Case Study: Successful Integration of Data Quality Analysis in an OLTP Project

Jodie Henderson
DQ Analyst-Application Engineer 5
Wells Fargo Bank

Thursday 1:00pm - 2:00pm

Level: Basic/Introductory

The classic DQ implementation model is primarily focused on the paradigm of applying DQ Analysis & Processing to the movement of large quantities of data from a source system--via extract data, control, and audit files--through various staging areas, to a target database or data mart. Most of the time, though, OLTP SOR's are the initial point of entry for this data...and any of its inherent quality issues.

This case study will address the following questions:

1. How do we proactively build data quality into the development life cycle of an OLTP system?
2. How can the Data Quality Analyst establish a strong presence and a clear and valued role within the greater data design, modeling, and development teams?
3. How do the fundamental concepts of data integrity and audit trail apply to data movement in an OLTP System?
4. What are some real-life examples of issues uncovered via DQ Analysis of transactional data interfaces?
5. And, finally, how do you successfully market the DQ role and communicate the value-add and distinction of DQ testing vs. traditional QA testing in an OLTP development life-cycle?

Jodie has over 15 years of full life cycle Oracle database application development experience, including data modeling, database architecture & design, ETL programming and application development, data analysis & decision support. This broad development experience, built upon the foundation of a Mechanical Engineering degree, and enriched by some creative guerilla marketing skills, uniquely qualified her for her current position as a Lead Data Quality Analyst for a large banking institution.