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
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