SUMMARY

• Proficient in Data Analysis, Data Modeling, Technical Documentation with around 7+ years of experience in Healthcare industry. .
• 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.
• 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 modelling, 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.
• 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.
• In-depth knowledge of Healthcare organization operations including outsourced operations, Health Insurance, HIPAA, and Medicaid/MMIS, including MITA.
• Experience in worked on FACETS batches like XPF and MMS to upload bulk data into the FACETS system through the HIPAA gateway by generating keyword files to enrol, modify or terminate providers and members.
• Good working knowledge of Claims processing, HIPAA Regulations and 270, 837P, 837I, 837D EDI Transactions for health care industries.
• 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.
• 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.
• 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.
• Good Knowledge in SQL, SAS and ETL tool.
• Experience in data Extraction, Loading and Transforming of data at the Data Warehouse level as well as skilled in various ETL tools for design and development of workflows, transformations, and mappings.
• Extensively worked on the ETL mappings, analysis, and documentation of OLAP reports requirements.
• 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, HlookUP, VlookUp) 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.
• 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.
• Skilled in 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.
• 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.
• 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

Confidential, New York, NY

Sr. Data Analyst

Responsibilities:

• Worked on documenting logical, physical, relational and dimensional data models. Designed the Data Marts in dimensional data modelling using star and snowflake schemas.
• Responsible for creating, documenting and maintaining logical & physical database models.
• Created 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 warehousing to analyse, generate comprehensive reports to decision makers and other affected by the results.
• Worked on 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.
• Worked on FACETS batches like XPF and MMS to upload bulk data into the FACETS system through the HIPAA gateway by generating keyword files to enrol, modify or terminate providers and members Analysis of the data using SAS retrieving data MS Excel Sheets.
• Worked on EDI transactions: 270, 271, 834, 835, and 837 (P.I.D) to identify key data set elements for designated record set.
• Involved in full HIPAA EDI transactions such as 835, 837 (P, D, I) 276, 277, 278.
• 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.
• Worked on building load rules and transformation logic for Extraction, Transformation and Loading (ETL) of the data into the data warehouse.
• 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.
• Responsible for reviewing data model, database physical design, ETL design, and Presentation layer design.
• Involved in Data Modelling of both Logical Design and Physical design of data warehouse and data marts in Star Schema and Snowflake Schema methodology.
• 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.
• 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.
• 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 and 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.
• Perform administrative tasks, including creation of database objects such as database, tables, and views, using SQL DCL, DDL, and DML requests.
• 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.

Confidential, Minneapolis, MN

Data Analyst

Responsibilities:

• Worked on data extraction using various queries/formulas, manipulate using various analytical tools to create reports.
• 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.
• 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 Modelling techniques such as Star Schema and Snowflake Schema.
• Worked with BA for analyzing requirements to developing SSIS and SSRS packages, testing, implementation and support.
• Worked on developing the Data requirement and use cases for FACETS batch process, automating the billing entities and commission process.
• Involved in using SAS programming and data analysis skills to extract, transform, translate, reformat, and load ETL raw healthcare data in HDMS's DART platform.
• Worked on the EDI 834-file load to Facets through MMS (Membership maintenance sub-system).
• Working within a growing environment of X 12 4010/5010 HIPAA Transaction Processing 837 I, P, D, 835, 834, 820, 270, 271, 276, 277, 278, EDI, Privacy, Security, and Medicaid.
• 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 Modelling and data flow diagrams.
• Worked with SQL, RDBMS, and Data warehousing (STAR Schema).
• Executed ETL operations for Business Intelligence reporting solutions using Excel.
• Involved in Data modelling 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.
• 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.
• 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.

Confidential

Data Analyst

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.
• Actively participated in producing system documents, functional requirements, ETL mapping and modelling deliverables Worked with root cause of data inaccuracies and improved the quality of data by using Data Flux.
• Created various transformation procedures by using SAS, ETL and SAS Enterprise guide.
• 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.
• Involved in Developing ETL (Extract, Transformation & Load) strategy to populate the Data Warehouse from the various source systems feeds.
• 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.
• Involved in Developing Tableau visualizations and dashboards using Tableau Desktop.
• 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.

Confidential, Cincinnati, OH

Data Analyst

Responsibilities:

• Analyse 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.
• Worked on data warehousing projects dealing with ETL (extraction, transformation, loading) using various databases.
• Worked with the fundraising teams to gather data migration and ETL requirements and preparing requirement documents.
• 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 Modelling 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.