Vaishnavi Wadhwa
Data Analyst
Data Analyst skilled in SQL, Power BI, Tableau, and ETL processes — transforming complex data into actionable insights. I leverage visualization, reporting, and analytics to support data-driven decision-making and operational efficiency.
2
Years of experience
Vaishnavi
About Me
I am a detail-oriented Data Analyst with hands-on experience in data visualization, ETL workflows, KPI tracking, and predictive analytics. I specialize in Power BI, Tableau, SQL, and advanced Excel to design dashboards, optimize datasets, and support business intelligence strategies. My work focuses on improving operational outcomes through structured data models, automated workflows, and insights that enhance decision-making. Whether building semantic models, performing root-cause analysis, or architecting data pipelines, I combine analytical thinking with practical execution to deliver measurable results.
My expert
areas
Experienced in building interactive dashboards, data models, ETL documentation, and analytical workflows to support forecasting, optimization, and strategic insights across business units.
Skills
Data Visualization (Power BI / Tableau)
SQL Reporting & Database Management
Advanced Excel & Data Cleaning
ETL Data Workflow Documentation
Predictive & Statistical Analytics
Agile Collaboration & Process Optimization
-
5
Projects Delivered -
10
Dashboards Built -
50
Business KPIs Analyzed -
5
Process Improvements Driven
Education
Postgraduate Certificate in IT Business Analysis
Conestoga College
Kitchener, ON, Canada
Sept 2023 – Dec 2024
GPA: 3.73 / 4.0
Bachelor's in Information Technology
DDIT University
Gujarat, India
Mar 2019 – May 2022
GPA: 3.35 / 4.0
Experience
Conestoga College (Loblaws)
Student Data Analyst
- Created detailed process documentation for ETL and data workflows, improving knowledge transfer efficiency and standardization.
- Simulated dynamic pricing strategies for loyalty programs, contributing to a 15% increase in customer retention.
- Analyzed user checkout behavior and optimized UX flow, reducing cart abandonment rates by 20%.
- Developed onboarding prototypes with real-time validations, reducing onboarding delay and cutting user onboarding time by 25%.
- Identified platform access limitations and expanded service availability into new regions, driving 30% regional growth.
Amul Federation
Data Analyst
- Integrated Kaizen methodology to enhance employee participation and engagement, increasing idea submissions and driving ownership culture.
- Built a dashboard to visualize categorized Kaizen entries, improving transparency and fostering constructive competition across teams.
- Simplified authentication and form input workflows, resulting in a 25% increase in idea submission rates.
- Developed a categorized Kaizen Form Application with validation logic, reducing processing time by 40% and accelerating approvals.
- Applied Agile-based sprint planning and continuous feedback loops, consistently completing milestones and enhancing project outcomes.
Certifications
SQL Data Reporting and Analysis
January 2025
LinkedIn Learning
SQL Intermediate Queries
January 2025
LinkedIn Learning
Salesforce Essential Training
January 2025
LinkedIn Learning
Data Cleaning in Python Essential Training
December 2024
LinkedIn Learning
Learning Data Visualization
December 2024
LinkedIn Learning
Predictive Analytics Essential Training: Data Mining
December 2024
IIBA
Projects
Canadian Health Expenditure Dashboard
Academic Project – Conestoga College
Student Data Analyst
Skills Used
- Tableau, Excel, Data Cleaning & Standardization, Geospatial Visualization, KPI Reporting, Demographic Analysis, Data Storytelling, Time-series Analysis, Dataset Normalization, Visualization Design
Key Roles
- Analyzed national health expenditure data (1975–2018) to uncover spending trends across regions, demographics, and time.
- Standardized raw datasets by restructuring formats, resolving null values, and removing aggregates to ensure Tableau-ready visuals.
- Designed interactive geospatial maps and multi-year spending trends to display variations across Canadian provinces.
- Built visuals showcasing age-wise expenditure distribution, enabling identification of high-impact demographic groups.
- Delivered an eight-insight Tableau dashboard narrative that simplified complex multi-decade data into actionable visual reports.
Canadian Domestic Flight Fare Analysis
Personal Data Analytics Project
Data Analyst
Skills Used
- Power BI, Excel, DAX, KPI Calculation, Price Benchmarking, Dashboard Reporting, Semantic Modeling, Exploratory Analysis, Feature Engineering, Travel Pricing Optimization
Key Roles
- Analyzed Canadian round-trip flight pricing to identify cost-driving factors such as routes, airlines, seasonality, and trip duration.
- Built an end-to-end analytics pipeline — cleaned raw data, modeled datasets, and visualized insights using Power BI.
- Developed DAX measures for normalized comparisons: average fare, fare per travel day, and booking window efficiency.
- Translated exploratory findings into booking strategy recommendations supporting data-driven travel planning.
- Built a scalable semantic model with interactive filters and KPIs to improve insight discovery for both technical and non-technical users.
Orders-and-Employee Database Management
Academic Project – SQL & Database Modeling
Student Data Analyst
Skills Used
- SQL Server, Database Design, ERD Modeling (Visio), Views & Stored Procedures, Recursive Queries, Data Integrity Constraints, Schema Optimization, Concurrency Concepts, Query Optimization, Data Cleansing
Key Roles
- Designed and implemented an eCommerce Orders database enabling structured order, product, and shipment tracking with 20+ SQL queries.
- Developed an ERD-driven Employee database addressing hierarchical reporting gaps and missing HR data points.
- Improved schema usability by resolving real-world structural issues such as multi-valued attributes and multiple addresses.
- Created advanced SQL objects — views, stored procedures, functions — streamlining data transformation and reporting automation.
- Enforced PK–FK relationships and referential integrity to support reliable multi-user operations and long-term database stability.
