Axalta
..
Background

The marketing department of Axalta creates and maintains technical documents / manuals for over 3000 SKUs in 27 languages. All these documents were created and maintained by 4 FTEs. The original version of these documents was always compiled from data and safety phrases from R&D, the pictures came from the marketing department and these data were further supplemented with free text. The original version was then send to 27 specialized translators. The translated documents were checked for correctness of the data and the layout was adjusted because the translations often turned out to be longer than the original text.

Challenge

Axalta wanted to automate this process in a way that after defining the content of the basic document, no work is required for translations and control of lay-out, but the uniformity and standardization of the end result remains guaranteed.

Solution

We provided a web application (based on a database) that retrieves the necessary data from the R&D database, takes photos from marketing database, uses as many icons as possible and uses standard sentences from a translation database. The application neatly converts all that content into one document with the correct layout for 27 languages. The result is a set of PDF's that nobody needs to check. For a new product, human work is therefore limited to defining what information must appear on the document. When data or photos change over time, the documents are updated automatically. When new sentences prove necessary , translators receive a message and can enter them directly in the translation database.

The productivity improvement is huge. There is now only 1 instead of 4 FTEs working on the documents. The duration from the introduction of a new document to the final result in 27 languages went from 3 months to 1 day and there were substantially fewer errors in the published documents.

Quick
..
Background

The menu and publicity screens, promotions and music in the restaurants were controlled by different systems and had to be handled by the local restaurant.

Challenge

Quick was looking for an integrated solution in which all screens and the music in the restaurants (individually or in group) could be directed from a central point via internet. The content had to continue to play autonomous also when the internet connection would be lost.

Solution

Coteng developed an application for the central marketing department. Via this application you can determine what should be shown on a certain screen, in a certain restaurant, at a certain time with or without sound / music. Users can plan videos, photos, presentations, live images, scrolling text or combinations thereof. In this application the different types of content and the music are combined into a playlist that can be previewed immediately and can be published in a schedule per week. To prevent screens going black when the internet connection drops out - what happens with traditional streaming technology - content for a full schedule on the local screens are buffered and repeated until new content is available.

Axalta
..
Background

As a car paint supplier, Axalta helps bodywork companies to improve their productivity. This requires a lot of data to be collected about the daily operation of the company: working hours per repair, consumption of paint and other goods needed for the repair. Once these data have been collected, a number of KPIs can be calculated that indicate where improvement is possible. For a consultancy service, providing such a service is time-consuming and expensive matter that needs to be repeated regularly to be effective.

Challenge

The development of a solution that allows the owners of bodywork companies to permanently evaluate productivity / profitability.

Solution

We developed a web application that:

  • registers working hours per vehicle via barcode scanning or manual entry per task (cleaning, sanding,primer, etc.);
  • keeps track of paint consumption per vehicle via scales and / or manual input;
  • keeps track of the consumption of other goods via scanning or manual entry (tape, sanding paper, masking film, etc.) per car.
The application allows the owner to monitor and manage the processes in his business in real time. There are always a number of predefined KPI's available (numerically or graphically) so that the owner knows where adjustment is needed.

Standox
..
Background

Sales people at Standox spend up to 10% of their time making quotes. That is a cumbersome process because these people themselves do not have access to SAP. They had to look up the price information in a spreadsheet (thousands of SKUs). Because SAP had a different product hierarchy compared to the one used by sales, it was also difficult to search in those list. Photos of the products had to be searched in a marketing database, to then copy paste them into the quotation. Because Standox products may have solvents, commercial quotes must also indicate the quantity of solvents contained in these products. This information had to be retrieved from yet another database. Finally, the sales person complied all that information together with an accompanying text in a Word document. Since everyone did this in their own way a uniform layout was lacking in the quotations made.

Challenge

Standox asked Coteng to automate the process so that sellers no longer lose time making quotes.

Solution

A web application that sales people could use from any location was our solution. The price data is now automatically retrieved from SAP and grouped according to a customer-friendly product hierarchy. The accompanying photos are automatically taken from the marketing database and the solvent values from an R&D application. All this content is then compiled into a single document with a nice layout, following the Standox house style. Furthermore, the application checks whether the sales person adheres to the agreed rules for giving discounts and if necessary his manager is automatically asked to approve an exception. When the potential customer approves the quotation, the prices with corresponding customer-specific discounts are loaded into SAP.

BNP Paribas Fortis
..
Background

BNP Paribas Fortis has been working for years with a customized communication gateway from Coteng. This ensures the integration of various business applications that are directly or indirectly related to e-mail, fax and SMS. Since 2018 it is mandatory for financial institutions, in the context of MiFID II, to archive a copy of all personalized publicity. The system the bank used to send publicity via e-mail does not have that option.

Challenge

The bank asked us to archive the emails in a generally supported format that can display e-mails as they were shown to the customer. Tags had to be added to this to make searching in the archive possible. Such publicity campaigns often generate tens of thousands of e-mails per hour. To process these flows a high-performance application is required.

Solution

Modules were added to the existing gateway to convert outgoing e-mail messages with personalized publicity into pdf format and add the necessary tags (campaign, customer, ...). These files then are delivered to the standard application that archives them as prescribed in the MiFID II legislation.