SHUBHAM KUMAR
New Delhi · Final-year, DTU

Shubham Kumar

Data Analyst · Mechanical engineering foundation

I find the signal in 150K-row datasets and turn it into a decision — SQL, Python, and statistical rigor applied to real problems, not toy ones.

Review the analysis Get in touch
shubham — casefile.sh
FILE / 01 Subject Profile

I'm Shubham, a final-year Mechanical Engineering student at Delhi Technological University who ended up spending most of his time in SQL, Python, and statistical models instead of CAD software — though the CAD stuck around too.

My work is grounded in statistical rigor: taking a raw, messy dataset and working it — through EDA, segmentation, and modeling — until it produces a number someone can actually act on.

Outside of casework: I was a Dell Aspire Scholar, held an NCC 'A' Certificate, and led my school house as Captain — a recurring theme of structured effort, under pressure, in front of people.

EducationB.Tech, Mechanical Engg. — DTU
Based inNew Delhi, India
Core stackSQL · Python · Power BI
Email
shubham1sure@gmail.com
Phone
+91-7836878701
FILE / 02 Case Log

A roadmap of where the work happened, in order.

Completed May '26 — Jul '26
Analyst Fellowship
CrackNonTech · Delhi
  • Solved guesstimates and live business cases across profitability, market-entry, and industry analysis under time pressure.
  • Presented data-driven recommendations via stakeholder-ready decks, tuning depth from technical detail to executive summary.
  • Applied SQL and Python to real business datasets, converting raw data into decision-ready recommendations for non-technical stakeholders.
Completed Jun '25 — Jul '25
Plant Design Intern
Engineers India Limited (EIL) · Gurugram
  • Produced plant layout and equipment drawings in AutoCAD for a live government infrastructure project.
  • Built an automated Excel tool with formula-driven logic to consolidate spend data, cutting manual processing effort for the project team.
  • Rated 'Excellent' in final performance evaluation — technical accuracy, task completion, professional conduct.
Up next
Full-time DA / BA role
Wherever the next hard problem is
FILE / 03 Technical Case Studies

Three projects where analysis and modeling drove a real decision — open one for the full report.

FILE / 04 Toolkit
01Analysis & Modeling
Python
SQL
MySQL
Pandas
Statistics & ML
02Business & Case Work
Structured Problem-Solving
Case Analysis
Power BI
Excel
03Delivery
Stakeholder Communication
Git / GitHub
Dell Aspire Scholar 2023
Selected among top national scholars — Michael & Susan Dell Foundation
NCC 'A' Certificate
Represented Delhi cadets nationally; met the Hon'ble PM at Red Fort
House Captain
Led Fraternity house to multiple gold medals in inter-house competitions
FILE / 05 Open A New Case

Have a dataset
worth looking into?

I'm looking for data analyst roles and internships where ambiguity in the dataset is the job, not the obstacle.

+91-7836878701
ESC