Summary
Education
Skills
Project
Position Of Responsibility
Certifications
Timeline
Generic

Abhijai Arya

Summary

Motivated and analytical 3rd year Mechanical Engineering undergraduate at Delhi Technological University with a strong interest in consulting and business strategy. Skilled in structured problem solving and data-driven analysis, with experience building insight-oriented dashboards using Excel and BI tools. Actively developing consulting-relevant capabilities through analytics projects, strategy simulations, and professional programs, with a focus on translating complex data into clear, actionable business recommendations.

Education

B.TECH -

DELHI TECHNOLOGICAL UNIVERSITY (DTU)
01-2027

High School Diploma -

Delhi Public School, Ghaziabad Vasundhara
01-2022

Skills

Data & Analytics: Advanced Excel, SQL

Visualisation & Reporting: Power BI, Tableau, MS PowerPoint, CAD

Business & Consulting Skills: Structured problem solving, analytical reasoning, market assessment, insight generation

Project

Store Inventory Management & Performance Dashboard |EXCEL

  • Built an interactive Excel dashboard analyzing ₹21M+ revenue across ~31K orders, identifying key drivers of AOV, channel performance, and demand trends
  • Uncovered ~8% revenue leakage due to cancellations/returns through operational analysis
  • Proposed data-driven strategies to increase AOV and optimize high-performing sales channels

Position Of Responsibility

Logistics Coordinator, Cultural Council-Engifest, DTU

  • Managed logistics for Engifest with ~3000+ attendees, ensuring smooth crowd flow and event execution
  • coordinated with vendors, internal teams, and volunteers for stage setup, resource allocation, and real-time issue resolution

Certifications

McKinsey Forward Program Fellow

  • Completed a competitive, cohort-based program by McKinsey, focused on consulting toolkit development
  • Delivered structured solutions to business problems using hypothesis-driven approaches, data analysis and MECE frameworks

BCG Strategy Consulting (Forage)

  • Simulated end-to-end consulting engagement, including problem structuring, market analysis, and growth strategy
  • Synthesised insights into concise, client-ready deliverables with clear business implications

Timeline

B.TECH -

DELHI TECHNOLOGICAL UNIVERSITY (DTU)

High School Diploma -

Delhi Public School, Ghaziabad Vasundhara
Abhijai Arya