CCL's clients are a large run-off portfolio originally owned by a large French insurer, and consisting of a variety of different portfolios originally acquired from a number of different original insurers. As part of the conversion process, the data was standardised as much as possible, filling in gaps where they existed.
At the same time, the parent company was going through a process of standardising all its reporting functions throughout its various subsidiaries, both live and run-off, and thus required a common approach to data definitions throughout the organisation. What, for example is Gross Net Premium? Or Net Net Premium?
CCL's approach is to keep the transactional data separate from the reporting data. The Data Warehouse we constructed holds a copy of all the data in the system, but reorganising the data that is necessary for reporting purposes, regardless of its source. It is updated on an overnight basis from transactions that have been processed during the day. The overnight process does not simply relocate the data from one place to another - it constructs all necessary reporting tables.
The Data Warehouse is constructed using a standard Microsoft tool - SQL Server, and has an output that can be printed, or exported to other standard tools such as Excel or Access.
This process allowed our client to have a clear idea of all the insurance assets under its management for the first time, despite all its disparate origins and complex reinsurance arrangements. With the aid of this, the High Court sanctioned a solvent Scheme of Arrangement which allowed a finality to the estate which is currently being worked through.