Data · Procurement · 2026 — Present
Purchase Document Pipeline Monitor
Fullstack Developer
A web app that monitors the full BPS procurement pipeline — PR → PO → GR → PI/AP. It imports SAP Business One Excel exports, enriches them against master data with document aging and status, and surfaces dashboards, filters, exports, and automatic stuck-PR detection so procurement never stalls silently.
Stack
PythonDjangoPandasSAP B1PostgreSQLSystem map
System captures
Problem
Procurement stages (PR→PO→GR→PI/AP) stalled silently inside SAP Excel exports — finance could not see aging or stuck documents without manual reconciliation.
Solution
Shipped a Django + Pandas monitor that ingests SAP B1 exports, enriches against master data, surfaces aging/status dashboards, and alerts on stuck PRs.
Highlights
- PR → PO → GR → PI/AP pipeline tracking
- SAP Business One Excel report ingestion
- Master-data enrichment with aging & status
- Stuck-PR detection & bottleneck alerts
- Interactive dashboards with filtering
- Data exports for finance & procurement review
Outcomes
- Stuck PRs surface early instead of after month-end pain
- Procurement and finance share one live pipeline view
- Manual SAP Excel reconciliation dropped dramatically
Impact
Gave procurement and finance a single live view of every document's stage and age — catching stuck PRs early and cutting manual SAP Excel reconciliation.