Shubham Joshi
Jaipur
Summary
Results-driven Data Analyst with over 5 years of experience utilizing SQL, Power BI, and advanced analytics to enhance business performance. Reduced attrition and optimized spending through data-driven strategies. Skilled in developing executive dashboards and converting complex datasets into actionable insights for informed leadership decisions.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Data Analyst
SK Finance
Jaipur
11.2023 - Current
- Cleaned and transformed structured and semi-structured datasets using Power BI and Advanced Excel to automate reporting workflows.
- Reduced manual reporting effort by automating dashboards, cutting reporting turnaround time by approximately 40–50%.
- Conducted year-over-year consultant spend analysis and hiring channel performance benchmarking; restructured sourcing strategy using campus hiring and internship pipeline, reducing consultant dependency by 36% (₹18 lakhs annual savings) and improving overall hiring cost efficiency.
- Improved offer-to-joining conversion rate from 82% to 93% (11% increase) by implementing recruitment funnel analytics, stage-wise drop-off analysis, and process control checkpoints.
- Identified and prevented 30 potential financial fraud cases within one month by introducing data-driven background verification controls, including Criminal Record and CIBIL score checks; significantly reduced fraud exposure risk.
- Performed advanced attrition analytics using trend analysis, cohort segmentation, and voluntary vs involuntary exit modeling; reduced overall attrition rate from 6% to 4% (33% reduction) by identifying key resignation drivers and implementing structured exit interviews.
- Developed executive-level Board Review dashboards and analytical presentations, delivering actionable business insights from financial datasets to facilitate informed strategic decision-making for leadership.
Data Analyst
WheelsEye Technology
Gurugram
01.2023 - 11.2023
- Managed employee database for over 1,000 employees in Google Sheets to ensure data accuracy and accessibility.
- Developed HR dashboards from scratch in Google Sheets to enhance data visualization and reporting capabilities.
- Automated daily HR reports and streamlined employee onboarding and off-boarding processes using Python.
- Reduced error percentage in the hiring process from 60% to 2.5% by redesigning the process from manual to automated.
- Reduced attrition % from 13% to 5%.
- Reduced the employee travel cost by 20%. Saved extra charges due to price surges in emergency flight bookings.
HR Analyst
Teleperformance
Jaipur
06.2021 - 01.2023
- Developed dashboards and reports in Excel to track key performance indicators for improved visibility.
- Improved resolution quality score of Business Human resources by 10% through audits and training sessions.
- Reduced pending training sessions in system from 1000 to 500 by creating audit reports in Excel.
- Streamlined onboarding process for newly hired HR executives to enhance integration experience.
Education
B.Tech - Mechanical Core
Vellore Institute of Technology
Vellore, Tamil Nadu08.2018
12th - Science
Saint Soldier Public School
Jaipur06.2013
10th -
Saint Soldier Public School
Jaipur06.2011
Skills
- SQL Databases
- Python
- Power BI
- Data Modeling & ETL (Power Query)
- Advanced Excel (Pivot Tables, Data Transformation)
- Statistical analysis
- Google Sheets
- Google Analytics
- Data visualization
- Process Improvement
- PowerPoint
Certification
- Google Data Analytics Professional Certificate
- Data Analysis and Visualization with Power BI
- Internship at North-Western Railways
- TIFAC Big Data
Timeline
Data Analyst
SK Finance
11.2023 - Current
Data Analyst
WheelsEye Technology
01.2023 - 11.2023
HR Analyst
Teleperformance
06.2021 - 01.2023
B.Tech - Mechanical Core
Vellore Institute of Technology
12th - Science
Saint Soldier Public School
10th -
Saint Soldier Public School