Anson Lau
Senior Operations Analyst
Vancouver,BC
Summary
Analyst with 6+ years of experience driving sales and merchandising performance across eCommerce, wholesale, and retail channels in the fashion and lifestyle sector. Skilled at translating complex data into clear insights that improve product assortment, inventory health, and digital customer experience. Known for developing tools and dashboards that support planning, forecasting, and product storytelling. Experienced with Excel (Power Query, VBA), Power BI, Tableau, and ERP systems like NetSuite to support cross-functional
Overview
9
9
years of professional experience
Work History
Senior Sales Operations Analyst
Purple Brand
01.2025 - Current
- Developed and implemented an EOQ-based demand planning model that reduced excess inventory by 25% while improving wholesale fill rate from 90% to 98%.
- Mentored and trained junior team members, including a Sales Coordinator and Inventory Analyst, to improve operational efficiency and analytical capabilities.
- Led ERP workflow redesign in NetSuite to track order cancellations, short inventory, and adjustments in real time, enabling faster sales team responses and driving a 6% increase in wholesale revenue for seasonal collections.
- Identified high-performing category and style trends through data analysis, informing design and production investment decisions that contributed to over $20M in incremental revenue.
- Built dynamic dashboards in Excel and Power BI to monitor sell-through, inventory turnover, and conversion metrics, enhancing visibility for planning and merchandising teams.
Sales Operations Analyst
Purple Brand
02.2023 - 12.2024
- Cleaned legacy data and partnered with cross-functional teams to standardize product attributes, enabling analysis by category, season, and channel across B2B and DTC.
- Developed accurate forecasting models to enable proactive resource allocation decisions, reducing overhead expenses significantly.
- Managed vendor relationships and negotiated contracts to ensure the timely delivery of high-quality products and services at competitive prices.
- Gathered and assessed data to promote insight into customer buying habits increasing our T-Shirt revenue by 15%.
Senior Merchandise Analyst (eCommerce)
SUKU Vitamins
11.2020 - 12.2022
- Ensured 99.5% product data accuracy across Amazon, Shopify, and Walmart channels, reducing cart abandonment due to listing errors.
- Delivered category performance insights that led to a 25% increase in conversion for top 10 SKUs and informed a major product line refresh.
- Automated weekly eCommerce dashboards using Power Query and Excel macros, saving ~8 hours/week and enabling real-time sales tracking.
- Developed data-driven insights into customer buying patterns, informing decision-making around product mix and pricing strategies.
Merchandise Analyst
Best Buy Canada (Head Office)
09.2018 - 10.2020
- Managed $12M+ assortment across 300+ SKUs, optimizing pricing and inventory to increase gross margin by 8% over two fiscal years.
- Led vendor negotiations and promotional planning, resulting in a 5% YoY uplift in promotional sell-through during Q4 peak periods.
- Created Excel-based tracking tools that reduced manual analysis time and improved SKU-level promotion forecasting accuracy by 10%.
- Delivered ad hoc analysis for senior leadership, including IMU trends, markdown efficiency, and sales-to-inventory performance.
Assistant Manager
J. Crew
08.2016 - 09.2018
- Supervised a team of 10+ associates in daily store operations, achieving consistent monthly sales targets and maintaining top 10% regional customer satisfaction scores.
Education
Bachelor of Arts - Interdisciplinary Studies – Economics/Commerce
University of British Columbia
Vancouver, BCGoogle Data Analytics Certificate -
Coursera
Skills
- Merchandising & Product Strategy
- Product Assortment & Category Optimization
- Sales Performance & Data Analysis
- Forecasting & Inventory Management
- Microsoft Excel (Power Query, VBA)
- Tableau
- Power BI
- Shopify
- Google Analytics
- Team Leadership & Development
- ERP (NetSuite)
Education Certifications
- Bachelor of Arts in Interdisciplinary Studies – Economics/Commerce, University of British Columbia, Vancouver, BC
- Google Data Analytics Certificate, Coursera
- Microsoft Power BI Data Analyst Professional Certificate, in progress
Timeline
Senior Sales Operations Analyst
Purple Brand
01.2025 - Current
Sales Operations Analyst
Purple Brand
02.2023 - 12.2024
Senior Merchandise Analyst (eCommerce)
SUKU Vitamins
11.2020 - 12.2022
Merchandise Analyst
Best Buy Canada (Head Office)
09.2018 - 10.2020
Assistant Manager
J. Crew
08.2016 - 09.2018
Bachelor of Arts - Interdisciplinary Studies – Economics/Commerce
University of British Columbia
Google Data Analytics Certificate -
Coursera
Similar Profiles
Chloe CornealChloe Corneal
Intern Trainee at Purple BrandIntern Trainee at Purple Brand
Meriam SquarciaficoMeriam Squarciafico
Psychic Medium at Purple Ocean/ Purple GardenPsychic Medium at Purple Ocean/ Purple Garden
Ankita PisalAnkita Pisal
Pharmacist support at Brand Institute, Brand Institute, IncPharmacist support at Brand Institute, Brand Institute, Inc
Qianyu ChenQianyu Chen
UBtheChange Student Activator at UBC Center For Community Engaged LearningUBtheChange Student Activator at UBC Center For Community Engaged Learning
Sanjay DobariyaSanjay Dobariya
Office Manager at Ravani Infrastructures Pvt Ltd.Office Manager at Ravani Infrastructures Pvt Ltd.