QA automation for a 650K-user platform

Overview

At BC Pension Corporation I worked as a Software Developer in Test on a large-scale web platform serving over 650,000 active users. The role combined automated functional testing with hands-on SQL work: building out a keyword-test suite in TestComplete, then writing the Oracle SQL queries needed to validate the data behind it and track down performance bottlenecks.

Highlights

• 01

  Developed a suite of 120+ automated Python tests in TestComplete for a large-scale web platform, enhancing QA traceability in Jira and improving release confidence for 650K+ active users.

• 02

  Designed and optimized 220+ advanced SQL queries within Oracle for functional and performance testing, uncovering data bottlenecks and improving query efficiency by 30%.