Herbalife is a leader in developing advanced weight-management, nutritional and personal-care products. Herbalife offers a wide range of scientifically advanced products, not only for weight loss, but also for enhancing nutrition and general health; skin and hair care; and cosmetics. Herbalife is represented in 50 different countries and provides over 150 different products.

Challenge:
In 1999 Herbalife implemented the Oracle ERP system that provided them with most of the features needed to effectively manage and distribute their products worldwide. Due to the unique requirements of their distributor sales programs, Herbalife chose to continue using their existing order processing system. Our challenge was to develop a system/solution that would bring the data together from both of these systems, analyze it, and serve it up in a format that would enable Customer Service and Supply Chain Management to make timely and informative decisions regarding worldwide inventory availability.

Solution:
A browser based solution was created using MS SQL Server as the data repository. The application was titled "PAIRS" which stands for Product Availability Information Reporting System. PAIRS receives supply and demand information from both the Oracle ERP system and the OPMAIN order processing system. PAIRS analyzes this data and provide the user with a multitude of data retrieval options. The data can be retrieved in both static and portable (Excel spreadsheet) formats.

PAIRS offers elaborate drill-down functionality enabling the user to quickly and easily view availability, replenishment, shipment, and backorder information globally. PAIRS is currently used by Herbalife employees all over the world.