My Resume

Updated regularly with my latest experience and skills

Download PDF

Alisa Guo

alisa.jingyi.guo@gmail.com | (437) 775-1043 | Mississauga, ON | github.com/Stickpie

Skills

Python AI SQL Power Automate Microsoft Office Project Management Hackathon Experience

Education

Toronto Metropolitan University

BS, Computer Engineering

Sept 2020 - Current

Mississauga, ON

Co-op Experience

Planning Assistant

Aug 2024 – Aug 2025

Mubea Cyclone, Mississauga, ON

Led a team of interns by providing job training, delegating responsibilities, and conducting individual check-ins
Automated a daily reporting workflow (Power Automate, Excel, AutoHotKey), reducing a 30-minute manual task into a 2-minute automated process for projecting Power BI charts across 3 manufacturing plants
Accurately entered and verified data in Excel sheets, comparing values and ensuring precise transfer into company systems
Automated half of the printing process, so that work orders can be printed overnight

Data Analytics Intern

Jun 2021 – Aug 2021

Regressor Studio, Mississauga, ON

Summarized data by creating pivot tables, dashboards, and data visualizations of data sets
Leveraged Excel VBA to assess and restructure 1M+ data items stored in CSV format
Automated the analysis of Play Store Reviews using AI and Python to identify current trends
Prepared PowerPoint of findings, and presented to key stakeholders

Technical Project Assistant

Jun 2022 – Aug 2022

Convergint, Mississauga, ON

Increased efficiency by 30% through introducing new technological shortcuts, minimizing time required for labor-intensive processes
Compiled data from different departments, then summarized everything into concise reports
Managed and organized project files in Google Drive, ensuring all documents were accurately sorted into intuitive folders for easy access by team members

Projects

Oracle Database System

Designed an Entity-Relationship model to serve as the foundation of the project proposal
Wrote SQL queries to create tables according to Relational Database Design in the Oracle Database
Verified system functionality by populating the database with test data and executing queries for debugging

Online Game Website

Created an online gaming website using Java N-layered architecture, then deployed it to the internet using Dockerhub and Kubernetes
Conducted requirement analysis based on market and stakeholder needs
Assigned group members to various tasks on Jira, then coordinated weekly report updates

Certifications

ICTC Cybersecurity ICTC Artificial Intelligence

Note: This is a preview. Download the full PDF version for complete details.