Summary
Overview
Work History
Education
Skills
Websites
Certification
Key Characteristics
Languages
Accomplishments
Languages
Timeline
Generic

Rajveer Singh Sarangdevot

Pune

Summary

Data Analyst with more than 3 years of experience in analyzing large data sets and coming up with data-driven insights for early-stage service-based companies. Worked in teams of 8-12 team members.

Overview

4
4
years of professional experience
1
1
Certification

Work History

Data Analyst

Xpressbees
Pune
06.2022 - Current
  • Automation of existing reports to cut down manual intervention by 50% for analysis
  • Reduced processing time for weekly reports through automation, achieving 99% on-time delivery rate to stakeholders
  • Spearheaded development and implementation of revamped incentive structure for last-mile employees
  • Integrated performance-based bonuses tied to key metrics, resulting in remarkable 10% increase in on-time deliveries and 25% decrease in customer complaints
  • Created visually engaging dashboards to present data, offering stakeholders insightful understanding of critical numbers
  • Collaborated with HR team to identify improvement opportunities by analyzing key metrics and KPIs related to retention and monetization and brought monthly costs down by 5%.
  • Proficient in data manipulation using SQL to extract valuable insights and support informed decision-making
  • Conducted Root Cause Analysis (RCA) on incidents, leveraging analytical skills to uncover underlying issues and drive effective solutions.
  • Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
  • Produced monthly reports using advanced Excel spreadsheet functions.
  • Tested data prediction algorithms based on historical data.

Data Analyst

Delhivery Pvt Ltd
Porvorim
03.2020 - 05.2022
  • Applied data-driven analysis and cluster mapping techniques to segregate profitable zones, optimizing resource allocation
  • Conducted data mining and implemented restructuring with basic checks to enhance data quality and usability
  • Identified new business opportunities by recognizing untapped lanes, contributing to business expansion
  • Successfully understood and addressed client’s unique business requirements to provide tailored vehicle solutions
  • Monitored monthly and quarterly Profit & Loss (P&L) statements for major clients, ensuring overall profitability and client satisfaction
  • Collected optimal price quotes from third-party providers for market cluster lanes, optimizing cost-efficiency
  • Maintained data integrity and collaborated closely with supply team stakeholders to achieve performance targets and business goals
  • Managed team of 5 members.
  • Defined clusters by grouping data and analyzed regional performance to enhance overall business profitability.

Education

B. Tech - Mechanical Engineering

Galgotias University
Greater Noida, UP
01.2019

XII - Science

Alok Sr. Sec. School
Udaipur, RJ
01.2014

X -

Alok Sr. Sec. School
Udaipur, RJ
01.2012

Skills

  • Advanced MS Excel
  • SQL
  • Power BI
  • Tableau
  • Data Analytics
  • Data Management
  • Logistics
  • Development And Training
  • HR Analytics
  • Data Quality
  • Data Mining
  • Data Visualization and Presentations

Websites

Certification

  • SQL (Intermediate)
  • SQL (Basic)

Key Characteristics

  • Strong Interpersonal & Communication Skills
  • Collaborative Team Player
  • Problem Solving & Analytical Approach
  • Leadership
  • Meticulous Attention to Detail
  • Continuous Learning

Languages

  • English
  • Hindi

Accomplishments

  • Awarded as Employee of the Quarter.


Languages

English
Bilingual or Proficient (C2)
Hindi
Advanced (C1)

Timeline

Data Analyst

Xpressbees
06.2022 - Current

Data Analyst

Delhivery Pvt Ltd
03.2020 - 05.2022

B. Tech - Mechanical Engineering

Galgotias University

XII - Science

Alok Sr. Sec. School

X -

Alok Sr. Sec. School

Similar Profiles

CREATE PROFILE
Rajveer Singh Sarangdevot