Integrated Revenue Maximization Analytics

AGENDA

TeleArc’s IRMA Platform Offerings

• Revenue Assurance

• Fraud Management

• Optimal Routing

• Revenue Data Analytics

www.telearc.com

TeleArc’s IRMA Platform at a Glance

• Architecture

• Appliance Configuration

• Deployment

• Product Reports and Screen-shots

www.telearc.com

Revenue Assurance

Fraud

Management Optimal Routing

Revenue

Data Analytics

Integrated Revenue Management Analytics (IRMA)

TeleArc’s Integrated Revenue Maximization Analytics (IRMA) offers Unified Platform enhancing Revenues and Profits across the CSP’s Revenue Value Chain. IRMA is a heterogeneous Platform with high flexibility to offer multi functional products. The Cross Functional Platform houses Multiple Telecom Solutions

IRMA Introduction

Pre-paid Post-paid

Wire line VAS

Roaming Interconnect

Collection

Billing

IN

Real-time

Billing

Vouchers

Switch

Mediation

Billing

CDRs

Invoices

Mediation

TAPIN

TAPOUT

DCH

RAP

Dual

IMSI

Invoices

Service

Billing

Revenue Services

www.telearc.com

Revenue Assurance Offering

Vertical Voice VAS Data

Wireless – GSM, CMDA and MVNO

Fixed

VoIP

Enterprise Solution ISPs, IPLC, ILL, Ethernet

Retail Broadband

IPTV

www.telearc.com

Revenue Assurance – Technology Scope

Fraud Types Addressed

TeleArc’s Fraud Management Enables

Fixed Line Fraud

Subscription Fraud

Call Hijacking

Internal Fraud

Roaming Fraud

Interconnect Fraud

One point solution to varied types of Fraud

Real Time Detection of Fraud

Hotlist of Suspicious Subscribers, Equipment & Destination

Analyzing Data Feeds & Reporting Discrepancies

False Answer Supervision

Data Fraud

Cloning Fraud

Mobile Money / Wallet

Credit Card Fraud

Content and VAS Fraud

At TeleArc we believe, FMS skills sets needs to be enhanced to deal with these challenges

Strategic Roadmap &

Profiling

ETL

Alarm & Thresholds

Reports

Tracking &

Monitoring

Risk Assessment

Constant Monitoring, Protection & Improved Customer Relations

Effective Fraud Investigation reducing Customer Churns

www.telearc.com

Fraud Management

Need for Optimal Routing

TeleArc’s Optimal Routing enables

Quality of Termination

Dynamic change in the Rate Sheets

Cost Concerns

Number Portability Concerns

High Interconnect Cost

Increased concerns on varied Rate Sheets

Automated Optimal Routing

Near Real Time Routing Engine

Optimize Operating Efficiency

Reduced Interconnect Costs

At TeleArc we believe, OR finds the balance for falling margins with multiple business and products available

Deliver Reliable & High Quality Services to Subscribers

Strengthened Service Quality

Multi Format Rate Sheet & Currency Normalization

Routing on QoS Metrics such as ASR, ACD, PDD

www.telearc.com

Optimal Routing

Marketing Analytics

•Tariff and Pricing model Analytics • Real time ROI Analytics of multi-campaigns approach •Loyalty / Reward Profiling Analytics •Basket Offering / High value customer retention analytics

Revenue Analytics

Customer Care Analytics

•Customer Profiling & Predictive Models •Split ARPU Analytics •Identify most at risk customers •Build co-relation models between Customer complaints / Problem resolution / Churn

Network/ Infrastructure Analytics

• Network Fault / Root cause Analytics •Network Impact Analytics – Routing changes, load changes etc • Radio Resource Utilization Analytics / Predictive model •Switch Data Analytics

Churn Analytics

•Churn history profiling & patterns and inter-predictor correlations •Network specific / Customer specific predictor Index •Network specific customer life span patterns •Churn Location- Identifying areas with higher Churn Rates and providing appealing offers

•Multi-point Discrepancy Analytics in Real Time (Switch / Billing / TAP / RAP Interconnect / Payments etc) •Network wise roaming revenue utilization •Payment Risk Analytics •Automated Dispute Tracking, Reporting capabilities to analyze financial and network cost information from disparate data sources

www.telearc.com

Revenue Data Analytics

API Integration

BI/UI Layer

Appliance Layer

Analytics Layer

Mediation Recon

KPI Dashboards Alerts Cases Users Admin

C1 C2 C3 C4

C5 C6 C7 C8

Database Layer

Node Data Distribution

Querying

Data

Loading

Hash Key

Generation

Child Table Creation

Rating OR Engine

Revenue Assurance Optimal Routing Data Analytics Fraud Management

An

aly

tic

s P

latf

orm

Integrated

Revenue

Analytics

Platform

TeleArc Analytics Platform Architecture is logically divided into four layers and each layer makes use of latest technologies in hardware and software

Reports

Analytics Engine Fraud Detector

www.telearc.com

IRMA – Architecture

OS

Storage

Storage

Storage

Storage

Storage Storage

Storage

Grid coordinator

Grid agent

Grid agent

Grid agent

FTP Server

Gigabit Ethernet

Highlights

www.telearc.com

IRMA – Appliance Configuration

• Hex Core Intel Xeon E5-2620, 2 GHz , 1333 MHz

FSB, 15 MB L3 Cache

• Intel Server Board S2600CP2

• 8GB DDR3 RAM

• 8x 2TB SATA HDD

• SATA RAID Card

• Dual NIC

• Gigabit Ethernet

• Connected through Analog KVM Switch

• Data Storage can be easily extendable depending

upon subscriber base

Firewall Web Server

Gigab

it Ethern

et

Telco G

igabit Eth

ernet

Intranet

Users

Telco Network

Analytics Appliance

Internet

www.telearc.com

IRMA – Deployment

www.telearc.com

Product Screenshot

www.telearc.com

Mediation

www.telearc.com

Recon Fields Configuration

www.telearc.com

KPI Monitor

www.telearc.com

Rating

www.telearc.com

CDR Analysis

0

100000

200000

300000

400000

500000

600000

2013-08-18 2013-08-19 2013-08-20 2013-08-21 2013-08-22 2013-08-23 2013-08-24

Co

un

t CDR_Count_Voice_Summary_Trend-Pre-paid vs Post-paid

Prepay-IDD

Prepay-National

Prepay-Local

Postpay-IDD

Postpay-National

Postpay-Local

Streams 2013-08-18 2013-08-19 2013-08-20 2013-08-21 2013-08-22 2013-08-23 2013-08-24

Prepay-IDD 6394 6896 5749 6827 6817 6943 6240

Prepay-National 470206 562221 431371 560939 545614 545730 514346

Prepay-Local 117098 148045 108029 149593 145471 145772 129028

Postpay-IDD 5058 13864 8195 14178 13903 11733 4653

Postpay-National 104406 293772 97425 307674 295669 292663 165734

Postpay-Local 37439 147845 33526 162324 157188 151223 74350

*Pre-paid National is having maximum CDR counts followed by Post-paid National CDR Counts

www.telearc.com

High Usage Revenue Risk Reports

Report Name : High Usage Report Exceeding 60 Minutes in Single Call

Operator : Telco 1

Prepared By : TeleArc

Report Date : Wed Dec 11 16:37:10 IST 2013

High Usage Report Exceeding 60 Minutes in Single Call

Voice Calls Usage Summary exceeding 60 Minutes in Single Call on Pre-paid & Post-paid

Stream MO CFW Grand Total

Post-paid 6206 0 6206

IDD 4061 0 4061

Local 1717 0 1717

National 428 0 428

Pre-paid 268 1 269

IDD 12 0 12

Local 52 0 52

National 204 1 205

High Usage-Voice Report – Pre-paid and Post-paid Billing

*High Usage Calls are high in Post-paid when compared to Pre-paid with IDD call_category

www.telearc.com

Revenue Trends - ARPU

0

1

2

3

4

5

6

2013-08-18 2013-08-19 2013-08-20 2013-08-21 2013-08-22 2013-08-23 2013-08-24

AR

PU

in L

KR

ARPU_Voice_Report _Pre-paid_vs_Post-paid

Prepay

Postpay

Streams 2013-08-18 2013-08-19 2013-08-20 2013-08-21 2013-08-22 2013-08-23 2013-08-24 Pre-paid 4.985549549 5.429786639 5.008064794 5.558301504 5.661818807 5.644483568 5.354882877 Post-paid 3.816337373 4.819720856 4.064538866 4.886412808 5.029335503 4.908473175 4.457545511

*ARPU from Voice Calls at Weekends is good in both revenue streams when compared to other days

www.telearc.com

Profitability Analysis

www.telearc.com

Dashboard

Thank You!!