Beverage Inventory Revolution

Project Snapshot Inventory operations for a fast-growing Peruvian beverage brand needed a single source of truth. I built a focused desktop logistics tool that keeps stock levels, movements, and alerts in sync across the company. Business Context Designed to replace fragmented spreadsheets with a guided workflow tailored to Oasisdrinks processes. Enables supervisors to visualize product turnover, pending restocks, and warehouse balances without manual reconciliation. Core Capabilities Modular Java Swing views for catalog management, purchase intake, and dispatch confirmation. MVC-based domain layer that isolates business rules from presentation for faster iteration. MySQL persistence with transactional safeguards to prevent duplicate or out-of-sync stock movements. Role-aware access that keeps critical actions limited to authorized clerks and managers. Implementation Notes Built with an extensible DAO pattern, paving the way for future web or API fronts. Includes seed data and environment scripts so new operators can trial the workflow quickly. MIT-licensed delivery with clean documentation for internal IT hand-off. My Role I led the full software lifecycle: gathering requirements with the operations team, designing the interaction model, developing the Swing UI and persistence layer, and deploying the pilot rollout. ...

August 22, 2024 · 1 min