SUMMARY

• Utilized business intelligence tools to include OLAP (Online Analytical processing), data warehousing, reporting, querying tools and excel.
• Experience in Data Analysis and ETL techniques for loading enormous amounts of data.
• Experience with DATA MINING.
• Identified issues when reports are created from several and complex data sources.
• Performed DATA MODELING, DATA MIGRATION, consolidate and harmonized data. Hands - on data modeling experience using Dimensional Data Modeling, Star Schema, Snow-Flake, Fact and Dimension Table, Physical and Logical Data Modeling using ERwin 3.x/4. x.
• Excellent knowledge and usage of statistical/mathematical analytics software like Stata, SPSS, SAS and Minitab.
• Knowledge of healthcare information systems, experience with Practice Management software and HIPAA Guidelines.
• Skilled in using SAS statistical procedures like PROC Report, PROC TABULATE, PROC CORR.
• Strong ability to write SQL queries using PROC SQL.
• Possess strong computer and office administration skills with a vast knowledge of Windows and Microsoft Office Suite (Word, Excel, PowerPoint, Access, and Visio).
• Excellent knowledge and usage of reporting tools such as Tableau and SAS.
• Experience in data scrubbing and cleansing.
• Possess a strong ability to adapt and learn new technologies and new business lines rapidly.
• Good knowledge of portfolio analysis, management and customer segmentation.
• Self-motivated individual with strong communication skills, great attention to details and the ability to work under pressure.
• Exceptional organizational and time management skills and the ability to work independently.
• Excellent team player with demonstrated experience of working diplomatically and collaboratively with all levels of staff to ensure successful implementation of assignments.

TECHNICAL SKILLS

Operating Systems: Windows, Mac

Databases: MS SQL Server 2005/2008/2012 , Teradata 12/13, MySQL 5.2, 5.7, Oracle 9i, 10g, 11g, DB2

ETL/Other Tools: Informatica Power Center 8.6.1/9, SAS Base 9.x, SAS Enterprise Guide, SSIS (Visual Studio), Erwin Data Modeler, ER Assistant

Querying Tools: SQL Management Studio 2008/2012, Teradata SQL Assistant, SQL Developer, Teradata-BTEQ, PL/SQL

Querying language: SQL, PL/SQL, TSQL

Business Intelligence Tools: Tableau 9.1, 9.2, 9.3, 10.4,2019.2, Excel and PowerBI

Programming language: SAS

PROFESSIONAL EXPERIENCE

Confidential

Health Statistical Analyst/Tableau Developer

Responsibilities:

• Created rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Wrote queries to gather data from different tables by using JOINs, sub-queries, correlated sub-queries and derived tables on SQL Server platform.
• Wrote SQL queries that were highly tuned using concepts like Explain, Stats, CAST and volatile tables and used SAS in importing and exporting data for SQL server tables.
• Developed dashboards in Tableau Desktop and published them in Tableau Server, ETL processes using Informatica PowerCenter, SQL and shell scripting to extract data from source systems, transform the data into the necessary format and load it into the data warehouse.
• Responsible for interaction with business stakeholders, gathering requirements and managing the delivery.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Created visualization for logistics calculation and department spending analysis.
• Generate KPI’s for customer satisfaction survey results.
• Support and develop ETL processes to support data warehouse and reporting requirements.
• Maintain test log and test evaluation summary reports.
• Developed data visualizations, pivot charts, and dashboards in Excel.
• Maintains departmental metrics in accordance with goal plan.
• Structured the dashboard with a consistent layout with visuals chart at the top and corresponding crosstab data and the bottom

Confidential

BI Developer - Tableau Developer

Responsibilities:

• Responsible for error handling, stored procedure, creating tables, views, triggers etc.
• Designed, developed, implemented, and maintained programs to load, aggregate, and extract data to meet a wide range of business and system requirements using SQL Server mainframe.
• Exercises positive interpersonal communication skills and worked with small team or independently on all phases of software development lifecycle.
• Worked with ETL Process which includes SSAS, SSIS, and SSRS. Worked with Business Intelligent tool like Tableau and Power BI on SQL server mainframe.
• Administered SQL Server including back up / recovery, creation of user, indexing (Cluster and Non-Cluster) for normalization. Created controls to preserve the integrity of the information being reported
• Developed stored procedures, views, triggers, execute test cases and defect management for ETL and BI systems
• Created DTS Packages for migration of data between MS SQL Server database and other databases like MS Access, and MS Excel.
• Used DTS to migrate the tables to the Data Warehouse. Handled Different DSS (Decision Support System) for various applications.
• Configured the Data mapping between Oracle and SQL Server.
• Wrote queries to fetch data from different table by using JOINs, Sub-queries, Correlated sub-queries and derived tables on Teradata platform.