Anshul Singh, Sr. Finance Executive

Anshul Singh

Sr. Finance Executive

AIRTEL

Location
India
Education
Master's degree, FINANCE
Experience
17 years, 5 Months

Share My Profile

Block User


Work Experience

Total years of experience :17 years, 5 Months

Sr. Finance Executive at AIRTEL
  • India - Gurgaon
  • My current job since February 2015

Handling R2R team General ledger for Africa (Nigeria)
Analyzed All Expense analysis for Accrual on monthly and quarterly basis
Responsible to review and and prepare month-end Schedules & Reports.
Reconciliation GL to Sub ledger and sub ledger to General Ledger
Prepare & Review manual Journal entries and uploading into General Ledger. Provision capitalization, accrual Journal entries.
Maintain Fixed Asset Register and do all Month-End activity, Tracking Budget Expanse, month on month and quarterly. Maintain clearing accounts. Preparing FA to GL, construction in progress to GL, FA to FA on monthly quarterly and yearly basis.
Expert in Data Analysis and maintain critical reconciliation for the company.
Ensuring Process stability and Quality improvement in process & Team. Team is following E2E understanding.
Handling first level escalation of for Fixed Assets and for team member within stipulated time line
Working On R12 ERP and using GL Module, AP & AR module, Fixed Assets module for financial reporting and month End Activity
Handling Nigeria Operational Company for all reporting and Fixed Assets activity, Maintain Fixed Assets for Depreciation, amortization, adjustment, retirement & transfers.
Report to Finance controller and CFO of the Operational company Nigeria
Conducting training to our team member time to time and preparing skills build program for Airtel. Also having team handling experience and responsible to Sr. Manager.
Good user of excel and prepare a Macro for different activity and make the work smoother work.
Financial Reporting
Reporting variously on various intervals for:
Balance sheet finalization and send to higher level management (Onshore).
Trends and variance analysis and providing insightful commentary for each and every account of profit & loss account & balance Sheet to explain MTD, QTD, YTD variance including resolutions of discrepancies and action plans to key finance and business contacts
Running and submitting balance sheet controls run periodically during close period

Process Developer at GENPACT
  • India - Gurgaon
  • October 2013 to February 2015

Handling R2R (Record to Report), General Ledger & Financial Reporting profile in Fixed Asset Domain for E*TRADE Financials for securities& clearing operation companies (Corporate Business). Financial reporting
Direct reporting to Onshore Director Finance and Sr. Managers of Finance E*Trade for different activities on daily basis.
Managing client relationship and handle first level escalation. Also having team handling experience and responsible to Manager
Proactively seeking client feedback to improve service level standards
Providing training to new resources hired in team.
Using Oracle 12R ERP (including journal entries uploading rights) and other subsystems supporting Corporate business (i.e. ADP, Discoverer etc.) of the E*TRADE Financials group & working extensively on MS-Excel & other business tools Akritiv, Oracle, Discoverer .
Using Fixed Asset sub-ledgers for uploading and tracking all Fixed Assets assets (for depreciation, amortization, adjustments, retirements & transfers).
Handling other domains as an extra responsibilities like:- Marketing & Accounts Receivables.
Conducting and participating into Skills build program and training.


Other initiatives and work achievements
Efficient use of resources leading to reduction of monthly cost & expenses.
Continuously innovating with the focus to improve the process - enhance effectiveness and value add. Given various process improvements & automations currently working on various special projects (Retirement Template, Monthly reoccurring JEs through prepaid system, Paper less activity of Invoice package).
Lean Certified from Genpact.
Effective documentation including SOPs and improve the quality of documents.
Maintain Monthly trackers.

Accountant at C.P. ARORA CONSTRUCTION PVT. LTD.
  • India - Delhi
  • April 2009 to July 2011

Handling Head office accounts, Audit of Branch.
Coordinating between branch and Head Office to maintain the accounts.
Bank Reconciliation sub ledger reconciliation with General Ledger.
Preparing Expense analysis of Branch on monthly and Quarterly basis.

Reporting variously on various intervals for Tax reconciliation and Tax vs Corporate analysis as per STATE, FED & AMT.Balance sheet to higher level management (Onshore).
Trends and variance analysis and providing insightful commentary for each and every account of profit & loss account & balance Sheet to explain MTD, QTD, YTD variance including resolutions of discrepancies and action plans to key finance and business contacts
Running and submitting balance sheet controls run periodically during close period.
Closure of books of accounts monthly and Tax books on Quarterly basis.

Duty Manager at ESSAR RETAIL LTD.
  • India - Delhi
  • January 2007 to April 2009

Maintain inventory requirement,
Daily audit of stock. Order stock/inventory as per sales requirement.
Maintain monthly expense for store and handling sales staff.
Preparing plan and strategies for achieving monthly target.
Provide training to staff about customer handling, customer relation and satisfaction and also conductive small session for skill build program.
Maintain & preparing records and reports for auditing purpose.

Account Executive at R. Mehra & Co.
  • India - Delhi
  • August 2004 to September 2006

Preparing & Filling Sale tax & VAT return for multiple companies on monthly, quarterly and yearly basis.
Bookkeeping for different industries (Manufacture, Pharmaceutical, Services).
Handling Internal Audit & statutory Audit of Govt & Private firms.
Accounting and Reconciling of ledger on behalf of clients using Telly, People soft and SAP.
Filling Income tax return for individual.
Monthly/daily (Sub ledger to GL, Schedule/statement to GL and other) reconciliations for:Accrued and other liabilities, Fixed Assets, Goodwill & Intangibles, Sub-ledger Interface to GL
Preparing and reviewing
accounts and returen and profit and loss analysis quarter over quarter

Education

Master's degree, FINANCE
  • at ALIGARH MUSLIM UNIVERSITY
  • May 2013
Bachelor's degree, COMMERCE
  • at IGNOU
  • June 2008

Specialties & Skills

Accounting
Internal Audit
General Ledger
Microsoft Excel
Fixed Asset Management
Leadership Skill
Interpersonal skill
Result Oriented
Problem Solving Skill
Computer skill Excell expert
Team Building Skill
Good Comunication Skill

Languages

English
Expert
Hindi
Native Speaker
Punjabi
Beginner
Urdu
Beginner

Memberships

ALL INDIA MANAGMENT ASSOCIATION
  • ACTIVE MEMBER
  • September 2012

Training and Certifications

ORACL ASSET MANAGEMENT (Training)
Training Institute:
ORACEL UNIVERRSITY
Date Attended:
November 2015
Duration:
48 hours
ORACLE FA MODULE (Certificate)
Date Attended:
November 2015
Valid Until:
January 9999
US RECONCILATION (Certificate)
Date Attended:
March 2014
Valid Until:
January 9999
ORACLE 12i (Training)
Training Institute:
ORACLE PARTNER
Date Attended:
October 2013
Duration:
120 hours
LEAN (Certificate)
Date Attended:
December 2014
Valid Until:
January 9999
LEAN (Training)
Training Institute:
GENPACT
Date Attended:
November 2014
Duration:
36 hours
TELLAY (Training)
Training Institute:
F TECH
Date Attended:
February 2006
Duration:
36 hours