Archive for the Quizzes Category

Welcome to this month’s LTT. You work for Acme-Telecom and it’s your first day in the job. You receive a phone call from the CFO’s secretary requesting you to meet him at 9am in his office. When you enter the room the Wholesale Manager is also sat at the table with a handful of papers and looking a little dismayed. He shows you the interconnect voice traffic stats for the month, which shows an unexpected decline on Monday 24 November.

LTT - 12

Figure 1: Interconnect voice traffic statistics for November.

The Wholesale Manager also shows you a screenshot of the termination rates being offered on the wholesale market in to Acme-Telecom. One particular company, called Dubious Voice Solutions, is offering rates which are lower than your termination rate.

When you entered the building this morning, you can remember seeing all the posters from the latest marketing campaign, offering 1000 on-net minutes for $2 per month. The launch day was Monday 24 November.

This is your chance to impress the CFO on your first day in the office. He asks you to put together an action plan detailing all the controls, reconciliation, and tests that would help to stop this revenue leakage. He wants to meet you for lunch to discuss your proposal.

What is mostly likely to be the problem, and what would your plan of action be?

  • A = Drop in traffic due to half-term school holidays
  • B = Grey routing / Sim boxing
  • C = Trunk route information missing in i/c billing system
  • D = An increase in the termination rate
  • E = None of the above

Please send your answer along with the plan of action to – the most comprehensive action plan received will be published on Monday 22 December, as a guest blog.

Bookmark and Share

In September I asked for opinions about changing the content of talkRA. Some of the responses reminded me of things people have been telling me for ages, both offline and online…

  • What happened to the lunchtime teasers?
  • Those quizzes were fun. Do more.
  • I liked doing the LTT, are you going to run more?
  • When will the L.T.T. return?
  • Do more of those puzzles you used to have.

There is no doubt about it: Lee Scargall’s L.T.T. developed a devoted following. Despite being incredibly busy with overseeing risk for the whole of the Ooredoo Group, Lee has bowed to popular demand, and made time to write a new question. Tune in Monday, quiz fans!

Bookmark and Share

This months LTT by Arun Rishi Kapoor was won by Abhijeet Singh from Subex for providing the first correct answer.



Congratulations to all those who took part in this months quiz. The next LTT will be published on Monday 16th December.

Bookmark and Share

Welcome to this month’s LTT by Arun Rishi Kapoor.

Crossword Challenge

LTT11 - 1


1 Call me if you have enough money for fun and games (3)
2 An insider’s con (8,5)
3 Micro is bigger brother of mini and nano (3)
4 Default passwords may brings this to you (3,7)
5 High speed data (3)
6 If two operators A and B are not ________ partners then it would not be possible for a customer of Operator A to communicate with a customer of Operator B (12)
7 Committed to fighting mobile Industry crime (4)
8 Use me to bypass phone company and its charges (4)
9 Technologies that have reduced the amount of power and time necessary for information to be communicated (3)
10 Control & supervises the Base Transceiver Stations (3)
11 Transfer of identity. Recall Mi2 (7)


8 Roaming network (4)
9 Part of IMSI to identiy the country (3)
12 A database of all subscribers (3)
13 Internet Protocol (2)
14 Causes interconnect termination revenue loss (6)
15 A tool to detect & prevent crime (3)
16 Optic fiber technology  of a broadband network architecture (4)
17 Largest mobile telephony in US (4)
18 Aim to optimize a service providers operational and process infrastructure (3)
19 Geographic position (4,4)
20 Local loop on which origination and termination of call happens (4)
21 Fraud occurs mainly where credit checking procedures are tightly controlled and fraudster uses another persons ID (5)
22 Happens when services are delivered but not billed (7)


5 Police services for Telecommunications (3)
10 Creditor’s loss (3,4)
23 Consists of fiber optic, telephone, cellular networks and comms satellites. Even consists of undersea cables interconnected by switching centers (4)
24 A third generation mobile cellular system developed by 3GPP (4)


25 Expert opinions for communication providers (4,2)
26 An act to steal (5)

Please send your completed answers in this file to

Bookmark and Share

This month’s LTT by Arun Rishi Kapoor was meant to illustrate that operational performance can be enhanced by fine tuning the alarm rules, to eliminate unnecessary false alarms. This would then allow the RA-FM team to also concentrate on alarms coming from the new roll out of 4G/LTE and Mobile Money services, without the need to recruit more staff.  

The CFO wanted to know the following:

Which network was contributing to the most number of false alarms?

You need to create a pivot on the (LTT_10_Alarms.xls) file to find the maximum number of false alarms.

LTT10 pic1

The correct answer is Network F.

What configuration entities can be fine tuned in the Industry Alert Violation rule to lower the number of false alarms in the FMS?

Based on the statistics of the pivot on the (LTT_10_Alarms.xls), the following recommendations can be given.

  1. As most of the false alarms are coming from Networks A, B, D, E & F, it would be better to create a separate rule for these Networks. In the extreme case, we could consider turning the alarms off for some of these Networks altogether but this is not advisable for extended periods of time.
  2. Since all of the fraud is being generated in Network C, but is also contributing to some false alarms (41), the Fraud Manager could expand the rule from the first 7 digits (cc+4 digits) to 9 digits (cc+6 digits) to make the rule more accurate.
  3. Out of the 1780 countries in the industry alert dump file, fraud alarms are only found in 15 countries (see table below).

 LTT10 pic2

Thus the three configuration entries – network, country and called number prefix is causing lots of false alarms and requires fine tuning.

How many calls were made to numbers in the Industry Alert Dump File?

  1. In the (LTT_10_xDRs.xls) file, take the NEW CALLED NUMBER field - 7 digits (cc+4 digits) and then copy them into a new column named [CALLED NO (first 7 digits)].
  2. Now do a vlookup of this new column to the column – [Range (cc + 4 digits)] in the (LTT_10_Industry_Alert_Dump.xls) file.
  3. For the B number ranges matching, these are the calls made to the Industry Alert dump.

The correct answer is 2410 calls and can be found in this file.

Congratulations to three times winner, Michael Lazarou, and Deepak Chand for providing the correct answer. The next LTT will be published on Monday 18th November.

Bookmark and Share