William Rivera Jr - Field Inventory Control Specialist

Field Inventory Control Specialist, Connecticut

William
Rivera Jr

Field Inventory Control Specialist & Data Analyst

My path to data analytics didn't start with a course. It started with 13+ years managing inventory integrity in the field: cycle counts, allocation planning, lot traceability, account-to-account movements. I transitioned into analytics because I already understood what the data was measuring.

Now I build the tools to measure it better.

View Projects Get in Touch

Open to new opportunities

13+

Years Experience

Projects Built

Certifications

Tools & Platforms

Core Competencies

Data & Analytics: PostgreSQL, Power BI, Excel
Operations: SAP, Field Inventory, PAR Optimization
Methods: Root Cause Analysis, Six Sigma, Lean
Development: Docker, Python (in progress), HTML/CSS/JS
Domain: Retail Distribution, Supply Chain, Field Inventory

About

Background

Over 13+ years in operations, the last 6+ managing field inventory and before that leading quality control in a high-volume distribution center. For me, numbers were never abstract: a single miscount meant the right item wasn't where it needed to be, when it needed to be there.

That is the lens I bring to data. I am not just someone who learned SQL and Power BI in a bootcamp. I understand what the data is actually measuring, because I lived inside the operations that generated it.

Now I build analytical systems that surface the kind of problems that hide in plain sight: stockout risks, fulfillment failures, demand patterns that nobody caught until it was too late.

LocationConnecticut

Current RoleField Inventory Control Specialist

Experience13+ Years Operations

FocusData Analytics Transition

GitHubgithub.com/wriveraj

Skills

Tools & Technologies

Data & Analytics

PostgreSQL & DBeaver
Power BI Dashboards
Excel & PivotTables
Tableau
Python (in progress)
ETL & Data Transformation

Operations & Supply Chain

SAP (Advanced)
Field Inventory Management
PAR Level Optimization
Demand Forecasting
Cycle Counting & Auditing
KPI Dashboard Development

Methods & Frameworks

Root Cause Analysis
Six Sigma Foundations
Lean Operations
Predictive Modeling
Cross-functional Collaboration
Docker & pgAdmin

Projects

Selected Work

01 - Featured

Retail Replenishment Audit Simulator

PostgreSQLDBeaverDockerpgAdmin

A 7-table relational database simulating five retail stores replenished from one distribution center. Built to demonstrate inventory auditing, shipment discrepancy detection, PAR-level analysis, and cost exposure reporting.

View on GitHub →

01$59,752 in reorder cost exposure identified across three underperforming stores

0233.3% fulfillment rate at one store, where only 1 in 3 shipments arrived correctly

03Data integrity flag: a mislabeled shipment note masked a shortage that would have delayed reorder

04AA Batteries identified as the highest-cost reorder item at $3,600/store, low at every problem location

05One store had the highest gap cost at $7,784, below PAR on all 15 products

Store Fixture Deployment Planner

PostgreSQLDockerPower BIPre-AllocationHTML Dashboard

An 8-table relational database tracking reusable display fixtures as they move from a distribution center to six stores for planned resets, then back for inspection. Includes pre-allocation logic, restock triggers, a 7-day deployment calendar, and an interactive HTML dashboard.

View on GitHub →

Retail Inventory KPI Dashboard

PythonDAXHTML DashboardPower BIRetail Data

A synthetic dataset and interactive dashboard modeling replenishment KPIs across a 4-district, 18-store retail network: PAR compliance, reorder cost exposure, demand variance, and DC-to-store turnaround, with a full DAX measure pack included for Power BI.

View on GitHub →

Side Project

Home Repair Tracker

HTML/CSS/JSJSONBin.ioReal-Time SyncData Parsing

A fully interactive repair tracking app built from the repairs identified across the property. Features 40 prioritized repair items with step-by-step DIY guides, materials lists, contractor and permit flags, and real-time cross-device sync.

Private tool. Demo available on request →

Experience

Where I've Worked

May 2020 to Present

Manufacturing, Field Operations

Field Inventory Control Specialist

Managed end-to-end field inventory lifecycle for high-value consigned product, ensuring 100% order readiness 3 to 5 business days ahead of scheduled use
Designed SAP-integrated KPI dashboards tracking inventory accuracy, order fulfillment, and demand variance across a multi-state division
Maintained inventory accuracy above 98% through comprehensive cycle counts and root cause analysis on recurring variances
Extracted and analyzed large operational datasets using SAP, Excel, and Power BI to produce actionable reports for leadership

Oct 2013 to Mar 2020

Dollar Tree Distribution

Quality Control Lead

Led quality control operations for high-volume distribution centers, overseeing 15+ associates and inbound/outbound inventory accuracy
Built and maintained a warehouse database to track inventory movement data, enabling trend analysis and proactive bottleneck identification
Leveraged data and analytics to reduce shipment error rates and improve throughput metrics across the facility

Certifications

Professional Development

14Completed

1In Progress

2026Latest Year