![](\"https:\/\/referenzen.mgm-tp.com\/wp-content\/uploads\/KAssekuranz.png\")
Enhanced requirements for business analysis at K\u00f6ln.Assekuranz<\/h3>\n
As a next step, after implementing the new agency system, K\u00f6ln.Assekuranz planned a solution for its reporting requirements that conforms to the regulatory requirements of MaRisk(VA):<\/p>\n
<\/p>\n
- \n
- Statutory reporting requirements (BaFin):<\/strong>
\nMeeting statutory information requirements on the status of the operational insurance business including claims.<\/li>\n- Group reporting within Munich Re:<\/strong>
\nAutomated preparation of monthly, quarterly and annual reports as input for the Group\u2019s annual financial statement.<\/li>\n- Historical business analysis:<\/strong>
\nOption for business analysis with a tamper proof audit trail to freely select evaluation and observation times based on a scheduled database.<\/li>\n- Reference data model:<\/strong>
\nTo 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.<\/li>\n- Cost efficient implementation:<\/strong>
\nThe implementation costs should stay within the low range of six figures.<\/li>\n<\/ul>\nBased on these requirements, a joint team of the customer\u2019s experts and mgm\u2019s actuaries and engineers conceived a solution. The mgm reference model for insurance companies was selected as the technical basis for this. Starting with the operational business information of the agency system and other neighbouring systems, a historical standardized database was developed serving as a data source providing a tamper proof audit trail for defined reporting (single point of truth).<\/p>\n
Implementation based upon the mgm data warehouse<\/h3>\n
The implementation of the data warehouse by mgm consists of the following components:<\/p>\n
<\/p>\n
- \n
- Data model:
\n<\/strong>mgm data warehouse reference model<\/li>\n- Data warehouse:
\n<\/strong>Oracle<\/li>\n- Analysis data base:
\n<\/strong>Oracle, MS SQL Server<\/li>\n- Data extraction and mapping:
\n<\/strong>Pentaho Data Integration\/Kettle<\/li>\n- Reporting:
\n<\/strong>MS SQL-Reporting<\/li>\n<\/ul>\nOne core area was mapping the data of K\u00f6ln.Assekuranz to the data warehouse and the presentation of the reports.<\/p>\n
\u201cOur 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 of presentation used by the company.\u201d explains Birgit Becker, project manager at mgm technology partners.<\/p>\n
Data quality creates trust<\/h3>\n
After the technical implementation of the data warehouse the intensive commissioning phase started, or to be more precise, the challenge of establishing trust in the figures within the KA staff. For this purpose, mainly colleagues from project K\u00f6ln.Assekuranz meticulously checked all the numbers.
\nIn addition, individual data had to be traced at field level on its way between the source system and data ware-house, between the data warehouse and analysis database and between the analysis database and reporting system.
\nThe 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.
\nOne particularly attractive feature of the reports generated is that they almost completely meet BaFin and Munich Re\u2019s ergonomic and optic standards.
\nOther advantages have been created for customers accessing reports via the KA customer portal (alternatively via e-mail) by using the business data in a better way.<\/p>\nConclusion<\/h3>\n
\u201cThe whole team committed itself to the set goal of going live within three months.\u201d said Alexander Ruppel, Head of Controlling at K\u00f6ln.Assekuranz, assessing the joint project work. \u201cWith the first stage of extension of our data warehouse we can carry out our reporting in a fraction of the time previously needed.\u201d<\/p>\n
<\/p>\n
*\u00a0 This reference has been officially confirmed by K\u00f6ln.Assekuranz.<\/p>\n
[\/et_pb_text][\/et_pb_column][et_pb_column type=”1_3″][et_pb_text use_border_color=”off” module_class=”sidebar” background_position=”top_left” background_repeat=”repeat” background_size=”initial” _builder_version=”3.1.1″]<\/p>\n
![\"\"](\"https:\/\/referenzen.mgm-tp.com\/wp-content\/uploads\/2019\/02\/KA_Koeln_Assekuranz_LogoKasten-300x300.png\")
<\/p>\nK\u00f6ln.Assekuranz-Agentur started operations as a 100% subsidiary of Munich Re on 1 October 2007. It is a nationally and internationally active underwriting agency for industrial risks and a specialist in the transport and group accident insurance classes.<\/p>\n
<\/p>\n
![](\"https:\/\/referenzen.mgm-tp.com\/wp-content\/uploads\/Assekuranz2-Zitatbild.png\")
<\/p>\n - Data warehouse:
- Group reporting within Munich Re:<\/strong>
![](\"https:\/\/referenzen.mgm-tp.com\/wp-content\/uploads\/KA-DataWarehouse-Download-1.png\")