Prakhar Agarwal Email & Phone Number

Kanpur, Up, In

Bengaluru, Karnataka, India

Working as a GET in the 'Electrode' Manufacturing Engineering department of one of India's most ambitious projects - "The Lithium-ion Giga Factory" in Bangalore.

Bengaluru, Karnataka, India

-> Streamlined the process of generating weekly grocery reports by automating 17 distinct reports, significantly reducing manual effort and ensuring timely and accurate data delivery.-> Conducted a comprehensive analysis to determine the correlation between delivery speed and grocery sales, utilizing various data points to provide actionable insights for optimizing delivery times.-> Developed and executed complex SQL queries to extract valuable data insights, including analysis of 'Deals of the Day,' retention metrics across different customer cohorts, and identifying pin codes contributing to the top 95 percentile of sales.-> Designed and implemented Omniture dashboards to visualize key performance metrics, enabling real-time tracking and data-driven decision-making for various business operations.

Bengaluru, Karnataka, India

Designed and developed innovative mass manufacturable powertrain housings, the first of their kind to be used in Mercedes automobiles to ultimately reduce the cost by 9%Focused on enhancing bearing technology for Electric Vehicles, working on solutions that reduced friction and improved longevity.

Kanpur, Uttar Pradesh, India

Gained practical shop floor manufacturing experience and performed quality control inspections to ensure compliance with industry standards.Supervised a group of workers in manufacturing processes such as CNC lathe, VMC, EDM, fabrication and weldingoperations. Also used FASTCAM software and operated CNC Plasma Profile Cutting Machine for production of critical parts.Worked on many projects whose details are mentioned below. Just to name a few-1. Pelleting Machine2. Twin Screw Feeder3. Shop Floor Crane4. Dust Collector5. Centrifugal Blower6. Industrial Machinery Spare Parts

India

->Worked as a Core Member under the Braking and Stability subdivision of Hyperloop India->Did research work on Contactless Eddy Current Braking System->Also worked as a core member for the Design Team->Designed a Roll Stability Model that would prevent our pod from toppling over

India

->Lead the SAE Supra- Bits Goa Racing as the Chassis Head of the club->Redesigned the chassis of our car and various parts->Performed analysis and simulation using ANSYS MECHANICAL so as to build a stiff and a better chassis->Designed aerodynamic bodyworks, driver seat and dummy for our car using SOLIDWORKS->Made reports for the competition

Worked on various Simulations using ANSYS Mechanical. Also made complex parts of our racing car using SOLIDWORKS.

India

Worked as Junior Publicity Head for Bits Goa Racing team. Called many big companies and managers to raise funds for our car.

-> Learnt Solar Panels Installation Process->Researched existing business models such as RESCO and CAPEX ->Made a new business model for the company so as to boost the solar system installation in our country. The model was specially made for the Indian subcontinent.

Goa, India

Worked as Operations Team Member in Hospitality Operations of Nirmaan ( a registered NGO, started by the students of BITS Pilani). I also called many hospitals, private clinics, and opticians for conducting a free eye checkup and first aid for underprivileged people of a nearby slum Zari.

Bachelor Of Engineering - Be, Mechanical Engineering, 8.5

Master Of Science, Biological Sciences, 8.5

High Secondary School, 93.4%