Post Job Free
Sign in

Sales Data Analyst

Location:
Los Angeles, CA
Posted:
December 04, 2017

Contact this candidate

Resume:

Siyuan Liang

Cell Phone: 765-***-**** Add: *** N Alameda apt212w, 90012 E-Mail: ***.***********@*****.*** Education

University of Southern California, Los Angeles, CA Aug.2015 - May 2017 Master of Science Major: Mathematics Finance

Relevant courses: Stochastic Process, Risk Analysis, Trading & Exchanges, Mortgage and MBS, Time Series. Purdue University, West Lafayette, IN Aug.2011 - May. 2015 Bachelor of Science Majors: Actuarial Science & Applied Statistics GPA: 3.3 Minor: Management Relevant courses: Portfolio Management, Managerial Accounting, Time Series, Linear Regression Core Qualifications

• Independent problem solver, love challenges, CFA level 1 Passed. Advanced Excel/SAS user.

• Strong interest in Financial markets. A fast learner with career integrity. Work Experience

Business development of MBI, Los Angeles May. 2017 – present

• Focused on business to business sales, communicating and connecting both Chinese and US clients in metal material industry.

• Attended Expos’ as sales for Chinese suppliers, developed relationships with clients, and assisted to signed contacts.

• Researched, and created reports about FDA policies or US pharmaceutical/nutrition products markets for Chinese Biotech company client.

• Operated a started-up company, from registration to tax reporting process, and team formation. Data analyst, USC Viterbi Engineering, Los Angeles Oct. 2016 – present

• Merged, created usable large databases in Excel, and used STATA to do data analyses and data immigration.

• Applied Structural Equation Modeling, Linear Regression for behavior analysis, developed survey and statistical tests plan.

• Drafted review reports for research paper and generated the summary chart and narrative paper. Icon Union leadership, Los Angeles Nov. 2015 – Nov.2016

• Co-directed the After Dark parties in LA, NYC, and SF. 15% return within 2 months of event preparation.

• Coordinated with sponsors and suppliers, followed up details and took responsibilities for the whole event.

• Help with sales team to promote our event, and sell the tickets and package to students through student associations in Southern California campuses.

Rotated Intern, Ming Sheng Bank, China Summer 2014

• Widely used Excel pivot table to digest the raw data of sales quarterly performance.

• Worked on reports of varies properties, used Excel models to get cap rate, LTV, etc.

• Make comparison table of financial ratios of client companies, such as P/E, Debt/equity, etc. Activities & Leadership

Rap Composer

• Hip hop enthusiast, writing raps for more than 6 years.

• Self-studied music production softwares Cool Editor and Logic pro x, produced my own music album. Favorite books

“The Big Short” “The Intelligent Investors” “Lairs Poker”



Contact this candidate