William Rogan

At Xumo, a Comcast subsidiary, I build BigQuery-backed Periscope/Sisense analytics for FAST ad monetization, following SSAI delivery from ad requests and fill through impressions and yield. My reporting has surfaced revenue leakage from privacy opt-ins and ad-server hop latency, helping teams and partners drive fixes.

I trace hard-to-find delivery failures to their source. I identified a long-running Samsung TV Plus traffic-loss bug through minute-level CDN logs, connected it to shared program IDs in a partner stitcher, and drove an API-level export fix that eliminated it.

I also build the validation and pipeline tooling behind reliable partner delivery: JSON and XML feed parsers, VOD catalog pipelines, EPG schedule diffs, and a normalized Airtable channel tracker. A six-hour Gracenote schedule-diff pipeline isolated scheduler changes behind recurring EPG drift and supported a 48-hour schedule-lock window.

My work spans AWS MediaTailor, MediaLive, MediaConnect, ad-server integrations, HLS, EPG metadata, SQL, and BigQuery. I started at Xumo as a QA contractor, creating concurrent multi-feed recording and stream-verification tooling, and was promoted to Product Management within six months.