Building a Unified Data Lake for Customer 360 and Real-Time Insights in Insurance

Quick Summary

A mid-market Indian insurance company struggled with siloed systems and duplicate data, hindering reporting and Customer 360. A Data Lake integrating 30+ applications with IBM CDC, DataStage, and SiNGL created a Unique Customer Repository, enabling real-time data, Salesforce integration, and Tableau analytics—resulting in better customer service, simpler reporting, and KPI-driven performance.

About the Customer

Top mid market General Insurance company in India providing Health, Motor, and Commercial Insurance.

Problem Statement

With siloed applications and no central data repository, business users struggled to generate daily reports and key insurance KPIs, relying on manual efforts. Customer data had duplicates and quality issues. As Salesforce was being rolled out across major functions for Customer 360 and lead conversion tracking, the need for unique customer identification and accurate transactional data became critical, but without a single repository these goals couldn’t be met.

Solution

A Data Lake was built to consolidate data from 30+ applications, using IBM CDC and Datastage. Alpharithm’s SiNGL created a Unique Customer Repository with data cleansing and normalization. Data was integrated with Salesforce via REST APIs (T-1 basis) and Tableau enabled analytics and dashboards. IBM RDM managed cross-mapping of masters from functions, GC, and Excel sources.

Business Benefits

Technology

IBM CDC, IBM DataStage and IBM QualityStage, IBM Db2 Warehouse, IBM Reference Data Management, Oracle, SQL Server, MySQL