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 4842 IT projects that we have successfully completed with our customers.How can we support you?
Cost planning tool for dismantling industrial plants
Project duration: 4 months
Brief description
For the implementation of a comprehensive cost controlling for dismantling works of industrial plants, a consolidation tool for retrospective and prospective cost considerations is developed. This serves as a basis for graphical evaluations and variance analyses. For this purpose, actual values from SAP are correlated with planned data from Oracle Primavera P6 within a newly created data structure in order to demonstrate meaningful developments and to be able to derive decisions. PTA designs the required consolidation structures within a new data management based on the existing source structures of the source systems. In addition, interfaces are created for permanent synchronization of the source data with the consolidation layer. In addition, query elements are provided to support external graphical evaluations.
Supplement
Provided data structures of both source systems in the form of Excel and CSV exports form the basis to derive a consolidated data model within a SQL Server data management. In order to prepare a permanent import of the source data, appropriate interface functionalities are implemented which cleanse, consolidate and store the incoming information in the required format in the new data storage. On the one hand, these include .NET functionalities for extraction and preparation for data processing, on the other hand, database procedures to be able to handle a high-performance comparison with already existing information. Appropriate data views offer the possibility to present information via any tools like Excel Power Pivot or Power BI. The task of PTA lies in the conception of the IT system in close coordination with the business department, the data modeling and implementation of the interfaces as well as the evaluation basis.
Subject description
The tool significantly simplifies the possibilities for cost controlling of project work amounting to more than 100 million euros for the specialist department. In addition, the quality and meaningfulness of the prepared information increases due to the mapped automated process.
IT project data
- Industries energy
- Specialist tasks finance plannung, IT consolidation
- DP tasks customised software new development
- System environments PC systems/networks, technical data processing
- Procedure model customer standard
- Programming languages C-Sharp, T-SQL (Microsoft)
- Development and test tool .NET Core, Azure DevOps, MS Visual Studio .NET
Project period01.11.2022 - 28.02.2023
Customers who trust us
Have we sparked your interest ?
