Akshat Agrawal
+91-7725899433 agrawalakshat108@[Link] LinkedIn GitHub Portfolio LeetCode
Education
Indian Institute of Information Technology and Management, Gwalior Nov 2022 - July 2026
Bachelor of Technology in Computer Science 6.2CGPA
Experience
Tech Mahindra May – July 2025
Data Analyst Intern On-site
• Built an interactive Supply Chain Management dashboard for an aerospace client, providing real-time visibility into procurement,
supplier performance, inventory flow, and key operational KPIs.
• Imported data from multiple sources and used Power Query for ETL, cleaning 1,300+ records and reducing end-to-end reporting
effort by 35%.
• Designed a star schema with a Purchase Order fact table connected to Supplier, Date, Status, and Item dimensions using one-to-
many relationships.
• Used DAX to calculate 15+ KPIs including PO status, monthly PO and visit trends, total POs, total visits, quantities, and repair cost.
• Enhanced dashboard interactivity using drill-through pages, advanced visualizations, and slicers, enabling stakeholders to explore
data at granular levels and derive faster insights.
Technical Skills
Languages: C++, C, Java, JavaScript, Python, HTML, Tailwind CSS
Frameworks and Libraries: [Link], [Link], [Link]
Data Analytics Libraries: NumPy, Pandas, Matplotlib, Seaborn
Databases: MongoDB, Redis, SQL, MySQL
Tools/Technologies: Docker, Nginx, GitHub, Postman, Render, Power BI, Power Query, DAX
Coursework: Data Structures and Algorithms, Operating System, Computer Network, Database Management System
Projects
Messo | React, Tailwind CSS, [Link], Express, Redis, MongoDB, Mongoose, JWT, Docker, Nginx May 2024
• Built a full-stack web app to manage menu ratings, announcements, complaints, and hostel rep evaluations across 5+ hostels and
500+ students.
• Developed frontend with React and Tailwind, and backend with [Link], Express, Redis and MongoDB.
• Implemented secure JWT authentication and scalable multi-hostel support with modular backend architecture.
• Utilized Docker and Nginx for scalable deployment, reducing deployment issues by 30% and improving performance with load
balancing across 3+ backend instances.
IMDb Data Analysis & Visualization | Python, pandas, NumPy, seaborn, matplotlib, nltk, word cloud, Power BI
November 2023
• Analyzed IMDb movie dataset with Python (pandas, NumPy, seaborn); cleaned data and explored trends in ratings, votes, and
runtimes across genres and release years.
• Processed text data using nltk and generated word clouds to surface frequent cast names and themes.
• Built an interactive Power BI dashboard to visualize ratings distribution, genre popularity, and runtime insights with slicers for
dynamic exploration.
Achievements and Positions of Responsibility
• Led and organized educational initiatives at SGM, • solved 300+ DSA problems across LeetCode, Codeforces, and
coordinating volunteers and ensuring smooth event GeeksforGeeks.
execution for underprivileged students. • Attended AI in Finance 2.0 – Coding to Capitalism, gaining
• Participated in LeetCode Weekly Contest 474, achieving a industry insights from leading BFSI firms.
contest rating of 1415.