Back to Developers
vaibhav tyagi

vaibhav tyagi

Data Analyst

Toronto, ON
83
Profile Score

About

Data Analyst with 2+ years of experience specializing in automated reporting engines and scalable data architecture. Expert in converting multi-million row datasets into actionable insights using Python, R (Markdown), Power BI and Snowflake. Proven track record of increasing profitability by 20% and reducing reporting cycles from weeks to minutes through parametric automation and advanced Power BI visualization.

Skills & Expertise (13)

Power BI (Advanced DAX) Advanced
8.3/10
2
Years Exp
Python (Pandas, NumPy, SciPy) Advanced
8.0/10
2
Years Exp
SQL Advanced
7.8/10
2
Years Exp
ETL/ELT pipelines Advanced
7.8/10
2
Years Exp
Snowflake Intermediate
7.5/10
1
Years Exp
KPI development Advanced
7.5/10
2
Years Exp
R (tidyverse, R Markdown) Intermediate
7.3/10
1
Years Exp
DataMart Design Intermediate
7.0/10
1
Years Exp
Excel (VBA) Intermediate
6.8/10
2
Years Exp
Tableau Intermediate
6.5/10
1
Years Exp
Statistical Modeling Intermediate
6.3/10
1
Years Exp
Parametric Reporting Intermediate
6.0/10
1
Years Exp
Geospatial Analysis Intermediate
5.8/10
1
Years Exp

Work Experience

Consultant - Data Analyst

George Brown College

Sep 2023 - Jun 2024

Acted as the bridge between technical data structures and business stakeholders, documenting requirements to ensure reporting accuracy across all departments. Architected and Automated a Snowflake DataMart: Integrated data from 15+ disparate sources using Python-based ETL pipelines, reducing manual processing time by 60% and saving 30+ hours weekly. Developed a multi-page Power BI suite tracking digital KPIs and engagement; optimized 20+ complex DAX measures to ensure 100% data accuracy and stakeholder usability. Automated the extraction and segmentation of PRIZM data, eliminating 70+ hours of manual effort and enabling rapid, cross-Canada audience analysis.

Data Analyst Intern

Invest India (Ministry of Commerce)

Nov 2022 - May 2023

Engineered an end-to-end reporting engine using R Markdown to extract, clean, and analyze multi-million row datasets; automated the generation of localized state-level reports in Word format, reducing the production cycle from 4 weeks to minutes. Developed a multi-factor maturity index using 5 key pillars (MNCs, FDI, Exports, Startups, and Unicorns) to evaluate city-level economic readiness; identified Tier 1 saturation and mapped data-driven expansion roadmaps for emerging Tier 2 hubs. Designed interactive dashboards to visualize regional performance metrics, enabling stakeholders to compare complex economic indicators and identify investment gaps. Implemented automated error-checking protocols within R scripts to ensure 100% data integrity across all 28+ state reports prior to government publication.

Operations Analyst

Neopay (Startup)

Jan 2022 - Oct 2022

Analyzed transactional data for 1,000+ FMCG SKUs using Python (Pandas, SciPy) to resolve wholesaler pricing inconsistencies; implemented a standardized pricing model that increased platform-wide profitability by 20%. Built visual route models by analyzing delivery latency data; identified bottlenecks in the fulfillment cycle to reduce average delivery time by 20%. Designed a Power BI performance suite to monitor the data entry team; tracked daily invoice throughput, item-level accuracy, and average processing time, enabling data-driven performance benchmarking. Developed a real-time Power BI dashboard integrated with SQL-exported data to track new orders and enrollments; mapped performance across 200+ sales reps to monitor and improve conversion rates. Led data modeling sessions with senior leadership to define and validate core business metrics, ensuring 100% alignment between operational dashboards and strategic goals.

Education

Post-Graduate In Project Management - George Brown College

2024 - 2025 · Afghanistan

Post-Graduate In Data Analytics - George Brown College

2023 - 2024 · Afghanistan

Bachelor of Business Administration (Marketing) - Bennett University

2018 - 2021 · Afghanistan

Certifications

Microsoft Power BI

Udemy · 2022

SQL for Data Science

IBM · 2021

Introduction to R Programming for Data Science

Microsoft · 2019

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 18/20
🎓 Education 10/10
⏱️ Experience 5/15
💰 Rate 0/5
🏆 Certs 5/5
Verified 5/5
Total Score 83/100

Profile Overview

Member sinceMar 2026

Availability Details

Relocation

Open to Relocation

Skills (13)

Power BI (Advanced DAX) Python (Pandas, NumPy, SciPy) SQL ETL/ELT pipelines Snowflake KPI development R (tidyverse, R Markdown) DataMart Design Excel (VBA) Tableau +3 more