Analytics & BI · FTTG Solutions LLC
Data thatdrives decisions. Senior BI Engineer with 8+ years in the Microsoft data ecosystem. I build reporting systems that turn complex operational data into clear, actionable intelligence for stakeholders at every level.
Selected Work
Selected Outcomes Featured
Behavioral Health Performance Platform County-wide provider network
Problem
Operational and financial reporting was fragmented across 20 providers, making cross-provider performance difficult to monitor.
Solution
Built a 15-page Power BI reporting system with a Python ETL pipeline and SharePoint ingestion through Microsoft Graph API.
Impact
Delivered a single performance view for staffing, census, finance, CPO, and SE metrics to support faster county-level decisions.
Power BI DAX Python Microsoft Fabric SharePoint API Deneb/Vega-Lite
Hospital Operations Intelligence Layer Multi-department clinical operations
Problem
Leaders lacked a consistent way to compare operational and clinical performance across departments.
Solution
Designed dimensional models and semantic reporting layers, then shipped executive dashboards for shared KPI visibility.
Impact
Improved executive reporting consistency and reduced decision latency across departmental stakeholders.
Power BI SQL Server DAX Azure
Insurance Portfolio Analytics Hub Underwriting and claims performance
Problem
Business teams relied on ad hoc requests for visibility into policy and claims behavior.
Solution
Built a self-service analytics layer for underwriting and claims, backed by modeled data and reusable metrics.
Impact
Enabled business users to explore portfolio performance independently and reduced reporting dependence on IT.
Power BI Snowflake dbt DAX
Logistics KPI Command Center Warehouse and fulfillment workflows
Problem
Core supply chain metrics were distributed across separate reports and difficult to track in one flow.
Solution
Created consolidated KPI dashboards for warehouse operations, order fulfillment, and carrier performance tracking.
Impact
Provided operations teams with a unified view of logistics health and clearer bottleneck detection.
Power BI SQL Python Excel
Retail Performance Reporting Suite Regional and departmental retail analytics
Problem
Teams needed clearer visibility into membership and inventory performance across locations.
Solution
Built dashboard suites for department and regional analysis with focused membership and inventory reporting.
Impact
Improved planning conversations by standardizing retail performance insights across business units.
Power BI SQL Power Query
Visualization
Power BI Deneb / Vega-Lite Power Pages
Data Platform
Microsoft Fabric Azure Synapse Snowflake SQL Server
Languages
DAX Python SQL M (Power Query) TypeScript
ETL / Integration
Azure Data Factory Microsoft Graph API dbt Pandas
Modeling
Dimensional Modeling Star Schema Semantic Layer RLS/OLS
Tools
DAX Studio Tabular Editor VS Code Git
Background
About I deliver full-stack web engineering services with a strong focus on TypeScript, clean API design, and maintainable product architecture.
I combine application engineering with BI consulting capability to deliver data-informed platforms that improve reporting, operations, and business decision-making.
© 2026 FTTG Solutions LLC