Haoxin Yu (Peter)

adv599@r.postjobfree.com New York, NY 10025 917-***-****

EDUCATION

Columbia University, New York, US Sept 2022 - Present MS in Applied Analytics; GPA 4.0/4.0

Relevant Coursework: Python for Data Analysis, Storytelling with Data, Analytics Frameworks and Methods Duke University, Kunshan, China/Durham, US Sept 2018 - May 2022 BS in Data Science; GPA 3.7/4.0

Relevant Coursework: Machine Learning, Numerical Analysis and Optimization, Interdisciplinary Data Analysis, Data Structures PROFESSIONAL EXPERIENCE

Lenovo Group Co., Ltd. - Market Intelligence Analyst (Intern); Beijing, China July 2021 - November 2021

• Assessed market size, growth trends, key players, competitive products, and potential opportunities in the accessories market and smart wearables market including 8 categories, and composed over 10 market research reports

• Visualized, and analyzed PC market historical/forecast data in 5 categories, including segment, geo, product category, company, and business size; Used Qlik Sense and Power BI, and presented data analysis results into reports

• Performed analysis of the business model, strategic adjustment, profitability, and profit forecast grounded on competitors'/suppliers' earnings reports, explored correlations among 4 financial indicators via Python

• Updated PCSD Strategy weekly newsletter on areas of PC core, core growth (such as gaming, accessories, OEM, etc.), and incubation (such as AR/VR, smart edge, etc.)

Volvo Group - Sales Operation (Intern); Beijing, China May 2021 - July 2021

• Carried out data cleaning, and analysis of storage/logistics information of 3 company's storage areas in Shanghai including the order number, vehicle models, put-away time, delivery time, delivery destination, and price

• Managed to avoid paying tens of thousands of RMBs in duplicate or questionable fees and pay off vendors' bills been stuck for nearly a year

• Designed 3 algorithms and uniform templates, later allowed to be in use, to support the team in reducing complexity and time for data entry, searching storage/logistics information, and budgets calculation Deloitte Consulting LLP - Management Consulting Analyst (Intern); Beijing, China September 2020 - January 2021

• Analyzed Chinese online education industry's market size, and growth trends; 3 market main players' business model, profits, and app function; Conducted competitive analysis report (Strategic consulting project of a top education group)

• Assessed 6 industry-leading companies' business models, core competence, organization structure, technology, financial analysis, and KPI assessment mechanism (Management consulting project of a state-owned industrial group)

• Investigated management mode of 2 benchmark enterprises in the retail industry, assisted in putting forward proposals for a new intelligent retail system and supply chain system (Management consulting project of a sports goods MNC company) RESEARCH EXPERIENCE

SciEcon Research Center - Research Assistant; Jiangsu, China August 2021 - April 2022

• Simulated construction of RepRisk ESG Rating based on over 500k historical data, discovered the relationship between its letter grade and scaling score, mathematical formula for calculation; The report was published on SSRN

• Quantified and visualized Miner Extractable Value through arbitrage trading on Ethereum Blockchain, operated SQL and Python API to crawl, clean, and analyze over 300k data, extended the research objects to 6 decentralized exchanges The Price Prediction of Ethereum Uni Token Project - Data Analyst; Jiangsu, China March 2021 - May 2021

• Predicted future price of Ethereum UNI token based on 2000k historical transaction data, our model’s RMSE was 2.07

• Utilized Python Networkx, Plotly to build and visualize transaction network; Used LSTM, CNN, and 4 other customized machine learning models to predict price; Identified log-difference method to solve the time-lagging problem

• Presented research at 2021 International Conference on Data Mining and Statistical Applications (DMSA 2021) COMPUTER SKILLS AND INTERESTS

Python SQL Tableau Microsoft Suite (Word, PowerPoint, Excel) R JAVA MATLAB Qlikesense Tennis Beijing Opera