Email a colleague    

July 2012

Versatile, Portable & Corrections-Savvy: Quest for the Swiss Army Knife of Revenue Assurance Software

Versatile, Portable & Corrections-Savvy: Quest for the Swiss Army Knife of Revenue Assurance Software

Revenue assurance maturity: perhaps it’s time for that concept to mature as well.

talkRA’s Eric Priezkalns and the TM Forum have both developed models for assessing the maturity of RA organizations.  Independently, colleague David Sherick and I came up with our own Five Dimensional Model of Revenue Assurance -- yet another maturity guide.

But our conception of what the RA practice is about moves on.  And that’s a healthy change that advances our art.  As for myself, I find the more client engagements I have, the more insights I gain, and a few contracts later certain RA problems or functions loom much larger and more significant than I formerly thought.

One area I think we maturity modelers have failed to shine enough light on is corrections.  Finding revenue leaks is wonderful stuff, but we also need to implement fixes to correct the historical issue and reduce the chance of further errors.

So in this column, I’d like to examine this area of RA corrections a bit.

Manual Processes: The Key Challenge of Corrections

RA problem identification and corrections are really two sides of the same coin.

On the mobile side, one of the standard reconciliations is between the HLR, the contract and the billing system.  Over the years, RA departments have gotten pretty efficient at identifying the discrepancies, but the manual fixes to these problems are another story.  Wouldn‘t it be handy to have an automated tool that could accurately make changes to the CRM, HLR / IN and Sales Order Systems?

On the fixed side, with leased circuits, one of the standard leakage measurement points is ensuring that network inventory matches what was ordered by customers.  And finding mismatches leads to many areas of potential correction: fixing incorrect invoices; modifying facility orders, and making changes to recover stranded assets.

These mobile and fixed examples actually share much in common.  Both situations call for comparing two different data sets and correcting one or another without introducing any further errors.

So what is the most likely source of correction those errors?  You guessed it: the manual entry phase, whether it’s the classic mistyping of numbers, lack of training, people being hurried, or users just getting bored or distracted.

Why are So Many Systems Still Stuck in Manual Drive?

For years, we’ve recognized that manual systems are the source of so many data integrity problems, but our industry never seems to tackle this problem.

Walk through your various business processes, Prospect to Cash, Network Management, and so on, and see many local databases and spreadsheets in use.  Why?  Well, mainly because people do not consider the original source data to be accurate or fit for their purpose.  At this point, you can begin to see one of the new challenges for RA: identifying sources of accurate data and ensuring that their accuracy is maintained.

Be honest — how many of you are seeing new manual billing processes sprouting up in your organisation?  Quite a few of you, I suspect.  When an innovative product or service is produced, marketing exerts pressure to get the product launched, and they are simply not going to let billing automation delay their time table.  The result?  Manual billing becomes an ugly, but necessary expedient.

This was certainly the case during the early days of GPRS — which is why the service was often given away for free.  It was also the case for MMS back in the dark days, and I suspect that today’s advanced LTE services are also getting deployed faster because the invoicing is being handled manually.

Yet, as we all know, manual invoicing is manageable when you have only 10 subscribers, but as soon as the subscriber count mushrooms into the hundreds or thousands, it becomes unwieldy.  Unfortunately, management usually finds more pressing things to spend its budget on than billing automation.

On the RA side, there is always the requirement to recalculate the bill.  Sure, the tariffs need to be checked.  But there other reasons, too.  The Sales department wants to show the savings that would have been earned by a potential client.  Sometimes the customer is on the wrong bundle so Customer Services needs to recalculate the bill with the correct bundle to calculate the credit.  This simple kind of automation would benefit any number of departments.

Ah, but there’s a catch: the problem is usually not considered of sufficient weight or priority to warrant a project And since it was not part of the initial planning process, there’s no budget for it anyway.  The other stumbling block is IT.  Automated -- or even semi-automated -- interfaces into mission critical BSS and OSS systems raise a red flag.  What if they should cause a system crash?  Effectively, this means IT will never give you free reign in the design.  Oh, and IT has neither the time nor budget to work on your project.  In other words, good luck.

Fantasies of an All-Purpose Revenue Assurance Gadget

I have no simple solution for the problems I’ve just described.  And since I’m not a software developer, I can only point to the usefulness of such a solution, but cannot build it on my own.

Yet from an RA Consultant’s perspective, wouldn‘t it be cool if you could walk into an organisation, look at any one of their problems, and deliver a solution within the normal timeframe of your contract?  And wouldn’t it be nice if that solution was affordable and versatile enough that you could apply it to other areas as well?

Hence we arrive at the notion of a “Swiss Army Knife” RA solution.  For those of you who don‘t know the name, the Swiss Army Knife is a portable all-purpose gadget made by Victorinox that comes with a wide range of tools folded into the body.  There is a knife, but you can also get a pair of scissors, a file, a screwdriver — the high tech version even comes with an USB drive.  In short, it’s a device to tackle many small jobs and that anyone can use.

So what would this RA Swiss Army Knife look like?  Well, here’s a quick list of the functionality I’m looking for:

  1. RA Analyst Friendly -- The tool should be simple to configure and maintain using the skills of a competent, but trained, RA Analyst.
  2. Easy Data Loading and Extracting — It should be simple to interface to different systems to extract or input data across a variety of formats.
  3. Versatile in Deployment -- The software should be designed to address a few problems in one area but be flexible enough to be used in another part of the process chain.  In one department it will help reduce the error rate by fixing a process.  In another, it will manage provisioning.  In still another, it will re-rate customer invoices.
  4. Suggests the Corrections -- Not only will the tool run the analysis and identify errors, it should also suggest what fixes are appropriate -- which once given the go-ahead, are then implemented.  NOTE: I am not a fan of auto-fix solutions where the system decides what is wrong and automatically makes the changes.  I prefer to have control over the proposed fix before it’s implemented and -- if necessary -- do some secondary checks.
  5. Relatively IT Free -- The tool should not require extensive IT support or maintenance.  Once you have the buy-in from one department, others can see how the approach works and will recognise how something similar can work for them.
  6. Low Cost and Quick-to-Deploy -- Small operators especially need quick-to-deploy, lightweight systems.  These come from firms such as CxB solutions and more recently, CenterView, or self-built tools using either SQL or programs such as ACL, MS Access or MS Excel.  These systems are generally either designed in-house or with the aid of an independent consultancy such as my firm, raaiim.  We need the same speed of deployment in systems that not only identify the errors but also have the ability to perform the fixes.
  7. Cross Industry Application -- Ideally, the solution should be flexible enough that it can even be used in, say, the utility industry or another one outside of telecom.  This would be a natural evolution since the rationale and approach would be the same, though the systems would be different.


So, where do I get one of these tools?  I wish I knew.  The elements of such a multi-purpose tool are certainly available from the many software vendors serving our market, but pulling together a unified tool is probably a long ways off.

Yet the benefits are tantalizing.  It could dramatically reduce the number of unrecognized errors and substantially lower an organization’s revenue risks.

Isaacson on Steve Jobs

NOTE: For further reading here, I suggest an excellent free book excerpt entitled, “Thirteen causes of enterprise data quality problems” by Arkady Maydanchik.

Copyright 2012 Black Swan Telecom Journal

Mark Yelland

Mark Yelland

Mark Yelland has been working in the revenue assurance and fraud space for over 20 years.  For the last five, he has run a small consultancy firm, RAAIIM, targeting the smaller and newer operators, helping them get started or improve their revenue leakage and risk management.  Showing them what can be achieved with minimal spend — getting more out of their existing systems, or developing tools using open-source products.

Like all engineers, he enjoys solving problems of all types, trying to find elegant, cost effective and simple solutions to big problems.  His engineering training comes from the degree course at Cambridge University and his business skills come from the Open University MBA.   Contact Mark via

Black Swan Solution Guides & Papers

cSwans of a Feather

  • The Revenue Assurance Game: How the Rules Change in the Era of IoT & Mobile Broadband interview with Rene Felber & Gadi Solotorevsky — Revenue assurance is perhaps the hardest of telecom functions to define because the term is used in so many different senses.  This discussion on the evolving role of revenue assurance was catalyzed by a survey of experts in the profession.
  • Day in the Life of a Revenue Assurance Analyst interview with Michael Lazarou — Revenue assurance is much more than a software category.  It’s individual analysts struggling to help their larger organizations get a handle on system errors and coordination problems.  In this interview, an analyst reveals the many challenges of getting the revenue assurance job done at a small GSM operator in Europe.
  • Revenue Assurance: History and New Beginnings in RA Maturity interview with Daniela Giacomantonio & Gadi Solotorevsky — The Roman Forum was the center of commercial life in ancient Rome.  Now, two millennia later, the Forum lives on in the exchange of ideas across countless professions and  media.  In this interview, two Revenue Assurance experts discuss both the new RA Maturity initiative of the TM Forum and the value of telco/solution vendor collaboration.
  • Versatile, Portable & Corrections-Savvy: Quest for the Swiss Army Knife of Revenue Assurance Software by Mark Yelland — Revenue assurance maturity models are not cast in stone.  Since  best practices will change over time, it’s healthy to explore moving maturity models forward.  For example, great gains have been made in leakage detection, but RA corrections has been harder to master.  The author dreams about seven functions that should ideally come together in a single all-purpose revenue assurance software tool.
  • Revenue Assurance Maturity: Report From the Arena interview with Eric Nelson — Revenue assurance maturity can‘t be easily computed.  How do you  compare the KPIs of Comcast billing with that of mobile money RA in Western Africa?  Even still, this article offers some universal RA wisdom from a straight-shooting veteran of carriers large and small.  Topics discussed include: dashboard or process, COTS vs. inhouse solutions, and tips on gaining internal support for the RA practice.

Related Articles