2.33M-data-point analytics engine with 877K automated formulas powering all investor reporting.
When PorchPass's 7-person outsourced engineering team failed to produce a single month of investor-ready data after four months of effort ($840K/year cost), Nick was brought in as the sole replacement. Within 72 hours of receiving the requirements, he architected and delivered the Enterprise Data Analytics Engine — a 2.33M-data-point system with 877,308 automated formulas organized across 14 interconnected processing modules.
The architecture's defining innovation was its single-input design: updating one configuration parameter in the Config tab triggers a full cascade recalculation across all 877K+ formulas, producing investor-grade Data Room Tapes for the entire $74.4M portfolio. This reduced a process that previously required 40+ hours of manual spreadsheet work to under 5 minutes — a 97% time reduction generating $210,000+ in annual cost avoidance.
The engine serves as the foundational data infrastructure for all downstream reporting: Board presentations, MIAC Analytics submissions, DQ dashboards, investor Data Room Tapes, and regulatory compliance reporting. It processes 12 months of historical data across both the Rogue Credit Union ($51.8M, 413 loans) and Thread Bank ($22.6M, 207 loans) portfolios.