NEO BA

Project

Description: The construction of a dedicated ERP for one of the perfumery market leaders in Germany

Key topics:

• Creation of a single, dedicated, consistent ERP system for the association of 180 independent companies with different requirements.
• Standardization of business processes across the organization in the field of procurement, warehousing, sales, marketing, sales planning and price management.
• Supporting the Customer in business processes modeling.
• Carrying out the project throughout the life cycle – from needs analysis to implementation and maintenance.

Business goals:

• Increasing the efficiency of the shops by providing, on the basis of Software as a Service, an efficient system to handle all the processes of the store, warehouse and headquarters.
• Increasing the transparency of data across the system by ensuring the integrity and availability in real time.
• Creating a user-friendly mechanism combining data from the stores with online data from suppliers and making web service available for future integration.
• Allowing everyday secure access to current inventory and sales data of more than 90 000 products.

Range (solutions):

• The first 5 deployments in perfumeries, ranging from a few to more than twenty shops, realized from spring 2014 until end of 2015.
• Ultimately, the system will be used in all companies belonging to the association in Germany.

Challenges:

• The need to provide a solution flexible enough to meet the demands of companies of all sizes, from those that have 1 shop, to the network consisting of more than 100 stores.
• Preparing the system to receive a huge amount of data. After implementing, the system handled approx. 0.5 TB of data, and the planned amount of actually processed transactional data is 50 TB after 12 months of operation.
• Implementation of a huge amount of functionalities and the need to manage nearly 1 million lines of produced code with tests.
• Optimization of query performance, for processing very large amounts of data in a synchronous manner, e.g. inserting 100 thousand items in one transaction.
• Integration with systems providing raw data („dirty”), and then developing a semantic and syntactic cleaning process.
• Creation of a rich and flexible user interface, giving high functionality – even when using only a keyboard.
• Remote cooperation of the development team from Szczecin with Customer’s teams in Bielefeld and consultants in Karlsruhe.

Evaluation of results:

• “… very satisfied with the level of services provided by Consileon Polska on this project, especially with the ability of Consileon Polska developers to ad-hoc understand and implement complex processes, also with regard to often not so obvious cross-process interdependencies. The development team not only handled technical/implementation issues, but also actively participated in shaping the details of business processes, providing valuable input, which lead to better understanding of the problem at hand on all sides. On the technical side solutions designed and implemented by Consileon Polska fully met our expectations and customer requirements. Consileon Polska developers proved that they can work on highly complex processes, without an extensive documentation and provide a result that fulfills business requirements while being state of the art, performant and well-designed also on the technical side” – Thomas Harer, Project Manager at Consileon Business Consultancy GmbH

• “More than 30 members in two countries have conceptualized and perfected the … project, not only to afford us a safe system, but also to make the everyday work day in the perfumeries easier and more transparent.” – CEO of end-customer

• “We are proud to offer our members the most modern system, which was developed especially for the needs of the modern perfumery” – CEO of end-customer