Business Intelligence Project

Designed and implemented a scalable inventory dashboard that consolidated data from multiple warehouse bin placement types across thousands of SKUs. The solution integrated REST APIs from the warehouse management system with advanced SQL window functions to enable accurate stock tracking and streamlined reconciliation with other systems the client used. This project improved operational clarity by transforming fragmented stock placement data into a single, actionable interface. Worked closely with operations and developer teams to validate real-time inventory views and ensure seamless integration with ongoing warehouse workflows.