SUMMARY

• Over 8 years of working experience as Tableau Developer, Data Modeler, Data & Business Analyst with high proficiency in Dashboard reporting, requirement gathering, data modeling including design and support of various applications in OLTP, Data Warehousing, OLAP and ETL Environment.
• Worked in a client - facing role to design and develop Tableau data models and dashboards to support client needs.
• Extensive experience in Data Analysis, Migration, Cleansing, Transformation, manipulation, chart creation, visual representation, Import and Export through various ETL tools.
• Utilized all Tableau tools including Tableau Desktop, Tableau Server, Tableau Reader, and Tableau Public.
• Handled Tableau admin activities like Installations, Configurations, creating user, user groups, granting access and managing extracts.
• Hands-on with creating solution driven dashboards by developing different chart types including Heat Maps, Geo Maps, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Line Charts, Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Build better dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
• Displayed visualizations from Tableau Server, Tableau Public, and Tableau Online in web pages using JavaScript API
• Well versed with the knowledge of Predictive Modelling techniques (Linear Regression, Logistic Regression)
• Worked on the development of Dashboard reports for the KPI for the top management.
• Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects.
• Good knowledge of Normalization, Collations, ETL, Data Modelling like Star Schema Modelling, Snow-Flake Modelling, FACT and Dimensions Tables using Analysis Services.
• In depth knowledge of SDLC, Agile methodology, HP ALM and QC.
• Experienced in Unit Testing, Regression Testing and User Acceptance Testing.
• Experience in guiding the team to accomplish the goals set by management and play a vital role in supporting the team from front and yet at the same time work under a supervisor.
• Excellent communication skills in both written and oral along with ability to tell a story through data.

TECHNICAL SKILLS

BI Tools: Tableau 7.0, 8.2, 9.0 and SSRS

Programming: SQL, PL-SQL, UNIX Shell, C, C++, VBA, VB, R, Python

ETL Tools: SSIS, Informatica

Defect management tool: HP ALM and QC

Databases: Teradata, Oracle, SQL Server, Access, MS Excel, PostgreSQL

Platforms: Windows, Mac OS, DOS, UNIX, Linux, Ubuntu

PROFESSIONAL EXPERIENCE

Confidential, Greeley, CO

Tableau Developer

Responsibilities:

• Involved in end to end implementation and enhancements starting from requirement gathering and dashboards development in Tableau Desktop.
• Created numerous dashboards in Tableau Desktop by importing and blending data from MS Excel and CSV files along with Oracle Databases.
• Performed Tableau Admin duties that comprised configuration, adding users, groups, managing licenses and data connections, scheduling tasks, embedding views in the Tableau Server.
• Worked on Predictive Analytics like linear/logistic regression using Tableau and R.
• Developed Geo/Area Maps to show details on which states are most sales vs. the least states.
• Created Bar Charts which is complied with data sets and added trend lines and forecasting on future usage of products.
• Created Crosstab’s to display underlying data based on various graphs and charts created for further data analysis.
• Created sheet selector to accommodate multiple chart types like Panel charts, Bullet charts and Stack bars etc. in a single dashboard by using parameters.
• Used calculated fields and Multiple Measures Extensively (like Individual Axes, Blended Axes, and Dual Axes.
• Used Sql Queries at the custom Sql level to pull the data in tableau desktop and validated the results in Tableau by running Sql queries in Sql developer.
• Complied interactive dashboards in Tableau Desktop and published them to Tableau Server which allowed story telling with Quick Filters for on demand needed information.
• Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop.
• Created and maintained issue log where business users enter their feedback by working on dashboard in test environment. Implemented the feedback and incorporated the necessary changes.
• Utilized the JavaScript API to create a customized portal for the sales management group
• Interacted with business users and performed Gap Analysis of Client requirements.
• Effectively interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change that have happened to ensure that the developed dashboards are displaying accurate and up-to-date live data and sent those into production after editing.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.
• Worked with Unit testing, Regression Testing, User acceptability testing.
• Supported end users in UAT, piloting and go-live
• Trained and mentor junior staff with latest functions of Tableau.
• Conducted workshops and training programs for the end users on the usage of the reports and tableau server and created support documents.

Confidential, Colorado, USA

Tableau Developer

Responsibilities:

• Involved in reviewing requirements and data sources form MS SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Used Tableau Desktop for blending databases and creating different interactive views and dashboards. Created extract files for improving the performance.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary reports and dashboards using KPI's
• Created complex reports like Detail level Transaction report's, monthly Aging, YTD cash goal Reports, Quarterly reports by creating multiple queries
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop.
• Created various types of charts to provide better visualization and created Interactive reporting dashboards by combining multiple views.
• Involved in troubleshooting and performance tuning of reports and resolving issues within Tableau Server and Reports.
• Creating users, groups, projects, Data connections, settings as a tableau administrator.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.
• Experienced with Unit testing, Regression Testing, and User acceptability testing.
• Worked on go-live phase and provided post live support, Coordinating and solving issues with QA and production.

Confidential, Washington

Data Analyst

Responsibilities:

• Prepared business requirement document, functional specification and technical specification documents. Documented all the procedures and processes for future references.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS. Analysed, designed, created and tested Reports as per user requirements using SSRS.
• Created packages in SSIS Designer using Control Flow Tasks and Data Flow Transformations to implement Business Rules.
• Worked with Tablix Properties and Filters Concepts.
• Transformed data from various data sources using OLE DB connection by creating various SSIS Packages.
• Worked on Cube Deployment, Processing, Creating cubes and aggregations on cubes.
• As per Client Requirements, developed the reports in the form of Table, Matrix and Chart and Rendering the Reports in the form of PDF, EXCEL and CSV to the Clients.
• Generated the Reports Weekly and Monthly basis as per the Client Requirements.

Confidential, New York, NY

Data Analyst

Responsibilities:

• Data mapping between the source and the destination and documentation of the data mapping spread sheet. Created SSRS reports and scheduled them to reach the customers on a weekly basis. Wrote SQL queries and stored procedures to generate data for reports.
• Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting. Tested and analysed relational and OLAP data. Enforced different business constrains and rules using triggers and check constraint.
• Responsible for the creation of reports/cubes using SQL Server 2005 Reporting Services (SSRS) and Analysis Services (SSAS). Created various reports using MS Reporting Services (SSRS). And deploy public reports in dynamic Web portal.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Used ETL process to Extract, Transform and Load the data into stage area and data warehouse.
• Generated Drill Through, Drill Down, and Ad hoc Reports. Created Cross-Tab and Sub-Report using RDL and promoted RDLs to Reporting Service Server. Scheduled the monthly/weekly/daily reports to run automatically.
• Generated reports that can handle dynamic grouping and dynamic sorting. Was involved in Debugging and then scheduling the reports to run automatically. Created monthly dashboard Reports for automatic changing of User Credentials.
• Provided technical support to internal developers and external clients. Set up database backup and recovery strategies.

Confidential, Atlanta, GA

SSRS Developer

Responsibilities:

• Continuous engagement with product team to understand the requirement and make the product reports more effective
• Worked with DBAs to design and implement Conceptual data model, Physical Data Model, SSIS mappings and workflows to meet business requirements
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Identified Facts, Dimensions, Levels / Hierarchies of Dimensional Modeling.
• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Found efficient ways to make tables and graphs which were visually easy to understand and at the same time maintaining the accuracy of the core information content.
• Attended daily standup meetings to update scrum master with what is achieved, what is being done and is there any impediment.
• Conducted user acceptance testing and mentored business users how to slice and dice data using filters and parameters.
• Published the developed dashboards into production and ensured the data was up to date.