Headline

Financial Analyst | Financial Modeling & Portfolio Analysis | DCF Valuation | Advanced Excel (VBA, MMULT) • SQL • Power BI | BBE Graduate | Seeking Finance Roles

About

Business Economics graduate with hands-on financial modeling and portfolio analysis experience. I specialize in DCF valuation, risk-return analysis and Excel-based quantitative modeling to support investment decisions. 🎯 KEY PROJECTS Project 1: Titan Company DCF Valuation Model Built comprehensive 5-year DCF model to determine intrinsic value using revenue forecasting, EBITDA projections, free cash flow calculations, and WACC (12.13%). Conducted scenario analysis (Base/Bull/Bear cases), sensitivity analysis on key value drivers, and comparable company analysis across 5 jewellery industry peers to derive investment recommendation. Project 2: Stock Portfolio Analysis Dashboard Analyzed 5-stock portfolio (HDFC Bank, Infosys, Reliance, Asian Paints, Maruti Suzuki) using 1 year of NSE daily data and achieved 36% volatility reduction through cross-sector diversification. Identified Maruti Suzuki as optimal investment with 21.50% return and Sharpe ratio of 1.06. Adjusted HDFC Bank prices for 1:1 bonus share issue to ensure data accuracy, demonstrating attention to corporate actions. 💼 PROFESSIONAL EXPERIENCE During my 13-month tenure at Marquee Equity, I supported talent acquisition for entry-level analyst positions, which gave me exposure to the technical competencies and skill requirements valued in financial services. This experience sparked my interest in financial analysis and motivated me to build the projects above. 🔧 TECHNICAL SKILLS Financial Analysis: DCF Valuation, Portfolio Analysis, Risk-Return Analysis, WACC Calculation, Scenario & Sensitivity Analysis, Financial Modeling & Forecasting Excel Proficiency: Advanced functions (VBA, MMULT, INDEX-MATCH, Pivot Tables, Macros), Variance-Covariance Matrix calculations, Statistical analysis Tools & Languages: SQL, Power BI, Statistical Analysis (Business Statistics, Econometrics) 🎯 WHAT I'M SEEKING Financial Analyst, Equity Research Analyst, Investment Analyst, or Portfolio Analyst roles where I can apply quantitative analysis, financial modeling, and risk assessment skills to support investment decisions. I'm based in Delhi NCR, open to remote work, and willing to relocate for the right opportunity. 📊 CURRENTLY Building my finance knowledge through hands-on projects and posting insights on LinkedIn 3x per week. Always eager to learn and connect with finance professionals. Let's connect! Open to discussions about finance, markets, and opportunities.

Location

Greater Delhi Area

Work experience

Investment Banking Fellow at Marquee Fellowship Program, Sep 2023 - Aug 2024 · 1 yr, - Supported talent acquisition and recruitment operations for entry-level analyst positions in investment banking environment, gaining direct exposure to technical competencies and skill requirements valued in financial services. - Screened and evaluated 40+ candidates via LinkedIn and internal ATS tools for analyst and associate positions across financial services functions, developing in-depth understanding of technical skills required in finance roles (financial modeling, DCF valuation, Excel proficiency, portfolio analysis) - Coordinated 20+ interviews with hiring managers across multiple departments; managed end-to-end recruitment workflow from initial candidate sourcing through final offer stage - Successfully onboarded 8 new hires while reducing average hiring cycle time by 10% through process improvements, streamlined communication, and efficient candidate management systems - Gained exposure to investment banking operations, analyst competencies, and financial services industry standards through daily interaction with finance professionals, which sparked my interest in transitioning from recruitment to financial analysis career path - This experience provided me with unique insight into what financial analysts actually do - the technical skills they use, the problems they solve, and the analytical frameworks they apply - which motivated me to build my own DCF valuation and portfolio analysis projects to develop those same capabilities.

Editorial Head at ForBES- Department of business economics, Aug 2023 - Jul 2024 · 1 yr, New Delhi, Delhi, India, - Led 6-member editorial team to create finance and business economics content for the society, developing leadership and content management skills. - Coordinated team assignments and delegated responsibilities to deliver 20+ high-engagement posts, driving reach to 300+ students across LinkedIn and social channels with 40% increase in average engagement - Developed content strategies and editorial plans focused on business economics and finance topics for student audience - Edited and proofread articles, scripts, captions, and reports to enhance publication quality and maintain consistent brand voice

Education

B.A. (Hons.) Business Economics, Business/Managerial Economics, Shivaji College

Senior Secondary Education, Business/Commerce, General, Sarvodaya Co-Ed Vidyalaya B4 Paschim Vihar