Arjun Duggal
Vancouver,BC
Summary
Data analyst with 4+ years of experience turning complex data into actionable insights and business impact across varying industries. Skilled in quantitative analysis, data visualization, statistical analysis, and predictive modeling.
Overview
5
5
years of professional experience
Work History
Data Analyst
Lululemon Athletica
Kitsilano, BC
04.2025 - Current
- Analyzed in-season demand forecasts across 400M+ records, identifying key product-level drivers of forecast variance and enabling better inventory and product decisions. Built and optimized star schema data models and Power BI dashboards to improve reporting scalability, accuracy, and stakeholder visibility.
- Automated documentation within Power BI, improving workflow transparency, standardizing reporting knowledge, and reducing manual process tracking across the team.
- Built a daily projections dashboard tracking transfers, unreceived dispatch units, and forecast demand by distribution center and class, giving stakeholders clear visibility into inventory movement, transfer drivers, and forecast changes across planning versions.
- Optimized one of the department's most widely used Power BI reports, reducing model size and refresh time by 50% through query folding, fact table cleanup, and data modeling best practices.
- Developed automated reporting tools using SQL and Excel, enhancing efficiency in data retrieval processes.
Data Analyst
Microserve
Vancouver, BC
04.2022 - 04.2025
- Built and scaled Power BI KPI dashboards for purchasing, e-commerce, and technical services teams, automating performance tracking and delivering real-time visibility into team and business metrics.
- Led automation initiatives using Power Automate, Python, and VBA, reducing manual effort, improving process accuracy, and streamlining recurring operational workflows.
- Partnered with the analytics team to deliver data-driven pricing and sales insights that contributed to 15% year-over-year revenue growth, identifying opportunities to improve commercial performance.
- Developed complex SQL queries and data pipelines to support custom reporting, analysis, and scalable Power BI solutions for business stakeholders.
- Led internal and client-facing stakeholder meetings, translating business requirements into analytics solutions and serving as a trusted liaison between technical teams and decision-makers.
Data Engineer
StockOdds, (Fintech Startup)
Vancouver, BC (Remote)
06.2021 - 03.2022
- Built and maintained SQL tables to accurately adjust historical stock prices for dividends and splits, ensuring reliable data for trader back-testing and market analysis.
- Engineered a high-performance Python script to calculate 80+ stock metrics in under 2 minutes, reducing runtime by more than 99% from a 10+ hour process through vectorization and elimination of iterative calls.
- Improved data quality and analytical reliability for trading strategies by delivering accurate, scalable market data solutions in a fast-paced fintech environment.
- Designed and implemented data pipelines to automate ETL processes for financial analytics.
Education
Bachelor of Science - Mathematics
McMaster University
Remote07-2021
Bachelor of Science - Mathematics
McMaster University
Hamilton, ON12-2020
Skills
- Programming: Python, R, SQL, M, Git, R
- BI and Analytics: Power BI, Tableau, Excel, Pandas, Power Automate
- Strengths : Problem-solving, Organization, Advanced Quantitative Analysis, Data Cleaning and Management
Timeline
Data Analyst
Lululemon Athletica
04.2025 - Current
Data Analyst
Microserve
04.2022 - 04.2025
Data Engineer
StockOdds, (Fintech Startup)
06.2021 - 03.2022
Bachelor of Science - Mathematics
McMaster University
Bachelor of Science - Mathematics
McMaster University