Coffee Supply Chain & Sustainability Traceability

Digitalizing traceability and global compliance for sustainable coffee supply chains.

Overview

Engineered a robust full-stack ecosystem to manage and track supply chain data for over 1,000 farmers across multiple regional branches. The platform is designed to transition manual tracking into a digital ecosystem, supporting the company’s compliance with international standards such as 4C (Common Code for the Coffee Community) and EUDR (European Union Deforestation Regulation).

Technical Highlights

Monorepo Architecture: Orchestrated a unified Monorepo structure to manage both React.js (Frontend) and NestJS (Backend) within a single codebase, improving developer productivity and code sharing.
Containerized Infrastructure: Fully Dockerized the entire application ecosystem, ensuring seamless deployment, scalability, and environment consistency across development and production.
Automated CI/CD Pipeline: Established a continuous deployment workflow using GitHub Actions. The pipeline automatically detects changes, executes security audits, builds and pushes images to Docker Hub, and triggers seamless container updates on the VPS.
Proximity Tracking & Precision Counting: Developed a real-time location-based feature to calculate the exact distance between the mobile device and designated counting points, ensuring data accuracy during field audits.
Geospatial Land Mapping: Engineered a sophisticated Polygon Mapping system to measure and visualize farm boundaries, enabling precise land area calculations and deforestation monitoring.
Full-Stack Architecture: Built a high-performance system using React.js and NestJS, integrated via Prisma ORM for robust database management.
Garmin Data Processing: Engineered a specialized file parsing engine to process and synchronize spatial data uploaded directly from Garmin GPS devices, ensuring high-precision field data collection for remote areas.
Automated Data Pipelines: Developed an Excel import/export engine with automated validation logic to handle massive datasets and prevent duplicate entries (Status: Imported, Hold, Duplicate).

Impact

Operational Accuracy: Eliminated manual measurement errors through automated distance tracking and polygon-based land area calculations.
Audit Readiness: Streamlined the preparation for 4C and EUDR audits by providing verifiable and precise geospatial data in a centralized digital repository.