Summary
Overview
Work History
Education
Skills
Timeline
Generic
Himanshu Gupta

Himanshu Gupta

Chartered Accountants
Gurgaon,Haryana

Summary

Qualified Chartered Accountant with more than 17 years of experience in managing finance & accounts encompassing financial reporting (Ind-AS & IGAAP financial), P&L variance analysis, AOP, Regulatory Finance reporting, Monthly MIS, Account's receivables and Account's payables in diverse roles across the organizational hierarchy. Managing Statutory audit with Big 5 consulting firms and managing Internal audit, CAG audit and departmental audit (DOT audit-Special audit). A versatile communicator and liaising experience of government bodies for ensuring statutory compliances. Well versed with computers and possess technical skills in ERP Systems like SAP and Tally.

Overview

17
17
years of professional experience
16
16

Years of post-qualification

Work History

Assistant General Manager (Financial Controller)

SequelOne Solutions Private Limited
Gurgaon
06.2022 - Current

The Company is providing “SaaS” as service, Staffing services, payroll services and compliances services in HR-tech domain with its brand name “HONO” in India, Dubai, Indonesia and Singapore
Working as financial controller
• Completeness of monthly closing on timely manner with all the GL review
• Preparation and finalisation of monthly and quarterly financial statements
• Financial review of subsidiary and branch (outside India-Singapore, Indonesia and branch in Dubai)
• Responsible for smoothly and timely completion of Statutory Audit
• Looking after ODI Investment and related compliance
• Looking after taxation related compliance
• Preparation of AOP
• Coordination with ISO and SOC audit
• Payroll Activity: Validation of Inhouse payroll (Company on roll employee's payroll) and their accounting entry
• Preparation of yearly and quarterly payroll budget Vs actual analysis.

Senior Lead

Sistema Smart Technologies Limited
Gurgaon
09.2010 - 05.2022

The Company is Russian MNC having 99% by Russian (bifurcated into- 76% stake of Sistema PJSFC (Holding Company) and 23% stake of Russian Federation (the Russian Government))
The Company was in business of providing telecommunication services in India with its brand name “MTS”
Role and Responsibility
Finance Function:

o Conversion of Ind-As financial from IGAAP financial in 2017, as per the MCA guidelines
o Finalisation of Standalone and Consolidated financial statement
o Preparation and finalisation of monthly financial statements and MIS for SISTEMA review
o Prepared Carveout Financials for demerged telecom entity
o Managing audits and their query: Statutory audits (with big 4 audit firms), AGR audit (with big 4 audit firms), internal audit, CAG audit and departmental audit
o Assisting in and providing details for GST audit and Tax Audit
o Responsible for timely and accurately filling XBRL with MCA of the Company and other group Companies
o Review and closure of post-paid collections and their reconciliation with TC, SAP and Utiba report (in telecom entity)
o Coordinate for CMS related issues for cheque/cash pick up
o Closely looked after Bank reconciliation and Fixed deposit Schedule and their calculation
Regulatory Finance and Departmental audit:
o Representation to Department of Telecommunication (DoT) requesting clarification about AGR
o Submission replies on behalf of finance on the consultation paper issued by TRAI
o Finalisation of Quarterly, yearly AGR calculation and their Payment
o Coordination with department (DOT) for finalisation of AGR assessment
o Coordination with Legal team and lawyer's for filing of court cases related to AGR
o Coordinate with CAG auditors for their audit and requirement
o Preparation of reply for CAG auditors and their Submission

Key Achievement:
o Implementation of E collection account from virtual account in ICICI Bank
o Received various clarification of deduction verification from DOT HQ for claiming of deduction.

Assistant Manager

ATC Telecom Infrastructure Private Limited, erstwhile Viom networks ltd
Jaipur
02.2008 - 09.2010

ATC Telecom Infrastructure Private Limited is providing passive infrastructure services to telecom operators
Roles and Responsibilities (Rajasthan Circle)
o Prepared Circle's Profit & Loss account and their MIS for management review
o Actively Involved in validation of input data and energy billing to minimize billing errors to customers
o Validation of Invoices/ Debit notes/ Credit notes received from corporate office for IP fees and power & Fuel & submit to customers and followed up for payment thereof.
o Validated site power & fuel expenses on the basis of consumption & Load and Closely deal with Operational team (O&M) for resolution of operational issue
o Processing of expense related site rental and employee claims
o Involved in and support to corporate office for capitalisation of sites (Rajasthan circle) based on RFI dates and Keep records of Site Return Material (SRM) and Assets Transfer Note (ATN) and updatation of the same in FAR
o Successfully completion of physical verification of sites of Rajasthan circle with third party
o Physical verification on monthly basis of warehouses with commercial team
o Responsible for Insurance claim of Rajasthan in connection with sites and their settlement
o Responsible for preparation and timely submission of VAT, WCT and other taxation returns of Rajasthan Service area and their payments
Key Achievement:
o Successfully processed site rental for the Company (India level) in 2008 when the business transferred from Tata Teleservices to ATC (formerly WTTIL)
o Successful completed site verification (for Fixed Assets) of Rajasthan Circle.

Senior Executive

Shyam Telelink Limited
Jaipur
12.2006 - 01.2008
  • Roles and Responsibilities Accounting/Finance:
    • Preparation of Invoices/ debit notes for Leaseline charges, IRU dark fibre and Site sharing (Infrastructure provisioning fee and fuel & electricity) and followed up for their payment
    • Finalisation of insurance policies related with Fixed Assets, Cash, Goods in Transit & In Warehouse
    • Coordinated with insurance company and their surveyor for insurance claim
    • Prepared MIS related to IP fees, power & fuel, leaseline details (New connection & disconnection) for review and quarterly reconciliation with network team
    • Issued bank guarantees, commercial paper and LC.

Audit Assistant

Mittal Garg Gupta & Co. Chartered Firm
Delhi
07.2001 - 11.2006

Virmani, Roy & Kutty. Chartered firm, Delhi

• Performed auditing work in accordance with auditing standards and principles.
• Worked audit engagements for industries in engineering, manufacturing, non-profit and human resources.
• Established audit and internal control procedures and recommended process improvements to address issues.
• Supported litigation through examination of canceled checks, invoices and bank records.

Assignment Handled

• Bharat Sanchar Nigam Limited (Statutory Audit- NTR & NTP region), Westfalia Separators India Pvt. Ltd., Helpage India, Allied photographs Ltd., Canfin Homes Ltd., Janta Travels Pvt. Ltd. (Internal Audit), India railways Womem Welfare Organization.
• Undertaken the various stock audits viz., Torrent Pharmaceuticals Ltd., Dr. Reddy Pharmaceuticals Ltd., Shnoffy Synthelabo Ltd., Zydus Cadila Pharmaceuticals, Nokia India Pvt. Ltd., Citi Corp. India Limited.

Education

Chartered Accountant -

Institute of Chartered Accountant of India
04.2001 - 05.2007

Bachelor of commerce -

University of Rajasthan
Sikar, Rajasthan, India
06.1998 - 04.2001

Skills

Financial Reporting (IGAAP & Ind-AS)

undefined

Timeline

Assistant General Manager (Financial Controller)

SequelOne Solutions Private Limited
06.2022 - Current

Senior Lead

Sistema Smart Technologies Limited
09.2010 - 05.2022

Assistant Manager

ATC Telecom Infrastructure Private Limited, erstwhile Viom networks ltd
02.2008 - 09.2010

Senior Executive

Shyam Telelink Limited
12.2006 - 01.2008

Audit Assistant

Mittal Garg Gupta & Co. Chartered Firm
07.2001 - 11.2006

Chartered Accountant -

Institute of Chartered Accountant of India
04.2001 - 05.2007

Bachelor of commerce -

University of Rajasthan
06.1998 - 04.2001
Himanshu GuptaChartered Accountants