Headline

SDE2 @ Flipkart

About

Sasirekha MSVL — SWE, Backend & Infrastructure I'm a backend engineer with 4 years at Flipkart building platform-scale infrastructure on GCP. My core work spans an analytics query optimization platform — where I used Apache ANTLR to parse and rewrite SQL expressions with 100% production accuracy, significantly cutting BigQuery slot consumption across hundreds of daily pipelines — and real-time inventory systems using Kafka, gRPC, and Guava Cache that reduced inventory lag from tens of minutes to under 5 minutes. I've built high-throughput data pipelines (30k+ records/second via Pub/Sub and Hibernate), multi-channel communication infrastructure delivering ₹1.32 Cr/year in cost savings, and owned zero-incident Big Billion Days readiness including a critical production fix for BigQuery streaming insert failures. I work across the full infrastructure stack — Kafka, Airflow, BigQuery, Terraform IaC, Kubernetes — and have a strong track record of debugging and resolving production reliability issues at scale.

Location

Greater Bengaluru Area

AI stack

antigravity

opencode

Work experience

Senior Software Developer at Flipkart, Sep 2024 - Present · 2 yrs, Bangalore Urban, -> Query Optimization Platform (Plato/FDP): Built an analytics query optimization layer for Euclid, A/B testing, and FUF pipelines. Introduced parameterisation to eliminate redundant join fanouts, hierarchical join rewriting, and segment-merging — significantly cutting BigQuery slot consumption across hundreds of daily scheduled queries. -> ANTLR Grammar for Free-Hand SQL: Integrated an ANTLR-based parser to convert user-authored case-when SQL expressions into structured ASTs consumed by the Plato backend — achieving 100% accuracy in production across all supported use cases. Enables non-technical analysts to author custom metrics without engineering changes. -> WhatsApp Notification Channel: Designed and shipped order-update delivery over WhatsApp via the Gupshup messaging API. Built message orchestration with AES encryption, multi-account credential management, retry logic, DLR/inbound callback handling via Kafka listeners, and Redis KV store for delivery-status tracking. Achieved 98% open rate, 40% response rate, 58% responses within 1 minute; unit cost ₹11.5p per 24-hr session window, delivering ₹1.32 Cr/year cost savings vs. the prior SMS fallback. Handles 9% of customers who lack WhatsApp on their registered number via automatic SMS fallback. -> Reliability & Production Incidents: Owned analytics infra for zero-incident Big Billion Days; fixed critical BigQuery upload failures on schema-recreated tables by switching streaming inserts to Query Job DML insertions. Resolved an SSI outage caused by CLOSE_WAIT connection leak (BulkheadFullException) by explicitly closing HTTP connections in error paths.

Software Engineer at Flipkart, Jun 2022 - Sep 2024 · 2 yrs 4 mos, Bengaluru, Karnataka, India, • Real-Time Inventory Manager: Built a Kafka Sink Connector backed by Guava Cache and gRPC to synchronise seller inventory in near real-time; eliminated stale-cache OOS errors in cart and reduced inventory lag from tens of minutes to under five. The Kafka Connect stack was adopted by multiple other Flipkart teams. • Health+ Marketplace Launch: Core engineer on the greenfield hyperlocal medicine delivery marketplace; owned Seller Panel APIs, Albus shipment integration, and Viaduct invoice/label generation; worked with BD and ops to onboard initial sellers across geographies. • Automatic HealthBuddy Onboarding Pipeline: Designed a Pub/Sub-driven pipeline that upserts high-volume seller and area records via Hibernate merge with FK-constraint awareness, removing the need for manual onboarding scripts. • Pricing & GCP Pipelines: Built Airflow DAGs triggered by Kafka events for multi-seller price sync; automated SQL→BigQuery MIS dashboard pipelines with full Terraform IaC; led a DLP de-identification PoC for PII handling across GCS-to-BigQuery flows.

SDE Intern at Flipkart, Jan 2022 - Jun 2022 · 6 mos

Web mentor at Edyst, Sep 2021 - Jan 2023 · 1 yr 5 mos, Hyderabad, Telangana, India

Cyber Security Intern at AMRITA VISHWA VIDYAPEETHAM, Jul 2021 - Nov 2021 · 5 mos, Online

Education

btech 1 year, c language, G Narayanamma Institute of Technology and Sciences

Intermediate, Sri Chaitanya Junior College, Bhaskar Bhavan