Proficiencies
Daily driversCORE
| SQL | The job itself · DB2 & SQL Server dialects |
|---|---|
| SSIS | Package development & deployment |
| SSMS | Where the SQL gets written |
| Excel | Delivery format of record · plus VBA |
| Tableau | When a table isn't enough |
Working knowledgeALSO
| Git | Version control for everything here |
|---|---|
| JavaScript / TypeScript | Every project on this site |
| React / Node.js | Side-project stack |
| Python / Pandas | Housing dashboard data pipeline |
| MongoDB | Persistence for the demos |
How I got here
-
SEP 2020
BSc Computer Science
Wilfrid Laurier University -
SEP 2020
Data Systems Analyst
Wilfrid Laurier University -
MAY 2022
Technical Support Analyst
Transcom -
MAY 2024
Summer Student
MCAP -
JUL 2024
Mortgage Specialist
MCAP -
APR 2026
Data Analyst
MCAP · Reporting & Analytics
Selected projects
- Ontario Housing Market Dashboard GTA home prices, sales volume, and market indicators across 10 cities from 2019 to 2026. Raw CSVs cleaned with Python and Pandas, visualized with Chart.js.
- Songdle Daily song-guessing game. Node.js backend against streaming APIs, with a daily rotation so everyone gets the same puzzle.
- QueryDesk Self-serve reporting for legacy databases: plain-English requests become validated read-only SQL against a demo AS/400 mortgage schema, with Excel export.
- TaskMaster Full Next.js 14 task manager with its own test suite, the largest single codebase on this site.