Data Analytics Engineering Intern
Tesla
Working on Residential Energy data systems, operational reporting, dashboard automation, KPI logic, data quality, and workflow improvements in a business-facing technical environment.
Computer Science major + Business minor at Michigan State University
Apurva Aggarwal
Building data systems and practical software for messy real-world problems
About
Building systems where data, software, and operations meet.
- Computer Science major and Business minor at Michigan State University, graduating in May 2027.
- Currently at Tesla Energy, building reporting, automation, GenAI workflows, and data quality systems.
- Previously at EY, supported data migration through SQL, validation, reconciliation, and UAT.
- Projects span machine learning, computer vision, sustainability analytics, microservices, and hackathons.
- Strongest in ambiguity, turning messy data and workflows into reliable technical systems.
Work
Experience
Technical and leadership roles across data systems, consulting, student organizations, and residential life.
Technology Consulting Intern
EY
Contributed to enterprise systems work involving ETL SQL scripts, data validation, reconciliation, UAT support, issue triage, and cross-functional stakeholder coordination.
Co-Director
SpartaHack
Help lead planning and execution for MSU's student-run hackathon, supporting team coordination, event operations, logistics, and the overall hacker experience.
Director of Technical Affairs
International Students Association
Lead technical planning and development for ISA systems, including website infrastructure, affiliate tooling, and internal workflow improvements.
Data Analyst
The Global Career Accelerator
Analyzed real-world business datasets using Excel, PivotTables, XLOOKUP, A/B testing, and data visualization, translating findings into actionable recommendations across media, sustainability, and operations-focused projects.
Resident Assistant
Michigan State University
Support residents through communication, conflict management, community programming, crisis response, and consistent people-facing ownership.
B.S. Computer Science, Business Minor
Michigan State University
Building a technical foundation while intentionally connecting software, data systems, analytics, and business strategy.
Builds
Projects
Selected work across machine learning, backend systems, internal tools, and interactive software.
01
ISA Affiliate CRM
A planned CRM-style web app for the ISA to manage affiliates, meeting attendance, and funding requests.
More details
Problem
ISA needs a more structured way to manage affiliate organizations, track participation, and handle funding request workflows.
Approach
Leading technical planning for a lightweight internal system with affiliate-facing views, admin workflows, attendance tracking, and funding request management.
Result
Currently in planning and early development, with focus on requirements, hosting constraints, data policies, and long-term maintainability.
02
Micro Foods Market
A microservices-based food marketplace project focused on user authentication, service separation, and containerized development.
More details
Problem
Modern web systems need clean separation between services, authentication, data storage, and application logic.
Approach
Built and worked with backend services using Flask, SQLite, and Docker Compose, with reusable authentication and user-service patterns.
Result
Created a foundation that can be refactored and reused in future web systems, including ISA's planned affiliate CRM.
03
FarmX - Sustainable Agriculture
A machine-learning prototype for agriculture decision support, built quickly under hackathon constraints.
More details
Problem
Agricultural decisions around crop suitability and nitrogen usage have practical consequences for yield, cost, and sustainability.
Approach
Built a prediction workflow using environmental and agricultural input data, then shaped it into a usable prototype for quick decision support.
Result
Won Best Sustainability Track at MHacks and showed my ability to turn an idea into a meaningful prototype under pressure.
04
Celebrity Face Recognition
A computer vision project that fine-tuned a deep learning model to classify celebrity faces across multiple classes.
More details
Problem
Image classification models need to distinguish between visually similar faces while handling variation in lighting, pose, and image quality.
Approach
Fine-tuned an AlexNet-based model using transfer learning, structured the dataset across multiple celebrity classes, and evaluated performance through repeated validation.
Result
Built a working face recognition pipeline that strengthened my understanding of computer vision, model training, validation, and applied deep learning.
05
Intel Sustainability Modeling
A sustainability-focused data analysis project evaluating regional energy readiness for potential data center expansion.
More details
Problem
Large data centers can create significant energy demand, so expansion decisions need to account for regional energy availability, renewable mix, and grid stability.
Approach
Analyzed regional energy datasets using Tableau and visualizations to compare power availability, usage patterns, renewable energy mix, and ability to handle increased demand.
Result
Translated energy and sustainability data into recommendations about which regions appeared better equipped to support future data center growth.
06
Battleship Terminal Game
A Python terminal-based game project focused on gameplay logic, state management, and object-oriented design.
More details
Problem
Games require clean handling of state, user input, rules, and repeated interactions, even in a simple terminal environment.
Approach
Built a playable terminal game in Python, focusing on core mechanics, structured logic, and a foundation that could later be expanded into a graphical UI.
Result
Developed a functional game project that strengthened my ability to organize interactive software systems from scratch.
Skills
Technical Stack
Tools and skills grouped by how I use them.
Data Engineering
Analytics Engineering
Software + ML
Business + Execution
Contact
Let's build something useful.
Reach out about software, data, AI projects, sustainability, internships, or collaborations.