Yalan Xu

Yalan Xu

A.V.I.D. Tutor

Followers of Yalan Xu700 followers
location of Yalan XuNew York, New York, United States

Connect with Yalan Xu to Send Message

Connect

Connect with Yalan Xu to Send Message

Connect
  • Timeline

  • About me

    Product Analyst at Seabourn | Certified Associate in Project Management

  • Education

    • Penn State University

      2017 - 2019
      Bachelor's degree Economics
    • Highline College

      2015 - 2017
      Associate’s Degree Business Administration and Management, General
    • New York University

      2019 - 2021
      Master's degree Management and Systems with concentration in database technologies
  • Experience

    • Project S.C.O.P.E. (Student Creating Optimal Performance Education)

      Jan 2017 - May 2017
      A.V.I.D. Tutor

      Project S.C.O.P.E offers high school and college classes to help students who get expelled, suspended in high school to get high school diplomas.- Lead 15 minutes reading sessions to a group of 6 students with the use of Cornell notes and supervised reading assignments- Provided monthly feedback to the responsible professor and the project director regarding the students study progress

    • Zhongshan Sints Powder Metallurgy Co.,Ltd.

      May 2019 - Sept 2019
      Product Management Intern

      - Collaborated with the managers from Manufacturing Department and Quality Control Department to create and implement the three dashboards to track production status, monitor product quality and highlight the peak production seasons- Facilitated new product development meetings through gathering product requirements from the Sales Department, interpreting the requirements into functional specifications for the engineer teams to develop digital mode- Engaged monthly with Product and Sales departments to identify and evaluate potential product opportunities and markets Show less

    • Moving For Life

      Sept 2020 - Jan 2021
      Data Analyst Intern

      - Performed ad-hoc reporting to answer questions from the board of directors, programming assistant, and grant proposal writer- Aggregated and analyzed over 3000 rows of attendance data weekly and present statistics in a monthly board meeting- Coordinated with the marketing team in questionnaires design to gather students’ demographic data and obtain class feedback- Cooperated with the finance team to conduct quarterly profit and loss analysis and to prepare a budget plan for the year 2021 Show less

    • United Nations

      Feb 2021 - May 2021
      Management and Programme Analysis Intern

      - Conducted analysis on Board of Auditors Recommendation Process to identify two fields of improvement, resulting in partially automating the notification process and obtaining continuous up-to-date information- Engaged with the Analytics Project Management team in data configuration discussion and dashboard development for BOA recommendation Project- Lead interviews with the Office of the Director to gather, document requirements for seat reservation application development

    • United Nations

      Jul 2021 - Sept 2021
      Management and Programme Analysis Intern

      - Managed, analyzed NewWork Culture Change dialogue attendance and developed attendance dashboard using Power BI- Researched and collected innovation-related articles for the monthly NewWork newsletter and helped design newsletter contents- Created 15 assessment questions for BTAD Transformers Programme

    • Seabourn Cruise Line

      Sept 2021 - now
      Product Analyst

      - Monitor booking performance and conduct in-depth competitor analysis on public fare and promotion- Lead weekly product meetings and deliver recommendations on optimal pricing and marketing effort to stimulate demand- Manage suites upgrade program and continue discovering potential opportunities that can maximize product yields

  • Licenses & Certifications

    • Social & Behavioral Research - Basic/Refesher

      CITI Program, A Division of BRANY
      Oct 2020
      View certificate certificate
    • Excel: Tracking Data Easily and Efficiently

      LinkedIn
      Jul 2021
      View certificate certificate
    • Microsoft Excel - Advanced Excel Formulas & Functions

      Udemy
      Oct 2020
      View certificate certificate
    • Excel: Macros and VBA for Beginners

      LinkedIn
      Jul 2021
      View certificate certificate
    • Business Analytics Foundations: Descriptive, Exploratory, and Explanatory Analytics

      LinkedIn
      Jul 2021
      View certificate certificate
    • Data Analyst with Python Track

      DataCamp
      View certificate certificate
    • Data Analyst with SQL Server Track

      DataCamp
      View certificate certificate
    • Certified Associate in Project Management (CAPM)®

      Project Management Institute
      Jun 2020
      View certificate certificate
    • The Essential Elements of Predictive Analytics and Data Mining

      LinkedIn
      Jul 2021
      View certificate certificate
    • Certificación De Calificación DELE NIVEL A2

      Instituto Cervantes
      May 2021
  • Honors & Awards

    • Awarded to Yalan Xu
      Honors Scholarship Highline College Jan 2017
    • Awarded to Yalan Xu
      Vice President's Honor Roll Highline College Apr 2016
  • Volunteer Experience

    • Volunteered in Food Bank

      Issued by Northwest Harvest on Feb 2016
      Northwest HarvestAssociated with Yalan Xu
    • Volunteered in Thanksgiving Food Drive event

      Issued by Phi Theta Kappa on Nov 2016
      Phi Theta KappaAssociated with Yalan Xu
    • Volunteer

      Issued by TCS New York City Marathon on Nov 2019
      TCS New York City MarathonAssociated with Yalan Xu