Service Delivery Leader2020–2022120K annual hires, India
SQL QuickSight VBA Process Engineering
What Was Broken
A candidate applies, gets an offer, and then waits four months for a background check. Four months. In that time, they’ve probably accepted another offer, or lost interest, or both. The process was a chain of manual handoffs between vendors, Legal, and internal teams, with no single person able to see the full pipeline.
The 90th percentile was the real problem — most checks finished in 6–8 weeks, but the long tail of blocked cases dragged the average to four months.
The First Cut: Seeing the Board
Before we could fix the process, we had to measure it. SQL queries against the vendor databases, stitched together with VBA macros because nobody had built a real dashboard. The output went into QuickSight — color-coded by stage, flagged by delay, grouped by vendor.
What showed up was obvious once you could see it: three specific vendors were responsible for 60% of the delays. One of them had a broken API endpoint that nobody had reported because the fallback was manual email.
Rewriting the Rules
The fix wasn’t technical — it was procedural. We renegotiated SLAs with the two worst vendors, added an auto-escalation trigger at 30 days, and built a fallback path with a secondary vendor for the most common check types. The third vendor we just stopped using.
The verification workflows got re-engineered too. Instead of serial checks (A finishes, then B starts, then C), we parallelized everything that didn’t depend on the other. SQL tracked dependencies, QuickSight showed bottlenecks in real time, and the team stopped spending half their day chasing status updates by email.
Scaling the Team
Ten people couldn’t handle the volume at peak season, and four of them knew the whole process end-to-end. So we grew to 45 — not by hiring generalists, but by building specializations. One track for vendor management, one for exception handling, one for data quality. I mentored six of them into leads who now run their own teams.
The hardest part wasn’t the scaling — it was getting Legal and Compliance to agree that a 30-day SLA was actually safe. That took sitting in meetings, showing them the data, and earning trust that the new rules wouldn’t create risk.
The Numbers
90th percentile turnaround dropped from four months to one. Manual review time cut in half. The program touches 120K hires a year across India.
The takeaway: most process problems aren’t engineering problems. You have to sit inside the process long enough to see where it actually breaks.
{"menu":[{"name":"Pages","items":[{"label":"Home","subtitle":"Overview","action":"navigate:/","icon":"page"},{"label":"Career","subtitle":"Timeline & principles","action":"navigate:/career","icon":"page"},{"label":"Projects","subtitle":"All projects","action":"navigate:/projects","icon":"page"},{"label":"About","subtitle":"About Meher","action":"navigate:/about","icon":"page"}]},{"name":"Settings","items":[{"label":"Toggle Theme","subtitle":"","action":"toggleTheme","icon":"theme"}]}],"fuse":{"threshold":0.6,"minMatchCharLength":2,"keys":["label","subtitle","searchableText"]},"projects":[{"title":"Global Payroll Platform","description":"Led end-to-end deployment of in-house payroll platform across 6 APAC markets processing $1.2B annually. Defined technical requirements for 2 engineering teams. Coordinated payments integrations via API/SFTP with ISO 20022 XML specifications.","tags":["Python","SQL","API Integration","ISO 20022"],"link":"#","image":null,"techStack":["Python","SQL","API Integration","ISO 20022"],"size":"large","domain":"fintech","icon":null,"featured":true},{"title":"Fraud Detection Engine","description":"Drove fraud detection initiative analyzing 1.5M payment transactions. Reduced manual validation touchpoints by 80% through automated rule-based detection and QuickSight analytics dashboards.","tags":["Python","QuickSight","Analytics"],"link":"#","image":null,"techStack":["Python","QuickSight","SQL"],"size":"medium","domain":"analytics","icon":null},{"title":"Background Check Revamp","description":"Cross-functional policy revamp with Legal, Compliance, and Business. Reduced 90th percentile turnaround time from 4 months to 1 month. Re-engineered verification workflows, cutting manual review time by 50%. Impacted 120K annual hires across India.","tags":["Operations","Compliance","Process Engineering"],"link":"#","image":null,"techStack":["SQL","QuickSight","VBA"],"size":"medium","domain":"data","icon":null},{"title":"Sovereign Homelab","description":"49-container self-hosted infrastructure: Caddy reverse proxy, DNSGuard local resolver, NetBird VPN, Vaultwarden, Redis, PostgreSQL, CouchDB. Full observability via Grafana, Loki, Prometheus, and Alloy. Running on bare metal—no cloud provider.","tags":["Docker","Linux","Caddy","NetBird"],"link":"#","image":null,"techStack":["Docker","Caddy","NetBird","Vaultwarden"],"size":"large","domain":"infrastructure","icon":null,"featured":true},{"title":"AI Node","description":"Local-first LLM orchestration on CUDA GPU. Running llama.cpp server with Open WebUI for private, on-device AI inference—no cloud APIs, no telemetry, no data leaving the box.","tags":["CUDA","llama.cpp","Open WebUI"],"link":"#","image":null,"techStack":["Python","CUDA","llama.cpp"],"size":"medium","domain":"ai","icon":null,"featured":true},{"title":"Matrix Citadel","description":"Self-hosted Matrix federation with full MatrixRTC voice/video via dual LiveKit servers. Twunnel federation bridges, JWT auth services, OpenClaw Gateway for AI agent orchestration. Running on cloudcitadel.in.","tags":["Matrix","LiveKit","Twunnel"],"link":"https://cloudcitadel.in","image":null,"techStack":["Matrix","LiveKit","Twunnel","OpenClaw"],"size":"medium","domain":"infrastructure","icon":null},{"title":"Media & Photo Stack","description":"Self-hosted media ecosystem: Jellyfin streaming, Immich photo library with ML-powered face recognition and reverse image search, full *arr automation pipeline (Radarr, Sonarr, Lidarr, Prowlarr, Bazarr), Jellystat analytics dashboard.","tags":["Jellyfin","Immich","*arr Stack"],"link":"#","image":null,"techStack":["Jellyfin","Immich","PostgreSQL"],"size":"medium","domain":"infrastructure","icon":null},{"title":"Observability Stack","description":"Full infrastructure telemetry: Grafana dashboards, Loki log aggregation, Prometheus metrics, Alloy collector, node_exporter, process_exporter, smartctl_exporter. Monitoring 49 containers and bare-metal health in real time.","tags":["Grafana","Prometheus","Loki","Alloy"],"link":"#","image":null,"techStack":["Grafana","Prometheus","Loki","Alloy"],"size":"medium","domain":"infrastructure","icon":null}],"skills":{"tools":["Python","SQL","QuickSight","VBA","Docker","Linux","Kubernetes","Grafana","Prometheus","Loki","Caddy","Matrix"],"standards":["ISO 20022"],"domains":["Payments","Compliance Engineering","Product Management"]},"contact":{"email":"hi@meherchaitanya.com","channels":[{"label":"Email","url":"mailto:hi@meherchaitanya.com","displayText":"hi@meherchaitanya.com","icon":"mail","external":false},{"label":"LinkedIn","url":"https://linkedin.com/in/meherchaitanya","displayText":"meherchaitanya","icon":"linkedin","external":true},{"label":"Matrix","url":"https://matrix.to/#/@meher:hanumara.online","displayText":"@meher:hanumara.online","icon":"matrix","external":true}]}}