CA. Sumit Gupta

CA. Sumit Gupta

Article Assistant

Followers of CA. Sumit Gupta360 followers
location of CA. Sumit GuptaGurgaon, Haryana, India

Connect with CA. Sumit Gupta to Send Message

Connect

Connect with CA. Sumit Gupta to Send Message

Connect
  • Timeline

  • About me

    Manager at PwC | Ex-Airtel | Ex-Deloitte | Ex-Wipro

  • Education

    • Jitesh Vlog

      2006 - 2007
      M.Com. Business Administration, Research Methodology, Income Tax, Statistics, Financial Accounts

      Secured 84%, 74% and 60% marks in Income Tax Law & Accounts, Financial Accounting and Research Methodology respectively in M.Com.

    • Jitesh Vlog

      2002 - 2004
      B.Com Quantitative Analysis, Business Administration and Business Economics

      Secured 79% marks in the Quantitative Analysis and more than 62% marks in Business Administration and Business Economics in B.Com.

    • The Institute of Chartered Accountants of India

      2003 - 2011
      CA Advance A/Cs, Auditing, Direct Taxes, Indirect Taxes, Cost Management, Management & Financial A/Cs

      Secured 67% marks in Indirect Tax in CA Final and 64% marks in Income Tax in C.A.(PE-II).

  • Experience

    • M/s S.P.Chopra & Co. (Chartered Accountants)

      Mar 2006 - Jun 2006
      Article Assistant

      Responsibility of conducting the various types of audit like Statutory Audit, Internal Audit, Stock Audit and filling & filing of Income Tax Returns, Sales Tax Returns at various levels e.g. individuals and firms. Preparation of PAN Forms of individuals and firms.

    • M/s Piyush Vishwa & Co

      Jul 2006 - Mar 2009
      Article Assistant

      - Review the Stores area, Purchase and Sales procedure. - Preparation of PAN Forms of individuals and firms. - Verification of Provision for Expenses and Depreciation Schedules. - Physical verification of Cash during Bank Audit.

    • V. Rohatgi & Co.

      May 2010 - Jan 2011
      Audit Lead

      - Lead the individual teams of around 3 peoples as a team leader.- Responsibility of conducting Internal & Concurrent Audit of banks and collection units of banks. - Reconciliation and verification of Stock of various concerns.- Ensuring compliance of applicable Accounting Standards and Auditing Assurance Standards in Financial Statements.

    • Radico Khaitan Ltd

      Aug 2011 - Jul 2012
      Junior Manager - Finance & Accounts

      -- Preparation and Presentation of MIS and monthly accounting updates to Top Management & Board of Directors.-- As an end-user, have sound knowledge of SAP.-- Activity Based Costing for operational processes and highlighted the cost saving areas to management.-- Comparative and trend analysis of OPEX and Capital Projects, analyzing the variances and communicate to all channel heads.-- Actively participated in budgeting activity and variance analysis.-- Responsibility of Bank, Stock, AP and AR Reconciliations.-- Preparation of Excise, Service Tax and VAT Returns.-- Preparation and processing of Purchase Orders, Goods Receipts and Invoice Receipts of Raw Material & Capital Goods.-- Monitoring Cash Management & circulation of Cash Certificate.-- Arranging and issuing all C, F & VAT Forms.-- Responsibility of discussions with Internal Audit, Statutory Audit and Excise Audit Teams. Show less

    • Wipro

      Jul 2012 - Aug 2014
      Associate Consultant

      - As a Finance Lead, experience in support activities of Oracle Financials – GL, AP, AR, CM, FA, PA & I-Expense modules.- Sound knowledge of P2P, O2C & HRMS module.- Application Enhancement and Support for GL, AP & AR modules.- Actively involved in several customizations and setups in ERP.- Handled period end closing activities of GL, AP, AR & PA modules.- Provided training & conducted sessions as per business requirements.- Business process analysis and requirement gathering for new customization, report development.- Sound knowledge of SQL, PL/SQL language (Toad).- Working knowledge of Oracle Financials for India (earlier known as India Localization)- Conducted various Change Request Process (CRP), System Implementation Testing (SIT) & User Acceptance Test (UAT).- End to end testing the functionality of new enhancements for new entitles in R12.- Prepared BP080 documents for implementation of GL, AP & AR.- Giving the overview on functional modules to Technical team.- Successfully completed Business Transition Activity.- Analysis of the current system by interacting with business and various cross functional teams.- Working knowledge of Web-ADI, Data Loader, Win-SCP and Putty tools to support client activities.- Monitor Interfaces, Scheduled Request (SR) and troubleshoot issues. Show less

    • Deloitte

      Aug 2014 - Jun 2016
      Consultant

      - Responsible for analyzing test scenarios of AP, GL & I-Expense and mapping of them with RICEWs accordingly. - Build working knowledge of SCM Modules like, Purchasing, Inventory, OM and Cost Management - Responsible for standard testing of finance modules like, AP, GL & I-Expense in Release 11i and 12.2.4 - Interacted with client to understand current business process and gathered business requirements accordingly. - Solution design for Customized objects to be migrated from 11i to R12.2.4. - Contribution to the project by providing timely solution of deliverables and commitments. - Through problem solving approach, resolved the issues of period closing in AP and GL. Show less

    • PwC India

      Jun 2016 - Aug 2020
      Senior Consultant

      Oracle Finance Functional Consultant (EBS & Cloud)

    • Airtel

      Sept 2020 - Apr 2022
      Senior Manager
    • PwC India

      Apr 2022 - now
      Manager
  • Licenses & Certifications

    • Oracle Financials Cloud: Payables 2021 Certified Implementation Specialist

      Oracle
      Oct 2021
      View certificate certificate