SUMMARY:

Corporate Tax Professional with more than 3 years progressively responsible

experience with preparation of tax provision work-papers. Skilled in working on large amount of data ( 57,000 plus fixed assets items ) and reports using Excel, Alteryx, Tableau, FAST, SQL, and Power BI.

CERTIFICATION

California CPA

B.S Business in Accounting, CSU Stanislaus, Turlock, CA. (GPA 3.7 /4.0) EXPERIENCE

ANDERSEN TAX SAN MATEO

CORPORATE & INTERNATIONAL TAX (Compliance & Consulting) May. 22 - AUG. 23 1. ASC 740 Provision:

Prepared and reviewed quarter / year-end both domestic and foreign income tax provisions including computation of book to tax differences or E&P adjustment, provisions to return (PTR) true-ups, current year tax expense, tracking of DTA inventory, valuation allowance schedule, tax attribute including NOL and R&D credit carry forward, UTB / FIN 48, cost recovery, SBC, M&A, identified discrete items and ETR reconciliation, and the required FN disclosure.

2. Tax Compliance:

Assisted in both U.S. domestic and international tax filings, including forms 1120, 5471, 8858, 5712, 1118, 8990, 8991, 8992, and required disclosure statements related to international portion of the US, such as statement of 926, 351, 6038B. etc.

Prepared CFC work papers including functional currency translation, schedules such as CE&P, GILTTI, PTEP, income of US Shareholders, Inter-company Transactions, and Qiaomin (Dana) Mai, CPA

1530 Southwest Expy Apt 203, San Jose CA 95126.

Cell: 408-***-****, ad0vg7@r.postjobfree.com

My LinkedIn profile: https://www.linkedin.com/in/qiaomin-mai-cpa-candidate-3b21aa53/ related financial statement disclosures and documentations, etc.

Performed international tax calculations, including E&P, Subpart F inclusions, GILTI, BEAT, FDII, and FTC limitation, Section 250 deduction, Section 78 Gross Up, Foreign Tax Credit, Tested Income of CFC, and high tax election for schedule G etc.

Assist in analyzing tax impact of various business initiatives and tax legislative changes as needed.

3. Consulting:

International Tax consulting project including analysis of treaties, resident test, created excel model for Safe Harbor Analysis from technical explanation, and tax research Memo such as Subpart F income for Captive service provider income.

Performed indirect tax research for 68 different countries for VAT / GST exposure for web sale vs online platform sales tax.

Domestic consulting projects on Tax Analysis including location of activities such as HQ location qualify opportunity zone (QOZ) credit, R&D development, manufacturing, warehousing, and customer location.

KPMG LLP ( In-house Consulting @ Facebook ) SANTA CLARA CORPORATE TAX ASSOCIATE Jan. – Oct. 2020

Assisted in Long Range Planning (LRP) or worldwide forecasting and budgeting including calculation of QBAI for GILTI and FDII; allocation of FDII/Non-FDII of NOL; calculation of R&D credit limitation, foreign tax credit etc.

Prepared depreciation calculation using excel formulas base on asset life, GDS, ADS, and depreciation method such as bonus depreciate, Straight-line, and MACRS for Federal, State, check-the-box entities, GILTI, and Subpart F etc.

Ad Hoc Reporting: Downloaded Tableau, FAST, and Incorta Reports to create Alteryx Output

Cost Segregation: Cost Recovery Analysis including Textura analysis

Prepared Fixed Asset roll-forward.

ALVAREZ AND MARSAL LLP SAN JOSE

CORPORATE TAX INTERNSHIP Jun, – Aug. 2019

Filed Federal (Form 1120), State, and international tax returns. Prepared tax return work paper in excel including information requests from clients, tax return roll forward with current year provision workpaper or prior year tax return.

Prepared trail balance coding for new clients, adjusting journal entries, estimated income tax payments, tax return workpapers, and inputting data to Go System for tax returns.

Assisted in both U.S. domestic and international tax filings, including the preparation of workpapers on quarterly and annual income tax provision to return true up analysis, book to tax differences, current and deferred taxes expense, DTA inventory, R&D credits, NOL carryforward analysis, E&P analysis, uncertain tax positions under ASC 740-10 (FIN 48), cost recovery analysis, effective tax rate, inter-company/transfer pricing entries, and footnote disclosures.

Assisted in the preparation of international portions of the US federal income tax returns, including section 965 transition tax expense computation, rebuilt or updated excel model for Form 5471 and Form 8858 for compliance purposes. MOSS ADAMS LLP CAMPBELL

INTERNATIONAL TAX INTERNSHIP Jan. – Apr. 2019

Remained current with regulatory updates and maintain an understanding of U.S. and international tax topics.

Determined which filings must be completed for each underlying entity, ensured accurate and timely filing to the proper regulatory agency, to include, but not limited to:

Preparation of PFIC Testing, PFIC Statements, 926 Statements, Form 8865, Form 5471, and GILITI Calculation

Communicating complex tax issues to non-tax professionals, colleagues, and clients. SKILLS & HOBBY

Proficient in MS Excel: performing logical test with combination of functions of "if",

"or", "and"; utilizing functions such as Xlookup, Index Match, Countifs, Sumifs, Averageifs, Pivot tables, etc;

Computer Skills: Proficient in MS Word, PowerPoint, Adobe; Alteryx; Power BI

Language Skills: Bilingual in English and Chinese (Cantonese & Mandarin)

Hobby: Enjoy swimming, walking with my dog, traveling, cooking, and working out. REFERENCES:

Upon request

Contact this candidate