Bethany(Ruoxuan) Gong
*** ********** ****. ****** ****, NJ 07310 ● 646-***-**** ● adc7pq@r.postjobfree.com 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 Salesforce.com 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%
ACADEMIC PROJECTS
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.
EDUCATION
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