Guanlin Lu
Mississauga,ON
Summary
QA Analyst with 3+ years of experience in data validation, workflow testing, and evidence-based analysis across complex systems. Skilled in structured control testing, API/UI automation, and documenting clear, traceable results aligned with risk and compliance expectations.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Quality Assurance Analyst
MPAC
Toronto, Ontario
01.2022 - 06.2023
- Executed control design and effectiveness testing for financial-impact property assessment workflows, ensuring governance alignment and data accuracy.
- Conducted stakeholder process walkthroughs to validate data flows and control points, similar to PRC and SOX controls.
- Developed automated UI/API test suites using Playwright, WebdriverIO, and Python, achieving 100% coverage of critical Property Owner Portal workflows.
- Reduced regression testing duration from three to less than one day by implementing automation solutions.
- Designed Python scripts for validating structured datasets (JSON, XML, CSV, Excel, PDF), enhancing data integrity monitoring.
- Decreased manual verification effort by approximately 95% through structured dataset validation automation.
- Executed sampling-based testing and cross-system reconciliation for AWS S3/RDS pipelines, ensuring accurate data synchronization.
- Prepared comprehensive audit documentation, including evidence packages and deviation reports for SIT/UAT cycles.
Project Manager
theL
Toronto, ON
10.2020 - 12.2022
- Built a full-stack booking, payment, and scheduling platform (Vue.js + ASP.NET Core + MySQL) with well-defined process flows and control points.
- Designed and executed automated tests for booking, payment, and user-permission workflows, reducing production errors by ~80% and improving system reliability.
- Led requirements gathering, workflow documentation, UAT coordination, and release validation similar to change management and controls testing processes.
- Managed database structures, API integrations, and data integrity checks across user and transaction modules.
Full Stack Developer Intern
Panyu Water Resource Comapny
Guangzhou, Canton
05.2019 - 07.2019
- Developed interactive water pressure surveillance system using ASP.NET, Gaode Maps API, ArcGIS, and Baidu ECharts API.
- Enhanced dashboard reliability and reduced manual monitoring workload by 30% through automation.
- Executed reconciliation and data validation across asynchronous systems, ensuring accurate municipal infrastructure governance.
Education
Bachelor of Science - Computer Science
Queen's University
Kingston,ON05.2021
Skills
Internal Controls & Testing
Control design assessment Operating effectiveness testing Process walkthroughs Evidence collection Sampling & traceability Data governance validation PRC/SOX-style testing UAT/SIT execution
Automation & Tools
Python Java JavaScript Playwright WebdriverIO Selenium Postman REST API automation SQL AWS (S3/RDS) Jenkins GitHub Actions JIRA Confluence
Data & Systems
JSON, XML, CSV, Excel, PDF validation Cloud & CI/CD environments Workflow mapping Calculation logic testing Reconciliation automation
Certification
ISTQB Certified Tester – Foundation Level | March 2025
Websites
Timeline
Quality Assurance Analyst
MPAC
01.2022 - 06.2023
Project Manager
theL
10.2020 - 12.2022
Full Stack Developer Intern
Panyu Water Resource Comapny
05.2019 - 07.2019
Bachelor of Science - Computer Science
Queen's University