Loading...
Share this Job

Revenue Assurance Analyst

  • Execute the Rating validation, usage counters, interconnect and platform integrity including post-paid and loyalty controls to save the revenue streams, and give trust to the management that all revenue streams are accurately identified, captured, recorded, billed, invoiced and reported in a timely manner.
  • Maintain and enhance the Revenue Assurance processes and control framework to ensure that all revenues are accurately charged, billed, collected and reported.

Perform internal & external monthly reports to the top management and group RAFM including group RAFM KPI list, RAFM Frame work, Highlighted Issue list, revenue leakage quantification.

  1. Rating & Hybrids Validation Controls
  • Identify the potential revenue leakage through auditing and developing the below traffics:
    • Validation of IVR & SMS Premium numbers configuration in Network and IT systems for accurate billing
    • Validate the rating accuracy for the VAS services (RBT – Call signature, MCN, Call filter etc.)
    • Validate the rating accuracy from the main and dedicated accounts for the top 10 prepaid rate plans (20 samples per day)
    • Validate the rating accuracy for the Mega products and promotions after launch commercially
    • Access fees validation for post-paid rate plans
    • Validate the out of bundles charging accuracy for Mobile internet & Mobile data traffics
    • Validated the rating accuracy for the content download according the content charging catalogue over the charging system
    • Validate the rating accuracy during the borrowing period
    • Ensure that the monthly fees are matched with the granted bundles over the charging system
    • Ensure that the accumulators and Usage counters are reset on regular bases as per the product design
    • Ensure that the fair usage has been applied according to product design business rules 
    • Validate the accuracy of add no’s transactions
    • Perform UAT for the new hybrid prepaid products to ensure the billing accuracy
    • monitor and review the Product Concept notes and its implementation at systems

 

  1. Post-paid, Adjustments, Subscription and Recharges Revenue Validation
  • Identify the potential revenue leakage through auditing and developing the below processes & KPIs:
    • End to end CDR Reconciliation between Charging and Billing systems for completeness of records
    • Identify the root cause analysis of the rejected CDRs from billing system
    • Ensure the end to end configuration and business rules on IT and Network nodes for accurate provisioning and billing related processes
    • Validate the Impact analysis of new the product and the promotions on different Network and IT Systems for addressing any deviation
    • Validated the accuracy of the assigned Promotions for the Post-paid customers before launch the bill cycle
    • Perform UAT for the new mega post-paid products to ensure the billing accuracy
    • Verify the accuracy of the rated CDRs at Billing System level (Based on the subscriber plan) for accurate billing
    • Review 5% (Almost 80 invoices) from the provided post-paid invoice samples to the customer care during the bill review activity period, and perform report contain the result of validation with the highlighted issues
    • Validate the automated OCC & Promotion packages for the Post-paid customers before launch the bill cycle
    • Validate the migration accuracy process and customers balance transferred from post-paid to prepaid and vice versa
    • control the exposure of customer usage as per the assigned credit limits
    • Adjustments-Debits and Credits validations from Main & Dedicated Accounts
    • Validate the accuracy of matching the adjustment fees with the granted bundles from the accumulators and usage counters over the charging system
    • Analysing the adjustments trend on daily bases 
    • Ensure the Adjustments are dully approved and authorized
    • Validate the balance movement accuracy after execute the adjustments transactions over the customer’s balances
    • Validate the charging accuracy for the below mentioned transactions with the reflected impact on the related Main, accumulator, Dedicated and usage counters accounts as per the defined business rules (Money vs Volume / Unites)
      • Opted In
      • Add ONs
      • Renewed fees
    • Validate the opted in charging accuracy for the VAS Services over the charging system
    • Validate the accuracy of all kinds of recharges transactions (physical, Top Up & e-recharges) To ensure all the recharges are as per the defined denominations
    • Validate the balance movement accuracy after recharged transactions (physical, Top Up & e-recharges) over the customers’ balances
    • Perform Balance movement flow from the main pull to the next layer
    • Validate the Odd Value Recharge (Other than E-Recharge)
    • Validate the accuracy for the bonus transactions that granted to the customers upon recharge 
    • Review the expired vouchers against executed recharges transactions to ensure that no expired voucher was recharged
    •  Perform CDR reconciliation among the Air, VOMS, MCOM, Portal and Top-up
    • Perform reconciliation between ERP and VOMS to ensure that no inventory is sold/used in Market without appropriate sales done to the market

 

  1. Usage Counters and Interconnect
  • Identify any potential revenue leakage and save the revenues through auditing and developing the below processes:
    • Voice, SMS reconciliation between Switch and charging system for completeness of records, also Identify the root cause analysis of the rejected CDRs
    • End to end CDR Reconciliation between Charging and Billing systems for completeness of records, also Identify the root cause analysis of the rejected CDRs
    • Subscription Reconciliation between CCN and Billing system also Identify the root cause analysis of the rejected CDRs
    • Perform end to end CDR reconciliation between GGSN and charging system and billing system with analysing the root cause for the rejected CDR's for all Etisalat APN’s and WIFI Hot spot
    • Monitor the traffic accuracy from the dedicated APN's
    • MMS Reconciliation between CCN and MDSP
    • RBT Reconciliation between RBT platform and CCN
    • Collect call Reconciliation between Collect call platform and CCN
    • Perform end to end CDR reconciliation between network nodes (Switch / SGSN / SGW) and TAP OUT files / DWH and analyse the results to identify the root cause of the potential revenue leakage
    • Perform end to end CDR reconciliation between GGSN / TAP IN and charging and billing system and analyse the results to identify the root cause of the potential revenue leakage with analysing the high usage customers on daily bases
    • CDR reconciliation between MSC vs. SMSC for completeness
    • Perform end to end CDR reconciliation between Radius and charging and billing system and analyse the results to identify the root cause of the potential revenue leakage with analysing the high usage customers on daily bases
    • Ensure that tariff configurations are correct at Interconnect Billing system
    • Validate the rating accuracy for the traffics over the interconnect system according to the approved agreements
    • Verify the invoice amounts and its deviation against the tolerance limit set between Physical and simulated invoices over the Revenue Assurance System
    • Validate the set up launch for the new operators, New Dial Code Configuration, New Trunk Group Creation
    • Ensure the Accurate Trunk Group in Switch/Interconnect Billing system for call routing/billing
    • Validate the Routing Table to provide suggestions for the Least Calls Routing for interconnect traffic
    • Validate the accuracy of the new product to ensure that all CDRs are captured and accurately billed
    • Validate the campaign managements requests that execute over the SMSC   
    • Analyse the consumptions traffics over the SMSC per department

 

  1. Platform Integrity & VAS Revenue Validation
  • Audit and develop the below VAS revenue processes as well as ensuring that the customers profiles and services are synchronized among the network and none network platforms:
    • Network Service Reconciliations
      • HLR Validation
        1. Reconcile the customers Profiles status
        2. Mobile Services status
        3. Different IMSI, Camel status
        4. Multiple HLR Profiles
        5. HLR Speed parameters (PDPCP) validation
        6. APN Validation
        7. Charging Characteristic Validation 
      • HLR reconciliation with the HSS
        1. APN Validation
        2. Charging Characteristic Validation 
      • Promotions validation
        1. Offer ID
        2. SOB (save more, Wi-Fi hotspot, international)
        3. PPID (Promotion Plan)
        4. Account Group
      • MNP Validation
        1. HLR Reconciliation with the FNR
      • Broadband Customers profiles validation
        1. Profile Status reconciliation among the Radius Vs. Billing System VS. Charging System
        2. Mismatched Speed between Radius and Billing
      • None Network Platform “Mismatched MSISDN and Status between billing system with the following nodes”
        1. Call Filter
        2. Blackberry (Rim Database)
        3. MCN
      • Billing vs. Charging systems reconciliations
        1. Reconcile the accuracy of the customers’ profiles between billing and charging system for the below subjects; -
          • Bill Cycle
          • Subscriber Type
          • Service Class
          • Offer ID      
          • Service Offer Bit
        2. monitor and review the below Promotions launches and its implementation at systems (from start till termination)
          • Promotion package
          • Communities Groups
        3. EMA Failed Requests
          • Failed Hotline Services
          • Failed Contract Activation
          • Failed Contract Reactivation
          • Failed Barring Services
    • Validate the charging accuracy for the VAS bundles over the charging system
    • monitor and review the Product Concept notes and its implementation at systems
    • Validate the promotions accuracy for the VAS services
    • Subscriber reconciliation between VAS platform vs. HLR vs. Billing System to ensure Integrity accuracy for the services
    • Ensure that the rating of VAS services are accurately configured over the charging system
    • Validate the business rules accuracy for all kind of overdraft transactions
    • Validate the overdraft service fees deduction accuracy
    • Validate the Settlement accuracy after recharge
  1. Loyalty & Broadband (A/VDSL) Validation
  • Audit and develop the below processes & KPIs to save the loyalty points & ADSL broadband revenue:
    • Validate the business rules accuracy for the enrolments eligibility, adding points, transfer points, expired points over the loyalty system  
    • Perform loyalty points movement validation per customers to identify the incorrect transactions according to the define business rules
    • Validate the accuracy for the deleted and freeze points
    • Validate the accuracy of adding Lifestyle (Tickets – voucher -...etc.) over the MORE PLUS system
    • Validate the ADSL basic bundle accuracy (Bundle fees vs. bundle quota vs. bundles validity)
    • Ensure that the accumulators and usage counters are reset on regular bases according to the tariff design plan over the charging system 
    • Ensure that the business rules and fair usage policies are accurately configured in the data charging
    • monitor and review the Product Concept notes and its implementation at systems
    • Monitor and review the Promotions launched accuracy at the IT systems (from start till end of promotion)
    • Perform UAT for the new mega broadband products to ensure the rating accuracy

 

  1. Revenue Assurance Monthly Reports & New Products & Services
  • Prepare below reports & set new PDs controls over RA system or DWH:
    • RA internal report
    • RA Newsletter
    • RA traffics trends
    • Group RAFM reports including all supported reports
    • Set the required controls for shared products, MEMOs to minimize potential revenue leakage and save the company revenues.
    • Validate the Impact analysis of new the product and the promotions  on different Network and IT Systems for addressing any deviation
    • Perform user acceptance test ( UAT) for MEGA products through identify the risk areas during the test phases before & after launch commercially
    • Validate the charging accuracy for the MEGA products on the related main, accumulator & dedicated accounts as per the defined business rules
    • Monitor the closure dates for the offers & promotions

 

  1. Roaming & International traffic validation
  • Identify the potential revenue leakage through auditing and developing the below processes & KPIs to save the inbound, outbound roaming and international revenues:
    • Validate the rating accuracy for the outbound roaming traffics over the charging & billing systems
    • Validate the IOT accuracy for the inbound roaming operators
    • Validate the new and updates Inbound roaming IOT agreements
    • Validate the accuracy of inbound roaming invoices
    • Review the unbilled data/records before the final invoicing
    • Validate the file transfer accuracy between Etisalat Misr and DCH
    • Validate the implementation accuracy for the Exchange rate over the billing system according to the provided currency exchange from finance department
    • Validate the IOT accuracy for the top 10 outbound roaming operators
    • Validate the new and updates outbound roaming IOT agreements
    • Validate the accuracy of outbound roaming invoices
    • Review the unbilled data/records before the final invoicing
    • Validate the file transfer accuracy between Etisalat Misr and DCH
    • Perform margin assurance (Revenue – Cost) for inbound roaming
    • Operator data configuration reconciliation between DCH, Billing and Network
    • Monitor and review the new roaming product concept notes and its implementation at systems
    • Validate the roaming promotions closure date
    • Validate the IOT accuracy for the national roaming operators
    • Validate the new and updates national roaming IOT agreements
    • Validate the accuracy of national roaming invoices
    • Review the unbilled data/records before the final invoicing
    • Validate the file transfer accuracy between Switch and DWH
    • Operator data configuration reconciliation between DCH, Billing and Network
    • Perform margin assurance (Revenue – Cost) for international traffics
    • Validate the accuracy of the international bundles over the charging system
    • Perform UAT for the new mega international promotions to ensure the rating accuracy
    • Validate the rating accuracy for the international traffics from the charging system
    • End to End CDR Reconciliation between network nodes (MSC, SMSC, International gateway) systems with the interconnect billing system for completeness of records
    • Perform margin assurance (Revenue – Cost) for international traffics 

 

5. COMMUNICATION and WORKING RELATIONSHIPS:

Internal:

  • Daily frequent contact with below stakeholders to discuss and report work progress, discuss problems and/or pending issues and seek resolution:
    • IT Departments
    • Technical Departments
    • Marketing Department
    • IOP Department
    • Customer Care departments

 

External:

  • Group RAFM
  • Revenue Assurance System Vendor (WeDo)

 

6. FRAMEWORKS, BOUNDARIES AND DECISION MAKING AUTHORITY:

  • Abide by RAFM strategies.
  • Follow DOP.
  • Fully authorized to instruct IT and Technical team to fix any detected revenue threats gaps

 

7. OPERATING ENVIRONMENT:

  • Indoor 100 %:
  • Outdoor %:
  • Location Fifth Settlements HQ S4

 

8. QUALIFICATIONS AND EXPERIENCE:

Knowledge:

  • Working on revenue assurance department on Mobile telecommunications company.
  • Experience in the products and promotion validation over the charging and billing systems.
  • Familiar with CX, CSS applications
  • knowledgeable in Etisalat network and revenue streams

Education:

Bachelor's degree

 

Prior Work Experience:

3 years’ experience in Telecom.

 

Language Proficiency:

Fluency in both spoken & written English & Arabic language is required.

 

Problem Solving:

  • Managing with all stakeholders any potential revenue risk exposures.

 

Innovation:

  • Think about the opportunity and/or need to develop new approaches, procedures, designs, plans, guidelines to overcome any technical limitations.

 

Skills & Abilities:

  • Self-motivator and creative thinking
  • Excellent interpersonal skills.
  • Ability to work under pressure
  • Able to adapt to changing priorities
  • Software skills especially in MS Office
  • Ability to work outside the official working hours
  • Decision maker/ finding solutions, Self-motivation
  • Ability to prioritize and meet tight deadlines
  • Ability to focus on the lowest level of detail and assess the impact at the macro level

 

9. CERTIFICATIONS / CREDENTIALS / MEMBERSHIPS / LICENSES:

 

 

 

10. TOOLS AND eQUIPMENT:

  • Revenue Assurance System
  • DWH Reports
  • VPN

 

11. data accessibility:

  • Revenue traffics
  • CRDs
  • Revenue streams reports and KPIs
  • SDP records
  • Billing detailed records.
  • All types of traffic cost
  • Relevant systems interfaces and applications