Selected work
Problems first. Tools second.
A collection of analytics and data-product stories focused on performance, trust, self-service, and decision support. Company data and implementation details are generalized where needed.
01
Renewal Reporting, Re-architected
From a 31-CTE live view to a high-performance Snowflake Dynamic Table architecture.
~3 min → ~110ms
SnowflakeSQLDynamic TablesPerformance
02
cabi Intelligence
A governed natural-language analytics layer built to make recurring business questions self-service.
Business logic → self-service
Cortex AnalystSemantic ModelsAI Governance
03
When the Numbers Don't Match
A root-cause investigation into a significant difference between executive and analytics reporting.
~$150K variance
ReconciliationSQLData Quality
04
Modernizing the BI Layer
Migrating legacy Tableau assets to governed published data sources while uncovering a hidden deduplication problem.
~19 dashboards
TableauGovernanceSnowflake
05
From Manual Reporting to Automation
Using Python, SQL, Excel, Power Query, and Snowflake to turn recurring analyst work into repeatable workflows.
Reusable workflows
PythonSQLAutomationExcel