Revenue Assurance

• Design and run Revenue Assurance controls across customer lifecycle: order, provisioning, usage, mediation, billing, invoicing, collection.
• Build/maintain reconciliation between network usage (CDRs/UDRs), mediation, rating, and billing systems for prepaid & postpaid.
• Analyze leakage drivers (e.g., provisioning failures, mediation gaps, rating errors, discounting anomalies, CRM/billing mismatches) and drive remediation.
• Perform data integrity checks for interconnect, roaming, and VAS revenue streams; validate VMS (voucher) issuance, consumption, and reversals.
• Support new product testing (NPI/NPD) to ensure correct charging, discounting, bundle depletion, and lifecycle behaviors.

Fraud Management

• Monitor and investigate fraud alerts (e.g., Simbox, subscription fraud, IRSF, roaming abuse, VAS abuse, dealer fraud).
• Develop rules, thresholds, and models in FMS platforms; tune detection logic for precision/recall.
• Coordinate with Network, IT, Customer Care, Legal/Compliance for case handling and recovery actions.

Systems, Data & Automation

• Write performant SQL/PL/SQL (functions, procedures, packages, indexing, partitioning) for controls, dashboards, and reconciliations.
• Develop scripts (e.g., HTML/PHP for lightweight web views; reporting scripts) to automate daily/weekly RAFM reporting.
• Build MS Excel/Access automations (including VBA macros) for control sheets, dashboards, and audit evidence.
• Partner with IT on OSS/BSS/CRM data models, mediation mappings, and API/ETL touchpoints.

Audit, QA & Compliance

• Conduct system/process audits; maintain evidence for SOX/compliance/internal audits.
• Own UAT/QA for billing/CRM/mediation changes and new product launches.
• Document control designs, SOPs, and keep a robust issue log /RCA/ corrective actions.

• 3+ years in telecom (RAFM, billing, mediation, or data analytics).
• Bachelor’s in computer science, Information Technology, Electronics, or Telecom.
• Preferred: TM Forum RA/Fraud, ITIL Foundation, SQL certifications.
• Strong SQL & PL/SQL (procedures, functions, packages, error handling, performance tuning).
• Working knowledge of HTML/PHP (for simple app/report pages) and reporting scripts.
• Advanced MS Excel (pivot tables, Power Query, complex formulas), VBA macros; MS Access for data marts/tools.
• Domain knowledge: Prepaid/Postpaid, OSS/BSS, CRM, Interconnect, Roaming, VAS, VMS (voucher mgmt.).
• Experience with data reconciliation, system audits, QA/UAT, and new product testing.
• Strong analytical, documentation, and stakeholder communication skills.
• Experience with data visualization (Power BI/Tableau).
• Knowledge of risk frameworks (e.g., TM Forum RA Maturity Model) and ITIL.