Summary
Overview
Work History
Education
Skills
Personal Information
Disclaimer
Timeline
Generic

Anand Pandri

Finance & Accounts and Data Analyst
Bangalore

Summary

I have overall 13.7 years of experience out of which, Finance & Accounting 10.3 years including 3 years in Power BI, Taxation & Auditing 2 years and non-Accounting 1.4 years.


Finance & Accounting - Handling RTR, Fixed Assets, Banking and Intercompany. Good in excel formulas & automated some of the activities to save time.

Power BI - Creating Interactive dashboards, Data modeling & DAX (Data Analysis Expressions).


Lead Assistant Manager with proven ability to drive team collaboration and deliver results. Skilled in team leadership, project management, and strategic planning. Known for flexibility and reliability, adapting effectively to changing needs. Strong communication, problem-solving, and decision-making abilities.

Overview

17
17
years of professional experience
3
3
Languages

Work History

Lead Assistant Manager

EXL Service
01.2024 - Current
  • Company Overview : Business management consultant. Applications used: People soft, Blackline & Power BI.
  • Team Handling - tracking leaves, conducting huddles, attending monthly & Bi weekly calls with clients, hiring new resources & performance appraisals of team members, ensuring meeting the TAT as per client requirements etc.
  • Preparation of key reports based on client requirements & handling escalation calls.
  • Preparation & processing of Intercompany settlement entries.
  • Performing BS reconciliations in blackline tool.
  • Preparation of Bank reconciliations & processing the entries like bank charges & interest, IC settlement, currency correction etc.
  • Preparation & processing of accruals, prepaid amortization, depreciation, payroll entries etc.
  • Following up with the respective teams on bank open items.
  • Building interactive dashboards for management purpose.
  • Scheduling weekly & monthly reports as per client requirement.
  • Performing DAX (Data Analysis Expressions) based on requirement.
  • Setting auto refreshing of data in power bi as per client requirement.
  • Collaborate with stakeholders to gather and analyze business needs, ensuring reports align with objectives.
  • Verify data integrity by cross checking with source system, ensuring reports reflect accurate and reliable information.
  • Develop and customize power bi reports & dashboards for mobile-friendly views, ensuring seamless accessibility.


Process Lead

Cargill Business Services
07.2017 - 11.2023
  • Company Overview : Manufacturing Industry. Applications used: SAP, Power BI, JDE, Blackline, RB (run book) & CMM.
  • Preparation of Balance sheet reconciliations.
  • Computation and processing of recurring & reclass Journal entries.
  • Preparation of prepaid amortization schedule on monthly basis.
  • Working on management reporting like Cartesis and Web Schedules.
  • Creation of IO, assigning & re-stating of budget, and IO settlement.
  • Capitalization of Fixed assets, depreciation run, retirement, transfer & disposal of assets.
  • Performing standard costing, ML (Material ledger), revaluation & translation run.
  • Clearing FX deals on daily basis and preparing open item report.
  • Preparation of TDS & TCS reports and processing the payment entries.
  • Preparation of Gratuity & LE entries based on actuarial reports.
  • Preparation of GRIR & FRIR open items reports.
  • Preparation of Intercompany reconciliations and following up with counter parties.
  • Finalizing the monthly PNL by taking calls with business.
  • Preparation and processing of salary entries.
  • Preparation of deferred tax asset (DTA) & deferred tax liability (DTL).
  • Preparation of 3B reports and updating in management tools.
  • Creation of accruals & provisions based on the details received.
  • Supporting statutory audit requirements.
  • Bad debts run & creating provision by processing an entry.


Senior Associate

EXL Service
05.2016 - 07.2017
  • Company Overview : Business management consultant. Applications used: JDE & Blackline.
  • Computing prepaid, accrual, deferred & outstanding expenses.
  • Computing and booking amortization entry as per invoice period.
  • Computing accrual & deferred income.
  • Checking for payment of accrual expenses if it is unpaid re-accruing the same.
  • Recognizing revenue generated and expenses incurred for domestic and international events.
  • Budget analysis and finding out variance by comparing with actuals, booking an entry accordingly.
  • Analyzing the reasons on over and under budget.
  • Preparing and extracting the financial reports.
  • Overhead analysis and reclassify to respective accounts.
  • Computing talent royalty as per the agreement.
  • Interacting & attending calls with US clients.
  • Preparation of Month end Reports.
  • Responsible for period end close activities.
  • Reviewing and updating DTP's whenever there is a change in the process.
  • Reconciliation of chase concentration bank account, major bank account for the project.
  • Computing unclaimed property.
  • Recording fund transfers to branches and analyzing on translations.
  • Preparing a report on an open item and following up with the respective teams.
  • Capitalizing the closed Projects by transferring the CIP balance to the respective asset GL accounts by booking an entry.
  • Capitalizing the postage, freight, sales tax, shipping charges by booking an entry.
  • Disposal, retirement, Impairment and write off assets.
  • Running pre and final depreciation.
  • Reconciliation of Fixed and current assets, balance sheet items.
  • Posting the entries in FA master and preparing integrity reports & analyzing the variance if any.
  • Computing property tax as per US provisions.

Senior Associate

Capgemini Business Services
10.2014 - 04.2016
  • Banking, Fixed assets, Balance sheet reconciliations, Journals preparation & processing, Month end reports.

Practitioner-CRM Operation

IBM Daksh
03.2011 - 07.2012
  • Handling escalation queries both in voice & non-voice, Preparation of MIS Reports.

Assistant in Audit & Income Tax

Gorti Associates - CA Firm
05.2008 - 06.2010
  • Computing tax liability of an Individuals, IT returns filing, Statutory & Interim audits.

Education

MBA - Data Science & Analytics

Jain University
Bengaluru, India
04.2001 -

Bachelor's Degree - Commerce & Computers

Andhra University
Visakhapatnam, India

Skills

MS Office

Personal Information

  • Passport Number: L3605811
  • Date of Birth: 07/15/88
  • Gender: Male
  • Nationality: Indian
  • Marital Status: Married
  • Religion: Hindu
  • Place of Birth: Visakhapatnam

Disclaimer

I hereby declare that the above-mentioned information is correct up to my knowledge and I bear the responsibility for the correctness of the above-mentioned particulars.

Timeline

Lead Assistant Manager

EXL Service
01.2024 - Current

Process Lead

Cargill Business Services
07.2017 - 11.2023

Senior Associate

EXL Service
05.2016 - 07.2017

Senior Associate

Capgemini Business Services
10.2014 - 04.2016

Practitioner-CRM Operation

IBM Daksh
03.2011 - 07.2012

Assistant in Audit & Income Tax

Gorti Associates - CA Firm
05.2008 - 06.2010

MBA - Data Science & Analytics

Jain University
04.2001 -

Bachelor's Degree - Commerce & Computers

Andhra University

Similar Profiles

CREATE PROFILE
Anand PandriFinance & Accounts and Data Analyst