Uploaded File
add photo
Manohar
manohar.gompa@gmail.com
312-694-5480
3001 South King Drive
Apt 901
Chicago, IL 60616
BI Developer
9 years experience W2
0
Recommendations
Average rating
269
Profile views
Summary

  • Around 3 Years of professional experience in the field of IT, Business Intelligence, Project Management, Business/Data Analytics, Data Visualization, Data Integration and Data Modeling.
  • Hands on Experience in working with Tableau Desktop and Tableau Server in various versions of Tableau 9.x/8.x.
  • Using multiple data sources like Oracle, Access, SQL Server, Excel etc., to develop the dashboards and to combine multiple data sources in a single view.
  • Developed web interfaces using HTML, CSS and JavaScript
  • Cleaned MS Excel data to load in to MySQL database
  • Proficient in writing queries using Structured Query Language for backend application development.
  • Developed complex SQL queries to fetch data from SQL Server for various internal projects.
  • Experience in creating dashboards in line with the analytical uniformity using the Advanced Analysis of
  • Tableau Desktop and organizing Dashboard views and Objects.
  • Experienced in designing customized interactive dashboards in Tableau using Marks, Action, filters,
  • parameter, calculations and Relationships.
  • Used Tableau Desktop for creating different interactive views and reporting Dashboards by combining
  • multiple views.
  • Have good knowledge in working with all phases of SDLC.
  • Developed ER Diagrams to design RDBMS.
  • Have ability to work independently and also can work with a team.
  • Experience working with web markup and scripting languages (HTML, XHTML, XML, CSS, JavaScript).
  • Good team player and a strong believer in teamwork and performance.
  • Very quick learner, have ability to learn new technologies based on the requirement.
  • Excellent analytical, interpersonal and communication skills.

Web Development: HTML, JavaScript, JQuery, CSS, XML

Data Analytics : Excel macros, R Scripting

Database Management: SQL Server, Oracle

Tools: Visual Studio, Eclipse IDE, Tableau, SAS, R Studio, Rational Rose, MS Visio, C, Java, C#, .NET SQL, PL/SQL, Shell Scripting, Microsoft Access, MySQL, SQL Developer, SQL

Experience
BI Developer
Information Technology
Aug 2015 - May 2016
  • Involved in BI tools, including report creation, query writing and building front end BI applications according to specifications.
  • Created dashboards in line with the analytical uniformity using the Advanced Analysis.
  • Designed customized interactive dashboards in Tableau using Marks, Action, filters, parameter, calculations and Relationships.
  • Created different interactive views and reporting Dashboards by combining multiple views using Tableau Desktop.
  • Worked on ETL tool Alteryx for blending and analyzing all data to deploy.
  • Used multiple data sources like Oracle, Access, SQL Server, Excel etc., to develop the dashboards and to combine multiple data sources in a single view.
  • Designed complex SQL queries to fetch data from SQL Server for various internal projects.
BI Developer Tableau Desktop Tableau Oracle SQL SQL Server Analysis ETL Data Analysis MS Access
Remove Skill
IT Graduate Student
Information Technology
Aug 2014 - Dec 2015

IT PROJECTS

Databases:

Created a Movie Production database using Oracle 12c by designing the Database Schema and Entity Relationship Diagrams. Queried the Database using the concepts of Joins and Sub Queries. Created Stored Procedures, Triggers, and Packages in PL/SQL and used Cursors to join tables without using Joins.

Created a Web Form in Microsoft Visual Studio in which we established connections to SQL Server and Oracle 11G. Upon clicking, data would be retrieved from the respective databases and displayed in the form of data grid view.

Data Analytics:

Cleaned the crude data and loaded into R Studio to make an analysis of the statistics of a large baseball Tournament. Used 3-Dimensional Bar Graphs, Pie Charts to depict a pictorial representation in R. Based on current statistics, created a planner for the tournament which would be held next year by using a Google Prediction API.

Java:

Created an IT help desk e­-ticketing system which dealt with raising new tickets, updating, closing, purging, and re­opening ticket operations by designing a Graphical User Interface.

Visual Studio Triggers Stored Procedure SQL Server SQL PL/SQL Oracle Java Analytics Analysis R Code
Remove Skill
SQL Developer
Information Technology
Jun 2012 - Jul 2014
  • Developed web interfaces using HTML, CSS and JavaScript.
  • Cleaned MS Excel data to load in to MySQL database.
  • Developed ER Diagrams to design RDBMS.
  • Effectively used SQL Server database to create data and information for all employees.
  • Created and supported website (Human Resources application for SHELL) using SQL Server database for SHELL account.
  • Demonstrated code in .NET using Visual Studio and connected to the database using SQL programming for SHELL.
  • Performed Web UI development using HTML, CSS.
  • Designed a website for US Bank customer online banking using MVC and ASP.NET.
  • Participated in the daily stand up SCRUM spry gatherings as a major aspect of AGILE procedure for reporting the normal advancements of the work done.
.NET HTML CSS MySQL ASP.NET Scrum SQL SQL Server Visual Studio UI MVC Microsoft Excel Agile Methodology JavaScript SQL Developer Database Design
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Master's in Information Technology and Management
Illinois Institute of Technology 2016
Certifications
Wipro Developer Certification SQL and ASP.NET
Skills
SQL
2016
3
SQL Server
2016
3
Visual Studio
2015
3
.NET
2014
2
Agile Methodology
2014
2
ASP.NET
2014
2
CSS
2014
2
Database Design
2014
2
HTML
2014
2
JavaScript
2014
2
Microsoft Excel
2014
2
MVC
2014
2
MySQL
2014
2
Scrum
2014
2
SQL Developer
2014
2
UI
2014
2
Analysis
2016
1
Analytics
2015
1
Java
2015
1
Oracle
2016
1
PL/SQL
2015
1
R Code
2015
1
Stored Procedure
2015
1
Triggers
2015
1
Application Development
0
1
BI Developer
2016
1
Business Intelligence
0
1
C#
0
1
Data Analysis
2016
1
Data Integration
0
1
Data Visualization
0
1
Eclipse
0
1
ETL
2016
1
jQuery
0
1
MS Access
2016
1
Project Management
0
1
RDBMS
0
1
SDLC
0
1
Shell Scripts
0
1
Tableau
2016
1
Tableau Desktop
2016
1
Tableau Server
0
1
XML
0
1