Summary
Overview
Work History
Education
Skills
Timeline
Generic

Shilpa Gupta

Financial Analyst
Gurgaon

Summary

Highly motivated and goal-driven Financial Analyst skilled in collecting, monitoring and studying data to analyze financial status and recommend business strategy. Experienced in qualitative and quantitative analysis, contract management and forecasting. Tech-savvy in use of spreadsheets, accounting and financial management software.

Overview

8
8
years of professional experience
9
9
years of post-secondary education

Work History

Financial Analyst

Volvo Eicher Commercial Vehicles
Gurgaon
12.2018 - Current
  • Promoted successful investment plans with well-organized and smooth presentations.
  • Managing PAN India which includes HD , LMD & BUS .
  • Reviewed and analyzed project spending throughout project life cycle.
  • Direct reporting to the Head of Department .
  • Zero day closure of books every month .
  • Finalize all agreements with financiers like Loss pool agreement , preferred financier agreement , MOU , Etc.
  • Analysis of Data on PAN India basis i.e. Market share of financiers, Subvention processing , pipeline tracking , loss due to finance tracking, CF Gap analysis ,Conversion ratio , Etc.
  • Prepare all presentation for FMT headed by CEO and EMT Members.
  • Reviewed monthly requisitions for accuracy and completeness, reconciled transactions and determined payment approval statuses.
  • Monitored and analyzed financial, statistical and operational data trends.

Senior Finance Executive

Bharti Airtel
Gurgaon
08.2014 - 12.2018
  • Ensuring all statutory guidelines of DOT
  • Handling internal audit, Quarter audit and financial audit
  • Communicated with clients concerning outstanding payments and arranged for rectification.
  • Prepare Goods and service tax reconciliations and its return
  • Sharing payment forecast with the treasury team .
  • Resolution for disputes arising on account of Minutes of usages
  • Service Tax Reco Schedule, AR GL Reconciliation .
  • Bank reconciliation statement
  • Reconciled and confirmed invoices with payments and purchase orders, verifying details for accuracy and effortlessly handling critical datasets and quantities.
  • Disbursed and processed payables, verifying TDS and GST compliance and other important documentation.

Education

Qualified Company Secretary -

Qualified Company Secretary
Gurgaon, HR
04.2001 -

LLB -

Agra University
Mathura, UP
07.2015 - 06.2018

MCOM -

IGNOU
Delhi, DL
06.2013 - 06.2015

Bcom -

Delhi University
Delhi, DL
06.2010 - 06.2013

High School Diploma -

CBSC
Gurgaon, HR
04.2009 - 03.2010

Skills

    Excellent attention to detail

undefined

Timeline

Financial Analyst

Volvo Eicher Commercial Vehicles
12.2018 - Current

LLB -

Agra University
07.2015 - 06.2018

Senior Finance Executive

Bharti Airtel
08.2014 - 12.2018

MCOM -

IGNOU
06.2013 - 06.2015

Bcom -

Delhi University
06.2010 - 06.2013

High School Diploma -

CBSC
04.2009 - 03.2010

Qualified Company Secretary -

Qualified Company Secretary
04.2001 -
Shilpa GuptaFinancial Analyst