This is one of 3224 IT projects that we have successfully completed with our customers.How can we support you?
Introduction of a central KPI database
Project duration: 10 months
Brief description
A database system is developed which receives unprocessed commercial data, condenses it and calculates KPIs based on this; these are stored in order to be available across the company to external systems for request. The project involves the design, implementation and testing of the system to be created. The target system comprises a database in which up to 20 GB is imported daily in the form of csv files, and processed within two hours. The architecture is open both for expansion by new input and output interfaces as well as implementation of new key figures.
Supplement
The target system runs on an Oracle 12c database under Linux. The input data is supplied in the form of csv files which are imported as external tables and processed with PL/SQL. The calculated KPIs are accessed via Oracle database links from the external systems. The project activities involve all tasks from the general concept through to the fine concept, requirement analysis and definition, implementation of all functions as well as planning and carrying out the module and integration tests, and providing support for the system and acceptance tests.
Subject description
The target system serves as a central source system for quick access to condensed KPIs by external systems. The implemented KPIs are planned and achieved sales quantities, sales volumes and, resulting from this, commercial KPIs that are used for providing information to planning processes.
Overview
- Industries trade
- Specialist tasks Big Data, KPI, promotional transaction, sales analysis, sales planning
- DV tasks customised software new development
- System environment technical data processing
- Procedure model agile software development
- Databases Oracle Database
- Development/ test tools MS Team Foundation Server TFS, MS Visual Studio, Oracle SQL Developer, Oracle SQL*Loader,
- Standard software Microsoft Test Manager
Project period06.05.2015 - 29.02.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
