Reports & Billing Department
US-Based Hospitality Company
Situation: A US-based hospitality client relied on complex client, facility, and transactional data stored in databases. They initiated a project to build a new centralized "Reports & Billing" department as a standalone product. The challenge was ensuring accuracy of financial calculations, data aggregation across multiple sources, and timely delivery of critical client invoices and P&L statements.
Task: As QA Team Lead, I architected a comprehensive quality strategy to validate the entire data pipeline—from source systems to final reports and bills—and built a future-proof test automation framework to ensure regression stability, moving the team away from purely manual verification.
Action: I led a shift-left approach collaborating with Business Analysts during requirements engineering to create testable acceptance criteria. I designed a hybrid automation framework:
- API/Data Layer: Used ReadyAPI with data-driven tests validating business logic and calculations at the service layer, including complex SQL queries for data transformation verification.
- UI Layer: Built Selenium WebDriver framework in Python for end-to-end validation of report generation, user interactions, and billing statement presentation.
- Team Leadership: Mentored QA team on automation best practices, transitioning them from manual testers to automation-capable SDETs.
Result: The "Reports & Billing" product launched successfully as a dedicated, revenue-generating service. Our automation strategy reduced the regression cycle for critical billing functions by over 90% (from days to hours), establishing a scalable foundation for future enhancements.