3P Application (Lean Management)

Challenge

KONE is one of the global leaders in the elevator and escalator industry. KONE developed Microsoft Access application for their internal use to support 3P method (Production Preparation Process). The application is customized for their factory in Ústí nad Labem (list of employees, production lines, etc.). We were asked to create a couple of new features in the current application (e.g., automatic email reporting, new Abnormality type – KAIZEN, etc.). The current functionality had to be preserved, and we were asked to improve the performance.

Output report grouped by shifts and assembly lines
New KAIZEN abnormality
Automatic email notifications
Better performance

Solution

The application was built on Microsoft Access 2010 platform with Microsoft SQL Server database server backend. We had to learn all processes in the application to preserve and test the original functionality. By simplifying and optimizing the queries, we successfully managed to speed up the whole application and to make the user experience better.

Technologies used

Microsoft Access

Previous case study

Next case study

3P Application (Lean Management)

Challenge

Solution

Technologies used

Do you want the perfect solution for your company?

Do you want the perfect solution
for your company?