Manufacturing projects for IEE

Production monitoring

A web application that provides a quick overview of the current situation on the shop floor. It compares the production scan results (traceability) with the order, the recipe from SAP, and the materials and tools issued from other external systems, which gives a detailed picture of whether production complies with the recipe. The overview is provided by a comprehensive multi-level table in which repeatedly expanding rows and columns takes you from summary information on the current state of the production order down to the fine details of individual shifts and processes. Since production involves electronics, the application also tracks the employees scanned in to processes with a mandatory ESD check (electrostatic discharge) and warns if someone has skipped the check.

Other projects:

• Database migration (MaxDB → DB2) – a tool for migrating data and other database structures (constraints, triggers, …) from the old SAP MaxDB v7.4 database to IBM DB2 (v. 9.+).
• Reliable Sender library (MQTT, JMS) – wraps sending messages to a broker and survives connection outages (messages are kept in a local store and sent once the connection is restored). The implementation had to be thread-safe and, after reconnecting, had to send all the data collected during the outage.
• ESD Terminal (Warmbier PGT120 + Datalogic TD1100) – an app for testing people for electrostatic charge (employees who work with open circuits and sensitive devices). It communicates with a barcode scanner (identification) and an electrostatic testing device and sends the results to a server. The client application for the testing station was built in JavaFX.
• Device Manager – an IoT server for managing devices, extensible for specific device types. It communicates via an API with the “Sensorium” application.
• Sensorium – a web application for collecting data from IoT devices (temperature, humidity, etc.) and visualizing the collected data. It sends an alarm when a value leaves its allowed range. It uses WSO2 ESB and MB for message flow.
• and more