PortfolioSelected founder experience
Making inactive inventory visible.
Automated analysis of $110M in stagnant inventory at Lowe's, supporting clearance decisions and an improvement in inventory turns from 3.7 to 4.0.
Selected professional experience of TvastrOps founder Roshan Mani Rao R at Lowe's, completed before TvastrOps. Role: operations and inventory analyst responsible for the analysis described.
- Stagnant inventory analyzed
- $110M
- Inventory turns
- 3.7 → 4.0
Project scope and measurement context
- Industry
- Digital
- Scope
- Operational Analytics, Dashboard Development, Data Integration, Inventory
- Project context
- Selected professional experience of TvastrOps founder Roshan Mani Rao R at Lowe's, completed before TvastrOps. Role: operations and inventory analyst responsible for the analysis described.
The $110M figure is stagnant inventory analyzed for clearance decisions. It is not cash recovered or realized savings. Valuation dates and final disposition outcomes are not published.
[ The challenge ]
Stagnant inventory tying up working capital.
Slow-moving and stagnant stock was tying up working capital across a large retail assortment, and finding clearance opportunities meant manual analysis that was slow to repeat.
[ The results ]
$110M of stagnant inventory analyzed, inventory turns up from 3.7 to 4.0.
As operations and inventory analyst, Roshan automated the Python, SQL and Excel analysis behind the inventory review. It identified $110M in stagnant inventory for clearance and disposition decisions and supported an improvement in inventory turns from 3.7 to 4.0. The $110M is inventory value identified, not cash recovered or realized savings. In DMAIC terms: the problem was defined as stagnant stock tying up working capital; measured with automated analysis across the assortment; analyzed to isolate $110M in stagnant inventory; improved through clearance and disposition decisions that supported turns rising from 3.7 to 4.0; and controlled by making the analysis repeatable instead of a one-off manual review.
[ highlights ]
What changed.
- 01
Automated analysis of $110M in stagnant inventory.
- 02
Python, SQL and Excel analysis replaced manual review.
- 03
Identified clearance opportunities in slow-moving stock.
- 04
Repeatable analysis instead of one-off manual reviews.
- 05
Supported an improvement in inventory turns from 3.7 to 4.0.
Project scope
- Operational Analytics
- Dashboard Development
- Data Integration
- Inventory
[ related projects ]
More from the floor.
[ start here ]
Let’s talk aboutyour warehouse.
Congested storage. Slow picking. Stock that won’t stay accurate. Lines waiting for parts. Tell us what isn’t holding and we’ll tell you where we would start.