This is one of 4620 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.
Overview
- Industries banking
- Specialist tasks mortgaging, quality assurance, risk analysis
- DV tasks Data Warehouse
- System environment Client/Server
- Databases Oracle Database
- Development/ test tools Discoverer/2000, Oracle SQL*Loader,
- Operating systems Unix, Windows NT
Project period01.01.2001 - 31.12.2002
Contact
PTA GmbH Head Office
Weberstraße 2-4
D-68165 Mannheim
© Copyright 2024 PTA GmbH | All rights reserved | Imprint | Privacy | Legal notice | Values & Code of Conduct
