Xi Bidian Email & Phone Number

Arizona, United States

Greater Seattle Area

• Currently working on a flight time band project, which aims to dynamically create time bands for each market based on the RASM strength of flights at different departure times. The project outcome will enable inventory.
• UFT migration – The Unified Flight Theory tool is used by Revenue Management team to bring a whole host of metrics into one place for comprehensive analysis and strategy development. Rebuilt the entire process in.
• Revenue review migration - Collaborated as a key member of a proactive team of three to successfully migrate monthly revenue reports from Excel to SSRS (SQL Server Reporting Services). This transformation resulted in.
• Advanced Booking Report revamp and migration – successfully migrated one of Alaska’s legacy reports from Excel to SSRS (SQL Server Reporting Services) by establishing a robust data pipeline in SSMS (SQL Server.
• Revenue review deck automation - automated the revenue review deck used in the monthly executive meeting which provides a high-level view of how Alaska was doing in the past one month in different facets, which.

Greater Seattle Area

• Guest mood meter – established a model to evaluate guest mood based on the negative events they had with Alaska in the past one year, such as cancellation, delay, diversion, and baggage lost etc. The model output was.
• Fluffy (pricing automation tool) – established a pricing tool which generates connective fares automatically. With appropriate logic and pricing rules built in, the tool has become easy to maintain and adapt when.
• Dynamic pricing tracker - established a tool to detect the difference between Untied Airline’s filed fare amount and the selling fare amount, which helped the pricing team learn our competitor’s dynamic pricing.

Greater Seattle Area

Plano, Texas

• Engaged in research to collect historical salary data from GSU MRM alumni to determine overall salary trend
• Acted as the student voice for information sessions and webinars, participated in online discussion forums

Omaha, Nebraska

• Group Insurance Modeling
• Created group sales projection model based on productivity changes and expected salesforce changes, automated the projection process utilizing VBA, providing a guideline for product area to set sales goal for each.
• Learned basics of MG-ALFA through hands-on tutorials and documented a group long term care model to facilitate comprehension and future modifications Capital Management
• Analyzed the relationship between fixed income investment spreads and various economic factors to inform assumption setting for cash-flow testing
• Performed sensitivity tests on prepayment assumptions for residential mortgage-backed securities in MG-ALFA, analyzed how these assumptions impact the par value and the total principal in the RMBS model

Greater New York City Area

• Interacted with various departments within the company and supported new business production
• Responsible for portfolio analysis, measured and managed the growth strategy of commercial multi-line and ocean marine cargo

Greater New York City Area

• Processed raw data on domestic movements of crude oil into organized data using Excel and the system Bargomatic
• Researched global oil production, transportation and consumption logistically by port

• Provided support for college students in mathematics with strong emphasis on problem-solving skills
• Tutored students in specific course material and integrated study and learning strategies to promote independent learning

Master'S Degree, Mathematical Risk Management

Activities and Societies: Vice President of Mathematical Risk Management Association in GSU & Treasurer of Actuarial Science Association.

Bachelor Of Science (Bs), Actuarial Science