Every solution below was delivered to a client. Clients are described by sector rather than named, and internal product names are removed. Each card lists what was built, the measured outcome, and how long it took.
Power BI and Microsoft Fabric reports, the semantic models behind them, and the pipelines that keep them refreshed. Most of these replaced a report someone assembled by hand in Excel.
Replaced client's manually compiled Excel portfolio status reports with a governed Microsoft Fabric Data App that gives eight departments at-a-glance triage of their Portfolio, refreshed straight from their application database.
A monitoring and diagnostic report that tells client how much to trust its demand forecasts - measuring accuracy and bias against arriving actuals across vintages, horizons, and methodology eras, which replaces roughly eight hours of manual forecast tracking each month.
A semantic model and BI solution that lets analysts explore and export time-series data from client's time series data warehouse without any SQL knowledge.
A semantic model and BI solution that automates client's monthly regulatory reporting to its regulator, integrating data from multiple utility service facilities and transforming thousands of transactional records into interactive analytics.
A semantic model and BI solution that integrates financial and operational data from multiple independent regulated entities into a single analytical platform, enabling cross-entity comparisons and data-driven analysis.
A semantic model and BI solution that automates demand forecast analysis, cutting manual Excel blending and enabling self-service insights for Finance Managers, Data Scientists, and Economists across client's operations.
Forecasting, clustering, topic modeling, and one-off statistical analysis, delivered as scheduled pipelines or apps your team runs, with tests and a runbook.
A pipeline that ingests and processes IT Customer Support Service data, discovers and assigns topics to each ticket, ranks them by volume and resolution time, and produces a FAQ for staff to review on demand.
A pipeline that consolidates adjacent, common-owner tax lots into single buildable sites, correcting a long-standing supply overcount in client's six-year buildable land inventory.
An analytics tool to inspect regional planning simulation model calibration runs, enabling rapid loss-convergence visualization, parameter significance testing (pseudo-ANOVA/pseudo-F), and easy comparison of model specifications.
An automated time-series forecasting system that runs a multi-model competition across statistical, machine-learning, and transformer approaches to generate accurate 70-month forecasts for over three dozen demand series, enabling data-driven long-term capacity planning and budget development.
A reproducible, court-ready data pipeline that reconciled the opposing party's truck-diversion logs against scalehouse transaction records and exposed that 90% of sampled diversion claims were contradicted by their own data.
Web applications that replace the spreadsheets and email threads a team runs its operations through: data-entry systems with validation and role-based access, internal tools, and AI assistants grounded in your own documents.
Designed and built an AI assistant that answers client staff and tax administrators' questions about the income tax, replacing hours of repetitive phone and email support that spike around quarterly filing deadlines.
A full-stack data management platform that consolidates fragmented operational and financial data from several of the client's source data systems into a centralized, validated database, replacing manual Excel workflows and providing a clean data foundation for ongoing cost-of-service rate studies.
A full-stack enterprise performance measures database system that replaces manual Excel-based workflows for 20+ client departments, featuring role-based access control, automated validation, and real-time reporting.
AI-powered tool that analyzes demand forecast dashboards and generates standardized narrative reports on demand, cutting manual report-writing time while enforcing consistency with client's reporting standards.