
Varun Agarwal

Connect with Varun Agarwal to Send Message
Connect
Connect with Varun Agarwal to Send Message
ConnectTimeline
Skills
AccountingAccount reconciliationBusiness analysisAnalysisFinancial accountingMicrosoft officeBank reconciliationTeam managementFinancial analysisFinancial reportingProcess improvementBusiness process improvementAuditingInternal controlsGeneral ledgerAutomationProcess simplificationProcess automationLeadership developmentChange managementAbout 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 - 2007Bachelor of Commerce (B.Com.) Commerce DegreeBachelors Of Commere

J.S.S. Mahavidaypeeth
1999 - 2002SSLC High School
Sri Bhagawan Mahaveer Jain College
2002 - 2004PUC CommerceActivities 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 - 2018Diploma in Dot Net Computer Programming, Specific Applications AActivities and Societies: C#, Dot Net, ASP.NET Registration Number : JYN-1718-1340
Experience

Tesco Bengaluru
Jul 2007 - May 20101. 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 2010Accounts Executive – Pensions And Payroll Accounting (General Ledger)
Jul 2007 - Mar 2010

Capgemini Invent
May 2010 - Apr 2013Process 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 - now1. 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 - nowBusiness Operations Manager – Material Compliance (RoHS and Reach)
Nov 2018 - Dec 2022Business Operations Analyst – Material Compliance (RoHS and Reach)
Apr 2013 - Nov 2018
Licenses & Certifications
- View certificate

Ethical Hacking: Overview
Lynda.comAug 2017 - View certificate

Visio 2019 Essential Training
LinkedInJul 2020 - View certificate

Learning Cryptography and Network Security
Lynda.comOct 2017 - View certificate

Power BI Essential Training
LinkedInMay 2020 
Microsoft DOTNET
IIHT LtdFeb 2018- View certificate

Introduction to Web Design and Development
Lynda.comAug 2017 - View certificate

First Look: Visual Studio 2019
LinkedInApr 2019 
Six Sigma Yellow Belt
CapgeminiMay 2011- View certificate

Intermediate Python
DataCampDec 2022 - View certificate

Explorer
HPOct 2020
Volunteer Experience
Inner Engineering Course
Issued by Isha Foundation on Mar 2016
Associated with Varun Agarwal
Languages
- hiHindi
- kaKannada
- enEnglish
Recommendations

Naoki okayama
CEO & Engineer at neno, Inc.Tokyo, Tokyo, Japan
Priyanshu gupta
Full Stack Engineer at Techno-park Inc.Uttarakhand, India
Balaji surywanshi
Regulatory Affairs Professional | Author | Record HolderMumbai, Maharashtra, India
Guna sekaran
Procurement Manager at Sarab ContractingManama, Capital Governorate, Bahrain
Jeevan vikash c v
Programmer Analyst at CognizantTamil Nadu, India
Yiga gilbert
Software Engineer & Developer | AI Enthusiast | Tech Enthusiast.Kampala, Central Region, Uganda
Rachael honaker
Senior IT Associate, International Business Units Business Process Architect at Eli Lilly and Compan...Crown Point, Indiana, United States
Siddhi jain
Digital Marketing | Promotional Media Consultant | Spanish Language SpecialistDelhi, India
Muhammad asif
FounderPunjab, Pakistan
Lawrencia boahemaa awuah mba, shrm-scp, assoc. cihrm
Human ResourceGhana
John randazzo
Director of Finance (CFO) at Niagara Falls Convention CentreHamilton, Ontario, Canada
Aleksander bruss
Looking for exciting and challenging opportunitiesTrieste, Friuli-Venezia Giulia, Italy
Elif yildirim
Farmaceutisch consulent | Masterstudente ZorgmanagementRoermond, Limburg, Netherlands
Mónica liseth ballesteros otero
Ayudo a conseguir más clientes utilizando Internet. | Asesoro a negocios para mejorar su presencia e...Bucaramanga, Santander, Colombia
Trevor stotka
MotivationNicolaus, California, United States
Jaime andrés fandiño herrera
Ingeniero de Desarrollo Senior en Neurona | Desarrollo de softwareColombia
Daniel eduardo villalobos correa
Mechanical Engineer at ECCIColombia
Lahcen aoubba
Seo Expert | +4 Experience Social Media Management ads ROAS Boost x5Laâyoune-Sakia El Hamra, Morocco.webp)
Fc de vos (fia, fassa)
CEOCity of Johannesburg, Gauteng, South Africa
Lucas elser
Senior Project Manager at Project Management Advisors, Inc.Austin, Texas, United States
...