// 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
Production Operations Dashboard
End-to-end data solution for a large printing company in Colombia. Tracks daily production progress order by order, pulling data from multiple SQL databases, web sources, and internal systems through a full ETL process. VBA macros automate daily report generation and refresh the Power BI dashboard for real-time operational visibility.
- —Multi-source ETL: SQL databases + web data + internal systems
- —Order-level daily tracking across the entire production floor
- —Automated daily refresh via VBA macros
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