Industrial OEE System Development

Project Title:
OEE Monitoring System Development (ESP32 + Node-RED + Orange Pi + MQTT + SQLite)

---

Project Description:

I am looking for an experienced developer to build and complete an industrial OEE (Overall Equipment Effectiveness) monitoring system based on my existing architecture.

The system is already partially designed, and the web dashboard is already available. The main task is to complete the data acquisition, processing, and integration layers.

This is an edge-based industrial system, not a simple web app.

---

System Architecture Overview:

Machine → ESP32 → Orange Pi → Node-RED → MQTT → Dashboard
↓
SQLite (historical data)
↓
Firebase (cloud sync)

---

Scope of Work:

1. ESP32 Development

- Read machine data via:
- Digital inputs (RUN, STOP, pulse counter)
- Modbus RS485 (via MAX485)
- Send data to Orange Pi via UART (USB serial)
- Data format should be structured (preferably JSON)

---

2. Node-RED Development (Main Logic Layer)

- Read serial data from ESP32
- Parse and normalize data
- Implement OEE calculation:
- Availability
- Performance
- Quality
- Handle machine state logic (RUN / STOP / STANDBY)
- Calculate runtime and downtime accurately
- Manage production session (production_id)
- Handle operator input form (Node-RED dashboard)

---

3. MQTT Integration

- Publish structured data to MQTT topics:
- machine/status
- production data
- OEE values
- Ensure real-time updates

---

4. SQLite Integration

- Store historical production data
- Store reject logs and machine status logs
- Ensure proper database structure and performance

---

5. Firebase Sync

- Sync SQLite data to Firebase when internet is available
- Ensure system works fully offline and syncs when online

---

6. Dashboard Integration

- Connect Node-RED/MQTT data to existing dashboard
- Ensure:
- Real-time data works
- Historical data loads correctly
- No need to build dashboard from scratch

---

7. Remote Access

- Setup Cloudflare Tunnel for access from outside local network

---

8. Node-RED Web Form
Create operator input form for:

- Product
- Target production
- Cycle time
- Shift
- Operator name
- Planned start / end
- Break time (multiple)
- Reject input (anytime)
- Downtime reason

---

Technical Requirements:

- ESP32 programming (Arduino / ESP-IDF)
- Node-RED (advanced flow design)
- MQTT (Mosquitto)
- SQLite
- Basic Node.js understanding
- Experience with industrial data / IoT systems is a big plus

---

Important Notes:

- Dashboard is already built
- Focus is on backend, Node-RED logic, and ESP32 integration
- System must work offline (local network)
- Must be stable for industrial use

---

Deliverables:

- ESP32 source code
- Node-RED flows (well structured & documented)
- SQLite schema
- MQTT topic documentation
- Setup & deployment guide
- Basic documentation of OEE calculation logic

---

Preferred Candidate:

- Experience with industrial systems / IoT
- Familiar with Node-RED and MQTT
- Able to design clean and maintainable data flow

---

Please include in your proposal:

- Relevant experience (Node-RED / MQTT / ESP32)
- Similar projects (if any)
- Your approach to implementing this system

---

This project can lead to long-term collaboration for further system development.