This is one of 4620 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
- Industries banking
- Specialist tasks Audit, BPM: process optimization, BPM: process realization, data warehouse, Revision, risk analysis
- DV tasks customised software new development
- System environment Business Intelligence, Client/Server
- Procedure model Waterfall Model
- Databases Oracle Database
- Development/ test tools Oracle SQL Developer
Project period01.10.2016 - 31.12.2016
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
