Yazhuo Gao


About Me

Pursuing a summer 2023 internship that will allow me to leverage the programming and analytical skills I am learning in my MS program.

Location

Los Angeles, CA
Beijing, People's Republic of China
Education
    University of Southern California
    January 2022 - December 2023
    degree
    Master's
    majors
    Applied Analytics
    Data Analytics
    Stony Brook University, SUNY
    August 2017 - May 2021
Work Experience
    Diamond Equity Research
    Data Analyst Intern
    New York City, NY, United States, 10075
    July 2021 - August 2021
    company
    Diamond Equity Research
    title
    Data Analyst Intern
    overview
    • Performed detailed research with Porter’s Five Forces to examine the competitive landscape of the E-Commerce industry, identified key comparative strengths and weaknesses in the market positioning of the client’s primary competitors • Examined the company’s organizational structure and business model, pinpointed the key revenue and cost drivers as well as the product type that led to the most significant revenue fluctuations • Collected historical stock price of a public company in the past three years, built trend line charts in R to examine the underlying seasonality behind price fluctuations, and leveraged multiple linear regression to quantify the relationship between short-term Earnings per share (EPS) and various macro-and micro-economic inputs • Performed scenario analysis to examine the impact from external shocks including COVID-19 and regulation changes on downside and bankruptcy risks, proposed customized investment strategies based on dividend yield prediction • Built discounted cash flow models to determine company value and prepared preferred due diligence reports regularly
Skills
Languages
ChineseEnglish
Technical skills
pythonrsql
Skills
Arena Simulation SoftwareMicrosoft Excel,Microsoft Word,Outlook,SharepointSAP
Volunteer
    Los Angeles Regional Food Bank
    October 2022 - October 2022
Hobbies
Traveling
Sketching
Skiing