Xuyuan (Alice) Zhang

Xuyuan (alice) zhang

bookmark on deepenrich
location of Xuyuan (Alice) ZhangPudong, Shanghai, China
Followers of Xuyuan (Alice) Zhang519 followers
  • Timeline

  • About me

    Data Analyst | M.S. in Business Analytics at Brandeis IBS

  • Education

    • Brandeis university

      2018 - 2019
      Master of science in business analytics (stem-designated)

      * Kaggle: - 2015 Flight Delays and Cancellations: Which airline should you fly on to avoid delays?(Exploratory Data Analysis, statistical test, k-means clustering)- FIFA 19: Predict the Market Value and Position for Players(Multiple Regression, Logistic Regression, K-nearest Neighbor, Decision Tree)* Projects: - Churn rates for QWE Inc. (Logistic Regression)- eBay (A/B Testing)- Pilgrim Bank (T-test)- Corporación Favorita Grocery Sales (Tableau)-… Show more * Kaggle: - 2015 Flight Delays and Cancellations: Which airline should you fly on to avoid delays?(Exploratory Data Analysis, statistical test, k-means clustering)- FIFA 19: Predict the Market Value and Position for Players(Multiple Regression, Logistic Regression, K-nearest Neighbor, Decision Tree)* Projects: - Churn rates for QWE Inc. (Logistic Regression)- eBay (A/B Testing)- Pilgrim Bank (T-test)- Corporación Favorita Grocery Sales (Tableau)- World Health Indicators (Tableau)- Aspect Based Sentiment Analysis for Restaurant Reviews (Python, NLTK)- Sam’s Club with Teradata SQL* Courses: - Analyzing Big Data I/II (R, SQL, Machine Learning)- Python Business Analytics- Machine Learning (scikit-learn)- Information Visualization (Tableau)- Marketing Analytics (R, LTV)- Digital Marketing (SEM, SEO, CTA)- Applied Econometrics with R- Healthcare Data Analytics- Introduction to NLP (NLTK, Python) Show less

    • Florida state university

      2016 - 2016
      Exchange student hospitality management
    • Macau university of science and technology

      2014 - 2018
      Bachelor of international tourism management 3.91/4.0

      Activities and Societies: Vice Chairperson at Pacific Asia Travel Association (PATA) Macao SAR Student Chapter; Financial Department of FHTM Student Association 2014 - 2018 Dean's Honor List2018.6 Rector's Honor List2018.6 Macao Foundation Scholarship2017.11 Bank of China Scholarship2015.11 & 2016.11 Henry Fok Foundation Scholarship

  • Experience

    • The walt disney company

      Jun 2016 - Dec 2016
      Quick service food & beverage/ merchandise intern

      • Handled cash transactions - both manual and using Point of Sale (POS) system• Conducted daily inventory checks and restocked to maintain optimal inventory needs• Generated great revenue performance by understanding consumer behaviors• Prepared food and beverage orders using safe food handling techniques

    • Pacific asia travel association (pata)

      Mar 2017 - Jun 2018
      Vice chairperson of macao sar student chapter

      • Organized and promoted activities such as Hong Kong Field Trip; Assigned different tasks to members according to their strengths• Summarized and reported financial information to the Macao Government Tourism Office (MGTO) through Excel• Cooperated with other universities for activity implementation• Negotiated with MGTO for activity advising and budgeting• Attended PATA networking activities (e.g. PATA Annual Summit) and built positive relationships with industry leaders

    • Spring airlines

      May 2019 - Aug 2019
      Data analyst intern

      • Worked in the Revenue Analysis Group and assisted in maximizing revenue performance through data analysis• Wrote simple to complex SQL queries including joins, date & time, strings, table creation & update, unions, subqueries and window function; Utilized the MySQL database to process over 50 million daily-updated data• Designed the logic to identify the latest flight status from other airlines by using Ctrip (the largest OTA in China) data• Created SQL Stored Procedures that automated the process of identifying and updating flight status in the database; Notified the marketing department through auto-send emails on a regular basis; Improved decision-making process tremendously• Analyzed the relationship between the frequency of adjusting price and sales revenue from unauthorized agencies by merging tables from multiple databases to support revenue analysis process• Liaised with the marketing department to evaluate their needs and develop data solutions; packaged result into client-faced deliverables and interpreted them to the department director Show less

    • Nyc data science academy

      Jan 2020 - Mar 2020
      Data science fellow
    • 咪咕视讯科技有限公司

      Jul 2020 - now
      Data analyst
  • Licenses & Certifications

  • Honors & Awards

    • Awarded to Xuyuan (Alice) Zhang
      Macao Foundation Scholarship (2018) - Jun 2018
    • Awarded to Xuyuan (Alice) Zhang
      Rector's Honor List (2018) - Jun 2018
    • Awarded to Xuyuan (Alice) Zhang
      Bank of China Scholarship (2017) - Jun 2017
    • Awarded to Xuyuan (Alice) Zhang
      Dean's Honor List (2014-2018) -
    • Awarded to Xuyuan (Alice) Zhang
      Henry Fok Foundation Scholarship (2015 & 2016) -
  • Volunteer Experience

    • Volunteer

      Issued by GAPPER INTERNATIONAL on Jun 2017
      GAPPER INTERNATIONALAssociated with Xuyuan (Alice) Zhang