Sales Social Media

Ellen Mengqi Xu

*** **** ******, *** ***, New York, NY 10044 Phone: 435-***-**** E-Mail: *************@*****.*** Professional Summary

Major in Data Analytics and work experience with top financial company (Interactive Brokers) and software company (Menusifu) in diverse- cultural environment. Comfortable in presentation of technical results and data insights to business audience. Familiar with program languages such as Python, R, SQL, Java and CSS; data visualization tools such as Tableau and Seaborn; Hadoop and Spark framework; cloud computing such as AWS and Salesforce; and operating systems such as Mac OX, Windows and Linux. Experiences

June 2018 till Now Menusifu Inc, New York, NY as a Data Analyst Intern

Implement scrapy framework and ParseHub applications to crawl restaurant information from advertising websites.

Research and present statistical prediction report on top 500 Chinese restaurants in US.

Create and operate PostgresSQL and NoSQL on AWS to store and syn sales data on cloud database.

Optimize sales calculation algorithms by programming on Excel VBA and pivot table.

Get familiar on company operations on Salesforce cloud computing. June 2016 till May 2017 Interactive Brokers LLC, Greenwich, CT as a Marketing Coordinator

Main responsibilities are promoting IB among Chinese social media and translating English financial technical analysis articles to Chinese.

Compared account applications between different brokers.

Researched and analyzed what top 500 Financial Advisor companies recommend to their customers and what services those FA’s would be interested in using.

Created IB entry on Baidu Encyclopedia and optimized brand zone and paid search listing on Baidu and 360 search engines. July 2013 till August 2013 Taian Shandong, China as a Salesperson

Sold summer shoes and sports clothes. Reduced company expenses by 5% through summer promotion activities. Sold out sports clothes successfully by applying creative marketing methods.

Gained profits for the company by analyzing and applying different pricing.

Designed new sales promotion strategies and finalized sales for brand campaigns. Projects

Chicago Divvy bicycle sharing system & weather information

Processed dataset by utilizing spark SQL and Hadoop MapReduce.

Designed and built analysis models such as random forest on weather dataset to predict key features influence traffic.

Imported folium to visualize Chicago traffic map at certain time and certain location. Wine review data wrangling analysis

Cleaned data and extracted features affect wine points by generating decision trees and SVM models.

Applied seaborn to visualize feature trends and manipulated Tableau to locate winery on a world map. Education

Master Degree

Fordham University New York, NY Major in Data Analytics 2017-2018 Dual Bachelors’ Degree

Dalian Nationalities University Dalian, China Major in Marketing 2011-2013 Dixie State University St. George, UT Major in Finance 2013-2016

Contact this candidate