Information InnovationPeople’s Choice Award

Denise J. LyonData Governance Program – Initiation and

Ongoing Enhancement

WellmarkSeptember 2010

Agenda

• About Wellmark• Initiative for People’s Choice Award• Relevance• Timeline• Innovation• Impact• Metrics• Maturity

2

About Wellmark

Wellmark Blue Cross and Blue Shield

• A mutual insurance company owned by its policyholders which allows us to make decisions in the best interest of our members

• Targets a minimal operating margin to keep health care insurance cost increases as low as possible

• Mission is to provide a broad array of high quality, accessible, affordable, and cost competitive health insurance products and services

• Serves over two million members with around 2000 employees in Iowa and South Dakota

Data Governance Program – Initiation and Enhancement

To develop a system of accountabilities, standards, and processes that will support consistent and secure use of quality data in the delivery of accurate and reliable information to our customers and stakeholders.

To provide support from a cross-functional program that takes an enterprise view of data concerns and choices.

WHAT??

WHY??

Data Governance Program – Relevance

data……are of high quality if they are fit for their intended use in operations, decision-making, and planning.

(Juran, 1964)

Data Governance Program – Relevance

6

Data Governance Program – Timeline

• Identified Data Stewards

• Drafted Program Charter

• Prioritized 2008 deliverables related to Critical Success Factors

• Completed 8 deliverables in support of Critical Success Factors

• Established Data Governance Work Zone on intranet

• Added contributions of a Data Steward to their Performance Evaluations

• Began capturing metrics for data quality improvement

• Formalized decision-making process

• Expanded membership of Data Stewards

• Conducted assessment of Data Governance Program

• Standards under development: Business Metadata Data Quality

Management• Ongoing metrics resulting

in improved data quality

2008 2009 20107 – 12/07

Data Governance Program – Innovation

People

Data Stewards of Business Data:•Definer•Creator•Consumer

Data Analysts:•Profiler•Documenter•Translator

Process•Roles & Responsibilities•Meeting & Communication•Monitoring & Tracking

• Issue Escalation & Resolution

Standards•Data Profiling•Data Quality Management•Metadata•Data Stewardship

Technology

•Metadata Tools•Data Quality Tools•Data Profiling Tools•Data Mapping Tools•Tracking Tools•BI Applications

DATA QUALITY

Data Governance Program – Impact

• Created logical names and descriptions for 7,311 data attributes from 206 source files/tables

• Approved 294 acronyms and 463 abbreviations for use• Decreased errors of incoming pharmacy claims data from 9.9%

(124,000/1,250,000) in November 2008 to 0.13% (1663/1,276,236) in June 2010

• Monitor file exchanges with vendors who provide services to our members

• Updated metadata – business and technical reference

Intangible…• Improved relationship between IT and business• Proactive consideration of data governance in projects

Data Governance Program – Metrics

Data Governance Program – Maturity

11

Wellmark’s Data Governance Program