Accounting Data

Guodong Wang

** ***** ***** ****, ******* Viejo, CA 92691 *************@*****.*** 949-***-****

EDUCATION

University of California, Los Angeles Expected Graduation Date: June 2019

Economics (B.A.)

Cumulative GPA: 3.2/4.0

Award and Honors: Berkman Scholarship

RECENT COURSEWORK

Accounting, Money & Banking, International Finance, Industrial Organization, Macroeconomics, Microeconomics, Finance, Econometrics, Financial Econometrics

TECHNICAL SKILLS

Programming: Proficient – R, SQL Familiar – C++, HTML, CSS & JavaScript

Economics: Regression, Hypothesis Testing, Accounting

Data Visualization: Tableau, Power BI

SELECT PROJECTS

Accounting Group Project

Work auditors for the company “Slim gym.” Present adjusted entries in good form in an Excel workbook with detailed computations and schedules to support the journal entry. Create a set of financial statements with Excel.

Stock Valuation Project

Retrieve stock price data from Yahoo Finance. Analyze financial statements and evaluated the price of stocks using the dividend discount model / discounted cash flow model. Compare calculated stock prices and NYSE stock price.

Portfolio Risk &return

Compute monthly returns and S.D. of monthly returns of stocks from the portfolio. Create a plot of annual standard deviation (volatility) on the x-axis and average annual return on the y-axis. Plot and compare the data points (Volatility, Return) for portfolios from the same time period of T-bill, Corporate bond, S&P 500, Small Cap stocks.

WORK EXPERIENCE

Costco Wholesale, stocker, Dec 2015– Dec 2015

• Stock and straighten merchandise for sale in the warehouse.

• Clear and clean aisles and dispose of discarded trash and plastic wraps in compress machines.

• Assist other crew members with other duties.

Olive Tree Chinese Kitchen, host, waiter & cashier, June 2017- Sept 2017, June 2018 - Sept 2018

• Increase guest check by suggestive selling and promoting items with high-profit margins

• Experienced with the restaurant POS operating system and online orders system

• redesigned and Improved menu with the owner together

• Success multitasking while remaining professional and courteous in the fast-paced and pressured environment

Contact this candidate