top of page
Image by Cytonn Photography

Customer Experience for Global Insurance Firm

Built using Python, Tableau

  • Implemented machine learning models to enable in-depth analysis of factors influencing customer experience metrics, life insurance premiums, and annuity sales

  • Illustrated the story of our findings through an interactive dashboard

Credit Allocation and Macroeconomic Fluctuations

Built using Microsoft Excel
Link

  • Transcribed financial sector data from a large raw database into concise databases divided by country using Microsoft Excel

  • Created a program measuring which sectors in the economy receive the most credit by banks and other lenders from 1940 to today in each country

mobile-phone-gf1c7c9567_1920.jpg

Modeling Hit Songs in Spotify

Built using R
Link

  • Conducted exploratory data analysis on 230k+ rows of data through summary statistics and a correlation plot

  • Designed unsupervised machine learning techniques such as Principal Component Analysis and K-Means Clustering

  • Implemented supervised machine learning methods including logistic regression, LASSO model, Post-LASSO model, classification tree, and K-fold cross validation

Ants VS Some Bees

Built using Python
Link

  • Built a tower defense game based on the popular mobile app Plants VS Zombies, using an object-oriented programming paradigm

  • Applied concepts such as loops, higher order functions, lambda expressions, recursion, and trees

splash.png
money-g005869d59_1920.jpg

Personal Loan Predictor

Built using R
Link

  • Designed logistic regression models that accurately predict whether bank customers will take a personal loan and whether that loan will be accepted.

  • Quantified customer KPIs to understand which segments of customers are the most profitable, and further what type of marketing campaigns should be pushed towards those segments

Online Auction Operations

Built using Tableau
Link

  • Illustrated financial metrics, territory operations, and pricing in an interactive dashboard

  • Advised the marketing manager of an online auction company on strategies for expansion, such as increased training to boost profit margin, reducing listing fees, and expanding the company westward.

ecommerce-g0dce19d2e_1920.jpg

© 2023 by Sarah Guo. Proudly created with Wix.com

bottom of page