Data platform msg.ORRP – integrated and transparent view of data

For back-office tasks in banking, transparent and comprehensible data are the central building block for all further analyses and evaluations. The various subject areas such as regulatory reporting, risk management or controlling all have the basic requirement that the associated analyses require a consistent and at the same time technically correct mapping of all asset/liability and off-balance sheet transactions.

Key challenges for a data platform

A fundamental distinction can be made between basic requirements for a data repository and special and complex additional requirements depending on the data use or specialist process (e.g. risk analyses for interest rate or liquidity management or regulatory reports such as FinRep, IRRBB or LCR/NSFR):

Basic requirements:

• Consistent data management for the various subject areas such as risk management or regulatory reporting
• Traceability of data flows via data lineage
• Central data correction options so that data corrections can be implemented consistently across the board.

Complex additional requirements:

• Depending on the view, different special information must be made available from common basic data (e.g. different cash flow views for interest rate risk reports and liquidity reports).
• Depending on the evaluation, planned transactions must also be taken into account in addition to existing transactions. A uniform view of planning assumptions and planned transactions must be created for each scenario.
• It must be possible to combine all evaluations into consistent overall scenarios and overall evaluations.

Making complexity manageable

The new msg.ORRP data platform meets both basic and additional requirements. In order to master this high level of complexity, both a very high level of specialist expertise and a very high level of IT expertise have been incorporated into the development of the platform, so that end users can conveniently carry out their specialist processes on a transparent database.

The following graphic gives an impression of the future complexity and variety of topics:

Central to msg.ORRP is a 3-layer system, so that all databases and simulations are transparently comprehensible:

1. Data provision and data analysis:

All data are made available to the specialist processes centrally in the data platform. The data can be analyzed using a data browser. These are provided as reports.

These can be individually defined using report configurations (“What should be displayed?”) and report views (“How should it be displayed?”). For example, it is possible to flexibly compile drill-down levels, key figure selection and aggregation rules.

The modern data storage in msg.ORRP and the associated data access are optimized for a high-performance drill-down. Convenient drill-downs down to individual transaction level can be displayed flexibly and with high performance.

2. Carrying out simulations and analyses:

All specialist processes can then be called up independently or simultaneously and used for different evaluations. For example, integrated overall bank scenarios can be calculated that are based on the same scenario assumptions for all risk types (e.g. interest rate development, default rate development). Complex regulatory reports, such as the IRRBB regulatory reports, which require data from several simulations and evaluations, can also be generated as standard using a batch routine/rule simulation.

3. Compact reporting of results:

The platform flexibly supports the merging of different evaluations, simulations and specialist processes. This means that complex issues can be presented simply and transparently to management in compact reports – with a focus on the central KPIs. The reports can be created flexibly and conveniently in the bank’s individual reporting tools (e.g. PowerBI, SAP SAC, TABLEAU). The following graphic shows how the key KPIs for the institution can be presented in compact form from various risk simulations.

msg.ORRP therefore makes it possible to generate highly complex simulations and regulatory reports conveniently and transparently. Thanks to the wide range of predefined reports and automated simulations, deputies in the specialist departments can also analyze and validate the results relatively easily – without the need for extensive training in the specialist departments.