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, India12-2024
CBSE - Class XII
Sanatan Dharm Public School
New Delhi, India04-2020
CBSE - Class X
Sanatan Dharm Public School
New Delhi, India04-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