Accounting Microsoft Office

Ruokun (Queenie) Wang

*** ****** ******, ********, **, 06906 203-***-**** ******.****@*****.***

SUMMARY

Master degree in Financial Mathematics. FRM Quantitative method concentration.

Experienced with large data analyst. Skilled with different programing software, such as Excel VBA, Access.

Proficient with financial report (management metrics), risk management and different pricing models.

Familiar with Microsoft office Word, PowerPoint, Excel, VLookup and Pivot table.

Great Financial/Accounting and Tax knowledge.

EDUCATION

University of Connecticut, Stamford, CT May 2015

MS Financial Risk Management

Cumulative GPA:3.8/4.0

Finance Courses: Modeling, Risk Management – Equity Market, Risk Modeling – Fixed Income, US Capital Market, Legal & Ethics Issue, Excel VBA in FRM, Financial Programming and Modeling, Advanced issues in ERM – A Quant Approach

Tianjin Polytechnic University, Tianjin, China June 2013

Bachelor of Science in Accounting

Cumulative GPA: 3.7/4.0

RELATED EXPERIENCE

UConn Project Stamford, CT

Data Analysis for Arthance Company July 2014- December 2014

Analyzed the impact of quarterly earning announcements to investment decisions using S&P 500 companies as an analysis sample.

Used software Eventus to generate the financial report by comparing the real earning data and forecast earning data acquired from database. Using forecast report to identify the influence (including the risk and opportunity).

Validated the accuracy of the forecast data by using different statistical models.

Verified that unexpected differences in forecast and actual earnings affect only in a short period, the market will adjust in a short time to minimize differences.

Provided the advise according to the different industries for the company.

UConn Project Stamford, CT

Analysis of the Momentum Anomaly August 2014

Built pricing modeling (CAPM & Fama - French 3 Factor Model) through Excel and detected that the momentum anomaly was statistically significant in each regression analysis.

Enhance and improve the model by changing different parameters and using statistic methods to test the efficient.

UConn Project Stamford, CT

VaR and Stress Testing of Hong Kong Equity Market in 1997 Financial Crisis May 2014

Estimated the market VaR and Expected Shortfall by collecting the dataset 1992-2002 from Bloomberg.

Used Microsoft Excel to calculate VaR of both index and stocks. The models include RiskMetrics, GARCH, NGARCH, HS and FHS.

Analyzed the validity of VaRs under different models by QQ plot, t(d) distribution and EVT

Nanyang Commercial Bank (China) Limited., Qingdao Branch Qingdao, China

Intern: Desk Officer June 2012-December 2012

Drew bank acceptance bills and transferred discount bills and learned discount process.

Drafted corporate and individual loan contracts, using letter of credit in international settlement.

Processed money savings & withdrawal, financial product sales, certificate of deposit and other daily business.

Balanced the general ledger, conducted fund position and cost management.

Solved the ad hoc inquiries from different counterparties and intercompany teams.

LEADERSHIP EXPERIENCE

President of Accounting Club, Tianjin Polytechnic University, Tianjin, China September 2011-June2012

Organized students interested in accounting to take part in a series of accounting knowledge and skills competitions and other activities.

Invited professors, teachers, top students and Financial & Accounting professionals to give lectures on accounting topics.

Coordinated meetings between students and faculties to engage students in accounting study and the passing rate of accounting professional certification increased by 10%.

Work with the accounting company to provide the improvement plan in the accounting and tax area.

SKILLS

Computer: Microsoft Word, Excel VBA, PowerPoint, Access, Matlab, familiar with SAP, R and Bloomberg.

Languages: Basic knowledge of Cantonese, Bilingual in Mandarin and English.

Contact this candidate