TING DING
Portland, OR **229
Tel: 503-***-****
Email: abiims@r.postjobfree.com
OBJECTIVE
Seeking a position in financial analysis and accounting
EXPERIENCE
Financial Analyst
July 2003-Sep 2004
Sales Compensation Department, Oracle Corp, Rocklin, CA
. Prepare monthly/quarterly/YTD financial reports
. Design and mock up new report templates by using advanced Excel such
as pivot, look up as well as nested if statement
. Forecast sales revenues and analyze complex financial statistical data
. Reconcile sales commissions between general ledger and compensation
department
. Use Oracle Financial reporting tools for ad hoc report generation and
data gathering
. Manage contents for Compensation department's web site on Oracle
Global Exchange
Accounting Analyst Feb 2001- Jun 2003
Fund Accounting Department, Franklin Templeton, Rancho Cordova, CA
. Perform accounting activities for two mutual funds, including
calculation of daily Net Asset Value
. Review of security transaction, post G/L entries, and perform bank
reconciliation
. Prepare and analyze financial statements, and complete month end and
fiscal year end reports
. Develop and manage budgeting processes for the assigned funds and
provide monthly operating reports for management review
. Maintain the fund's compliance with various tax rules and prepare
tax reporting schedules
Accountant /Financial Analyst Jul 1999-May 2000
Call Center Admin., Personal Line Insurance Center, The Hartford,
Southington, CT
. Prepare and distribute daily/weekly/monthly/YTD reports on performance
against plan
. Analyze workload and staffing issues arising out of actual performance
. Analyze complex data and reporting out on the analysis of cost
benefits
. Produce workload forecasts with real time assessment of plan vs.
actual variances associated actions or recommendations
. Identify trends, opportunities and success and make recommendations
. Develop/enhance Excel-based report templates
Graduate Assistant (Accounting Tutor) Sep 1998-May 1999
Accounting Department, University of Hartford, West Hartford, CT
. Accounting tutor for undergraduate and graduate students
Electrical Engineer 1987-1994
Tech. Service Dept., Shanghai Precision Measurement Instrument Co.,
Shanghai, China
. Lead of a small group of associate engineers and technicians;
responsible for customer accounts and training
EDUCATION
M. S. in Professional Accounting May 1999
University of Hartford, West Hartford, CT
GPA: Graduate Courses - 3.80/4.0; Undergraduate Courses - 3.77/4.0
B. S. in Electrical Engineering
July 1987
Shanghai University of Technology, Shanghai, China
Received "Best Undergraduate Thesis" Award, 1987
SKILLS
Microsoft Office (Excel, Word, Access, PowerPoint and Outlook)
Microsoft Windows, SQL Language, IEX, Prism, Lotus Notes,
Oracle Discoverer, Oracle Global Exchange
Excellent math
HONER SOCIETY
Member of Sigma Beta Delta (an Int'l Honor Soc. in Business, Mgmt., &
Admin.)
LANGUAGE
Chinese
English
CITIZENSHIP
United States