1. Mediation review Vince Kocher Mediation Programming Manager

2. Mediation System Overview • Recent Modifications • Usage Warehousing • Usage Fraud Detection • Number Portability Administration Center (NPAC) www.cdg.ws

3. RECENT MODIFICATIONS • Mediation File Processing Details • Allow Duplicate File Names check boxTo allow duplicate file names to process in the Mediation system, check this box • Client Copy Path1If a copy of the incoming feed is needed, select the appropriate path from the drop-down list • Client Copy Path 2 If a second copy of the incoming feed is needed, select the appropriate path from the drop-down list www.cdg.ws

4. RECENT MODIFICATIONS www.cdg.ws

5. RECENT MODIFICATIONS • Mediation File Processing • Pack Header Attributes – Add Pack Hdr/TrlOption This option allows the adding of pack header and trailer records for EMI feeds from external sources that do not contain a pack header or trailer www.cdg.ws

6. RECENT MODIFICATIONS www.cdg.ws

7. RECENT MODIFICATIONS www.cdg.ws

8. RECENT MODIFICATIONS • Daily Rating Input Files • Reformatting Details ButtonProvides details about the records processed in the reformatting stage • Rating Details ButtonProvides details about the records processed in the rating stage www.cdg.ws

9. RECENT MODIFICATIONS www.cdg.ws

10. RECENT MODIFICATIONS www.cdg.ws

11. RECENT MODIFICATIONS www.cdg.ws

12. RECENT MODIFICATIONS • Merge Input Files • File Drop Totals List BoxHighlighting the Drop type in the File Totals tab will populate the File Drop Totals listing with a description of the drop reason www.cdg.ws

13. RECENT MODIFICATIONS www.cdg.ws

14. USAGE WAREHOUSING • Usage Types • International • CALEA • All Usage Types • Retention • 0 – 24 Months • Auto Setup / Cleanup • Linked into Query Reporting Tool (QRT) www.cdg.ws

15. USAGE WAREHOUSING www.cdg.ws

16. USAGE WAREHOUSING www.cdg.ws

17. USAGE WAREHOUSING www.cdg.ws

18. USAGE FRAUD DETECTION • Identify Business Rules • Call Patterns • Based on Terminating Location • Based on Dialing Pattern • Based on Type of Call • Based on Number of Calls / MOU • At Company Level / Customer Level • Timeframe to Execute Business Rules • Dependent on How Often Data Delivered to CDG • During every Usage Load • Once a Day (early morning / late evening) www.cdg.ws

19. USAGE FRAUD DETECTION (CNTD) • Distribution of Alerts • Email • Text • Distribution list (group) • Threshold for Alerts • Format of Information for Research / Correction • Basic in Email / Text • Detail Report www.cdg.ws

20. USAGE FRAUD DETECTION (CNTD) www.cdg.ws

21. NPAC • Information at the Line Level • Identifies Service Provider (ownership) • Identifies Line Type (wireless, wireline, paging, etc.) • Routing Code (LRN) • CDG would Receive Daily Updates • File would Contain Information for Canada and US • An Additional Fee would be Assessed to Cover License www.cdg.ws

22. www.cdg.ws