Mandy Guo

Senior Analyst - Business Intelligence @ Ally | MS, Business Analytics

Seattle, Washington, United States

About

Experience

  • Ally (Full-time · 4 yrs 1 mo)
    • Senior Business Intelligence Analyst
      May 2024 - Present · 2 yrs 2 mos

    • BI Analyst II - Data Solutions Support
      Jun 2022 - May 2024 · 2 yrs

  • Risk Analyst at TF Holdings
    Jan 2022 - Apr 2022 · 4 mos

    • Evaluated data performance in the underwriting process by utilizing modeling techniques such as CART and regression • Integrated data preparation and descriptive analysis procedures in SAS to generate key performance metrics • Utilized Power BI to design and implement dashboards reports for presentation to stakeholders • Implemented automation process for monthly review reports reducing the report generation processing time by 80% • Analyzed marketing campaign experiment result data, and made data-driven recommendations on future A/B test design

  • Wealth Management Manager at AIA
    Aug 2018 - Jul 2021 · 3 yrs

    • Developed, and recommended investment programs and wealth management solutions based on analysis of client demographics and behaviors data to achieve stated investment objectives, leading to over 70% lead conversion • Optimized client satisfaction and experience, and built strong client relationships by providing export support and data-driven recommendations

  • Events Coordinator at Grand Hyatt Hong Kong
    Oct 2016 - Aug 2018 · 1 yr 11 mos

    • Managed over 100 events management projects and maintained clients’ satisfaction by collaborating with different departments • Assisted revenue management team in analyzing inventory and availability for over 20 function rooms and 500 guestrooms daily to optimize hotel revenue