SUMMARY:

• Around 9 years of diversified IT experience in Design, Analysis and Development in the fields of Business Intelligence and Data Warehousing, Migration and Reporting projects.
• Wide - ranging experience in developing statistical and predictive models using Tableau 7.0/8.0/9.0/10.0 .
• Strong understanding of project life cycle and SDLC methodologies including Agile and Waterfall models.
• Expertise in designing and creating analytical reports and Dashboards to help users to identify Critical KPIs and facilitate strategic planning in the organization.
• Mastered the ability to design and deploy Rich, Thoughtful visualization & Visual Analytics using Tableau and good at writing complex LOD Calculations.
• Worked extensively with Advance Analysis Actions, Calculations, Level of Detail expressions, Parameters, Filters, Background images, Maps, Trend Lines, Statistics, Groups, Hierarchies, Sets, Bins etc. to create detail level summary reports and dashboards.
• Highly Proficient in design and development of complex and innovative dashboards, Expert in Tableau Data Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of Actions according to the end user requirement.
• Excellent ability in requirements gathering, Writing specifications, Implementation, User support and maintenance.
• Experience on working with multiple databases like Microsoft SQL Server, Oracle, Teradata, Impala and Hive and data warehouses like Amazon Redshift and Oracle Exadata.
• Project experience in dimensional data modeling (star/snowflake), Strong SQL optimization capabilities, Metadata Management (Connections, Data Model, VizQL Model).
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions, Relational Database models and Data integrity, and SQL joins.
• Hands on experience in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power BI and PowerPivot.
• Experience in whole cycle of SQL Server Integration Services (SSIS 2005/2008/2012 ) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
• Created Master/Detail reports, Parameterized reports, TAT reports and Cross tab reports using SSRS and maintained securities, roles, subscriptions in SSRS Report Manager.
• Experience in configuring reports from different data sources using data blending and Joins.
• Extensive experience in complex Troubleshooting, Performance Tuning of reports and resolving issues with in Tableau server.
• Ability to quickly adapt to new technologies and different project environments.
• An excellent team member with Interpersonal, Communication and Presentation Skills along with Time Management.

TECHNICAL SKILLS:

Languages: C, C++, T-SQL, PL/SQL, XML, HTML.

Operating Systems: Windows 7/8/10, UNIX, MAC OS X

Database: Cloudera Hadoop (Hive, Impala), Sybase, Oracle 10g/11g, MS Access, MS SQL Server 2008/2008R2/2012/2014, Amazon Redshift, Postgre SQL, TERADATA.

BI Tools: Tableau 7.0/8.0/9.0/10.0, SSIS, SSRS, Alteryx, Crystal Reports, Talend, Power BI, Power pivot.

SDLC Tools: Team foundation Server(TFS), Preforce, JAMA, MS Office Suite, MS Share Point, JIRAHP Quality Centre, Spira, Service Now.

PROFESSIONAL EXPERIENCE:

Confidential, Lees Summit, MO

Sr. Tableau Developer

Responsibilities:

• Worked with business users for requirement gathering ( Confidential ), business analysis, and translated the business requirements into technical specifications to build the Enterprise data warehouse.
• Delivered on time reports and Tasks on every sprint and Completed Weekly, monthly and Quarterly Milestones.
• Developed Meaningful Use (MU) early-warning dashboard for Eligible Hospitals with drill-down capability to identify hospital compliance with federal regulation. Cerner adopted my dashboard structure and design and incorporated it into their Stage 3 reporting. (Tableau, SQL, Alteryx).
• Presented my MU early-warning system at the 2017 Healthcare Data and Analytics (HDAA) conference.
• Integrated Tableau with Alteryx to extract patient cohort data for Care Process Modeling project.
• Created action filters, parameters, aggregated bins and calculated sets for preparing dashboards and worksheets in Tableau.
• Developed Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Created solution driven dashboards by developing different chart types including Crosstab's, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.
• Developed metrics, attributes, filters, reports, dashboards and also created advanced chart types, visualizations and complex calculations to manipulate the data.
• Developed actions, parameters, Filter (Local, Global) and calculated sets, data bins for preparing dashboards and worksheets using Tableau.
• Generated context filters and used performance actions while handling huge volume of data.
• Used multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Created Data extracts for better performance and accessing data offline.
• Automated the process of extracting the PDF or image from tableau server and sending it to users using PowerShell and Tabcmd.
• Created a PowerShell script with integration of Tabcmd to generate the PPT automatically by extracting the images from server with single click.
• Created my own script to lower the version of Tableau workbook.
• Integrated Tableau report using iframe technique in Salesforce CRM.
• Implemented Data blending with multiple data sources on a single worksheet for data analysis.
• Development of Key Performance Indicators (KPI) dashboards that provides internal employee productivity of specific period.
• Working with Level of Details expressions and Regular Expressions which are helpful in providing ETL functionality for tableau.
• Design interactive dashboards in Tableau Desktop and published them to Tableau Server.
• Reviewed existing dashboards to identify bottlenecks and redesigned process to increase the performance and reduced total time frame.
• Created Indexes and Views using SQL to enhance the performance of the reports.
• Created Test Cases to ensure data was matching as per the business requirements and documented the Test Results.

Environment: Tableau desktop 10.4, Tableau Server, Alteryx, Azure, Oracle 11g, FACETS, Salesforce, AWS, MongoDB, Tortoise SVN.

Confidential, Owatonna, MN.

Tableau Developer

Responsibilities:

• Created Reports Specification Document and Data mapping for reports development.
• Extensively worked on Informatica Power Centre 9.6 for Extraction, Transformation and Loading of data from various sources into the target database
• Worked on complex mappings with transformations including connected/un connected lookup, Joiner, SQL, filter, router, Source Qualifier, expression, aggregator and normalizer transformations.
• Extensively used Informatica debugger to figure out the problems in the mapping. Also involved in troubleshooting existing ETL bugs.
• Designed and developed Informatica Mappings to load data from various Source systems like Files, Relational into the ODS (operational data store), DW and then to the Data Mart.
• Creating users, groups, projects, Data connections, settings as a tableau administrator.
• 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.
• 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.
• 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, Informatica 9.1/9.6, JavaScript API, Infromatica, Netezza, Oracle11g R12, OBIEE, Toad, Hadoop Horton works, Cloudera, Unix, Windows 7.

Confidential, Columbus, OH.

Tableau/SQL SSIS SSRS Developer

Responsibilities:

• Created dashboards according to user specifications and prepared stories to provide an understandable visions.
• Involved in gathering user requirements and in the Design Team.
• Created and published Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
• Participated in building and visualizing dashboards using Tableau Desktop.
• Used Tableau visualization software to generate Tableau combination dashboards.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Blended data from multiple databases into one report by selecting primary key’s from each database for data validation.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/ dynamic and static datasets.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Created Database Objects - Tables, Indexes, Views, Cte’s, Triggers, Complex Stored Procedures and User defined functions according to the requirements of the project.
• Performed Database Normalization to avoid data redundancies.
• Involved in performance tuning of TSQL queries and Stored Procedures by using SQL Profiler and optimized the queries by creating clustered, non-Clustered indexes and indexed views.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
• Worked on different kinds of Transformations in SSIS like Slowly changing dimension (SCD’s), Lookup, Merge, Derived column, Multicast, Conditional split, Aggregate, Fuzzy lookup, Pivot and Un Pivot as per the client requirement.
• Created checkpoints and configuration files in SSIS packages, experienced in slowly changing dimension in SSIS packages. Implemented error logging using event handlers.
• Scheduled the SSIS packages to run as jobs on periodic basis according to the requirement using SQL Server Agent.
• Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
• Developed several detail and summary reports, sub-reports, drill down, drill through, linked, TAT reports according to business requirements using SQL Server Reporting Services (SSRS) and PowerPivot.
• Generated reports using SSRS expressions, Cascading parameters and automated the execution of SSRS reports using subscriptions and command center batch interface.
• Created spreadsheets using Power BI and Power Pivot by importing data from the sources directly.
• Participated in meetings, reviews and user group discussions as well as communicating with different business groups.

Environment: Tableau Desktop 7.0/8.0, Tableau Server, SQL Server 2008/2008R2/2012, SSIS, SSRS, MS Excel, PowerPivot, SQL Profiler, Query Analyzer, MS Access, TERADATA.

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.