QA Automation for Telecom Service Providers
Case Studies
Challenges & Solutions
Technical Environment
Results
Executive Summary
Client
Telecommunications provider
Industry
Communications & Media
Business Problem
U.S. telecom client required an improved framework for generating automated test data, developing test automations, and executing data movement between systems. A full range of validations was also required to ensure accuracy of results.
Outcome
Developed a framework to generate unique test data and created tools and utilities for moving files to a Linux system. Utilities were also developed to facilitate logging into the Linux system as a root user and executing shell scripts. Tool evaluation and framework development were conducted, culminating in end-to-end automation for test data generation and validation.
Solutions
- Developed a framework to generate customer and employee data in the form of feed files.
- Created utilities to copy feed files from a Windows system to a Linux system via an SSH channel and to update the properties of these files.
- Developed additional utilities to log into the Linux system as a root user (superuser) to execute shell scripts.
- Automated database validation for commission amounts (Net SIM and Net Revenue) and achieved the best Return on Investment (ROI) in test data automation compared to manual execution.
Technical Environment
- Java.
- Jenkins.
- Oracle Database, Linux.
- JIRA.
