Global Retailer

Client Description

Client operates 313 global distribution facilities.


The data integration process for the GWM had country/region specific business rules that needed to be handled for specific labor laws, currency conversions and age specific rules based on location of the stores.


iOLAP architected a solution using IBM InfoSphere DataStage that extracted data from all locations across the globe. Business rules were implemented based on the specific labor laws of the location and sent to the 3rd party GWM company to allow for time tracking and statistical reporting.


The delivered product allowed for schedule automation and had significant costs savings. Management could build schedules and know total staff cost at any point in time. The process provided the ability for the client to report on historical scheduling so they could increase or decrease staff based on special events such as holidays, Super Bowl, etc. Employees were not allowed to clock in prior to their scheduled time and were forced to clock out at the end of shifts.

Drive your business forward!

iOLAP experts are here to assist you