SUMMARY:

• Over 8+ years of experience in Designing, Developing, Administering, Supporting Tableau and Business Intelligence applications.
• Extensive experience in BI and Tableau connecting multiple databases like SQL Server, Oracle etc.
• Experience and technical knowledge of Hadoop and other related Big Data Technologies (Cloudera, Hortonworks etc.)
• Participated in the Agile planning for Team Foundation Server to make sure that our team sprints satisfied backlogs.
• Exposed to assignments in various domains like Retail, Healthcare, Banking and Telecom.
• Thorough understanding of Software Development Life Cycle (SDLC), involved in various phases like Requirements, Analysis/Design, Development and Testing
• Strong knowledge of Dimensional Modeling like Star Schema and Snow Flake Schema to fit Query, Reporting, and Analysis requirements
• Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source, Filters, Actions, Functions, Trends, Hierarchies, Sets, Groups, Calculations, Data Blending and Maps etc.
• Experience in Production and Technical Support activities and managing production rollouts
• Identifying and removing bottlenecks in order to improve the performance of dashboards and reports.
• Experience troubleshooting ETL jobs, bug fixing and addressing production issues like performance tuning and enhancements
• Worked on implementing Modern Analytics toolkit using Amazon Redshift and Tableau Software which form a Data warehousing and analytics solution that allows users to analyze datasets.
• Experience in writing complex SQL queries to perform End - to-End ETL validations and support Ad-hoc business requests.

TECHNICAL SKILLS:

BI Tools: Tableau 10.x/9.x/8.x/6.x, Oracle Business Intelligence Enterprise Editions, SSRS

Languages: SQL, HTML.

Databases: SQL Server 2000/2005/2008/2012/2014, MS Access, Oracle

Operating Systems: WINDOWS 95/98/2000/NT/XP, 7, 8, 10

Dimensional Modeling: Star Schema Modeling, Snow Flake Modeling, Fact and Dimensions Tables

Application Software: MS Word, MS Excel, MS Access, MS Power Point.

ETL Tools: MSBI, SSIS

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

Sr. Tableau Developer

Responsibilities:

• Created and analyzed reporting within Tableau based on the business requirement.
• Designing and developing Supply Chain data models by integrating data from multiple sources
• Developing Inventory Control dashboards using Tableau to analyze vendor defects
• Writing SQL queries solved many critical requirements by digging the required data.
• Developing Tableau interactive dashboards to monitor KPIs related to Overages, Shortages and Damages etc.
• Extensively used advance chart visualizations in Tableau like Dual Axis, Bar chart, Pareto Chart, Heat Maps, Tree maps etc., to assist business users in solving complex problems.
• Created complex formulas and calculations within Tableau to meet the needs of complex business logic
• Created and assisted users in Tableau dashboard development.
• Defined best practices for Tableau report development and effectively used data blending feature in tableau.
• Support ad-hoc requests; perform deep-dive analysis to identify areas of concern and debugging of data inaccuracies.
• Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server.
• Utilized Tableau visual analytics and best practices like Dashboard structure, view orientation, Sizing and Layout, Data Emphasis, Highlighting, Color, Fonts, Tooltips, and performance improvement of complex dashboards/reports
• Strong SQL skills including use of nested expressions, unions, multi-table joins.
• Involved in testing the Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.

Environment: Tableau 10.5/9.1, SQL Server.

Confidential, Weston, FL

Tableau Developer

Responsibilities:

• Created Reports Specification Document and Data mapping for reports development.
• Generated Test Cases for each report specification corresponding to each module.
• Created adhoc reports to users in Tableau by connecting various data sources.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Connected Tableau server with share-point portal and setup auto refresh feature.
• Maintained Test log and Wrote test Evaluation, Summary Reports.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps.
• Involved in creating dashboards and reports in Tableau and Maintaining server activities, user activity, and customized views on Server Analysis.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Generated context filters and used performance actions while handling huge volume of data.
• Generated tableau dashboards for sales with forecast and reference lines.
• Experience working with JavaScript API’s to integrate tableau reports to web applications as per the requirement.
• Generated tableau dashboards with combination charts for clear understanding.
• Worked on Motion chart and Drill down analysis.
• Developed Interactive (Dynamic) dashboards, Adhoc reports for users.
• Involved in the migration of OBIEE reports to Tableau.
• Creating data blending in case of merging two different datasets.
• Developed dashboards using various data sources such as Hartonworks Hadoop Hive and Cloudera Hadoop, Oracle, Netezza.
• Extensively developed custom SQL queries.
• Implemented AWS security features in Tableau server by providing AWS security features that Tableau Server can use to protect the environment, including Amazon Virtual Private Cloud, Security Groups, Aws identity and AWS Direct connect.
• Created many parameters, quick filters, sets and shapes for better navigation in Tableau dashboard.
• Improved reports performance in tableau using extracts and context filters.
• Scheduled Full/Incremental refreshes of dashboards depending on the business requirements for data sources on Tableau Server.

Environment: Tableau 8.0/9.0, JavaScript API, Netezza, Oracle11g R12, OBIEE, Toad, Hadoop Horton works, HiveQL, AWS, Cloudera, Windows 7

Confidential

Tableau Developer

Responsibilities:

• Involved in full project lifecycle of SDLC and coordinated with all project teams.
• Interacted with Subject Matter Experts& End Users to gather business requirements.
• Analyzed requirements for various reports, dashboards, and scorecards.
• Effectively used data blending feature in Tableau.
• Designed and developed a business intelligence dashboard using Tableau Desktop, allowing executive management to view past, current and forecast data.
• Mentored business power users to create reports/dashboards using tableau desktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Developed key indicators and the appropriate tracking reports with graphical and written summations to assist in the quality improvement initiatives.
• Involved in creating interactive, parameterized dashboards by extracting data from different sources using data blending and applying actions - filter, highlight and URL.
• Created dashboard from scratch that included drill-through, filters, Heat/Geo/Tree maps, Pie/Bar charts, Circle views, Line/Area charts, Scatter plots and Bullet graphs.
• Created prompts, customized calculations, conditions and filters (Local, Global) for various analytical reports and dashboards.
• Created and modified interactive dashboards and developed guided navigation links within interactive dashboards.
• Created Table of Contents (TOC), a common navigation page which had all the links to various reports and dashboards.
• Published the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Used SQL tools like Toad and Teradata SQL Assistant to run SQL queries and validate the data in the warehouse and data marts.

Environment: Tableau Desktop/ Server, MS Project Teradata, Teradata SQL Assistant, SQL, PL/SQL, SQL Developer, Informatica Power Center, SQL Server, Control-M.

Confidential

SQL Server Developer

Responsibilities:

• Actively involved in different stages of Project Life Cycle.
• Actively participated in gathering of User Requirement and System Specification.
• Created Stored procedures, Triggers, Views, and User Defined Functions to facilitate the automation of data entry by a front-end application.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS.
• Created many drill through, drill down, ad-hoc reports using SSRS.
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs and deployed into Report server and SharePoint.
• Involved in tuning of database by creating efficient stored procedures and T-SQL statements.
• Provided assistance to development teams on Tuning Data, Indexes and Queries.
• Created Clustered and Non-Clustered Indexes for improved performance.
• Optimized the existing queries to improve performance with the use of SQL Profiler and Execution Plans.
• Implemented Backup and Recovery of the databases.
• Actively participated in User Acceptance Testing and Debugging of the system.

Environment: SQL Server 2005/2008, SQL Server Integration Services, SQL Server Reporting Services, Visual Studio 2008, Excel, Performance Point, Data Analyzer, Windows XP.