Lam Alex

Developed HR cost tracker and staffing dashboards in Power BI, supporting 2500+ stores and implementing Row-Level-Security (RLS) across 5 hierarchical levels. Delivered actionable workforce, KPI and labor cost insights through interactive data visualizations. Supported leadership decision-making and workforce planning, contributing to the achievement of a 96% staffing fulfillment rate.

Deliver recurring KPI reporting on headcount, turnover, surplus, vacancies, labor cost and compliance, modeled in DAX and Power Query M, and drive follow-up action on staffing events and compliance gaps. Designed and configured Workday reports and automated end-to-end data pipelines using SharePoint, Python, Azure SQL, and Alteryx. Streamlined data integration, extraction, validation, and reporting processes, reducing manual effort by approximately 40% and improving operational efficiency.

HR Operation Representative, Power BI & Data at Panda Express (2025-11 – Present)

• Developed HR cost tracker and staffing dashboards in Power BI, supporting 2500+ stores and implementing Row-Level-Security (RLS) across 5 hierarchical levels. Delivered actionable workforce, KPI and labor cost insights through interactive data visualizations. Supported leadership decision-making and workforce planning, contributing to the achievement of a 96% staffing fulfillment rate.
• Deliver recurring KPI reporting on headcount, turnover, surplus, vacancies, labor cost and compliance, modeled in DAX and Power Query M, and drive follow-up action on staffing events and compliance gaps.
• Designed and configured Workday reports and automated end-to-end data pipelines using SharePoint, Python, Azure SQL, and Alteryx. Streamlined data integration, extraction, validation, and reporting processes, reducing manual effort by approximately 40% and improving operational efficiency.
• Built a Microsoft Copilot Agent to support HR reporting audits and identify data anomalies and compliance risks. Increased audit workflow efficiency by 60%, enabling faster review cycles and improved reporting accuracy.

Programmer at Shoalter Automation Limited (2023-09 – 2024-11)

• Developed and maintained microservices for an enterprise e-commerce platform (in:FIVE), leveraging Java, Spring Boot, Kubernetes, React, and TypeScript, with integrated content management capabilities.
• Integrated Apple Pay and Google Pay into the payment gateway and built instant-refund functionality.
• Integrated with Deliveroo Merchant Center & Google Products Feeds API to list products on new channels, lifting click rate by 20%.
• Built a React merchant portal for configuring their own marketing campaigns, including BOGO deals, new-customer discounts, referral rewards and special offers.
• Implemented the end-to-end ordering and order-distribution flow enabling instant in-store pickup, cutting order packing time by 50%.
• Built Apache Spark and SQL pipelines for finance and accounting reporting, improving data consistency across payment records.

Programmer at SxL Techlology (2020-03 – 2021-08)

• Built Java API services integrated with Google Cloud Storage, with OAuth 2.0 single sign-on.
• Developed a custom AI model training function for object detection by using Python. Allow user to build and tune-up their own object detection model
• Designed and built user interfaces in React (web) and Python Tkinter (Raspberry Pi) for an elementary-school audience, prioritizing clarity and ease of use.

M.S. in Computer Science (Online) – Georgia Institute of Technology (2025-09)

Bachelor of Science (HONS) in Computing; Capstone Project – Data Analysis Tool for Environmental Data – The Hong Kong Polytechnic University (2019-09 – 2023-06)