Derrick Mengyan Yao
yaomengy@usc.edu / GitHub / LinkedIn
Master Student at the USC Viterbi School of Engineering, University of Southern California
Educational Background
University of Southern California Los Angeles, CA
Master of Analytics Expected in May.2024
University of California, Santa Barbara Santa Barbara, CA
- Bachelor of Arts in Statistics and Data Science GPA:3.44/4.0 Dec. 2022
- Major Courses: Financial Accounting, Data Science Principle, Python, Differential Equations, Probability & Statistics, Vector Calculus, Trans Higher Math, Microeconomics, Regression Analysis, Time Series
Professional Experience
Capgemini China May.2021-Jul.2021, Shanghai,CN
Consultant Assistant, IT Consulting Department
- Participated in the supply chain project for an automotive IoT solutions, assisted the consultant to organize the background port code file, and wrote java markdown
- Employed a collection of visualization techniques including conventional charts, funnel visualization, visiting path diagrams and heat maps to guide customer experience optimization
- Involved in the sales management platform project for a world-leading cosmetics company, conducted Python programming, analyzed the code and wrote the program flow chart
- Communicated with clients to obtain the required data and clients’ need
Shenzhen Astra IOT Technology Company Sept.2020-Dec.2020, Shenzhen, CN
CEO Assistant
- Participated in the exhibitions, collected solutions about artificial intelligence security system, compared and analyzed the advantages and disadvantages of products from different suppliers
- Assisted the engineers to test the face recognition algorithm of edge server by Java
- Communicated product requirements with customers and got solutions from engineers, confirmed the production plan with system manufacturing company
Academic Projects
Course Project: Application of ARIMA Model on Prediction of Dow Jones Industrial Index (PSTAT 174 Time Series) Dec. 2021
- Selected the data set from the R package “TSDL”, the average weekly closing price of the US Dow Jones Industrial Index from July 1971 to August 1974, with 162 observations
- Used the “T-series” package of R language to establish the ARIMA model for the weekly average closing price sequence of the Dow Jones Industrial Index
- Drew ACF and PACF diagram to determine the order of the model
Research on Mobile Phone Brand Choice Tendency and Influencing Factors in China Jun.2018-Sept.2018
- Designed a questionnaire and get 200+ valid questionnaires by sampling survey
- Analyzed the impact factors of mobile phone brand selection by R, using descriptive analysis, factor analysis, and regression analysis
Skills
Programming and Software: R, Java, Python, HTML, SQL, SAS, Arena