Financial Analyst

Lu Jiang

**** ******** ****** ***.*** Phone: 812-***-****

Simi Valley, CA 93065 Email: ******.*****@*****.***

Objectives

Desire a financial analysis position in a firm, and interested in areas such as budgeting, forecasting, and financial statement analysis, etc.

Qualifications

1. Experience in P&L statement preparation, budget development and financial forecasting

2. Proficient in Financial Statements Analysis (Ratio analysis and Common-Size financial

statements), Standard & Variances analysis, and Margin Analysis

3. Expert in Excel financial modeling (scenarios analysis, sensitivity analysis, solver, goal

seek, pivot table and macro)

4. Expert in Access (maintaining database, create more advanced queries and customer forms and

report)

5. Proficient in using analytical software such as SAS and SPSS to do data analysis, and

generate reports

6. Skills in MS Office such as Word, and PowerPoint with excellent presentation skills

7. Knowledge in SAP FI/CO

8. Trilingual background (Chinese, English, Japanese) and excellent communication skills

Education

Indiana State University (ISU), College of Business, Terre Haute, IN (08/2005 to 05/2007)

MBA degree, concentrate in Finance, May, 2007. Overall GPA: 3.8/4.0 scale

Indiana University (IUB), Kelley School of Business , Bloomington, IN (09/2001 to 05/2004)

B.A. degree in Business Administration, major in Finance, May, 2004. Overall GPA: 3.5/4.0 scale

Foreign Affair University, Beijing, China (09/1996 to 07/1999)

A.A. degree in Communication, major in Japanese, July, 1999. Overall GPA: 3.7/4.0 scale

Work Experience

Financial Analyst (06/2007 to present) Bush Industries Commercial Furniture, Inc.

• Prepared the company-wide operations budget and three-year financial plan

• Developed monthly sales & margin financial model and quarterly financial forecast model to

monitor and evaluate profit and lose, including variance analysis.

• Prepared month-end sales & profit reconcilements on planning and forecasting deviation, and

write financial analysis report to CFO.

• Developed Cash Flow model to improve daily cash flow management.

• Assisted in Cross Functional Team to make recommendation from financial point of view to

Sales VP.

Graduate Assistant (08/2006 to 05/2007) Finance Department, ISU

Assisted finance faculties in teaching, grading homework and, and updating webpage. Provided academic reviews to the research of analytical department chairman on financial services and institutions

Internship (07/2006 to 08/2006) Modern Aluminum Castings Co., Inc.

Involved teleconference translations, email translation/correspondence and document preparation for our Chinese Manufacturing Associates.

Office Assistant (08/2005 to 06/2006) Dean’s Office, ISU

Provided assistance to students and faculties who visit or call the Dean’s Office and other office operations.

Marketing Analyst (07/1999 to 03/2000) IBM Corporation

Conducted customer surveys, collected and analyzed marketing data with Lotus 123 and analytical skills.

Contact this candidate