Telecommunications Operator

  • Print

 

To attend court orders, regulatory or customers complaints  for reissuance of old telephone bills is a complex process for telephone companies. Currently our customer has a database including over 60 billion registrations to be consolidated and combined for redesign the bills. In addition to the delay, the cost is also high: Storing files on backup tapes is expensive, and relies on the specific knowledge of the person in charge of storage for retrieval and use.


In searching for an alternative, StoneAge was contracted to develop a Storage and Recovery of Bills Project, a dataset structured with detailed information on telephone bills to attend not only the storage and recovery information needs, but also the need for more sophisticated data analysis.


Using extreme IQ, a quality and ETL tool designed by StoneAge, the files containing the lines of each telephone bill over the last 10 years were recovered. Even the registrations stored on tapes of unknown format were recovered and used...


Then, a dataset was developed by using the eXtreme database manager. These bases containing different visions of each line of the telephone bill over the last 10 years, allow the compact storage of information, and the efficient access, segmentation, filtering and recovery of any telephone bill in that period.
Finally, by using eXtreme OLAP the end users of information may not only recover old bills, but also analyze and carry out tasks of Business Intelligence on a dataset of information which had been considered lost, and difficult to work because of the volume of information.


Some benefits:


•   Compression of original volume of 100 Terabytes to 9 Terabytes.
•    Efficient storage of over 60 billion of registrations.
•    Savings of U$10 million in the hardware cost only.
•    Total elimination of delay in the information recoveries (data provided online).
•    Possible BI studies on the entire database.
•    Recovery of R$100 million resulted from the recovery process of paid taxes.

Return on investment of over 1,000%.