Stephen Wang

Experience

• 

  Ylab品牌创新增长实验室

  May 2021 - Sept 2021

  Data Analyst Intern

  • Analyzed sales data from 600+ retail brands on 3 major e-commerce platforms, creating visual summaries thatidentified 5 key market trends, aiding strategic decisions.• Collaborated with brand analysts to model Market Opportunity Analysis for 6 industries, gathering key metricsand creating an Excel data pipeline, improving market predictions by 15%.

• 

  Scotiabank

  Jan 2022 - Aug 2022

  Data Analyst

  • Leveraged Python to automate and streamline the weekly Data Quality Issue Management metrics reportproduction, reduced the weekly production time by 4 hours and significantly improved the report layout and datapresentation format.• Worked as an ad-hoc analyst in maintaining an end-to-end reporting solution for GBM Data Office team reportingwith Excel, Python, and PostgresSql.•Acted as an analyst in the company’s data system migration process from IGC to Collibra. Created business domain onboarding procedures for the business’s Collibra system. Created presentations for CDOs/ senior management team to enhance their understanding in the new data system; • Ran biweekly scrum meetings for the data system migration project and as the scrum master; kept records of each sprint and made plans for next sprints Show less

• 

  Mercer

  Jan 2023 - Apr 2024

  Career consulting analyst

  • Spearheaded the analysis of over 10 client projects, delivering strategic insights that enhanced client strategies and increased efficiency.• Conducted research and analysis for clients across 5 industries. Leveraged Excel to consolidate financial data extracted from S&P Capital IQ platform and internal databases, performed benchmark analysis and created robust data visualizations to form clear, actionable insights on business strategy, corporate performance, and compensation practices.• Constructed client presentations using PowerPoint with data driven recommendations on business strategy and compensation policies for Executives, Boards of Directors, and Senior Management.• Implemented Generative AI solutions for 3 different client projects, automating processes and saving 10+ hours per project by streamlining workflows.;• Pioneered Generative AI implementation, standardizing its use across 2 business areas, reducing cost by 20%. Show less