Engineered Workflows

Portfolio

I design structured systems that eliminate friction in complex workflows — from executive reporting and regulatory monitoring to engineering data transfer and revenue operations.

All Desktop App Excel Web App Workflow
Retail Banking Monthly Board Report
Excel
Featured
Retail Banking Monthly Board Report

Power Query–driven Excel dashboard that transforms large core banking reports into executive-ready visuals, reducing preparation time from days to minutes.

Power Query Executive Reporting Banking Dashboard
View project →
Daily Concentration Report
Excel
Daily Concentration Report

Automated VBA-driven workflow that calculates loan concentration risk daily, strengthening regulatory monitoring and real-time oversight.

VBA Risk Management Banking Automation
View project →
Cost Curve Generator
Excel
Cost Curve Generator

Strategic cost modeling system that generates industry cost curves with scenario controls, enabling leadership to evaluate competitive positioning and market risk.

Financial Modeling Strategy Data Architecture Visualization
View project →
EZ Invoice
Excel
EZ Invoice

Custom Excel add-in that converts field reports and scope data into standardized, customer-ready invoices with one-click PDF generation.

Excel Add-in VBA Revenue Operations Workflow Automation Finance
View project →
CD Portfolio Optimization
Excel
CD Portfolio Optimization

Excel-based forecasting and scenario modeling tool that projects interest income and models rate changes for a $24M CD investment portfolio.

Power Query Financial Modeling Forecasting Dashboard
View project →
Annual Employee Scorecards
Excel
Annual Employee Scorecards

Automated Excel-based performance reporting system that generates role-specific annual scorecards, reducing weeks of manual compilation and standardizing evaluation acro…

VBA Reporting Automation Performance Management
View project →