Projects

Ontario COVID Scholastic Impact Analysis

• Determine COVID-19 pandemic academic performance impact at the elementary and high school level in Ontario. Identify geographical areas that may serve as physical placements for resource allocation.

Tech Stack : Azure Blob Storage, Azure Data Factory, Azure SQL Database, Power BI
GitHub

Retail Sales Analysis

• Analyze Sales Trends, Profit/Revenue Breakdown, Sales Channel performance, and customer demographics for a fictional Canadian Boutique retail store.

Tech Stack : Tableau
GitHub
Dashboard

Olympics SQL Demonstration

• Create advanced SQL illustrating aggregation, multiple variations of joins, CTE, CASE, Window Functions on Kaggle Olympic data using Postgres.

Tech Stack : SQL, Postgres
GitHub

Toronto Crime Statistic

• A visualization for Toronto Crime Statistics

Tech Stack : Tableau
GitHub
Dashboard

Kalista

• A Python API Wrapper that allows for simple access to Riot Games’ eSports API.

Tech Stack: Python, asynchronous, pandas
Github
Documentation

S&P 500 Dashboard

• A visualization for S&P 500 data

Tech Stack: Tableau
Dashboard

Toronto Crime DBT

• A DBT project that transforms Toronto Crime data into a star schema

Tech Stack: DBT, Postgres, Python, Docker, Jinja
GitHub

AI-Powered Travel Itinerary Planner

• A work in progress travel itinerary planner that powered by AI agents.

Tech Stack: Python, Firebase, Serverless Architecture, TinyAgents, AI, LLMs Website