Linyan Dai

530-***-**** adfxbf@r.postjobfree.com St. Louis, MO LinkedIn GitHub

P R O F I L E

A fast learner; have innovative thinking and able to thrive in a challenging, fast-paced, and hectic environment. Skills: SQL, ETL, Python, R, Tableau, Spark, Excel, MongoDB, Neo4j, AWS, GCP, Java, C++, Access, SharePoint E D U C A T I O N

University of California, Davis San Francisco, CA

Master of Science, Business Analytics Aug. 2019 – Jun. 2020 Highlighted Coursework: Data Management, Data Visualization, Big Data Analytics, Machine Learning, Cloud South China University of Technology Guangzhou, CHN Major: Bachelor of Science, Economics / Minor: Computer Science Sep. 2015 – Jul. 2019 P R O F E S S I O N A L E X P E R I E N C E

Data Analyst, Practicum Project - Packsize Sep. 2019 – Jun. 2020 San Francisco, CA

• Created a tool pack based on analysis of their experimental data and implement a data pipeline for data analysis. Helped Packsize quantified each attributes’ effect and hierarchy on their machine success rate

• Simulate part of the data and combined information scraped from Amazon as a placeholder for real experiment data via Python since the experimental data is not ready

• Apply statistical theory and machine learning techniques along with visualizations tools (Tableau and Flexsim) to provide data analysis on the results

• Drafted a user guidance for our tool pack and written a whitepaper for publication Data Analyst Intern - Ounian Technology Dec. 2018 – Aug. 2019 Guangzhou, CHN

• Extracted user data from the transactional system to ODS using SQL and cleaned a large amount of incomplete, wrong, and duplicate data

• Incrementally checked on updated data and store them into the data warehouse

• Explored user behavior from the data and improved user conversion rate Business Analyst Intern - Anheuser-Busch InBev Apr. 2018 – Dec. 2018 Beijing, CHN

• Conducted market surveys for new products, interviewed manager of the product, collected information from social networking platforms and securities companies and then stored the data into a database

• Performed cross-analysis on age, agender, etc. and purchase intention, estimated market shares for targeted products and competitive set using SQL queries and regression modeling

• Landed on an acclaimed marketing strategy and provided a written report with convincing visualization Assistant to Branch Manager - China Galaxy Securities Mar. 2017 – Apr. 2018 Beijing, CHN

• Set up indicators needed for further analysis, built tables of information related to convertible bonds extract from database using SQL queries and updated whenever needed

• Conducted analysis over the data to help the manager make decisions based on results

• Interact with customers to provide and process information in response to inquiries and requests P R O J E C T S

Venmo Social Network Analysis: Spark + Python May. 2020

• Utilized text analytics on messages and social network analytics on users’ network with SQL queries

• Predicted user’s behavior using information extracted using machine learning techniques Hackathon - COVID-19 Challenge: Natural Language Processing on Twitter (Second Place) April. 2020

• Scraped trend #StayHome, performed topic modeling and conducted sentiment analysis on each topic

• Use topic and bag of words to conducted Lasso regression and performed visualization to provide guidance that can shift public behavior to mitigate community spread with Python Natural Language Processing on YouTube ‘Tasty’ Channel to Predict Views: Python Mar. 2020

• Web scrapped videos’ title, subtitles, comments description, length, likes, dislikes and views of the

‘Tasty’ channel and integrate all data into MongoDB

• Performed topic modeling on comments and bag of words for subtitles and description to predict Views

Contact this candidate