Overview
Work History
Education
Skills
Certification
Languages
Timeline
Generic

GARRETT IVAN, CPA

Overview

6
6
years of professional experience
1
1
Certification

Work History

Senior Tax Consultant

- Deloitte
06.2022 - Current
  • Prepared tax returns/workpapers for partnership and corporate tax returns for 8+ active clients. Including one of the top 10 largest private equity firms
  • Mentored and coached multiple staff on specialized tax topics
  • Reviewed staff-prepared workpapers and tax returns
  • Created more efficient Excel workpapers though Python and Visual Basic (VBA)
  • Coordinated communication within a client team of more than 60 people managing tax notices
  • Led 12+ interns, managed meetings and training sessions

Finance and Data Consultant

- Immortal Roadmap Program
11.2023 - 05.2024
  • Created Python scripts to analyze 2,000+ webpages to provide data-driven insights in teaching students
  • Upgraded company-wide tracking system for sales and coaching team, improving automation and reduced errors
  • Created financial projections to guide financial decisions
  • Managed client books and prepared monthly statements

Tax Internship

- Deloitte
06.2021 - 08.2021

Prepared tax returns for partnerships

Finance Committee Intern

- De Anza College
01.2019 - 03.2020
  • Oversaw $1M budget
  • Interviewed and worked with finance team to prioritize spending effectively

Marketing Intern

- NOV
06.2018 - 08.2018
  • Created more than ten promotional videos with marketing experts, assisting in scouting, filming, and editing

Education

Business Administration, BS

University Of California - Berkeley

Skills

  • Tax & Accounting
  • Excel
  • Python
  • Data Science
  • Pandas, Matplotlib, Playwright
  • SQL
  • Web Scraping
  • Personal Finance
  • GoSystem Tax RS
  • Quickbooks

Certification

Certified Public Accountant (CPA)

Languages

Chinese (Mandarin)
Limited Working

Timeline

Finance and Data Consultant

- Immortal Roadmap Program
11.2023 - 05.2024

Senior Tax Consultant

- Deloitte
06.2022 - Current

Tax Internship

- Deloitte
06.2021 - 08.2021

Finance Committee Intern

- De Anza College
01.2019 - 03.2020

Marketing Intern

- NOV
06.2018 - 08.2018

Business Administration, BS

University Of California - Berkeley
GARRETT IVAN, CPA