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, case coordination, 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: Medical Device, Supply Chain, Distribution

About

Background

Over 13+ years in operations, the last 6+ managing field inventory for a medical device division, and before that leading quality control in high-volume distribution. For me, numbers were never abstract: a single miscount could mean a surgeon lacked the right implant.

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 RoleSurgery Coordinator / Field Inventory

CompanyZimmer Biomet

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

Medical Supply Chain Audit Simulator

PostgreSQLDBeaverDockerpgAdmin

A 7-table relational database simulating a regional medical supply chain across six clinical sites. Built to demonstrate real-world 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 sites

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

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

04N95 Respirators identified as highest-cost reorder item at $3,600/site, critically low at all problem locations

05One site had the highest gap cost at $7,784, the furthest below PAR across 15 products

Surgical Instrument Deployment Planner

PostgreSQLDockerPower BIAdvanced AllocationHTML Dashboard

An 8-table relational database simulating a surgical implant deployment operation across six hospital sites. Includes allocation logic, restock triggers, a 7-day deployment calendar, and an interactive HTML dashboard.

View on GitHub →

SAP Field Inventory KPI Dashboard

PythonDAXHTML DashboardSAPHealthcare Data

A synthetic dataset and interactive dashboard modeling field inventory KPIs across a 4-territory surgical device operation: PAR compliance, reorder cost exposure, demand variance, and allocation 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.

View Live Demo →

Experience

Where I've Worked

May 2020 to Present

Zimmer Biomet

Surgery Coordinator / Field Inventory Control Specialist

Managed end-to-end field inventory lifecycle for surgical implants, ensuring 100% case readiness 3 to 5 business days ahead of procedures
Designed SAP-integrated KPI dashboards tracking inventory accuracy, order fulfillment, and demand variance across the North Atlantic 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