عمر Farooq

Revenue Assurance Consultant

Vodafone

البلد: قطر - الدوحة
التعليم: ماجستير, Fianance & Marketing
الخبرات: 17 years, 7 أشهر

الخبرة العملية

مجموع سنوات الخبرة :17 years, 7 أشهر

Revenue Assurance Consultant في Vodafone

قطر - الدوحة
أشغل هذه الوظيفة منذ نوفمبر 2016

Margin Assurance.
Traffic Assurance.
Charging Analysis.
Revenue Analysis.
Platform Integrity.
Interconnect.

Revenue Assurance Specialist في Mobilink

باكستان - إسلام أباد
يونيو 2013 إلى نوفمبر 2016

Assisting commercial in changing tariff, new products and offers launch on the basis of market knowledge and traffic trends.
New product analysis and identification of risk areas and suggestions to mitigate or prevent those commercial, financial, technical and reporting risks along with business constraints.
To perform CDR validations during the change implementation on any Network element.
Investigate issues and anomalies of charging, identify and mitigate risk/loss by escalating to Technical teams for fixation.
Continuously work to understand and mitigate losses to ensure the highest levels of loss avoidance and reduction.
New Msc CDR testing and verification.
Prepaid Charging verification of Voice, SMS, Data for all packages.
Postpaid Charging verification of Voice, SMS, Data for all packages.
Outbound Roamer charges verification.
Inbound Roamer charges verification.
Short code (IVR & SMS) charging verification for Prepaid & Postpaid.
Manual Postpaid Bill verification & Rating Assurance.
Monitoring of Free Minutes, SMS & GPRS (ATL) (Subscription, Posting& Consumption).
Verification of CDR for 3G Free Trial area on the bases of LAC & Cell ID (Adhoc) .
Perform regular reconciliation and (gap) analysis of revenue streams.
Swap Sites revenue analysis.

Product Testing and performed the following activities
Comprehensive testing through Test Call Generator (TCG) for pre&post launch testing.
UAT and post implementation fine tuning.
Traffic Assurance and performed the following activities:
Prepaid Traffic Assurance:

Network Elements (MSC/SMSC/MMSC/ GGSN/SGSN) vs IN vs DWH
Postpaid Traffic Assurance:
Network Elements (MSC/SMSC/MMSC/ GGSN/SGSN) vs Mediation/CGW vs billing
Inbound Roamer Traffic Assurance:
Network Elements (MSC/SMSC/GGSN) vs Mediation/CGW vs billing vs MAC
Outbound Roamer Traffic Assurance:
MAC vs Geneva, MAC vs IN, MAC vs SMS/SGNS/CGW

Platform Integrity and performed the following recon:
HLR vs CRM
HLR vs GENEVA
HLR vs IN
IN vs CRM
RBT vs IT Platform

Accounts Payable Executive في Mobilink

باكستان - إسلام أباد
فبراير 2013 إلى مايو 2013

 Invoice Verification booking.
 PAF Verification and processing the payment.
Processing of Office rent Payments and maintain schedule.
Processing of Office Utilities Payments.
Process of Vehicle R&M Payments.
Monthly variance analysis of Expenses and provide the reasoning.
Preparation monthly Accrual Schedule.

Receivable Executive في Mobilink

باكستان - إسلام أباد
يناير 2012 إلى يناير 2013

Preparation of Revenue Invoices (FO, LM, IB & COLO );
Preparation of Debtor subsidiary Ledger;
Preparation of Aging against receivable of LDI & WIMAX;
Preparation the monthly closing JV;
Maintenance of Memorandum record of Fiber Optic (FO) Contract as Well as Purchase Orders (POs) & Purchase Requisitions (PRs);
Preparation of Invoices of Revenue of Int. Origination/Termination;
Payment Processing & Verification of Interconnect Invoices.
Booking of Revenue & Cost of Int. Origination/Termination;
Preparation of VAS Cost Accrual of PMCL;
 Manage reconciliation of invoices by vendors of Value Added Services (VAS).
 Maintenance of Memorandum record of vendors contracts, reconciliation of invoiced counts verified by Revenue Assurance dept and final processing of Payment.
Preparation & Booking of revenue of WIMAX;
Preparation of Schedule of Unearned revenue.
Preparation of Variance Analysis on Revenue & Cost of LDI and WIMAX.
Monitoring customer account details for non-payments, delayed payments and other irregularities.
Maintain accounts receivable customer files.
Follow established procedures for processing receipts, cash etc.
Prepare bank deposits & Receivable Adjustment.
CPP operators reconciliations
Performed Quarterly reconciliation with Customers (FO, LM, COLO, IB).
Quarterly balance confirmation with Customers (FO, LM, COLO, IB).
Monthly Closing of revenue & coordinating with external auditors.
Investigate and resolve customer queries.
Organizing a recovery system and initiate collection efforts
Communicating with customers via phone, email, mail or personally
Preparation SOP & SLA of LDI & WIMAX.

Finance Officer في Mobilink

باكستان - إسلام أباد
أغسطس 2007 إلى ديسمبر 2011

 Invoice Booking and Payment;
Processing of payments;
Preparation of Goods Received Note (GRN), Payment Authorization Form (PAF), Service Completion Certificate (SCC);
Maintenance of Memorandum record of Fiber Optic (FO) Contract as Well as Purchase Orders (POs) & Purchase Requisitions (PRs);
Maintenance of Petty Cash;
Preparation of Bank Reconciliation;
Preparation of Monthly sales tax Payment;
Preparation of Payment of withholding tax
Verification of Expense Claims of Employees and Further Processing for Payments;
Preparation of Voucher in GL & Invoices in AP (Oracle Financial);
Preparation of Revenue Invoices (FO, LM, IB & COLO ) Excel Based.
Preparation of Revenue Invoices (FO, LM, IB & COLO ) Receivable Module
Preparation of Debtor subsidiary Ledger;
Maintaining record of Advances to Staff;
Maintenance of books of accounts of LDI & GETT;
Preparation of Management Accounts of LDI;
Maintenance of record of LDI & WIMAX payments made by PMCL;
Preparation the schedule of prepayment (ROW- Railway & NHA).
Preparation the schedule of prepayment of Insurance.
Preparation the monthly closing JV.
Preparation the schedule of monthly closing JV`s
Preparation of Schedule of Prepayments.
Worked at Hyperion planning Module (HPM) for reporting to parent company.

Financial Associate في Excel Financial Services Pvt. Ltd.

باكستان
مايو 2007 إلى يوليو 2007

Telemarketing, keep ur eyes on international market movement, keep ur eyes on European market, American maket, Bush speech, Burnankey speech, Fukki speech . Oil prices, Gold prices, FED Rate movement.

Intern في United Bank Limited

باكستان
يوليو 2005 إلى ديسمبر 2005

Cash managemt, Teller, CS, TT, DD, Loan ledger, Bank Banker, Bank income, Banker Expenditure.

الخلفية التعليمية

ماجستير, Fianance & Marketing

في College of Business Adminstraion & Economics
مايو 2007

3.11GP. major subject are Basic marketing, Marketing managmenr, Brand Managemnt, Services marketing, Sales managment, SBM, Corporate accounting, Managment accounting, Principle of accounting, Busniess finance, Financial securities & investement,

Specialties & Skills

Accounts Payable

خدمات بيت.كوم