Washington Metropolitan Area Transit Authority (WMATA) — Automation Frameworks
Background
WMATA operates a wide range of enterprise applications to support safety, operations, and workforce management. These included the Safety Management System (SMS), Hazard Management Module, ProWatch access control, Metroview, Radio Run Tracking, Safety Dashboard, Cognos/SSRS reporting, SharePoint upgrades, and PeopleSoft HCM. With frequent upgrades, integrations, and compliance requirements, WMATA needed automation strategies to accelerate regression testing, validate large datasets, and ensure reliability across mission-critical systems.
Challenge
The breadth of WMATA’s technology ecosystem created significant testing demands. Safety and hazard modules required validation of workflows, reporting accuracy, and data integrity across multiple databases. SharePoint and reporting integrations demanded regression coverage during upgrades and patching. PeopleSoft HCM required validation of sensitive HR and risk management data across multiple modules. Manual regression testing was time-consuming and resource-intensive, often delaying release schedules. The challenge was to design automation that could reduce repetitive effort, ensure accuracy, and integrate seamlessly into release cycles while supporting compliance and operational readiness.
Solution
Our team designed and implemented a comprehensive automation strategy tailored to WMATA’s enterprise systems. Using HP QuickTest Pro (QTP) and Unified Functional Testing (UFT), we developed modular, data-driven, keyword, and hybrid frameworks from scratch. Automated scripts were created for SMS and Hazard workflows, including automated report generation and data comparison routines that eliminated hours of manual validation.
Parameterized scripts were integrated with databases, Excel sheets, and environment variables to support dynamic test data. Automation was extended to backend validation through SQL queries across Oracle, SQL Server, and MySQL databases, ensuring data integrity across modules. Scripts were scheduled for unattended execution using task schedulers, batch runners, and driver scripts, producing complete reports without manual oversight.
Automation also supported disaster recovery and failover testing, ensuring continuity of operations. Integration with HP Quality Center enabled centralized scheduling, defect reporting, and traceability. Performance and load testing were executed using LoadRunner, providing insights into system scalability and resilience.
Results
The automation initiative delivered measurable improvements:
- Regression cycles reduced from weeks of manual effort to hours of unattended execution
- Automated Hazard and SMS report validation saved significant QA time and improved accuracy
- Parameterized, data-driven scripts improved coverage across multiple environments and datasets
- Automated validation of Cognos/SSRS Reports data ensured compliance and reliability across modules
- Integration with Quality Center provided traceability, defect reporting, and centralized execution
- QA resources were freed from repetitive tasks, enabling focus on analysis, oversight, and exploratory testing