Interconnect & Roaming Analyst at Airtel

Job Purpose

• The position is key in identifying potential and existing revenue leakage areas in the business and preventing such leakages thus enabling the business maximize its revenues and in essence increase profitability.

Key Accountabilities
Ensure Accurate Recording of Traffic on The Interconnect Billing System:

• DComparison of Interconnect CDRs and Switch CDRs from other downstream systems e.g. Cognos, Connectiva etc. to ensure accurate recording of traffic on the Interconnect System.

Interconnect International B Table Validation To Ensure Billing/Charging Accuracy of Interconnect CDRs:

• Review international interconnect dump from all Transit MSC for B table and check for all the charging, routing, and barring parameters defined on each MSC.

Formulate Risks Prevention Techniques in The Billing of all Roaming Services / Products:

• Design controls and processes to ensure accuracy and completeness of billing of revenue products across all billing domain with the organization. Identify GAPS and initiate work steps.
• Developing and interpreting Roaming reports and revenue KPIS and providing consultation to management
• Ensuring compliance with self-validated control check list.

Drive Favorable Roaming Revenue Position by Ensuring Accuracy of Invoicing and Dispute Resolution With all Roaming Partners:

• This is achieved through reconciliation of partner’s records, highlighting areas of dispute and liaison with partners to resolve disputed invoices.

Conduct Business Impact Assessments of Roaming New Products:

• Reconciliation and validation of roaming partners test records with Airtel data and ensuring accurate processing of records by the data clearing house.
• Ensure that routine test and validations are done for all new roaming partners, products/services to ensure accuracy and completeness to prevent loss in revenues.

Propose and Implement Controls to Mitigate Against Risks in Roaming Financial and Data Clearing:

• Reconciliation and validation of Airtel records d with the clearing House records, ensuring record completeness, billing accuracy and prompt transfer of files to avoid old and unbillable records for inbound and outbound roaming operations.

Ensure That Operational System and Process Controls are Consistent With Company’s Expectations with Emphasis on Data Quality and Data Access to Ensure Revenue Maximization:

• Review of audit issues on roaming controls and ensuring prompt closure of any outstanding issues
• Monitoring of roaming traffic trend per revenue stream as well as analysis, investigation and resolution of traffic issues
• Conduct root cause analysis for all KPIs beyond admissible parameters.

LCR Validation:

• Ensure Least Cost Routing is prepared and implemented accurately.

Resolution of Interconnect Dispute:

• Resolving all interconnect disputes where variance between Airtel records and Interconnect Operator records exceeds acceptable variance allowed by NCC.
• Ensure Interconnect CDRs are made available to Operators when invoices are disputed

Interconnect Reference Data Validation:

• Ensure the accuracy of rates, trunks, switch and all other reference data configured on the interconnect billing system.

Test Call Reconciliations:

• Reconcile test CDRs between Airtel and Interconnect operators and ensure completes, accuracy and validity of CDRs before new routes are opened or expansion of existing routes.

To ensure KPIs/ reports availability:

• Ensure that Interconnect reports and KPI’s are available to stakeholders and management for decision making.

MSC/TRUNK MOU Trending to Monitor Operator Performances:

• Monitor Interconnect Switch, Trunk and Operator to ensure completeness of Operator minutes of use and revenue arising.

Provide Required Support in Combating Sim-boxing and Traffic Refilling:

• Reconcile traffic sent/from various MNOs through clearing houses to detect possible cases of traffic refiling.

Required Skills, Experience, and Educational Qualifications
Educational Level - Must have:

• First Degree in Finance, Science or related discipline. MBA an added advantage
• A professional qualification such as ACA, ACCA, CISA is desirable.
• Solid problem-solving and business acumen skills
• Team leadership/project management skills
• Sound knowledge of SQL (Structured Query Language) and ACL (Audit Command Language) for data analysis and reporting

Working Experience - Must have:

• Minimum of 12 years relevant working experience with +5 years in Revenue Assurance and Fraud management.
• Proactive and resilient
• Excellent communication skills
• Good leadership/interpersonal skills

Skills critical to the role:

• Problem solving skills and good team spirit.
• Good leadership/interpersonal skills.
• Communications skills.
• Proactive and resilient.