Case study · Warehouse · Oil & gas
Wellbore schematics application
Turning rows of drilling data into interactive 2D and 3D pictures of what's actually downhole.
Problem
Everything engineers needed to know about a wellbore — casing, tubing, components, workover history — existed in the drilling system's tables. But rows and columns are a hard way to reason about a physical structure thousands of feet deep. Understanding a well's current configuration or its history meant stitching together records by hand, and that knowledge stayed with whoever did the stitching.
Approach
I worked on the development and project management of a Snowflake-based application built over WellView source data. The application renders detailed wellbore schematics as interactive 2D and 3D visuals: the objects and components attached to each wellbore, positioned as they are downhole, with the historical context of how the well got to its current state.
The data model consolidates component and event records in Snowflake into structures the visualization layer can render directly, so the schematic always reflects the source system rather than a manually maintained drawing. Throughout delivery I communicated with stakeholders to keep the implementation aligned with business and operational requirements — the people who would actually use the schematics shaped what they show.
Architecture
Outcome
Engineers can open a well and see it — components in place, history attached, in two or three dimensions — instead of reconstructing it from tables. The schematic is generated from governed Snowflake data, so it stays current with the source system, and it's become the visually striking anchor piece of the reporting estate it belongs to.