Call Data Reconciliation at Canar Telecommunication

Ebaa Marouf

Project overview

Call data often comes from myriad sources, including network infrastructure, third-party vendors and billing systems. Ensuring consistency, accuracy, and reliability across these datasets is crucial to maintain customer trust and accurate billing.

• To perform a comprehensive reconciliation of call data from different sources within Canar's ecosystem and identify, report, and rectify discrepancies.
• Implement continues monitoring mechanism to address future spam sources

Project Objective

Tools Used

• Data Collection: Gathered call logs and related data from various sources including:
• Network call routers
• Customer billing systems
• Third-party communication service providers
• Customer complaint and feedback channels
• Pre-processing:
• Standardized data formats across all sources
• Addressed missing values, outliers, and anomalies
• Reconciliation Process:
• Mapped corresponding data entries from different sources
• Identified mismatches in call durations, timestamps, caller/callee IDs, and billing amounts
• Tagged discrepancies for further investigation
• Reporting:
• Created dynamic dashboards using tools like Excel and Power BI
• Highlighted key areas of concern, such as frequent mismatches from specific sources or particular types of discrepancies
• Resolution:
• Collaborated with respective departments to delve deeper into root causes
• Implemented corrections in the data and provided feedback loops for system refinements
• 
  

Project Outcomes

The reconciliation process led to:

• A significant reduction in billing errors, enhancing customer trust.
• Identification of systemic issues in certain data sources, leading to infrastructure improvements.
• Streamlined workflows for future reconciliation processes, improving efficiency.