Open to opportunities

SAKSHI MEHAN

@sakshimehan

Message

Data analyst skilled in SQL, Python, and BI for actionable business insights.

Canada

Message

What I'm looking for

I seek analytic roles that leverage SQL/Python and BI tools to deliver actionable insights, emphasize collaboration, mentorship, and opportunities to improve reporting and operational efficiency.

I am a data analyst with experience optimizing SQL performance, building BI dashboards, and applying Python for forecasting and exploratory analysis. I deliver actionable insights that improve reporting efficiency and support data-driven decisions.

At Tata Consultancy Services and Capgemini I tuned databases, automated reporting workflows, and mentored analyst teams, achieving measurable improvements in query speed, reporting time, and operational effectiveness. In academic projects at BCIT I modeled electricity trade and forecasting scenarios, projecting import needs and recommending resilience strategies.

I combine technical skills in SQL, Python, Tableau, and Power BI with strong communication and problem-solving to translate complex data into clear recommendations. I enjoy mentoring and applying analytics to solve operational and strategic challenges.

Experience

Work history, roles, and key accomplishments

Current

Volunteer Tutor

Current

The C.O.D.E. Initiative

Jan 2025 - Present (1 year)

Delivered lessons in Scratch, Sphero Robotics, and Python and provided code reviews and mentorship, improving elementary students' coding proficiency.

Python Scratch Sphero Robotics Teaching Mentorship Code Review Curriculum Development Communication

Capstone Project Lead

BCIT

Feb 2025 - May 2025 (3 months)

Analyzed cross-border electricity trade (2007–2026) and forecasted 7.5M MWh net imports for BC in 2025–2026, modeling shortage scenarios and recommending storage and microgrid islanding to improve grid resilience.

Python Pandas Data Visualization Matplotlib

Student Analyst

BCIT

Sep 2024 - Jan 2025 (4 months)

Analyzed survey and credit card retention data, built Power BI dashboards and Excel analyses to optimize product testing and uncover churn drivers, improving data-driven decision-making and reporting performance.

Power BI Excel Python Data Analysis Data Visualization Statistical Analysis Reporting

Systems Analyst

Tata Consultancy Services

Sep 2023 - Nov 2024 (1 year 2 months)

Optimized SQL queries and indexing to improve data retrieval speed by 30%, automated SLA reporting to cut manual reporting time by 30%, and validated migration of 100,000+ records improving reporting efficiency by 20%.

SQL Query Optimization Data Validation Python Data Migration Performance Tuning

Associate Consultant

Capgemini

Aug 2019 - Aug 2023 (4 years)

Improved database performance and reporting through SQL tuning and ETL automation, mentored a 12-person analyst team, and enabled real-time insights for a European electronics retailer.