📊
SSD DC Scorecard — Operations Dashboard
AWS Cloud • Data Pipeline • Live Dashboard
Full-stack operations scorecard serving 7 warehouses with real-time KPIs across leadership, ops, and engineering views. Built on a serverless AWS pipeline: Andes/Redshift SQL queries export via Datanet to S3, rendered through a Chart.js dashboard hosted on CloudFront.
Features 11 analytical datasets covering volume/throughput, quality scorecards, shift performance, zone heatmaps, bottleneck analysis, cost-per-unit tracking, and hourly intraday monitoring — all with warehouse-level filtering.
▶ Live Preview
- 3-tab dashboard: Leadership KPIs, Ops real-time, Engineer diagnostics
- 11 SQL queries against Andes (Redshift) with weekly Sun–Sat aggregation
- Automated data pipeline: Datanet → S3 → SPICE-ready CSVs
- CloudFront + S3 static hosting with Origin Access Control
- Warehouse filter across HDC3, HGA6, HLA6, HMW3, HNE1, HPA1, HTX3
- IAM least-privilege: QuickSight + Redshift read-only policies
AWSS3CloudFrontQuickSightRedshiftSQLPythonChart.jsIAMDatanet
🔥
Goldilocks — Capacity Management Platform
Real-Time Monitoring • Automated Controls
Full-stack desktop app monitoring bin, bay, and aisle utilization across drop zones and pick areas in real time. Color-coded heatmaps, automated lock/unlock via BinConf CSV upload, and 13x speed improvement over browser scraping using direct HTTP calls.
- Real-time drop zone and pick area utilization tracking
- Aisle-level heatmap with stowmap class-N color mapping
- One-click lock/unlock with automated BinConf CSV upload
- API parameter capture and caching for direct-mode scraping
- 15-minute auto-refresh with multi-warehouse support
PythonTkinterSeleniumREST APIsOpenPyXLThreadingJSON Caching
🚨
Andon Monitor
Alert Tracking • Analytics Dashboard
Real-time warehouse andon monitoring dashboard that tracks alert counts by type, dwell time analysis (0-12h, 12-24h, 24-48h, 48h+), and weekly top puller rankings.
- Multi-page pagination scraping for complete data extraction
- Automated login with security key authentication flow
- Hidden browser operation with win32gui window management
- Clickable CSV exports by type, dwell category, or puller
- Auto-refresh every 15 minutes with session persistence
PythonTkinterSeleniumWin32 APIExcel COMThreading
🛣
Pick Path Generator
Aisle Sorting • Path Optimization
Automated pick path generation tool that sorts bin IDs by aisle, shelf, and slot with configurable snake or zig-zag patterns. Outputs BinConf-ready CSVs for direct upload.
- Snake pattern: alternates shelf direction per slot (A-Z, Z-A, A-Z...)
- Zig-zag pattern: repeats same direction for all slots
- Z-K mode: custom shelf sequence skipping L-Y on reverse
- Dual-aisle interleaving for paired VNA aisles
- 200-row configuration for full facility path planning
PythonPandasTkinterOpenPyXLCSV
🗑
Bulk Delete & Sideline Tool
Inventory Management • Browser Automation
Dual-tab automation tool for mass item deletion and sidelining via AFT and Poirot. Handles the full workflow with progress tracking and Excel log exports.
- Automated AFT Delete Items workflow with 5 deletion reason types
- Poirot-based sidelining with confirm/change container flow
- Session reuse across runs (no re-login required)
- Structured Excel logs with container, ASIN, disposition, and cost
- FC Research integration for dropzone-based bulk extraction
PythonSeleniumTkinterOpenPyXLCSVThreading
🚚
Inbound Flow Monitor
Real-Time Tracking • Web Dashboard
Web-based inbound flow monitoring system integrated with FMC. Tracks VRIDs, pallets, units, and door assignments in real time with auto-refresh.
- Live VRID monitoring with pallet and unit counts
- Door assignment tracking per VRID
- Performance metrics and KPI dashboards
- Multi-user profiles with per-user credentials
PythonFlaskHTML/CSS/JSSeleniumFMC API
📈
WAVE DPT — Damaged Inventory Tracker
Quality Monitoring • Automated Reporting
Automated scraper and reporting tool for FC Quality damaged inventory data. Generates actionable reports for inventory governance and deletion cost tracking.
- Automated FC Quality data scraping
- Excel-based damaged inventory adjustment tracking
- Configurable warehouse and report parameters
PythonSeleniumExcel/VBAJSON Config
🕑
Inventory Dwell Time Analysis
Facility Audit • Inventory Intelligence
Multi-join analytical query calculating container dwell times across an entire fulfillment center. Uses temp tables, window functions, timezone conversion, and COALESCE chains.
- 12+ table joins across containers, bin items, stow metrics, pick actions, and ASIN catalogs
- Window functions to isolate most recent stow/pick per bin
- Spatial bin parsing (mod, aisle, level, slot) for heatmap-ready output
- Pallet-nested item resolution via containing_container_id traversal
SQLRedshiftWindow FunctionsCTEsTemp TablesTimezone Conversion
⚠
Overweight Package Safety Report
Safety • Automated Alerting
CTE-based query identifying packages exceeding 50 lbs. Feeds an automated daily email alert system that routes flagged items to safety teams.
- Multi-step CTE pipeline: heavy items → container mapping → weight enrichment
- FCSKU → FNSKU → ASIN resolution chain across 3 catalog tables
- Directly reduced workplace injuries through proactive rerouting
SQLRedshiftCTEsMulti-Table JoinsAutomated Alerting
📋
Standard Work Compliance Monitor
Regional Monitoring • Accountability
Operational compliance query tracking dirty cage container movements across the network. Distributed via automated daily email to regional leadership.
- Dwell time calculation in days and hours for SLA tracking
- Associate-level accountability with move-by tracking
- Pattern-matched container filtering (dirty cage locations)
SQLRedshiftDATEDIFFPattern MatchingAutomated Distribution