Utkarsh Agarwal
Berkeley,CA
Summary
UC Berkeley student in Data Science and Applied Math with hands-on experience in drivetrain engineering, performance analysis, and STEM education. Skilled in Python, SQL, and visualization tools to turn complex data into clear insights that drive improvement. Passionate about cars and long-distance running, carrying the same persistence, focus, and discipline from rebuilding engines and training miles into problem-solving and collaboration. Experienced in both team-driven research and independent projects, from restoring a car to life to designing STEM curriculum that makes sustainability tangible for students.
Overview
3
3
years of professional experience
Work History
Drivetrain Intern
BMW
Madison, Wisconsin
05.2024 - 12.2024
- Assisted engineers in diagnosing and repairing drivetrain systems on test vehicles, gaining hands-on experience with transmission and powertrain components.
- Collected and analyzed performance data using Python and Excel to identify trends in drivetrain efficiency and durability.
- Designed my own dashboards to track torque, RPM, and fuel efficiency under different load conditions, giving engineers faster insight into performance gaps.
- Supported testing of new drivetrain prototypes, documenting results and suggesting adjustments based on data findings.
- Collaborated with technicians and senior engineers to streamline workflow by integrating data-driven insights with mechanical troubleshooting.
Undergraduate Research Assistant
University Of Wisconsin-madison
Madison, Wisconsin
01.2024 - 06.2024
- Analyzed energy consumption data from student housing, identifying inefficiencies in heating and lighting systems and recommending solutions that reduced usage by over 15%.
- Modeled campus transportation trends to optimize shuttle routes, improving efficiency and reducing delays.
- Collaborated with faculty and PhD researchers to present findings, combining statistical analysis with clear visual reports for stakeholders.
Tech Green Scholars Intern
Seaside Sustainability
Gloucester, Massachusetts
10.2021 - 07.2023
- Designed STEM-based sustainability curriculum for student programs.
- Built and maintained the organization’s website to expand outreach.
- Managed online donations and streamlined fundraising reports.
- Researched coastal conservation and environmental policy to support grants.
Education
Bachelor of Science - Data Science & Applied Math
University of California, Berkeley
Berkeley, CA12-2027
Bachelor of Science - Data Science & Economics - 4.0/4.0
University of Wisconsin, Madison
Madison, WI07-2025
High School Diploma -
Saint Francis High School
Mountain View05-2023
Skills
- Python, R, SQL, Excel
- Data Visualization (Dashboards, Matplotlib)
- Mechanical Troubleshooting (Drivetrain, Powertrain Systems)
- Curriculum Design (STEM & Sustainability Programs)
- Project Management & Event Coordination
- Leadership & Team Collaboration
- Public Speaking & Communication
Languages
Hindi
Native/ Bilingual
English
Native/ Bilingual
Timeline
Drivetrain Intern
BMW
05.2024 - 12.2024
Undergraduate Research Assistant
University Of Wisconsin-madison
01.2024 - 06.2024
Tech Green Scholars Intern
Seaside Sustainability
10.2021 - 07.2023
Bachelor of Science - Data Science & Applied Math
University of California, Berkeley
Bachelor of Science - Data Science & Economics - 4.0/4.0
University of Wisconsin, Madison
High School Diploma -
Saint Francis High School
Similar Profiles
Lucas CarpenterLucas Carpenter
BMW Service Technician at BMWBMW Service Technician at BMW
Marquis HallMarquis Hall
Car Detailer at BMWCar Detailer at BMW
Faith MsibiFaith Msibi
Bookings Clerk /Receptionist at BMWBookings Clerk /Receptionist at BMW
Yogesh TanejaYogesh Taneja
Team Manager at BMWTeam Manager at BMW
Celine ZhongCeline Zhong
Customer Service Representative at State FarmCustomer Service Representative at State Farm