Success StoryBreaking Silos, Building Single Source Of Truth For Claims Analytics

A leading personal lines insurance company struggled with their legacy data ecosystem that was built on multiple on-premises technologies. They were looking for a modern, unified data model that could improve their BI and reporting, so they approached Exavalu.

 

 

Challenge

1

Working with the legacy data ecosystem had become difficult for our client. Data silos and the absence of data governance constrained their reporting capability.

2

They did not have a single source of truth to rely on. Their diverse tech stacks further resulted in higher maintenance costs.

The Difference Exavalu Delivered

  • Exavalu adopted a collaborative and phased approach to help them transition from their existing data architecture to AWS.
  • We created a unified data model to streamline their BI reporting and developed a data lakehouse using S3 and Redshift for BI consumption. We replaced ETL pipelines with AWS Glue, Lambda, and PySpark. And finally, we leveraged AWS analytics and machine learning capabilities to enhance their business insights.

Tech Stack

  • AWSS3
  • Glue
  • PySpark
  • Redshift
  • Cloudera
  • SQL Server
  • Informatica
  • Guidewire CDA

Benefits

1

Claims, Policy, and Billing Centers: 3+ subject areas, covering Claims, Policy, and Billing Centers

2

Cloudera on-premises Migration: 1800+ entities migrated from Cloudera on-premises

3

Legacy Processes Replacement: 300+ ETL jobs were discovered replacing SSIS, Sqoop, and Informatica processes

4

Improved Insight Generation: With faster data processing

5

Reduced Maintenance Costs: Using modern cloud infrastructure and simplified tech stack

Key Highlights

1

3+ subject areas

Covering Claims, Policy, and Billing Centers

2

1800+ entities

Migrated from Cloudera on-premises

3

300+ ETL jobs

Replacing legacy SSIS, Sqoop, and Informatica processes