Shobhit Agrawal
Gurugram
Summary
Analytical finance professional with expertise in valuation, financial modeling, and data-driven decision-making. Achievements include clearing CFA Level II and earning a B.Tech from IIT Bombay. Proven experience in strategy and growth at OYO, alongside a background in financial analysis and cost modeling within the solar energy sector. Proficient in Python and SQL, with a strong focus on equity research, Capital modelling and investment analysis.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Asset Manager
Oyo Vacation Homes
Gurugram
12.2024 - Current
- Spearheaded financial modeling to enhance forecast accuracy by 18% across over 300 properties.
- Identified €6-7 million annual opportunities through profitability analysis of ADR, occupancy, CAC, and RevPAR.
- Collaborated with product and operations teams, achieving 7% quarter-over-quarter revenue growth via strategic pricing.
- Executed cohort-level analyses to optimise OTA mix and cost structure while refining profit and loss statements.
Research Associate
Arga Investments
Chennai
07.2022 - 12.2022
- Conducted comprehensive research on global solar PV value chain, analyzing manufacturing economics and technology transitions across China, India, and Southeast Asia.
- Developed detailed cost models for polysilicon, ingots, wafers, cells, and modules to project industry cost curves and pricing trajectories.
- Evaluated key sector drivers such as policy incentives and supply-demand cycles to inform macro-level investment theses.
- Compiled extensive historical cost datasets, forecasting 15-20% cost reduction by 2030 to support renewable energy investments.
- Contributed to investment memos through industry benchmarking and comparative technology assessment.
Education
Dual Degree(B.Tech + M.Tech) - Mechanical Engineering
IIT Bombay
Mumbai06.2022
Skills
- Valuation and Modelling: DCF, comparable, sensitivity analysis
- Equity and sector research: Fundamental analysis, Industry benchmarking
- Quantitative tools: Python, SQL, Advanced Excel, Power BI
- Business and strategy: Market sizing, forecasting, P&L analysis
- Finance knowledge: Corporate finance, asset valuation, portfolio concepts
Certification
Chartered Financial Analyst (CFA) Level 2, 10/01/25.
Hobbies and Interests
- Financial modeling
- Mathematics
- Artificial intelligence
- Data analysis
- History
- Economics
Projects
- Equity research model: built a full three-statement model and DCF valuation for a listed NBFC, and delivered a 12-page research report with a BUY recommendation based on intrinsic undervaluation
- Python trading analytics: Created a backtesting engine for factor-based strategies (momentum, SMA) using Python
Timeline
Asset Manager
Oyo Vacation Homes
12.2024 - Current
Research Associate
Arga Investments
07.2022 - 12.2022
Dual Degree(B.Tech + M.Tech) - Mechanical Engineering
IIT Bombay