Sales Data

Location:

Posted:

March 18, 2015

FAN SHI

**** ** ***** **, *** ***, Kirkland, WA *8034 ● 646-***-**** ● ********@*****.***

OBJECTIVE To pursue a Financial Analyst position in the greater Seattle area

SKILLS Programs: - Proﬁcient in Excel (Vlookups, Pivot Tables, Macros, etc), PowerPoint, SAP Financials,

MS Dynamics SL, Concur, ProSystem Fx;

- Knowledge of Oracle Financials and Access;

- Strong Research Skills in U.S. GAAP, IFRS, FASB ASC and CCH Rules

Languages: Chinese - English Bi-Lingual Translator

PROFESSIONAL EXPERIENCE

06/2014-12/2014 Staff Accountant

Santa Clara, CA Ibiden USA Corporation

• Performed monthly ﬁnancial analysis, analyzed causes of unexpected variances;

• Audited BFA reports, identiﬁed trends in areas of revenue and cost of sales;

• Maintained FP&A processes, created ad-hoc ﬁnancial reports including the analysis of key metrics,

models and supporting activities;

• Performed monthly closing, prepared ﬁnancial statements reporting to HQ in Japan;

• Assisted auditors on HY reviews, conducted transaction reconciliation and comparative analysis;

• Managed sales accrual process, D&B analysis and data sharing within FP&A;

• Filed multi-states Sales and Use tax; prepared transfer pricing documents

01/2014-05/2014 Accountant (Contractor)

Mountain View, CA Travelzoo Inc.

• Assisted the Controller preparing Actual vs. Budget reports, supported in developing ﬁnancial pre-

sentations for Senior Management;

• Performed Oracle reporting: migrated data, set up chart of accounts and created WebADI entries;

• Assisted auditors with issues on revenue recognition and SOX internal control;

• Analyzed revenue rate cards to ensure compliance to pricing guidelines;

• Performed full-cycle Concur employee expenses and reimbursements analysis and reporting

01/2012-04/2012 Tax Accountant

San Jose, CA Martin, Stavolone & Hughes CPAs

• Prepared tax returns for 100+ high net-worth individuals, trusts, partnerships and S/C corporations;

• Advised clients on tax deductions and beneﬁts, ranging from investment, property leases and sales;

• Researched IRS and state new tax regulations on capital gains and energy improvement credits, etc

EDUCATION

08/2012-12/2013 Master of Science in Accounting

San Francisco, CA San Francisco State University

ACTIVITIES Fellow of Salzburg Seminar on Media and Global Change in Austria;

Tutor at Columbia University Language Resource Center in New York