A functional analysis of all existing performance reports included in the scope for migration was the focus of the first three months. Subsequently, several commission-related data marts – to reduce the complexity of the performance report development – were introduced. A common definition of the so-called subscriber value, based on the amount of recurring monthly fees for tariff services, was established. Subscriber value change was widely adopted as a common measure of performance for all sales channels focusing on residential customers. We also contributed to the implementation of reporting rules for contract renewals regarding both residential and business customers.
In the implementation phase, the solution was delivered as a set of custom-built tables and procedures in the Teradata EDW focusing on managing commission rules by the responsible MI analysts in a user-friendly fashion, and, on the reliability and efficiency of data calculation, storage and exports to reporting tools. An effective development process based on a sandbox environment – allowing for the immediate redefining and testing of new commission rules and an agile release process promoting tested and verified code to a guaranteed production environment – were introduced.
In the test phase of the project, each of the delivered reports was thoroughly tested against the former solution in the previous data warehouse. Reports were compared to the details of individual sales transactions and large issues were reconciled and mitigated. The project and the entire solution was successfully handed over to the in-house delivery and maintenance teams.