financial analysis, marketing analysis, computational skills

YIYI BAO

******@********.***

*** **** *** ***., *** 6C, New York, NY 10025 917-***-****

Objective: Seeking an analyst position in financial industries EDUCATION

Columbia University, MS in Actuarial Science, GPA: 3.72, New York, NY Expected Dec 2015 University of Virginia, BA in Economics and Financial Mathematics, Charlottesville, VA May 2014 Related Courses: Financial Markets, Risk Management, Money and Banking, Derivative Securities, Theory of Interest Applied Linear Models, Stochastic Processes, Econometrics, Corporate Finance, Financial Accounting, Marketing EXPERIENCE

CITIC Securities Company Limited- Investment Banking Intern; Beijing, China Jun 2015 – Aug 2015 A leading investment bank in China

• Built a valuation model for the M&A target company in telecommunication industry using DCF analysis and comparable company analysis

• Contributed in the operation of CITIC Qihang Plan, the first experimental REIT in China and praised for the researches on the differences between the REIT in China and the REIT in the U.S.

• Determined the range of possible values for 30 stocks across several industries Asia Link Group, Inc- Financial Intern; Beijing, China Jun 2014 - Aug 2014 Privately owned investment holding / consulting company with more than 10,000 employees

• Evaluated client’s performance using comparable analysis with 5 different Excel models and effectively resolved data discrepancy

• Performed due diligence on an M&A target company with $400 million revenue in recycling covering 36 facilities in the U.S.

• Conducted valuation analysis for M&A transactions in value of $200 million in waste management industry

• Implemented new analytical software, Gleasy, to increase data reporting efficiency by 20% China Minmetals Corporation- Financial Intern; Beijing, China May 2013 - Jul 2013 Rank No.192 among the Fortune Global 500

• Forecasted revenue trends of 7 departments using R Programming Language

• Designed and developed business trip expenses tracking system for both sales and trading divisions using Excel

• Conducted cost-effectiveness analysis based on 5 year business trip expenses data using Excel and R Programming Language and submitted cost-saving proposal, reduced business trip expenses by 15% RELEVANT EXPERIENCE

Project: M&A Simulation- Columbia University, New York Mar 2015 - May 2015 Coordinated with other 3 teammates, I conducted WACC analysis to acquire the value per share for each of the company and used comparable analysis to determine the reservation prices. We conducted Monte Carlo Simulation for every M&A assumption among the firms and came up with the WACC and APV for each scenario using VBA. Combined with each firm’s background, we concluded the best M&A strategies for these firms and got full credit for our project. Project: Asset Valuation- Columbia University, New York Oct 2014 - Dec 2014 As the leader of a five-member-team in the asset valuation course project, I was in charge of team building, ideal consolidating, and project planning. The goal of the project was to provide a new portfolio that changes asset allocation from a 60:40 stock to bond to one that was entirely bond. We applied both Duration Matching method and Cash Flow Matching method to do this conversion using VBA and Excel. The result was highly praised by the professor. LEADERSHIP EXPERIENCE AND ACTIVITIES

Columbia University Chinese Student and Scholars Association- Department Director, New York, NY Sep 2014 - now

• Elected as the General Secretary and Director of on-site operation for the 2014 Columbia Chinese Prospect Conference with over 500 participants

• Led and Organized Mid Festival Gala and China Day and attracted over 2000 attendants University of Virginia Chinese Student and Scholar Society- Vice President, Charlottesville, VA Sep 2012 - May 2014

• Promoted Bank of America to raise funds of $2,000 per semester and 20% discount at 10 local restaurants for members SKILLS & INTERESTS

Skills: Actuarial Science( passed Exam P and Exam FM), VBA, R, SAS, MATLAB, Java, linear regression, Excel, PowerPoint Interests: First Place in the National Cheerleading Competition in Dancing, Tenth level in Playing Piano, Horse Riding

Contact this candidate