William Rivera Jr - Data Analyst

Data Analyst — Connecticut

William
Rivera Jr

Data Analyst & Operations Specialist

My path to data analytics didn't start with a course. It started with 15 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

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

In my current role and the last 8 years, I have been managing field inventory for a medical device division and overseeing 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

Experience15 Years Operations

FocusData Analytics Transition

GitHubgithub.com/wriveraj

Projects

Selected Work

01 — Featured

Medical Supply Chain Audit Simulator

PostgreSQLDBeaverDockerpgAdmin

A 7-table relational database simulating a regional medical supply chain across six Connecticut 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 Bridgeport Community Clinic — 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

05Waterbury Urgent Care had the highest gap cost at $7,784 — 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 Connecticut 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

Power BISAPDAXHealthcare Data

Simulating field inventory KPI tracking across a surgical device territory — fulfillment rates, demand variance, and PAR-level performance modeled from real operational workflows.

In Development

PAR Level Demand Forecasting Model

PostgreSQLPythonForecastingSupply Chain

Modeling stockout risk and PAR optimization using historical surgical case demand patterns across a multi-site medical device territory.

In Development

Cycle Count Reconciliation Analyzer

PostgreSQLPower BIRCAInventory Audit

Automating inventory discrepancy detection and root cause flagging across a multi-site surgical supply network.

In Development

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 — Present

Zimmer Biomet

Surgery Coordinator / Field Inventory Control Specialist

Managed end-to-end field inventory lifecycle for surgical implants, ensuring 100% case readiness 3–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 — 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