About the client: These 3 clients are in the mid market Life Insurance and General Insurance segment in India providing Health, Security, Savings and Wealth products.
Business Challenges: Clients wanted to deliver near real-time reporting of their Insurance business to the management. However the Core Insurance applications built on legacy platforms couldn’t’t cater to this requirement, resulting in reports delivered late by up to 48 hours. Additionally there were a host of satellite applications catering to needs of various Channels who data was required on real-time basis.
Solution: Data from Core Insurance applications running on AS/400 along with data from Satellite applications were replicated in real-time using IBM’s CDC technology to a Operational Data Store (ODS).
This new platform:
  • Reduced the overhead on the Operational system (AS/400)
  • Delivered central repository of enterprise data
  • Enabled intra day operational reporting
  • Supported downstream application requirements without impacting the source
  • Revenue Growth:Improved revenue with real-time data availability for Operational BI
  • Cost Savings:Improved Customer Retention, Reduced Churn, Reduced IT spending on Source system upgrades, Reduced data management costs, Reduced batch window from hours to minutes
  • Risk: Reduced the risk of the Operational system going down
Technology: Change Data Capture (IBM CDC)
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.
  • Real-time Visibility:Real-time availability of data from various source systems in ODS with implementation of purpose built data marts
  • Revenue Growth:
    • Improved tracking of key KPI’s like Revenue Per Policyholder, Average Cost Per Claim, Loss Ratio, Underwriting Speed.
    • Implemented Key Predictive Models namely Persistency Report, Customer Churn, Campaign Analytics, Analytics to Predict Surrender
  • Self-Service: Business Users able to generate their own reports
  • Operations : Reduced IT dependency
Technology: IBM CDC, IBM DataStage, IBM Db2 Warehouse, IBM Cognos Analytics