Financial Analyst

YING CAI

**** ***** ** **, *******, WA 425-***-**** *****@********.***

Objective & Career Goal

Highly motivated graduate seeking a financial analyst role where I can use my knowledge to carry out various responsibilities.

To be a professional financial analyst in three to five years.

Education & Honors

Seattle University (Jun. 2017- Mar. 2019) WA, USA

Master of Science in Finance, Dean’s Honor List, Winter 2019 GPA: 3.8/4.0

Nanjing University (Sep. 2002- Jun. 2006) Shanghai, China

Bachelor of Arts in English Language & Literature, Business Admin. GPA: 4.1/5.0

Professional Skills & Attributes

Corporate finance: FP&A skills, valuation, risk assessment (variance, scenario, sensitivity analysis)

Portfolio strategic asset allocation through mean-variance optimization through Microsoft Excel Solver function

Big data visualization using Microsoft Power BI or Tableau software

Excellent written & oral communication skills gained through six-year interaction with over 150 global clients

Self-motivated, detail-oriented, organized time management when under pressure (e.g. accomplished three projects simultaneously)

Language & Computer Skills

■ Language – English Chinese Conversational French

■ Microsoft Word, Excel (Pivot table, VBA Marcos), PowerPoint, Power BI, Tableau, MySQL; etc.

Finance Course Projects

Hampton Machine Tools Credit Analysis, team work, Entrepreneurial Finance course, Winter 2019

Worked as a co-leader with another teammate in a five-people group setting and finished the project within two weeks with a grade of 95 over 100.

Scheduled group meetings to assign work for group member and monitored the progress to meet the deadline

Prepared a cash source & use statement and did ratio analysis to forecast the trend of the company’s performance: future revenue and cost, etc.

Worked out projected income statement and balance sheet, together with the company’s credit history, to decide the possibility of timely loan payoff.

Paccar Buy or Build Decision Making, Corporate Investment Decision course, Winter 2018

Finished the whole project independently and received grade 39 over 40, which was in top decile in the class

Estimated the NPV (DCF model), IRR and Payback period of buying and building respectively using four risk assessment tools: 1) break-even; 2) two-way sensitivity; 3) scenario and 4) the Monte Carlo Simulation analysis

Wrote final report and presented it to professors and board of directors of Seattle University’s finance department and got applause

Amazon 2016 performance valuation, Corporate Finance course, Fall 2017

Researched and analyzed Amazon’s financial statements, annual reports and 10K from Yahoo, Value Line and SEC

Applied three value-based performance measures, FCF EVA TSR to analyze Amazon’s performance and wrote final report to support hypothetic strategic decision makers

Work Experience

Senior Export Specialist, Jutu Technologies, Shanghai, China (2009-2012)

Served more than 150 international clients in three years by creating, following orders and maintaining client relationships

Created average revenue of $1 Million per quarter, around 10-15 orders per month with a size of $20,000 to $30,000/order

Conducted sales analysis based on order data and developed sales plans for company’s long-term business development

Negotiated with cross functional teams (both logistic and supply chain department) through face meetings, emails and calls daily to meet clients’ order requirements

Community Activities

Volunteered in Children’s Rehabilitation Center of Nanjing, China, 2004-2006