Bachelor of Commerce, McMaster University

Colin Yu-Lo

Second year Commerce student at the DeGroote School of Business, McMaster University, building a strong foundation in how financial information is prepared and used to guide business decisions. I use generative artificial intelligence (AI) tools at work and at school to check data and stay organized.

What I bring

Skills, and where I've used them

Attention to detail

I checked customer records for address changes, name changes and duplicates, and issued client invoices accurately and on time.

AI literacy

I use generative AI to review documents and flag errors, then verify every change myself.

Data and Excel

I track and validate data in Excel and use Power BI, backed by my accounting, finance and data analytics coursework.

Business sense

I spent five years tracking inventory, expenses, cash flow and margins at a food business.

Communication and teamwork

At the DeGroote 24-Hour Case Competition, I made sure every teammate understood their role and validated our work against a tight deadline. I've also handled client correspondence and customer service.

Problem solving

I researched and fixed the records AI flagged, and resolved customer requests through peak periods.

About

Accounting shows what happened. Finance helps figure out what to do next.

I like that finance turns numbers into decisions. I want to start where I can learn how the numbers are built, whether that's in accounting, accounts payable and receivable, or financial planning and analysis.

Helping run a food business taught me how a business works, from managing inventory, cash flow and order volumes to serving customers.

Experience

Where I've worked

PeriodRoleWhat I did
May to September 2026 InternHub Technology Group, Toronto, ON Moved hundreds of service contracts into HubSpot, checked records with generative AI, kept sales territories current in e-automate and helped roll out customer asset tags.
Summer 2025 AnalystYu Consulting Group, Toronto, ON Handled billing, research, reporting and client correspondence for a finance and operations advisory practice.
Summer 2020 to Spring 2025 Administrative Assistant and Customer ServiceYu's Dumplings, Toronto, ON Helped run daily operations, including inventory, expenses, cash flow and high order volumes.
Summer 2024 Customer Service Representative, Print ServicesStaples Canada, Toronto, ON Answered print service inquiries, matched customers to the right products and completed Amazon returns in store systems.

How I use AI

AI does the first pass. I check the details.

I use generative AI tools to read documents, compare data and keep myself organized. Here is where it shows up in my work and at school.

Hub Technology Group

Reading service agreements

I used generative AI tools to review service agreements and identify the company and contact details, then recorded them on the matching HubSpot profiles.

  • Agreement
  • AI review
  • HubSpot profile
  • Complete and accurate

Hub Technology Group

Checking records against the source

I used generative AI to match customer relationship management (CRM) records against the source data and flag what needed correcting. Then I researched record identifiers, verified customer site addresses and name changes, and merged duplicates.

  • CRM record
  • AI match
  • Flag
  • Verified by me

Excel

Comparing and validating data

I use generative AI tools to compare and validate data, and to store and retrieve information in Excel.

On my own time

Always learning

I keep trying new AI tools and look for everyday tasks I can automate.

McMaster University

Course outlines to calendar

I used generative AI to import assignment and test dates from my course outlines into a calendar with automatic reminders.

Course outline to calendar

Managerial Finance

Course outline, evaluation

Assignment 1Oct 2
Midterm testOct 21
Assignment 2Oct 30
October3 due dates
  • Assignment 1, due Oct 2Reminder Sep 30
  • Midterm test, Oct 21Reminder Oct 14
  • Assignment 2, due Oct 30Reminder Oct 28
Recreated example, sample dataDue dates from a course outline become calendar events with reminders.

Selected work

A closer look at what I've worked on

Hub Technology GroupMay to September 2026

Moving service contracts into HubSpot and cleaning up the records

The job

Managed Print Services agreements and service contracts sat in Microsoft SharePoint and needed to move onto the right company records in HubSpot.

  • HubSpot
  • Microsoft SharePoint
  • Excel
  • e-automate
  • Generative AI

What I did

  • Migrated hundreds of agreements and service contracts from SharePoint into HubSpot company records, tracking each upload in Excel.
  • Used generative AI to review the agreements and flag records that needed correcting, then verified every change myself.
  • Recategorized contacts and kept sales territories and account ownership up to date in e-automate, the company's enterprise resource planning (ERP) system.
Service agreement to company record

Managed Print Services Agreement

Customer: Northbeam Dental Group

Service location: 45 Sample Road, Toronto, ON

Contact: Dana Reyes, Office Manager

Email: dana@example.com

N
Northbeam Dental GroupCompany record
Site address
45 Sample Road, Toronto, ON ✓
Contact
Dana Reyes, Office Manager ✓
Email
dana@example.com ✓
Agreement
Attached ✓

Matches the agreement

Recreated example, sample dataCompany and contact details found in a service agreement and recorded on the matching company record.
Upload tracker.xlsx
D8fx=COUNTIF(D2:D7,"<>None")
ABCDE
1AgreementCompanyUploadedAI flagFixed
2MPS1041Northbeam DentalYesNone
3MPS1042Kestrel LogisticsYesAddressYes
4MPS1043Fernwood LegalYesName changeYes
5MPS1044Brightline PrintYesDuplicateYes
6MPS1045Ashgrove ClinicYesNone
7MPS1046Coral Bay FoodsYesNone
8Flags3
Recreated example, sample dataEach upload tracked in Excel. AI flags what needs fixing, and I verify every change.

Yu Consulting GroupSummer 2025

Billing and research for an advisory practice

The job

A finance and operations advisory practice needed help with billing, research, reporting and client correspondence.

  • Accounts receivable
  • Market research
  • Reporting

What I did

  • Issued client invoices accurately and on time, supporting accounts receivable and steady cash flow.
  • Researched industry trends and benchmarks to support client strategy and financial planning.

Yu's DumplingsSummer 2020 to Spring 2025

Tracking inventory and cash flow for a food business

The job

A food business with high order volumes needed help running daily operations, inventory and customer service.

What I did

  • Tracked inventory, expenses and daily cash flow, giving ownership reliable records for purchasing.
  • Compared food costs with sales to see the margin on each product and which ones were most profitable.
  • Processed customer orders and inquiries, resolving requests through peak periods.
  • Inventory
  • Expenses
  • Daily cash flow
  • Margins
  • Customer service
Store records.xlsx, Daily log
D2fx=B2-C2
ABCDEF
1DaySalesExpensesNet cashStock (bags)Note
2Mon$1,240$410$83096
3Tue$1,105$385$72081Reorder
4Wed$1,380$1,150$230140Restocked
5Thu$1,215$360$855122
6Fri$1,690$455$1,23598
7Total$6,630$2,760$3,870

Stock under 85 bags flags a reorder.

Store records.xlsx, Product margins
E2fx=D2/B2
ABCDE
1ProductPriceFood costMarginMargin %
2Pork and chive (50)$28.00$11.20$16.8060%
3Chicken and mushroom (50)$30.00$13.50$16.5055%
4Vegetable (50)$24.00$8.40$15.6065%
5Shrimp (30)$32.00$17.60$14.4045%

Shrimp sells for the most but earns the lowest margin.

Recreated example, sample dataDaily sales, expenses, cash and stock, plus the margin on each product.

Education and tools

What I'm learning and what I use

Education

Expected April 2029 Bachelor of Commerce

DeGroote School of Business, McMaster University, Hamilton, ON

Relevant coursework

  • Introductory Financial Accounting
  • Managerial Accounting I
  • Introduction to Finance
  • Managerial Finance
  • Business Data Analytics
  • Decision Making with Analytics
  • Introductory Microeconomics
  • Introductory Macroeconomics
June 2025 Ontario Secondary School Diploma, Honour Roll

Brebeuf College, Toronto, ON

Tools

Software
Microsoft Excel, PowerPoint, Power BI, Google Workspace, Photoshop, Canva
Systems
HubSpot, e-automate, Microsoft SharePoint
AI
Generative AI tools for document review, data checks and scheduling
Programming
Working knowledge of Python 3 and Java console programming

Extracurriculars

  • DeGroote 24-Hour Case Competition, McMaster University
  • Social Media Representative, Brebeuf Student Council
  • Community Volunteer, Neighbourlink North York

Interests

  • AI and automation: teaching myself new AI tools and ways to automate everyday tasks
  • Fitness: weightlifting and running five times a week
  • Financial literacy: following markets and personal investing

Contact

Let's talk

I'm looking for a Summer 2027 role in finance or accounting. If you have an opening, or advice on where I might fit, I'd be glad to hear from you.

LinkedIn
LinkedIn
Location
Toronto, ON