About the client: Top mid market General Insurance company in India providing Health, Motor, and Commercial Insurance.
Business Challenges: Siloed applications, no central data repository, hence business users were finding it difficult to generate their day-to-day reports, had to perform considerable manual work for generating key insurance specific KPI’s. Actuarial users were finding it difficult to consolidate data and generate their models.

Solution: Data from Core Insurance applications running on AS/400 was replicated in real-time using IBM’s CDC technology on to an Operational Data Store (ODS). IBM’s Data Integration tool was used to process and transform the input data and subsequently populate the Star Schema defined in IBM Db2 warehouse. Key reports and KPI’s were developed in Cognos. Real time availability of data in a central place allowed the Actuarial users to build and test their models with very little effort.

  1. Real-time Visibility: Real-time availability of data from various source systems in ODS with implementation of purpose built data marts
  2. Revenue Growth:
    1. Improved tracking of key KPI’s like Revenue Per Policyholder, Average Cost Per Claim, Loss Ratio, Underwriting Speed.
    2. Implemented Key Predictive Models namely Persistency Report, Customer Churn, Campaign Analytics, Analytics to Predict Surrender
  3. Self-Service: Business Users able to generate their own reports
  4. Operations: Reduced IT intervention
Technology: IBM CDC, IBM Datastage, IBM Db2 Warehouse, IBM Cognos Analytics