Xuan (Tracy) Wang

Jersey City, NJ ***** 518-***-**** ad5a0c@r.postjobfree.com LinkedIn

EDUCATION

Johns Hopkins University, Carey Business School Aug 2022 – Aug 2023 Master of Science in Business Analytics and Risk Management (STEM) Rutgers University Sep 2019 – May 2022

Bachelor of Science in Finance

SKILLS & QUALIFICATIONS

Programming Languages: Python (NumPy, Pandas, Matplotlib, Seaborn), SQL, R Software: Tableau, PowerBI, SAS, Microsoft Excel, Bloomberg Terminal Financial Skills: Financial Modeling, Data Analysis, Investment Analysis, DCF Valuation PROJECT EXPERIENCE

Quality Prediction Study for Red Wine Python, R Apr 2023 – Jul 2023

• Leveraged R to conduct comprehensive analysis on extensive financial datasets comprising 10,000+ entries, generating univariate analysis and correlation table to identify key quality drivers for red wine production

• Developed Logistic Regression and Random Forests models to predict wine quality, leading to improved accuracy rates and optimization of production efficiency

• Performed model validation by splitting the data into training and testing sets, utilizing Python scikit- learn package to compare test results and evaluate the loss function

• Utilized industry metrics (RMSE, MAE, R-squared) to validate regression models, affirming Random Forest outperforming by 15% in accuracy rate Telecom Customer Churn Prediction R Jan 2023 – Mar 2023

• Conducted Exploratory Data Analysis (EDA) to explore the relationship between customer churn and factors such as contract type, tenure, and monthly charges

• Collaborated with a team of 3 members to develop predictive models using Logistic Regression, Support Vector Machines(SVM), and Random Forests to proactively reduce churn rates

• Evaluated the performance of the models using 10-fold cross-validation and assessed key performance metrics such as accuracy, precision, recall, and F1-score

• Compared the performance of the models using ROC curves and calculated the AUC values. Logistic regression emerged as the top-performing model with an AUC of 0.854 on the test set PROFESSIONAL EXPERIENCE

Shanghai Pudong Development Bank Jul 2022 – Sep 2022 Intern, Finance Department

• Conducted financial analysis to assess the financial health of corporate clients, evaluating key drivers such as capital structure (debt-to-equity ratio), profitability & loss, operational capacity, and debt repayment ability to provide strategic feedback on the financial conditions

• Organized the bank's financial statements and conducted internal searches for payment data including bank transfers, cheque payments, and credit card payments to support internal and external audits

• Reviewed payment and bill settlement requests, collaborating with the budget team to verify and reconcile accounting entries created in Oracle to facilitate smooth account settlements