-Parsed over 465 billion records in SQL and combined with win probabilities to make marginal benefit pricing tool-Created revenue forecast for Hawaii markets with an 80% reduction in bias used by commercial group-Tested nearest neighbors vs clustering for booking curves and productionized data pipeline to support 30+ analysts

-Created RMS forecast dashboard viewed over 3,000 times using Alteryx, SQL, and Tableau-Updated displacement process used by FP&A to calculate opportunity costs for commercial initiatives-Created Tableau visualizations to support senior leaders in decision making during new RMS calibration-Served as subject matter expert on forecast elements of new RMS system

-Manage inventory of markets worth over $500 million in annual revenue creating increased incremental revenue through higher yields and load factors-Automate daily market management using Alteryx and SQL to reduce daily management time by over 1 hour-Use SQL, Tableau, and Excel pivots to generate market performance reports for department leadership and regional management teams to influence management strategy and align cross-department efforts-Create and modify existing department tools in Alteryx and Excel for more flexible and faster reporting leading to more responsive and accurate inventory management strategies

-Co-developed Isolation Forest model using BTS performance and reliability data to reduce root cause analysis time by over 2 hours-Prototyped microservices architecture for Isolation Forest based root cause analysis program to be deployed to customer as a web application-Contributed to organization AI and ML capability through developing and hosting multi-part training series covering introductory machine learning topics and models to over 100 engineers

-Collected data from patient surgery outcomes and aggregated into excel spreadsheet leading to more efficient data management for staff-Used Excel macros and functions to create statistical reports that led to more accurate and faster lens selection for patients improving patient visual acuity and reducing surgery recovery times

-Supervised and functioned as mentor to a group of 33 residents-Planed and executed events designed to promote student retention and well-being-Used conflict mediation and crisis management training to resolve conflicts between residents

-Managed inventory settings on markets that generated over $60 million dollars in annual revenue to create incremental revenue through improved yields and load factor-Analyzed market performance, prepared and presented analysis to senior management to inform yield strategy and evaluate need for inventory changes -Built forecast accuracy tool with SQL and Excel pivots to determine whether history set management is necessary to generate a more accurate baseline forecast