Xinyu Rachel Wang

Experienced Program manager with expertise in marketing, project management, and data analytics. Strong communication skills in English and Japanese (JLPT N2). Proven ability to drive business growth and manage cross-functional projects effectively.

• MySQL: Database Management Projects and Business Analysis Projects, 2019 - 2022, Built SQL query structure on MySQL server to sort, filter and retrieve data of app store sales., Created ER diagrams to better visualize airlines management database schema using MySQL., Performed in-depth schema analysis using MySQL on footwear manufacturer client about their performance at different geographical locations, online customer profiling according to their subcategories, and geography focused targeting., Provided insight for the client to make a marketing plan on specific products for specific demographic.
• Python: Dell New Hire Training Project; Amazon Books Recommendation Project, 2021; 2020, Manipulated the repair data of Dell in Python, calculated KPIs as required and visualized the results by matlpot library., Built a user-based recommendation system on Amazon books using text mining, Pearson correlation matrix, and KNN algorithm in Python with the objective of providing book recommendations for users.
• Tableau: Airbnb Data Visualization Projects, 2020, Researched multiple dimensions of database and retrieved data from 30,478 Airbnb listings in New York City and visualized analysis results as requested., Synthesized findings and communicated results by creating high-quality deliverables in different dimensions using Tableau.
• Power BI: Dell Projects, 2020 - 2022, Extracted KPIs of repairing data using Power BI and manipulated data in Excel and Python., Visualized business data dashboard using Power BI.
• Excel: Analytical Decision Modeling Projects, 2019 - 2022, Formulated Excel models to represent complex real-world decision problems by applying optimization, simulation and using spreadsheet tools., Performed sensitive analysis to these models to gain insights of problems., Summarized and visualized vital KPIs and business data by excel in various projects in Dell.
• SAS Enterprise: Data Analytics Team Project, 2019, Established multiple SAS models including decision tree and regression to predict if a purchase of a car in the auction will turn out to be a good buy using data provided by Carvana.