Andrew Baccellieri
Pelham,NY
Overview
8
8
years of professional experience
Work History
Tax Senior Analyst
PepsiCo
05.2022 - Current
- Prepare U.S. international tax forms and related analysis required for the annual income tax compliance including Forms 5471, 8858, 8865, 1118, 926, 8993, and 8990
- Prepare quarterly and annual Subpart F forecasts for estimated annual effective tax rate calculation
- Assist in various International Planning Initiatives
- Review and calculate Earnings and Profits (E&P) and Subpart F income for foreign affiliates
- Prepare responses to IRS tax audit Information Document Requests and assist with State tax audits
- Provide transformation team with support on PepsiCo legal entity reporting project
Tax Analyst
PepsiCo
02.2022 - 05.2022
- Prepared and reviewed forms relevant to the international portion of the U.S. federal tax return
- Prepared disclosure statements relevant to IRS code sections 351, 367, and 368
- Assisted in setup and maintenance of Corptax tax prep system
- Utilized Oracle Hyperion Financial Management system to provide local teams with financials for hundreds of legal entities
Tax Associate Analyst
PepsiCo
02.2021 - 02.2022
- Prepared forms relevant to the international portion of the U.S. federal tax return
- Prepared the certification of Dual Consolidated Losses and analysis in relation to IRS code section 1503(d)
- Reached out to various local tax jurisdictions to obtain section 901 foreign tax credit substantiation for withholding and current income tax
- Uploaded data to Corptax for joint ventures via financial statements based on their respective filing requirements
Tax Assistant Analyst
PepsiCo
02.2020 - 02.2021
- Assisted in Corptax data management system software transition
- Assisted in the preparation of Tax Forms 1120, 8858, and 5471
- Updated Fin 48 reserve summary and roll-forward for quarterly closes
- Prepared Form 8990 and completed section 163(j) analysis regarding business interest limitation for various foreign subsidiaries of PepsiCo Inc.
- Assisted in restatement for current and prior year FAS109 reports for new sectors APAC and AMESA after they were broken out from AMENA
Tax Intern
PepsiCo
02.2019 - 02.2020
- Prepared Form 1120 for dozens for U.S. foreign branches
- Prepared Form 8858 for foreign disregarded entities.
- Assisted with the transition to OneSource tax system from Corptax
Internship
NYPD
06.2018 - 02.2019
- Produced Excel spreadsheets and updates with the latest information.
- Wrote and edited professional-level documents for the department.
Volunteer Work
Einstein Emergency Room
09.2015 - 01.2017
- Provided minor assistance to nurses and physicians.
Education
Bachelor of Arts - Economics
Purchase College
NYSkills
- Proficient in Corptax Corporate Tax Software
- Proficient in Oracle Hyperion Financial Management System
- Extensive Knowledge of PepsiCo Business Operations and International Structure
- Tax Technical Understanding
- Proficient in Microsoft Office
- Excellent interpersonal and communication skills as well as strong analytical and organizational skills
Accomplishments
Overall GPA 3.43
Major (Economics) GPA 3.90
Timeline
Tax Senior Analyst
PepsiCo
05.2022 - Current
Tax Analyst
PepsiCo
02.2022 - 05.2022
Tax Associate Analyst
PepsiCo
02.2021 - 02.2022
Tax Assistant Analyst
PepsiCo
02.2020 - 02.2021
Tax Intern
PepsiCo
02.2019 - 02.2020
Internship
NYPD
06.2018 - 02.2019
Volunteer Work
Einstein Emergency Room
09.2015 - 01.2017
Bachelor of Arts - Economics
Purchase College