ja_mageia

Client

The Coca-Cola Company is the owner and marketer of nonalcoholic beverage brands. It also manufactures, distributes and markets concentrates and syrups used to produce nonalcoholic beverages. The Company owns or licenses and markets more than 500 nonalcoholic beverage brands, primarily sparkling beverages but also a variety of still beverages, such as waters, enhanced waters, juices and juice drinks, ready-to-drink teas and coffees, and energy and sports drinks. It also manufactures, or authorizes bottling partners to manufacture, fountain syrups, which it sells to fountain retailers, such as restaurants and convenience stores.

Challenge

The Minute Maid division of Coca-Cola acquired Odwala juice company and needed to merge the new company into their current reporting system. Initially it seemed like a straight forward project. However, their current Essbase reporting system was poorly designed and was experiencing severe performance issues. The poor design also made adding the new company difficult, and put the application at risk of even further performance issues.

Solution

Although not in the initial scope of work, an Essbase redesign was necessary. The redesign would not only make the system more flexible for future acquisitions, it would greatly increase performance.

Results

The Essbase application was redesigned and the new company was easily added. The calculation time of the application went from hours to under two minute and redundancies in application maintenance were also eliminated. This significantly increased the efficiency of the accounting department by allowing more time for analysis and less time spent on system maintenance.