Tuesday, April 25, 2006

10:30 am - 11:30 am

Level: Intermediate

Understanding and improving information quality (IQ) almost always involves knowing where data came from, the business (and data quality) rules applied to it, where those rules were applied, and any transformations the data went through. That is, you must understand and document the metadata around data transformations. You will learn how to build an information chain and the many ways the information chain can help you understand and document data lineage, rules, assigning of stewardship, and semantic mapping. A basic metamodel will be presented for recording transformations in a metadata repository, and how to customize the metamodel to add more detail for business rules and the rule application point. You will learn processes to record and implement business rules and how to segregate data that fails the rules. You will also learn the process and cultural implications of implementing rigorous IQ through metadata management. A case study will document actual cost savings and productivity increases from having successfully tracked lineage for data.

• Building the Information Chain
• The value of the Information Chain
• Tracking data lineage across the Information Chain
• Specifying IQ rules
• Examining the metadata that must be recorded and analyzed to understand what happened to the data
• Inspecting the Lineage metamodel

David Plotkin is the Manager of Data Quality for Wells Fargo Consumer Credit Group (CCG), one of the fastest growing companies in Wells Fargo. He has been working with data modeling, metadata and data quality for over 15 years, and has built Metadata management environments in four companies, including the implementation of several corporate repositories. He was the architect/modeler for the complete recreation of Longs pharmacy system using object-oriented technology, including CASE tools, code generation and database generation from models, synchronizing the effort with a third-party software package, and implementing the Metadata management initiative. The effort includes a business rules-driven approach, with the capture of business rules, as well as the automated implementation of parameter-driven business rules. He has built and currently maintains the CCG metadata repository, and is directly responsible for the data quality (and the data quality organization) at Wells Fargo CCG. He is also one of the leaders of the metadata, stewardship, and data quality initiatives at Wells Fargo corporate, serving as a subject matter experts on many topics.