Toronto, ON
Omar Serrano
Data Analyst
SQL · Python · Tableau · Excel
I clean data, check it against trusted sources and turn it into clear charts and summaries. Computer Programming diploma from Georgian College and the Google Data Analytics Professional Certificate. Bilingual English and Spanish.
12-month sums, Dec 2022 to Sep 2026. Source: Statistics Canada.
Featured project
Canada Export Diversification Under US Tariffs
The question
Since the 2025 US tariffs, did Canada really move its goods exports away from the US, or is the change mostly gold and energy?
What I found
Partly. The US share of Canada's exports fell 8.4 points, from 76.2% to 67.8%, but gold explains more than half of that drop, and most of the rise in gold is a price effect. Without gold and energy, the share fell only 3.3 points. Among the tariffed sectors, only aluminum clearly found other buyers.
- drop in the US share of exports
- −8.4 pp
- drop in the US share of exports
- of the drop explained by gold
- 56%
- of the drop explained by gold
- aluminum offset ratio, the only sector that redirected
- 0.84
- aluminum offset ratio, the only sector that redirected
- products and 224 destinations, Jan 2022 to Sep 2026
- 5,382
- products and 224 destinations, Jan 2022 to Sep 2026
Opens the live Tableau Public view here.
Interactive dashboard on Tableau Public
What I did
- 01Downloaded monthly Statistics Canada trade data and built clean tables with SQL (DuckDB) and Python.
- 02Checked every total against published Statistics Canada tables before running any analysis.
- 03Wrote down four hypotheses and their pass/fail rules before looking at the results, then tested each one.
- 04Built the dashboard in Tableau Public and wrote the findings in plain language, with limits and sources.
Tools
- SQL (DuckDB)
- Python (pandas)
- Jupyter
- Tableau Public
- Excel
- Git
Skills
Data
- SQL
- Python (pandas, Jupyter)
- Tableau
- Excel and Google Sheets
Analysis
- Data cleaning
- Checking data against trusted sources
- Data visualization
- Writing up results for non-technical readers
Other
- Git and GitHub
- Azure fundamentals (AZ-900)
- HTML, CSS, JavaScript, React
- English and Spanish
Experience
May 2025 – Present
Toronto, ON
Independent Web Applications: Setup and User Support
Self-employed
- Built and run two live web applications, pravepath.ca and francaisia.com: worked out what users needed, set up the system, tested it end to end and launched it.
- Write the user-facing help content, such as explanations of each field and how results are calculated, so users can work on their own.
- Reproduce user-reported problems, find the cause and confirm the fix with the user.
Aug 2023 – Jun 2026
Toronto, ON
Customer Service Associate / Server
The Rec Room · Part-time
- Recommended and upsold products at every table, such as game cards for families, to raise the average bill.
- Supported private events for up to 800 guests in a fast, high-volume setting.
- Fixed POS terminal, payment device and receipt printer problems on the spot and escalated what I could not fix.
Mar 2023 – Apr 2025
Remote
Freelance Web Development and Client Support
Meraki Creative Lab · Freelance
- Acted as the client contact for 3 to 5 small business websites, turning their requests into clear tasks and giving status updates in English and Spanish.
- Built and maintained responsive websites with HTML, CSS, JavaScript and React, using Git.
Jun 2020 – Jun 2022
Atizapán, State of Mexico
Administrative Support Specialist
Hospital General de Atizapán · Full-time
- Supported staff across hospital departments and the Director's Office with requests, correspondence and follow-ups.
- Proposed shared Google Drive files so teams could see supply and medication availability in one place, keeping the information accurate and up to date.
- Promoted to a department head level role within about five months of starting.
Education and certifications
Certifications
Google Data Analytics Professional Certificate
Oct 2026Google · Coursera
Microsoft Azure Fundamentals (AZ-900)
2025Microsoft
Education
Diploma, Computer Programming
Sep 2023 – Apr 2025Georgian College
Bachelor's degree, International Trade
Aug 2018 – Jun 2022ESCI University, Mexico City
Studied supply chain, procurement and international trade.
Apps I built and run
Two web apps I designed, built and still maintain on my own.
Contact
Open to Data Analyst, Business Analyst and Operations Analyst roles in Toronto. The fastest way to reach me is email.