Chirag Sharma

Chirag Sharma

Data Migration Analyst

Followers of Chirag Sharma968 followers
location of Chirag SharmaMumbai, Maharashtra, India

Connect with Chirag Sharma to Send Message

Connect

Connect with Chirag Sharma to Send Message

Connect
  • Timeline

  • About me

    Manager Cost Analyst at Bharti Airtel

  • Education

    • Sheila Raheja School of Business Management and Research

      2021 - 2023
      Master of Business Administration - MBA Finance Semester 1: A+ Semester 2: O Semester 3: A+ Semester 4: A+
    • St.francis high school

      2014 - 2015
      S.S.C
    • Prahladrai Dalmia Lions College of Commerce and Economics Sundar Nagar S V Road Malad West Mumbai 400 064

      2016 - 2017
      H.S.C
    • Prahladrai Dalmia Lions College of Commerce and Economics Sundar Nagar S V Road Malad West Mumbai 400 064

      2017 - 2020
      Bachelor of Banking and Insurance
  • Experience

    • OYO

      Aug 2021 - Nov 2021
      Data Migration Analyst

      1) Data migration from google sheet to website.2) Working closely with revenue team regarding pricing comparison.3) Train & QC for new intern.

    • Worldline

      May 2022 - Jun 2022
      Summer Finance Intern

      1) Revenue Forecasting for the year 20222) Profit and loss projections for the next five years.3) Balance sheet forecasting for the next five years.4) Cash Flow movement5) Comparative balance sheets were prepared.6) CostAnalysis7) Profit &Loss Ratio Analysis8) BalanceSheet Ratio Analysis

    • Insync Analytics Pvt. Ltd

      Mar 2023 - Aug 2023
      Financial Analyst

      1) Examining the financial and operational data/statements of the companies in relation to various industries.2) Creating basic & complicated models to assess financial results and value businesses.3) Analysis of the financial statements (Income Statement, Balance Sheet, Cash Flow, DCF, and Model Summary).

    • Airtel

      Aug 2023 - now

      • Opex Productivity: Analyzing cost trends and identifying opportunities to reduce waste, analyzing Network Rent, Energy Cost Analysis and Control.• Business Analytics: Analysis and reports on business performance by means of: Monthly performance & variance analysis in Opex trends.• Process Excellence: Lead and conduct process audits for SCM and logistics and identify and drive process improvements and lead a culture of continuous improvement.• Store R&M cost deep dive analysis w.r.t painting, electrical work etc.• Drive & Validation of >75K Project & WOW.• Analysis on Site wise performance.• Analysis on Dead rent to avoid billing on Locked & Dismantled Sites.• Analysis on Relocated and its principal sites to prevent dual billing.• Detailed analysis on Promoters and XFE productivity.• AO Hygine Analysis• Maintaing P&L, Productivity and decay for ILMS.• Ensuring the successful implementation of the model by managing the site acquisition team's P&L and productivity. Show less • Opex Productivity: Analyzing cost trends and identifying opportunities to reduce waste, analyzing Network Rent, Energy Cost Analysis and Control.• Business Analytics: Analysis and reports on business performance by means of: Monthly performance & variance analysis in Opex trends.• Process Excellence: Lead and conduct process audits for SCM and logistics and identify and drive process improvements and lead a culture of continuous improvement.• Store R&M cost deep dive analysis w.r.t painting, electrical work etc.• Drive & Validation of >75K Project & WOW.• Analysis on Site wise performance.• Analysis on Dead rent to avoid billing on Locked & Dismantled Sites.• Analysis on Relocated and its principal sites to prevent dual billing.• Detailed analysis on Promoters and XFE productivity.• AO Hygine Analysis• Maintaing P&L, Productivity and decay for ILMS.• Ensuring the successful implementation of the model by managing the site acquisition team's P&L and productivity. Show less

      • Manager Cost Analyst

        Jun 2024 - now
      • Assistant Manager Cost Analyst

        Aug 2023 - Jun 2024
  • Licenses & Certifications

    • Company Valuation & Financial Modelling

      Udemy
      Oct 2022
      View certificate certificate
    • Excel Fundamentals - Formulas for Finance

      Corporate Finance Institute® (CFI)
      May 2022
      View certificate certificate
    • Virtual Experience Program Participant

      J.P. Morgan
      Apr 2022
      View certificate certificate
    • Virtual Experience Program Participant

      J.P. Morgan
      Jun 2022
      View certificate certificate
    • NISM Certification for participating in the Nation-Wide Financial Market Quiz

      National Institute of Securities Markets (NISM)