Warehouse Inventory Monitoring System

Role: Fullstack Developer (team neusta | May 2023 – September 2023) Objective: Create an IoT-driven system to track inventory levels in real time across warehouse zones. Technologies & Implementation:

Hardware: Deployed Raspberry Pi 4 units with ultrasonic sensors (Python firmware) to measure stock levels. Data transmitted via MQTT to a central broker.

Frontend: Developed a dashboard using Vue.js with interactive heatmaps and inventory alerts. Integrated WebSocket for live updates.

Backend: Built REST APIs with Java/Quarkus for CRUD operations. Used Hibernate for ORM and Kafka to process sensor data streams.

Database: Stored inventory history in Cassandra for time-series data and transactional records in PostgreSQL. Challenges & Solutions:

Sensor Accuracy: Calibrated sensors to account for environmental noise and implemented data averaging algorithms.

Real-Time Sync: Optimized Kafka consumer groups to handle 10,000+ messages per second with minimal lag. Outcome: Reduced stock discrepancies by 75% and cut manual auditing hours by 60%.