RESUME

Summary

Edison Wang

I am a Business Intelligence Analyst/Data Specialist who loves messing around with data. I specialize in Data Engineering, Databases, Visualization, and designing user-friendly Power BI dashboards to eliminate gaps for all types of users. I enjoy finding problems and fixing them.

  • : Waterloo/Toronto, ON, CA
  • : edisonwang898@gmail.com


Skills

Tool Box

Python:Pandas
9/10

SQL
8/10

PowerBI
9/10

Docker
6/10

Python:General
7/10

Powershell
9/10

Git
8/10

Apache:Airflow/Spark
6/10


Education

Big Data Solution Architecture

Graduate Certificate
2022 - 2023
GPA: 3.9

Conestoga College, ON, Canada

Skills Acquired: Database Design, Data Warehousing, Programming, Machine Learning, and Big Data processing.

Financial Analysis Statistics Minor

Bachelor of Mathematics
2014 - 2018

University of Waterloo, ON, Canada

Skills Acquired: Computational finance, Data Analysis, Computer Science, Mathematics, and Statistical Modeling.


Certification

1. Microsoft Certified: Power BI Data Analyst

Issued by: Microsoft
Issued on: Jan, 2024

2. Chartered Financial Analyst (CFA): Level 1

Issued by: CFA Institute
Passed on: Dec, 2018

Work Experience

Business Intelligence Analyst/System Support

Sowa Tool & Machine Co. Ltd.
Oct,2023 - Present

Kitchener, ON

  • Designed and Built robust data pipelines and MySQL database with automated ETL process.
  • Developed Company PowerBI dashboards featuring 120+ custom DAX measures, and custom functions that suit individual department needs.
  • Automated various business processes using Python, Windows Task Scheduler, batch scripts, and other tools.
  • Maintain network, ERP, or other infrastructure, ensuring optimal system performance and security.
  • Provide admin support across company, resolving IT related issues.

Software Developer - Coop

Conestoga Smart Centre
Jan,2023 - Apr,2023

Cambridge, ON

  • Our team built a web application with a Machine Learning model to help poultry farms predict animal growth and manage environmental factors, which reduces mortality rates and costs.
  • Assessed the feasibility and potential impact of integrating AI into traditional poultry farming processes.
  • Processed data and trained Machine Learning model using Python, Apache Airflow, and Jupyter Lab
  • Collaborated effectively and ensured timely project delivery using Agile methodologies.

Business Analyst - Intern

Sightline Technology
Oct,2021 - Jan,2022

Richmond, BC

  • Developed data pipelines to consolidate and integrate diverse data sources using Python.
  • Designed and implemented PowerBI dashboards to streamline business intelligence reporting.
  • Transformed raw data into insights for management and offered efficient data support.
  • Conducted routine website maintenance to ensure information consistency and accuracy.

Parts Advisor

Schlueter Acura
Feb,2020 - Sep,2021

Kitchener, ON

  • Managed parts inventory through automotive ERP systems, ensuring consistency and accuracy.
  • Maintained industry-standard fill rates, supporting a timely and reliable automotive supply chain.
  • Provided timly and professional support to customers and technicians.