SGreens ERP System
ERP platform for inventory, HR, payroll, and operations
Project Overview
SGreens is an ERP system built for a poultry farm business that was running operations across multiple disconnected tools. The platform consolidates inventory tracking, HR and payroll management, financial reporting, and supplier workflows into a single system. Built with React and Spring Boot, it replaced manual processes with structured, role-based digital workflows.
Problem Statement
The business was managing inventory on spreadsheets, HR records manually, and invoices on paper. There was no single view of operations โ stock levels, employee records, and financials all lived in separate places, causing delays and frequent data errors.
Architecture Overview
React frontend with Spring Boot backend and MySQL database.
System Architecture
React dashboards, tables, and reporting UI
Spring Boot services handling business logic
MySQL with relational schema
Key Features
Inventory Management
Real-time stock tracking with inward and outward movement logging and supplier workflow management.
HR & Payroll
Employee records, attendance tracking, and automated salary processing with calculation rules.
Financial Reporting
Invoice generation, expense tracking, and management dashboards with drill-down reporting.
Role-Based Access
Admin, Supervisor, and Worker roles with separate permissions and dashboard views per role.
Performance Optimization
Pagination and lazy loading implemented for large dataset tables across inventory and HR modules.
Engineering Challenges
Cross-Module Data Consistency
Inventory, HR, and finance modules share relational data โ ensuring updates in one module reflect correctly across others required careful API design and state management.
Large Dataset Performance
Tables with thousands of inventory and HR records required pagination, lazy loading, and component memoization to keep the UI responsive.
Role-Based UI Logic
Each role (Admin, Supervisor, Worker) sees a different set of modules and actions. Implementing clean RBAC without duplicating components required a structured permission system.
Impact
Replaced 4+ disconnected tools (spreadsheets, manual HR records, paper invoices) with one unified system
Inventory tracking and supplier workflow modules handle stock movements end-to-end
HR and payroll module manages employee records and salary processing
Performance optimized for large datasets using pagination and lazy loading