Experience

• 

  Ufone

  Nov 2006 - Mar 2017

  -Development and execution of end to end usage assurance controls for Postpaid, Prepaid, International roaming, Interconnect, VAS and Data revenue streams.-Development and execution of end to end platform integrity/subscription assurance controls for Postpaid, Prepaid, International roaming, Interconnect, VAS and Data revenue streams.-Development and execution of end to end rating and billing assurance controls for Postpaid, Prepaid, International roaming, Interconnect, VAS and Data revenue streams.-Rating and Margin assurance controls for Interconnect and roaming.-Planning and development of new controls to enhance Revenue Assurance coverage.-Planning, development and execution of in-house automated tools for rating assurance, fraud configuration assurance (like balance change, product/resource provisioning by backend system etc.) for postpaid, prepaid and roaming.-Follow-up and resolution of highlighted revenue assurance and fraud issues.-Risk assessment of new products, services, promos and systems.-Implementation of preventive and detective revenue assurance controls.-Insourcing of change requests in RAID Module (RA system by Wedo Technologies) to save company cost.-Supervision of revenue assurance controls.-Preparation of monthly dashboards and report for Management and Group reporting and liaison with Group.-End to end FED and AIT tax cycles validation.-Accounting Cycle validation to ensure the reported revenues are in line with revenue assurance figures.-Development and monitoring of Dashboards/Business Intelligence Tools for unusual revenue trends/outages and alert Technical and higher management in case of anomalies-Manual adjustment validation.-Deferred Revenue calculation and investigate the issue in the process of Booking of sales and revenues.-Sales, retention and top up/recharge commission validation. Show less Monitoring of End to End Reconciliation for Prepaid involving all major network nodes (MSC, SMSC, Mediation, SGSN GGSN, SCG, Billing, PSA and OCS). End to end verification and risk assessment before product development and validation of testing result after product developmentDevelopment and monitoring of Hourly Rating Module to ensure correct charging of different prepaid services (Voice, SMS, GPRS, Package conversion). Development and monitoring of Dashboards/Business Intelligence Tools for unusual revenue trends/outages and alert Technical and higher management.Development and Monitoring of IN Balance movement on daily basis (using RAID-PBV). Assuring EVC Balance movement against individuals Distributors, Sub Distributors and Retailers. Monthly Revenue to the Finance team along with the GL wise validation.Ensuring the synchronization of different platforms (HLR, PSA and OCS) to ensure platform Integrity of Prepaid Subscribers. Development and monitoring of controls related to fraud like Camel Parameters for prepaid, SIM Swap, and P2P balance sharing, Electronic Transfers and CommissioningMonitoring, analysis and development of Revenue Assurance System- RAID to cope the new RA needs without incurring CR to vendor.Reconcile the Automated and Manual Adjustment and ensure all adjustment made as per defined SOP and agreements published by Marketing/Finance and approved by CEO. Planning and Development of New Revenue Assurance Models and Matrices to improve accuracy and efficiency of Usage, Subscription, Ratting and Cost & Margin assurance.Deferred Revenue calculation and investigate the issue in the process of Booking of sales, revenues and commissioning.Dashboard and Presentation for Group RAFM team (Etisalat) and higher management with respect to exposed risk, savings and recoveries made during the month Show less As Senior Executive Revenue Assurance I was looking Prepaid and Postpaid DomainPerform and analyze end to end reconciliation between Switch and Billing nodes for prepaid and postpaid. Investigation the core reason of differences and escalate issues to Technical NSS and Planning teams.Perform audits of postpaid billing rejected event table and investigate the reason and escalate the issue to Billing and HLR Teams.Performs ratting and configuration validation on all products Voice, SMS, GPRS and bundles and escalate issues to Technical and Billing teams.Perform prepaid balance movement and postpaid billing movement and investigate the reason of all differences found and escalate the issues to Billing and Technical teams.Postpaid lines rent validation and investigate the issue found with respect to package and escalate the issues to Billing team for rerating.Postpaid and Prepaid adjustments, payments, and billing wavers verification and escalate the issues to Marketing and Cops teams for rectifications. Postpaid subscribers hot billing reporting, booking and billing verification and escalate the issues to billing team for rectifications.Postpaid service status validation between HRL and Billing and investigate the reason and escalate the issues to billing and HRL teams for rectification.Postpaid and Prepaid subscribers platform integrity issues validation between HLR, Billing, IN and CRM and investigate the core reason and escalate the issue with respect to Camel parameters OCSI and TCSI change, Status mismatch for postpaid between HRL and Billing etc to Billing and Technical teams.Third party VAS services integrity between Vendor servers and provisioning and billing nodes.PSA subscriber definition product (prepaid and postpaid) wise mismatch identification with HLR, IN and Billing. Show less Managing the creation, publication and delivery of data/analytical reports on-line and in-print for MIS channel.Prepare MIS reports based on revenue, calls and customer basis to respective high end-users.Enhance advance data analysis techniques/methods to incorporate complex business reporting requirements.Designing and Developing IN-HOUSE software reports as per MIS requirement using VB.Net.Providing support for miscellaneous ad-hoc and special requests for data and reports to respective PTML departments.Performing operational tasks on Teradata (Fast loads ,Multiloads ,Bteq ,Fast Exports and SQL etc)Managing ETL processes for daily CDRs loading.• Revenue Analysis on the basis of Product, Customer, Geography, Service Categories etc.• Analysis of Customer Segmentation on the basis of their activities and duration.• Different type of Trend Analysis with respect to Product, Geography, Calls, SMS, MMS and GPRS. • VAS analysis before and after launch. Analysis of different Voucher Recharges with respect to their Denominations, Customer Segment etc.CRM (Cares) (Customer Activity Recording System) using Oracle 9i, VB.NET for Customer, Sales and Inventory Management, and Provisioning on engineering platforms. Maintains complete customer record, along with his history and provides end to end solution for Sales. It has direct interaction with Switch and IN (Intelligent Network) platforms.Commissioning Management System to calculate and distribute commission according to sales, retention, franchising etc.Tagging customer according to revenue limits and also on the basis of first call activation, first commercial call, second commercial call, first card load, second card load etc. MSC raw data loading and reconciliation with IN. Show less

  • Revenue Assurance Manager

    Jan 2015 - Mar 2017

  • Revenue Assurance AM

    Jan 2011 - Dec 2014

  • Senior Executive Revenue Assurance Finance

    Jan 2009 - Dec 2010

  • Executive IT (Dataware house & Software Development)

    Nov 2006 - Dec 2008
• 

  Etisalat

  Apr 2017 - now

  Specialist revenue assurance