1 / 15

Geoff Hammond Head of Revenue Assurance

Geoff Hammond Head of Revenue Assurance. Agenda. Interconnect – CRAB the start Current Wholesale Revenue Assurance Focus PPC current position PPC Radial Distance Hanif Lalani – Message Revenue Assurance Strategy. The Problem:- Interconnect (24 Months ago).

mikasi
Download Presentation

Geoff Hammond Head of Revenue Assurance

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Geoff HammondHead of Revenue Assurance

  2. Agenda • Interconnect – CRAB the start • Current Wholesale Revenue Assurance Focus • PPC current position • PPC Radial Distance • Hanif Lalani – Message • Revenue Assurance Strategy

  3. The Problem:- Interconnect (24 Months ago) • Inventory issues on circuits & features • Relied on Provision data to provide the billing checks • Route & circuit alignment ie No common key • Incomplete data passed to billing • Required extensive manual validation before billing • Customers challenged bills

  4. Problem Summary

  5. Prove LiveInventory Compareto Orders Compareto Billing How Did We Solve This ? • Circuit Revenue Assurance Board - CRAB • What was actually there? • What should be there? • What are we billing for? • System & Process to maintain results All based on ONE TRUTH DATABASE

  6. OTDB Customer Count

  7. Results – Interconnect (12 months on) • Customers now being billed More accurately • Bills produced on time • Orders easier to deliver as data is right • Spare network capacity released • Customer satisfaction improving

  8. BT Wholesale RA Focus – March 05 • Broadband - BBDQM • IP Stream • Data stream • SDSL • Mobile • Retail Private Circuits • Partial Private Circuits

  9. Partial Private Circuits -Today • Enabled a team to focus on PPC Circuits (6 months) • Now have a Prototype “One Truth” data base (OTDB) • Web Based OTDB – in User Acceptance Testing • Circuit Inventory now Proved to 99.6% • Circuit Data aligned in 6 key operational systems • Remaining 0.4% to Resolve • Timing issues • Some cleanse to do • Now working on the PPC Circuit Attributes • Radial Distance ( Nov 04)

  10. PPC Radial Distance - Issues • Migration of RPC to PPC • Migration Tool had a rounding error • didn't always pick the correct serving exch • Issue with grid references – leading 0 • Introduction of Tier One Pricing • B end Post codes missing or inaccurate • Errors in data feeds used by the TODD tool. • The odd 1141 codes duplicated or transposed. • Missing post codes in our Customer Service System • Customer Management Center process • Inconsistent Trunk and Terminating field layout

  11. PPC Radial Distance - Issues Bill Validation • Its very complicated • No Clear written Industry Process • Missing post codes in the Exchange Name Postcode file. • Customers using OLD Post Office Address File (PAF) • Customers not able to provide or validate their own B ends

  12. PPC Radial Distance – Moving Forward • Clear written Industry Process issued • True Serving Exch – Exchange Name Postcode file. • Nearest Serving Exch –Supplementary Post Code List • Grid Reference – centered- current Post Office Address File • Matching Point of Handover (PoH)- grandfathered PDH • RPC/ PPC Migration tool being Fixed • Asking Customers to validate B end Post codes • TODD - Data feeds being corrected • Provision System being corrected - Screens • Improving Training in Customer Management Centres • “One Truth” tool modification to hold the gains

  13. PPC Radial Distance – Next Steps • CRAB Validation Now Complete • Pilot • Send sample of changes to each Customer • Each Customer then to Validate the sample and agree • BT will then Update its systems • Remaining • Send all remaining changes to each Customer • Each Customer then to Validate and agree • BT will then Update its systems • Billing Corrections • Readjusting back to when tier 1 pricing was introduced. • Your Help Needed to :- • validate and agree to the changes • provide correct B end Post codes

  14. A word from our New Group CFO Hanif Lalani OBE

  15. Questions Geoff Hammond Head of Revenue Assurance Geoff.Hammond@bt.com

More Related