Adam Li

+1-647-***-**** ad0xcc@r.postjobfree.com (Preferred) Toronto, ON LinkedIn

Profile Summary

Experienced data analyst with a demonstrated proficiency in SQL (Joins, Stored Procedure, Window Function), Python (Pandas, Numpy, Scipy, Seaborn), Flask, HTML/CSS/Javascript, Excel (VLOOKUP, Pivot Table), PowerBI

(DAX, Power Automate), and Tableau. Skilled in utilizing these tools to extract, transform, and analyze large datasets to uncover valuable insights and trends. Passionate about data visualization and using visual storytelling to communicate complex findings to stakeholders effectively. Experienced in building and deploying predictive models, as well as integrating them into applications to provide real-time insights and drive data-informed decision-making. Strong collaborator with excellent communication skills, able to work effectively in cross-functional teams and present findings to technical and non-technical audiences. Education

Master of Computing (Specialization: Data Science) 2021.02 - 2022.12 Australian National University Canberra, Australia Honours B.Sc in Applied Statistics & Economics; Minor in Mathematics 2016.09 - 2020.06 University of Toronto Toronto, ON

Work Experiences

Data Analyst (Virtual Internship) Toronto, ON

Quantium Group 2023.05 - 2023.09

● Analyzed over 1 million customer transactions and ~80K retail client profiles using SQL to understand behavioral patterns such as purchasing frequency, preferred brands, spending habits, and transaction periods

● Designed A/B testing to evaluate the impact of new trial layouts in select stores for the client’s Category Manager. Performed hypothesis testing to compare the performance of trial stores against control stores.

● Assessed KPIs, including total sales revenue, customer counts, and average transactions per customer, segmented by different customer groups to determine the effectiveness of the new layout. Data Analyst Shenzhen, China

Zhengye Technology 2020.11 - 2021.03

● Extracted, cleaned, and validated raw spending data from suppliers, conducted trend analysis and variance analysis, and identified cost-saving opportunities that influenced sourcing strategy for the upcoming fiscal year and aided the execution of cost reduction initiatives.

● Developed and sustained PowerBI dashboards to track Supply Chain Performance, emphasizing Key Performance Indicators (KPIs) such as Inventory Turnover, Warehousing Costs, On-time Shipping, Delivery Time, and Fill Rate.

Project Experience

StockX Sneaker Data Challenge 2023.02 - 2023.04

● Cleaned ~100,000 sneaker sales data from StockX across brands, and augmented the dataset with additional information, such as the estimated number of pairs released for each sneaker model.

● Conducted EDA in Python to answer key business questions such as identifying the most popular shoe models and assessing profit margins, utilizing descriptive statistics and data visualization techniques.

● Developed predictive models using linear regression, random forest, and XGBoost to predict the sale price of sneakers and provide actionable insights for StockX sellers to optimize their selling strategies.

● Deployed the packaged model using Flask, enabling users to interactively input sneaker brand and model, and get estimated price and primary contributing factors such as celebrity/brand collaboration, color, and rarity. Pro Actor’s Toolkit, Mobile-App Development 2022.03 - 2022.11

● Led a team of 5 to develop a mobile app used to help actors/actresses practice memorizing their scripts leveraging ASR (Automated Speech Recognition) technologies.

● Developed the mobile app using Unity with features such as automated extraction of online content with provided links and script analysis tool within the app, capable of recognizing and providing constructive feedback on factors such as tone and speed, offering users valuable insights for performance improvement.