Sales Data

Jingjing(Jane) Xie

425-***-**** *********@*****.*** jingjing-xie-050a5b177 Redmond, WA

SUMMARY

Master student who aims at finding data analyst, with sufficient experience in data analytics, data visualization and machine learning. Strong knowledge of statistics and solid programming skills in Python and SQL. EDUCATION

Northeastern University Seattle, WA June 2020

Master of Science in Data Analytics GPA: 3.8/4.0

• Coursework: Probability and Statistics, Machine Learning, Data Warehousing and SQL University of International Business and Economics Beijing, China July 2015 Master of Science in Finance GPA: 3.4/4.0

Qu Fu Normal University Shandong, China July 2012

Bachelor of Science in Economics GPA: 3.5/4.0

SKILLS

• Programming: Python(Pandas, Numpy, Sklean, Pyspark), SQL, R, JavaScript

• Machine learning: Classic & Penalized Regression Method(Lasso, Ridge), Decision Tree, Random Forest, K Nearest Neighbors, PCA

• Statistics analysis: Hypothesis Testing, A/B testing, Text mining, Time analysis

• Software & Tools: Spark, MySQL, Tableau, AWS (S3, Athena), GCP big query, Advanced Excel WORK EXPERIENCE

Kaitong Financial Information Services (Beijing) Co., LTD. Beijing, China Operation Manager Mar.2015 - Mar.2017

• Built and managed each project’s data books, analyzed each client’s sales performance and trend.

• Performed annual, quarterly and monthly analysis to support recommendation to marketing team, including products, revenue and customer analysis.

• Managed the full life cycle of a project and ensure the project is completed successfully from beginning to end aligning with client’s business strategy, goals and vision. Yinhua Fund Management Co. Ltd. Beijing, China

Marketing Analyst Intern Mar.2014 - Oct.2014

• Collected and analyzed product data and sales data for each sales region.

• Prepared and performed sales performance analyses to sales team, including sales and cost structures, KPIs.

PROJECTS

Costco Sales Data Analysis with Tableau

• Analyzed sales data for Costco stakeholders to track key performance indicators(KPI) and provided recommendations on sales and stock strategies with Tableau.

• Preprocessed 106+K raw sales data including dealing with missing values and data transformation.

• Performed exploratory data analysis to identify sales trend, popular items, most returned items in each region with visualizations.

• Created a dashboard to present the sales performance; provided stock recommendation and sales strategies for warehouse in each region based on popular items and sales trend. Movie Recommendation Engine Development in Apache Spark

• Built data ETL pipeline to analyze movie rating dataset and conducted Online Analytic Processing(OLAP) with Spark SQL.

• Trained the Alternative Least Square(ALS) model with 100K ratings data to predict the movie ratings via Spark UI on AWS.

• Tuned model hyperparameters by grid search via 3-fold cross validation with RMSE (0.72).

• Provided user based movie recommendation and identified similar movies to a specific movie. Financial Anomaly Detection and Risk Analysis

• Developed machine learning models in Python to predict fraudulent transactions and built an alert system to prevent fraudulent transactions.

• Performed exploratory data analysis on 135+K transactions data and preprocessed data set via data cleaning, encoding category data and re-sampling imbalanced data with SMOTE.

• Trained logistic regression and random forest models and tuned model parameters via grid search to optimize F1 score.

• Selected the best model based on F1 score and built an alert system to prevent fraudulent activities.

Contact this candidate