I am a BE(MECH),MBA(FINANCE), CMA(FINALIST) professional with 12 years of experience having a techno-commercial qualification with strong analytical and Interpersonal Skills.
I am skilled in Creating Scenarios in a model using OFFSET, Data Validation, Macros,Pivot Tables ,Slicers ,Index Match, SUMIFS, COUNTIFS, AVERAGEIFS, Named Range, LOOKUPS, in Excel. My Skills include creation of Revenue Drivers ,Cost Drivers ,Creating Automated Debt Schedules ,Dynamic Cash Sweep
Creating P&L, BS & CF Forecasts,Valuation, Sensitivity Analysis etc.
1)Part of all major Committees like NIRF,NAAC,AICTE,NBA,NPTEL.
2)Hands on Experience on Financial Modelling, MS Office etc.
3) Acts as Pinpoint of Industry-Institute Interaction.
4) Teaching Finance Subjects to Engineering and MBA .
1) Was a part of Setting Costing System
2) Visiting Vendors of the company to catch the details of labor charges.
and Other Costs.
3) Recording the Loading, unloading time &set up time of each process
to extract the details required for doing costing. etc.
4) Participating in the stock Audit of the different Plants.
1)Looking after the Production and Quality Aspects
2) Making Timely Delivery Schedules, production plans, doing final inspection of Product, maintaining Inventory levels, minimizing Losses.
Creating Proforma Statements NAV Goodwill Calculations Deal Structuring Ownership Dilution Analysis Calculation of Proforma EPS EPS Accretion/Dilution AnalysisDynamic debt schedule Cash Sweep Toggle Debt Infusion Equity Infusion Creating Proforma IS, BS and CF Statements Forecasts Credit Statistics IRR and Cash Returns Analysis Scenario ManagerCreating Company Profile Creating sector analysis Research Tips and Tricks Creating formatted backupsperating Margin Method Return on Capital Method Operating lease concepts Calculation of lease commitment life Adjustment to Debt, operating income Triangulation of ROC, Reinvestment Rate and Growth Laying a 2 stage DCF model with operating lease adjustments
1.Hands on Experience in Excel ,PowerPoint and Word while working Cost Accountants Firm CMA Pravin Mohani and Company on Projects of Steel Billets and Bars Costing and Thermal Power Station Costing for Approximately 2 Months.
2.Working as a Subject Matter Expert for Finance Domain in Chegg Inc.U.S based MNC on Part time basis, where solutions in Word Format have to be submitted to the Chegg based on the fixed timelines for subjects like Financial Management, Managerial Economics, Financial Accounting etc.
3.Runs my own YouTube Channel for the Subject of “Operations Management” .This Channel was specifically created considering reaching the wider audience which is not specifically possible in the Offline Mode. This is done in Pre-Pandemic Time.
4. Part of Network Marketing Team for a famous FMCG Brand were work of Customer Relationship Management and Business Development was carried out in Part Time Basis without disturbing the job.
5.Completed Courses like Financial Modelling in which the Financial Analysis of any company is done right from scratch based on the Annual Reports of the last 5 to 6 years .This can be done for companies of different Sectors like Pharma, Automotive, Software etc.
6.Was Working as a Visiting Faculty for almost 3 years for same subject “Operations Management” at Inter Level to The Institute of Cost Accountants of India Aurangabad Chapter at Intermediate Level.
7.Done Internship Projects as part of MBA Program in Reputed Companies Like Endurance Technologies Limited and Raymond’s Limited Mumbai focusing on Material Costing and Textile Costing and got Exposure to SAP -MIRO,MIGO module at time of internship.