Accounting Microsoft Office

Amy (Shu Qing) Cheung

***** ** **** **, ********, WA, 98005 *****.**@*****.*** 206-***-****

PROFESSIONAL EXPERIENCE

EXPEDIA, INC. Bellevue, WA

**** – 2018 Tax Manager (State & Federal)

2008 – 2012 Senior Tax Analyst

Developed a detailed yearly compliance workplan for federal and state filing requirements using the MS Project Tool program. Coordinated with various team members, groups, and outside providers get buy in from all individuals involved. Continuously monitored and adjusted workplan as necessary to accommodate the ever-changing workload/projects.

Created and managed a schedule to track tax returns filing and payments and assigned preparers and order of preparation. Prepared and reviewed federal (1120s, 1120Fs, and 1065s) and state returns, extensions, estimated payments and quarterly cash tax forecasting.

Learned the various internal tracking schedules and systems (TOMS and SharePoint). Managed and maintained these various tracking schedules and systems for the federal and state compliance.

Revamped multiple federal and state processes to improve efficiency, consistency and accuracy. Simplified, cleaned-up, standardized and improved workpapers, documentation, and folder structures.

Coordinated with transfer pricing team to prepared and reviewed Country-by-Country (CBC) Reporting utilizing Corptax tax software. Worked closely with software provider, attended webcasts, and researched to learn the ins and outs of the system as the provider developed and tweak the new reporting tool. I was the matter expert on this tool for the company.

Managed and reviewed state returns, state notices, and state apportionment for numerous entities. Resolved numerous state notices on various entities and actively supported/assisted with the federal tax audit.

Developed and maintained working relationships with professional accounting firms, directors, accounting group, and various internal departments to resolve issues.

Managed two senior tax analysts, contractors, and outside providers on various tasks/projects.

Successfully e-filed the consolidated federal return and two partnership returns under time constraint and limited resources.

Prepared and reviewed return to provision true-ups and tax return memorandum. Reviewed transactions of the company and prepared statements for filing.

Learned and prepared the rollover of Corptax software for new compliance filing season.

Coordinated with compliance and provision team members to prepare and complete the quarterly and year-end tax provision for federal and state adjustments/impacts.

Reviewed numerous projects from various teams within the company and assessed impact(s) to the compliance team.

AMAZON.COM, INC. Seattle, WA

2012 – 2017 Senior Tax Analyst

Managed the tracking of 300+ the domestic entities, created organization charts for quarterly distribution, and presented entity structure changes to various groups and management levels.

Assisted with the development of a new online internal entity tracking tool. Worked closely with the technology team by providing guidance, clear communication of goals and roadblocks/issues in the process, and knowledge of entity transactions across multiple years. Tested the tool in multiple phases of the development and communicated issues to technology team.

Supported and contributed to the successful implementation of Corptax software. Attended multiple training to learn about the system. Worked with outside providers and internal team to get the system setup. Tested and review date inputted into the system for accuracy. Communicated the pros and cons of various features of the software and developed work arounds where the system lacks in meeting the needs of the users.

Reviewed, analyzed, and prepared various tax forms and numerous tax adjustments while consistently adding detailed notes/documentation to file.

Prepared and filed tax extensions and federal tax returns.

Managed, trained, and provided guidance to contractors on various assignments.

Coordinated with provision team to prepare forecast, numerous tax adjustments, and updating the tax deferred schedules.

Improved workpapers and various processes within compliance.

Worked with various accountants to resolved issues and/or gather additional information to gain better understanding of accounting/financial treatment of numerous matters.

Managed numerous ad-hoc requests from various team of the company for W-9 Forms, Form 8832, and SS4 Forms.

Balanced and effectively managed multiple priorities and meeting various internal and external deadlines under pressure.

WEYERHAEUSER COMPANY Federal Way, WA

2005 – 2008 Tax Analyst II

2004 – 2005 Tax Analyst I

Prepared and reviewed complex income tax returns including issue recognition, analysis, research and resolution.

Worked in broad areas of state and federal tax return preparation, including the preparation of property tax, subsidiary, and private foundation (Form 990PF) returns.

Supported special projects requiring analysis and research of tax impact:

Prepared and reviewed annual NAFTA certificate issuance.

Facilitated Section 1031 Like Kind Exchanges for the Company.

Created and implemented the process for the data collection and calculation of R&D credit/expense. Worked with numerous employees of the company to understand the various projects, gathered information through interviews and determined qualification for credit.

Managed and improved the FAS 123R process working with accounting and outside providers.

Mentored and educated new hires and employees outside of the tax group on tax matters.

Maintained flexibility and professionalism amongst constant shifting of projects and work within the team.

EDUCATION

University of Washington Seattle, WA

2003 – 2004 Master of Professional Accounting - Taxation

1999 – 2003 Bachelor of Arts - Business Administration (Accounting, Information Systems, Finance)

SKILLS AND ACTIVITIES

Proficient in Microsoft Office, Project, Visio, Peachtree, Tax Dimension, SAP, PTMS, OneSource, SharePoint, Oracle and Corptax. Research with RIA Checkpoint & BNA Portfolio.

Volunteer work: Project Habitat for Humanity; joined a team to teach English to teachers in China; led my own teams to rural areas of China to teach English to high school students and orphans in two separate years; tutored elementary students, and Northwest Harvest.

Trained and completed three half marathons, one full marathon, and received the trifecta medal for Spartan races.

Contact this candidate