SUMMARY

• A motivated and proactive individual with a wide range of IT knowledge and expertise gathered over the span of 7+ years in fields such as healthcare, Financial, and Banking domain. Able to learn unfamiliar material and techniques quickly, exhibit great attention to detail, execute under aggressive deadlines, and adapt quickly to changing circumstances and systems to maintain strategic vision of the organization and link it with everyday work. Very passionate about projects and able to carry out tasks that are time sensitive in an efficient manner to guarantee the growth and success of the organization. A wonderful team player who values collaboration and communication, eager and possesses a very strong work ethic and can relate and work efficiently with diverse groups.
• 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, SAS, Microstrategy and PowerBI.
• Experience in Data Munging (data scrubbing and cleansing).
• 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.
• Great understanding of SDLC methodologies such as Waterfall and Agile (specifically SCRUM).
• Frequent update and exposure to new technologies and new business lines.
• Good 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, PROC ANOVA, PROC MEANS, PROC TTEST, PROC FREQ, PROC UNIVARIATE, and PROC LOGISTIC.
• Used SAS to import and export data from and into Teradata tables.
• Excellent knowledge of Teradata DWH platform including architecture.
• Hands on experience in SAS programming for extracting data from Flat files, Excel spreadsheets and external RDBMS (ORACLE) tables using LIBNAME and SQL PASSTHRU facility.
• Experience in working with SAS ENTERPRISE GUIDE SOFTWARE for reporting and analytical tasks.
• Strong ability to write SQL queries using PROC SQL.
• 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.

TECHNICAL SKILLS

OPERATING SYSTEMS: Win XP, Vista, 7, Windows Server 2003, 2008(X32, X64)

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 Plus, SQL Developer, Teradata-BTEQ, PL/SQL

QUERYING LANGUAGE: SQL, PL/SQL, TSQL

BUSINESS INTELLIGENCE TOOLS: Tableau 9.1, 9.2, 9.3, 10.4, Microstrategy, Excel and PowerPivot, PowerBI, Cognos and PowerPivot, SSRS

PROFESSIONAL EXPERIENCE

Confidential, Mars, PA.

Business Intelligence Analyst

Responsibilities:

• Identify and document limitations in data quality that jeopardize the ability of internal and external data analysts
• Creating complex SQL queries and scripts to extract and aggregate data to validate the accuracy of the data
• Performing daily integration and ETL tasks by extracting, transforming and loading data to and from different RDBMS
• Utilize SSIS for ETL data modeling, data migration, and analysis
• Business requirement gathering and translating them into clear and concise specifications and queries
• Prepare high level analysis reports with Excel and Tableau
• Provides feedback on the quality of data including identification of billing patterns and outliers
• Analyze and Assess invalid and missing data in the All Payer Claims Data
• Used SAS to mine, alter, manage and retrieve data from a variety of sources and perform statistical analysis
• Documenting the extent to which data fails to meet threshold reporting requirements
• Created T/SQL statements (select, insert, update, delete) and stored procedures.
• Data governance and defining processes concerning how data is stored, archived, backed up, and protected from mishaps, theft or attack.

Confidential, Fairless Hills, PA

Tableau Developer, Data Analyst

Responsibilities:

• Created Views and Database Triggers, Stored Procedures and Functions using SQL such that information entered by a certain WM can make appropriate changes to the respective tables.
• Wrote complex SQL queries using advanced SQL concepts like Aggregate functions
• Performed ad-hoc reporting analysis as well as manipulate complex data on MS SQL server.
• Wrote complex SQL queries to retrieve data from disparate tables utilizing Joins, Sub-queries and also used concepts like Explain, Stats, Cast and volatile tables on SQL server
• Involved in extensive data validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Analysed duplicate data or errors in data to provide appropriate inter-departmental communication and monthly reports.
• Experienced in Data mapping, Data transformation between sources to target data models.
• Analysed reporting requirements and develop various Dashboards.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
• Experience in creating various views in Tableau (Tree maps, Heat Maps, Scatter plot).
• Experience in creating Filters, quick filters, table calculations, calculated measures and parameters.
• Responsible for developing, analysing and reporting key risk indicator and key performance indicator metrics that enable management to make timely and effective decisions related to threats, risks and control requirements.
• Strong ability in developing SQL queries to extract, manipulate, and/or calculate information to fulfil data and reporting requirements including identifying the tables and columns from which data is extracted.
• Used statistical techniques such as regression, cluster analysis, factor analysis, time series forecasting, experimental and design, etc. to solve business problems.
• Used SAS to solve problems with data and analytics.
• Reviewed coding done to SAS and Python application upgrades and extensions.

Confidential, Pittsburgh PA

Data Analyst / Tableau Developer

Responsibilities

• Supported the company’s healthcare software functions, implementation and training.
• Make business recommendations based on data collected to improve business efficiency.
• Collected data from all clients and made recommendations for improvement.
• Ad-hoc data extraction through queries in SQL Server 2008, Excel, SAS, Tableau report or PDF.
• Supported business lead for special assignment and to ensure production efficiency.
• Data analysis, reporting using Tableau and SAS.
• Use data visualization tools to provide an easy to understand interface for end users to quickly identify key themes within their Data
• Designing the Reports as per client Requirement and created the reports using Excel file, SQL Server and Oracle databases.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, heat maps, bullet charts, Gantt charts demonstrating key information for decision making.
• Utilize SAS, and other software, to provide ad hoc reporting, tables and listings and graphs for clinical trials data, regulatory submissions, Risk Based Monitoring, and publications
• Developed and produced peer quality metric performance: validated data and processes to ensure accuracy, completeness, and consistency of data using SAS.
• Created, organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Created demos in Tableau Desktop and published onto Tableau Server.
• Worked on motion chart, Bubble chart, drill down analysis using tableau desktop.
• Deployed Tableau Dashboards and worksheets in clustered environment.
• Documented a whole process of working with Tableau Desktop and evaluating Business Requirements.
• Interacted on a day to day basis with several different groups to achieve a common deliverable.

Confidential, Knoxville, TN3

Data/Business Analyst/Tableau Developer

Responsibilities

• Used SAS to import and export data from and into SQL Server tables.
• Used Pivot tables to create reports that did dicing and slicing functions on data. This is called dimensional analysis and gives business a 360 view of what is going on.
• Wrote queries to fetch data from different table 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.
• Wrote complex SQL queries using advanced SQL concepts like aggregate functions, Group By and OLAP (Online Analytical Functions).
• Developed and implemented strategies to handle errors by the ETL teams
• Extract data from flat files, Oracle, DB2, and SQL Server 2014, and to load the data into the target database.
• Developed automated tool for updating and running quality checks on ERWIN data models
• Created Logical and Physical Models using ERWIN
• Created numerous permanent tables, local and Global Temporary tables.
• Developed leading routines and data extracts with Informatica and SAS and SQL procedures