Ran (Rose) Ro

608-***-**** • linkedin.com/in/ran-rose-ro-22a01975 • adh759@r.postjobfree.com

EDUCATION

The University of Chicago Chicago, IL

Master of Science in Analytics - STEM Program Aug 2020 - Dec 2021(Expected)

Relevant coursework: Statistical Analysis (Generalized Linear Models, Bayesian Methods, PCA), Data Engineering Platforms (SQL, Tableau), Programming (R, Python), Time Series Analysis, Machine Learning University of Washington Seattle, WA

Bachelor of Arts, Economics, Minor: Mathematics Sep 2013 - Mar 2017

Honors: Dean’s list (twice), Certificate in Quantitative Managerial Economics SKILLS

Programming: Python (Pandas, Numpy, Keras, Seaborn, Tensorflow, Scikit-Learn, Web-scraping, Hypothesis testing), R, Stata, Excel VBA

Algorithms: SVM, Regressions, Decision Tree, Ensemble Learning(Boosting, Bagging, Random Forests), Clustering Analysis(K-means, Hierarchical, DBSCAN)

Database: Mongo DB, Neo4j, MySQL, noSQL, postgreSQL

Visualization/Geospatial: Tableau, MatplotLib and Plotly(Python), ggplot2(R) GSheets, Excel PROJECTS/EXPERIENCE

The University of Chicago Sep 2020 - Now

Lending Club Data Loan Default Analysis: design relational database; clean, normalize, analyze and visualize data initially with 150 columns and 13000+ rows; conduct correlation analysis using R

Sakila Database Analysis: designed EER Model for OLTP database; transformed and designed Snowflake Schema for OLAP database; gained insights using SQL code and created Tableau dashboards

Mining Safety Project: applied logistic regression and nonlinear optimization model to predict the perfect timing to send alarm signals to workers in a mine for them to escape from goaf events, using R Mizuho Bank (Dual-Hat of Mizuho Securities) Tokyo, Japan Financial Analyst (TMT Industry Coverage) Apr 2018 - Jul 2019

Built loan default forecast model based on 50,000 randomly sampled data, using Tableau to analyze and visualize data and Python to develop the model and improved precision by 22% through feature engineering and parameter tuning

Automated 5+ routine data work, such as loan rate quotation and data extraction and transformation from an internal database to generate M&A target lists, with VBA, resulting in a 60% decrease in division-wide routine work hours

Created 3 M&A proposals with quantitative analysis, one led to an acquisition worth $50M (revenue size $300M)

Conducted all areas of commercial banking business to maintain client relationships, such as 20+ FX and derivatives contracts & remittance, 10+ bond issuance, and 40+ corporate credit rating analysis Amazon Seattle, WA

Quality Auditor & Brand Registry (BR) Investigator Apr 2017 - Aug 2017

Generated and maintained business reports in Amazon Redshift used by global sites leadership and program managers for product performance tracking, and enhanced reports by detecting data discrepancies issue, with SQL and Excel

Audited 100+ Japanese/US/UK brand cases daily with high accuracy based on seller data analysis, delivered findings to Seller Support and BR teams and improved process efficiency by 40% through several SOP revision suggestions Goldman Sachs Tokyo, Japan

Securities Division Analyst (Equity Sales, Trading, Fixed Income Structuring) Jun 2016 - Aug 2016

Back-tested half-leverage ETF strategy on Nikkei 225 index 5-year historical data, and achieved higher Sharpe Ratio

Built Variance Swap Simulation Model, performed Option Greeks comparison analysis and pitched options in a week

Analyzed financial data of 63 regional banks to develop asset allocation strategies that led to new structuring ideas EXTRACURRICULAR ACTIVITIES/ADDITIONAL INFORMATION

Weget Magazine VP of Advertising Sales Apr 2016 - Mar 2017

Led a 6 person Ad Sales team in attaining 8 advertisers with over $7000 advertisement profit, breaking profit record Alpha Kappa Psi Business Fraternity – Rho Chapter Seattle, WA Rho Consulting Consultant & Fundraising Committee Member Apr 2014 - Jun 2016

Organized 10+ fundraisers and executed the Annual Silent Auction with 27 sponsors, generating profit over $3000 Languages: Japanese (Native), Mandarin (Native) Hobbies: Piano, Art Exhibitions, Swimming, Yoga, Reading

Contact this candidate