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 4813 IT projects that we have successfully completed with our customers.How can we support you?
Risk Management III
Project duration: 1 year, 3 months
Brief description
Support for and further development of a data warehouse for risk management in mortgaging (see project IDs 262 and 562). In addition to enhancing the range of evaluations available to users, the main task is to improve the performance of the data warehouse.
Supplement
Fundamental improvements to performance are achieved by changing the database design and replacing, step by step, the procedures implemented in PL/SQL for filling the data warehouse and providing the data. The latter is mainly done by developing and using SQL scripts. These can be started in UNIX manually by means of shell scripts or automatically via jobs.
Subject description
Changes to functional requirements, a growing quantity of data to be processed and unsatisfactory performance for the risk management system in mortgaging result in the need for a series of adjustments to the data warehouse. The main focus of activities is on technical aspects.
IT project data
- Industries banking
- Specialist tasks mortgaging, Reporting, risk analysis
- DP tasks Data Warehouse
- System environments Client/Server
- Procedure model iterative procedure
- Programming languages PL/SQL, SQL
- Databases Oracle Database
- Development and test tool Hora, Oracle SQL*Loader, Oracle SQL*Plus, TOAD, UltraEdit
- Operating systems SunOS, Windows XP
Project period01.11.2006 - 05.02.2008
Customers who trust us
