~/tags/supply-chain

Supply Chain

$ cat ~/tags/supply-chain — 2 entries

~/blog ×2

Jul 29, 2026 | Data Engineering |4 min read

Tally Prime XML to SQLite ETL Cookbook

The unglamorous plumbing behind the 18h-to-4h forecasting win: streaming a 1.8 GB Tally Prime XML export with lxml iterparse, surviving mixed encodings and damaged nodes, into an indexed SQLite frame.

Mar 30, 2025 | Data Engineering |7 min read

AI Inventory Forecasting: From 18 Hours to 4 Hours

How I replaced a crashing Excel-based inventory planning process for 7,800+ SKUs with a Python multiprocessing pipeline using Meta's Prophet AI — cutting weekly planning time from 18 hours to 4 hours overnight.