Enterprise Case Study • Manufacturing Execution System

Manufacturing Production Control & Traceability Architecture

How Techfics engineered a zero-downtime Production Control System (PCS) for Maruwa Malaysia and Maruwa Japan (TSE Prime: 5344), automating batch traveler serialization, dynamic QR tracking, and precision tolerance compliance across five cleanroom manufacturing stages.

100%
Batch Traceability
0
Lot Mixing Errors
< 15s
Audit Query Recall
< 5s
Batch Registration

Client Entity

Maruwa (M) Sdn Bhd / Maruwa Japan

Industry

Precision Ceramics & Circuit Fabrication

Deployment Scope

Cleanroom Plant Shop Floor (Intranet)

Core Technology

FastAPI, MS SQL Server, Thermal QR Scanners

01
Operational Friction & Risk

Business Challenge

Maruwa is a world-class Japanese precision ceramics manufacturer listed on the Tokyo Stock Exchange (TSE Prime: 5344). In their semiconductor packaging and medical-grade precision component lines, raw powder must undergo exact press molding, thermal sintering, grinding, lapping, and dimensional inspection.

The Shop-Floor Pain Points:

  • Manual Paper Travelers: Physical job sheets moved along lines, suffering coffee stains, smudged ink, and misplacement across 24/7 rotating 3-shift crews.
  • Lot Mix Risks: Raw powder lot numbers and pressing machine mold codes were handwritten, introducing the risk of unverified powder lots being commingled.
  • Time-Consuming Customer Audits: Traceback of a specific valve or seal required quality managers to manually retrieve paper binders from physical archives, often taking 2 to 4 hours per query.
  • Fragmented Station Data: Inability to prevent an operator from processing an out-of-spec lot at grinding when the sintering stage had logged an abnormal thermal curve.

Maruwa required an air-gapped, zero-lag production control system that shop-floor operators could run rapidly wearing cleanroom gloves, with zero toleration for barcode scanning delays.

02
Bespoke Shop-Floor Architecture

Techfics Solution

Techfics designed and implemented a custom Shop-Floor Production Control System (PCS) featuring automated lot serialization, thermal QR label dispatch, and real-time tolerance validation across all five stages of the manufacturing lifecycle.

Stage 01
Pressing

Automated C-prefix serial & QR traveler generated upon mold start.

Stage 02
Firing

Kiln batch linkage & furnace thermal ramp verification.

Stage 03
Grinding

Micron dimensional verification against locked CAD specs.

Stage 04
Lapping

Surface roughness inspection with scan-to-advance barrier.

Stage 05
QC Final

Digital CoA release & sealed customer package barcode.

Core Solution Capabilities:

Deterministic Serialization Engine

Automated sequential C-prefix 6-digit serials (C000001 to C999999) and dynamic daily powder lot sequences (M-yymmddT-N) eliminating duplicate numbers across lines.

Thermal QR Batch Travelers

Automated print execution on 70mm × 45mm heat-resistant thermal stickers with high-density 2D QR codes containing encrypted batch hashes.

Spec Master Lockout

Tolerances are tied directly to relational database master records. The system actively blocks lot advancement if dimensions exceed allowable micrometers.

3-Column Ergonomic UI

Single-screen, no-scroll interface optimized for touch terminals with sequential Enter-key field jumping for sub-5 second operator registration.

03
Industrial Engineering & Stack

Technology & Integration

Cleanroom production lines cannot tolerate cloud latency, external internet dependencies, or heavy browser frameworks that lag under continuous shift use. Techfics implemented an ultra-lean, localized industrial stack:

// Maruwa Production Control System (PCS) Architecture
• Backend Service: Python FastAPI (Async ASGI, Uvicorn Workers)
• Database Engine: Microsoft SQL Server Enterprise Edition
• Driver & Connection: ODBC Driver 17 with pyodbc pre-allocated connection pool
• Frontend Interface: Lightweight Vanilla JavaScript (0 external CDN dependencies)
• Hardware Layer: Zebra & Honeywell 2D QR Barcode Scanners + TSPL/EPL Thermal Printers
• Network Topology: Isolated Plant VLAN (OT Subnet) with zero internet ingress
• Data Redundancy: SQL Server High Availability Mirroring + Daily Encrypted Backup Snapshots

FastAPI Serialization Endpoint Logic

To ensure multiple operators pressing batches simultaneously never collide or generate duplicate serials, Techfics implemented an atomic database transaction with strict row locking:

@router.post("/api/v1/batches/register")
async def register_batch(batch_in: BatchRegistrationSchema, db: Session = Depends(get_db)):
    # 1. Fetch and atomically increment running sequence with UPDLOCK
    seq = await db.execute_scalar(
        "SELECT NEXT VALUE FOR dbo.Seq_ProductionLotNumber WITH (UPDLOCK)"
    )
    serial_no = f"C{seq:06d}"
    
    # 2. Compute dynamic powder shift code: M-yymmddT-N
    lot_code = generate_dynamic_powder_lot(batch_in.powder_grade, batch_in.shift_id)
    
    # 3. Commit record and dispatch thermal QR traveler payload
    batch_record = await persist_batch_and_specs(db, serial_no, lot_code, batch_in)
    return {"serial": serial_no, "qr_payload": batch_record.qr_data}

The system is fully decoupled from Maruwa's corporate WAN, ensuring that even during plant-wide WAN maintenance or optical fiber outages, factory floor production continues with 100% autonomy and 0 ms network jitter.

04
Measured Business Impact

Verified Business Results

Following deployment across Maruwa's production lines, the system delivered immediate, verifiable operational outcomes documented during internal quality reviews:

100% Traceability

Zero Blindspots

Every component is indexed to its original powder shipment, sintering kiln run, pressing mold serial, and QA technician timestamp.

90% Faster Audits

<15s Query Time

Customer and ISO audit inquiries that previously took 2–4 hours of physical binder searches are now resolved within 15 seconds.

Zero Lot Mix Errors

100% Enforcement

Digital spec-locks and 2D QR gate validation completely prevented incompatible powder mixtures or unverified mold lots from entering sintering.

Sub-5s Registration

Operator Velocity

Operator data-entry velocity increased 4x thanks to auto-fill masters and sequential Enter-key field focus navigation.

Engineering Review Feedback
“Techfics delivered an industrial solution that understood how our plant floor actually functions under shift pressure. The QR batch traveler workflow eliminated our paper burden while giving our Japan headquarters complete real-time verification of batch compliance.”
M
Manufacturing Operations Lead
Maruwa (M) Sdn Bhd

Ready to Digitize Your Shop-Floor Operations?

From PLC edge gateways to full-scale MES and batch traceability systems, Techfics engineers high-availability industrial software tailored to your production workflow.