SUMMARY

• Tableau Certified professional over 7 years of IT experience working as Power BI and Data Visualization Developer along with four years of experience in Data Visualization development using Tableau Desktop versions 7.x/8.x/9.x/10.x, Tableau Reader, Tableau Public and Tableau Server to create innovative dashboards across Healthcare, Banking and Finance domains.
• Expertise in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects with Expertise inTableau 7, 8,9,10.
• Designed and developed various analytical reports from multiple data sources by Data Blending on a single worksheet in Tableau Desktop.
• Developed KPI’s and dashboards based on reports, spreadsheets, charts and Pleasant experience in Migration of Reports & Packages to the higher versions of Tableau.
• Created attractive visuals/dashboards to convey the story inside the data using Tableau Desktop versions 7/8.2,9 and 10.2, Tableau Reader and Tableau Server.
• Expert level capability in Table calculations and applying complex, compound calculations to large, complex data sets and built dashboards using techniques for guided analytics, interactive dashboard design and visual best practices.
• Proficient in performing administration tasks such as publishing workbooks, setting permissions, managing ownerships, providing access to the users and scheduled instances for reports in Tableau Server along with trouble shooting of performance issues which were associated with Tableau reports.
• Expert in designing reports using SSRS, Power BI and Excel Power Pivot table connecting to OLAP cubes. Adept in creating ad - hoc, drill-down, sub-Report, parameterized, cascading parameterized, drill-through, chart, tabular, matrix reports.
• Expert in developing business architecture using requirements such as scope, processes, alternatives, and risks.
• Analyze client’s business requirements and processes through document analysis, interviews, workshops, and workflow analysis.
• Experience in working in V2V team to create variety of value reports and Highly proficient in writing complex SQL Queries, Stored Procedures and User Defined Functions to implement the business logic.
• Performed in Migration of Reports & Packages from Cognos to Tableau successfully.
• Good understanding on statistical and data analysis languages like R and Python.
• Experienced in creating Reports using Enterprise BI tools in designing stylish report layout parameterized, performance, Chart Reports, ad-hoc reports.
• Experience on Data warehousing concepts including data modeling such as snowflake schema, star schema, facts and dimensions, data marts and ER Modeling.
• Expert on ETL process to Extract, Transform and Load the data by creating SSIS packages into stage area and data warehouse.
• Good interaction with clients, understanding Business Applications, Business Data Flow and Data Relations.
• Expertise in Full Life Cycle Development of Reporting Projects, which includes Requirements gathering/analysis, Design, Development, Testing and Production rollover.
• Created data extracts with Java Script API’s.
• Created TDE's using Hadoop as the data source and using Hive and Impala connectors.
• Improved the Performance of data extracts created from Hadoop using contexts and Action filters instead of quick filters
• Experience in working with both Agile and Waterfall methodologies with good understanding of technical trends, architectures and highly motivated to know more about latest technology, new software and products.

TECHNICAL SKILLS

DW Technologies: Microsoft Business Intelligence (MS-BI), Tableau Desktop 7.x/8.x/9.x/10.x

Databases: SQL Server 2016-2005, MS Access, Teradata

Programming: T- SQL, C#.Net, VB.Net, C, C++

Operating System: Windows 2012 R2/2008 Advanced Server, Linux

RDBMS: MS SQL Server 2012/2008 R2/2008/2005/2000, SQL Azure, MySQL

ETL Tools: SQL Server Integration Services (SSIS), Informatica

OLAP Tools: SQL Server Analysis Services (SSAS)

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reports, Jasper Report, Cognos BIPower BI, Business Objects

Other Tools: MS SQL Profiler, SQL Query Analyzer, Erwin Data ModelerMS Visio, Map Force, SQL Server Agent, Drupal

PROFESSIONAL EXPERIENCE

Sr. BI Developer

Confidential, TX

Responsibilities:

• Involved in gathering the healthcare business user requirements, analyze the data and transformed them into interactive dashboards using Tableau Desktop.
• Evaluated risks related to requirements implementation, testing processes, project communications.
• Created connections to Hadoop Hive and work with data/time data as well as test the connection Hadoop cluster.
• Responsible in enhancing the existing dashboards, creating healthcare reports such as correlation between drug usage on age profile of residents using Tableau desktop and published that reports on to Tableau server.
• Used Quick filters, Data Source filters, Global filters, Context filters to restrict the healthcare data and use only the required meaningful data and used Parameters, Calculated fields and sets to handle views more efficiently on Tableau Reports.
• Performed migration of Tableau 9 to Tableau 10.2 in all the environments like SIT/UAT and PROD and tested the data.
• Effectively used data blending in case of merging two different healthcare datasets. Extracted data from various data sources such as Oracle, Microsoft SQL Server, other ODBC and MS Excel to generate various dashboards.
• Identify new metrics and enhance the existing KPI's which will improve the quality of the visualization and helps to take affective decisions in the healthcare.
• Applied Actions in Worksheets and Dashboards (Filters, Highlight, and URL) for interactivity and to compare data against different views.
• Utilized Tableau Visualizations like Dual Axis, Donut Charts and produced powerful dashboards telling story behind the data in an effortless way to understand the format such as pie, bar, geo and line charts.
• Analyzed SQL queries and edited inner, left and right joins inTableauDesktopby connecting to live and extract healthcare datasets.
• Ability to use Custom SQL for complex data pulls, and replicated those Custom SQL query joins onto Tableau to connect to various data sources.
• Knowledge on Teradata physical design and optimization of Teradata SQL query banding.
• Responsible in converting the charts into Crosstabs for further underlying data analysis inMSExcel.
• Combined views and reports into interactive dashboards inTableauDesktop that were presented to Business Users, Program Managers, and End Users.
• Administered user, user groups, and scheduled instances for reports inTableau.
• Used ETL process to Extract, Transform and Load the healthcare data into stage area and data warehouse.
• Involved in testing the SQL Scripts for report development,Tableaureports, Dashboards, Scorecards and handled the performance issues effectively.
• Created line charts to show number of completed Health Assessment people for each client in a breakdown of weekly, quarterly and yearly parameter numbers.
• Tested and executed the required queries and reports before publishing dashboards.
• Responsible for creating /delivering monthly reports to business users.

Environment: Oracle 11g, R 3.1.3, Tableau Desktop and server 8.x/9.x/10.x, Toad, MS SQL Server 2012, Teradata, PL/SQL, T-SQL, TFS, Windows Server 2012, MS Access, MS Office 2007 Microsoft SQL Server, JIRA V6.0.2, Hadoop

Senior BI Developer

Confidential, NC

Responsibilities:

• Develop, organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Converted business requirements into story-telling VIZ by developing views and dashboards in Tableau Desktop publishing to the Tableau Server allowing end-users to control and filter data.
• Created ad-hoc reports in Tableau connecting various data sources such as Teradata, Oracle, MS Excel and other files. Provided reporting solutions for OLTP and OLAP systems.
• Expert in preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies inTableau.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle, SQL Server and MS Excel.
• Generated context filters and used performance actions while handling huge volume of data.
• Generated tableau dashboards for sales with forecast and reference lines using parameters, sets, groups and calculations.
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database, analyzed data source to modify data types.
• Used Data Blending, groups, combine fields, calculated fields and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Worked on the sales analysis Dashboard using Tableau 9.x with complex drill down charts, pie charts, and stacked column charts etc.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Executed and tested required queries and reports before publishing dashboards.
• Involved in migration of SSRS reports to Tableau workbooks.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Created pie and bar charts and combining dashboards to demonstrate elevated risk areas.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Worked on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Hadoop and MS Excel.

Environment: Oracle 11g, Tableau Server, Tableau Desktop 8.x, Cognos, R 3.1.2, OBIEE11.1.1.6, Toad, SQL Server 2012, PL/SQL, T-SQL, SSIS, MS Access, TFS, Power BI

BI Developer

Confidential, NC

Responsibilities:

• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle, SQL Server and MS Excel.
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database, analyzed data source to modify data types.
• Performed unit testing, integration, user acceptance testing on the reports migrated and provided production support for the Deposits and Loans reports.
• Designed, Developed, debugged the reports and visualizations using Power BI, Power View, Power Query.
• Developed dashboards and appealing visualizations for derived data sets using Power BI.
• Published the reports within the organization with periodic data refresh.
• Performed datatype changes on a column and referential integrity relationships using DirectQuery option.
• Created users and assigned their role to view the reports and obtained security to the reports.
• Designed and developed reports with advance charts, graphs and Geo spatial maps which are innovative and interactive to the users.
• Designed, Developed, debugged account info with respect to branch manager Dashboards and Scorecards with focus on business KPIs in Power BI.
• Developed dashboard reports for daily changes on ACCINFOUSA database tables using Reporting Services, Report Model and ad-hoc reports using Report Builder.
• Created CA and NJ customer account status reports in SSRS and Power BI with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters for customized and ad-hoc Queries.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Created pie and bar charts and combining dashboards to demonstrate elevated risk areas.
• Used advanced SQL scripts and aggregation functions and advanced charts like tree map and bubble chart for applications.

Environment: Oracle 11g, Cognos, R 3.1.2, OBIEE11.1.1.6, Toad, SQL Server 2012, PL/SQL, T-SQL, SSIS, MS Access, TFS, Power BI

SQL/SSIS/SSRS with Power BI Developer

Confidential Company, IL

Responsibilities:

• Analyzed the requirements and selected the appropriate fact tables/created fact tables.
• Selected the dimensions required based on the analysis requirements, created the new dimensions, Shared dimensions and time dimensions.
• Involved in discussing Requirement Clarifications with multiple technical and Business teams.
• Designed Schemas using facts, dimensions, physical/logical, alias and Extension tables in OBIEE 11g Administrator tool.
• Writing SSISpackages for loading the data from heterogeneous database & different files format (Text File, Spread Sheet) to SQL Server.
• Developed and maintained enterprise reporting (Power BI) based on specifications and business needs and modified existing reports as needed.
• Created Reports usingPower BI 2008 for ad-hoc Queries.
• Developed /modified SQL stored procedures, functions, triggers based on technical and functional specification documents.
• Created OLAP cubes using SSAS and created reports from the OLAP cubes using Power BI.
• Involved in uploading of the data from flat files into Databases and validated the data with SQL stored procedures.
• Actively involved in Normalization & De-normalization of database.
• Materialized views, dimensions and stored outlines for optimal performance.
• Developed complex queries on Data Warehousing and developed SQL procedures to give in nice strategic plans to higher level of management.
• Used Dynamic SQL programming technique to build and process SQL statements at run time.

Environment: Tableau Desktop and Server, SQL Server 2008, Oracle 9i, SQL BI Suite (SSIS, SSRS, SSAS), Enterprise Manager, Crystal Reports, Erwin, XML, MS PowerPoint