Summary
Overview
Work History
Education
Skills
Certification
Languages
Hobbies and Interests
Summer Internship Research Project
Academic Projects
Accomplishments
Timeline
Generic

Shubhamkar Mane

Nashik

Summary

A PGDM Student and a Numerically savvy, organized, and determined Financial Analyst Intern known for performance reporting and financial reporting and analysis expertise. Detail-oriented, analytical, and performance-driven.

Overview

1
1
Certification

Work History

Financial Analyst

Lux Industries Ltd.
Kolkata
05.2023 - 06.2023
  • Enhanced Financial Reporting and Analysis for informed MIS decision-making and helped in the improvement of the existing SAP FICO system.
  • Data transformation, analysis, and visualization using SAP FICO, MS Excel, and Power BI for effective communication of Actionable Insights and Financial KPIs with the help of Variance and Sensitivity Analysis.
  • Developed a Segregation Matrix with unique codes of 291 SKUs for amplifying profitability scrutiny at more granular levels
  • Streamlined the process, evaluated financial performance, and provided Actionable Insights
  • Spearheaded the investigation and provided comprehensive reports of the reasons behind the threefold loss in Quarter 2 of FY 2022 - 2023 in the Artimas Branch.

Education

PGDM - Business Design

Welingkar Institute of Management
Mumbai
04-2024

B. Com - Financial Accounting

Savitribai Phule Pune University
08-2021

HSC -

B.Y.K College of Commerce
Nashik
04-2018

SSC -

R.J.E.M School
Nashik
04-2016

Skills

  • Financial Modelling
  • Financial Statement Analysis
  • Problem-Solving
  • Analytical Thinking
  • Business and Data Analysis
  • Design Thinking

Tools

  • SAP FICO (Beginner)
  • MS Excel (Intermediate)
  • Bloomberg Terminal (Beginner)
  • Power Bi (Beginner)
  • MS Office 365 (Beginner)

Certification

  • CA CPT
  • Introduction to Risk Management
  • Introduction to Business Intelligence
  • Fundamentals of Corporate Finance
  • Introduction to Derivatives
  • FP&A (Monthly Cashflow Forecasting) (Pursuing)
  • NISM - Research Analyst (Pursuing)

Languages

Marathi
First Language
English
Advanced (C1)
C1
Hindi
Intermediate (B1)
B1

Hobbies and Interests

  • Chess, Trekking, Cricket, Lawn Tennis

Summer Internship Research Project

Mergers and Acquisitions: Impact and Financial Performance of Public Sector Banks in India:

  • Analyzed the Pre-merger and Post-merger financial performance of the 6 Public Sector Banks using the CAMEL framework.
  • Prepared a Research report and executive summary highlighting the significant changes in banking ratios.
  • Identified the diverse impacts of mergers on the banks involved, using Ratio Analysis and Statistical Analysis.

Academic Projects

Equity Research Report: Samvardhana Motherson

  • Conducted a Fundamental Analysis using a Top-down approach with extensive analysis of the Economy, Industry, Company, and Financials.
  • Calculated value per share using Relative Valuation through Trading Comps. and constructed a Risk assessment module with the use of consulting management frameworks.
  • Report prepared with the extensive use of Bloomberg Terminal, Screener, Moneycontrol, Statista, EMIS, and Annual Reports.

Business Sector Analysis: Life Insurance Sector

  • Analyzed historical trends, competitor analysis, trend analysis, supply chains, and distribution networks, as well as the regulatory environment, the PESTEL, and the advertising agencies in the life insurance sector.
  • Performed primary research to develop strategy canvasses and find the value of parameters and KPIs for life insurance businesses.
  • A comparative study and benchmarking of LIC, SBI Life, HDFC Life, and ICICI Prudential.

Financial Modelling and Relative Valuation: R. K. Swamy Ltd.

  • Financial Statement Analysis, Industry Research, Data Analytics and Screening, Ratio Analysis, and DRHP Analysis of an IMC Company (Filed for IPO).
  • Revenues, EBITDA, and EPS projection for the Company and its Peers through Trading Comps. Valuation and identified the Growth drivers.
  • Calculated EV/EBITDA and P/E Multiples (Forward and Trailing Multiples) for the Company, its peers, and industry Median (EV/EBITDA = 35.84X, P/E = 56.66X).
  • Performed Financial Valuation using Comparable Company Valuation (R. K. Swamy FY-24: Share price - ₹ 398, Enterprise Value - ₹ 2258 Cr.)

Foreign Currency Risk Exposure: Ultratech Cement Ltd.

  • Identified the Transaction, Translation, and Economic Exposure of the cement-producing giant of India.
  • Analyzed the Major Contributors to the operating Exposure faced by the company.
  • Studied the Risk Mitigation strategies (Forwards, Options, Swaps) and commented on plans going forward.

Power BI Dashboard: Financial Reports

  • Developed Power BI reports by translating financial data into insights and highlighting actionable KPIs.

Accomplishments

  • CA CPT PROGRAM CERTIFICATION (122 out of 200)
  • Lawn Tennis: Runner-Up in Divisional Level Sports
  • Competitions: Beat the Market Techkriti'23: Selected and Participated at IIT Kanpur (March 2023)
  • Responsibilities: Runbhoomi Cricket Tournament: Managed the finance team and formulated a budget.

Timeline

Financial Analyst

Lux Industries Ltd.
05.2023 - 06.2023

PGDM - Business Design

Welingkar Institute of Management

B. Com - Financial Accounting

Savitribai Phule Pune University

HSC -

B.Y.K College of Commerce

SSC -

R.J.E.M School
Shubhamkar Mane