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?
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.
IT project data
- Industries banking
- Specialist tasks technical controlling
- DP tasks customised software new development
- System environments Client/Server
- Procedure model PTA project manual
- Databases MS SQL Server
- Development and test tool MS Access
Project period01.05.2018 - 02.05.2022
Customers who trust us
