Work History
Education
Skills
Projects
Timeline
Generic

Xinyi Li

North York,ON

Work History

Data Analyst Intern

Puhao Mechanical & Electrical Equipment Co
Chongqing, China
05.2022 - 08.2022
  • Extracted actionable insights from user behavior and transactional datasets using SQL and Python.
  • Conducted data cleaning, validation, and exploratory data analysis to ensure high data quality.
  • Developed analytical reports and visualizations to monitor key business metrics such as retention and engagement.
  • Collaborated with stakeholders to convert business questions into effective data-driven solutions.

Education

Master of Applied Computing -

University of Windsor
Windsor, ON
08.2026

Bachelor of Science - Mathematics and Economics

University of Toronto
Toronto, ON
06.2024

Skills

  • Java
  • Python
  • C
  • MySQL
  • R
  • Advanced Excel
  • PowerPoint

Projects

Distributed E-commerce Inventory System (Database & Backend)

10/01/25, Windsor, ON

Designed and implemented a distributed e-commerce inventory backend using MySQL, Redis, Docker, and Kubernetes, supporting multi-node replication and fault tolerance. 

Built ACID-compliant purchase workflows with row-level locking to prevent overselling under high concurrency. 

Created Prometheus + Grafana dashboards to monitor query latency, lock waits, and replication lag; achieved P95 latency under 90 ms during load tests. 

Developed Python-based multi-threaded client simulator generating 100+ concurrent user sessions for performance benchmarking. 

Semi-Supervised Learning for Imbalanced Tabular Data (Machine Learning Project)

11/01/25, Windsor, ON

Implemented OS-level process management utilities in C using fork(), execvp(), pipe(), pthreads, signals, and file descriptors.

Built a mini shell supporting piped commands, background jobs, signal handling, and parent/child process synchronization.

Developed a backup automation system using tar, differential backup logic, timestamp tracking, and custom logging, achieving reliable recovery across multiple states.

Debugged race conditions and deadlocks; applied 2-phase locking and precedence graph reasoning to ensure schedule serializability.

Timeline

Data Analyst Intern

Puhao Mechanical & Electrical Equipment Co
05.2022 - 08.2022

Master of Applied Computing -

University of Windsor

Bachelor of Science - Mathematics and Economics

University of Toronto
Xinyi Li