Requirements on the left, what I actually have on the right. Depth is self-rated and deliberately honest — anything that is working knowledge rather than production experience says so.
| Requirement | Evidence | Depth |
|---|
Working systems, not coursework. Several are live and clickable.
Turns raw bank transaction exports into cleaned, coded, import-ready files for accounting systems. Deterministic SQL rules handle recurring transactions; a model call resolves only novel ones and writes its decision back as a new rule row.
Pulls production, cost and operational records from separate systems into one executive view, with the joins and unit reconciliation that field data always needs before it can be compared.
A rig-site reporting tool for the company man. Photograph the tank board, the mud report, the morning numbers — the app reads them, returns a formatted report and a mobile dashboard the office can open. Runs on the company man's own laptop with a folder connection, or hosted.
Twelve years across two halves of the same problem: capturing messy operational data at the source, and building the databases and pipelines that make it usable.
Highlighted groups are the ones that matter most for the selected role.
Microsoft SQL Server · MySQL · PostgreSQL / Cloud SQL · Oracle PL/SQL · SQLite · Hadoop / HDFS
Schema design and normalization · ER modeling · constraints and referential integrity · stored procedures, views, triggers · window functions · legacy migration · data dictionaries
Query optimization and execution plans · index strategy · backup, restore and recovery · role-based access and least privilege · monitoring · capacity management
Python (pandas, pyodbc, SQLAlchemy) · Power Query · scheduled and event-driven loads · validation and QA harnesses · reconciliation · audit logging · idempotent and append-only patterns
Power BI (DAX, Power Query, data modeling) · SSRS · advanced Excel and VBA · KPI dashboard design · automated recurring reports · end-user training
Hybrid rules + LLM architectures · LLM-assisted classification with rule write-back · Azure OpenAI integration · exception-handling design
Ubuntu provisioning and administration · Docker · nginx · SSH key management · Git / GitLab / GitHub · branch-based deploys · automated test suites
Drilling and wellsite operations · borehole and formation records · fluid and water sample chemistry · sensor and telemetry time series · LOE and production data · GL and transaction data