← Back to Main
Case Study • Multi-Tenant SaaS • Real-Time Analytics

Incident Management System

View Details on GitHub

Executive Summary

Production Scale

~2,000
Schools
100K+
Users
100s
Daily Incidents
Real-Time
Operational Analytics

System Overview

Core Objectives
Incident Lifecycle

System Architecture

Transactional incident workflows and read-optimized analytics pipeline under a multi-tenant SaaS architecture.

Angular ASP.NET Core MVC MySQL Multi-Tenant RBAC Analytics Views
User Dashboard API Layer ASP.NET Core MVC Role-Based Filtering Analytics API Layer OLTP (Transactional) Organization Incident Issue Type User / Role Site Analytics (Read Optimized) Partitioned Tables Composite Indexes Pre-Aggregated Views

Production Analytics Dashboard (My Ownership)

Data Flow
MySQL (Analytics Views)
↓
ASP.NET Core REST API
↓
Angular Dashboard
↓
Interactive Graph & Map Visualization
My Responsibilities

Performance Optimization Strategy

Index Strategy

Partitioning Strategy

Client-Side Parallelization

View-Based Pre-Aggregation Strategy

Why View Pre-Aggregation?
Design Principles
Analytics Capabilities

Role-Based Analytics Enforcement

My Contribution

System-Level Participation
Sole Ownership (Analytics Layer)

Measurable Impact

Dashboard

Latency

Aggregation

Operations

Engineering Highlights

Multi-Tenant SaaS Architecture Hierarchical IssueType Modeling Partition-Aware Analytics Optimization Composite Index Strategy View-Level Optimizer Tuning Spatial Data Analytics Full-Stack Analytics Ownership

Project Impact