Xia Xiao_Resume
no image
Location: Cleveland, OH, United States
School: Case Western Reserve University
Major: Finance

Xia Xiao_Resume

Case Western Reserve University Cleveland, OH
Master of Science in Management, Finance, May 2018
• Risk Management Track
• GPA:3.62/4.00
• Course Highlights: Empirical Finance (SAS), Financial Modeling (Excel Macro), Application in Big Data (Python)

Bachelor of Arts, June 2016
• Accounting and Finance
• GPA: 3.51/4.00
• Awarded First-Class Scholarship for 2 times (1% highest student award)
• Course Highlights: Financial Report Analysis, Statistics I&II (STATA), Data Analysis and SPSS Application

ROLAND BERGER Shanghai, China
05/2017 – 08/2017 Summer Analyst Intern, Marketing Research
• Led a four-intern group interviewing 158 retailers/consumers in the underwear industry within four weeks, completed market share and growth data for 10 underwear manufacturers
• Analyzed business performance, competitive ability and market growth for a global leading confectionery manufacturer, collected supporting data through interviews, desk researches and cold calls

03/2016 – 08/2016
CITIC Securities Beijing, China
Investment Banking Intern
• Conducted due diligence of a contact lens company, looking into management profiles, 5-year financial and product portfolio
• Complied companies financials from Capital IQ, and prepared the valuation analysis using FCFF Model in Excel spreadsheet
• Searched for expansion opportunities in logistics and chemical industries for a firefighting equipment company, which resulted in a potential of 12 projects and an expected market share growth of 3%

Invest Strategy on Target Corporation Spring 2017
• Collaborated with four teammates to build a domestic equity portfolio comprising different indices that will in most instances outperform the S&P 500 Index
• Combined three methods, which were traditional diversification, risk budgeting, goal-based methods to the portfolio construction
• Ran analysis under different objective functions in SAS environment, and found out the optimal portfolio by using the competitive analysis method
• Performed the final presentation in 6 minutes by using Prezi skills

• Active Member: Directed and organized the Country Dance Party and monthly Happy Hour in Graduate Student Council
• Volunteer: God’s Love We Deliver, NYC, 2016
• Lead Dancer: Performed the dance at the Weatherheadless Halloween Event
• Professional Certifications: SAS Certified Advanced Programmer for SAS9
• Computer Skills: Advance Excel; Python; R; SAS; VBA; Bloomberg terminal; Tableau

Financial Analyse, Data Analyse, Consulting, SAS, Excel, Intern