leo shen

* Excel VBA Project: * Led Revenue Management Remote Solution Discount Segment Strategy Analysis Tool creation to support detailed analysis on each Rate 360-Shopped discount segment: AAA; Government; Advance Purchase; Senior Discount * Designed, coded, piloted and launched a macro-enabled Excel template for Revenue Management Remote Solution Discount Segment Strategy Analysis Tool * Helped Revenue Management Remote Solution proactively set segment strategies for the upcoming month with strategy teams Revenue Management Function: * Utilized all available Marriott Revenue Management tools and systems to develop and integrate strategy decisions * Market Analysis Project: Analyze Great Boston suburb area market to provide practical suggestion to RMRS team leader

Created Excel models and tools for DOM, DOS and GM on topics such as Cancellation and Multi-Department Profitability Analysis, with data exported -Worked in a fast pace environment that requests prompt decision-making and consistently multi-tasking. Assisted in coordinating and communicating with DOM, GM regarding production performance, group rate quoting, and strategic promotion, pricing and distribution decision-makings -Was trained by the Director of Revenue Management to complete Dynamic Pricing Calendar based on STR report analysis, demand and industry trends, booking curves study, and channel distribution costs for Inventory Control and forecast reports