Summary
Work History
Education
Skills
Affiliations
Timeline
Generic

Pranshu Vashishtha

Dehradun

Summary

Aspiring Data Analyst with hands-on experience in SQL, Python, and Excel, skilled at analyzing complex datasets and translating them into clear, actionable insights. Passionate about solving business problems using data and eager to contribute and grow in a data-driven environment.

Work History

Supply Chain E2E Data Analysis

(SQL)
  • Analyzed city-wise and month-wise SLA breaches to find areas with frequent delays
  • Reviewed customer experience metrics by city and month to understand service quality trends
  • Studied hourly order volume to identify peak demand hours
  • Evaluated order processing performance across cities to spot delays and inefficiencies

Delivery Rider performance analysis

(SQL)
  • Calculated rider-level delivery share to understand individual contribution to total orders
  • Analyzed customer NPS at rider level to evaluate service quality and rider performance
  • Identified top-performing riders across cities based on delivery volume and ratings
  • Measured rider-level SLA breach contribution on a weekly and monthly basis
  • Performed rider earnings analysis to understand income and performance trends

Zomato — Order & Customer Analytics

(SQL)
  • Analysed a food delivery dataset of 10,000+ orders and customer records using SQL (PostgreSQL) to assess peak ordering hours, restaurant growth, and customer ordering behaviour.
  • Identified that repeat customers contributed a major share of revenue, supporting the importance of retention-focused marketing strategies.

Education

Bachelor of Computer Applications -

Graphic Era (Hill University)
Dehradun, India
06-2026

Skills

  • Database programming and SQL
  • MS Excel proficiency
  • Python and Java programming
  • Analytical problem solving
  • Data visualization
  • Looker Studio - Basics
  • Google app script - Basics
  • Effective communication skills
  • Team collaboration
  • Critical thinking

Affiliations

Management Committee Member, Organizing Committee, Graphic Era.

Timeline

Supply Chain E2E Data Analysis

(SQL)

Delivery Rider performance analysis

(SQL)

Zomato — Order & Customer Analytics

(SQL)

Bachelor of Computer Applications -

Graphic Era (Hill University)

Similar Profiles

CREATE PROFILE
Pranshu Vashishtha