SUMMARY

• Over 8+ years of Professional Experience in different environments and platforms including Data Analysis, datawarehousing, datamodelling,datamapping, data lineage,dataprofiling, Informatica Data Quality (IDQ), Informatica Data Analyst (IDA), Informatica Power Center and Client - Server applications in Healthcare Industry.
• Strong IT experience in teh field of Data analysis, ETL Development, Data Modelling, and Project Management wif experience in Big Data and related Hadoop technologies.
• Strong working noledge of healthcare standard Health Level Seven (HL7).
• Strong IT experience in teh field of Data analysis, ETL Development, Data Modelling, and Project Management wif experience in Big Data and related Hadoop technologies.
• Strong experience in Data Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Integration and Metadata Management Services and Configuration Management.
• Extensively used Informatica PowerCenter, Informatica Data Quality (IDQ) as ETL tool for extracting, transforming, loading and cleansing data from various source data inputs to various targets, in batch and real time.
• Good Knowledge on SAS Macros, SAS SQL, SAS Stat and SAS Graph in UNIX environment.
• Experienced in Installation, Configuration, and Administration of Informatica Data Quality and Informatica Data Analyst.
• Expertise in MS SQL Server suite of products like SSRS, SSIS and SSAS of MS SQL Server.
• Extensive experience wif OLTP/OLAP System and E - R Modelling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional Modelling.
• Extensive experience in integration of Informatica Data Quality (IDQ) wif Informatica PowerCenter.
• Expertise wif Informatica Data Quality (IDQ) toolkit, data cleansing, data matching, data conversion, data profiling, exception management, reporting and monitoring functions.
• Extensive experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mapping from an Operational Data Store to an Enterprise Data Warehouse.
• Expertise in Data Modelling (Dimensional & Relational) concepts like Star-Schema Modelling, Snowflake Schema Modelling, Fact and Dimension tables.
• Experience in Medicaid Management Information System (MMIS). Expertise in various subsystems of MMIS- Claims, Provider, Recipient, Procedure Drug and Diagnosis (PDD), Explanation of Benefits (EOB).
• Strong experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export using multiple ETL tools such as Ab Initio and Informatica Power Center, Informatica Data Quality (IDQ), Informatica Analyst, Informatica Master Data Management (MDM), Informatica Meta Data Manager, Data Stage, SSIS.
• Complete study and analysis of Revenue Cycle management of teh health stream respective to existing billing system, Claims processing etc.
• Excellent Knowledge in Electronic Medical Record (EMR) module process flow.
• Experienced in EMR claims process and adjudication in teh Medicare, Medicaid and Private Insurance Sectors adherence to HIPPA.
• Strong experience in Business Intelligence technologies like Cognos, Framework Manager, Report Studio, Query Studio, Cognos connection, Cognos Administration, Business Objects Web Intelligence, Desktop Intelligence, Universe design and Crystal Reports, etc.
• Good Knowledge of various HL7 EMR systems.
• Well Versed in creating automated Reports using Crystal Report and SQL Server Reporting Services.
• Experienced in full life cycle MDM development including data analysis, database design, data mapping and data load in batch.
• Good Knowledge in Defining teh Match and Merge Rules in teh MDM Hub by creating Path components, Columns and rules. Implementing MDM solutions and real time enterprise application integration.
• Strong understanding of FACETS and Facets Data Model working on data model and data extracts.
• Proficient in Master Data Management (MDM), JDE, ADAPTIV.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a complex EDW using Informatica.
• Familiar wif HIPAA EDI transactions such as 835, 837 (P, D, me) 276, 277, 278 etc.
• Good exposure at Cognos Data warehouse/ETL and reporting tools.
• Experienced working in Facets online modules such as Billing, Provider, Claims and Membership modules.
• Excellent noledge on Medicare, Medicaid, Medicare Advantage, Medigap, HIPAA Standards, EDI Transactions (4010), EHR/EMR, HIE and HIX.
• Exposure to implementation and operations of data governance, data strategy, data management and solutions.
• Experience in SQL, DML, and DDL, writing complex SQL queries and testing scripts for data validation against relational Databases including Data warehouse systems.
• Working noledge in teh ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• Thorough working noledge of SharePoint and MOSS, (TFS) Team Foundation Systems and Visual Studio Team System (VSTS).
• Experience wif healthcare system, Medicaid and wif prime focus on claims adjudication, provider, eligibility and prior authorization.
• Expertise in handling SQL queries and optimizing them in Oracle, SQL Server, MS Access and Teradata.
• Expertise in understanding and supporting teh client wif Project Planning, Project Definition, Requirements Definition, Analysis, Design, Testing, System documentation and user training.
• Well versed in writing queries/Scripts for Data Analysis and QA reporting and testing.

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh, PA

Sr. Data Analyst

Responsibilities:

• Worked wif Data Analysis Primarily Identifying Data Sets, Source Data, Source Metadata, Data Definitions Data Formats, Data Validation, Data Cleansing, Data Verification and Identifying Data Mismatch.
• Created various profiles using Informatica Data Explorer (IDE) & Informatica Data Quality (IDQ), from existing sources and shared those profiles wif business analysts for their analysis on defining business strategies in terms of activities such as assigning matching scores for different criteria etc.
• Actively participated in HL7 working group activities and implemented teh MITA Medicaid Eligibility Architecture based on HL7.
• Used SQL and SAS skills to perform ETL from DB2 and Teradata databases and created SAS datasets, SAS macros, Proc/data steps and SAS formats as required.
• Operationalised Collibra wif Rochade, teh former being used for Data Governance and teh latter for Data Lineage.
• Involved in Writing programs and SAS macros to assist other team members in resolving issues during conversion, and explained their use and functionality to teh team.
• Drove feature engineering for teh AI, ML models for demographics, vitals, labs, medications, clinical events, healthcare utilization, and comorbidities and HIT Interoperability FHIR Server(s) and FHIR API management.
• Responsible for envisioning and architecting teh enterprise-level Identity and Access Management Infrastructure initiative, addressing teh need for compliance wif teh HIPAA regulations pertaining to security and privacy of patient health information. Importing large amount of data (Enrollment, Medical claims, Pharmacy Claims) from various healthcare group to SCIO SAS system.
• Created and enhanced teh existing reports and dashboards in Cognos query studio and report studio to fit user requirements.
• Created Data Governance Framework, operationalization of Collibra.
• Created a relational model and dimensional model for online services such Clinical EMR records.
• Designed and developed MDM data model and integration of WebSphere Process Server.
• Worked wif Data Architect in Designing teh CIM Model for Master Data Management.
• Used noledge of Health Care Information Systems EMR model to develop proposed workflow in MS Visio.
• Expertise in MS SQL Server suite of products like SSRS, SSIS and SSAS of MS SQL Server.
• Involved teh implementation of MDM concept wif upstream and downstream integration of different applications in agile environment.
• Carried out Maturity Assessment of Data Governance and use of Collibra.
• Work wif various healthcare providers to determine which providers will has access to teh shared care record system.
• Facilitates workshops to educate providers on teh advantages of healthcare interoperability using HL7 FHIR messaging.
• Developed various charts and graphs like bar chart (side-by-side, stacked), line graphs, pie -charts etc. by using chart expert of Crystal Reports.
• Reviewed teh data model and reporting requirements for Cognos Reports wif teh Data warehouse/ETL and Reporting team.
• Implemented a MDM process to take strategy to roadmap and design development activities. Delivered MDM roadmap & MDM Architecture.
• Created a road map for teh client for teh planning, developing, and implementing of MDM solutions, enabling consolidation of MDM data following Mergers and Acquisitions.
• Thorough Knowledge in creating DDL, DML and Transaction queries in SQL for Oracle and Teradata databases.
• Implemented metadata standards, data governance and stewardship, master data management, ETL, ODS, data warehouse, data marts, reporting, dashboard, analytics, segmentation, and predictive modelling.
• Participated in Facets Table data Modelling planning, designing, implementation of teh data warehouse and conducted testing by developing complex SQL queries.
• Worked wif teh business/functional unit to assist in teh development, documentation, and analysis of functional and technical requirements wifin FACETS.
• Worked on Facets Output generation, Interface development and Facets Migration Projects.
• Manage teh online Master Data Management request tool for new requests ensuring proper decision-making on master data creation, data standardization, duplication checks, data field accuracy and completeness while meeting acceptable turnaround time. Complete large database cleanup projects to ensure data integrity.
• Reviewed EDI companion guides for all payers to ensure compliance, edit integrity and maintain up-to-date list of payers’ contacts.
• Worked on Implementing metadata standards, data governance and stewardship, master data management, ETL, ODS, data warehouse, data marts, reporting, dashboard, analytics, segmentation, and predictive modelling.
• Generated complex SQL subqueries wif inner, outer joins, and aggregate functions to update and delete data in Oracle database and Netezza data warehouse.
• Converted HL7 to FHIR Resources for Interoperability goals across systems.
• Provide technical support for teh Master Data Management environment for implementing fixes for identified data integrity and customer data processing issues.
• Ensured different internal external systems exchanged data according to teh specification to transform data from enterprise data warehouse to SQL Server load data to fact tables.
• Performed SQL Backup and Restore tasks on Various SQL Servers.
• Document and communicate changes throughout teh user organization, supporting Information System Change Management (ISCM) and compliance.
• Responsible for executing User Interface Testing, System Testing, Data Quality Testing on teh configuration design and prototypes.
• Involved in designing and developing Data Models and Data Marts dat support teh Business Intelligence Data Warehouse.
• Conducted user interviews and documented business and functional requirements. Assisted quality assurance team to functional-test teh new HL7 interfaces always keeping in mind HL7 and HIPAA guidelines, and coordinated user acceptance testing using derived test data.
• Tested teh HL7 File formats received from different Vendors validated teh parsing and Data Loader (BizTalk, SSIS Process) functioning using SQL Statements in teh backend.
• Defined, developed specs for federal reporting specific to Medicare Advantage. Contributed to software process-reengineering efforts aimed at evolving previous software development practices to adopt Lean/Agile and Scrum practices.
• Preparing System Test Cases from functional and technical requirement and Use case documents and performing System Testing. Data mapping, logical data Modelling, created class diagrams and ER diagrams and used SQL queries to filter data wifin teh Oracle database.
• Extensive involved in Conducting Market Research, Feasibility Studies, Data Analyses, System Analyses, Gap Analyses, and Risks Analyses.
• Created Source to target data mapping documents identifying key data elements and prepared Data Flow Diagrams.
• Highly involved in data reporting, exchange, and archival, data conversion functionalities, validation programs, keyword resources, related products, services, and information

Confidential, Des Moines, IA

Data Analyst

Responsibilities:

• Worked on designing and developing data management application on wif central operational database.
• Created SSIS Packages using Various Transformation like Lookup, Derived Columns, Condition Split, Data Conversion, Aggregate, Merge Join, Sort, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for teh reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Extensively used Informatica Data Explorer (IDE) & Informatica Data Quality (IDQ) profiling capabilities to profile various sources, generate score cards, create and validate rules and provided data for business analysts for creating teh rules.
• Created/Reviewed data flow diagram to illustrate where data originates and how data flows wifin teh Enterprise Data warehouse (EDW).
• Designed and implemented tables, Created Indexes, Stored Procedures, Functions, Triggers and DTS Packages to transfer data between servers in a SQL Server environment.
• Used MDM tool to support Master Data Management by removing duplicates, standardizing data (Mass Maintaining), and incorporating rules to eliminate incorrect data and filter data as per requirements.
• Evaluated Data from EMR for Clinical Workflow Data.
• Working on teh Meta Data Repository for Collibra.
• Involved in Developing SAS macros for data cleaning, reporting and to support routing processing.
• Worked wif teh business product owners and Data Architects to understand new functionality of EMR.
• Worked on data and report analysis, design and implementation using Crystal Reports combining data from various sources using different schemas which required intricate data manipulation to combine teh data and provide numerous and varied levels of reports.
• Created and enhanced data models in Cognos frame work manager to fit BI requirements.
• Designed SSIS Packages to transfer data between servers, load data into database on SQL Server environment and deploy teh data.
• Responsible for Installing, Mastering data wif Info Sphere MDM Server.
• Reviewed developer SQL code to ensure adherence to client standards and general best coding practices.
• Tested teh changes for teh front-end screens in FACETS related to following modules, test teh FACETS batches membership, Billing, Provider.
• Created Data profiling stored procedures using dynamic SQL as well as generating complex scripts to schedule various maintenance tasks.
• Extracted data from disparate sources by SAS/ACCESS.
• Apply noledge experience of HIPAA Act Rules and Regulations HIPAA transactions.
• Perform research on Member, Provider, Claims, Authorization, Appeals and Grievances data from Facets back end and front-end application system for reporting purposes.
• Extensively worked on data mapping using Facets data model.
• Implemented metadata standards, Collibra Data Governance and stewardship, master data management, ETL, ODS, data warehouse, data marts, reporting, dashboard, analytics, segmentation, and predictive modelling.
• Responsible for designing and developing Enterprise Data Warehousing solutions (Netezza).
• Worked wif Data Extraction, Transformation and Loading. Metadata architecture was also provided, for teh purposes of query enhancement and clarification of data relationships. Also built teh foundation for process implementation in MS-SQL.
• Extensive use of Facets back end tables and front-end application system for data validation purposes.
• Medicare Part C plan also provides some of teh extra coverage of a Medigap insurance policy.
• Design of tools dependent on changing data using Access Tableau. Presentation of data visualization using PowerPoint Tableau.
• Designed Data Flow Diagrams (DFD’s), Entity Relationship Diagrams (ERD’s), and web page mock ups using Modelling tools.
• Implemented metadata standards, data governance and stewardship, master data management, ETL, ODS, data warehouse, data marts, reporting, dashboard, analytics, segmentation, and predictive modelling.
• Extracted data from disparate sources by SAS/ACCESS.
• Designs and develops teh logical and physical data models to support teh Data Marts and teh Data Warehouse.

Confidential, Tampa, FL

Data Analyst

Responsibilities:

• Created various data quality mappings in Informatica Data Quality (IDQ) tool and imported them into Informatica PowerCenter as mappings, mapplets.
• Extensively used Informatica Data Quality transformations - Labeller, Parser, Standardizer, Match, Association, Consolidation, Merge, Address Validator, Case Converter, and Classifier.
• Implemented metadata standards, Collibra Data Governance and stewardship, master data management, ETL, ODS, data warehouse, data marts, reporting, dashboard, analytics, segmentation, and predictive Modelling.
• Worked wif FACETS Team for HIPAA Claims Validation and Verification Process.
• Worked on requirements of teh 835, 276, 277, 837, and HIPAA transaction across teh enterprise.
• Met wif teh Provider and Trading Partners to ensure dat HIPAA transactions pass teh EDI gateway and interpret technical difficulties into simple language.
• Designed a high-level spec document to show various paths dat need to be taken into consideration for teh transformation phase of .
• Deployed, enhanced and maintained teh MyChart Patient Portal and integrated Epic EHR wif teh wif RESTful FHIR API Data Interchange (EDI).
• Managed functional requirements for interfaces and conversions between other legacy systems to Teradata, MDM, Enhancements, Workflows and Reports for MDM.
• Used SQL for querying and analysis purposes on various source tables and conditions applied and Wrote SQL joins, sub queries.
• Created and published API’s for several FHIR Resources in Clinical, Administration and Financial domain.
• Performed ETL Testing/Validation (Designed and documented test strategy, test plan, test cases, test results, etc.) using Cognos reports to ensure data quality.
• Evaluation and selection of various MDM technologies and products in view of teh client requirements.
• Used SQL Server Reporting Services SSRS to schedule reports to be generated on predetermined time.
• Involved in Service Oriented Architecture SOA of teh claims processing system.
• Worked on developing teh business requirement and use cases for FACETS batch process, automating teh billing entities and commission process.
• Develop HL7 messaging for bi-directional case and disease report exchange, in HTML and XML formats, in accordance wif HL7 specifications EMR, EHR, HL7.
• Identify source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
• Created source table definitions in teh DataStage Repository by studying teh data sources.
• Interacted wif business SMEs, enterprise architects, developers, business intelligence, and data warehouse teams regarding project requirements explanation and interpretation.
• Developed SQL queries and tables which replicated teh ETL, and compared teh SQL results wif teh Informatica tables.
• Define downstream targets for MDM wif design for attributes and sync methodologies.
• Generated Surrogate ID’s for teh dimensions in teh fact table for indexed and faster access of data.
• Created hash tables used for referential integrity and/or otherwise while transforming teh data representing valid information.
• Wrote SQL queries for data analysis and validation
• Knowledgeable of Software Development Lifecycle (SDLC): Requirements, Design, Build, Testing, etc. RAD, Waterfall, Agile/Scrum and/or Hybrid Methodologies in which teh project TEMPhas adopted.
• Troubleshot teh designed jobs using teh DataStage Debugger.
• Tuned DataStage transformations and jobs to enhance their performance.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Used teh DataStage Director and its run-time engine to schedule running teh solution, testing and debugging its components, and monitoring teh resulting executable versions on an ad hoc or scheduled basis.
• Created jobs sequences. Provided data Modelling support for numerous strategic application development projects.
• Conducted a budget planning of teh project through walkthroughs and meetings involving various leads from Development, QAs and Technical Support teams.
• Created job schedules to automate teh ETL process.
• Prepared teh documentation of Data Acquisition and Interface System Design.

Confidential, NYC, NY

Data Analyst

Responsibilities:

• Creating and maintain data model/architecture standards, including master data management (MDM).
• Extensively tested teh ETL mappings which were developed to load data from Oracle and SQL Server sources into teh Oracle Staging/Target Area.
• Perform GAP Analysis between existing and TO-BE Business process Models to understand teh additional functionalities required meeting HER standards. Electronic Data Interchange (EDI), EMR, EHR, HL7.
• Involved in (Master Data Management) MDM to help teh organization wif strategic decision making and process improvements. (streamline data sharing among personnel and departments)
• Used MDM tool to support Master Data Management by removing duplicates, standardizing data (Mass Maintaining), and incorporating rules to eliminate incorrect data and filter data as per requirements.
• Created SQL tables wif referential integrity and developed queries using SQL, SQL*PLUS and PL/SQL.
• Understand teh As Is system and develop teh To Be system concept and also prepare teh System Process Maps.
• Involved in conducting presentations of teh Q/A test results wif analysis to teh stakeholders and users and documented modifications and requirements.
• Worked on multiple FHIR implementations in Provider and Payer domain using FHIR STU3 and R4.
• Designing test scripts for testing of Claims in Development, Integration and production environment.
• Tested teh HL7 File formats received from different Vendors validated teh parsing and Data Loader (BizTalk, SSIS Process) functioning using SQL Statements in teh backend.
• Participated in all phases of teh Facets Extended Enterprise (TM) administrative system implementation including teh planning, designing/building/validation (DBV), and Go-live support phases.
• Assigned tasks among development team, monitored and tracked progress of project following agile methodology.
• Helped design data warehouse solutions and business intelligence dashboards and scorecards.
• Identified teh impacts teh HIPPA 5010 project had on enrollment Claims, FEP (Medicare and Medicaid program). Maintained proper communication wif teh developers ensuring dat teh modifications and requirements were addressed and also monitored these revisions.
• Involved in compatibility testing wif other software programs, hardware, Operating systems and network environments.