Summary
Overview
Work History
Education
Skills
Languages
Timeline
Generic

Aolie Yu

Edmonton,-

Summary

Detail-oriented and analytical Data Analyst with a strong foundation in statistical analysis and machine learning techniques, including regression models and clustering analysis. Skilled in leveraging the power of R for insightful data-driven problem-solving and proficient in MySQL and Excel for robust data management. Experienced in utilizing Power BI for effective data visualization.

Overview

7
7
years of professional experience

Work History

Table Game Dealer

Grand Villa Casino
09.2022 - Current
  • Proficient in dealing various table games: blackjack, poker
  • Strong mathematical skills and ability to calculate payouts quickly and accurately
  • Knowledge of casino procedures, rules, and regulations
  • Ability to work in a fast-paced and high-pressure environment
  • Collaborated with other casino staff.

Open Book Editor (Latex)

MacEwan University
02.2023 - 05.2023
  • Edit open-access statistics book for MacEwan University.

Student Consulting Research Project (R, Excel)

MacEwan University
01.2023 - 04.2023
  • Collaborated with clients to fulfill project objectives focused on understanding suicidal ideation in Brazil
  • Conducted data cleaning and preprocessing to ensure the dataset was suitable for analysis
  • Used data visualization techniques, such as bar charts and correlation plots, to explore and visualize the structure of the data
  • Applied binary logistic regression modeling and decision tree algorithms to analyze the dataset and identify significant predictors related to suicidal ideation
  • Generated insights and findings from the analysis and prepared an analysis paper to report the results to the clients.

Student Consulting Research Project (R)

MacEwan University
01.2023 - 04.2023
  • Applied four clustering techniques, including k-means, agglomerative hierarchical clustering, Probabilistic Gaussian Mixture Models (PGMM), and self-organized map (SOM), to analyze the datasets
  • Evaluated and compared the performances of the four clustering techniques based on relevant metrics such as Euclidean distance, Rand index, and silhouette width
  • Presenting the findings and conclusions of the clustering analysis to stakeholders or clients.

Senior Sales Associate

7 Eleven
03.2017 - 01.2023
  • As a senior associate to receive the new delivery and arrange them properly
  • Greeted customers and helped with product questions, selections and purchases
  • Helped customers complete purchases, locate items and join reward programs
  • Checked pricing, scanned items, applied discounts and printed receipts to ring up customers
  • Maintained clean sales floor and straightened and faced merchandise
  • Used POS system to process sales, returns, online orders and gift card activations
  • Trained new associates on cash register operations, conducting customer transactions and balancing drawer.

Student Consulting Research Project (R, SQL)

MacEwan University
09.2022 - 12.2022
  • Utilized a time series analysis tool to analyze and model the sales data of Flexxaire Inc
  • Applied appropriate time series models, such as ARIMA (Autoregressive Integrated Moving Average) to fit the sales data and capture underlying patterns and trends
  • Conducted model diagnostics and validation to ensure the accuracy and reliability of the fitted model
  • Presented the findings, including insights and actionable recommendations, to the client in a clear and concise manner.

Research Assistant (R, Excel)

MacEwan University
05.2022 - 09.2022
  • Gathered and organized COVID-19 data from AHS website
  • Designed a COVID-19 model using a compartmental modeling approach
  • Implemented the designed model using the Kalman filter and EM algorithm
  • Actively took part in meetings and presentations to discuss the details of the literature relevant to the model being developed
  • Prepared a detailed research report for the prediction of COVID-19.

Education

Bachelor of Science - Mathematics And Applied Statistic

MacEwan University
Edmonton, AB
06.2023

Skills

  • Technical Skills: R, Latex, Maple, MySQL, Power BI, Matlab, Python, Microsoft Excel, PPT and Access
  • Statistical Methods: clustering and classification, Regression Model, Principal Component Analysis (PCA), SOM, etc

Languages

English
Professional
Chinese (Mandarin)
Native/ Bilingual
Chinese (Cantonese)
Native/ Bilingual

Timeline

Open Book Editor (Latex)

MacEwan University
02.2023 - 05.2023

Student Consulting Research Project (R, Excel)

MacEwan University
01.2023 - 04.2023

Student Consulting Research Project (R)

MacEwan University
01.2023 - 04.2023

Table Game Dealer

Grand Villa Casino
09.2022 - Current

Student Consulting Research Project (R, SQL)

MacEwan University
09.2022 - 12.2022

Research Assistant (R, Excel)

MacEwan University
05.2022 - 09.2022

Senior Sales Associate

7 Eleven
03.2017 - 01.2023

Bachelor of Science - Mathematics And Applied Statistic

MacEwan University
Aolie Yu