fraud and ra dashboard and kpi sample

8/9/2019 Fraud and RA Dashboard and KPI Sample

http://slidepdf.com/reader/full/fraud-and-ra-dashboard-and-kpi-sample 1/6

Platform

orProcess

KPIName

KPICode

Usag

eCompleteness

Rating&Ch

argingAccuracy

SubscriptionAssurance

Revenuesav

edvsrecovered

Subscription completeness 001 x

HLR vs. Post Paid Billing System 100 x

Post Paid subscribers Count 101 x

Post Paid subscribers Status 102 x

Post Paid subscribers active services 103 x

HLR vs. Pre Paid System 200 x

Pre Paid subscribers Count 201 x

Pre Paid subscribers Status 202 x

Pre Paid subscribers active services 203 x

HLR vs. Value Added Services Platform(s 500 x

MSC CDR vs. IN CDR 210 x

MSC CDR vs. SMSC CDR 011 x

MSC CDR vs. Mediation OUT CDR 012 x

Overall CDR Completeness 010 x

Rejected Files 021 x

Incorrect filtering 022 x

Mediation to Billing 121 x

Mediation to Roaming TAP OUT 424 x

Mediation to Roaming TAP IN (MTC ONLY 425 x

Mediation to Interconnect 326 x

Mediation processing completeness 020 x

Overall Mediation

SMSC CDR vs. Mediation 031 xSMSC CDR vs. Post Paid Billing 131 x

SMSC CDR vs. Prepaid IN 231 x

SMSC CDR vs. Roaming (outbound) 431 x

Overall SMSC

Negative Balances 241 x

Balance movement validation 242 x

Deferred Revenue Reconciliation 243 x

Vouchers/Charging accuracy 244 x

Discounts/rates reporting 245 x

Prepaid rating accuracy 246 x

Prepaid reporting accuracy 247 x

KPI ClassKPI ID

Mediation

Subscriptio

nAssurance

MSC

SMSC

IN



Overall IN


Trunk groups reconciliation 352 x

Interconnect rating accuracy 353 x

Interconnect reporting accuracy 354 x

Days Sales Outstanding 355Overall Interconnect

Operators list completeness 461 x


Roaming system in/Out 463 x

TAP OUT vs. FCH invoices 464 x x

TAP IN vs. Billing System 465 x

TAP OUT Rating 466 x

TAP IN Rating 467 x

FCH reports 468 x xRAP OUT completeness 469 x

Days Sales Outstanding 470

Overall Roaming

Rejected records 171 x

Rating Accuracy 172 x

Billing success 173 x

Bill cycle verification 174 x x

Reporting completeness/accuracy 175 x x

Days Sales Outstanding 176

Overall Post paid Billing

Call failure rate 002 x

RA Savings ($) 003 x

RA Recoveries ($) 004 x

WholeSale Vs. Retail Sales 005 x

Billing

Others

Interconn

ect

Roaming



Timeliness

ControlPoint01

DataType01

ControlPoint02

DataType02

Remarks

1xxPost-paid

2xxPre-paid

3xxRoaming

The sum of KPIs x x x

HLR Dump Billing Dump Sum of the postpai x

HLR Dump Billing Dump The delta between x

HLR Dump Billing Dump Active subs on HL x

HLR Dump Billing Dump Services defined o x

HLR Dump IN Dump Sum of the prepaid related KPIs

HLR Dump IN Dump The delta between subs on th x

HLR Dump IN Dump Active subs on HLR but inacti x

HLR Dump IN Dump Services defined on HLR but x

HLR Dump VASP Dump Services defined o x x

MSC CDR File IN CDR File Reconcile the volume of CDR x

MSC CDR File SMSC CDR File Reconcile the volu x x

MSC CDR File Mediation CDR File Reconcile the volu x x

The sum of the a x x x

Mediation Inputs Mediation ejected fileVolume of rejected x x

Mediation Inputs Mediation ejected fileVolume of wrongly x x

Mediation Inputs Billing CDR Files Volume of post pai x

Mediation Inputs Roaming CDR Files Volume of roaming in records reaching m x

Mediation Inputs Roaming CDR Files Volume of roaming out MTC records reac x

Mediation Inputs nterconnecCDR Files Volume of interconnect records in mediation not rea

Mediation Inputs Mediation Outputs Total volume of pro x x

SMSC CDR files Mediation Inputs Volumes of CDRs i x xSMSC CDR files Billing CDR Files Volume of Post Pai x

SMSC CDR files IN CDR Files Volume of Pre Paid SMS CD x

SMSC CDR files Roaming TAP IN Volume of Roaming in SMS CDR comple x

IN database total volume and value of cust x

IN database apply the formula IN ending b x

IN database validate the financial system's x

IN database VOMS database valide the amount of recharge x

IN database automatic discounts/rating tab x

IN CDR files recalculate a sample CDRs u x

IN database IN Report Validate that IN reports includ x

Control Points & Data Types Revenue



Interconnec database automatic discounts/rating tables in interconect syst

Interconnec database MSC database reconcile trunk groups on MSCs vs. interconnect billi

Interconnec CDR files recalculate a sample CDRs using published rates to

Interconnec CDR files nterconnec database Validate that interconnect reports include all CDRs in

x nterconnec database Number of days interconnect debits remain outstand

Roaming Database MSC database validate the names of active roaming part x

Roaming Database automatic discounts/rating tables in roami x

Roaming Inputs Roaming TAP Out ensure the completeness of CDRs proce x

Roaming TAP OUT FCH Report review the completeness and accuracy of x

Roaming TAP IN Billing CDR files Ensure the completeness of CDRs proce x

Roaming TAP OUT Re-rating of sample TAP OUT records to verify ratin

Billing CDR files Ensure the accuracy of Roaming CDR ra x

FCH Report Roaming Input Ensure the completeness and accuracy o xRoaming AP Outpu FCH Report Ensure the completeness and accuracy o x

x Roaming Database Number of days roaming debit remains o x

Billing database % of rejected recor x

Billing CDR files recalculate a samp x

Billing database % of successful bill x

Billing database Validate rating, dis x

Billing database Billing reports Validate that billing x

x Billing database Number of days bill x

Call faluire rate x x x

Total amounts sav x x x

IC System CDR Files illing,Roa CDR Files Compare IC OUTP x x x



4xxInterconnect

Voice

SMS

SMSVAS

x x x x

x x x

x x x

x x x

x x x

x x x

x x x

x x x

x

x x x

x x x

x x x x

x x x x

x x x x

x x x x

x x x

x x x

x

x x x x

x x x x

x xx x

x x

x x

x x x

x x x

x x x

x x x

x x x

Affected



x x x x

x x x x

x x x x

x x x x

x x x x

x x x

x x x

x x x

x x x

x x x

accuracy

x x x

x x xx x x

x x x

x x x

x x x

x x x

x x x

x x x

x x x

x x x x

x x x x

x x x

fraud and ra dashboard and kpi sample

Documents