Jeffrey Roach Email & Phone Number

Austin, Tx, Us

Austin, Texas, United States

Austin, Texas, United States

Austin, Texas, United States

Greater Nashville Area, Tn

• Developed Python Django application to allow real time tracking of Revenue, Guest Volume, and future bookings.• Implemented, itemized, and Batched transactional data using Pandas, 3rd Party APIs, and Web scraping in order to save time of staff accountants and flag unusual transactions requiring additional expertise.• Analyzed guest booking data as to maximize revenue during non-peak business hours through strategic discounts, such as a Happy Hour discount that increased fill rates by .5 guests per game during the 3-5 weekday time window.• Manipulated and analyzed data sets of millions of rows to provide insight into day-to-day operations, including converting over 100,000 records from obsolete data formats from the company’s early years• Crafted SQL scripts to allow the tracking of day-to-day performance of over 400 team members from 16 different US locations in order to identify areas of improvement in front of house operations• Designed Game and Maintenance Database, allow the monitoring of the health over 6000 unique game components and complex analysis of over 250,000 individual Escape Room Experiences• Partnered with a multinational accounting firm to develop a learning management system, in order to teach thousands of learners worldwide on the use of advanced data and analytics software in an effective and engaging way• Constructed Production Management Application on the Quickbase Platform to track construction of 7+ new locations each year, saving Warehouse managers 1500 hours a year of tracking production progress• Administrated website and booking platform used to book 400,000 guests since its inception in 2018