02 // work
3 areas
§
Data Extraction & Analysis
Built a pipeline of SQL views and Python extractors to pull structured records from the warehouse management system — tracking box locations, type transitions, stock levels, and movement sequences. Analysis targets unnecessary moves, unblocking events, and speed-buffer utilisation to quantify inefficiencies and guide scheduling decisions.
- Box-level record extraction and state tracking across time
- Anomaly detection on weight measurements and lot expiry
- Movement analysis: unnecessary relocations, blocking patterns, unblocking frequency
- Article stock reconciliation and location-change auditing
§
Dashboards & Reporting
Built and maintained automated dashboards in Apache Superset and Power BI for ongoing performance monitoring. Implemented a reporting pipeline that pushes updated metrics to clients on a scheduled basis, reducing manual overhead.
- Apache Superset dashboards with automated data refresh via API
- Power BI reports for stock and quality analysis
- Scheduled report delivery with client-specific export logic