Case Studies

Telecommunications Provider

TechSafari was engaged by the On-Going Support organization of a large ILEC, CLEC, and long distance telecommunications service provider in November 2002, with the objective of reducing the running time of the end-of-day batch processing of the billing system. TechSafari was able to make a near immediate impact on some of the longest running processes. TechSafari was able to affect a 500% improvement in processing time of the end-of-day batch processes, and orders of magnitude improvement in customer service application and report production times. TechSafari also re-engineered several services within the customer service and provisioning application, the performance of which at the time had rendered the application unusable. TechSafari’s efforts allowed the application services to return to availability within 72 hours. Over the several months that followed TechSafari continued to implement improvements, taking customer service transactions from minutes to sub-second wait time, drastically reducing call handle time for hundreds of customer service reps in the call centers. TechSafari also:

• Produced a suite of tools to measure batch job performance, performance of the services that enable the customer service application, and identify potential scalability issues.
• Reduced the processing time for the extract and load processes of billing system data for the data warehouse by over five times.
• Tuned over a dozen generic billing system data layers improving the performance of both batch processes and the customer service applications.

These improvements ranged from five fold to ten fold increases in performance. Tuned over a dozen billing system reports being produced during end-of-day or end-of-month. These improvements ranged from two fold to fifty fold increases in performance. Identified and produced workarounds for processes affected by an I/O latency problem that a new hardware platform introduced. Increased the performance of the extract
and load processes of billing system data for a reporting database.
The most expensive process was rewritten to produce a twenty fold
increase in performance.

TechSafari also:

• Produced a suite of tools to measure batch job performance, performance of the services that enable the customer service application, and identify potential scalability issues.
• Reduced the processing time for the extract and load processes of billing system data for the data warehouse by over five times.
• Tuned over a dozen generic billing system data layers improving the performance of both batch processes and the customer service applications. These improvements ranged from five fold to ten fold increases in performance.
• Tuned over a dozen billing system reports being produced during end-of-day or end-of-month. These improvements ranged from two fold to fifty fold increases in performance.
• Identified and produced workarounds for processes affected by an I/O latency problem that a new hardware platform introduced. Increased the performance of the extract and load processes of billing system data for a data warehousing and reporting database. The most "expensive" process was rewritten to produce a twenty fold increase in performance.

Experience & Depth:

Experience Overview

Case Studies