Warehouse Scheduling System

Completed
Warehouse Scheduling System, schedule view preview card

Warehouse scheduling built on raw warehouse-management report exports, the schedule everyone needs, without the spreadsheet ritual.

Problem

Warehouse scheduling ran on data exported from SAP and reshaped by hand into a working schedule, daily effort, and the result lived in one person’s spreadsheet.

Solution

A system that ingests the raw exported reports, structures them into a database, and renders the working schedule for everyone who needs it, current, shared, and searchable, with operations views on top of the same data. As with all my SAP work, it operates on exported reports; nothing inside SAP is modified.

Impact

The schedule became a shared, always-current view instead of a private spreadsheet rebuilt each morning.

Built with

DjangoPythonMySQLopenpyxl