Sign in

Data Analyst Python

Seattle, WA
May 14, 2020

Contact this candidate


Bethany(Ruoxuan) Gong

*** ********** ****. ****** ****, NJ 07310 ● 646-***-**** ● SUMMARY

Experienced business/data analyst professional with considerable experience in business intelligence, data analysis/visualization, machine learning, project management, analytical thinking and creative problem solving. Skilled, creative and innovative. SKILLS

Programming: SQL, Python (Pandas, NumPy, Scikit-learn, Seaborn), SPSS Analysis Techniques: Decision Tree, Random Forest, K Nearest Neighbors, K-means, Linear/Logistic Regression, Regularization, Classical & Penalized Regression Methods (Lasso, Ridge), Principal Component Analysis (PCA), Hypothesis testing, A/B testing Software/Technology: Advanced Excel (Vlookup, Pivot Table), Tableau, Qlikview, Google Analytics, Hotjar, MS Project, Salesforce EXPERIENCE

Morgan Stanley New York, NY

Data Analyst (Credit Risk Department) Jul 2017 – Present

• Integrated different data resources, simplified reporting and data quality check tools, and enabled automation using SQL which significantly improved the efficiency of multiple existing workflows by 30% on average

• Created and maintained business intelligence dashboards using Qlikview, Excel and Python to monitor and analyze the performance of key risk metrics

• Prepared/presented status report and assessment results to senior management including CCO on weekly basis

• Initiated and led end-to-end projects and managed multiple projects simultaneously. Project example: designed, tested and implemented several CCAR (Comprehensive Capital Analysis and Review) Schedule H.1 related refining projects in compliance with Fed regulatory reporting requirements, which improved efficiency by 50% and increased data accuracy by 30%

• Collaborated and interacted with cross-functional teams including IT, Operations, credit coverages, reporting and stress testing team to identify/resolve routine and ad-hoc data issues, and assist in project design, UAT testing and cross-functional trainings WhoWhatWhy New York, NY

Business Analyst Intern (PMO) Aug 2016 – May 2017

• Worked extensively with marketing and project development teams and tracked their progress through Lucidchart and MS project over the life of projects

• Structured four years of publicity mention data and performed in-depth market analysis/data visualization using Python

• Automated weekly site traffic analysis dashboard/report using Hotjar and Google Analytics that helped the marketing department to boost site traffic by 10%

Visionary New York, NY

Business Data Analyst Intern Aug 2016 – Jan 2017

• Leveraged to analyze over 1000 potential investors, matched investors with suitable clients, and created specific targeted email campaigns to arrange meetings and events

• Automated manual processes using Python which reduced redundancy and increased efficiency by 50%

• Utilized SPSS, Tableau, and Excel to analyze customer behavior datasets and generated customer behavior reports that improved customer retention by 10%


Banking Customer Churn Prediction and Analysis

• Developed algorithms using banking customer churn dataset to predict customer churn probability using Python

• Preprocessed features and trained supervised machine learning models including Logistic Regression, Random Forest and K- Nearest Neighbors(KNN), and applied regularization with optimal parameters to select the best model

• Evaluated the model based on the classification performance on testing datasets using ROC curve/AUC score/confusion matrix Natural Language Processing and Topic Modeling on User

• Used unsupervised learning methods to cluster unlabeled documents using customer review data from an e-commerce platform

• Tokenized, stemmed and removed stop words while preprocessing the data, and performed TF-IDF to extract features

• Implemented unsupervised machine learning methods, such as K-means and Latent Dirichlet Analysis (LDA) to obtain important topics and keywords from target users.


Fordham University, Gabelli School of Business New York, NY MS in Information Systems, GPA: 3.96/4.00 Aug 2016 – Dec 2017 Relevant Coursework: Database Management, System Analysis and Design, Web Analytics, Data Mining, Project Management University of Minnesota - Twin Cities Minneapolis, MN BS in Economics with Minor in Statistics, GPA: 3.54/4.00 Aug 2013 – Dec 2015 Honors and Awards: Maroon Global Excellence Scholarship, 2014 CLA Dean’s List

Contact this candidate