GUANG (EMMA) YANG
**** ****** ***., ****** ****, CA 91303
818-***-**** / acvxgh@r.postjobfree.com
http://www.linkedin.com/in/emmaguangyang
EDUCATION
Pepperdine University, Graziadio School of Business and Management, Malibu, CA Master of Science in Applied Finance, Investments, GPA:3.57 August 2015 – August 2016
• CFA Level I Candidate
Shanghai University of Finance and Economics, Shanghai, China Bachelor of Science in Business Administration, Logistics Management September 2011 – June 2015
• Leadership: President of “Odyssey of the Mind” Club, Secretary in Charge of Personnel Department
• Clubs: Member of Venture Creation Center Association
• Volunteering: Donation and Library Volunteer Activities RELEVANT FINANCE COURSEWORK
Financial Modeling, Pepperdine University, Malibu, CA April 2016 – June 2016 The course applies functions and VBA procedure in Excel for modeling.
• Applied V-Lookup, VBA, What-if analysis and other techniques to design and develop cash flow analysis, valuation, amortization and loan payment analysis, and other financial models
• Given complex rate or principal scenarios, calculated different returns or payments and made financial decisions Finance, Pepperdine University, Malibu, CA August 2015 – December 2015 The course covers various financial tools to analyze company performance and make investing decisions. General Electric – Group Project
• Utilized discounted cash flow models to forecast expected free cash flow over a five-year period
• Calculated an optimal Weighted Average Cost of Capital to construct company’s capital structure
• Concluded investment decisions by calculating and comparing company’s liquidity, profitability and solvency financial ratios with competitors
Advanced Financial Accounting, Pepperdine University, Malibu, CA January 2016 – April 2016
• Reviewed company’s financial reporting and produced vertical and financial ratio analysis
• Analyzed company’s inventory, A/P and A/R, and prepared financial statements according to company’s business transactions
EXPERIENCE
Estée Lauder Company, Shanghai, China September 2014 – February 2015 An American manufacturer and marketer of prestige skincare, makeup, fragrance and hair care products. Market and Brand Intern in Jo Malone London
• Gathered data to analyze industry trends and deliver business analysis, and provided customer feedback data analysis monthly to manage customer relationship using spreadsheets
• Prepared billing and expense summaries to ensure that all invoices and staff reimbursements were paid accurately
• Managed product purchases and payments process in SAP system
• Coordinated and worked with various departments to assist with store-opening and product promotion
• Produced monthly sales memorandums, updated store calendars and assisted with employee training Kimberly-Clark Corporation, Shanghai, China April 2014 – August 2014 An American personal care corporation that produces mostly paper-based consumer products. Business Analyst Intern
• Participated in conversions, maintenance and development projects, and conducted data analysis in Excel for senior management
• Interacted with external vendors to ensure payments and purchases process using SAP system
• Updated product information in product database and official website back end
• Performed daily support for business operations and market promotion China Everbright Bank, Shanghai, China January 2014 – April 2014 A financial services company in asset management, direct investment, brokerage and investment banking in the China. Financial Analyst Intern
• Obtained and reviewed financial statements, checked credit reports, entered data and performed collateral analysis
• Provided business unit support for financial analysis ADDITIONAL
Languages: Bilingual English/Mandarin Chinese
Computer Skills: Excel (PivotTable, V-lookup, VBA), Word, PowerPoint, Data Analysis, Modeling, Fast Searching Awards: The First Prize in National High School Chemistry Olympiad Competition (2010)