MySQL

Project Snapshot Sales leaders needed a trustworthy system to track incentives across cards, loans, and cross-selling campaigns. This backend streamlines goal management, reward policies, and compliance-ready reporting. Business Context Built to replace spreadsheets that obscured advisor performance and bonus eligibility. Equips managers with transparent dashboards to coach teams and justify payouts. Lays the groundwork for omnichannel banking experiences by exposing clean REST APIs. Core Capabilities JWT-secured authentication with Spring Security guarding every endpoint. Role-specific workflows for managers, advisors, finance analysts, and reporting stakeholders. Goal and points engine that ties products to reward tiers, updates progress, and prevents duplicate credit. Comprehensive API surface covering managers, advisors, financial products, clients, sales, and KPI reports. Realtime-ready architecture using WebSocket support for instant leaderboard refreshes. Implementation Notes Spring Boot 3.1 with JPA orchestrates persistence against MySQL, supported by H2 for local testing. OpenAPI/Swagger documentation auto-generated via SpringDoc for faster onboarding. Modular layering (controllers, services, repositories) keeps business rules testable and extensible. Packaged with Maven for streamlined deployment into bank-managed infrastructure. My Role I reimagined the legacy rewards process, modelled the domain, implemented the security and data layers, and configured observability scaffolding for future production rollout. ...

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. ...