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
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
- 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
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.
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
Prepared 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.
Model Presentation: Successfully presented pricing model benefit to management. Model was adopted by firm
Impact
Tool allowed more effective negotiations with global luxury brands (Zara/Gucci). Profit margin improved upto 3% for longer cycle orders
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
Increased awareness on GC Principles and actioned on Principle 9
Skills: GC Principles, Persuation, Presentation, Policy
No Collections Here
Sort your projects into collections. Click on "Manage Collections" to get started