Consumer Awareness

1
Importance of Data Quality
April 21, 2004
2
Agenda

• Uses Benefits of Data
• Elements of Quality
• IBC Data Quality Safeguards
• Metrics
• Data Quality Improvement Tools
• Incorporating Quality into Design
• Questions

3
Uses and Benefits of Data

• Provide Industry Analysis
• Identify Emerging Industry Issues
• Support Lobbying Efforts
• Fraud Investigation
• Government Rate Filing
• Company - Business Decisions
• Product, Pricing, Market

4
Elements of Quality

• Validity/Consistency
• Completeness
• Timeliness
• Accuracy
• Meets the needs of the business!

5
IBC Data Quality Safeguards

• Business Logic / Editing
• Testing Facility
• Trending Analysis
• Tools Reports
• Deficiency Fees
• Dedicated IBC Resources
• Data Quality Management

6
IBC Data Quality Safeguards

• Accountability
• Visibility
• CEO Data Quality Report
• Data Accuracy Profiles
• Compare to Related Data Reporting
• Compare to External Sources

7
IBC Data Quality Safeguards

• Compare to Financial Statements
• CFO Sign-Off
• Internal Actuarial Review
• External Actuarial Review
• Regulator Review
• Compare to Rate Filing

8
Error Management
Data Accuracy
DataSubmission
Submission Management
SNA FTP
Errors
EDIT
Valid Data
AccuracyAnalysis
Products Services
9
Data Quality Management Team

• Vice President
• Manager Data Collection Quality
• Data Quality Specialist 1
• Data Quality Analysts 5
• Data Entry Staff 2
• Manager Data Accuracy
• Data Accuracy Analysts 3

10
Metrics

• 200 Active Reporting Companies
• 6 Statistical Plans
• 3 Reporting Types per Plan
• 1,400 Data Submissions per Week
• 150 Million Data Records per Year
• 1.6 of Records have Errors
• 2 Million Records Corrected per Year

11
2003 Data Metrics

• All Submitted Data
• Personal Lines
• Commercial Liability
• Commercial Property
• OSABSP
• Automobile
• Facility Automobile

• 98.38
• 99.87
• 98.40
• 99.71
• 91.91
• 98.58
• 91.76

12
Metrics

• 3,200 Pages - Stat Plan Documentation
• 1,500 Pages for Automobile
• 10 User or Reference Manuals
• 5 Web Applications
• 1,330 Active User IDs
• 2,000 Client Interactions per Week

13
D. Q. Improvement Tools

• Documentation
• Statistical Plan Manuals
• Edit Rules Documentation
• Application User Manuals
• Reference Manuals
• Communication
• Data Quality Bulletins
• Tips Emails

14
D. Q. Improvement Tools

• Meetings
• Error Correction Training
• Statistical Plan Coding Seminars
• Status Meetings
• Annual Data Quality Forum
• Deficiency Fees
• Monthly Invoice
• Detail Reports (showing counts, aging, etc.)

15
D. Q. Improvement Tools

• Reports
• Submission Confirmation Email
• Greensheets Error Listings
• Monthly Status Reports
• UV Accuracy Reports
• OSAB Database
• Ad-hoc Reports
• CEO Data Quality Report

16
CEO Data Quality Report
17
(No Transcript)
18
(No Transcript)
19
(No Transcript)
20
D. Q. Improvement Tools

• Analysis
• Submission Process
• Data Trending
• Data Accuracy
• Completeness Checking
• Annual Balance Reconciliation
• OSABSP to ASP Balancing

21
D. Q. Improvement Tools

• Website
• Library of Communications/Bulletins
• Application Description Information
• Frequently Asked Questions
• Links to Data Quality Applications
• All User Reference Manuals

22
D. Q. Improvement Tools

• 5 Web Applications
• Prime gt Pre-Edit Testing
• SMART gt Submission Management
• Expert gt Error Management
• EEC gt Error Correction
• EVC gt VIN Correction

23
Error Management
Data Quality
DataSubmission
Submission Management

• EXPERT

• SMART

• PRIME

• EEC

• EVC

SNA FTP
Errors
EDIT
Valid Data
AccuracyAnalysis
Products Services
24
PRIME

• Streamline Testing Process
• Automate Detection of Data Mapping Errors
• Identify Required Changes to Company Programs or
  Translation Tables
• Information provided
• Batch Structure Errors
• Error Volume
• Error Code Frequency
• Detail Record Download

25
(No Transcript)
26
(No Transcript)
27
(No Transcript)
28
(No Transcript)
29
(No Transcript)
30
(No Transcript)
31
(No Transcript)
32
(No Transcript)
33
SMART

• Coordinate Submission Management
• On-Line Reconciliation to Confirm Balances
• Provides Summary Detail Submission Information
• Allows users to
• Ensure Completeness
• Identify Submission Abnormalities

34
(No Transcript)
35
(No Transcript)
36
(No Transcript)
37
(No Transcript)
38
(No Transcript)
39
EXPERT

• Coordinate Error Management Process
• Flexible Search Criteria
• Enables User to Identify Trends
• Information provided
• Most Frequent Errors
• First Time Errors
• Repeat Errors
• Error Correction Volume
• Number of Outstanding Errors

40
(No Transcript)
41
(No Transcript)
42
(No Transcript)
43
(No Transcript)
44
(No Transcript)
45
EEC

• Streamline Error Correction Process
• On-Line Access to Correct Errors
• Refreshed Daily
• Allows users to
• Improve Timeliness of Error Correction
• Improve Productivity Through Bulk Correction
• Reduce Paper and Courier Fees
• Reduce Deficiency Fees

46
(No Transcript)
47
(No Transcript)
48
(No Transcript)
49

• Questions?