This is one of 4623 IT projects that we have successfully completed with our customers.How can we support you?
Monitoring of customer contracts
Project duration: 2 years
Brief description
Creation of a solution for monitoring of special customer contracts. The data on ordered goods, payments made and forecasts are processed in a data mart, checked and then made available to customers via the Internet.
Supplement
Requirements are recorded, documented and modelled. The development of the database is done in Visual Studio. The calculations are done in a relational ETL process. For data verification, the calculated values are checked against SAP data. The comparison values are made available via a Web service and loaded into the data mart via Integration Services.
Subject description
Customers can view the status of their contracts via the Internet and check goods retrieved and their payments.
Overview
- Industries pharmaceutical industry
- Specialist tasks contract management, contract processing, Customer Relationship Management (CRM), data warehouse, ETL, sales and distribution, Webservice
- DV tasks Data Warehouse
- System environment Business Intelligence
- Procedure model customer standard
- Databases MS SQL Server
- Standard software Tableau Desktop
Project period11.07.2017 - 28.06.2019
Contact
PTA GmbH Head Office
Weberstraße 2-4
D-68165 Mannheim
Service
Industries
© Copyright 2024 PTA GmbH | All rights reserved | Imprint | Privacy | Legal notice | Values & Code of Conduct
