SUMMARY

• Data Analyst with 8+ years of experience in Healthcare/Health Insurance industry that accepts the responsibilities to support both external clients and internal management.
• Comfortable in working with various requirement gathering techniques like Brainstorming, JAD sessions, Focus Analysis, Reverse Engineering, Survey, Document Analysis, Interview, Prototyping and Observation.
• Experience in Designing, developing, testing, and implementing HL7 interfaces. Good understanding of SDLC (methodology) with waterfall and Agile methodologies.
• Expertise in T - SQL Programming, SQL stack including SSIS, SSRS and SSAS.
• Experience in EDI transactions (810, 832, 850, 855 and 856) and experience with EDI and EDI outputs, IDOCS, ANSI, partner profiles, master data.
• Excellent knowledge of SQL along with hands on experience of Data manipulation, using SQL Navigator, Toad and MS Access.
• Extensive knowledge of Object-Oriented Analysis and Design (OOAD) using UML and Rational Unified Process (RUP).
• Strong Experience in ER & Dimensional Data Modeling to deliver Normalized ER & STAR/SNOWFLAKE schemas using Erwin.
• Experience with Azure transformation projects and Azure architecture decision making Architect and implement ETL and data movement solutions using Azure Data Factory (ADF), SSIS.
• Datacenter Migration, Azure Data Services have strong virtualization experience.
• Experienced in data integration, metadata management, ETL, data modeling tool sets.
• Excellent SQL programming skills and developed Stored Procedures, Triggers, Functions, Packages using SQL, PL/SQL.
• Experience in Data transformation and Data mapping from source to target database schemas and also data cleansing.
• Expertise on Relational Data modeling (3NF) and Dimensional data modeling.
• Experienced in SWOT Analysis, Gap Analysis, Impact Analysis, Risk Analysis, and Project Planning
• Extensive knowledge of Medicaid, Medicare, Procedural and Diagnostic codes and Claims Process
• Strong experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export through the use of multiple ETL tools such as Ab Initio and Informatica Power Center Experience in testing and writing SQL and PL/SQL statements - Stored Procedures, Functions, Triggers and packages.
• Specialized experience in healthcare insurance domain including Medicare and Medicaid. Profound experience with HIPPA X12 EDI transaction codes such as 270/271(inquire/response health care benefits), 276/277(Claim-status), 834(Benefit-enrollment), 835(Payment/remittance advice), 837(Health care claim).
• Analyzed 4010A1 and 5010 TR3 Implementation guides to identify and document the changes for HIPAA EDI Transactions such as 837 P, 835, 276/ 277 and 270/271.
• Expertise in Logical Modeling, Physical Modeling, Dimensional Modeling, Star and Snow-Flake schema.
• Worked extensively on creating reports using free form SQL queries in Microstrategy.
• Extensive experience in querying languages using SQL, PL/SQL, T-SQL, SAS, HIVE.
• Strong understanding of various SDLC methodologies such as RUP, Waterfall and Agile with hands on experience in all of them

PROFESSIONAL EXPERIENCE

Data Analyst

Confidential - TX

Responsibilities:

• Responsible for designing, testing and implementing HL7 interfaces utilizing HL7 V 2.X and user-defined message sets.
• Performed Data Analysis, Data Migration and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Experience managing Azure Data Lakes (ADLS) and Data Lake Analytics and an understanding of how to integrate with other Azure Services. Knowledge of USQL and how it can be used for data transformation as part of a cloud data integration strategy.
• Conducts and facilitates effective project meetings, including requirements gathering, issue tracking, status reports, and executive communications
• Ensures problems are effectively escalated and crisis management activated, as needed
• Document root causes and specifications and work with Business and Technology to set controls to prevent further issues.
• Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
• Extensively used Star and Snowflake Schema methodologies in building and designing the logical data model into Dimensional Models.
• Created message flows for validation, routing, qualification and transformation of HL7 and non-HL7 messages.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a complex EDW using Informatica.
• Provider inquiry about the status of claims. This involved checking the MMIS claims subsystem to see the status of claims sent and informing the providers if the claims have been suspended / denied or paid.
• Worked on different HL7 Message types like Admit Discharge Transfer, Orders and Results.
• Involved in creating SQL scripts, Tables, Views in Teradata for Data Analysis and to support User Acceptance Testing (UAT) and Post Production Validation (PPV) of the data in Data warehouse.
• Ensure data warehouse database designs efficiently support BI and end user requirements.
• Responsible for the full HIPAA compliance lifecycle from gap analysis, mapping, implementation and testing for Medicaid Claims.
• Design and development of ETL processes using Informatica ETL tool for dimension and fact file creation
• Recreating existing application logic and functionality in the Azure Data Lake, Data Factory, SQL Database and SQL data warehouse environment. Experience in DWH/BI project implementation using Azure DF.
• Maintains version control and add appropriate comments when creating or modifying macros within the report writing tool or when creating workflows
• Involved in creating end-user documentation, guidelines and establishes naming conventions for use with reporting tools
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Currently working on XML parsing using Hive, HDP
• Manage and analyze data communication channel to ensure compliance security requirements in accordance to ISO, HIPAA and PCI guidelines. Coordinated with Project Managers to resolve risk issues and ensure compliance of Security System related to the HIPAA.
• Ensure that ad-hoc project of data migration to Audit database meet WebSOS expectations for quality and timeliness.
• Modified existing OLAP cube to extract historical data to support healthcare cost utilization analysis and actuarial reporting (SSRS).
• Identify advanced and increasingly sophisticated opportunities for Business Intelligence usage
• Performs data manipulation techniques such as cleansing and standardization
• Carry out data testing to validate the business logic and reconciliation across various stages of data transformation.

Data Analyst

Confidential - Boston, MA

Responsibilities:

• Collaborated with the business to understand strategic goals and objectives, define requirements, assess product fit to business needs, and reengineer business processes as needed.
• Conducted all interviews and meetings needed to document current business process.
• Participated in daily scrum meeting to discuss current tasks and status
• Gathered requirements with high quality and customer satisfaction
• Helped prepare test strategy, detailing test approach, data used, and test environments.
• Extensively used agile methodology and organized Sprint and Scrum meetings.
• Analyzed business and user need, through research and fact-finding combined with a basic understanding of applicable business processes, systems, and industry requirements. Used Test Director, PL/ SQL for testing the application.
• Designed the data marts in dimensional data modeling using star and snowflake schemas.
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
• Performed Data mapping and data translation in HL7 version.
• Involved in requirement gathering phase (Provider, Claim components and HIPAA). Utilized Rational Unified Process (RUP) to configure and develop process, standards and procedures.
• Retrieved the claims from Claims Inventory System (CIS) using Electronic Data Interchange (EDI).
• Checked files in Electronic Data Interchange (EDI) transaction support tool and reporting tool and modified the files based upon the errors and checked them if they were loaded successfully in CIS.
• Involved in developing Data Migration and Cleansing rules for the Integration Architecture (OLTP, OLAP, DW).
• Involved in designing Setup maintain Administrator the Azure SQL Database, Azure Analysis Service, Azure SQL Data warehouse, Azure Data Factory, Azure SQL Data warehouse.
• Assurance, and Developers in the process of creating and documenting business and data requirements.
• Involved in designing and implementing basic SQL queries for QA Testing and Report/Data Validation.
• Analyzed and tested business workflows that organize and integrate clinical information for each of its member's clinical records, pharmacy information, charts, and clinical practice guidelines and EDI-X12 transactions in the HIPAA 4010/5010 Version.
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Created jobs, alerts to run SSIS packages, SSRS reports periodically.
• Developed various SSIS templates for heterogeneous data migrations.
• Retrieved and analyzed data using T-SQL, Excel, SSRS.
• Developed multiple processes for Daily Reports using SSRS, Tableau and PowerPivot.
• Developed SSRS reports by migrating data from DB2.
• Migrated data from traditional database systems to Azure SQL databases.
• Collaborated with the technical team to understand the data design of the application and apply that knowledge to define data requirements related to the new functional requirements.
• Involved in developing flowchart and process diagram using MS Visio.
• Prepared Functional Requirement Documents (FRD's) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.

Data Analyst

Confidential - Deerfield, IL

Responsibilities:

• Prepared 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
• Extensively involved in the modeling and development of Reporting Data Warehousing System.
• Involved in creating, documented and maintained logical & physical database models.
• Perform in-depth data analysis and load customer details from data warehousing to analyze, generate comprehensive reports to decision makers and other affected by the results.
• Performed data migration using TSQL & SSIS to go-live version of modernization LOB database.
• Involved in developing strategies and loading techniques for better loading and faster query performance.
• Worked in Agile environment, participating in daily stand-ups and planning meetings. Worked directly with client SMEs in gathering and defining business requirements. Presented recommendations to client and wrote functional requirements document.
• Intricately involved in Business Process Flow development, Business Process Modeling, and ad hoc Analysis
• Interaction with the developers to report and correct bugs.
• Involved in validating HL7 ADT (Admit Discharge Transfer) and HL7 ORU (Observation Result Message) message types for various Hospital Information exchanges.
• Created SSRS reports in with different type of properties like chart controls, filters, Interactive Sorting, parameters etc.
• Involved in developing Snowflake Schemas by normalizing the dimension tables as appropriate.
• Validated HIPAA ( Conversion) rules and HL7 Standards.
• Created and executed test cases for ETL jobs to upload master data to repository.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• 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 creating advanced chart visualizations in Tableau using Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Pie Chart, Gantt chart, and Histograms.
• Followed a structured approach to organize requirements into logical groupings of essential business processes, business rules, and information needs. Ensured that critical requirements are not missed.
• Worked on SQL queries in a dimensional data warehouse as well as a relational data warehouse.
• Involved in extensive data validation by writing several complexes SQL queries and involved in back-end testing and worked with data quality issues.
• Worked closely with Developers, User Representatives and participated in the product design process including specifications and other document reviews.
• Used Test Director to invoke the scripts, initially performed the baseline testing, organized all the scripts systematically and generated reports.
• Provide analysis on inbound HL7 messages which included ADT, RAD, Lab, Path and Trans. Matched and verified HL7 messages and the various reports sent to hospitals and providers.
• Involved in designing and developing database models for the operational data store, data warehouse, and federated databases to support client enterprise Information Management Strategy.

Data Analyst

Confidential - Atlanta, GA

Responsibilities:

• Responsible for requirement and design documentation review, test plans, identifying and reporting software anomalies and test results.
• Attended and conducted meetings and workshops to discuss high level requirements.
• Involved in Project Estimation, extensive data analysis, data migration design, creating mapping document, reviewing offshore implementation, test results and production implementation.
• Involved in developing business use cases and also extensively worked on Rational Requisite Pro in gathering the requirements. Coordinated with Project Managers to resolve risk issues and ensure compliance of Security System-Related to the HIPAA.
• Responsible for implementing the Key process areas and Impact analysis. Generated Use Case diagrams, Sequence diagrams, Business Objects, Domain Object Model using Visio, to depict process flows and PowerPoint presentations.
• Involved in SQL and PL/ SQL support, coordinated with the developer's team throughout the development process.
• Used query languages such as SQL, Hive, Pig and experience with NoSQL databases, such as MongoDB, Cassandra, HBase.
• Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin.
• Involved in designing new database tables to meet business information needs and mapping document, which is a guideline to ETL Coding.
• Configured the Data mapping between Oracle and SQL Server 2005.
• Created SAS programs that are used for data validation, statistical report generation and program validation and automated the Edit Check programs using Macros.
• Used Hive to store the data and perform data cleaning steps for huge datasets.
• Propose strategies to implement HIPAA 5010 in the new MMIS system.
• Worked with ANSI X12 5010 as well as ANSI X12 4010 including medical transactions such as 837 (medical claims), 835 (medical claim payments), 270 (eligibility inquiry), 271 (eligibility response), 276 (claim status), 277 (claims status response), 820 (enrollment)
• Managed Version Control, each version of the application was stored in Clear case and necessary modifications, updates, analysis was done
• Highly proficient in the use of SQL and Relational Databases for querying and reporting purposes.
• Involved in developing Data mapping, Data Governance, Transformation and Cleansing rules for the Data Management.
• Worked extensively with Oracle and SQL Server.
• Was responsible for EDI map analysis, development, testing and implementation. analyzed current EDI maps
• Incorporated HIPAA standards, EDI (Electronic data interchange), Implementation and Knowledge of HIPAA code sets.
• Preparation of various test documents for ETL process in Quality Center.