Post Job Free

Resume

Sign in

Excel, SAS, and MATLAB

Location:
United States
Posted:
July 28, 2015

Contact this candidate

Resume:

Yahui Xu

*** *. ******* **. **** **** 312-***-****

Chicago, IL, 60611 acqy87@r.postjobfree.com

EDUCATION

Illinois Institute of Technology (IIT) Stuart School of Business- Chicago, IL May 2015 Master of Science in Finance

• Relevant Courses: Mathematics with Financial Application, Statistical Analysis in Financial Marketing, Equity Valuation, Investment Banking, Models for Derivative, Financial Statement Analysis

• Member of Chinese Students and Scholars Association Donghua University- Shanghai, China Sep 2009-Jun 2013 Bachelor of Economics

• Relevant Courses: Macro/Microeconomics, Econometrics, International Finance, Accounting, Investment Banking

• Awarded “Most Creative” by Financial Management Competition held by “China Business News of Shanghai”

• Awarded “Academic Excellence Scholarship”

• Member of Voluntary Service

• Member of Student Union

PROJECTS

Electricity Forward and CDD Forward Project Sep 2014- Dec 2014

• Simulated 3-month daily electricity price, load and temperature according to Monte-Carlo theory by MATLAB

• Calculated the electricity sales profit, electricity forward payoff and CDD forward contract payoff

• Hedged the electricity profit using electricity forward and CDD forward contract by minimizing tail risk Style Analysis and Alpha Model Mar 2014- May 2014

• Performed style analysis to certain mutual fund in Excel, using 5-year rolling data

• Tracked the movement of the fund, drew style analysis charts and compared them with Morningstar style analysis c

• Separated alpha factors and risk factors by regressions and significance tests

• Constructed an alpha model and actively adjusted portfolio weight according to the alpha value

• Conducted an alpha model bias regression to test the value of the alpha model (R-square Test) EXPERIENCE

Willis- Shanghai, China Dec 2012- May 2013

Financial Team Assistant

• Analyzed business sales performance for sales managers and checked all the details of the transactions.

• Invoiced on average of 30-50 per day for sales managers of the whole company.

• Monitored all accounts receivable (on average 50 accounts receivables per day) and advised sales managers of possible delayed payments.

• Summarized the work progress and gave verbal reports to my boss.

• Used JP Morgan system to pay insurance online, and contacted with JP Morgan and Bank of China to complete transactions.

Standard Chartered Bank- Shanghai, China Aug 2012-Oct 2012 Priority banking Intern

• Recommended appropriate financial products to clients by determining their risk appetite.

• Assisted manager with the promoting and selling 5 financial products on average per day to customers.

• Analyzed financial markets, and advised clients to avoid possible risks, thus maximizing their profits.

• Contacted with clients every week to inform current returns of their financial products and give advice for adjustment. SKILLS

• Skilled with SAS and MATLAB

• Proficient in Excel, Word, and Power Point

• Speak Mandarin and English

ADDITIONAL

• Volunteered for Center for Economic Progress Jan 2014-Apr 2014

• Volunteered for Chicago Marathon Oct 2013

• Volunteered for Shanghai International Textile Expo Aug 2012



Contact this candidate