/02—Selected Work
Set-Center ERP / MES
Manufacturing & Inventory Management System — Japan
Lead / Sole Backend Engineer
Node.jsTypeScriptExpress.jsPostgreSQLPrismaWebSocketsAWS S3LINE APIJWTRBAC
Project Overview
Production ERP/MES backend for a food packaging manufacturing company in Japan. Sole backend engineer across the full project lifecycle — from requirements and architecture through development, deployment, and ongoing maintenance. The system manages production scheduling, multi-stage inventory, transactional workflows, real-time factory floor updates, and document generation.
Backend & Engineering Highlights
- —Sole backend engineer responsible for architecture, development, deployment, and maintenance.
- —Designed and implemented 50+ relational models handling manufacturing, inventory, and operational data in PostgreSQL with Prisma.
- —Built core ERP modules: production scheduling, multi-stage inventory management, and transactional business workflows with ACID consistency.
- —Implemented WebSocket-based real-time broadcasting for live factory floor status and operational event updates.
- —Created a server-side PDF generation pipeline for order sheets, packing slips, delivery notes, and management reports.
- —Integrated AWS S3 for secure document storage, media attachments, and file management.
- —Implemented JWT authentication, role-based access control (RBAC), and LINE API notification workflows.
- —Delivered the system to production and maintained it through iterative feature additions and client feedback cycles.