P Product
Strategic Network Exit Tool
A decision-support product that helped teams understand why inventory was accumulating and identify actions before costly liquidation became the default outcome.
Type
Product
Core Competency
Product Development
33%
overstock inventory reduced
250+
associates trained
Enterprise
scale after handoff
Win in Digital
recognition award
Context or Challenge
Excess inventory accumulated in fulfillment locations without one clear view of the underlying drivers or recommended next steps.
Observation
Teams could see the inventory, but they could not quickly distinguish whether the issue was related to pricing, product availability, customer-facing publication, competitive position, or another readiness factor.
Insight
Decision support needed to explain the likely cause and point users toward an action, not simply display the size of the problem.
My Thinking
I organized fragmented inventory and e-commerce signals around the decisions merchants needed to make. The experience emphasized root-cause visibility, prioritization, and recommended action.
What I Built or Led
I developed a tool that surfaced excess-inventory drivers and recommended actions, then created enablement to help merchant teams incorporate the product into recurring inventory decisions. The root-cause diagnostic and action-routing logic below shows what that looked like in practice.
Featured Capability: Root-Cause Diagnostic Engine
- Replaced manual triage with a rules-based check that evaluated each excess item against common root causes -- item publication status, pricing and promotional state, buy-box competitiveness, page traffic and conversion, and catalog quality -- and returned a plain-language reason, not just a number
- Grouped and ranked excess-inventory dollars by root cause, so the highest-impact issues surfaced first instead of requiring manual review of every item
- Routed each root cause to the team actually positioned to fix it -- merchandising, replenishment planning, or site merchandising -- turning one report into three coordinated action queues
- Powered both an executive-level aggregate view and an item-level desk view from the same underlying model, so leadership and operators worked from identical logic
Technology Behind the Tool
- SQL (decision-tree, conditional root-cause logic)
- BigQuery-based enterprise data warehouse integration
- Automated, scheduled data refresh
- Rule-based root-cause classification model
- Dollar-impact ranking and prioritization logic
- BI dashboard design (executive + desk-level views)
- Cross-functional action-routing logic
How It Works, Behind the Scenes
In general terms, the tool continuously evaluates each excess item against a set of common root causes and returns a plain-language explanation instead of a raw number. That evaluation runs as decision-tree logic built directly into the underlying SQL: each item moves through a chain of conditional checks in BigQuery until it lands on the most likely explanation, and the same query logic calculates the dollar-impact ranking used downstream. Those root causes are grouped and ranked by dollar impact, then routed to whichever team is positioned to fix them. The same model feeds both an aggregate executive view and an item-level action queue, and continuous monitoring keeps the underlying data current.
Launch or Adoption Strategy
I trained more than 250 associates and transitioned the product for enterprise engineering and scale.
Business Impact
- Reduced overstock inventory by 33%
- Trained 250+ associates
- Scaled beyond the original use case after enterprise handoff
- Recognized with a Win in Digital award
Key Takeaway
“Decision-support products create more value when they explain why a problem exists and what a user can do next.”
Capabilities Demonstrated
- Product discovery
- Decision design
- Root-cause diagnostics
- Inventory strategy
- E-commerce readiness
- Cross-functional enablement
- Change management
- Enterprise scaling