1 / 12

Intelli-Householding Sample Client (Insurance)

Intelli-Householding Sample Client (Insurance). “CENTRIFY” Customer Household Business. FFIC Database. “CENTRIFY” (Householding) One Unique Key Per Consumer Policy Holder One Unique Key Per Business Policy Holder One Unique Household ID per FFIC Business Rules

tatum
Download Presentation

Intelli-Householding Sample Client (Insurance)

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Intelli-HouseholdingSample Client(Insurance)

  2. “CENTRIFY” • Customer • Household • Business FFIC Database • “CENTRIFY” (Householding) • One Unique Key Per Consumer Policy Holder • One Unique Key Per Business Policy Holder • One Unique Household ID per FFIC Business Rules • Tailor Sensitivity Household Keys for FFIC Intellidyn Householding: Process Flow Stage I Stage II “Hygiened” FFIC Database • Unique Record Id • Customer • Household • Business Populate Missing Values Address History Look up Address Name Verification • Address History Look Up • Historical Address Analysis • 36 Month • 60 Month • Address Name Verification • Corrections • Normalization • USPS Reference • Patterning • Populate Missing Value • Reformat • Correct Concatenation • Analysis of missing value • Business Rule of missing value • Standardization • Unique Record ID • Identification of Unique • Customer • Household • Business • Policy Joins • Key Assign

  3. Case 1 Case 2 Case 3 Case 4 Case 5 Populating Missing Values • Organize Missing Values by Case • Business Rule Definition • Populate Based on Business Rules Case 1 & 2 Case 4 Case 3 Case 5

  4. *Over 18,000 records had missing values, of which we populated almost 60%*Consumer Records Correction of missing information is 59% (10,910 of the 18,441 Records) Before (3,162,572 Records) After (3,162,572 Records) Non-Populated (18,441 Records) Non-Populated (7,531 Records) 0.2% 0.6% 99.4% 99.4% 0.4% Populated (3,144,131Records) “Repaired (10,910 Records) Populated (3,155,041 Records)

  5. Consumer Records With Missing Values Unable to be Populated Missing Name & Address (1 Records) Missing Address (388 Records) Missing Zip (46 Records) 0.2% Missing Name (7,096 Records) 99.8% Populated (3,155,041 Records) Non-Populated (7,531 Records)

  6. Repaired Consumer Records by Populating Missing Values Populated (2,435,901 Records) Repaired (10,910 Records) 10,910 99.6% .4% Repaired missing 1 value (See next page for missing values by year) .2% Non-Populated (7530 Records)

  7. Repaired Consumer Records by Year Repaired 1 Missing Value (8,706 Records) Repaired 1 Missing Value (1,700 Records) Repaired 1 Missing Value (444 Records) Repaired 1 Missing Value (37 Records) Repaired 1 Missing Value (12 Records) Repaired 1 Missing Value (11 Records) 2005 2006 2007 2008 2009 2010

  8. “CENTRIFY” • Customer • Household • Business Client Database • Address History: • Update moves and address changes • Zip & Zip4 Correction • Address Corrections • Nixie Reconciliation Intellidyn Householding: Address History Stage I Stage II “Hygiened” Client Database • Unique Record Id • Customer • Household • Business Populate Missing Values Address History Look up Address Name Verification • Address History Look Up • Historical Address Analysis • 36 Month • 60 Month • Address Name Verification • Corrections • Normalization • USPS Reference • Patterning • Populate Missing Value • Reformat • Correct Concatenation • Analysis of missing value • Business Rule of missing value • Standardization • Unique Record ID • Identification of Unique • Customer • Household • Business • Policy Joins • Key Assign

  9. Intellidyn Householding: Overall Results • “CENTRIFY” • Policy Holder • Household Client Database Consumer 2005 - 2010 Stage II Stage I “Hygiened” Client Database • Unique Record Id • Policy Holder • Household Populate Missing Values Address History Look up Address Name Verification Non-Populated (18,441) Non-Populated (7,531) Input Records 3,162,572 Populated (3,144,131) Populated (3,155,041) Policy Holders (1,325,558 ) Households (658,990) Address Updates (291,460) We found 658,990 households, versus Client’s 889,657 Group ID’s

  10. True Picture of Customer Relationships across Client’s Businesses 48,032 have Auto and Home 148,861 Auto Households 502,971 Home Households 658,990 unique Client households (269 households have all three policy types) 559 have Auto and Fire 4,095 have Home and Fire 58,675 Fire Households There are 658,990 *unique households, using the Client Business Rules and our Householding

  11. The Policies Per Household include renewals and multiple policies per household

  12. Intellidyn Householding: Address Updates

More Related