Over the last 10 years we have been involved in over 40 successful data warehouse implementations for a wide range of Lloyd’s, London market and general insurance entities. This experience and track record culminated in 2009 in the development of our Insurance Framework.
The Framework is an established model and set of processes for managing data through structured stages of warehouse development to deliver core management information and KPIs. The Framework consists of proven market leading components supporting best practice principles and provides a solid and reliable base for handling data across the organisation. The Framework integrates with existing source systems and allows users to quickly and easily slice, dice and drill down into data.
The Framework helps to reduce the risk inherent in delivering these solutions by providing a core set of capabilities for operational reporting, analytics and business-focused dashboards. These core capabilities cover a number of functional areas, including policy/risk, claims, outwards R/I, earned premium, budgets/benchmarks, reserves, and can be extended to incorporate financial and regulatory reporting.
The Framework has been designed as a composite data model, applicable to all types of insurance organisations, whether broker, underwriter or reinsurer and regardless of product line or market. Furthermore, it has been tailored to cater specifically for the composite insurer who operates across multiple markets with multiple product lines.