Toll Free Reporting : : Call-Center Traffic Analysis


Web-based Reporting and Analytics

Our client, one of the biggest telecommunications companies in the world, was at a significant competitive disadvantage. They were not able to provide their customers with web-based reporting on their toll-free phone traffic. This was a big selling point for their competition and a decision point for many potential customers.

What the client wanted:

Our client needed a database and website that would provide their customers with self-service access to information on their toll-free call traffic.

What SD3 did:

SD3 worked with our client to launch a secure, customer-facing website for toll-free call traffic reporting. SD3 provided the technical project management, application architecture, system design, software development, database administration and web server administration for the project that included:

  • A multi-threaded TCP/IP sockets message processing engine that handles millions of call records each day generated from network events at the switch level
  • A dimensional data model for analytical processing implemented in a highly scalable Oracle database running on Sun servers
  • Secure access to reports via a web browser. These customizable reports enable the business customer to view their call information across a number of dimensions and also to drill down to report details
  • Complete Data and Report export functionality

The outcome:

The website is the source for online decision support, analytics, and reporting on toll-free call traffic. Business customers log onto the website to access their customizable reports. Millions of call messages are received and processed into a highly tuned database. Reports show visibility to calls within minutes of completion. The website has already increased our client’s business, enabling the company to expand their market share and increase overall revenue.


Java (J2EE) architecture (JDBC, JSP, Servlets, multithreading), TCP/IP Sockets, dimensional data modeling, Tomcat Web Server, IBM WebSphere Application Server, Oracle database, and Sun Servers

  • Competitive Advantage
  • Top-Line Revenue Growth
  • Increased Market-Share

<< Back

Contact Us

Case Studies

Customized Mobile Application Development

img3_small Bringing together multiple relevant software platforms, SD3 created an app that streamlines workflow assessment in real-time. Team members in the field can communicate smoothly with home office, each one in sync with work orders, updates and more. Read More...

HipaaCat & My Doctor Note Android and iOS Apps

case_studies_img3 A hospital system that relies on communication of critical and highly private patient information needed a safe way to do so electronically. The forward-thinkers at SD3 developed an app enabling chiefs, residents and nurses to securely send and receive images and/or messages. This required creation of a custom camera application to keep images off the “camera roll” for security and yet still gave full control of image details. Read More...

Data Warehouse Telecommunications

img10_small When the regional arm of a large cellular provided needed a massive tech fix, SD3 provided the solution, in the form of a system to monitor performance of cellular towers to troubleshoot every factor imaginable. This data retrieval and storage system not only earned a Corporate Award for Excellence, but ended up being implemented nationwide. Read More...

Website Development Marketing

img13_small SD3 built a customized marketing site that leveraged the client’s need for a heavy web presence. The environmental services company came away with a site that not only pumped the brand, but enabled the company to access regulatory adherence documentation, product lines, customer education and other critical information. Read More...

Healthcare Network Security

img14_small Multiple Network Security and HIPAA Compliance A healthcare company needed to insure that its computers, databases and networks were safe from ... Read More...