Data Analyst Sales

XIN (ARIEL) YU

**** ********* ***, *** *** College Park, MD 20740

***.**@*******.***.*** 240-***-**** https://www.linkedin.com/in/ariel-yu/ EDUCATION

University of Maryland, Robert H. Smith School of Business, College Park, MD Dec 2017 Master of Science in Information Systems, Major GPA 3.31/4.00

• Creator (2017): Created a campus items website and migrated the data into AWS, achieved 300+ visitors Zhejiang University of Finance & Economics, School of Information, Hangzhou, China Jun 2015 Bachelor of Management, Major in E-business, Minor in Accounting, Overall GPA 3.91/4.00

• Vice President, E-commerce Association of School of Information (2012-2015): Represented the school at official functions during 30+ activities events, cooperated with 3,000+ students organized

• Social Work Scholar (2011-2015): Selected among the top 5% of 5,000 students for social achievements

• Author (2015), Published Problems and Solutions in E-commerce Accounting in Knowledge Economy TECHNICAL

• Data Analyst with R Track Certificate, Joining Data in PostgreSQL Certificate

• Proficient in R, R studio, MySQL, PostgreSQL, HTML & CSS, Dreamweaver, MS Office

• Advanced in Python, Django, Hadoop, Hbase, Hive, Spark, Amazon Website Service (AWS)

• Experienced with Tableau, Salesforce, MS project, Agile Methodology, Photoshop, InDesign EXPERIENCE

Paradyme Management Inc., Greenbelt, MD Sep 2017 – Present Corporate Technical Analyst Intern

• Increased the resume screening efficiency by 30% through designing a website and visualizing the data

• Managed a 50+ entities’ database by writing Queries in MySQL, improving retrieval efficiency by 25%

• Attended Agile Scrum meetings to response the daily effort, resolving 52 changing requirements for users Lan Xi Technologies Co. Ltd., Beijing, China Jun 2017 – Aug 2017 Data Analyst

• Explored 3,000+ data to modify business strategies using Regression and Decision Tree in R Studio

• Connected MySQL with R Studio to generate relevant indexes to simplify the calculation of different growth indicators, which saved 25% search and calculation time

• Designed a text classification model to classify daily online news, dealing with 5000+ training dataset of 87.9% identification and 73.2% overall classification rate University of Maryland, College Park, MD

Big data of Allstate Consumer Purchase Prediction Project Jan 2017 – May 2017

• Gathered and classified a dataset with over 665,000 records in Hadoop, reducing 35% management time

• Evaluated the best model- Decision Tree in pyspark with 75% accuracy rate in the three candidate models

• Analyzed the customer purchase history and produced marketing solutions for all Allstate’s 7 insurance packages, which guide the potential customers to new customers House Sales Prediction Project Jan 2017 – May 2017

• Adjusted house sale price using Classical Decomposition method, improving sales volume by $400,000

• Cleaned and tided 21,207 data by executing GGally in R through replacing missing values, dropping off the unrelated variables and dummying categorical variables ADDITIONAL

• Volunteer: Volunteered 50 hours to re-design and implement interior decoration for School Study Room

• Interests: Badminton, Swimming, Running, Travelling, Cross-stitch, Chinese Cuisine

Contact this candidate