Excel File Diff Tool

Two versions of a vendor data file were arriving weekly with no reliable way to confirm they matched. Built a comparison tool in Excel that flagged every discrepancy row by row, outputting a clean exception report. Replaced a manual review process that was taking a few hours each time.

Power BI Finance Dashboard

Pulled financial data from a SQL database into Power BI to build a Q4 dashboard tracking P&L and accounts payable/receivable aging. Source data was validated and staged in Excel before loading, giving finance a clean audit trail alongside the live dashboard. Built two toggleable views so leadership could switch between a high-level P&L summary and a detailed AP/AR breakdown without running separate reports.

CSV Regex File Sorter

CSV files dropped from telecom vendors arrived with inconsistent naming formats. Wrote a batch script that read each filename, matched it against a set of regex patterns, and routed it to the correct vendor folder automatically. Unmatched files were flagged separately for review.

Slack Automated Alerts

Key operational thresholds were being missed because nobody was watching the dashboards. Set up a notification layer that monitored critical fields and delivered Slack and email alerts automatically when something crossed a threshold or went stale.

HubSpot Configurable Reports

A team was manually compiling a weekly ops summary from two systems. Exported HubSpot data into Google Sheets for cleanup, then built a scheduled process that pulled the reconciled data back and delivered a configurable formatted report by email every Monday morning.