Development and Implementation of Statistical/Quantitative Analytical Tools

The Assignment:

In partnership with Computer Ingenuity Associate (CIA), developed budgeting and forecasting tools that interfaced and imported historical, actuals and future business from the Micros PMS, Micros POS, IDeaS Optimization System, Delphi Sales & Catering System, DataPlus and Accounting system. The objective of this assignment was to create one repository data aggregator from the multi data source systems and utilize it for budget and forecast of guestrooms, food & beverage outlets, banquet & catering, labor costs, revenue and expenses and daily audit. The online SQL Server reporting portal created a better understand the trends and patterns to make better business decisions.

Scope of Work:

  • Developed business analytics on performance and profitability from the multi data source systems to fit operational needs
  • Provided factor driven forecast and budgeting and allowing costs to self adjust as drivers and demand changed
  • Produced trending information of labor cost and performance standards for budgeting
  • Created real-time forecasting repository for static and rolling forecast of all revenue streams


  • Data warehouse from all data source systems
  • Improved forecast accuracy of revenue streams by 15% overall for the year post implementation. – Increased GOP by 4% within 2 year of post implementation.