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
Documentation skills
Negotiation
Bookkeeping
Data trending
Industry analysis experience
Preparing models
SAP , Oracle , Udaan , DMS Software
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 -