Prabhat Gupta

About Prabhat Gupta

Experience of working in distributed system application development in high throughput and high availability environments with large data sets in the Rapid Application Development model- Extensive experience in High Level & Low-Level design of new components from scratch. Evaluating various data stores, data pipelines, and component interactions, and finalizing the contracts between various components- Extensive experience with various design patterns in Java, solid design principles, writing maintainable and extensible code, usage of best design practices, object-oriented modeling, and design- REST API design with underlying tech stacks like Redis, Apache Kafka, Elastic Search, Spring Boot, and JPA.

Experience

1. Software Engineer Ii - Ic3

   Microsoft

   Mar 2023 — Present · Bengaluru, IN

   Team: Management IDC | Data Platform – Ingestion & Lifecycle Team Technologies used: C#, Message Bus, Cosmos DB, MSSQL, ADX, ADF.Collaborated with the Data Infrastructure team to support Intune scenarios and led PRS reporting for targeted policy groups. Led the hydration of all PE ASUs, including sovereign clouds, with policy reports. Calculated expected traffic volume and RU increase, set up monitoring dashboards, and collaborated with publishers outside IDC hours for a smooth, low-disruption rollout. Optimized Cosmos DB COGS by resolving query inefficiencies, reducing RU allocation by ~80%(~5.8M/sec to ~1.2M/sec), saving ~$184K/month, and maintaining 95-100% RU utilization with minimal throttling. Designed and implemented a flighting framework for controlled PRSv3 report rollouts, enabling seamless switching at various levels and minimizing risks. It supports real-time tenant exclusion, includes tracking queries and dashboards, and adapts to needs like blocking AOSP tenants. After analyzing partition merging trade-offs, proposed a migration strategy requiring no code or configuration changes, independently executed the migration over four days, reducing physical partitions in the CDB account from 256 to 64. This resulted in a 20% reduction in RU/s consumption, improved query performance, and no production issues. Identified PRSv1 entities used in DWH reporting, developed a transition strategy to onboard PRSv3 entities, and created & executed a migration plan to move the PDR document to the Bronze layer for seamless reporting. Collaborated with the CDB migration team to successfully migrate RC data to Cosmos DB for PRSv1, resolving critical issues, facilitating the final RC cutover, and addressing the partition split issue to unblock the migration. Evaluated the lift-and-shift pipeline testing plan, uncovering anomalies and assessing delta shift accuracy. Reviewed the A/B testing strategy for PRSv1/PRSv3 logical views, identifying discrepancies.

Education

• Guru Tegh Bahadur Public School

  Intermediate, Science(PCM)

  2010 — 2012

• Millennium Public School

  Matriculate

  2004 — 2010

• Madan Mohan Malaviya Engineering College (MMMEC)

  Bachelor of Technology (B.Tech.), Computer Science and Engineering

  2013 — 2017