6 years of quality solutions delivery for US energy operators and technology clients — architecture, team leadership, and client communication from requirements through production. 29 projects, each with a dedicated case study.
Manual, audit-heavy accounting built on incoming bank statements.
A US oil and gas operator needed derivative journal entries produced from incoming bank statements - a manual, error-prone, audit-sensitive close process.
Case study →
Well and property records that didn't agree across five source systems.
Built the master-data backbone for a US upstream operator's Snowflake estate: an end-to-end cross-reference (Xref) system unifying identifiers across five source systems (ERP, production, land, drilling), plus Well Master and Property Master reporting found…
Case study →
Company knowledge scattered across hundreds of tools and databases.
Designed, developed, and deployed an MCP-native AI knowledge platform that gives AI assistants governed, consolidated access to a company's internal systems and databases.
Case study →
A full Snowflake estate that had to move during a corporate transition.
When one US energy operator's assets transitioned to another, the entire Snowflake analytics estate had to move with them - data layers, object layers, security, and downstream reporting.
Case study →
A land system with sparse documentation and opaque relationships.
Built a complete land-entity data stack for an energy data platform where the source system had minimal documentation and limited insight into its internal relationships.
Case study →
Drilling data locked in tables nobody could visualize.
Delivered a Snowflake-based application that renders detailed, interactive wellbore schematics from WellView source data - every object and component in the wellbore, with historical context attached, explorable through 2D and 3D visuals.
Case study →
Bad data discovered only when a report looked wrong.
Designed, developed, and implemented a Snowflake-based data quality framework for an energy operator's critical reporting views, surfaced through Sigma dashboards.
Case study →
“Why did this well produce less than expected?” — asked daily.
Built production variance reporting over ProCount data in Snowflake with Sigma dashboards for a US upstream operator, plus daily production (days vs. depth) reporting over WellView drilling data.
Case study →
Business and financial rollups living in spreadsheets.
Architected, deployed, and project-managed two Snowflake-based web applications for creating, mapping, and comparing multi-level business and financial hierarchies.
Case study →
Two systems disagree; nobody can prove where or why.
Performed comprehensive gap analysis between an energy operator's source systems and their MDM/warehouse layer, then across unified metrics, production, and volumes reporting sub-systems.
Case study →
A single-machine ERP conversion workflow at its limits.
An aging Enertia ERP conversion system - the workflow that imports and updates client company data into the ERP - was rebuilt on a hybrid-cloud approach I co-designed.
Case study →
Five source systems, five naming conventions, zero shared keys.
Designed, named, and built MatchMaker AI end to end: an ML-driven matching engine that unifies data from five oil & gas source systems - ERP, reserves, production accounting, drilling operations, and scheduling - into one cross-reference backbone.
Case study →
Land answers assembled by hand from multiple systems.
Developed a land-management reporting suite on Snowflake for an energy data platform: Division of Interest, task usage and workload, acreage, wells, and data quality reporting, delivered through Tableau.
Case study →
Brittle manual data handling feeding a global producer's SAP.
Modernized the data intake workflow for a global chemicals and energy producer running a legacy drilling-software estate: built secure processes to ingest data from multiple streams, then process, transform, and load it into SAP and SQL systems using Azure …
Case study →
Business-critical reports; near-zero documentation; limited access.
Built two business-critical financial reports - owners to be paid, and ledger - for a client on SQL Server, working with very limited access and near-zero documentation.
Case study →
A US SaaS platform needing architecture, scale, and cost discipline.
Led cloud engineering for a US SaaS platform on AWS: designed the microservices and API architecture, DB schemas (MySQL RDS, Cassandra), and the AWS roadmap across logging, encryption, metrics, storage, compute, delivery, security, and sustainability.
Case study →
Relationship-shaped questions relational databases answer slowly or never.
Helped design and build a graph-based data analytics platform on AWS: DynamoDB and PySpark for data processing, Neo4j for graph storage and analytics, serverless stack provisioned with Chalice.
Case study →
Reorgs breaking rollups that lived in spreadsheets.
Architected the cloud solution, deployed, and project-managed DataAmplifier: a Snowflake-based web application for creating, mapping, and comparing multi-level business structures.
Case study →
Financial rollup trees changing faster than reports could follow.
Architected, deployed, and project-managed the Hierarchy Manager web application: a Snowflake-based tool for creating, mapping, and comparing multi-level financial structures.
Case study →
A production integration that had to survive deployment, not just development.
Developed TIES-related objects over Snowflake for a US energy operator, reviewed work completed by other developers, prepared deployment scripts, and project-managed the integration effort end to end: implementation review, deployment readiness, and structu…
Case study →
Midstream volumes with reconciliation challenges all their own.
Project-managed a midstream data initiative for a US oil and gas operator: provided technical guidance to the development team, maintained the deployment cycle, and kept implementation planning, technical coordination, and release management aligned through…
Case study →
A commercial MDM covering only part of the estate.
Developed the end-to-end integration of the EnerHub cross-reference system across a US operator's Snowflake environment.
Case study →
Every system answering “which property is this?” differently.
Developed and co-designed the Property Master sub-system on Snowflake for a US energy operator, providing a single unified view of properties across the organization.
Case study →
A consultancy's own estate spanning three clouds.
Designed, deployed, and managed a consultancy's internal infrastructure across Azure, AWS, and GCP: virtual machines, databases, applications, networking components, and supporting cloud resources.
Case study →
The drilling curve everyone watches, rebuilt on governed data.
Developed and provided oversight for daily drilling report development over Snowflake using WellView source data, centered on days-vs-depth reporting - the curve every drilling engineer reads first.
Case study →
Production architecture on the third cloud.
Designed and deployed the cloud architecture for a route-planning application on Google Cloud Platform for a technology client.
Case study →
Adding pipelines to a production estate without breaking it.
Extended an established Azure Data Factory estate for a US energy operator, adding new workflows to production data pipelines without destabilizing what already ran.
Case study →
Five systems that never agreed on volumes and metrics.
Developed and still maintain the unified presentation layer for a US operator's reporting: volumes and metrics views fed by five different source systems over Snowflake, all resolved through the unified cross-reference system.
Case study →
Daily ops numbers and monthly accounting numbers that never agreed.
Developed the daily and monthly production reporting suite for a US operator based on the ProCount production accounting system - the operational heartbeat reports that production and management teams open every morning and every close.
Case study →Have a data or AI problem worth solving? Let's catch up.
Contact me