Experience

Amol Pharmaceuitcals Pvt. Ltd.

• India
• Pharmaceutical Manufacturing
• 1 - 100 Employee

• • Apr 2022 - Present

• • Mar 2020 - May 2022

  •Extract Trial Balance to make Income Statements & Balance Sheets of three US Entity for Analysis & Month Closure. •Involved in all the activities of Financials Closure.•Develop detailed spreadsheets to identify trends. Perform in-depth financial analysis on monthly basis for Management & Important Key Performance Indicators.•Allocations of Revenue & Expenses between Segment Sales for Income Statements on monthly basis for Analysis & to find Segment wise Profits.•Made Direct & Indirect Expense Reports to find the Rate per Tablets/Capsules and Analysis on Monthly.•Making Capex, AP & AR Analysis reports on monthly basis.•Making Weekly Direct Cash Flow Projection of all the three US Entity with Variance Analysis. •Involved in all the activity related to US Audit.•Sales Gross Margin Analysis of Actuals vs Standard Cost on Monthly. Making monthly Sales reports and their Analysis on Customers & Products basis.•Making Excess & Short Inventory Reports as per the Open Sales Order for Managements with Comments on Monthly which can help the Sales & Operations team to complete the Open Sales Order on time.•Making Inventory Ageing Reports and their Analysis on monthly.•WIP Variance Analysis reports (With Reason) on weekly which is impacting the Income Statements. •Making Standard vs Actuals Rate Variance Reports and their Analysis on weekly. •Making BOM Costing on weekly & monthly for Change in standard cost. Made Product Costing on Monthly.•Making Customs & Freight per Tablets/Capsules rate analysis reports on weekly.•Purchase Rate Analysis of Open Purchase Order Reports on weekly. Show less



Kalpataru Limited

• India
• Real Estate
• 700 & Above Employee

• Financial Analyst

  • May 2018 - Mar 2020

  •Worked in CFO Team. •Involved in all Yearly Budget Activity of the Company by Coordination with all the departments for the Reports. •Made Consolidated & Project wise Company Annual Cash Flow Budget of the Company. •Forecasting 5 Years Project wise Long Term Cash Inflow & Out Flow based on expected construction Milestone Date & others expense details with Net Present Value for Analysis given by respective Project Heads for Management Decision on Quarterly & Yearly. •Made Project wise Cash Flow & Revenue projection of Yearly with Price strategy of Company for Board Meeting on Quarterly & Yearly by Coordination with Sales Departments & Project Head with Power Points Slide. •Made Power Points reports with Important KPI respective Projects. •Variance Analysis report of Revenue for Budget Review and their Power Point for Management. •Made Monthly & Yearly Cash Inflow projection of Expected New Sales based on expected construction milestone date. •Develop tools and reports to help for Analysis which help to find the Cash Inflow of current Customers. •Made Actual vs Budget Quarterly MIS of Indirect Expense and their Analysis Reports. •Made Monthly MIS Actual Cash Flow with variance and their Analysis Reports. •Analysis on a Sales Pricing Strategy for different scheme based on Net Present Value. •Short term Revenue budget for Management. •Made Competitors Analysis Report of Financial Statements, Sales & Upcoming Projects of Company for Management with important Key Performance Indicators in graphs and their Power Point on Quarterly & Annual basis. •Made different MIS report with Graphs on Power Point based on requirement by Management Team. •Perform ad hoc analysis and special projects as requested. Show less



Glenmark Pharma

• Mumbai, Maharashtra, India

• Trainee

  • Jul 2014 - Aug 2016

  •Made Annual Budget Plant wise & consolidated. •Made Operations Profit & Loss, Capex Addition to Block reports of Plant wise & Consolidated. •Made Operations & Capex Cash Flow reports on Monthly. •Made P&L explanation Plants wise Reports of Budget Vs Actuals. •Made & Analyze actuals Plant wise & HO Cost Centre wise Overhead Reports. •Made RM PM Consumption, Overhead Absorption & Variance Analysis Reports. •Coordination with Costing Department for Standard Cost of Products for Annual Budget . •Reports of Products analysis on Fixed & Variable Cost basis. •Prepared Power Point of all the reports of Actuals vs Budget with reason of all the Variance for Managements on Monthly. •Co-ordination with Plant for all the reports & for Making Annual Budget. •Made Consolidated Overseas MIS Reports of all Plants. Show less