QINGYUE (SUE) SU

Santa Clara, CA ***** 781-***-**** admwdj@r.postjobfree.com [LinkedIn]

EDUCATION

Brandeis University Waltham, MA

Master of Science in Business & Data Analytics (STEM-Designated) 08/2019 - 05/2021 GPA: 3.8/4; Relevant Courses: Machine Learning (Python), Information Visualization (Tableau), Big Data (MySQL & R) Central University of Finance and Economics Beijing, China Bachelor of Science in Double Major (Finance & Economics and Management) 09/2015 - 06/2019 GPA: 3.6/4; Undergraduate Scholarship (Top 5%); Relevant Courses: Database, Linear Algebra, Probability & Statistics PROFESSIONAL EXPERIENCE

EFORTles Inc New York, NY

Data Analyst Intern 05/2020 - Present

• Optimized digital marketing campaign performance by extracting 430K+ viewer records from different social platforms like LinkedIn, YouTube, and established interactive dashboards in Tableau to track conversions and leads by different channels.

• Designed A/B tests on (call to action) CTA like the hashtag design and usage of photos or videos, which doubled the Click- Through Rate (CTR) and increased conversion rate by 50%.

• Built the machine learning model (SVM, KNN, and decision tree) by Python to automatically categorize the transaction type based on the description of the transaction with over 85% accuracy.

• Designed a real-time user form for data entry and a property window by Excel VBA to automatically extract the required data from SQL Server, which largely shortened the data processing time by 20% and increased the efficiency of daily internal control. KPMG Beijing, China

Analyst Intern 12/2017 - 02/2018

• Consulted with an E-commerce foodstuff company and provided business recommendations to improve its customer satisfaction rate.

• Performed sanity check for data consistency, cleaned outliers and dealt with missing/null values.

• Leveraged, and interpreted large datasets in SQL and Python to uncover key insights like the top 10 keywords of the five-star compliments and that of one-star complaints.

• Provided visualizations and recommendations on the next steps to business clients and helped them increase the net promoter score (NPS) from 33 to 56.

AIA Hong Kong

Marketing Data Analyst Intern 01/2016 - 02/2016

• Performed exploratory data analysis (EDA) like age structure, income level, gender distribution, destination country, traveling time length, claim amount, claim frequency, etc., and visualized the findings in Tableau.

• Collaborated with Engineer and product team to develop recommendation system based on user shopping behavior analysis from 300M customer data

• Summarized the insights in a report to presented with the email marketing team to design personalized emails to customers with high potential value, which increased the conversion rate by 20%. PROJECTS EXPERIENCE

Instacart Customer Behavior Analysis and Recommender Design [Project] Waltham, MA 10/2019 - 12/2019

• Implemented recommendation systems on inventory by analyzing 3M+ orders and 32M+ products record from Instacart.

• Leveraged and implemented large data set, performed the ETL process, and analyzed data utilizing SQL.

• Designed key metrics like daily purchases volume, purchase frequency, orders by hour of the day, number of reorders by- product.

• Built ML models to recommend the products for the targeted customer by using cosine similarity based on other customers who has the similar shopping behavior; Defined the metric (recall ratio) to evaluate the model.

• Visualized data to track customer reorder rate, average order value, etc.

• Presented the descriptive statistics, methodologies, and findings to stakeholders and translated insights to non-tech people. Other Projects: [Github]

ADDITIONAL INFORMATION

Vice President: Student Union, Central University of Finance and Economics, Beijing, China 09/2016 - 06/2018 Qualification: CFA Level II Candidate

SKILLS

Technical Skills: SQL, Tableau, Python (Matplotlib, Pandas, Numpy, Scikit-Learn), R, SAS, Looker, Microsoft EXCEL (VBA, Pivot Table, VLOOKUP), PowerBI, Hive, Hadoop, SPSS

Statistical Skills: Logistic Regression, Cross-Validation, K-Nearest Neighbors, Decision Tree, Random Forest, Neural Network, K- means Clustering, Dimensionality reduction

Contact this candidate