How custom software leads to more productivity
Compose and maintain technical data sheets.
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.
This was their working process:
- 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.
- That version was then sent 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.
From a manual process to an automated process
Axalta wanted to automate this process in a way that after defining the content of the basic document, no work would be required for translations and control of lay-out. Of course the uniformity and standardization of the end result had to remain guaranteed.
Achieving results with a custom application
We developed 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 PDFs that nobody needs to check.
- Human work is therefore limited to defining what information must appear in 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
- Substantially fewer errors are being made in the published documents.
Custom web application integrates marketing communications
Different systems per location
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.
Automatic control from a central point
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.
Time saving and uniformity with custom software
Coteng developed an application for the central marketing department.
Via this application the user:
- can determine what should be shown on a certain screen, in a certain restaurant, at a certain time with or without sound / music
- 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.
Smart application boosts productivity
Collect data and calculate KPIs
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 a time-consuming and expensive matter that needs to be repeated regularly to be effective.
Develop a method to evaluate productivity continuously
The development of a solution that allows the owners of bodywork companies to permanently evaluate productivity / profitability.
Web application maps business processes in real-time.
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 KPIs available (numerically or graphically) so that the owner knows where adjustment is needed.
Administrative software leads to significant time saving.
Capture data from different software programs
Sales people at Axalta spend up to 10% of their time making quotes. That is a cumbersome process. These steps are involved:
- These people themselves do not have access to SAP. They have to look up the price information in a spreadsheet (thousands of SKUs).
- SAP uses a different product hierarchy compared to the one used by sales, therefore it is also difficult to search in those list.
- Pictures of the products have to be searched in a marketing database. The copy-paste-function is used to insert them into the quotation.
- Because Axalta products may contain solvents, commercial quotes must also indicate the quantity of solvents contained in these products. This information is to be retrieved from yet another database.
- Finally, the sales person compiles all that information together with an accompanying text in a Word document. Since everyone does this in his own way a uniform layout was lacking in the quotations made.
Process automation ensures ultra-smooth working methods
Axalta asked Coteng to automate the process in order to no longer lose time making quotes.
Simple web-based tool to make quotes, results in more time to focus on sales
A web application sales people can use from any location was our solution.
- The price data are 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 Axalta 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
Powerful app is the solution for mandatory data archiving
New legislation requires new communication flow
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 possibility.
Data processing and storage in a user friendly format.
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.
Extension to existing application provides data archiving conform the legislation
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.
An API platform connects different applications in a cost efficient way.
When different systems need to communicate.
Several large companies have presented us with a similar problem in the past. They use different communication systems (e-mail, fax, SMS and others) and different systems for content generation or content archiving. Usually, the need quickly arises to combine the different applications. Connecting such systems one to one results in an exponentially growing number of interfaces.
From one on one to a platform.
Customers wanted a solution that allows to connect the different systems in a more efficient way without sacrificing capacity, speed and reliability.
A modular platform allows unlimited combinations.
A server application was developed that functions as a high-speed, high-capacity switching system to store and forward messages. An external system is connected to the switching system by a 'connector' (interface). Once connected, the remote system can communicate with all other connected systems. If a message cannot be forwarded for some reason (eg receiving system not available) it will be send again later. If problems persist, the system administrator will be notified, the message will never be 'lost'. At the same time, a log of all traffic is kept. Connectors are available for many popular communication platforms. If the application to be connected is not included, we develop a connector once.
Some typical examples of connected systems: different e-mail systems, fax, SMS, IBM MQ, application to generate promotional messages , application to generate PIN code, application to confirm appointments via SMS, application to legally archive mails, etc.
Automation for the calculation of the Green Power Certificates (GPC)
Processing data for the application of the GPC
Parkwind builds and operates offshore wind farms. In addition to electricity, these windmills also generate a constant stream of data. This data stream can deviate due to various causes. For example, a broken sensor, or maintenance work or simply a counter that has reached its maximum and jumps back to zero.
Until recently, Parkwind used standard software to process the data for the application of Green Power Certificates (GPC). Loading the data, correcting anomalies, and start processing took their engineers quite a bit of time each month. Moreover, those actions were also very susceptible to human error.
Process data streams efficiently
Cleaning and processing the data stream taking into account all possible deviations and exceptions giving the engineers a noticeable time saving. In other words: efficient data processing.
Automation delivers significant time savings
Initially, AI was considered to work with. But after further analysis with the engineers, it turned out that the anomalies were easily identifiable. AI only makes sense when the logic between input and output is not clear. It also requires a huge amount of historical data for the model to 'learn'. Therefore, we decided to do things differently. First, we defined all possible deviating scenarios. Subsequently, we built custom software that knew what to do in case of any deviations. As a result, the Green Power Certificates are automatically requested to the government.
Ultimately, this automation saves Parkwind 2 to 3 days of manual and repetitive work every month. The GPCs are approved faster because human error is excluded. The engineers are happy to be relieved of this monotonous task while maintaining control.