Python SQL Developer, R Studio, Sas Jmp, Tableau, Microsoft Project

YIXUAN LU

adh0jr@r.postjobfree.com 203-***-**** ** Prospect St. Apt 6J, Stamford, CT 06901

OBJECTIVE

Enthusiastic and talented individual with strong data science background and business analytics skills seeking the position of [Data Analyst/ Business Analyst/Data Scientist, Analytics]. Bringing outstanding academic and project experience in analyzing, modeling, programming and interpreting data to help company and clients achieve goals and exploit opportunities. EDUCATION

University of Connecticut, Stamford, CT Sep 2019 - Dec 2020 (expected graduation) Master of Science, Business Analytics & Project Management GPA: 3.86/4.00 3 years of work authorization through STEM-extension OPT Chongqing Technology and Business University, Chongqing, China Sep 2015 - Jun 2019 Bachelor of Business Administration, Accounting GPA: 3.80/4.00 SKILLS

• Tools: SQL Developer, R STUDIO, SAS JMP, Tableau, Microsoft Project, SAS Studio, JUPYTER Notebook, SAS, GitHub

• Languages: Python (Scikit-learn, Pandas, NumPy, SciPy, Matplotlib, Seaborn), R, SQL, PLSQL, NOSQL, Hadoop (Pig. Hive, Sqoop, MapReduce, Apache Spark), Big Query, ETL

• Databases: MYSQL, PostgreSQL, Oracle, Snowflake

• Statistics and Machine Learning Models: Linear/Logistic Regression, Natural Language Processing, Ensemble (Bagging Boosting), SVM, Naive-Bayes, KNN, K-means, GBDT, Neural Networks, Clustering, A/B testing, Time Series (ARIMA), Collaborative Filtering

• Analytical Skills/Management: Data Cleansing, Mining, Wrangling and Visualization, Exploratory Data Analysis, Advanced Excel (Macros, Pivot Tables, VLOOKUP), BI, Statistical Analysis, Segmentation, Project Management, Project Risk and Cost Management WORKING EXPERIMENCE

DataReady DFW Remote, USA

Dada Analyst Volunteer 10/2020 – Now

• Wrote Python scripts for web scraping with Selenium to find suitable grants, complete filter clicking/filling and fill out application.

• Used Nature Language Processing (tokenizing, stemming and word vectorization) to build a model for automating grant search process.

• Collected constants, wrote autofill scripts and completed testing and debugging with Python to automate grant application process. Pan-China Certified Public Accountants Chongqing, China Data Analyst 06/2018 – 01/2019

• Wrote Complex SQL in BigQuery to analyze financial transaction data to identify major financial issues

• Worked with stakeholders to develop a working process of handling data analysis request, ad-hoc project and dashboard request.

• Supported the audit team to get and analyze the reconciled data with Tableau given a limited timeline AXA Insurance Hong Kong, China

Data Analyst 03/2017 – 09/2017

• Wrote SQL to collect data from MySQL database and assisted fund manager to analyze the trend of fund using advanced Excel

• Conducted fund portfolio analysis, built financial modeling by using Python(pandas)

• Increased professional skills including data analysis and cooperate decision making Chongqing Shang Cang Technology Ltd Chongqing, China Data Analyst (finance team) 05/2016 – 12/2016

• Wrote a script to automatically process and prepare monthly and quarterly financial report, tax documentations by using Python

• Conducted on the implementation of new quantitative models with Python to stabilize the business and maximize efficiency

• Built a pipeline to monitor daily cash flow and set up a daily cron job to send alter email to stakeholders PROJECT EXPERIMENCE

Henkel Product Analysis (Python Tableau SAS) Aug 2020

• Performed data exploratory and visualization by Python and Tableau

• Built a product differentiation platform for Henkel by using customer view and product data with NLP

• Provided competitive product launches suggestion with Tableau by analyzing consumer sentiments and consumer reviews data

• Diversified marketing campaign strategy using customer segmentation(K-means) algorithm.

• Predicted customer churn rate and provided customer re-engaged suggestion by using survival analysis with SAS with 85% accuracy Yamibuy Customer Analysis Project (SQL Python) Jun 2020

• Wrote complex SQL to analyze more than 100k+ products data, customer demographic, behavior, transaction data of Yamiby to provide marketing campaign strategy

• Built model and conducted clustering analysis with K-means to differentiate customer segments

• Created a pipeline to optimize model selection (among 11 models) process by using Python and performed feature engineering to enrich dataset hyperparameter tuning for 20 features

• Drew the EERD and relations in the 3rd Normal Forms and wrote definitions for Yamibuy to reduce the duplication of data, avoid data anomalies, ensure referential integrity, and simplify data management.

Contact this candidate