Resolve Tech helped the client, an American telecommunications conglomerate, streamline its profitability reporting process using a data warehousing and analytics solution. The solution enabled the client to make data-oriented decisions about marketing campaigns. Due to single version of truth shared by all departments: Marketing, Operations, and Finance, the telecom major was able to overcome inherent delays & inaccuracies in the profitability reporting. The client thus achieved faster management reporting, improved marketing decision making, and better data synergy across various departments.
Business rules migrated with over hundred cost attributes factored
Reduction in processing time for generation of RCM report
Matching of business rules with those of the legacy system
Our client, an American telecommunications giant, wanted to keep track of their profitability margins with Revenue per Customer per Month (RCM) and RCM Accretion over time- as target metrics for measuring the success of their past marketing campaigns
However, lack of relevant data, low accuracy & timeliness of RCM reporting process was causing delays in decision making. Also, limited flexibility of their legacy system on providing support for visual rendering of reports and resistance to business changes was leading to a large and unfinished backlog.
The client decided to empower management with data-driven strategic decision-making through advanced analytical capabilities. With Resolve Tech as a technical partner, the client implemented a new Enterprise Data Warehouse with billing details that uniquely identify every customer to compute revenue data across customers or segments in aggregate.
Additionally, Resolve Tech also addressed reporting and data needs of other departments, namely Operations and Finance, along with the RCM reporting needs of the Marketing team. To achieve the above, Resolve Tech worked with various teams, specifically the BODS team to understand the existing functionality of data mappings and RCM computation.
Data extraction from legacy systems and definition of business rules and KPIs to be pre-built into the data warehouse
Teradata based Data Warehouse that integrates with product and billing systems (including legacy accounts)
Advanced reporting and analytics engine with a daily refresh of data and self-service features for power users
Self-service capability for users to analyze profitability data across customer segments, products, and geographies
Segment based monitoring to help understand the sensitivity of RCM to specific events such as price-ups, roll offs, etc. for tailored marketing decisions
Automated computation of cost of service of individual customers, and across all customers, eliminating manual process