Data Assistant

YINAN YANG

linkedin.com/yinan.in/yang@yinan-yang utexas.• edu 512-***-****

EDUCATION

The University of Texas at Austin Master of Science in Information Technology and Management May 2019 Coursework: Advanced Data Mining, Cognitive Computing, Data Science Chongqing University Bachelor of Management Information Systems June 2018 TECHNICAL SKILLS

Python, SQL, HTML+CSS, Tableau, Django, Spark, AWS, TensorFlow, Excel Pivot Table, Kotlin, Microsoft Azure, Trello, A/B Testing WORK EXPERIENCE

Charles Schwab – Analyst Intern (Capstone Project); Austin, TX Spring 2019

• Deliver an end-to-end workflow and platform that provides a standard way to write and deploy model types, decreasing time-to- value, and increasing agility

• Read input data from csv, process input data using the PMML instructions, create predictions using offline model

• Send prediction outside application (response to request), log input features, prediction result and time it took to score the features

• Python and JAVA for model container, Spark for model service engine, Trello for team management Bain & Company – Part Time Assistant; Shanghai, China Winter 2017

• Conducted price sensitivity analysis of the clients in Beer industry using market data through Excel

• Supported managers with strategies of pricing products based on consumers' portraits, sizes of the retailers, competitors' promotion activities, interacted with customers, retailers, and managers

• Composed competitive product analysis of market through secondary data research, contribute to make the transformation decision of traditional retail industry to e-commerce platform Deloitte – Data Analytic Intern; Chongqing, China Spring 2017

• Labeled and classified customers based on their purchase frequency using Excel Pivot Tables and basic VBA

• Through Python and SQL, researched on the decision tree to classify the customers’ purchase intention and forecasted the future customers’ tendency

• Accuracy is about 95%, presented the report through Jupyter Notebook

• Built database structure to store users’ demographic information and generated product analysis using web analytics tools ACADEMIC PROJECTS

Transactions Database System Project Fall 2018

• Designed a database system to store employee personal information, internal transactions and monthly performance by DDL

• Achieved real-time internal scoring, trading and generated monthly and annual internal performance reports by DML, view, stored procedure and trigger

• MySQL for database, HTML/CSS for establishing the website and Django on Eclipse for connection Makeup • Scraped Review the comments Analysis of and 130,Recommendation 000 consumers on Project MakeupAlley.com about 470 cosmetic products using beautiful soap Fall 2018

• Developed customers’ preference analysis by analyzing customers’ concerns and product attributes through LDA Model, Cosine Similarity, Sentiment Analysis, and provided top 10 recommendation to users based on preference rank

• Composed competitive product and target market segmentation map through Engagement Score and Lift Clickbait Classification Project Fall 2018

• Converted raw text data to the vectors using Word2Vec and Glove, visualized the distribution of data through TSNE

• Implemented a text classification system based on LSTM plus CNN, reduced the time consuming and increasing the accuracy to 69% HONOR

Winner • • • Designed Established Generated of THE UI facial MySQL of 2019 web attributes UT database application – Charles analysis on based MS Schwab through Azure on Hackathon target SQL MS Server customers Azure - Moving and Cognitive built persona Beyond tables Service named using the Face Password Wendy DDL API in Authentication Spring 2019 In Class Kaggle Competition – Top 27% Fall 2018

• Observed data distribution through pandas and Matplotlib, explored feature engineering methods like PCA and linear embedding

• Predicted binary classification using lighgbm, evaluated model performance using AUC ADDITIONAL INFORMATION

Work Eligibility: Extended eligibility to work in the U.S. due to S.T.E.M. certification

Contact this candidate