Internships / Work Experience
ADB Project
Economic and Infra Development of the Kaylana Lake region in Rajasthan as a tourist hub
Sector
Infrastructure, Tourism, Development Finance
Challenge
Determine reasons for low tourist footfall at Kaylana Lake in Rajasthan, and recommend economic / infrastructure solutions to increase the footfall
Approach
- Primary Research / Data Analysis
Conducted primary research through small businesses at Kaylana Lake. Analyzed data to determine annual visitor footfall and resulting tourist market sizing.
- Analysis of Infrastructure Gaps and Economic Feasibility
Critically analyzed infrastructure gaps, policies and funding around Sewage, Transportation, Water, Solid Waste, Telecom Towers, Electricity and Tourist Activities
Solution
Recommended policy sustainable infrastructure, and financing solutions to improve tourist footfall
- Public Bus Stop near lake - Mobility
- Green Zone around lake
- Tourist Activities (Electric Boats, Night Zipline, Regulated Fishing, Biking Track)
- Women's Safety Initiatives
- Improved Drainage, Sewage, Solid Waste Treatment and Telecom Connectivity
Impact / Result
- Feasibility Study for Infrastructure Financing
Feasibility study will be used for ADB DFI Financing for infrastructure projects leading to an increase in tourist footfall in the lake region and job creation.
Skills Developed
Development Economics, DFI Finance, Primary Research, Extrapolation, Market Sizing Data Analysis, Policy
Sector
Dairy Consumer, E-Commerce
Challenge
Reduce inventory losses for dairy products portfolio across 18 cities by improving accuracy of Next-Day Demand Forecasts to be as close as possible to Actual Demand.
Approach
- Factors affecting Demand
Understood factors affecting demand - festivals, holidays, weekends, seasons, leakage, unforeseen surge
- Data Analysis
Analyzed data for all dairy products across 18 cities, including Actual Demand and Indent (existing forecast).
- Team Collaboration
Collaborated closely with forecasting team to identify excess inventory factors and enhance the forecast model
Solution
- Demand Forecast (Regression Analysis + Seasonality)
Initially forecasted demand using Regression Analysis. The results were not better than the actual demand. Enhanced the excel regression model by incorporating seasonality and trends.
Impact / Result
- Optimized Demand Forecast
Optimized next-day inventories across 18 cities and reduced next-day average inventory losses from 8.75% to 3.95%.
- Model Presentation and Adoption
Prepared presentation and demonstrated model to teams. Model enhancement was successfully adopted after feedback
Skills Developed
Excel Regression, Dairy Sector, Demand Forecast, Team Collaboration, Presentation
Sector
Luxury Footwear Manufacturing, Export
Challenge
Factor in inflation into the costing model for luxury shoes and improve profit margins
Approach
- Cost Model & Supply Chain Analysis
Proactively analyzed costs (Direct / Indirect) and supply-chain associated with the production of luxury shoes.
- World Bank Inflation Data
Determined WB as a source of inflation data
Solution
- Inflation-linked Pricing Model
Built excel model that linked purchase price of raw materials to inflation of the country over a 3 year projection. Model was linked to the World Bank Inflation Dataset.
Impact / Result
- Improved Profit Margin
Tool allowed more effective negotiations with global luxury brands (Zara/Gucci). Profit margin improved upto 3% for longer cycle orders
- Model Presentation
Successfully presented pricing model benefits to management. Model was adopted by firm
Equilibrium Prices
Using Demand and Supply curves determined product Equilibrium Prices.
Skills Developed
Impact of inflation on prices, Supply Chain, Direct and Indirect Costs, Import-Export, Supply-Demand, Equilibrium Price.
Sector
Airport
Challenge
Align ThreeD policies to UN Global Compact principles.
Approach
- Global Compact (GC) Awareness
Raised awareness with ThreeD on GC Awareness
Solution
- Policy alignment with GC Principles
Analyzed and proposed updates to policies relating to the development and diffusion of environmentally friendly technologies (Principle 9), in line with UN Global Compact Principles.
Impact / Result
Increased awareness on GC Principles and actioned on Principle 9
Skills Developed
GC Principles, Persuation, Presentation, Policy
Challenge
Establish collaboration with other MUNs or schools to increase brand visibility
Approach
- Cold-Calling and Collaboration Pitch
Cold-called 20+ MUNs and schools and pitched collaboration benefits with PII MUN
Solution
- MUN Collaboration
Arranged cross-collaboration with Wizards MUN over Instagram. Coordinated collaboration announcement.
Impact / Result
MUN increased brand visibility from increased traffic flow
Skills Developed
Marketing, Collaboration, Brand Recognition, Communication