In recent years, the group has extended its product range to meet market demand. As a result, the volume of data to be managed has risen significantly. To cope with the new business processes and the rising volume of data, YOMO implemented SAP R/3 in early 2000. Initially, YOMO had expected the amount of historical data stored in its database to increase from 200 gigabytes to 500 gigabytes. However, within only one year of the SAP implementation, the volume of data had increased dramatically. In fact, the Oracle database tripled in size, becoming one of the largest in the industry. Managing such quantities of information is costly, but it allows YOMO to conduct targeted Marketing, and provides important insight into sales patterns. To reap these benefits, system sizing has to be regularly monitored to match capacity with changing requirements.
The project
In early 2001, YOMO opted to partner with REALTECH. To optimize YOMO’s entire IT landscape and enhance system performance, it was essential to reconfigure the database, and to carry out a systematic archiving process.
Furthermore, plans had to be drawn up for the introduction of data warehousing. Collaboration also included second-level support. To ensure a smooth conversion to the euro, YOMO’s systems had to be analyzed and optimized. In addition, a test environment had to be implemented for the introduction of the new currency.
YOMO intended to put its systems offline for five days. REALTECH and YOMO drew up a detailed plan of action, and began to carry out inhouse training. Streamlining the system was especially complex, since it was necessary to reconfigure the system database – something YOMO had never attempted before. However, the changes delivered a number of significant performance enhancements. Analysis, monitoring, and reconfiguration continued until mid July-2001. The next project phase involved archiving data from early 2000. YOMO and REALTECH began with data on the company’s inventories before going on to deal with invoices and orders. In early 2001, administering the database was a daunting task. By early 2002, however, YOMO had this well under control and was looking at other ways of optimizing data management.
In collaboration with REALTECH, they decided to develop an archiving approach to prevent their system from growing excessively, and to help them cope with data warehousing issues. Against this background, YOMO and REALTECH recovered the data archived during the project, and decided which and how much information would be managed via the SAP Business Information Warehouse. The SAP solution further reduces the amount of data that the group’s core systems have to deal with, ensuring that capacity problems are a thing of the past.
About YOMO
In Italy, the YOMO group is a leading manufacturer of dairy products and fresh food. Headquartered near Milan, YOMO has around 600 employees. The group also owns and markets other brands: Merlo, Pettinicchio, Torre in Pietra and Mandria. YOMO distributes its products throughout Italy via some 500 sales agents. Seven distribution centers and 50 transit points enable daily deliveries to between 40,000 and 50,000 retail outlets.