Summary
Overview
Work History
Education
Skills
Certification
Key Projects
References
Timeline
Generic

Sapana Patel

Sudbury,Canada

Summary

Results-driven professional with expertise in data analytics and team leadership. Optimized HR processes and improved employee performance tracking. Proficient in SQL and Power BI, developed impactful dashboards that enhanced decision-making and retention strategies. Committed to delivering actionable insights and fostering collaboration within teams.

Overview

5
5
years of professional experience
1
1
Certification

Work History

Customer Service Manager

Walmart Canada
Sudbury, Canada
02.2023 - Current
  • Managed HR records and staff schedules; produced Excel-based weekly reports on employee performance.
  • Tracked absenteeism and supported hiring efforts with HR team.
  • Collaborated with store leadership on headcount forecasting and shift optimization.

Jr. Data Engineer

Vistara Automation
Mumbai, India
05.2020 - 04.2024
  • Built scalable ETL workflows using SQL and Python to support HR reporting needs, employee data tracking, and performance dashboards.
  • Managed large datasets from recruitment, payroll, and HRMS tools to generate periodic analytics reports.
  • Implemented rule-based data validation and transformation pipelines ensuring clean, trustworthy HR metrics.
  • Supported multiple internal dashboards for HR, recruitment, and retention analytics using Power BI.
  • Applied predictive techniques for churn and attrition analysis.

Education

Master of Science - Computational Science

Laurentian University
Sudbury, ON
04.2024

Skills

  • Data analytics and BI tools
  • Power BI and Excel
  • DAX and SQL
  • KPI development
  • Python and PySpark
  • ETL and data engineering
  • HR data analysis
  • Compliance monitoring
  • Metadata management practices
  • Azure data engineering and analytics
  • Agile methodologies
  • Project management
  • Team building and leadership

Certification

  • Microsoft Certified: Azure Data Fundamentals (DP-900) certified
  • Building Practical Skills in NLP and Generative AI , completed
  • Azure Enterprise Data Analyst (DP-500)&(DP-700) , In Progress

Key Projects

HR Data Pipeline for Attrition & Performance

  • Ingested and transformed HR data using ADF, Databricks, and Power BI.
  • Delivered performance dashboards with KPIs such as engagement score, productivity rate, and turnover.

Workforce Predictive Analysis

  • Used logistic regression to predict employee attrition based on features like age, salary, and tenure.
  • Visualized insights in Power BI with department-wise risk breakdowns.

Customer 360 with Employee Sentiment Analytics

  • Integrated customer service and internal employee feedback datasets to assess the correlation between staff engagement and customer satisfaction.
  • Applied Natural Language Processing (NLP) to analyze sentiment from employee feedback surveys and identify workforce morale trends.
  • Developed interactive Power BI dashboards and SQL views to visualize service ratings, issue resolution metrics, and team performance across departments.

References

References available upon request.

Timeline

Customer Service Manager

Walmart Canada
02.2023 - Current

Jr. Data Engineer

Vistara Automation
05.2020 - 04.2024

Master of Science - Computational Science

Laurentian University
Sapana Patel