Summary
Overview
Work History
Education
Skills
EXTRA-CURRICULAR ACTIVITIES
Timeline
Generic

Piyush

Data Analyst | Service Coordinator | Operations Analyst
New Delhi,DL

Summary

Data-driven and detail-oriented professional with experience in SQL, Excel, and Power BI for extracting insights, automating reports, and optimizing operations. Skilled in coordinating cross-functional teams, improving inventory management, and enhancing service efficiency. Passionate about using data to drive business decisions and solve real-world problems.

Overview

3
3
years of professional experience

Work History

Branch Service Co-Ordinator

Sony India
08.2024 - Current
  • Coordinated operations and ensured timely reporting for 14 service centers across North India by leveraging advanced Excel (VLOOKUP, PivotTables), and developing complex SQL queries for accurate data analysis and performance reporting.
  • Automated data reconciliation and reporting processes using SQL and Excel, improving report generation efficiency by 40%, and enabling data-driven decision-making.
  • Implemented strategies to resolve material shortages and optimize inventory management, collaborating with cross-functional teams to enhance service efficiency, and overall customer experience.

Summer Intern

Bharat Heavy Electricals Ltd.
06.2023 - 07.2023
  • Completed an 8-week curated internship program in the Strategic Management Department, actively engaging in strategic analysis and decision-making processes.
  • Led a comprehensive project titled 'Study on Growth Strategy of Information Technology Firms in India', conducting thorough analysis of strategies fueling the growth of IT companies.
  • Employed qualitative and quantitative research methods to extract key insights, contributing to a deeper understanding of effective strategies within the Indian IT sector.

Summer Intern

Indian Oil Corp. Ltd.
06.2022 - 08.2022
  • Completed a 6-week internship focused on electrical engineering, specializing in Load and No-load currents in Drive Units and Relay Settings.
  • Conducted thorough research, gathered data, and collaborated with a team to optimize relay settings for efficient system performance.
  • Presented findings to senior engineers, demonstrating problem-solving skills and practical application of theoretical knowledge.


Education

B. TECH - Electrical Engineering

Delhi Technological University
New Delhi, India
12-2024

CBSE - Class XII

Sanatan Dharm Public School
New Delhi, India
04-2020

CBSE - Class X

Sanatan Dharm Public School
New Delhi, India
04-2018

Skills

  • SQL

  • MS Excel

  • Power BI

  • Python

  • Strong Communication & Presentation Skills

  • Data Analysis

EXTRA-CURRICULAR ACTIVITIES

  • Events Member, YUVAAN, DTU: Actively participated in organizing and managing various events as part of the Literature & Film Fest at Delhi Technological University, collaborating with multiple teams to ensure successful execution.
  • Mentor, Desh Ke Mentor, Delhi Government: Guided and supported four students from a Delhi Government High School, providing academic and career counseling as part of the Delhi Government’s mentorship initiative.

Timeline

Branch Service Co-Ordinator

Sony India
08.2024 - Current

Summer Intern

Bharat Heavy Electricals Ltd.
06.2023 - 07.2023

Summer Intern

Indian Oil Corp. Ltd.
06.2022 - 08.2022

B. TECH - Electrical Engineering

Delhi Technological University

CBSE - Class XII

Sanatan Dharm Public School

CBSE - Class X

Sanatan Dharm Public School
Piyush Data Analyst | Service Coordinator | Operations Analyst