SUMMARY

• Over 8+ years of working experience as a Data Analyst in Healthcare Industry with high proficiency in Data modelling including design and support of various applications in OLTP, Data Warehousing, OLAP and ETL Environment.
• Hands on experience in importing, cleaning, transforming, and validating data and making conclusions from the data for decision - making purposes.
• Expertise in defining data quality, data modeling, data warehouse, Star/Snowflake Schema Designs with requirements analysis - definition, database design, testing and implementation, and Quality process.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modelling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modelling.
• Worked on Data Model design, Data Extraction, Transformations and Loading, Mappings & Workflows, Customized Analytics Reports.
• Experience with data warehousing techniques like Slowly Changing Dimensions, Surrogate key, Snow flaking etc. Worked with Star Schema, Data Models, E-R diagrams and Physical data Models.
• Experience in Performance Tuning and Debugging of mappings and sessions. Strong in optimizing the Mappings by creating/using Re-usable transformations, Mapplets and PL/SQL stored procedures.
• Expert Knowledge of T-SQL, Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
• Experience in Data warehousing, Data Architecture &Extraction, Transformation and loading (ETL) data from various sources into Data Warehouse and Data Marts using Informatica Power Centre.
• Solid understanding of statistical analysis, predictive analysis, machine learning, data mining, quantitative analytics, multivariate testing, and optimization algorithms.
• Worked on various databases Oracle, SQL server, Teradata andDB2.
• Experience in Integration and extraction of data from various sources like DB2, SQL Server, Oracle, Sybase, and Teradata, MS Access, Flat files into a staging area.
• Very Good Experience in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
• Expertise in writing SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Experience with HEDIS Healthcare Effectiveness Data and Information Set for benchmarking managed care effectiveness and evaluating provider payer relationships.
• Proficient in developing Use Case Model, Analysis Model, Design Model, Implementation Model, Use Case Diagrams, Behaviour Diagrams (Sequence diagrams, Collaboration diagrams, State chart diagrams, Activity diagrams), Class Diagrams based on UML using Rational Rose.
• Well versed in system analysis, ER/Dimensional Modelling, Database design and implementing RDBMS specific features.
• Skilled in visualizing, manipulating and analysing large datasets and has ability of designing and developing effective reports. Proficient with MS Office Applicants, Excel (Pivot Table, Hlook UP, Vlook Up, Countify) and experienced with Tableau, MS SQL Server.
• Strong experience in Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export by multiple ETL tools such as Informatica Power Centre Experience in testing, data validation and writing SQL and PL/SQL statements - Stored Procedures, Functions, Triggers and packages.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Experience in supporting Informatica applications, data extraction, Transformation and Loading from heterogeneous sources using Informatica Power Center.
• Strong knowledge in conceptual design, logical design and physical design of business intelligence, data warehouse projects.
• Profound knowledge of Data modelling including Star Schema and Snowflake Dimensional Data modelling, 3NF Normalized Data Modelling. Very good understanding of Logical Modelling and Fine-tuned Physical Data Modelling.
• Worked on Tableau and created adhoc reports and dashboards.
• Ability to use custom SQL for complex data pulls.
• Good understanding of SQL Database and data warehouse design principles (e.g., facts, dimensions).
• Experienced in managing, monitoring and investigating cases such as trouble tickets from customers and fixing the issues.
• Worked in creating different Visualizations in Tableau using Bar charts, Line charts, Pie charts, Maps, Scatter Plot charts, Heat maps and Table reports.
• Involved in Design of the Enterprise Data Visualization Architecture. Defined best practices for Tableau report development.
• Strong SQL Skills related to information retrieval and analysis. Exposure to Client Interaction, User requirement Analysis and Support.
• Extensive experience in developing Unit, Integration and UAT Test plans and Cases and has experience in generating/executing SQL Test Scripts and Test results.

PROFESSIONAL EXPERIENCE

Sr. Data Analyst

Confidential - Reston, VA

Responsibilities:

• Worked on documenting logical, physical, relational and dimensional data models. Designed the Data Marts in dimensional data modelling using star and snowflake schemas.
• Involved in preparing documentation for all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, and glossary evolve and change during the project.
• Coordinated with DBA on database build and table normalizations and de-normalizations.
• Involved in creating, documenting and maintaining logical & physical database models.
• Identified the entities and relationship between the entities to develop Conceptual Model using ERWIN.
• Involved in creating Data mappings, Tech Design, loading strategies for ETL to load newly created or existing tables.
• Perform in depth data analysis and load customer details from data ware housing to analyse, generate comprehensive reports to decision makers and other affected by the results.
• Involved in creating Schema objects like Indexes, Views, and Sequences, triggers, grants, roles, Snapshots.
• Developed strategies and loading techniques for better loading and faster query performance.
• Worked with client to gather Business/Technical Requirements, Approval of CR (Change request), Design and Implementations for State MMIS.
• Involved in ICD 10 Analysis. Full knowledge of the Diagnosis and Procedural Code changes for Healthcare Entities like Payers, Employer Groups and Providers.
• Involved in gathering requirements and modelled the data warehouse and the underlying transactional database.
• Worked on writing complex SQL queries using joins, sub queries and correlated sub queries to manipulate and validate data.
• Generated monthly and quarterly reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS.
• Involved in Data Modelling of both Logical Design and Physical design of data warehouse and data marts in Star Schema and Snowflake Schema methodology.
• Made major contribution in the implementation of EDW Incremental (pull and load) that constituted different modules like claims, providers, members, products for different source systems of which Amisys was primary source.
• Performed mappings & ran sessions and workflows to execute the Land Process of loading the customer data Set into Informatica MDM Hub using ETL tool that was coming from various source systems.
• Worked on developing dimensional model for Data Warehouse/OLAP applications by identifying required facts and dimensions.
• Involved in generating the DDL using forward engineering Worked in merging and complete compare of Physical models.
• Used the Data Warehousing Life Cycle to identify data elements from the source systems, performed data analysis to come up with data cleansing and integration rules for the ETL process.
• Involved in full HIPAA EDI transactions such as 835, 837 (P, D, I) 276, 277, 278.
• Worked on designing STAR schema for the detailed data marts and plan data marts consisting of confirmed dimensions.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle.
• Used forward engineering to create a physical data model with DDL that best suits the requirements from the Logical Data Model.
• Participated in identifying the database tables for defining the queries for the reports using SSRS.
• Worked on creating advanced chart visualizations in Tableau using Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Pie Chart, Gantt chart, Histograms.
• Involved in Creation of dashboards, stories and visualizations in Tableau. Created report schedules on Tableau Server.
• Worked on SQL queries in a dimensional data warehouse as well as a relational data warehouse.
• Worked on writing SQL scripts to test the mappings and Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Recommend additional methods to analyse collect and manage data to improve data quality and efficiency of the data systems across the application.
• Perform administrative tasks, including creation of database objects such as database, tables, and views, using SQL DCL, DDL, and DML requests.
• Involved in Developing Tableau visualizations and dashboards using Tableau Desktop.
• Involved in designing and developing database models for the operational data store, data warehouse, and federated databases to support client enterprise Information Management Strategy.
• Involved in developing the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.

Data Analyst

Confidential, Bloomington, MN

Responsibilities:

• Worked on data extraction using various queries/formulas, manipulate using various analytical tools to create reports.
• Worked on various reports using reporting tools like Tableau and MS excel to forecast the growth of various KPI.
• Worked independently to store, organize and collaborate numerical data and business objects to initiate analysis that enhance the understanding of our client's current customer base which can be leveraged to generate future business opportunities.
• Analyse and creating reports to evaluate inventory data and makes recommendations to enhance processes in pharmacy operations.
• Create web forms that feed directly to Sales Cloud or Marketing Cloud.
• Extract data on request from customers and business partners using SQL and translate results into various formats, including Excel, Crystal Reports and SSRS.
• Generated Data Models using Erwin and developed relational database system and involved in Logical modelling using the Dimensional Modeling techniques such as Star Schema and Snowflake Schema.
• Involved in creating Ad-hoc reports by data analysis using MS-Access via ODBC or TOAD for data import and SQL analysis of reconciling data from the call centre and stores across USA.
• Worked with BA for analyzing requirements to developing SSIS and SSRS packages, testing, implementation and support.
• Designed and customized data models for Data warehouse supporting data from multiple sources.
• Involved in development of High-level design, Conceptual design, Logical and Physical design for Database, Data warehousing and many Distributed IT systems.
• Used Data Warehouse Architecture and Design - Star Schema or Snowflake Schema, FACT and Dimensional Tables, Physical/Logical Data Modeling and data flow diagrams.
• Worked with SQL, RDBMS, and Data warehousing (STAR Schema).
• Involved in Data modeling process, conceptual, logical and physical models, ERD and data warehouse design-Dimensional-Star, snowflake schema, Data Integrity and OLAP and facts, indexing, data dictionary.
• Reviewed EDI companion guides for all payers to ensure compliance, edit integrity and maintain up-to-date list of payer contacts.
• Involve in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Informatica Power Center.
• Involved in developing SQL and VBA (ADO) automated processes to access and clean externally and internally generated data and making that data usable for analysis and project trackers.
• Worked on source system analysis, data transformation, loading, validation for data marts, operational data store and data warehouse.
• Developed the ETL Informatica Mappings for importing data from ODS into subsequent data marts.
• Analysed EDI X12 - 837I/P, 835 and 834 transactions consistency related to providers, payers, subscribers and other related entities.
• Worked on multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, WebSphere and Cognos.
• Capturing data and building reports for clients in SSRS and creating stored procedures using T-SQL daily.
• Involved in creating functional specification documents based on RBC data feed requirements to be on-boarded onto the Cosmos platform.
• Worked on creating mappings between Transcend (Cosmos) data feed requirements and RBC source data feeds.
• Involved in Legacy Application Developments, BI (Data Warehouse Implementations), Country rollouts, M&A assignments, continues improvements, enhancements, server consolidations, upgrades and Tools development.
• Involved in writing, Queries to retrieve data from ODS to analyse relationships and supported in building the Data Model.
• Used databases and created tables and models in data mart, data warehouse and staging.
• Work with clients to establish eligibility data exchange and write data mapping specifications for custom file layouts. Includes testing eligibility data files with vendors, defining profiles and documenting procedures.
• Worked with testing team and performed UAT on the application.
• Worked on Test Plans and Test Execution Procedure Document based on the Business & Functional Requirement Document and numerous Test Cases and Test Scenarios to cover overall aspect of quality assurance.

Data Analyst

Confidential - Madison, WI

Responsibilities:

• Used SQL to test various reports and ETL load jobs in development, QA and production environment.
• Worked on creating Process Flow diagrams, Use Case Diagrams, Class Diagrams and Interaction Diagrams using Microsoft Visio and Rational Rose.
• Used complex SQL queries to perform Data Analysis like Data Profiling, Data Quality checks to maintain the integrity of data.
• Played a key role in the planning, testing, and implementation of system enhancements and conversions.
• Billing and collection of all third-party insurance carriers and private payer sources.
• Worked on performance reports and interactive visualizations of data using Tableau for data analysis.
• Create and maintain data model/architecture standards, including master data management (MDM).
• Worked with Quality Control Teams to develop Test Plans in HP ALM and Test Cases.
• Involved in testing the ICD-10 codes by sending the test transactions to clearing houses or payers.
• Involved in Data Modeling of both Logical Design and Physical Design of Data Warehouse and data marts in Star Schema and Snowflake Schema methodology.
• Used the DataStage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database.
• Involved in DB2 Performance tuning projects where the existing modules are analysed for optimum use of system resources.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Involved in creating logical and physical data modelling with STAR and Snowflake schema techniques using Erwin in Data warehouse as well as in Data Mart.
• Worked on implementation of Document Management System meeting requirement deadlines.
• Participated in performing Data Profiling of the current state of data in the Data Warehouse by doing Data Analysis using SQL Queries and Microsoft Excel, finding Gaps in Data and formulating solutions for the same.
• Involved in generating and verifying weekly/ monthly/ yearly reports, using SAP Business Objects and ad-hoc reports.
• Involved in analysis for wide range of Six Sigma and Web-based initiatives, including user requirements.
• Worked on Data mapping, logical data modelling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Performed data entry and reconciliation as well as back end data systems maintenance work using MDM tools Informatica and SQL language programming.
• Worked on developing SSIS packages using for each loop in Control Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table.
• Attended group (JAD) sessions with business units and stakeholders to define project scope and deliverables.
• Involved in doing Functional Testing and followed through the process until the defects were closed.
• Worked on reviewing the Defects entered by the QA team and prioritized the defects and assigned them to the development team.
• Worked on UAT Materials, including the UAT Process, UAT Test document which would include step-by step process for UAT as well as all the tests that would cover all requirements.
• Worked with the Training Group to build training materials as well provided any suggestions/ tool tips to assist in User Training.

Data Analyst

Confidential - Nashville, TN

Responsibilities:

• Involved in creating fact and dimension table implementation in Star Schema model based on requirements.
• Worked on business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Centre.
• Involved in data governance, defined data mapping from source to target (for all the three heritages).
• Gathered metadata and created data analysis repository (spreadsheet), which includes following metadata information: data source, hierarchy, fact, dimension, data attribute, data integration, data model, data acquisition etc.
• Worked collaboratively with multiple business entities and successfully implemented new business processes and established data governance.
• Involved with data quality and data governance solutions including platforms and supporting data processes.
• Involved in defining data requirements and elements used in XML transactions.
• Worked with QA team issues and reviewed test plans and test scripts for proper implementation and execution.
• Worked on Data Manipulation and Data Validation using SQL queries in a MS SQL Server 2008 environment.
• Involved in Data Validation with Data profiling.
• Worked on report generation using SAS/Macros as per the requirements.
• Involved in the testing of Data Mart using Power Centre.
• Worked on SQL query (Oracle and T-SQL) in analyzing and validating SSIS ETL database data warehouse processes.
• Involved in documenting additional data cleansing needs and consistent error patterns that could diverted by modifying ETL code.
• Involved in Data Cleansing, data aggregation, Data Scrubbing during the ETL's Extraction and Loading Phase by analysing the raw data and writing SAS and SQL queries and creating complex reusable Macros.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Worked on different Data mapping activities from Source systems to Teradata.
• Involved in Developing, Debugging, and validating the project-specific SAS programs to generate derived SAS datasets, codebooks, summary tables, and data listings according to departmental standards.
• Worked on tasks performed by other team members and involved in data validation and data cleaning in all phases of Survey studies.
• Worked on Unit testing for all reports and packages.
• Involved in preparing Test Strategy, Test Plan, test report and Gap Report.
• Performed UAT based on Requirements Document and prepared the Test Cases using Quality Centre.

Data Analyst

Confidential - Dallas, TX

Responsibilities:

• Analyze the client data and business terms from a data quality and integrity perspective.
• Perform root cause analysis on smaller self-contained data analysis tasks that are related to assigned data processes.
• Worked to ensure high levels of data consistency between diverse source systems including flat files, XML and SQL Database.
• Involved in Developing and run ad hoc data queries from multiple database types to identify system of records, data inconsistencies, and data quality issues.
• Involved in translating the business requirements into data requirements across different systems.
• Involved in understanding the customer needs with regards to data, documenting requirements, developing complex SQL statements to extract the data and packaging/encrypting data for delivery to customers.
• Worked with Data Modeling team to create Logical/Physical models for Enterprise Data Warehouse.
• Participated in identifying the database tables for defining the queries for the reports using SSRS.
• Worked on data analysis using SQL, T-SQL and many other queries-based applications.
• Worked with senior DA in conducting JAD Sessions.
• Transferred data objects and queries from MS Access to SQL Server.