Yu (Blair) Guo *******@*****.***, 469-***-****
**** *********** **., ***. ****, Dallas, TX 75248
EDUCATION
MS in Accounting Expected 12/2013
The University of Texas at Dallas, Richardson, Texas GPA 3.5
Dean’s Impact Scholarship Award
BS in Accounting 07/2011
Chengdu University, Chengdu, China GPA 3.6
Dean's Honored Graduate
CERTIFICATIONS AND SKILLS
Certification: CPA eligible, sitting for FAR section, August 2013
Technical: Quickbooks, SAP, MS Office Excel and Hyperion Financial Management (HFM), Outlook
Languages: Fluent Chinese, English
WORK EXPERIENCE
Financial Planning & Analysis Intern
Baker Hughes, Grand Prairie, Texas 01/2013 – 05/2013
Provided ad hoc financial analysis to support quarterly revenue tempo reasonableness
Operated HFM adhoc sheets to find revenue variances and reconcile differences
Created weekly revenue reports detailing sales, rental services and invoice numbers
Interviewed sales and operation departments to determine reasons for revenue discrepancies
Updated P&L, headcounts, lapse days and inventory reports to support management
Accounting Intern
Kidd Kraddick in the Morning, Irving, Texas 08/2012 – 11/2012
Processed AR/AP transactions with Quickbooks
Prepared entries to general ledger accounts to assist in the month end close process
Reconciled bank statements by comparing statements with general ledger
Created invoices based on sales and services to verify accuracy in workflow system
Maintained accounting databases by entering data and filing documents
Tax Preparer
Volunteer Income Tax Assistance Program (VITA), Dallas, Texas 01/2012 – 04/2012
Coached a team of 5 volunteers, answering tax return questions
Prepared 15 individual tax returns for low-income families with Tax Wise
Determined need for additional forms for more complicated tax returns
Auditor Assistant
Beijing Red Sun Public Accounting Firm, Chengdu, China 01/2010 – 05/2011
Assisted in the planning activities related to financial and performance audits and operational reviews
Executed test of controls and fieldwork of audits including interviews, data analytics, research and
application of compliance to determine internal control weaknesses and operational risks
Provided recommendations on the effectiveness and efficiency of operations, the reliability and
integrity of financial information, and compliance with applicable laws and regulations
Drafted auditors’ reports on different audit engagements
ACTIVITIES
President
Culture Connection, UT Dallas, Richardson, TX 01/2012 – 05/2013
Coordinated and presided over 15 workshops for international students on cultural issues
Collaborated with International Office and other student organizations to improve cross-cultural events
Treasurer
Ascend, UT Dallas, Richardson, TX 01/2012 – 02/2013
Prepared operating budget, issued checks and arranged payment vouchers