Success Stories
Data warehousing for a P&C Insurance Company
Customer
The customer is a leading Fortune 200 P&C insurer in North America, offering a wide range of products in P&C and life insurance, besides operating a large retail bank, credit union and investment services.
Business Context
The customer has two data warehouse applications. One for maintaining the history of underwriting data and provide useful information to the underwriters and users of actuarial services. A second warehouse was an enterprise needs based sales and service system. These were running on old platforms that were increasingly becoming expensive to operate. The customer wanted to move these important applications to a newer platform.
Solution Objectives
HCL provided an offshore-onsite based solution in phases that smoothly moved these critical data-warehouses to an IBM platform from Tandem.
Business Benefits
This solution was delivered in record time and helped the customer save millions of dollars in license renewal fees and maintenance costs on Tandem. Through the use of reusable components to convert code, the solution was developed faster and enabled easier and more comprehensive testing. The resulting data-warehouse enabled the client perform important analysis on policy data for top and middle management.












