At Border Guards Intelligence & Security Office, I engineered a Python and Apache Airflow pipeline that turned tens of thousands of unstructured Word inventory documents into validated SQL Server data and Power BI reports. The tools made recurring stock questions answerable by query instead of manual search, and remain in use after my posting ended.
In personal projects, I built a Microsoft Fabric food-delivery Lakehouse with deployment pipelines and automated duplicate and PII checks, and a Snowflake and dbt ELT pipeline with incremental models and SCD Type 2 history. I also led a four-person team on a DEPI graduation project to deliver an Azure ELT pipeline for NYC Taxi data.
