Data Quality Analyst Resume
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
ConfidentialResponsibilities:
- 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.