SUMMARY:

• 12 years of overall experience in Data/Information Management and Data Governance Programs in terms of data strategy and technical implementations.
• 12 years in healthcare, working with multiple Payers, Providers and care management organizations.
• Heavily skilled in data management operations including data sourcing/acquisition, data integration, data analytics and data dissemination practices
• Demonstrated experience in Data Governance Methodologies.
• Ability to clearly communicate with technical DBAs to high level business users in their own technical and business terminologies respectively.
• Over 11 years of hands - on experience in Informatica Power Center, Informatica Data Quality (Developer and Analyst), Informatica MDM and Metadata Manager tool suites and their interoperability.
• Demonstrated experience of Column / Advanced Data Profiling and its best practices as a part of Data Quality Assessments.
• Good Knowledge in Translating complex Business rules into implementable set of data rules with Informatica analyst tool for validating data quality/conformity of data to its standards.
• Complex data quality rule and design, development and implementation patterns with cleanse, parse, standardization, validation, scorecard, exception, notification and reporting with ETL and near Real-Time consideration.
• Implemented MDM projects in for payers and providers for analytical and operational purposes with focus on deterministic and probabilistic matching techniques.
• Good understanding of DAMA Data management Principles.
• Demonstrated knowledge in Data enrichment and data verification processes.
• Basic knowledge on with Big Data/Data Lake technologies.
• Good Knowledge on problem solving and decision making (clear thinking) skills.
• Good Knowledge on Data Visualization tools and visualizations.
• Good handle on BPMN design and implementations using Activiti platform.
• Good knowledge of integrating Collibra with other systems using Collibra connect/Mulesoft ESB
• Actively learning Cloud Computing, No SQL and New SQL techolologies.

EXPERTISE AREA:

Data Governance:

• Creating Scope definition and Value proposition
• Creating operating models and communication plans.
• Identify critical data
• Manage business glossary, metadata, standard and system reference data and their relationships.

Data Architecture and Metadata Management:

• Identifying possible source systems (internal/external) of data for mastering/enriching data.
• Documenting technical metadata of data elements in Collibra through Collibra connect integrations or pseudo automatic process.
• Documenting metadata lineage through integrations using the metadata exchange capabilities of the tools.

Data Quality Management

• Identification of business rules and data quality rules for the data elements.
• Performing Data quality assessments using data profiling concepts and tools
• Performing Root Cause Analysis.
• Documenting the Data quality scores in Collibra using integrations with Informatica Data Quality.
• Performing Issue prioritization, Corrective Action Plans and Preventive Action plans to clean up the data.
• Validating the data element against its standard reference data.

Healthcare:

• Designed and implemented an asset model in Collibra for governing Healthcare Measures and analytical products used in the organization.
• Good knowledge on HIPAA, CFR, PHI, PII regulations.
• Designed and supported an operational MDM implementation using Informatica MDM in accordance with DG enforced standardizations with a customized Informatica Party MDM data model.
• Developed standard reference data for most of the provider’s data including specialty, license and EMR specific reference data.
• Designed and architected HEDIS submission initiatives and readmission rates, and built several registries for reporting NQF metrics and risk stratification models.
• Implemented a framework for maintaining Population Health Data.
• Designed and built custom registries with integrated EMR and Population Health data for increased insights.
• Designed and implemented an analytical MDM (non-traditional) for a payors Members involving a massive 18M records to master using Informatica PowerCenter and Developer tools. The matching process is highly hand-coded as per the already existing matching logic using IDQ matching.

TECHNICAL SKILLS:

Data management: Collibra DGC, Informatica Analyst, IBM Info sphere.

ETL: Informatica Power Center, 9.x, Informatica Developer 9.xData Quality: Informatica Developer / Analyst (IDQ), Ataccama Data Quality Analyzer

BI Tools: Tableau, Qlikview, Business Objects XI R3, XcelsiusRelational Databases: MS SQL Server, Teradata, MS SQL Server 2005/2008, Oracle 8i/9i /10gClient Side Skills: SQL, T-SQL, PL/SQL, UNIX shell scripting, KSH

Scheduling Tools: Active Batch

Platforms: Windows NT Server/9x/2000/XP, DOS, MVS & OS390 on IBM MAINFRAME, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, St Louis, MO

Data Governance/Data Quality Analyst

Responsibilities:

• Architected and implemented the Asset model as per data governance operating models in Collibra to serve as an electronic data management platform.
• Contributed to Change management process by designing the corresponding workflows.
• Contributed to Operating guidelines and Data governance principles.
• Design and implement integrations from Collibra to other systems thru Collibra connect.
• Worked with MSOs and HSO to identify the possible data sources for mastering the data.
• Acted as a mediator between the technical and business units in terms of communicating the message/needs from a Data governance perspective.
• Advised and developed standard reference data incorporating business/technical perspectives.
• Created and implemented custom asset model in Collibra for governing BJC measures and reports.
• Designed a framework for providing trust score to the data elements.
• Profiled the source systems and mapped the code values to standard reference data code values which will be replicated as “Cleanse Lists” in MDM.
• Set up Data Profile and Scorecards using Informatica Developer Tool to monitor the quality of data, as a part of the Data Governance initiative.
• Perform effort estimation and planning for the data integration and data quality activities.
• Performed UAT for MDM implementation through IDD portal.
• Designed a pseudo-automatic integration process to integrate Data governance portal with MDM hub for enforcing certain Data Governance standards.

Confidential, Peoria, IL

IT Tech Lead

Responsibilities:

• Propose a BI initiative for the customers’ business needs.
• Enhance the existing EDW to make it more robust and user friendly in terms of Metadata Management and Data Security.
• Work with data analyst and define (business) data rules.
• Build subject area marts for dashboard requirements using PowerCenter/Teradata/Qlikview platforms.
• Handle customer data management initiatives using Informatica platform.
• Set up Data Profile and Scorecards using Informatica Developer Tool to monitor the quality of data, as a part of the Data Governance initiative.
• Perform effort estimation and planning for the data integration and data quality activities.
• Prepare the logical design, process flow diagrams and detailed technical design documents.
• Act as a single point of contact for the offshore resources.
• Perform code review, unit testing and validation of test results.
• Provide UAT support and production deployment.

Confidential, Des Moines, IA

IT Tech Lead

Responsibilities:

• Worked with Business Analyst to define (business) data rules.
• Set up Data Profile and Scorecards.
• Analyzed the matching algorithms and shared the results with the business owners to validate them, and fine-tuned the matching rules.
• Provided effort estimation and planning for the data integration and data quality activities.
• Prepared the logical design, process flow diagrams and detailed technical design documents.
• Coded the Informatica PowerCenter and IDQ components.
• Served as the single point of contact for the offshore resources.
• Performed code review, unit testing and validation of test results.
• Provided UAT support and production deployment.

Confidential, White Plains, NY

Data Quality Lead - Consultant

Responsibilities:

• Worked with Data Analyst and define (business) data rules.
• Set up Data Profile and scorecards.
• Analyzed the root cause of the issue.
• Performed effort estimation and planning.
• Coded the Informatica components.
• Ensured production support and monitoring.

DW Technical Lead

Confidential

Responsibilities:

• Analyzed the business requirement.
• Prepared the Technical Design Document.
• Coded the Informatica components.
• Established reusability in code for increased productivity.
• Performed unit testing and documentation.
• Scheduled the jobs.
• Ensured production support and monitoring.
• Transitioned to lights-on team for technical support.

ETL Technical Lead

Confidential

Responsibilities:

• Analyzed the business requirement.
• Prepared the Technical Design Document.
• Performed Data modeling for the newly created reporting database.
• Coded the Informatica components and Business Objects WeBI reports.
• Established reusability among code for increasing productivity.
• Performed unit testing and documentation.
• Scheduled the jobs.
• Ensured production support and monitoring.
• Transitioned to lights- on team for technical support.

Confidential, CA

Technical Lead

Responsibilities:

• Guided the Informatica team of six in technical and business aspects.
• Interacted with onsite team, gathered requirements and shared with offshore team.
• Mentored the entry level trainees in the project.
• Prepared Technical Design Documents, Analysis and Approach Documents.
• Prepared Low Level Design Documents.
• Coded and tested as per the requirements.
• Tested and recorded the unit test results.
• Prepared a system integration test plan preparation.
• Provided UAT support and code deployment.
• Ensured warranty support.

Technical Lead

Confidential

Responsibilities:

• Served as CC (Configuration Controller) role in the project.
• Involved in performance optimization of ETL mappings.
• Analyzed the root cause for the long running mappings.
• Redesigned, developed, and performed unit test, and system test and implemented in production environment the modified mappings to reduce the batch window.
• Prepared design document, UTC, STC, Deployment Document.
• Prepared the Technical Design Documents, Analysis and Approach Documents.
• Prepared Low Level Design Documents.
• Coded and tested per the requirements.
• Tested and recorded the test results.
• Involved in test case preparation for system integration testing and unit testing.
• Involved in system testing and documenting the System Test Results (STR).
• Provided production warranty support.

Technical Lead

Confidential

Responsibilities:

• Took the role of DPC in the team.
• Served as offshore ETL Developer.
• Actively involved in design, development, unit testing, system testing and implementation.
• Modified the existing code to meet the new requirements.
• Performed debugging and testing.
• Determined the permanent fix for the issue logs.
• Prepared Technical Design Documents, Analysis and Approach Documents.
• Prepared Low Level Design Documents.
• Coded and tested as per the requirements.
• Tested and recorded the test results.
• Involved in test case preparation for system integration testing and unit testing.
• Involved in system testing and documenting the System Test Results (STR).
• Provided warranty support.

Senior ETL Developer

Confidential

Responsibilities:

• Actively involved in design, development, unit testing, system testing and implementation.
• Modified the existing code to meet the new requirements.
• Prepared Technical Design Documents, Analysis and Approach Documents, and Low Level Design Documents.
• Performed coding and testing and documentation of the test results.
• Involved in test case preparation for system integration and unit testing.
• Performed system testing and documented the System Test Results (STR).
• Performed warranty support.

ETL Developer

Confidential

Responsibilities:

• Actively involved in Design, Development, Unit Testing, System Testing and Implementation.
• Modifying the existing code to meet the new requirements.
• Debugging and testing.
• Prepared documentation.
• Coded and tested as per the requirements.
• Worked on test case preparation.