Yirong Song

*** *. ******* ***., ********, CA ***53

acz92y@r.postjobfree.com, 650-***-****

https://www.linkedin.com/in/yirong-song

EDUCATION

Santa Clara University, Leavey School of Business Santa Clara, CA Master of Science in Business Analytics June 2017

• Relevant Coursework: Data Science and Machine Learning, Data Science Analysis with Python, Database Management (SQL), Econometrics with R, Time Series Analysis, Big Data Modeling and Analysis, Dashboards/Scoreboards and Visualization University of Iowa, Tippie College of Business Iowa City, IA Bachelor of Business Administration in Finance May 2015

• University of Iowa National Scholarship Recipient, 2011 – 2015; Dean’s list

• VP of Finance in pledge class and member of Delta Sigma Pi – Professional Business Fraternity, 2013 – 2015

• Relevant Coursework: Income Measure & Asset Valuation, Valuation of Financial Claims, Advanced Tax Topics, Corporate Finance, Investment Banking, Applied Equity Valuation, Investment Management TECHNICAL SKILLS

• Programming Languages: Java, Python, R, Octave, Matlab

• Tools & Platforms: Tableau, SQL, SAP, Hadoop, AWS, Apache Hive, MapReduce, UNIX skills Academic Projects

• H1B visa petition analysis – Designed dashboard in Tableau showing which states provide the most H1B jobs and approval rate

• Airline Reservation Database System (SQL): Designed airline reservation database system model from scratch; created and executed SQL queries; presented a single document with all deliverables to an audience group of 30+ people

• Buy Online, Pickup In Store (BOPS) Policy Impact Evaluation: Developed statistical models from a dataset with 1 million observations to evaluate BOPS policy’s impact on a jewelry retailer by using treatment-effect model, Poisson model and negative binomial model; conducted tests for multi-collinearity and heteroscedasticity

• Rental Listing Inquiries: Built models by implementing machine learning concepts such as random forest, naïve bayes and classification tree to forecast how much interest will a new rental listing on RentHop receive

• Text Mining of Bible: Analyzed the text of Bible by stemming and converting the text to term document matrix to find the top common words; tested the mood score of the text and find the three main topics of the bible and top words in each topics

• Time Series forecasting model of tourists visiting Brazil: Utilized R features to visualize Brazil’s tourist data from 1989-2015; build ARIMA model to forecast tourists amount for the following years EXPERIENCE

Strattica Lab Inc. Palo Alto, CA

Data Analyst Intern (Practicum) Spring 2017

• Applied machine learning to the entire RMA dataset to correlate high deviations from prior periods with positive/negative trends in the industry

• Estimated cash flow/profit projections using historical data and interpreted industry signals such as expansion and contractions Transamerica Cedar Rapids, IA

Applied Research Intern 2015

• Researched the U.S. Commercial Real Estate (CRE) market and analyzed trends relating to transaction and financing; published 6 quarterly research reports on company’s website covering portfolio risk exposure and investment insights

• Quantified the tech/finance industry’s risk within the U.S. CRE market to enable management to make better decisions on CRE acquisitions; updated loan risk rating model on a monthly basis to enable the monitoring of a $9B CRE debt portfolio and ensure accuracy of data

Deloitte Shanghai, China

Audit Intern Summer 2013

• Collaborated with managers to complete credit rating reviews and ensured the accuracy and quality of the auditing process Additional Information

• Github: https://github.com/ysong2

Contact this candidate