ENGINEERING CASE STUDY

SRE Incident Intelligence Engine — Pareto 80/20, MAD Z-Score & Dash

Clean-room analytical engine built in Python (Pandas, NumPy, Plotly, Dash, Gunicorn) to transform raw Tier-2 / Tier-3 (L3) incident queues into statistically rigorous engineering prioritization (Pareto 80/20, contractual SLA compliance matrices, skewed MTTR percentiles, and robust MAD anomaly detection) — powered 100% by deterministic synthetic telemetry (Zero NDA / Zero PII).

Pareto 80/20 Chronic Failure Fingerprinting
MAD > 3.5 Robust Post-GMUD Spike Detection
P50 / P90 / P95 Log-Normal MTTR Percentiles
Zero NDA Deterministic Generator & Pytest

Dual-Surface Architecture: Live L3 Investigation & Executive Storytelling

Mission-critical sustainment teams need both interactive multidimensional drill-down and zero-server Data Storytelling artifacts for weekly SLA and Six Sigma governance reviews. Both surfaces share a single pure analytical core:

Stage 01

Synthetic Generator (Seed=42) / CSV Adapter

Stage 02

Schema & Null Audit

Leakage-Free Backlog

Stage 03

SRE KPI Engine

Pareto, SLA Matrix, P50/P90/P95 & MAD

Stage 04

Reactive Plotly Dash Console

Gunicorn :8050

Stage 05

Standalone Zero-Server HTML Report Exporter

Statistical Rigor & Operational Data Hygiene

Operational Analytics ChallengeClassic Implementation PitfallEngineering Approach Implemented
Right-Skewed Repair Times (MTTR)Reporting arithmetic means distorted by single long-tail incidentsSystematic P50, P90, and P95 percentiles paired with log-scale severity distributions (SEV-1..SEV-4)
Post-Deployment (GMUD) Spike DetectionGaussian Z-scores ($\mu \pm 3\sigma$) suffer statistical masking during extreme burstsModified Z-Score via MAD (Median Absolute Deviation, threshold $> 3.5$) with automatic IQR / 1.349 fallback
Active Unresolved Backlog (NULLs)Dropping rows without resolved_at (hiding in-flight SLA breaches) or leaking future timestampsExplicit DataQualityAudit preserves active backlog, evaluates in-flight SLA elapsed time (reference_now - opened_at), labels "Pending L3 RCA", and imputes missing MTTA via per-severity median with ack_imputed flag
Six Sigma / DMAIC Toil EliminationTreating incidents individually rather than clustering systemic failure modesComposite service :: root_cause_category fingerprinting isolating the Vital Few driving 80% of toil and synthesizing P0 / P1 / P2 actions
Inspect the Python Package, ADRs & CI Pipeline on GitHub

Modular package featuring a unified CLI (sre-analytics), Pytest suite, non-root Gunicorn Dockerfile, and statistical ADRs.