Summary
Overview
Work History
Education
Skills
Websites
Accomplishments
Languages
Certification
https://public.tableau.com/app/profile/hui.wang1742/viz/EvaWangProfileinTableauFormat1/EvaWangResume
Timeline
Generic

EVA WANG

Burnaby,BC

Summary

Over 8 years of combined professional and educational experience in data analytics, with expertise in data analysis, data visualization/reporting, statistics, and more

Overview

6
6
years of professional experience
1
1
Certification

Work History

Data Analyst II

Farmers Business Network
02.2023 - 03.2024

Led cross-functional projects spanning marketing, sales, supply chain, and finance domains, aimed at uncovering avenues for revenue growth and cost optimization. Presented data-driven insights and recommendations to senior leadership to support strategic decision-making

  • Teamed up with marketing department to develop 10+ segments for various promotions and then created Tableau report to monitor web activity and sales, contributing to average of 50% higher sales than projected promotion targets
  • Built data pipelines leveraging DBT, leading to around 250% improvement in data accuracy, consistency, and code reusability

Data Analyst I

Farmers Business Network
10.2021 - 02.2023

Partnered with cross-functional teams to gather requirements and identify data-driven solutions. Employed SQL and Python to uncover insights and trends. Developed 30+ informative Tableau reports, empowering performance tracking and pinpointing areas for improvement

  • Directed project focused on forecasting future demand and supply costs, resulting in approximately 60% improvement in cost of goods (COG) accuracy and contributing to enhancement of company profitability
  • Accomplished project specializing in predicting purchase order (PO) payment timing and amounts, resulting in approximately 80% improvement in cash flow planning accuracy

Data Analyst Intern

Buddytree
07.2021 - 09.2021
  • Analyzed web/digital/marketing data and visualized new user trends, conversion rates, click-through rates (CTR), acquisition, retention, and more, leading to 30% increase in marketing performance visibility

Data Analytics Freelancer

Self-employed
05.2021 - 09.2021
  • Authored 5+ BI reports to track KPI and metrics, diagnose root problems, identify key influencers, and predict future trends

Inventory Analyst

Best Buy Canada
11.2017 - 02.2021
    • Implemented predictive analysis tools using Power Query, VBA, and API to maintain SKU availability, resulting in $15M additional revenue
    • Initiated centralized promotion management tool, enhancing forecast accuracy and inventory sufficiency by 300%

Education

Applied Data Analytics -

British Columbia Institute of Technology
Burnaby, BC
07.2022

Master of Science - Global Supply Chain Management

HEC Montreal
Montreal, QC
02.2016

Skills

Computer Language: SQL Python R

Data Visualization: Power BI Tableau

Data Transformation/Pipeline: DBT

BI Reporting & Mining & ETL: SSRS SSAS SSIS

Database & Data Warehouse: Database Design Dimensional Modeling Amazon Redshift Google BigQuery

Machine learning & Modeling: Look-alike Modeling Regression Model Clustering Algorithms

Statistics for Data Analytics: Probability Distributions Hypothesis Testing A/B testing Time Series

Version Control: GitHub

Accomplishments

  • SQL Server Integration Services Certification, LinkedIn
  • Google Analytics Certification, Google
  • Competent Communicator, Toastmasters
  • PROJECT
  • Target High-Value Audience Using Look-Alike Model
  • The article details a method for identifying postal codes where residents are likely to spend similarly to those in the highest-spending postal code
  • This is accomplished through a look-alike model employing a data mining process to determine the target audience based on similarity scores
  • Does History Repeat in the Stock Market?
  • The project explored recurring patterns or trends associated with the S&P 500 index, particularly in light of the COVID-19 crisis by 2020

Languages

English
Native or Bilingual

Certification

  • CBAP - Certified Business Analysis Professional
  • Certified [Job Title], [Company Name] - [Timeframe]

https://public.tableau.com/app/profile/hui.wang1742/viz/EvaWangProfileinTableauFormat1/EvaWangResume

These are personal website, LinkedIn profile and personal portfolio

Timeline

Data Analyst II

Farmers Business Network
02.2023 - 03.2024

Data Analyst I

Farmers Business Network
10.2021 - 02.2023

Data Analyst Intern

Buddytree
07.2021 - 09.2021

Data Analytics Freelancer

Self-employed
05.2021 - 09.2021

Inventory Analyst

Best Buy Canada
11.2017 - 02.2021

Applied Data Analytics -

British Columbia Institute of Technology

Master of Science - Global Supply Chain Management

HEC Montreal
EVA WANG