->
Industrial systems intelligence

I turn warehouse data into decision-grade evidence.

I investigate warehouse systems the way an analyst should: by cross-referencing WMS behavior, mainframe logic, and physical reality until the hidden failure mode is undeniable.

Four years at CVS Distribution Center 8. Currently an Operations Lead Coordinator working across operations, systems investigation, process improvement, and analytical escalation.

~$14M+Documented issue exposure
20K+ABN records traced
~35K ft³Recoverable capacity documented
12Certifications and tracks
Warehouse systems intelligence visualization
SignalInventory mismatch detected
MethodCross-system validation
Impact register

Evidence translated into business exposure.

~$11M/yr

Assignment failure exposure

Identified inventory deductions happening without corresponding pick assignments, creating hidden lost-sales and adjustment exposure.

Corporate escalation

$498K

CC2 billing mismatch

Joined cycle count and billing data to surface systematic overages across 159 items rather than isolated variances.

SQL documented

$200K+/yr

XYZ coordinate defect

Traced reserve overstates into Cherry Pick failures, stocking abandons, and compounding operational waste.

Root cause found

20K+

TWI root-cause trace

Linked 20K+ ABN records into a causal chain from reserve overstates through Cherry Pick failures and stocking abandons.

Failure path established

~35K ft³

Recoverable reserve capacity

Mapped misconfigured reserve logic and blocked storage locations to reveal meaningful zero-capex capacity recovery.

Zero-cost opportunity

87.5%

Cubiscan measurement error

Audit showed most sampled items were understated in WMS, distorting slotting, utilization, and transportation assumptions.

Physical audit completed
Selected investigations

Structured case work built for leadership, not just local fixes.

The same analytical approach applies across any warehouse or supply chain system — the tools change, the logic doesn't. Each investigation is built to survive scrutiny, not just explain a local anomaly.

Investigative evidence wall for warehouse systems analysis
Investigations combine floor validation, query work, pattern recognition, and escalation-ready documentation.
Case file

WMS Assignment Failure — "Bomb" Issue

~$11M/yr
Problem

Inventory was being deducted in WMS without creating valid pick assignments, so product never moved while the system behaved as though it had shipped.

Root cause

Assignment logic allowed deductions without a corresponding executable pick path, hiding the failure behind system-valid looking transactions.

Action

Built the evidence trail, quantified the site-level exposure, escalated the issue to leadership, and pushed it into an official vendor investigation path.

Outcome

Vendor-level ticket opened after leadership escalation; the finding moved beyond local operations into enterprise review.

Infor WMS 2000Assignment logicRevenue impactEscalated
Case file

CICS vs WMS Billing Logic Mismatch

145 orders / 9 days
Problem

The mainframe enforced a four-unit minimum while WMS allowed sub-minimum shipments, creating repeatable overbilling and fulfillment contradictions.

Root cause

Cross-system business rules were not aligned, so one environment permitted transactions the other priced and interpreted differently.

Action

Analyzed shipment patterns by order size, reconciled system behavior across both environments, and documented a network-level architecture mismatch.

Outcome

Established that the issue was systemic cross-system logic conflict rather than user error or isolated transaction noise.

CICSCross-systemBilling discrepancyArchitecture gap
Case file

Reserve Capacity Unlock

~35,000 ft³
Problem

Valid reserve locations were being skipped or underfilled because location descriptions, cube assumptions, and putaway logic were misaligned.

Root cause

Wrong height limits, incorrect cube capacities, and missing location types in WMS location master data blocked otherwise usable storage.

Action

Audited location data against physical conditions, mapped the logic path, and quantified recoverable space without infrastructure spend.

Outcome

Produced a clear zero-capex recovery path that translated system cleanup into tangible storage capacity.

PutawayLocation masterCapacityZero capex
Case file

CC2 Billing Mismatch

$498K / 159 items
Problem

Persistent discrepancies between cycle count quantities and billed quantities appeared across many SKUs instead of behaving like isolated counting noise.

Root cause

Process gaps in the inventory-control workflow allowed count-to-billing mismatches to persist without a consolidated view of impact by item.

Action

Built SQL queries to join CC2 records against billing tables, grouped findings by item, and quantified both per-item and aggregate overage.

Outcome

Full analysis documented and reported, reframing the issue as systemic financial exposure rather than local variance.

SQLCycle countsBillingDocumented
Case file

Cubiscan Measurement Error Audit

87.5% error rate
Problem

WMS cube values did not match physical product dimensions, undermining slotting, utilization, trailer loading, and transportation assumptions.

Root cause

Cubiscan measurement values stored in WMS were systematically lower than actual product dimensions.

Action

Re-measured representative items, compared physical dimensions to system values, and modeled how understated cube data distorted planning.

Outcome

Converted a hidden data-quality issue into an operations and cost story decision-makers could act on.

SlottingPhysical auditCube utilizationData quality
Case file

Stray Case (TWI) Root Cause Analysis

20K+ records
Problem

"Twilight Zone" inventory appeared at rates suggesting systemic causes rather than random human error or one-off handling misses.

Root cause

Reserve overstates led to Cherry Pick failures, which triggered stocking abandons and ultimately generated stray-case inventory exceptions.

Action

Extracted and segmented 20K+ ABN records by reason code, location, time, and item, then cross-referenced those records against XYZ defect data to establish the causal chain.

Outcome

Investigation moved from loose suspicion to repeatable failure-mode analysis with a defensible logic path.

20K+ ABN recordsFailure mode analysisPattern recognitionUnder investigation
Case file

Slotting Optimization & Putaway Logic Model

Model in development
Problem

High-velocity SKUs were sitting in low-efficiency slots while putaway rules lagged behind actual demand patterns and corrected cube dimensions.

Root cause

Slot assignments were not aligned with velocity tiers, and putaway logic was not incorporating corrected cube dimensions, anchor locations, and reserve constraints.

Action

Ranked SKUs by velocity, cross-referenced them with corrected Cubiscan data, and built a putaway decision framework around cube capacity, reserve height, and anchor-location logic.

Outcome

Developed a practical optimization model aimed at reducing travel, overflow, and storage inefficiency without adding infrastructure.

Velocity analysisAnchor locationsCube capacityPutaway logic
Case file

Chargeback & Vendor Compliance Analysis

Ongoing tracking
Problem

Receiving discrepancies and ASN accuracy issues were costly, repetitive, and hard to prioritize without a structured view of repeat offenders and trends.

Root cause

Vendor compliance issues were dispersed across daily exceptions instead of being tracked as a recurring analytical pattern with accountable sources.

Action

Tracked discrepancies by vendor, receiving event, and exception type to surface repeat offenders and support better operational follow-through.

Outcome

Turned ad hoc exception handling into a repeatable compliance signal that supports vendor conversations and internal accountability.

Receiving discrepanciesASN accuracyRepeat offender trackingCompliance
Analytical method

A repeatable way to expose hidden operational failures.

My approach is built to move from weak signal to hard evidence without losing the operational context that makes the finding credible.

01

Spot the anomaly

Start with the signal others gloss over: an unexplained variance, odd trendline, stranded location, or exception volume that refuses to behave normally.

02

Validate against reality

Compare system assumptions to the floor, the process, and the physical inventory so the investigation stays grounded in operational truth.

03

Trace the logic path

Follow the failure through WMS rules, mainframe behavior, records, locations, and transactions until the real break in logic becomes visible.

04

Quantify the impact

Turn the issue into concrete exposure using dollar value, throughput loss, space recovery, labor waste, or risk concentration.

05

Document and escalate

Package the finding so leaders and vendors can act on it, with enough structure to survive review beyond the immediate team.

Systems and buildout

The working toolkit behind the findings.

These are the environments, tools, and analytical surfaces I use to transform messy operational noise into explainable action.

Cube Utilization Dashboard

Dashboarding warehouse cube usage to expose underutilized reserve patterns and slotting inefficiencies.

Power BIExcelWMS exports

Damage Tracking Dashboard

Operational visibility layer for damage trends, recurring sources, and corrective-action prioritization.

Power BIProcess analysisException data

Inventory Mis-Stock Search

Targeted analysis flow for finding misplaced or stranded inventory records faster than manual review alone.

SQLWMSAd hoc investigation

Undelivered Item Analysis

Evidence-driven analysis used to isolate why shipped assumptions and delivered outcomes drift apart.

Variance analysisMainframeWMS

Throughput Analytics

Throughput views built to understand bottlenecks, dwell-time patterns, and system-handling friction.

ExcelBIOps metrics

Cycle Count Variance Tracker

A structured view of count-to-billing mismatches that turns recurring discrepancies into reportable evidence.

SQLCycle countsReconciliation

WMS & enterprise systems

  • Infor WMS 2000
  • CICS mainframe
  • Cross-system issue tracing

Inventory control

  • Cycle counting (CC1/CC2/CC3)
  • Billing reconciliation
  • ABN exception handling

Slotting, cube & putaway

  • Velocity-based assignments
  • Location master review
  • Reserve height optimization

Data & analytics

  • SQL
  • Power BI
  • Excel
  • Pattern recognition

Operational analysis

  • Chargeback analysis
  • Vendor compliance
  • Inbound/outbound trend analysis

Process & leadership

  • Escalation-ready reporting
  • Cross-team communication
  • Analytical ownership
Operational analytics

Ongoing analysis work that keeps the floor visible.

Not every contribution begins as a marquee defect. Some of the most valuable work is persistent analytical ownership that turns recurring operational noise into usable management signal.

Inventory adjustment & variance analysis

Continuous review across CICS, Cognos, and SQL to distinguish noise from actual process drift and inventory exposure.

CICSCognosSQL

Inbound vs outbound volume analysis

Volume trend analysis used to expose flow imbalance, capacity pressure, and operational bottlenecks before they become reactive problems.

Volume trendsThroughputCapacity

Daily report ownership

Ownership of Bad Item, Detail Change, and Out of Tolerance reporting to maintain visibility on recurring exceptions and corrective follow-through.

Bad ItemDetail ChangeOut of Tolerance

Chargeback & vendor compliance tracking

Structured tracking of receiving discrepancies, ASN accuracy, and repeat offenders to support operational accountability.

ReceivingVendor complianceASN accuracy
Career signal

Experience shaped on the warehouse floor and in the data trail.

The strongest part of the portfolio is not a title. It is the pattern of being trusted with issues that carry operational and financial weight.

Apr 2024 — Present

Operations Lead Coordinator

Inventory & systems analysis focus

CVS Distribution Center 8 — Aiken/Graniteville, SC

Operating at the intersection of floor execution, inventory control, and systems investigation while surfacing hidden failures standard reporting misses.

  • Identified assignment failure exposure, quantified the site-level risk at roughly $11M per year, escalated the finding to leadership, and helped move it into vendor review.
  • Identified XYZ coordinate defects, quantified the exposure at $200K+ per year, documented the logic path at the location level, and translated the issue into an actionable failure mode.
  • Documented reserve-location corrections that revealed roughly 35,000 cubic feet of recoverable storage capacity without capital spend.
  • Conducted TWI root-cause analysis across 20K+ ABN records and established the causal chain back to reserve overstates and Cherry Pick failures.
  • Built internal dashboards and analysis tools to close WMS visibility gaps and strengthen exception handling.
  • Developed a data-driven putaway optimization model using cube utilization, anchor locations, reserve height, and velocity tiers.
  • Led throughput analytics, volume analysis, and shift performance reporting to support operational decisions.
  • Ran continuous variance analysis using CICS, Cognos, and SQL to separate repeatable system issues from local noise.
Sep 2022 — Apr 2024

Inventory Control Clerk

Analytical foundation and system visibility

CVS Distribution Center 8 — Aiken/Graniteville, SC

Managed daily inventory accuracy while building the analytical capabilities that surfaced systemic issues others missed.

  • Identified the CC2 billing mismatch, quantified a $498K overage across 159 items, and documented the findings for escalation.
  • Executed the Cubiscan audit, found an 87.5% understatement rate, and documented downstream impact on slotting, cube utilization, and transportation assumptions.
  • Managed cycle counting, slotting, chargeback analysis, markouts, and ABN exceptions with a strong bias toward root-cause analysis.
  • Built cube utilization, damage tracking, mis-stock search, and undelivered-item tools to improve local analytical visibility.
  • Developed SQL queries against Informix 4GL environments for ad hoc WMS extraction and reconciliation work.
  • Initiated vendor-compliance tracking for receiving discrepancies and owned daily exception reporting.
  • Promoted to Operations Lead Coordinator based directly on analytical contributions and investigative impact.
Recognition and escalation history

Director-level escalation — findings were forwarded to corporate leadership for review when the evidence showed broader system exposure.

Promoted from Inventory Control Clerk to Operations Lead Coordinator based directly on analytical impact and investigative ownership.

Trusted to investigate high-impact system issues that typically sit outside ordinary operations scope.

Official Infor vendor ticket opened from WMS defect analysis substantial enough to warrant formal review.

Findings have influenced internal discussions around system fixes, operational changes, and vendor-level investigations.

Credentials

Technical depth backed by continuous study.

Formal coursework, analytical tooling, and operations methodology all reinforce the same thing: a bias toward precise thinking and useful execution.

Six Sigma Black Belt
Power BI
Snowflake
Tableau
SQL
Python
Data Analytics
Supply Chain
Excel Advanced
Lean Operations
Data Visualization
CCNA (In Progress)
Education

A.S. Computer Networking & Programming

Expected 2026

Systems fluency
Technical foundation
Analytical range
Next step

Let's talk about analytical roles where operational truth matters.

Targeting data analyst, business systems analyst, and supply chain analytics roles focused on operational efficiency, systems reliability, and measurable business impact. The strongest fit is any team that values evidence, cross-system reasoning, and operational follow-through.

Reach me directly by email, connect on LinkedIn, or download the resume version that best matches the role: Data Analyst or Supply Chain / Operations.