This IT project is part of our digitalization and optimization of our customers’ IT landscape. Through targeted measures, we promote technological progress, optimize cross-system processes and create a sustainable basis for future developments. Our IT reference projects serve as a basis for orientation. They support the reusability of tried and tested concepts as part of project implementation.
This is one of 4822 IT projects that we have successfully completed with our customers.How can we support you?
Risk Management II
Project duration: 2 years
Brief description
Development of new and further development of existing tables and procedures for filling a data warehouse for quality assurance in mortgaging. Development of database queries for risk analysis, reporting and downstream systems. Execution of production safeguarding measures.
Supplement
The data warehouse is designed as an Oracle database and is located on a decentralized server. The data involved is monthly closing levels stored in the database as what are known as time slices. Procedures for filling the database and providing data are implemented in PL/SQL. These can be executed individually or in batch operation. Data to be exchanged with other systems is extracted to sequential text files and transferred via FTP. The Discoverer, Oracle Reports and Oracle Graphics tools, in particular, are used for analysis and reporting.
Subject description
The risk management system is an information system for business analysis and reporting in the field of mortgaging. Each month, data is collected from a variety of inventory systems and operational systems based on different technologies; this data is used to fill the data warehouse. Evaluations that are based on the data warehouse are used for controlling and risk analysis of the real estate portfolio, as well as adjusting the portfolio, and for making data available to other systems (e.g. the property renovation area). Consequently, the risk management system forms the general data basis and source of information for the mortgaging business.
IT project data
- Industries banking
- Specialist tasks mortgaging, quality assurance, risk analysis
- DP tasks Data Warehouse
- System environments Client/Server
- Programming languages PL/SQL
- Databases Oracle Database
- Development and test tool Discoverer/2000, Oracle SQL*Loader
- Operating systems Unix, Windows NT
Project period01.01.2001 - 31.12.2002
Customers who trust us
