Potomacutonomy

Past Performance

Representative prior performance

Performed by the principal in prior employment. Not contracts held by this firm.

Government

Federal emissions compliance calendar

Integrated a compliance calendar and tasking app to track federal emissions requirements, with automated hand-off between task owners.

100% automated task hand-off

Power Apps · Power Automate · SharePoint Lists

Government

Backup generator emissions tracking

Delivered a VBA-powered Excel workbook for backup generator regulatory emissions tracking across 70+ sites.

Confirmed compliance submission approval

Excel/VBA

Energy

Sensor-to-SaaS emissions pipeline

Engineered a data pipeline connecting field sensor readings to a SaaS EHS platform for an oil & gas client.

~24 days of manual entry eliminated / year

REST API · SQL · cron · Cority

Energy

Standardized multi-source BI reporting

Built and maintained 18+ Power BI dashboards tracking TRIR, DART, near-miss, inspection closure, and training compliance across large multi-source datasets; standardized 6 source tables with corporate data analytics.

Executive report prep: 3 days → under 2 hours (94% reduction)

Power BI · AWS · Snowflake

Energy

Methane emissions data automation

Automated a data pipeline connecting field sensor time-series data to a natural gas client's compliance database.

~200 hours of manual entry eliminated / year

XML API · SQL

Energy

Interactive regulatory-requirements Sankey view

Built a bespoke interactive Sankey diagram projecting requirements across facilities with filterable views for leadership reporting.

470k+ requirements across 300+ facilities

JavaScript/TypeScript · Power BI

Energy

Enterprise ETL across 18+ databases

Designed and maintained ETL pipelines across relational databases, surfacing incomplete regulatory requirements for systematic remediation.

100k incomplete OSHA/EPA requirements surfaced across 300 facilities

AWS · Starburst · Snowflake

Manufacturing

LLM-powered safety data sheet extraction

Built an LLM-powered PDF extraction tool to structure Safety Data Sheet content for downstream compliance workflows.

SDS processing: 30+ min → under 60 seconds

LLM extraction · Python

Manufacturing

Legacy database modernization

Extracted, transformed, and loaded a legacy Microsoft Access database into Dataverse for improved reliability and querying.

40% query performance improvement

ETL · Dataverse

Energy

Automated safety & HR workflows

Automated safety training tracking, safety inspections, and vehicle telemetry workflows previously run manually.

~600 administrative hours eliminated / year

Power Automate · Power Apps · Salesforce Flows

Healthcare

Legacy test suite migration

Migrated 200+ legacy unit tests to Google Test for a medical imaging client's automation suite.

40% faster test suite runtime

Google Test · C++