SUMMARY

• Detailed - oriented professional with 5+ years of IT experience in the Healthcare, Financial, Government and Banking domain.
• Very passionate about projects and savvy with business requirements; translate them into clear and concise specifications; as well as extract and manipulate data from RDBMS in order to make cutting-edge and prudent decisions to improve the outlook of the organization.
• Always ready to unleash the skills and knowledge acquired over the years for the development and progress of the organization.
• 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 and Minitab.
• 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.
• Experience in data scrubbing and cleansing.
• Great understanding of SDLC methodologies such as Waterfall and Agile (specifically SCRUM).
• 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: Win XP, Vista, 7, Windows Server 2003, 2008(X32, X64), Unix, SAP, Oracle Financial

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

Test Tools: HP Quick Test Professional 10/11, HP Quality Center 10

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, Cognos, Excel and PowerPivot, SSRS

Programming language: SAS, use of automated scripts, ACL, NESSUS and Team Mate, Audit Management System, Audit Command Language (ACL) and MS Visio

PROFESSIONAL EXPERIENCE

Confidential

Data Analyst

Responsibilities:

• 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 SQL Server databases
• Utilize SISS for ETL data modeling, data migration, and analysis
• 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
• Identify and document limitations in data quality that jeopardize the ability of internal and external data analysts
• Created rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• 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.
• Maintain test log and test evaluation summary reports.

Confidential

Data Analyst

Responsibilities:

• Responsible for extracting data from multiple systems and databases including SQL Server and Oracle to bring it into a centralized system.
• Created and populated patient data using advanced SQL and TSQL queries and scripts Worked on analysis of the Facets claims processing application to gather requirements to comply with HIPAA 5010
• Prepare high level analysis reports with Excel and Tableau
• Analyze patients’ dataset using R Studio to provide strategic direction to the company
• Performed association rules and apriori analysis in R using packages such as arules and arulesViz
• Clustered patients’ dataset using R to group the patients based on hospital admissions data for prediction of readmission of patients within 30 days of initial admission
• Presented a summary report of analysis in R to stakeholders
• Did PowerPoint presentations on a number of analysis deliverables to stakeholders
• Performed a number of data preprocessing in R using functions and modules such as str, summary, is.na, na.rm, discretize, etc.
• Created transformation and mapping by using Informatica Design
• Maintained data consistency, Oracle database integrity and reported instances of data corruption.
• Created mappings using transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update strategy, Joiner, Normalizer, Union, Store procedure and XML transformations
• Performed numerous data extraction requests involving SQL scripts and UNIX
• Performed data migration between different environments and Third-Party Databases
• Performed drill down analysis reports using SQL Server Reporting Services
• Created data dictionary for the clinical aberrancy rules
• Analyzed HIPAA 4010 and 5010 standards for 837P EDI X12 transactions related to providers, payers, subscribers and other related entities

Confidential

Data Analyst

Responsibilities:

• 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 used concepts like Cast and volatile tables on SQL server
• Analyzed duplicate data or errors in data to provide appropriate inter-departmental communication and monthly reports.
• Developed several operational reports using SSRS.
• Used SQL and PROC SQL (SAS) for ad-hoc report programming and creation of the ad-hoc reports for marketing research data
• Utilized IMPORT and EXPORT features in MS SQL to load data onto the data warehouse
• Created numerous Permanent tables, Volatile tables and Global Temporary tables
• Wrote standard SQL Queries to perform data validation and created excel summary reports (Pivot tables and Charts)
• Ensured that data warehousing design was scalable and maintainable