Built an automated Python ETL pipeline in Databricks validating reference numbers across 600+ daily orders into Delta tables, cutting a Customer Experience reporting workflow from a half-day to under 10 minutes and preventing customs delays.

Architected a two-tier active/historical dataset modeling freight at the order and stop level across past, current, and future states, with 15-minute incremental Delta updates re-checking only changed fields — eliminating full 100–200 GB scans.

Developed an AI document scraper on the Google Gemini API extracting reference data from PDFs, reducing per-order processing from 15–20 minutes to 1–3 minutes across 18,000+ annual orders for a major CPG account.

Engineered a real-time alert system measuring order dwell times against operational windows and auto-escalating un-ingated loads, replacing manual reporting and preventing SLA breaches.

Built geospatial Power BI tracking of container paths through rail yards from ping coordinate data, piloted at one facility then rolled out nationwide, with geofence polygons covering ~75% of total volume.

Delivered a SQL-backed carrier performance scorecard in Power BI with an embedded Power App for write-back to source; surfaced historical pricing used by directors in rate renegotiations.

Held sole ownership of analytics for Mexico cross-border trade across Intermodal and Highway operations, building the SQL and Excel reporting on Cost Center health and P&L that leadership ran on.

Created the early Power BI dashboards that became the team's foundational analytics templates.

Ran P&L monitoring and KPI reporting across multiple Cost Centers; built financial models, forecasting tools, and variance tracking.

Automated recurring warehouse reporting after on-site operations analysis, giving leadership clearer throughput visibility.

Drove fleet growth from 5 to 9 drivers by analyzing utilization, demand, and per-route margins to justify each addition to ownership.

Ran invoicing, AP/AR, payroll, and fuel management in a 3-person office; delivered weekly P&L summaries and built fleet utilization tracking that improved margins.