Avirup Banerjee
Kolkata
Summary
With a robust background at Tata Consultancy Services and Genpact, I excel in leveraging SAP and S4 HANA expertise alongside strong leadership abilities to drive financial process improvements and strategic decision-making. Achieved significant efficiencies and cost reductions through innovative solutions and team mentorship, demonstrating exceptional analytical and interpersonal skills.
Overview
18
18
years of professional experience
Work History
Assistant Manager
Tata Consultancy Services
08.2023 - Current
- Tower Lead for Finance and Accounting Services - responsible for month-end closing, balance sheet reconciliation, financial accounts reporting to the board, invoice processing, payment proposal creation, performing soft close and hard close, and analyzing monthly accrual postings.
- Preparation of the Cash Management Report, which provides a business-wise breakdown of actual cash expenditures against the budget.
- Providing leadership, insight, and mentoring to newly hired employees to supply knowledge of various company programs.
Business Process Lead
Tata Consultancy Services
01.2019 - 07.2023
- Bank accounting - Performing daily maintenance of cash clearing accounts, identifying open items, following up with the business on these open items, and arranging weekly calls with onshore stakeholders to report on open items.
- Treasury - Performed as a team lead for the offshore Treasury team, and performed daily cash reporting to help in the analysis of daily working capital requirements.
- Forecast cash receipts and payments to report requirements of cash to onshore counterparts.
- Process urgent payments and refunds.
- Implementation of S4 Hana: worked on the finance side of the implementation of S4, which would involve the preparation of the Chart of Accounts and the migration of balances from the legacy system to the new system.
- Preparing process maps and notes for the new organization.
- Developed and implemented process improvement initiatives to increase efficiency and reduce costs.
- Collaborated with IT teams to design system solutions that supported new or revised processes.
- Researched and implemented best practices to improve audit results.
- Prepared monthly bank reconciliations and resolved discrepancies in a timely manner.
- Collaborated with external partners to complete audits.
- Performed financial analysis to evaluate capital structure decisions such as refinancing or restructuring existing debt agreements.
Senior Process Associate
Tata Consultancy Services
02.2016 - 12.2018
- Weekly revenue reporting, which would include the preparation of reports as well as reconciliation of the same between the GL and various systems.
- Posting accruals based on GL analysis.
- Initiating billing by creating an invoice.
- Inter-company reconciliation.
- Monitored daily liquidity positions and worked with other departments to ensure sufficient funding was available for operations.
- Developed and implemented cash management strategies to optimize liquidity and reduce risk.
- Identified opportunities for process improvement initiatives by analyzing existing practices and developing new approaches.
- Created and reviewed journals for bank account transactions.
Process Developer
Genpact
11.2013 - 02.2016
- Responsible for ensuring that correct account balances are reflected in the licensor's ledgers.
- Auditing of the Licensor's database to ensure proper records are being updated in the system.
- Coordinating with the maintenance team to ensure proper uploading of Library/File combinations to the accounting system.
- Preparation of the operational Standard Operating Procedures (SOP) and ensuring compliance with the set standards.
- Training new hires and helping them to come up the learning curve.
- Being a Process Trainer, I had to ensure quarterly assessments for all resources in the team.
- Project creation to ensure billing is done on time.
- Quarterly closing of the General Ledger, which would include posting manual journal entries.
- Balance Sheet Reconciliations of Accounts.
- Controlling disputed payments and working with service managers to clear them.
Process Associate
Genpact
11.2011 - 11.2013
- Managed global clients' royalty accounting for both online and offline transactions
- Reconciliation of net sales with royalty statements.
- Reconciliation of work, sales detail, with the report generated from the sales department
- Reconciled online sales data from clients against work sales report
- Reconciliation of variances between different systems to provide solutions to ensure all systems provide the same information
- Comparative analysis of the monthly revenues generated, and identifying any abnormal changes.
- Calculation of royalty for special paid customers, and ensuring payments as per the agreements
Audit Assistant(Staff)
Bhattacharya Das and Co. Chattered Accountants
12.2010 - 08.2011
- Collaborated with external partners to complete audits.
- Ensured all audit work is conducted in accordance with established professional standards and guidelines.
- Prepared detailed schedules for auditing purposes, such as revenue and expense accounts or inventory items.
- Maintained accurate accounts for cash, fixed assets and other transactions.
- Presented audit results to management teams, delivering information in non-technical terms for easy understanding.
Article Assistant
Bhattacharya Das and Co. Chattered Accountants
05.2007 - 11.2010
- Monthly KYC audits at various banks
- Loan audits based on credit ratings and documents available with the bank
- Circulation audit for a Publishing company on the basis of ABC(Audit Bureau of Circulations) guidelines
- Statutory Bank audits based on Long Form Audit Reports
- Purchase audit based on invoices and vouchers
- Concurrent Audits for multiple banks which included, KYC checks, preparing reports on Term Loan, CC accounts, NPA reports
- Quarterly stock audits
- Daily checking of payment vouchers
- Subscription audits
- IT audit for Banking software in different banks
Education
Class 12 -
Julien Day School
Kolkata01.2005
Class 10 -
Julien Day School
Kolkata01.2003
B.Com - Accounts Hons.
Calcutta University
Skills
- Tally
- Skilled in Office Suite Tools
- Digital Communication Tools
- SAP
- Blackline
- Treasury Management System Proficiency
- S4 HANA Expertise
Accomplishments
- Awarded Lean, Six Sigma certification (3 star Lean Ace) from Genpact- India for providing 3 lean ideas which can ensure 100% accuracy of work and take less time in doing so.
- Awarded Bronze award for exemplary performance and demonstration of Genpact values.
- Awarded Bronze award for Exemplary Performance for the process.
- Awarded Bronze award from training team for good performance as a Process Trainer.
- Won Presentation competition.
- Winner of On Spot Skit Competition in Office Event.
- BPS Star Performer of the month on 3 occasions.
- Awarded as an Individual Contributor.
Training
- Practical Training on Emerging excellence, Interpersonal skills.
- Domain Knowledge on Royalty Accounting.
- Knowledge on Progress Collection Accounting.
- Agile E2 certified.
Personal Information
Date of Birth: 12/17/86
Language Known: English,Bengali and hindi
Activities
- Participated in various sports and events at School and college level.
- Represented Genpact Badminton team.
Timeline
Assistant Manager
Tata Consultancy Services
08.2023 - Current
Business Process Lead
Tata Consultancy Services
01.2019 - 07.2023
Senior Process Associate
Tata Consultancy Services
02.2016 - 12.2018
Process Developer
Genpact
11.2013 - 02.2016
Process Associate
Genpact
11.2011 - 11.2013
Audit Assistant(Staff)
Bhattacharya Das and Co. Chattered Accountants
12.2010 - 08.2011
Article Assistant
Bhattacharya Das and Co. Chattered Accountants
05.2007 - 11.2010
Class 12 -
Julien Day School
Class 10 -
Julien Day School
B.Com - Accounts Hons.
Calcutta University