IQMS — Integrated Quality Management System
An Integrated System that connects Warehouse, Quality Control & Assurance operational platform to eliminate paper-based administration work into a digitalized system that enforce ISO 22000 & HACCP compliance. This system provides audit tracebility and recall of operational process in Bionic Natura.
Waiting For Thumbnail
Challenge & Architecture Target
Data Drift and Failed Audit Traceability Risk
Miscommunication and unsynchronized standard parameter can lead to wrong test results. In Food Regulation itself, every material must be cleared before it sent to government parties for compliance.
Single Source of Truth
Integrate multiple division as a single data truth system. Reducing communication error by synchronizing end-to-end data traceability across the organization.
Engineered Modules
Raw Material Verification
Enforces Quality check with standardized parameters with internal company procedure. Digitalized document-ready system from manual note taking of laboratory testing.
Headless Google Sheets Integration
While the users stay with their spreadsheet, this system has integrated each division for continuous update of real-time operational data via Google Sheets API.
Data Parsing & Automated Compliance
Offers highlighter for every test result compared to standard quality parameters. Increased QA visibility to check differences between standard and actual lab results.
HTTP Gateway & Session Guard
Implemented route guard for user authorization in each API endpoint. Axios interceptors manage tokens and secure cross-division data access.
Architectural Highlights
Prisma ORM
Avoided raw SQL queries to prevent injection vulnerabilities. Strict schema migration history enables precise tracking of database column modifications across deployment stages.
Immutable Snapshots & Logs
Prevents unauthorized dynamic changes in historic data, guaranteeing data integrity during ISO audit reviews. Users can see the older data based on certain timeline.
Rate Limiting & Auth Guard
Protects other user from modifying unauthorized data and rate limiting to prevents multiple request in short time that potentially duplicate data and overload server