Portfolio & Case Studies

Selected Engineering Work

A combination of sanitized enterprise case studies and independently built software systems. Case studies focus on real architectural problems, trade-offs, and verified outcomes.

Open Sourcedeveloper-tools

2026

Query Gate

Creator & Lead Architect

An enterprise database access gateway with fail-closed auditing, granular object permissions, in-flight data masking, and multi-engine SQL support.

Supported EnginesSQL Server, PostgreSQL, MySQL, MariaDB

Audit Assurance100% Fail-Closed Guarantee

ComplianceIn-flight Dynamic Masking

C#.NET 10Blazor ServerSQL ServerPostgreSQLMySQLMariaDBMonaco EditorDocker

GitHub

Read Case Study

Case Studyenterprise

2023 – 2024

Enterprise Reporting Engine

Senior / Lead Backend Engineer

Architecting a high-throughput, configurable reporting pipeline for complex multi-worksheet Excel exports and asynchronous background execution.

Throughput500K+ rows / batch

Memory Ceiling< 250MB fixed ceiling

Web TierZero thread starvation

C#.NETASP.NET CoreSQL ServerHangfireEPPlus

Sanitized Case Study

Read Case Study

Case Studyenterprise

2023

SQL Server Performance Engineering

Senior Backend & Database Engineer

Diagnosing execution plans, resolving severe table scan bottlenecks, and redesigning indexing strategies for high-volume relational tables.

Query Latency8.4s → 115ms (98% reduction)

Logical Reads1.2M reads → 3.8K reads

CPU UtilizationReduced peak SQL CPU by ~45%

SQL ServerT-SQLExecution Plan AnalysisIndex OptimizationC#

Sanitized Case Study

Read Case Study