Regulatory Authority
Data warehouse system landscape using the Data Vault approach with OLAP components
Starting point
A regulatory authority with approximately 400 insurance companies requires an information system with:
- A consolidated reporting system at a "Single Point of Truth"
- Assurance of data integrity throughout the entire processing workflow
- Automated processing of the reporting data from the insurance companies
Procedure
- Agile project management with multiple development iterations (sprints)
- Architecture & design
- Requirements management
- Implementation
- Test management
- Support for commissioning
Features/Project outcome
- Enabling content control and historical comparability of the reporting data
- Automated forwarding of the reporting data to the overarching European regulatory authority within fixed reporting cycles
- Semi-automated generation of a data warehouse system landscape using the relational Data Vault approach and OLAP cubes based on an XBRL metadata description
Customer benefits
- High transparency regarding the development of business figures for insurers within the framework of regulatory requirements
- Efficient and timely execution of control activities without disruptions between systems
- Cost reduction and error minimisation through maximum automation and avoidance of manual steps
- Unified, consolidated data foundation for managing the control process
- Quick identification of discrepancies through guided and ad-hoc analyses, as well as KPI monitoring
Vincent Fourmi | Member of Executive Board