Varun Agarwal

Varun Agarwal

Followers of Varun Agarwal432 followers
location of Varun AgarwalBengaluru, Karnataka, India

Connect with Varun Agarwal to Send Message

Connect

Connect with Varun Agarwal to Send Message

Connect
  • Timeline

  • Skills

    Accounting
    Account reconciliation
    Business analysis
    Analysis
    Financial accounting
    Microsoft office
    Bank reconciliation
    Team management
    Financial analysis
    Financial reporting
    Process improvement
    Business process improvement
    Auditing
    Internal controls
    General ledger
    Automation
    Process simplification
    Process automation
    Leadership development
    Change management
  • About me

    Professional with over 12 Years Experience in Continuous Delivery of Process Improvements, Process Automation, Internal Controls and Yellow Belt Certified. Specialties: Technical Skills - VBA Programming in Excel (Macro), Automation, Process Simplification. Business Operation - RoHS/REACH, Project Management, Accounting, Bank Reconciliation, Account Reconciliation. Proud of - Over 500 small and big automations. - Helped to reduce team of 15+ to less than 5 with long term automation. - Implemented automation in Journal Entry template to validate entries, auto selection of approver with tight integration with Outlook used globally. - Preparation of templates which would auto populate numbers from SAP System and Hyperion Reporting Tool for 3-way audit and verification.

  • Education

    • BHS First Grade College, Bangalore University

      2004 - 2007
      Bachelor of Commerce (B.Com.) Commerce Degree

      Bachelors Of Commere

    • J.S.S. Mahavidaypeeth

      1999 - 2002
      SSLC High School
    • Sri Bhagawan Mahaveer Jain College

      2002 - 2004
      PUC Commerce

      Activities and Societies: Professional Multimedia Couse Professional Multimedia Course. Designed several professional websites with video and audio authoring to flash based games.

    • INDIAN INSTITUTE OF HARDWARE TECHNOLOGY LIMITED

      2017 - 2018
      Diploma in Dot Net Computer Programming, Specific Applications A

      Activities and Societies: C#, Dot Net, ASP.NET Registration Number : JYN-1718-1340

  • Experience

    • Tesco Bengaluru

      Jul 2007 - May 2010

      1. Ensure accuracy and completeness of Month End Activities.2. Passing Journal Entries, Prepare Balance Sheet Account Reconciliation, Bank Reconciliation Statements and Clearing Bank Open Items.3. Preparation and Posting of Quarter End Accruals – Income and Expense Accrual, Contributions Accrual.4. Verification and Requisition of remittance of contributions of employees to various third parties in UK.5. Verify and Certify – Contributions Transfer and Pensioner Payment Transfer6. Investigation of gain or loss in stock of UK Stores.7. Identification of issues in stores and suggesting corrective measures.8. Waste Management of entire 3500 UK Stores.9. Assist in the preparation of Report for National Statistics Organization, UK. Show less 1. Ensure accuracy and completeness of Month End Activities.2. Passing Journal Entries, Prepare Balance Sheet Account Reconciliation, Bank Reconciliation Statements and Clearing Bank Open Items.3. Preparation and Posting of Quarter End Accruals – Income and Expense Accrual, Contributions Accrual.4. Verification and Requisition of remittance of contributions of employees to various third parties in UK.5. Verify and Certify – Contributions Transfer and Pensioner Payment Transfer6. Investigation of gain or loss in stock of UK Stores.7. Identification of issues in stores and suggesting corrective measures.8. Waste Management of entire 3500 UK Stores.9. Assist in the preparation of Report for National Statistics Organization, UK. Show less

      • Senior Accounts Executive – Pensions And Payroll Accounting (General Ledger)

        Mar 2010 - May 2010
      • Accounts Executive – Pensions And Payroll Accounting (General Ledger)

        Jul 2007 - Mar 2010
    • Capgemini Invent

      May 2010 - Apr 2013
      Process Lead – Controller (General Ledger)

      1. Lead a team for complete management and execution of Month End Close Activities for a Global Swiss agribusiness client.2. Consistent and Accurate delivery of Month End Activities which includes Journal Processing, Intercompany activity, Sales, Inventory & COGS reporting, GRIR analysis and Hyperion reporting.3. Ensure complete compliance of SoX requirements.4. Performing the complete Hyperion reporting on a monthly basis and reconciliation between SAP and Hyperion. Includes data upload to Hyperion and clearing all the validations and reporting the final balances for Global reporting5. Analysis of GRIR Account and Open PO’s and assisting client with preparation of Goods in Transit accruals.6. Presentation and preparation of Dashboard Metrics.7. Client Management to ensure accuracy and completeness of Month End Activities.8. To ensure Payment Proposal and Invoice Audit is done as per stipulated norms.9. Preparation of Key Accounts Reconciliations and posting of Journals.10. Creation and Execution of Assessment Cycles. Show less

    • HP

      Apr 2013 - now

      1. Developing and implementing data analyses, data collection systems and other strategies.2. Acquiring data from primary or secondary data sources and maintaining databases.3. Identify, analyze, and interpret trends or patterns in complex data sets4. Work with management to prioritize business and information needs5. Locate and define new process improvement opportunities6. Material Compliance (RoHS) of HP Personal System Products such as Notebooks, Desktop, Workstation, All-In-Ones and RPOS.7. Process Automation, Process Simplification and collaboration with several teams such as IT for implementation of new tools, supplier id creation and Business Partner Management Teams.8. World Wide Implementation of Regulations affecting products of HP.9. Development of automation using Microsoft Technologies. Show less 1. Material Compliance (RoHS) and REACH of HP Products such as Notebooks, Desktop, Workstation, All-In-Ones and RPOS.2. Complete HP Supplier Management including supplier onboarding.3. Process Automation, Process Simplification and collaboration with several teams such as IT for implementation of new tools, supplier id creation and Business Partner Management Teams.4. World Wide Implementation of Regulations affecting products of HP.5. Development of automation using Microsoft Technologies Show less

      • Data Analyst

        Jan 2023 - now
      • Business Operations Manager – Material Compliance (RoHS and Reach)

        Nov 2018 - Dec 2022
      • Business Operations Analyst – Material Compliance (RoHS and Reach)

        Apr 2013 - Nov 2018
  • Licenses & Certifications

  • Volunteer Experience

    • Inner Engineering Course

      Issued by Isha Foundation on Mar 2016
      Isha FoundationAssociated with Varun Agarwal