Short description:

Implementation of transaction balance sheet reports for risk management in the area of mortgaging. Enhancement of an existing data warehouse to include a reporting function using Oracle Reports. The reports can be generated for various organizational views.


The transaction balance sheet reports are based on a data warehouse that is implemented as an Oracle database. Oracle Reports and PL/SQL are used for the implementation.

Technical description:

The risk management system that was designed as a data warehouse is enhanced to include an additional reporting function. This can be used to output transaction balance reports that offer a series of options for displaying the existing credit risk of specific mortgages. The reporting function is mainly used for controlling by higher-level organizational units. One core aspect of the investigation, besides presenting the data at the organizational level, is to take into account changing responsibilities at the level of individual customers. The reports are always based on month closing dates and they are always displayed by quarter.