Excel, Stata, PowerPoint, SQL, Python, R Studio, Tableau, Visio, Bloom

HAO GU

Phone: 202-***-**** E-mail: *********@*****.***

LinkedIn: www.linkedin.com/in/hao-gu-0914a1179

EDUCATION

American University, Kogod School of Business Washington, DC

Master of Science in Finance September 2020 to May 2022 Master of Science in Business Analytics (STEM)

GPA: 3.50/4.0

American University, Kogod School of Business Washington, DC

Bachelor of Science in Finance September 2016 to May 2020

GPA: 3.32/4.0

CFA Program Candidate, CFA Institute

EXPERIENCE

DingLi Cranes Jiangsu, China

Business Analyst Intern May to August 2018

Assessed enterprise financial risks through Monte Carlo simulation in Stata and Excel, helped Finance team to estimate loss and allocate capital for it.

Developed daily cashflow and balance sheet reports with the Accounting team to monitor the key financial metrics and supported the budgeting process.

Built a time series model to forecast the future crane sales with Holt-Winter approach in Excel and Stata, presented to CEO and CFO, got validated and eventually adopted in day-to-day operation.

Bank of China Jiangsu, China

Finance Intern May to August 2017

Established a data automation process using Python and Excel to monitor the quarter over quarter change in credit risk capital for the Risk Management department.

Performed financial project research on loan distribution based on the credit report and risk-adjusted returns of client companies.

Worked with senior financial advisors on wealth management and portfolio analysis using various financial models, such as VAR Calculation.

PROJECTS

Student Managed Fund

Led a group of 12 students and managed a one-million-dollar fund and outperformed the S&P 500 index by 721 basis points from September to December in 2020.

Studied corporate valuation models (Multiples and DCF), valuation of M&A Transactions, Leveraged Buyout Transactions and Real Option Valuation.

Quantitative Methods in Finance

Used regression analysis and time series in Stata and conducted different quantitative research by pulling the data from WARDS and FRED databases.

Finished a research project to study the relationship between corn price and stock price movement through regression analysis.

ASSETS

Skills: Excel, Stata, PowerPoint, SQL, Python, R Studio, Tableau, Visio, Bloomberg Terminal

Interests: San Antonio Spurs (NBA), Formula One, Japanese Food

Contact this candidate