Monitoring and billing support for customer contracts
Project duration: 1 year, 11 months
Brief description
Creation of a solution for monitoring of special customer contracts and support for their billing. An existing data mart is extended by contract data. This includes calculation results, orders placed under these contracts and measurements taken by customers. Based on this data, contract- and organization-related evaluations are provided.
Supplement
Requirements are recorded, documented and modelled. The development of the database is done in Visual Studio. The calculations are performed in a relational ETL process.
Subject description
The customer needs a new solution for monitoring specific customer contracts and support for their billing. For this purpose, contracts are considered, with the products ordered on them and the corresponding billing, in relation to the contractually agreed quotas.