MTC - Namibia
Transforming Revenue Assurance & Fraud Management with CDRlive
With 2.6 million active subscribers, MTC Namibia has been a key player in the telecommunications industry for over 26 years. They provide voice and data services to individual and business customers through an extensive network infrastructure. The adoption of the CDRlive Enterprise Data Warehouse (EDW) since 2019 has strengthened MTC’s operational capabilities by processing more than 36 different feeds and handling around 1.5 billion CDRs per day.
Challenge
Several challenges existed in MTC’s environment demanded strategic solutions. Firstly, staying abreast of new network technologies like 5G presented the need for the inclusion of new data sets in monitoring tools. Secondly, the management of increasing complexity and disjointed data from multiple monitoring systems hindered the attainment of a comprehensive view. Thirdly, the exponential growth of raw network data posed challenges in tracking, loading, and analysis. The need to combat increasingly sophisticated criminal syndicates exploiting network vulnerabilities was a critical concern. Additionally, coping with a multi-vendor environment complicated Datawarehouse maintenance and integration. Adapting to new partnerships and commercial models led to billing rule complexities and errors. Finally, addressing reduced proactive measures to prevent revenue leakage became an essential aspect of our operational focus.
Solution Approach
The implementation of the Revenue Assurance and Fraud Management System followed a strategic approach
Leveraging EDW Data Processing:
Utilised a centralised EDW for a complete view of user activity, automated KPI validation, and proactive alert mechanisms.
Revenue Assurance
Insured data quality, accurate billing, and automated monitoring of usage, subscriptions, and event-based services. Anti-Fraud Measure
Anti-Fraud Measures
Implemented automated usage trend analysis, case management, and investigation processes to detect and prevent irregular activities.
Built on the CDRlive EDW, ensuring the availability, accuracy, and accessibility of all necessary data.
Conducted multiple sessions with MTC to understand specific needs, tailor use cases, and ensure user involvement
Implemented use cases using an agile approach, allowing for parameterisation and easy configuration changes.
Engaged users throughout the process, from requirement specification to final testing and approval of each use case.
Network
- Network: Monitoring and analysis of network traffic to optimise performance and resource allocation.
- MSC/Cell Level Reporting: Granular reporting at the Mobile Switching Center (MSC) and cell level for targeted insights.
- Device Analysis: Analysis of device usage and performance to enhance service offerings and device compatibility.
- Voucher Management and Value Added Services (VAS) Analysis: Monitoring and analysis of voucher usage and VAS offerings to maximise revenue and customer satisfaction.
Subscriber Management
- Subscriber Analysis: Comprehensive analysis of subscriber data, including daily and monthly subscriber numbers, to understand user behavior and preferences
- Revenue Generating vs. Non-Revenue Generating Subscribers: Segmentation of subscribers based on their revenue contribution to tailor services and marketing strategies accordingly.
Financial and Legal
- Finance Financial analysis and reporting to support budgeting, forecasting, and financial decision-making.
- Revenue Assurance and Fraud Investigation: Detection, investigation, and prevention of revenue leakage and fraudulent activities within the network. The solution plays a critical role in safeguarding revenue and ensuring billing accuracy.
- Billing and Billed Usage: Monitoring and analysis of billing processes and billed usage to ensure accuracy and compliance.
Product/Service Management
- Supporting new product launches, prelaunch testing, post-launch evaluation, and performance reporting to enhance product/ service lifecycle management.
Marketing
- Customer Segmentation: Segmentation of customers based on various criteria for targeted marketing campaigns and personalised offerings.
- New Service Launch: Facilitating the launch of new bundles, offers, or service plans through data-driven insights and analysis.
Results
The implementation of CDRlive at MTC Namibia led to remarkable outcomes:
Centralised EDW
Seamlessly integrating data from all network sources.
Optimised Reporting
Reliable data source for analysis and reporting needs.
Improved Data Ingestion
Daily database syncs and ingestion of approximately 81,000 f iles from 31 streams.
Proactive Checks
Implementation of a revenue assurance alert system and proactive fraud detection checks.
Billing
Enhanced billing accuracy and reduced revenue leakage.
Intuitive Dashboards
Facilitating case management, tracking, and resolution, resulting in reduced investigation response times.
System Specifications
Database
Technology | Greenplum 6 |
|---|---|
Operating System: | RHEL 7 |
Size: | 400 TB |
Avg events loaded per day: | 1.5 Billion |
Daily Peak event load capacity | 3 Billion |
Hardware
Front end server (FTP): | FTP/SFTP: 22 cores / 128 GB RAM |
|---|---|
Front end server (Parsing): | ETL (x3): 24 cores / 256 GB RAM per server |
Database servers: | Greenplum Database (x10): 32 cores / 64 threads / 256 GB RAM per DB server |
Conclusion
Telstra’s success story with CDRlive underscores the transformative potential of Adapt IT Telecoms’ technology in driving operational excellence, revenue growth, and customer satisfaction. As Telstra continues its journey towards digital transformation, CDRlive stands as a reliable partner, empowering Telstra to navigate challenges, capitalise on opportunities, and deliver unparalleled value to its stakeholders.
Testimonial
“One portion where the CDRlive EDW helped us a lot was on a partner’s USSD codes. It helped us as Commercial to have a fast and clear insight into what is going on, and where we should make changes. This change has made a significant difference since July 2021 and is still very much relevant today.”
Andre De Jager
Commercial Department – MTC Namibia
Ready to Elevate Your Telecom Strategy?
At Adapt IT Telecoms, we’re committed to empowering your business with cutting-edge solutions tailored to meet today’s demands and anticipate tomorrow’s opportunities. Whether you’re an enterprise, MNO, ISP, or beyond, we have the expertise to drive your growth and success.
