Data Analyst Sales

Yuan (Sophia) Sheng

******.****.*****@*****.*** 206-***-**** linkedin.com/in/yuan-sophia-sheng

EDUCATION

Northeastern University Washington, United States

Master of Science in Business Analytics (STEM-Certified Program), GPA: 3.96 / 4.00 01/2020 – 07/2021 Coursework: Predictive Analytics, Data Visualization, Data Mining, Machine Learning North China University of Technology Beijing, China Bachelor of Accounting, GPA: 3.76 / 4.00 09/2011 – 07/2015 PROFESSIONAL EXPERIENCE

JD.com (China’s Largest E-Commerce Company) Beijing, China Data Analyst Intern 08/2020 – 11/2020

• Executed daily scheduled SQL pipelines based on 20+ business tables and developed new analytical tables to provide validated and credible data with the operation team and meet different internal business analysis requirement.

• Developed automated report processing by coding reusable SQL queries under SSIS from multiple Oracle databases. Reduced 25% of the time cost for entire workflow.

• Created Tableau dashboards with 7000k+ order data to analyze weekly and monthly trends of KPI. Increased customer engagement by 12.5% in collaboration with the operation team.

• Utilized ETL and Python to extract and wrangle history order data, created user personas with interactive graphs. Discovered about 15% of high-value customers based on RFM Customer-Value model. Da Hua Certified Public Accountants (China's Top Ten Largest Accounting Firms) Beijing, China Financial Business Analyst, 2017 Annual Company Excellent Staff 07/2015 – 10/2018

• Worked on the profit and loss (P&L) statement, financial ratio and trend analysis, and constructed financial models in Excel to facilitate strategic planning and predict future performance.

• Directed clients to enhance performance, through expense control, new revenue sources and reduced employee turnover, which yielded 30% sustainable income improvement.

• Interacted with clients to help stakeholders evaluate financial status and investment potential through due diligence.

• Wrote and optimized VBA codes to improve efficiency of sample data collecting by 25%. China Futures Association (National Self-Disciplinary Organization of Futures Industry) Beijing, China Statistical Analyst Intern 04/2015 – 06/2015

• Analyzed operation results from over 300 futures companies and performed futures market research analysis on turnover and transaction volumes through 5 futures exchanges to disclose information for the public.

• Wrote and published monthly transaction reports on the official website. PROJECT EXPERIENCE

Financial Anomaly Detection and Risk Analysis Seattle, WA

• Developed a machine learning model in Python to predict fraudulent transactions and build a real-time alert system to prevent fraudulent activities.

• Performed exploratory data analysis on 138k+ transactions data by removing duplicates, encoding categorical features and handling imbalanced labeled data by SMOTE.

• Built Logistic Regression and Random Forest Models, evaluated the models via 10-fold cross validation, found optimal model parameters via grid search, and selected the best model based on AUC (best AUC 79.05%). Banking Customer Churn Prediction and Analysis Seattle, WA

• Designed algorithms for telco service vendors to predict customer churn probability based on labeled data in Python.

• Preprocessed data set by data cleaning, categorical feature transformation and standardization, etc.

• Trained supervised machine learning models including Logistic Regression, Random Forest and K-Nearest Neighbors, and applied regularization with optimal parameters to overcome overfitting.

• Evaluated model performance of classification (accuracy 85.92%) via k-fold cross-validation technique and analyzed feature importance to identify top factors that influenced the results. Costco Wholesale Sales Analysis (https://github.com/tuling-meiyuan) Seattle, WA

• Led a team to pretreat 830k+ sales data from 2018-2019 through data cleaning and transformation in R and Tableau.

• Developed 20+ Tableau dashboards to provide corporate leaders in a retail chain with answers of 6 business problems and suggestions, including product brand, returns, sales, inventory, warehouses ranking and correlation analysis. TECHNICAL SKILLS

Programming: SQL, Python, R, Tableau, PowerBI, Java, VBA Certifications & Training: Advanced Google Analytics Certificate, Chinese Certified Public Accountants Certificate

Contact this candidate