This is one of 3224 IT projects that we have successfully completed with our customers.How can we support you?
Support and development for central KPI reporting at a pharmaceutical company 2017
Project duration: 2 years
Brief description
In this project, further development and support tasks are provided for the analysis systems at a pharmaceutical company. This involves a series of OLAP databases covering all company reporting for actual and planned data, down to the level of individual articles. Support activities ensure smooth operation. They also include implementing changes and new requirements. Development activities cover ETL processes and system status reports.
Supplement
The database software used is the SQL Server 2016 from Microsoft. Business Intelligence Development Studio, based on Visual Studio 2015, is used as the development environment for the data processes and the OLAP databases. Support tasks that can be performed directly on the database (such as configuration, data checks and data corrections) are carried out using the SQL Server Management Studio. The processes for loading the fact and dimension data are implemented using Integration Services. The data processes that are to be implemented are integrated into an established centralized sequence control system. The sequence logic needed to do this also has to be created and maintained. The OLAP databases are made available to users by means of Analysis Services. MS Reports is used in this context with SharePoint for the system status reports. HPSM from HP is used as the ticket system and SAP SSM is used for documentation.
Subject description
The key performance indicators database shows the company's actual and planned sales around the world at the level of individual articles, in terms of value and quantity. Target figures can be used together with up-to-date actual figures on a monthly basis to create analyses. The key performance indicators include values for the working capital, sales figures and manufacturing costs, value management, and employee figures and costs. The itemized items are available in both consolidated and unconsolidated form, which enables the value of the entire manufacturing process to be checked. In addition, data is provided for a detailed deviation analysis. The database enables planners and controllers to evaluate the KPIs in more than 12 dimensions. These dimensions are integrated into the management reporting concept for an existing analysis database at a rougher level.
Overview
- Industries pharmaceutical industry
- Specialist tasks BPM: process realization, data warehouse, Reporting
- DV tasks customised software further development
- System environment Business Intelligence
- Procedure model Scrum
- Databases MS SQL Server
- Development/ test tools MS Team Foundation Server TFS, SQL Server Business Intelligence Develop. Studio,
- Operating systems Windows Server 2012
- Standard software Deltamaster, SAP Solution Manager, XL Cubed
Project period01.01.2017 - 31.12.2018
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
