Pawan Jindal

Lead the effort to implement critical game features, such as Team-Up and App-version validation, Matchmaking, etc. Conducted load tests on the system using Python and Locust with simulated concurrent user activity of 3M Daily Active Users, ensuring optimal performance under stress. Reduced load testing server infrastructure cost by 60%, while increasing response time by 20% by leading a cross-functional team effort to implement a new virtualization system. Implementation of Grafana dashboard for monitoring gameplay and system performance. Reduced game bugs by 50% by deploying bug fixes and a new regression test suite, resulting in a smoother gameplay experience for users. Tech Stack- Java, Python, Spring-boot, Microservices, MySQL, Redis.

Performed ETL operations and created utilities to streamline tasks for the Central Data Platform team by utilizing Python and SQL. Conducted a POC for enhancing platform performance by improving query runtime from 2 hours to 20 minutes and saved the company infra cost by 30%. Reduced Query run time and amount of data by 80% by implementing Data modelling techniques. Achieved a 40% cost reduction in Google Big Query usage by storing data to cache in Google Big Query Table, saving ~$20K per month. Tech Stack- Python, Java, MySQL, Spark, Hive, GCP, AWS.

Developed an extensible Unity3D multiplayer shooting game to facilitate simultaneous training of multiple individuals in a shared environment, specifically designed for soldier training. Tech Stack- Unity3D.

Collaborated with the Business Request team to successfully migrate jobs from Hive to Spark, resulting in a 50% reduction in ETL pipeline runtime (from D-2 to D-1) by rewriting SQL queries into Spark data-frames. Tech Stack- MySQL, Java, Hive, and Spark.