Sandip Basnet
SRE Lead
Verified Systems & Blueprints

Executive Case Studies & Blueprints

Production architectures, zero-downtime database clusters, and high-throughput systems engineered for mission-critical reliability.

devopsFintech / Core Banking Platform

Enterprise PostgreSQL High Availability Cluster

The Challenge:A high-concurrency platform suffered risk of catastrophic failover downtime and WAL divergence during peak traffic spikes.
Maintained 99.99% uptime with automated sub-10s leader failover across enterprise traffic spikes.

Enterprise automation blueprint for PostgreSQL HA clustering, Patroni consensus failover, pgBackRest S3 backups, and Grafana telemetry.

99.99%Target Availability
<10sFailover Time (RTO)
PostgreSQLPatroniEtcdAnsibleDockerPrometheusGrafana
opensourceDeveloper Ecosystem & Open Source

info-nepal: Developer Geographical Metadata Engine

The Challenge:Software applications lacked a standardized, normalized administrative geographical dataset, causing data fragmentation across web and mobile apps.
Zero-dependency geographical metadata engine powering location selectors across web and mobile apps in Nepal.

High-performance developer library delivering normalized geographical metadata for 77 districts, 7 provinces, and municipal divisions of Nepal.

753Administrative Divisions
0Runtime Dependencies
Node.jsTypeScriptNPMOpen SourceGISZero-Dependency
NPM
opensourceGeospatial Computing & Developer Tools

geoenclave: Point-in-Polygon (PIP) Geospatial Validation Engine

The Challenge:Geofencing and spatial query operations often relied on heavy C++ bindings or bloated GIS libraries that bloated bundle sizes and slowed client-side execution.
Zero-dependency, sub-millisecond point-in-polygon verification used in spatial routing, geofencing, and delivery boundary checks.

High-performance TypeScript utility implementing ray-casting algorithms to validate whether a geospatial coordinate lies inside a defined boundary or complex polygon.

Sub-1msExecution Overhead
0Runtime Dependencies
TypeScriptNPMGeospatialGISRay-CastingZero-DependencyAlgorithms
NPM
opensourceDeveloper Ecosystem & Localization

nepali-dates: Bikram Sambat (B.S.) Calendar & Date Matrix

The Challenge:Nepali calendar applications lacked lightweight, dependable data matrices for variable Bikram Sambat month day counts, leading to recurring date calculation bugs.
Provides accurate calendar day matrices for Bikram Sambat years 1970 B.S. to 2100 B.S. with zero runtime dependencies.

Ultra-compact NPM utility mapping month day counts, leap intervals, and calendar conversion metadata for the Nepali Bikram Sambat (B.S.) calendar system.

1970 - 2100 BSYear Span Supported
0Runtime Dependencies
Node.jsTypeScriptBikram SambatNepali CalendarDate UtilitiesZero-Dependency
NPM
backendDigital Media & Content Streaming

High-Concurrency Low-Latency Audio Streaming Core

The Challenge:Legacy monolithic media servers struggled under concurrent streaming bursts, causing memory saturation and high audio buffering latency.
Sub-2s latency streaming for concurrent media consumers with 60% lower server memory footprint.

High-performance HTTP Live Streaming (HLS) audio server leveraging Node.js streams and FFmpeg dynamic chunk transcoding.

<2sStreaming Latency
60%Server Memory Savings
Node.jsHLSFFmpegStreamingExpressBuffer Piping
devopsEnterprise SaaS & Cloud Infrastructure

Autonomous Kubernetes GitOps & Observability

The Challenge:Deployment delays and opaque distributed tracing across microservices caused multi-hour MTTR during production incidents.
Accelerated deployment frequency from bi-weekly to multi-daily with automatic rollback triggers.

Infrastructure-as-Code repository configuring Kubernetes cluster telemetry with Helm, ArgoCD, Prometheus, and OpenTelemetry.

<5mIncident MTTR
Multi-DailyDeployment Cadence
KubernetesHelmArgoCDOpenTelemetryTerraform
devopsHigh-Growth Scale-Up & Cloud Systems

Multi-Cloud FinOps & Infrastructure Automation Pipeline

The Challenge:Uncontrolled cloud sprawl and manual server provisioning led to budget overruns and long environment lead times.
Cut environment provisioning from 4 days to 12 minutes with automated security validation and 38% AWS bill reduction.

Modular cloud automation pipeline using Terraform, Ansible, and GitHub Actions for continuous deployment and infrastructure provisioning.

12 MinsProvisioning Speed
38%Annual Cloud Savings
DevOpsTerraformAnsibleGitHub ActionsDockerAWSFinOps
opensourceSystems Engineering & Core Architecture

Systems Programming & POSIX C Reference Architecture

The Challenge:High-level abstractions often obscure low-level memory footprint, caching efficiency, and concurrent POSIX syscall behavior.
Referenced by engineering teams for memory management audits and systems-level concurrency design.

Comprehensive architectural tutorial repository for low-level memory allocation, pointer arithmetic, linked data structures, and POSIX system calls.

Valgrind CleanMemory Audit
POSIX CStandard
CPOSIXSystem ProgrammingMemory ManagementValgrind