We provide IT Staff Augmentation Services!

Data Quality Analyst Resume

4.00/5 (Submit Your Rating)

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.

TECHNICAL SKILLS

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

ETL: Informatica Power Center, 9.x, Informatica Developer 9.x

Data Quality: Informatica Developer / Analyst (IDQ), Ataccama Data Quality Analyzer

BI Tools: Tableau, Qlikview, Business Objects XI R3, Xcelsius, Relational

Databases: MS SQL Server, Teradata, MS SQL Server 2005/2008, Oracle 8i/9i /10g, Client

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

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 Confidential 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

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

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

Data Quality Lead

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

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.

We'd love your feedback!