Summary
Overview
Work History
Education
Skills
Volunteer Experience
Projects
Professional Certifications
Languages
Timeline
Generic

Yan Chen (Spencer) Li

Mississauga,Ontario

Summary

Hardworking, passionate, and data-driven university student and job seeker with strong organizational skills eager to seek a data analyst position. Detail-focused data-driven person with knowledge on the data analyst cycle. Proven to understand the process of data analysis and applying into real-world datasets on various applied data analysis projects.

Overview

6
6
years of professional experience

Work History

Math Tutor

Freelance Tutor
09.2023 - Current
  • Give high school students extra tutoring on mathematics courses
  • Explained mathematical concepts and communicated with students clearly, assigned homework questions for students in preparation of tests
  • Simulated testing environment for students in preparation of final exams, and supported students with helpful study habits and exam strategies.

Database Programmer Intern

PKTech
07.2018 - 08.2018
  • Collaborated with the team to maintain databases, occasionally do data analysis with MySQL software
  • Assisted the team on their ongoing WEB application project using Java efficiently
  • Assisted in building databases and table structures for web applications.
  • Beyond August 2018, I am also a remote freelance helper, occasionally helping them with their side projects

Education

Honours Bachelor of Science - Mathematics and Statistics Double Major

University of Toronto
Toronto, Ontario
06-2026

High School Diploma -

St. Aloysius Gonzaga Secondary School
Mississauga, ON
06-2022

Skills

  • Programming languages: Java, Python, R
  • SQL and MySQL
  • Pandas, Numpy
  • RStudio
  • Microsoft Office (Word, Excel, and PowerPoint)
  • Data collection, data cleaning, data analysis, and data visualization
  • Dashboarding
  • Tableau and IBM Cognos Analytics
  • Independence
  • Teamwork and leadership
  • Communication
  • Problem solving and critical thinking

Volunteer Experience

Junior Leader, 09/2019 - 06/2020

St. Aloysius Gonzaga Secondary School - Mississauga, Ontario.

  • Assisted peers and staff on organizing the post-secondary fair and shown good communication with the presenter.
  • Been a tour guide for the school to Grade 8's.
  • Effectively planned the tour with my tour guide team before the tour, and shown leadership skills with my tour group during and after the tour.


Food Sorter, 09/2018 - 06/2019

The Mississauga Food Bank - Mississauga, Ontario

  • Sorted and organized food cans in the right category in the warehouse
  • Helped with others on organizing warehouse storage
  • Communicated with other food sorters and supervisor

Projects

IBM Data Analyst Capstone Project: Developer Survey Inferences, IBM Data Analyst Professional Certificate, 08/2024 - 09/2024

  • Data collection using API and Web Scraping in Python
  • Data wrangling, analysis, and visualization using Numpy and Pandas in Python
  • Creating an interactive data visualization dashboard using IBM Cognos Analytics
  • Putting the previous parts all together in a compelling, creative, and innovative Microsoft PowerPoint presentation.


Google Data Analytics Capstone Project: Case Study 1, Google Data Analytics Professional Certificate, 12/2023 - 01/2024

  • Used Google Sheets application to clean and analyze datasets from a fictional bike rental company, and used spreadsheet tools to generate data visualizations
  • Effectively and efficiently used pivot tables to create summary data
  • Created a compelling presentation on Google Slides to share the visualizations, do data storytelling, and wrote recommended next steps.


Statistical Analysis: Chemical Abundances of Particular Elements on Stars, STA130 Course at University of Toronto, 02/2023 - 04/2023

  • Used R programming to clean, analyze, and design data visualizations on an astronomy dataset with my project team
  • Wrote my part of the statistical report effectively
  • Used Microsoft PowerPoint to create a compelling data analysis presentation, showing visualizations.
  • Presented the findings orally with my project team on a poster board.
  • Shown effective communication and leadership skills in a 4-people group setting.

Professional Certifications

  • HSK Level 6 Mandarin Certificate
  • Google Data Analytics Professional Certificate
  • IBM Data Analyst Professional Certificate

Languages

English
Native or Bilingual
French
Elementary
Chinese (Mandarin)
Native or Bilingual
Spanish
Elementary

Timeline

Math Tutor

Freelance Tutor
09.2023 - Current

Database Programmer Intern

PKTech
07.2018 - 08.2018

Honours Bachelor of Science - Mathematics and Statistics Double Major

University of Toronto

High School Diploma -

St. Aloysius Gonzaga Secondary School
Yan Chen (Spencer) Li