BI & ML Analyst Intern at Venizia Inc

Developed a BI platform unifying import/export operations data across orders, suppliers, logistics, customs, and finance; Designed Power BI dashboards tracking shipment delays, carrier performance, duty costs, and profit margins; Conducted cost-optimization analyses in Python (Pandas, NumPy) and Power BI DAX; Built a machine learning forecasting module to predict shipment delays and order demand; Delivered a complete BI ecosystem covering data modeling, ETL, visualization, and predictive analytics—cutting reporting time by 40% and improving cost-control decision-making.

BI Analyst & Project Lead (Capstone Project) at City of Ottawa / Algonquin BISI

Led a 5-member Agile team; Jira; delivered 100% scope +20% stretch features within 4 sprints. Built end-to-end ETL pipelines (Python, Pandas) to ingest and standardize Excel data, clean and validate records, engineer features, and export final datasets to Power BI for visualization. Designed interactive Power BI dashboards (vacancy %, capacity utilization, wait-list velocity, provider revenue, geo heat-maps) and added self-service drill-through pages. Applied Holt-Winters forecasting (MAPE ≈ 9%) to project child-care demand through the next 6 months. Consolidated analytical findings into executive-level reports and visual summaries; presented insights to municipal planners, driving data-backed resource allocation decisions.

Business Intelligence Intern at STE Comised

Built an integrated BI solution centralizing HR, asset, and budget data for 120+ employees, eliminating manual spreadsheets. Developed interactive Power BI and SSRS dashboards tracking staffing efficiency, asset utilization, and budget performance—cut monthly reporting time by 30%. Modeled and optimized a 3NF SQL Server schema, boosting data integrity and reducing query latency (1.8s → 0.4s). Automated data extraction and validation pipelines (SQL, Excel macros) ensuring cross-department consistency and auditability under ISO 27001 governance standards.