Benny Yuan
Mississauga,Ontario
Summary
4th Year commerce student, majoring in finance, minoring in economics. Knowledgeable in business finance, economic theory, and data analysis. Experience using various programs for data management, analysis, and visualization. 100+ hours using excel for financial modeling and VBA, 100+ hours using python, 30+ hours creating and querying databases with SQL
Overview
1
1
year of professional experience
Work History
Employee Absenteeism
Data Project
Mississauga, Ontario
12.2021 - 01.2022
- Designed database using SQL to store and query employee data
- Preprocessed data and used Machine learning to build logistic regression model using python libraries
- Created Interactive dashboards and Slide decks using Tableau to visualize model
Research Assistant
Economics Research Paper, University of Toronto
Mississauga, ON
10.2021 - 01.2022
- Conducted Quality assurance, merging, finalizing of data, and preparing of deliverables for team lead
- Communicated with multiple data entry research assistants to assign individual roles and responsibilities and schedule effective due dates to meet deadlines
- Worked both independently and collaboratively in fast-paced environment
Education Inequalities
Data Project
Mississauga, Ontario
01.2021 - 03.2021
- Built regression model to predict effects of pandemic on education inequalities in developing countries
- Analyzed data from 180+ countries and used data to fit regression model using Stata
- Performed multiple tests on specification errors to maximize goodness of fit
Café Management Simulation
University of Toronto
Mississauga, Ontario
11.2019 - 01.2020
- Managed simulated café business performing stakeholder analysis to exercise on decision including inventory purchases, prices, ambiance, and social trends
- Carried out day-day-day duties accurately and efficiently.
- Collaborated in 5-member group, as team lead, led group to top 7/81 group performance
Vice-President of Finance
Junior Achievement
Calgary, AB
11.2018 - 04.2019
- Performed stakeholder analysis for use in calculating future inventory purchases, dividend calculations, share returns, product pricing, ROI, and executive decisions
- Led team of 4 members, delegated individual responsibilities for each member, planned weekly agenda for finance team, and oversaw multiple activities while prioritizing team efforts effectively
- Organized sale and management of company shares to generate initial capital through equity and subsequent redistribution of dividends and repayment of shares to shareholders
- Performed Tracking of inventory and cash flow through journalizing transactions using Microsoft Office
Education
Bachelor of Commerce - Finance Major, Economics Minor
University of Toronto
Mississauga05.2023
Skills
- SQL
- Tableau
- Python
- R
- Excel / VBA
- PowerPoint
- FactSet
- Stata
Timeline
Employee Absenteeism
Data Project
12.2021 - 01.2022
Research Assistant
Economics Research Paper, University of Toronto
10.2021 - 01.2022
Education Inequalities
Data Project
01.2021 - 03.2021
Café Management Simulation
University of Toronto
11.2019 - 01.2020
Vice-President of Finance
Junior Achievement
11.2018 - 04.2019
Bachelor of Commerce - Finance Major, Economics Minor
University of Toronto