Demonstration portfolio · present-tense · illustrative

Barry Middlebrook

BI Developer Data Architect Analytics Engineer Governance Lead

“I build modern data systems that are fast, trustworthy, and audit-ready.” This site demonstrates how I approach real enterprise problems using BI, SQL, ETL, dimensional modeling, and governance — not a résumé, but a working showcase of method.

Explore the demonstrations → How to read this portfolio

What I Demonstrate

Four end-to-end demonstrations

Each artifact walks a realistic enterprise scenario from problem to audit-ready outcome. All examples are illustrative demonstrations of method — not historical claims.

SOX

ARTIFACT 01

Enterprise Power BI with SOX Controls

A unified mortgage-servicing dashboard on a governed star schema — RLS aligned to SOX access matrices, documented DAX, lineage, and refresh logs for audit evidence.

Open demonstration → SQL PROFILER

ARTIFACT 02

SQL Performance & Data Modeling

Diagnosing a slow healthcare-claims system with SQL Profiler and execution plans, then redesigning fact/dimension tables with SCD Type 2 and partitioning.

Open demonstration → AI ANOMALY

ARTIFACT 03

ETL, Data Quality & Governance

An end-to-end pipeline with validation checkpoints, AI anomaly detection, a data-quality scorecard, and a governance dashboard consuming pipeline logs.

Open demonstration → MODERNIZATION

ARTIFACT 04

SSRS → Power BI Modernization

Inventorying static SSRS reports, consolidating embedded SQL into governed views, and rebuilding as an interactive Power BI semantic model with governance controls.

Open demonstration →

Technical Strengths

The stack behind the demonstrations

A senior BI/data-architecture toolkit spanning the Microsoft data platform, modeling discipline, and governance. Select any capability to see where I've applied it.

Select a capability above to see where I've applied it — with the company and years.

Industries Served

Built for regulated, high-stakes data

The demonstrations are framed around domains where accuracy, access control, and auditability are non-negotiable.

Finance

Mortgage servicing, SOX controls, model risk, and executive reporting where every number must trace to a governed source.

Healthcare

Claims and encounter analytics with SCD Type 2 history, partitioned facts, and validated, self-service semantic layers.

Public Sector

Transparent, auditable reporting pipelines with lineage, data-quality scoring, and SLA compliance built into the platform.

Portfolio Philosophy

These are demonstrations of how I solve problems.

Every artifact on this site is an illustrative demonstration written in the present tense. Each walks a realistic enterprise scenario — the problem, the constraints, the architecture, and the method — to show how I design fast, trustworthy, audit-ready data systems.

The scenarios, metrics, and screenshots are examples used to communicate approach and craft. They are not statements of past employment and not audited results. Read them the way you would read a worked solution: as evidence of thinking, technique, and engineering standards.

Barry Middlebrook Data Architect & BI Consultant

About Middlebrook

The full stack this work demands.

Modern BI takes more than a dashboard tool. It takes one person who can model the data, tune the SQL, engineer the pipeline, and design reporting an executive actually trusts — I work across all of it.

24 years across the enterprise data lifecycle — SQL Server and T-SQL, dimensional modeling, ETL, and Power BI reporting, much of it in regulated finance (SOX, CFPB/MISMO).
Model → pipeline → report, end to end — star schemas and SCD Type 2 history, tuned stored procedures and SSIS/ADF pipelines, and Power BI semantic layers built for self-service.
Reporting leaders can trust — governed definitions, documented lineage, and row-level security, so every number on a dashboard traces back to a single source.

A BI developer, data architect, and analytics engineer in one — the person who owns the whole path from raw source to boardroom-ready report.