Case Studies

Testing Solution for a Major Telecom Provider

Background

Our Client, a major U.S. telecom provider, approached us with a critical project to validate the commission calculations for every customer that utilizes their services and products. They are typically defined as device purchases, data and voice plans, and other additional addons to complement a customer’s completed phone experience.

Customers range across the North American continent, comprised of 3 defined groups: Brick and Mortar stores, independent distributors, and large corporate accounts. Each customer has a specific contract that addresses their finances and commissions that the client pays out each month.

The Challenge

In addition to the large amount of customers in these three groups distributed across the United States, each customer had a customized contract with specific terms and rules that apply only to them. So it was integral to the client to validate every inbound and outbound financial calculation was correct.

Thousands of dollars were being lost because of incorrect calculations due to overpayments. The client has a large backend system that feeds over 5200 logic algorithms that computes the computations of each item in the contracts. Because of the complex set of customized rules, a team of experts was needed to perform advanced data calculations, proficient SQL knowledge, and expertise in testing complex large databases.

The Solution

We assembled a dozen consultants, made up of SQL developers and Test Analysts. The team was physically split into two locations in Washington, and operated in a tactical and methodical way across the country. Each individual was heavily involved with test planning of new feature requirements, partnering closely with agile development teams, and performed full end to end testing throughout the entire cycle. Testing involved test data creation, validating complex mathematical and business logic, and mining every number that is fed through their commissions database to ensure that no penny was miscalculated. While the commissions system was automated, no one customer had the same contract and many customized business logic rules were applied and needed real time collaboration on the right business data.

In addition to new feature testing, our team performed a large set of regression tests, performance tests, UAT tests, and in-depth defect analysis. But even after a full end to end test deployment was completed, our team didn’t stop there. As issues arose in the production, our analysts worked hand in hand with customer support, by filing out post-production tickets, submitting change requests, retesting new logic and deploying hotfixes, and ensuring the regression suite is up to date for the next time.

Post-production issues could range from 1 week to 2 months of investigation and testing. As a result, the overpayment problem was completely resolved. Our partnership with this client continues to grow, as the reliability and performance of our analysts continue to exceed their expectations. Q Analysts continues to find smart and effective ways to improve the quality process with this client, and the work shows high quality through the end.

Browse Q Library

IT Quality Process Management and Execution

BACKGROUND Our client, a major U.S. telecom provider, was in the midst of a very large corporate merger. Both companies had similar System Development Life Cycle methodologies and processes based on…

Integration Platform as a Service

A multinational telecommunications company headquartered in the United States was looking for ways to improve the efficiency of service-oriented architecture (SOA) components that support its…

Offsite Managed Services Testing of New Mobile Operating System

BACKGROUND Mozilla, the creator of the Firefox web browser, was preparing to launch Firefox OS, a Linux-based, open-source, mobile operating system for smartphones and tablet computers that enables…

Q TestLab and Multi-National Telecom Provider Partner on a Messaging App

BACKGROUND Recently, one of the world’s largest telecommunications corporations decided to expand its product line to include an all-in-one messaging service. This ambitious undertaking would…

A Leading International Mortgage Insurance Company

THE CHALLENGE The world’s largest Mortgage Insurance Company was growing at a rapid rate. To keep pace with this growth and implement new Governance controls, the client began a major reorganization…

Custom Test Management Application Developed for a Leading Telecom Company

THE CHALLENGE The central testing organization of a leading telecommunication provider was having trouble identifying and managing the testing needs from projects across a broad range of…

New iOS Mobile Application Testing for Large Coffee Retailer

BACKGROUND Our client, a large coffee retailer, experienced extreme success with its mobile retail application. Twenty-five percent of the company’s loyalty card users also use the mobile app for…

Testing Managed Service for a Leading Telecom Company

THE CHALLENGE The client, a leading provider of wireless services with hundreds of million subscribers, was seeking to improve service levels to its integrated 3rd party resellers. The group…

Testing Competency Development for Home Security Automation

BACKGROUND Our client, a major U.S. telecom provider, was expanding beyond telephone, TV, and internet services to include Internet-based home security and automation services. This new product…

Q Analysts Enables Leading VR Provider to Deliver Highest Quality Product on Time

BACKGROUND & CHALLENGE In order to become a leader in the emerging Virtual Reality (VR) market, one needs to be aggressive. But aggressive goals can cause unexpected challenges. A leading VR…

Top 10 Must-Dos for Testing Mobile Apps

The mobile and mobile testing industry has evolved very quickly in this era and is only going to move even faster due to Rapid Application Development. We live in a world now that despite what…

Send a Message

Contact us now to discuss your project