Jonathan Brooks Email & Phone Number

Phoenix, Arizona, Us

Phoenix, Arizona, Us

● Implemented ThoughtSpot as enterprise-wide analytics tool● Lead the creation of data products for store, email marketing, and customer surveys to enable speed and ease of insights for decision scientists and other business partners.

Phoenix, Arizona, Us

• Created a comprehensive reporting system to measure KPIs for promotional product locations unlocking the capability for teams to measure the success of their monthly promotional choices and adjust future strategies based on results• Modeled impacts of growing or reducing brand space in PetSmart stores to support Senior Leadership project prioritization and to impact annual brand space contract negotiations• Partnered with IT to build ETL processes that tied sales and space data from two different databases together enabling the creation of space aware performance reporting that users could view in standard PetSmart tools. • Led a team of nine responsible for maximizing sales and margin in PetSmart Stores based on product mix and in store location; team responsibilities included building and maintaining space optimization models, space productivity reporting, and data flows for all space planning execution tools

Phoenix, Arizona, Us

• Created and implemented a K-means clustering model using the sales patterns of targeted product attributes. The model allowed us to create a more localized assortment in each cluster and generated incremental sales in targeted categories• Leveraged spatial and sales data to create a targeted strategy of space reduction for underperforming brands that minimized the risk of losing sales while creating room for five new pet food brands to enter PetSmart stores• Became an early adopter of Alteryx at PetSmart and used it in combination with SQL to build a model that clusters stores based on customer shopping patterns• Automated monthly and yearly budget reporting using VBA to be updated with a single button click

Dallas-Fort Worth, Texas, Us

• Developed and implemented high level pricing and inventory management strategies to maximize ticketed revenue for all domestic and international American Airlines flights• Built reporting to support the merger of American Airlines and US Airways using SAS to combine revenue and passenger metrics from the two independent databases• Provided all key revenue and passenger metrics to support quarterly earnings call with investors• Identified and Implemented an incremental revenue strategy by increasing seat inventory availability for customers who purchase tickets within fourteen days of departure• Modeled the revenue impact of a significant competition increase in American Airline’s routes; Led a multi department task force to identify and implement opportunities to minimize the revenue impact; Reported findings and action items to senior leadership on a recurring basis

Us

• Led a team of eight analysts who were responsible for forecasting and optimizing $3 billion in annual revenue on US Airways and American Airlines flights in the Northeast United States• Presented market strategy changes and performance updates in weekly meetings with managers, directors and the Senior Vice President• Calculated passenger recapture or loss on flights due to capacity changes by other airlines• Analyzed discrepancies between team and system level trends and made improvement recommendations to leadership

Us

• • Forecasted demand and maximized revenue through seat inventory controls on a subset of US Airways flights worth approximately $500 million annually • Tested and trained best practices for using a new forecast system for the Yield Management department• Developed a SAS pricing trend report that enabled analysts to more accurately identify areas where pricing changes impacted the demand forecast

Us

• Preserved the integrity of the flight schedule by confirming that all flights had been assigned to a legal crew• Confirmed that all crewmember assignments were within company policies and were accordance with FAA required regulations• Communicated with crewmembers, in a timely manner, all changes made to originally published schedules• Resolved rest requirements and crew legality issues based upon the appropriate regulatory requirements• Maintained the best customer service possible throughout the company

• Performed and observed tasks in airside operations including airfield inspections, wildlife management, and safety area inspections• Completed necessary revision to the Gerald R. Ford International Airport Rules and Regulations• Maintained compliance with Federal Aviation Regulations•Rotated through various aspects of the airport community including: airline, airport police, and air traffic control