Built a full-stack database system using ASP.NET and PostgreSQL that consolidated all capital project data into a single internal web application. The system allowed users to import CSV files or manually input data, with search, filtering, and detailed project views. Replaced fragmented Excel workflows entirely.

Automated compliance monitoring by integrating daily data from a proprietary source into Power BI. Used Python and Power Query to clean and transform data for 15 chemicals across 15 locations, building a dimensional model for analysis. The dashboard tracked compliance thresholds in real time and triggered automated reports via Power Automate, alerting the responsible manager whenever a chemical approached non-compliance.

Mapped the entire data flow and used Excel as the warehouse layer. Built a template that auto-generated a master sheet, monthly sheets, and yearly sheets for each location annually. The team entered data once in the master sheet, and XLOOKUP formulas connected it to all downstream reports. Once entered, data flowed automatically into monthly and annual reports, fully removing all manual work.

Pulled sales data from the SAP API (job type, cost, revenue, and margins) and stored it in Azure SQL Data Warehouse. Ran a cross-reference analysis and discovered that residential window services had the highest margins but the fewest jobs. Unlike car services where people have a “car guy,” residential window tinting is actively searched rather than referred, meaning low awareness was the bottleneck, not demand. Recommended marketing adjustments targeting search audiences to boost conversions and improve overall margins.