Siddharth Gurav

Mumbai, Maharashtra

About Siddharth Gurav:

Immediate Joinee.

Experienced professional with total 2+ years of experience in financial domains. By qualification an Economics graduate, MBA (Finance) with multiple certifications. Currently worked with Renewable energy sector as a Finance Executive. In past I worked with Indian’s leading Credit rating agency CRISIL as a Research Analyst, also I have completed 2 internships with leading stock brokering firms in Research, for a cumulative period of 8 months.

Experience

Jan. 2020 – Oct. 2020 (10 months)
Morgan Stanley Group Co. (Continuum Green Energy Pvt. Ltd.), Mumbai
Executive - Finance | MIS & Data Management, Modeling and Advance Excel

• Functional Area : MIS & Data Management | Modeling & Budgeting | Fixed Income / Credit Analysis & Rating | Project Finance | Financial Planning and Analysis
• Excel modeling & Analysis : Building models for our various operating projects and foresting business cost & revenue items, Data & MIS, Pivot tables, V-Lookup, Hlookup, Data validation, Ifs, Conditional formatting, Charts and Tables etc.
• Analyzing the business KPIs (PLF, P90 & P75, generation & grids availability).
• Maintain, forecast & analyze key ratios (DSCR, ICR, DSRA, FACR, COD, ATR etc.) for group companies and various project
• Research : Research and analysis on the Indian Power sector - Conventional & Renewable Sources, tariffs and power biddings.
• Strategy : Closing work with CEO, CFO & VP for execution of corporate strategy.
• Credit Rating : Handling Credit rating assignments of our various wind & solar projects of varying sizes and help credit rating agency preparing credit reports and rating rationale.

Aug. 2018 - Nov. 2019 (1 Year & 4 months)
CRISIL Ltd (An S&P Global Company), Mumbai
Research Analyst – Client Analytics team | Advance Excel | Quantitative Anaysis

• Functional area :- Excel Modeling & Graphical analysis | Budgeting & forecasting |
Industry/Market Research | Macro Economic & Strategy analysis.
• Expertise in analytical reporting using Advanced Excel features i.e. Pivot tables, VLookup, H-lookup, Data validation, Ifs, Conditional formatting, Template/Excel automation, other formulas and shortcut keys etc.
• Macro-Economic analysis :- CPI,IIP, WPI, 8 Core industry Index, GDP & GVA, Fiscal deficit, Trade deficit, FII & DII Flow, Money Market instrument etc.
• Report writing :- Analysis summary, business KPI & financial KPI, current trend, sector & market share reports. Also use Bloomberg and Reuters
• Market Strategy & Industry research :- Also carryout Detailed Market Research across Financial Product (Index, Equities, Fixed Income/ Credit, Bonds, Currency and Commodities etc.) for Global IBs, primary and secondary research.
• Estimating the Market share/size of the Investment bank and benchmarking them with their peer performance and rank accordingly.
• Analysis helps the IBs to understand their performance in financial market, and identifying business opportunity, formation of strategy & focus area.