Menu
This is one of 4546 IT projects that we have successfully completed with our customers.How can we support you?
Automated evaluations in the audit data warehouse
Project duration: 3 months
Brief description
The audit performs a variety of evaluations of the customer stock at regular intervals, in order to assess the risk to the bank. The evaluations, which are currently performed manually, are to be automated by integrating them into an existing audit data warehouse (DWH). The audit employee accesses these evaluations via a user interface.
Supplement
The audit DWH was already structured on the basis of an Oracle database. An evaluation stock is entered into the DWH each month. The evaluations are implemented with the help of stored procedures on the database. These stored procedures are started automatically after the data is provided. In a temporary solution, the reports are structured using MS Excel. In later stages, the use of Cognos tools is planned.
Subject description
The data is retained in the DWH for one year. As a result, audit employees can carry out risk analyses of the current situation and assess the trend over recent months.
Overview
- Branchen banking
- Fachaufgaben Audit, BPM: process optimization, BPM: process realization, data warehouse, Revision, risk analysis
- DV-Aufgaben customised software new development
- Systemumgebungen Business Intelligence, Client/Server
- Vorgehensmodell Waterfall Model
- Datenbanken Oracle Database
- Entwicklungs- und Testtool Oracle SQL Developer
Project periodProjektzeitraum01.10.2016 - 31.12.2016
Have we sparked your interest?
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
