Regional P&C Insurer · Insurance · Columbus, OH · 13 weeks
Claims data unified across 4 legacy systems
A regional property and casualty insurer struggled with claims data scattered across four legacy systems, lacking a common policy ID. This prevented them from assembling training data, stalling their AI underwriting project for 18 months. We consolidated the claims data into a unified foundation in 13 weeks, enabling the AI initiative to launch six weeks after.
Challenge
The insurer bought two smaller carriers over eight years but never merged their claims systems. Each system had its own policy numbers, loss codes, and date formats. The data science team spent 18 months trying to build a usable training dataset and failed twice.
Outcome
We consolidated 1.2 million policy records from four separate systems into a single claims data foundation. Six weeks after delivery, we launched the AI underwriting model, which went live within the next quarter. This work increased loss ratio reporting accuracy from 71% to 97% by aligning data across systems.
Results
- 1.2M Policy records unified across 4 systems
- $8.4M AI underwriting initiative unblocked
- 71% to 97% Loss ratio reporting accuracy
- 6 weeks Time from delivery to AI initiative launch
Our data science team worked for 18 months on creating a training dataset for the AI underwriting model and ran into dead ends twice. Thinklytics pulled all our claims data together in 13 weeks, and we rolled out the model six weeks later. It’s up and running now.