Ruchita

Data Analyst with 4+ years of experience driving product and revenue insights at Canada's leading fintech and global technology firms. Expert in SQL, Python, Snowflake, and Power BI to transform complex datasets into executive dashboards and actionable recommendations. Proven track record owning end-to-end analytics for 4M+ user products, optimizing A/B experiments, and building automated reporting pipelines.

PIPEDA-compliant and experienced in cross-functional collaboration with product, engineering, and finance teams.

Data Analyst - Wealthsimple - Toronto, ON

(2024-08)

• Own analytics infrastructure for Cash and Invest products serving 4M+ active users, building SQL data models in Snowflake to track user behavior, funnel conversion, and retention patterns.
• Built 8 Power BI dashboards using DAX and Power Query that became the primary reporting suite for Product and Growth teams, tracking DAU, AUM trends, feature adoption, and campaign ROI.
• Designed and analyzed A/B experiments on onboarding flows in partnership with product managers and engineers, delivering insights that improved Cash account activation rate by 16%.
• Automated weekly executive reporting with Python pipeline (pandas, Snowflake connector), eliminating 12 hours/week of manual work and reducing human error in C-suite metrics.
• Developed SQL-based churn prediction model using RFM segmentation and cohort analysis, identifying at-risk users 45 days in advance and enabling proactive retention campaigns.
• Ensured PIPEDA compliance across all data workflows; documented data lineage and definitions for 30+ KPIs in Confluence, establishing single source of truth for business metrics.

Data Analyst - KPIT - India

(2021-06 - 2024-05)

• Led analytics initiatives delivering Tableau and Power BI dashboards tracking supply chain KPIs, defect rates, and production efficiency across global factory networks.
• Designed SQL pipelines on Azure SQL processing 10M+ records/month; optimized queries with indexing, CTEs, and partitioning, reducing average runtime by 55%.
• Built Python automation (pandas, NumPy) consolidating data from 6 disparate systems into unified reporting layer, cutting monthly data prep from 3 days to 4 hours.
• Conducted hypothesis testing on vehicle telemetry data (statistical trend analysis); findings presented to client C-suite directly informed $420K process improvement initiative.
• Migrated 18 legacy Excel reports to Power BI, achieving single source of truth, reducing distribution time by 70%, and improving stakeholder trust in data accuracy.
• Supported AWS Redshift and S3 data lake queries for connected-vehicle analytics platform, writing optimized SQL for large-scale event extraction and validation.
• Mentored 2 junior analysts on SQL best practices and Power BI; authored internal training documentation adopted as team onboarding standard.

Bachelor of Engineering - Information Technology - Gujarat Technological University