session: silvafelipe.mainframestatus: onlineinterface: human / terminal
back to logs

Case Study: Process Automation Suite

Bridging the Gap: ERP to Machine

One of the most impactful projects I've worked on is the Process Automation Suite. It addresses a common problem in manufacturing: the disconnect between the "office" (ERP systems) and the "floor" (CNC machines and operators).

The Problem

Information was being manually transcribed from digital work orders into machine controllers. This introduced:

  • Human Error: Typos in dimensions or tool offsets.
  • Latency: significant time lost walking back and forth.
  • Lack of Traceability: No digital record of when a program was loaded.

The Solution

I built a desktop application using Electron and React that acts as the bridge.

Key Architecture

  1. Electron Main Process: Handles low-level serial port communication (RS-232) with older CNC machines and network requests to newer ones (OPC UA).
  2. React Renderer: Provides a clean, touch-friendly interface for operators to view work orders.
  3. Node.js Middleware: Fetches live data from the ERP API to validate job status before allowing a program download.

The Results

  • Reduced Setup Time: Setup time dropped by ~15% per job.
  • Zero Transcriptions Errors: Direct data transfer eliminated manual entry mistakes.
  • Operator Satisfaction: Replaced a complex paper shuffle with a simple "Scan & Load" workflow.

Tech Stack Highlights

  • Electron: For cross-platform desktop capabilities and hardware access.
  • SerialPort: For communicating with legacy hardware.
  • React: For a responsive, modern UI.

This project reinforced my belief that better software tools directly translate to better physical products.