To produce a consistent reporting package of earnings and claims experience
to assist in the negotiation of contracts with Reinsurers.
The client needed to have a standard, easily accessible way to calculate and produce earnings,
loss ratios, claims experience, loss triangles and other data required by reinsurers during
the annual contract negotiation.
The client operates with a fairly small staff that do not have the time or the skills needed
to obtain the information required.
Implement some OLAP Analysis cubes to collate and calculate the required information from the client's
in-house web based Insurance management system.
Build parameter driven Reporting Services reports over the source system and the cubes so that the
users can easily run the reports over the time frames required to obtain the needed information.
- Integration Services packages to bring data from the source system into an Operational Data Store.
- Analysis Services cubes to allow calculation, transformation and storage of the data over time.
- Reporting Services reports that can be run using different parameters that provide a standard, fast
way of retrieving and presenting the data for the renewal negotiation.