This is one of 4620 IT projects that we have successfully completed with our customers.How can we support you?
Service Controlling – Central Database
Project duration: 4 years
Brief description
Within the framework of an MS Access / SQL Server migration project, the data storage from MS Access databases is transferred to SQL Server databases. A major application concerns contracts with external service providers and the verification of compliance with SLAs of the individual services. The data model of the old application is mostly available in a non-normalized form. Therefore a re-engineering of the data model and the MS Access front-end application is carried out.
Supplement
A normalized data model is created based on the data model of the legacy application. Parallel to this, an analysis of the business processes and the creation of a prototype for user guidance / data maintenance is carried out. An iterative procedure is used to compare the data model and business processes. The aim is to centralize data objects that were previously maintained separately in different business applications and thus create the basis for merging them into a central application / data model. In addition to the realization of the MS Access application, interfaces to a contract management system and an ITSM system are implemented.
Subject description
The application serves as a central database for service reporting.
Overview
- Industries banking
- Specialist tasks technical controlling
- DV tasks customised software new development
- System environment Client/Server
- Procedure model PTA project manual
- Databases MS SQL Server
- Development/ test tools MS Access
Project period01.05.2018 - 02.05.2022
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
