Köln.Assekuranz Agentur: Data Warehouse
Enhanced requirements for business analysis at Köln.Assekuranz
As a next step, after implementing the new agency system, Köln.Assekuranz planned a solution for its reporting requirements that conforms to the regulatory requirements of MaRisk(VA):
- Statutory reporting requirements (BaFin):
Meeting statutory information requirements on the status of the operational insurance business including claims.
- Group reporting within Munich Re:
Automated preparation of monthly, quarterly and annual reports as input for the Group’s annual financial statement.
- Historical business analysis:
Option for business analysis with a tamper proof audit trail to freely select evaluation and observation times based on a scheduled database.
- Reference data model:
To guarantee the security of the investment and the expandability of the new data warehouse under preparation, the database should be developed on the basis of the mgm DWH reference model for insurance companies.
- Cost efficient implementation:
The implementation costs should stay within the low range of six figures.
Implementation based upon the mgm data warehouse
The implementation of the data warehouse by mgm consists of the following components:
- Data model:
mgm data warehouse reference model
- Data warehouse:
- Analysis database:
Oracle, MS SQL Server
- Data extraction and mapping:
Pentaho Data Integration/Kettle
One core area was mapping the data of Köln.Assekuranz to the data warehouse and the presentation of the reports. “Our solution allows the user to view their business over the course of time using just a few clicks. In terms of the presentation we adjust almost in fully to the sort presentation used by the company,” explains Birgit Becker, Project Manager at mgm technology partners.
Data quality creates trust
After the technical implementation of the data warehouse the intensive commissioning phase started, or to be more precise, of the challenge of establishing trust in the figures within the KA staff. For this purpose, mainly colleagues from project Köln.Assekuranz meticulously checked all the numbers.
In addition, individual data had to be traced at field level on its way between the source system and data warehouse, between the data warehouse and analysis database and between the analysis database and reporting system.
The first report with error-free data could only be prepared in November 2009, after every proof concerning the accuracy of the data had been established.
One particularly attractive feature of the reports generated is that they almost completely meet BaFin and Munich Re’s ergonomic and optic standards.
Other Advantages have been created for customers accessing reports via the KA customer portal (alternatively via email) by using the business data in a better way.
“The whole team committed itself to the goal set of going live within three months,” said Alexander Ruppel, Head of Controlling at Köln.Assekuranz, assessing the joint project work. “With the first stage of extension of our data warehouse we can carry out our reporting in a fraction of the time previously needed.”
* This reference has been officially confirmed by Köln.Assekuranz.
“With the first stage of extension of our data warehouse we can carry out our reporting in a fraction of the time previously needed.”
Head of Controlling at KA Köln.Assekuranz Agentur
Reference Koeln.Assekuranz DWH PDF