RAE GUAN State College, PA 814-***-**** ad4wb6@r.postjobfree.com https://www.linkedin.com/in/shenruiguan/ Education

The Pennsylvania State University M.Sc. in Business Analytics 08/2024 The Pennsylvania State University Graduate Certificate in Supply Chain Risk Management 05/2023 The Pennsylvania State University B.Sc. in Hospitality Management 05/2017 Professional Experience

PNC Bank Retail Banking Consultant 08/2023 - 11/2023 State College PA

Assisted with account services, employing data analytics for problem-solving and cross-selling financial products.

Implemented a customer relationship management (CRM) approach to track and analyze customer interactions and feedback. This strategy enabled the identification of service improvement areas and the development of targeted financial solutions to meet evolving customer demands.

Leveraged customer data analytics to assist clients with account openings, closures, and maintenance, ensuring personalized and efficient service.

Panda Express General Manager 07/2019 - 08/2023 State College PA

Conducted comprehensive menu analysis using menu engineering techniques. Strategically revised the menu by identifying high- profit-margin items and phasing out underperforming dishes, aligning with customer preferences and profitability metrics, resulting in a 16% increase in the profitability of key menu items.

Utilized customer traffic flow analysis to optimize seating arrangements and improve dining experience efficiency. Implemented strategic seating models to maximize table utilization and enhance customer satisfaction.

Applied ABC analysis and EOQ models using Excel for sophisticated inventory management. Enhanced inventory turnover by 25% through precise demand forecasting and procurement optimization, significantly reducing food waste.

Collaborated in the deployment of WorkJam, a workforce scheduling software, to optimize staffing levels. Leveraged data analytics to align staffing with fluctuating customer demand patterns and seasonal trends, enhancing operational efficiency.

Spearheaded the development and implementation of data-driven training modules for both front-of-house and back-of-house staff, focusing on enhancing customer service standards, food safety protocols, and operational efficiency. Utilized a blend of in- person and on-the-job training methods, leveraging analytics to tailor training approaches.

Led the overhaul of SOPs and maintained rigorous inspection documentation for food handling and sanitation. Employed statistical analysis to ensure compliance with health regulations and consistency in food safety, achieving a 100% compliance rate with established food safety standards.

InterContinental Hotels & Resorts Operations Analyst Intern, Room Division 05/2015 – 08/2015 Beijing China

Automated data retrieval and calculations by utilizing VLOOKUP, SUMIFS, and INDEX-MATCH, building Excel spreadsheets and visualization dashboards to generate daily, weekly, and monthly room division reports.

Utilized the OPERA Revenue Management Software (RMS) to monitor room availability, rates, and bookings in real-time, assisted in optimizing room inventory by implementing overbooking and allocation strategies.

Successfully maintained rate parity across all online distribution channels, preventing revenue leakage due to rate disparities. Project Experience

Workforce Development in Advanced Manufacturing (2024 Super Analytics Challenge Case)

Conducted in-depth analysis of workforce development challenges in the advanced manufacturing sector, utilizing Python/R for efficient data cleaning and preprocessing.

Employed Tableau for dynamic data visualization, presenting labor market trends and workforce development program effectiveness.

Developed innovative strategies for personalized learning and continuous skill enhancement, with a focus on adapting to technological advancements.

Facilitated collaborations with community partners, using data-driven insights to connect individuals to advanced manufacturing job opportunities.

Pioneered creative solutions to enhance training programs, emphasizing entrepreneurship and innovation in workforce development. Qualification

Data-driven professional with a robust background in business strategy optimization.

Harmonizes data from various systems to provide comprehensive business insights.

Builds predictive models to optimize resources and inform business decisions.

Tools: Tableau, Power BI, SQL, Python, R, Excel (incl. VBA)

Contact this candidate