Case Studies

Curious about what we can do?

In each case, Delaero’s consultants played a key role in design, development and/or management of these projects.


  • Custom payroll export between SAP and Kronos, responsible for signing off and paying 160K employees.
  • Custom auto pay interface, responsible for creating time cards for exempt employees’ schedules.
  • Error Handling – Created a mechanism for SBUX to launch, monitor and report on all GLS processes.
  • BI/ETL – Designed and built an ETL interface for above store reporting.
  • Termination pay interface – An interface that identified and calculated immediate pay for terminated employees.
  • POS Import – Designed and built a highly scalable POS interface that was responsible for processing up to 53M transactions a day.
  • Designed and built a custom Lawson payroll interface that performed many custom calculations to support the business and needed to support all store associates.
  • Designed and built a custom error handling process that launched, monitored and did analysis and reporting on various integrations.
  • Designed and built a payroll interface responsible for signing off and paying 400K employees in a little under 2.5 hours.
  • Designed and built a custom labor standards integration to distribute labor standard creation tasks to store management.
  • Custom LDAP integration to support all store associates.
  • Designed and built a custom bi-­‐directional interface used to drive labor calculations for back room activities.
  • Designed a custom module allowing store managers to enter and track receiving data.
  • American Girl
  • Disney Stores
  • Family Dollar
  • Forever21
  • Hannaford
  • Jo-­Ann Stores
  • Jos. A Banks
  • Kohls
  • Lowes
  • Nike
  • Pep Boys
  • PUMA
  • Save-­a-­lot

Hospitality and Food

  • Security solution to allow all corporate employees to login to Kronos and to a remote SFTP site using SAML.
  • SSIS based mainframe integration that converts the format of file and ensures reliable transmission to a main frame.
  • Error handling routine to detect and report errors with payroll process.
  • Developed a custom data broker to handle bi-­directional communication with Micros to completely populate Micros employee data and extract POS and hours information.
  • Developed a custom data broker to synchronize Kronos to Micros.


  • Designed and built a custom data broker to collect data from shop floor devices.
  • Designed and built a custom web service tier to support a mobile application.
  • Designed and built a custom ETL and data extract to synchronize transactional data to their data warehouse.
  • Delivered a series of 38 Cognos reports from the new data warehouse structure.
  • Developed a custom Single Sign-­On solution to integrate the clients’ enterprise security infrastructure to Kronos.


  • Designed and built ESB adaptors to publish time and HR data in a real time fashion.
  • Designed and built an HR and payroll system to manage complex union rules in the specific manner the state needed.


  • Designed and developed a middleware services platform that integrates a number of different medical devices to the Pyxis data store.
  • Developed a custom Single Sign On service for the Kronos application and mobile device.
  • Designed a services framework for a form based patient diagnostic program.
  • Developed a custom Single Sign-­On solution to integrate Kronos to the clients’ security infrastructure.
  • Designed a bi-directional schedule interface between Kronos and AllScripts.


  • Designed, architected and built the first generation of the Kronos Hosting Program.
  • Designed and built a plug-­‐able architecture for SAML based Single Sign-­‐On for the Kronos product. This design was used as the baseline for SAML in WFC 7.0
  • Designed and built the Kronos Dynamics integration product.
  • Delivered a variety of services ranging from security/infrastructure consulting, to custom application development and integrations supporting specific business functions.