All Projects

Academic work and things I've built

Every term project from the PGDM at Great Lakes Gurgaon, plus the side projects I've built outside class.

PGDM, Term 1 to 3

Business Intelligence · Power BI

Movie Investment Analysis

A Power BI study that treats film investment as a finance problem: five business questions on budget, genre, language industry, cast and OTT distribution, answered from historical movie data and pulled together into one recommendation for a first-time producer.

Power BIDashboardingROI Analysis

Term 2 · Business Analytics

Decoding India's Workforce

A group study of 10,045 Indian job-seeker profiles on how education, experience, skills and location shape pay and mobility, using EDA, log-linear regression, K-Means clustering and percentile-ratio inequality measures. Submitted to Prof. Bappaditya Mukhopadhyay.

EDARegressionClusteringPython

Term 2 · Marketing Management II

Marketing Plan, House of Crunch

A burger QSR brand concept built from scratch for a Marketing Management II group exercise: brand name, positioning statement, a five-line product mix with serving sizes and prices, a 46-SKU burger line mapped by width and depth, and a psychological entry-pricing strategy.

Brand ConceptProduct MixPricing

Term 2 · Marketing Management II

LEE Jeans in India, a Marketing Plan

A full marketing plan for LEE Jeans in India, built from secondary market sizing, segment and brand-share estimates, and interviews with LEE customers, competitor customers and a LEE dealer, ending in an Ansoff-based strategy and a costed Q1 2026 marcom plan. Presented to Prof. Parveen Ahluwalia.

Marketing PlanPrimary ResearchAnsoff

Term 2 · Production & Operations Management

Kaizen, Section A

A group project applying Kaizen, continuous improvement principles, to a real process, presented and filmed for submission.

Process ImprovementKaizen

Term 1 · Financial Accounting & Decision Making

Ratio Analysis of Tata Motors

Five-year vertical, horizontal and ratio analysis of Tata Motors' standalone financials (FY2020-21 to FY2024-25), covering liquidity, working capital, leverage, profitability and investor ratios, benchmarked against Maruti Suzuki and an industry aggregate, and ending in an investment recommendation.

Ratio AnalysisFinancial Statements

Term 3 · Strategic Management

The Strategic Logic of Econstru

A field study of Econstru, a four-person, self-funded lighting procurement startup in Bangalore, built from two live interviews with the founder rather than secondary data, applying five frameworks (effectuation, VRIO, dynamic capabilities, jugaad, entrepreneurial orientation).

Field ResearchStrategy Frameworks

Term 1 · Statistical Methods in Decision Making

Foodpanda Growth, Statistically

Descriptive statistics, six hypothesis tests and a regression on 6,000 Foodpanda orders, closing with recommendations on where revenue growth can and cannot come from.

Hypothesis TestingRegression

Term 1 · Marketing Management I

STP Strategy for Pizza Express

An eight-member secondary-research study of Pizza Express in India: market sizing and segmentation, a product-level comparison with Domino's, Pizza Hut and La Pino'z, and an analysis of the brand's existing segmentation, targeting and positioning.

STPSecondary Research

Term 2 · Groups in Organization

Reading Our Own Group

A reflective analysis of my own six-person study group across Terms 1 and 2, using FIRO-B scores and four critical incidents to explain how we worked, where we clashed, and why.

FIRO-BGroup Dynamics

Term 3 · Business Research Methods

What Drives Canteen Queues

A non-participant ethnographic study of the campus mess: 6 to 10 hours of observation across a week of breakfasts, lunches, snacks, dinners and the late-night paid counter, hand-coded from descriptive, interpretive and reflexive field notes into six behavioural themes.

EthnographyQualitative CodingPrimary Data

Term 3 · Financial Management

Cost of Capital, Three Companies

Estimated cost of equity (CAPM), cost of debt and WACC for Wipro, TCS and IBM, and traced the gap between them to home-market rates, beta and capital structure.

WACCValuation

Term 3 · Human Resource Management

VR in Employee Development

An HR article review arguing that VR simulation builds soft skills better than classroom or e-learning formats, paired with a group study of how HR practitioners in IT and technology firms actually use AI tools, based on practitioner interviews.

HR PracticeAI in HRPractitioner Interviews

Term 1 · Karma Yoga

Pathways to the Future

A career guidance handbook for school students in Bilaspur and Uttarakhand, where career counselling is scarce: stream-wise flowcharts from Class 10, fifteen career profiles with eligibility, exams, fees and duration, and a sector-wise guide to defence, tech, health, public sector and commerce jobs.

Community ServiceCareer Guidance

Side projects

Open Source · Telegram Bot

Yukki Music Bot

An open-source Telegram music and video streaming bot written in Python with Pyrogram and Py-Tgcalls. I started it in December 2021 and maintained it to December 2024; it stands at 1,400 stars and 4,228 forks on GitHub, and by my own count it reached more than 250,000 groups and 20 million users before I sold it for six lakh rupees.

PythonPyrogramOpen SourceTelegram

MarQuest · Web Platform

marquest.in

The web platform I built and run for MarQuest, the marketing club at Great Lakes Gurgaon: news, a placement prep hub, a daily aptitude bank, events with registration, live event quizzes, and an admin panel for the club team, on Next.js 14, TypeScript and MongoDB.

Next.jsTypeScriptMongoDBClaude APIsocket.io

MarQuest · Telegram Bot + Mini App

PGDM Timetable Bot

A Telegram bot and mini app that reads the live PGDM timetable sheet, works out each student's personal schedule across sections, groups and electives, and sends per-class reminders and change alerts automatically.

Pythonpython-telegram-botMongoDBGoogle Sheets APITelegram Mini App

Freelance · UI/UX

CK App Suite

Eight mobile screens for a client's gaming and affiliate platform: the agent side (referral code, multi-level commission dashboard, commission details and history) and the player profile side (wallet, quick actions, service centre and a six-tier VIP progress system).

UI DesignMobile

Freelance · Automation

Fiverr Client Work

Small web and automation builds sold through Fiverr, USD 2,138 earned before taxes over the life of the account, with nothing lost to expenses or disputes.

Web DevAutomation

BETFOC · Internship

Payment Ops Bot

The Telegram notification bot from my BETFOC internship: it watches a client's payment backend for new deposit and withdrawal requests, pushes a real-time alert with the payment details, and lets the operator approve a deposit in one tap.

PythonPyrogramMongoDBREST API