// projects
Selected Work
Meta Invoice Automation
Automated pipeline that monitors a shared Google Drive folder for Meta ad invoices, reads and extracts data using AI, and tabulates everything into a structured report. Built for agencies managing multiple clients, where Meta can generate dozens of invoices per month across different ad accounts.
- —AI-powered invoice parsing — no manual data entry
- —Google Drive integration for seamless client handoff
- —Handles multiple clients and ad accounts at scale
Loan Projections Calculator
Web application for mortgage amortization analysis. Users can calculate their full amortization schedule and run rate-change scenarios — seeing exactly how their payments and total interest shift when rates move. Built with interactive charts for clear financial decision-making.
- —Full amortization schedule generation
- —Interest rate scenario comparisons with charts
- —Live at loanprojections.com
Automated Operations Dashboard
A self-refreshing reporting system that replaced sporadic manual reports with daily automated visibility across production, WIP, financials and operational efficiency — reducing the monthly closing cycle from 12 days to 4. Still in active production use.
- —67% reduction in monthly closing cycle (12 → 4 days)
- —4 live data sources consolidated automatically
- —Daily auto-refresh with no manual intervention
Custom ERP Implementation
End-to-end coordination of a full platform migration — from a legacy system with no support since 2004 to a modern, custom-built ERP in React, JavaScript and PostgreSQL covering 6 critical modules across the entire company.
- —Legacy system replaced across 6 business modules
- —100+ users migrated over a 10-month rollout
- —Real-time unified view of sales, ops, dispatch and billing
Paper Flow Control Tool
End-to-end visibility system tracking the full paper supply chain — from purchase order to production consumption — built after a real production stoppage exposed a critical gap in supply chain visibility. Result: zero stockout-related production stoppages.
- —Zero stockout-related stoppages after launch
- —5 supply chain stages tracked end-to-end
- —12-week max lead time managed with real-time ETAs
Todos a Aprender
End-to-end coordination of a Colombian government education program: planning, production, packaging and delivery of 7M+ textbooks across 32 titles to 14,000+ rural schools nationwide — in under 6 months.
- —7M+ books delivered on time to 14,000+ rural schools
- —32 titles managed simultaneously with zero delays
- —Full government traceability compliance, zero penalties