UPHAR ARORA

• Leading team for Investments tax , responsible for Tax basis calculations of Investments made by the AIG Group.
• Review and sign off on quarterly Provision calculations of the Partnerships, Mortgage Loan and Affordable Housing portfolio.
• Review and sign off on the tax basis calculations for all partnership investments by AIG, which includes taxable income calculations and capital gain calculations which eventually gets reported on 1120.
• Review and sign off on tax basis calculations as per IRC sec 705 and related codes.
• Performance on complex work papers for Fixed income and equity investments for AIG and Corebridge group.
• Responsible for further transition of the Investments tax advisory work to India.
• Team had grown from 7 FTE to currently 18 FTE in last 3 years, where responsibility of transition of work and set up of team was my key responsibility.

• Quarterly US GAAP provision review in accordance with ASC 740 encompassing ETR drivers, Current Tax Payable, deferred roll-over & tie out, Valuation Allowance analysis, NOL analysis, Return-to- Provision review & sign off, Elimination co
• Quarterly Forecast; Pre-Tax Book Income review for reasonableness, identifying the inter-company & purchase accounting transactions and identifying the best estimate for each permanent and temporary adjustment in order to calculate a reasonably annualized forecasted income tax provision for each jurisdiction
• Quarterly Balance Sheet Analytics review for AIG entities.
• Worked on some key tax technology projects to eliminate the technical debt within the organization thereby resulting in saving full time employee effort hours that went into review
• Collaborated with the US team to deliver tax technical trainings on key topics such as Valuation Allowance, FIN48 and ETR analysis

• Key Processes Managed (US , Canada & Latin America):

• Direct Tax Compliance; Preparation of Federal Tax Returns (Form 1120) for US companies
• Quarterly Federal Estimated & Extension Tax Payment calculations due to IRS
• Quarterly US GAAP Tax Provisioning in accordance with ASC 740 rules:
• Quarterly Discrete Items reporting: UTP, Valuation Allowance, TAAA, Return- to- Provision and Other Discrete’s
• Preparation of Annual “Return to Provision” calculations
• Indirect Tax Returns for the various provinces under the scope of Canada
• Additional Accomplishments:
• Successfully transitioned the tax processes for the US GAAP Consolidation’s & Non- Insurance Tax Team, and ensured smooth implementation of the same at AIG’s Shared Service Centre in India
• Worked on various Automation/Standardization projects that resulted in significant $ savings through reduction of full time employee effort hours
• Successfully completed the transition for the Bogota Finance Centre, Nashville US Center that encompassed the US GAAP Tax Provisioning process for 10 Latin American countries & Tax payments process from US.

• Setting up the APAC tax team for Direct and Indirect tax functions.
• Feb 2014 - Traveled to Hong Kong and transitioned the direct tax return and provisioning work to India Team.
• Mar 2014 - Traveled to Indonesia for transition of US GAAP work.
• Oct 2014 - Traveled to Philippines to transition of Indirect tax and direct tax work.
• Mar 2015 - Traveled to Singapore for transition of the MAS provisioning work and direct tax work for Singapore entities.
• Oct 2015 - Traveled to Australia for representation of APAC team in global tax meet.
• Was responsible for set of the team operations of APAC in India.
• Further on Project for Indirect tax work transition to EY GDS, i performed the roll of project manager managing processing are transitioned smoothly to EY GDS and any risks are highlighted.

-Transition of work from African countries for there financial and tax reporting.

- My role was to train the employees on the work processes been transitioned.

- Traveled to Lagos for the agreement and scope finalisation of work.

• Preparation of Federal Tax Returns (Form 1120) and State Tax Returns for Macquarie Entities operating in the United States of America using One Source Income Tax software by Thomson Reuters
• Monthly ASC-740 US Tax Accounting for the Macquarie US entities
• Preparation of quarterly federal estimates and extensions calculations, check requests and payment vouchers, due to the IRS
• Key contributor in annual projects such as Federal Tax True Up (RTP), State Tax True- up (RTP)
• Worked on calculations for the Australian CFC's as a special project for Australia team.
• Deferred Tax reporting for Macquarie US entities.

• In the Global Accounting team
• My job profile included accounting for the various business units of the EMEA region that fall under the entities purview
• Accounting included accrual bookings, taxation, and reconciliation of the accounts, prepaid and respective amortization
• In addition to the above Monthly control checks and activities are performed diligently so as to ensure adequacy from an Audit perspective.