Qiutong Zhao

Qiutong Zhao

BI Solution Architecture
Canada
English, Chinese
Full-time Hybrid

نبذة عني

Business Intelligence professional with 5+ years of experience designing and delivering enterprise analytics solutions across retail, operations, finance, and marketing. Skilled in end-to-end BI architecture, including d…

الخبرة

Senior Business Intelligence Developer

Compass Group Canada · Mississauga
Jan 2024 - حتى الآن · 2 سنوات 10 أشهر

<ul><li>Architected a centralized pricing management platform for 400 P&L accounts and 100+ users using Microsoft Fabric SQL Database, Power BI, and User Data Functions. Enabled real-time writeback, validation, and audit tracking, replacing manual workflows and saving 20+ hours monthly and ~$40K annually.</li><li>Designed enterprise BI and pricing analytics for 7,000+ Canteen locations using Snowflake, SQL stored procedures, and Power BI. Implemented RLS across 10+ branches, integrated sales and P&L reporting, and applied price-sensitivity analysis to evaluate revenue and volume impacts. Automated transaction anomaly detection and Teams alerts to streamline data quality monitoring.</li><li>Built a retail analytics and AI solution integrating Snowflake POS transactions, SKU × store demand forecasting, seasonality modeling, and Power BI semantic models. Developed a Copilot Studio-powered analytics agent assistant for natural-language sales investigation, enabling users to explore performance drivers across products, locations, and promotions.</li><li>Automated promotion-effectiveness analytics using Snowflake, Power Automate, and Power BI, combining campaign participation and YoY performance to measure take rate and execution gaps, helping Marketing identify underperforming campaigns and locations.</li></ul><p></p>

Business Intelligence Developer

Compass Group Canada · Mississauga
May 2023 - Dec 2024 · 1 سنة 7 أشهر

<ul><li>Built an enterprise Like-for-Like reporting framework using SQL Server and Power BI, standardizing weekly, period-to-date, and year-to-date YoY revenue comparisons across sectors and operating units and establishing a consistent source of truth for performance reporting.</li><li>Developed an NLP sentiment-analysis solution using Python and Hugging Face Transformers to classify 2,000+ comments across 20+ emotion categories and sentiment polarities in Power BI, replacing manual Excel reviews and surfacing actionable insights for leadership.</li></ul><p></p>

Intermediate Data Analyst

Abbott Point of Care · Ottawa
Aug 2020 - May 2022 · 1 سنة 8 أشهر

<ul><li>Automated clinical data quality monitoring using R, developing surveillance reports to identify data inconsistencies and anomalies and reducing manual validation time by 50%+.</li><li>Designed MySQL database schemas and supported daily ETL pipelines for clinical data integration, improving data consistency and reliability across reporting and downstream analytical processes.</li><li>Developed and scheduled Power BI dashboards to monitor clinical study progress, detect outliers, and analyze blood test result distributions, enabling data managers to identify issues and track study performance more efficiently.</li></ul><p></p>

Research Analyst Intern

China Construction Bank · Jinan, China
May 2019 - Aug 2019 · 3 أشهر

<ul><li>Gathered data from various sources, including financial statements, databases, and online resources, ensuring the accuracy and completeness of the data.</li><li>Created pivot tables in Excel for individual income, transaction history, and interest rates using VLOOKUP and INDEX & MATCH functions, and generated summary reports.</li></ul><p></p>

المهارات

Snowflake Power BI Microsoft Fabric Advanced Analytics AI Data Integration ETL ELT Data Modeling Semantic Models Security Automation DAX M Query SQL Python Statistics Machine Learning Microsoft Fabric SQL Database User Data Functions SQL stored procedures RLS Teams Power Automate NLP Hugging Face Transformers MySQL Excel VLOOKUP INDEX & MATCH GLM Logistic Regression Decision Tree ANOVA Backward Selection Data Cleaning One-Hot Encoding Exploratory Data Analysis Normalization Log Transformation Data Visualization SAS
الإبلاغ عن هذا الملف الشخصي؟