Scribd Logo
Upload

Welcome to Scribd!

  • 56 views

    Yiguo (Margo) Wang: Master of Science in Business Analytics (STEM)

    Uploaded by

    ANISHA DUTTA
    This document provides a summary of Yiguo (Margo) Wang's education and experience. She is currently pursuing a Master's degree in Business Analytics at USC and holds a Bachelor's degree in Mathematics and Economics from NYU. Her skills include machine learning, data analytics, databases, and data engineering. Her experience includes internships in business analytics, data analytics, and marketing analytics. Her projects include meal plan prediction and bank customer segmentation using machine learning models.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Yiguo (Margo) Wang: Master of Science in Business Analytics (STEM)

    Uploaded by

    ANISHA DUTTA
    56 views1 page
    This document provides a summary of Yiguo (Margo) Wang's education and experience. She is currently pursuing a Master's degree in Business Analytics at USC and holds a Bachelor's degree in Mathematics and Economics from NYU. Her skills include machine learning, data analytics, databases, and data engineering. Her experience includes internships in business analytics, data analytics, and marketing analytics. Her projects include meal plan prediction and bank customer segmentation using machine learning models.

    Original Title

    MBA

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides a summary of Yiguo (Margo) Wang's education and experience. She is currently pursuing a Master's degree in Business Analytics at USC and holds a Bachelor's degree in Mathematics and Economics from NYU. Her skills include machine learning, data analytics, databases, and data engineering. Her experience includes internships in business analytics, data analytics, and marketing analytics. Her projects include meal plan prediction and bank customer segmentation using machine learning models.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    56 views1 page

    Yiguo (Margo) Wang: Master of Science in Business Analytics (STEM)

    Uploaded by

    ANISHA DUTTA
    This document provides a summary of Yiguo (Margo) Wang's education and experience. She is currently pursuing a Master's degree in Business Analytics at USC and holds a Bachelor's degree in Mathematics and Economics from NYU. Her skills include machine learning, data analytics, databases, and data engineering. Her experience includes internships in business analytics, data analytics, and marketing analytics. Her projects include meal plan prediction and bank customer segmentation using machine learning models.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 1

    YIGUO (MARGO) WANG

    Los Angeles, CA • (929) 364-7514 • yiguowan@usc.edu • https://www.linkedin.com/in/yiguo-margo-wang

    EDUCATION

    University of Southern California, Marshall School of Business – Los Angeles, CA December 2023
    Master of Science in Business Analytics (STEM)
    • Expected Coursework: Applied Modern Statistical Learning Methods, Time Series Analysis for Forecasting, Data
    Warehousing, Business Intelligence and Data Mining, NoSQL Database in Big Data, Statistical Computing and
    Data Visualization (R)

    New York University, College of Arts and Science – New York, NY May 2022
    Bachelor of Science, Mathematics and Economics (STEM)
    • Honors: Phi Beta Kappa, Magna cum laude
    • Coursework: Machine Learning (Python), Database Design and Implementation (Python, NoSQL, SQL),
    Econometrics (R), Theory of Probability, Statistics (R), SQL for Data Science (SQL)

    SKILLS & INTERESTS

    • Database Processing: SQL, NoSQL, AWS | Data Engineering: Spark, Hadoop, Hive, MapReduce
    • Data Analytics: A/B testing, Casual Inference, Tableau, SAS, Google Analytics, MS Excel, PowerBI
    • Machine Learning: Python (Scikit-Learn), R, SPSS | Hypotheses Testing, Predictive Modeling, Regression
    Analysis

    EXPERIENCE

    MJHS Health – New York, NY July 2022 – August 2022


    Business Analytics Intern
    • Engineered 100k user data from database and processed 15+ usable features including age, highest education,
    module completion, etc.
    • Identified key customer churn points following AARRR model for 5 cohorts and compared differences
    • Predicted probability of churn rate with existing modules across 3 tracks in gradient boosting regression model,
    achieved 0.892 R2, lifted course completion rate by 20%
    • Executed A/B test for launching new lecture mode (interactive mode) and implemented statistical methods to
    analyze results
    • Presented 2 customer analysis reports on behalf of sales and marketing department, it was well-received by the PMs

    GF Securities – Hunan, CHINA June 2021 – August 2021


    Data Analytics Intern
    • Leveraged SQL to review investment risk tolerance questionnaires and generated reports for sales team
    • Analyzed customer risk tolerance score in 4+ different dimensions including region, city, card type, etc.
    • Evaluated relationship between customer characteristics and risk tolerance score with correlation analysis
    • Recommended financial investment product based on analysis to target customer, increased sales by 6%

    Perfect Diary – Remote June 2020 – September 2020


    Marketing Data Analytics Intern
    • Collected product data with 8+ features including product color, size, price, etc. for more than 60+ competitor
    brands
    • Extracted and engineered 10GB + company product data of 4 years using Hive
    • Optimized pricing strategies by examining product pricing, pre, and after-sales services, etc. through comparison
    with similar products on market with PEST analysis
    • Created 4+ reports in Tableau for executive teams of KPIs, such as marketing spend, generated revenue, and ROI,
    saving 15 hours of manual reporting each week

    PROJECTS

    Meal Plan Prediction Project - New York, NY February 2022 – May 2022
    • Scraped 40K+ dishes' information (dish name, dish price, restaurant address, restaurant name) from Menupages in
    Python and loaded into SQLite database
    • Forecasted meal plan preference based on customers information using decision tree and random forest model,
    reached accuracy =0.872
    • Led a team of 5 to design a survey to collect customer opinions regarding meal plan change, it improved
    satisfaction rate by 20%

    Bank Customer Segmentation Project - New York, NY March 2021 – April 2021
    • Conducted exploratory data analysis by using Histograms, KDE plots, and correlation matrix for transaction
    • Performed K-means clustering algorithms to conduct customer segmentation and identified target cohort
    • Optimized marketing campaign by feeding customized content to 5 customer clusters, and achieved 70% boost in
    the KPIs performance

    You might also like