File Diff Tool

Two versions of a vendor data file were arriving weekly with no easy way to spot what changed. Wrote a script for Excel that compared the files row by row and flagged discrepancies in a separate sheet. Replaced a manual process that was taking a few hours each time.

Vendor File Reconciliation

Two vendor data exports were arriving weekly and needed to be compared against internal records to catch discrepancies before they became billing issues. Built a script that diffed the files, flagged mismatches, and output a clean exception report.

Internal Alert Workflow

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

Weekly Ops Report Automation

A team was manually pulling numbers from two separate systems each week and compiling a summary for management. Set up a scheduled process that pulled from both sources, reconciled the data, and delivered a formatted report by email every Monday morning.