This is one of 3224 IT projects that we have successfully completed with our customers.How can we support you?
Support Data Warehouse 2019
Project duration: 1 year, 2 months
Brief description
In this data warehouse, which is connected to SAP and Clarify or to MS Dynamics, ERP and CRM data is prepared and made available for purposes of analysis.
Supplement
The data warehouse which is the topic of this project is a globally developed reporting solution with single implementations for affiliates both in Germany and abroad. It contains a couple of relational databases both for the data import from several source systems and for the creation of fact and dimension tables. Furthermore, a multidimensional (OLAP) database for analytical purposes is part of the solution. The support project includes supervising the databases and interfaces belonging to the system, performing adjustments and expansions, and processing inquiries relating to these (incidents in HPSM or ServiceNow respectively) from subsidiaries in Germany and abroad, including the creation of reports and upgrading existing systems to new versions. Due to the upcoming replacement of the supported systems by new BI solutions this support also includes tasks for the decommissioning of this data warehouse in particular affiliates.
Subject description
In this data warehouse solution country specific data and structures from several source systems (CRM, ERP (SAP), global definition data and local source data) are provided for reporting purposes. It is the analytical part of a complete solution with an operational part based on Amdocs Clarify. CRM data are combined with other source data like SAP or SAP BW respectively, consolidated and provided for reporting both as relational and multidimensional (OLAP) data. Among other things this data warehouse provides actual and planning sales values on the basis of single or aggregated customer or material data. Moreover, this solution offers extensive possibilities for service reporting.
Overview
- Industries pharmaceutical industry
- Specialist tasks Customer Relationship Management (CRM), data warehouse
- DV tasks customised software support
- System environment Business Intelligence, standard software: CRM systems, standard software: ERP systems
- Procedure model customer standard
- Databases MS SQL Server
- Development/ test tools MS Visual Studio, SQL Server Business Intelligence Develop. Studio,
- Operating systems Windows 10, Windows Server 2008
- Standard software HP Service Manager, ServiceNow
Project period01.01.2019 - 29.02.2020
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
