May 2023 – Sep 2024 · 1 yr 4 mos · Bangalore Urban, Karnataka, India · On-site

• ◦ Implemented features such as referral program, powering Android notifications, OTP-based login, export of Django model data to CSV, notifications in Django Admin, and PDF agreement signing for 946 employees. Also added graphs on Django Admin for key metrics overview.
• ◦ Transitioned from AWS RDS to Postgres master and slave setup on EC2, achieving a cost reduction from $347.44 to $21.87 saving $325.57.
• ◦ Optimized database usage in the Django application by implementing an efficient read-through cache mechanism, and using client-side batch processing cursors with Pgbouncer transaction mode. This resulted in processing 50,000 records in a single batch while maintaining memory and cost efficiency.
• ◦ Enabled remote control of IoT devices by establishing a single, efficient connection to the MQTT broker in Django using daemon thread, reducing resource consumption.
• ◦ Achieved efficient synchronization of IoT sensor time series data with InfluxDB using MQTT broker and Telegraf.
• ◦ Took part in System Design Architecture of Client, Financial, and OPS Platform based on CAP theorem and kept a single source of data in a team of six, streamlining client vehicle orders, vehicle procurement, getting best deals, and vehicle delivery. Designing OPS platform admin interface on top of external APIs.
• ◦ Improved data retrieval efficiency by optimizing the SQL queries running in multiple AWS Lambda functions to pull data from Postgres DB for periodic charts in the Client Platform reducing the time from 20sec to 2sec.
• ◦ Implemented security protocols: restricted SSH access to VPN-authenticated users, utilized AWS Pre-Signed URLs to prevent public resource access, and employed AWS STS to mitigate credential exposure.

Jun 2022 – Apr 2023 · 10 mos · Noida, Uttar Pradesh, India

• ◦ Platform Write-Back :- This service writes data back to platform databases provided in the REST API request body.
• ∗ Improved API response from 10 sec to 1.1 sec for 100 records by implementing bulk insert, upsert, and delete queries in the Postgres database
• ∗ Improved data validation, error handling, logging, documentation, unit-testing, and handling unique characters in request
• ∗ Implemented factory design pattern for handling global database connection
• ∗ Integrated Gunicorn in the Django app to increase the handling of multiple concurrent requests
• ∗ Improved API response time from 3.5 sec to 0.92 sec for Snowflake database by using Kafka broker, Kafka connect, Snowflake streams, Procedures, Tables, Tasks
• ◦ Made Scrappers and Transformers to scrape medical data from websites, upload to S3 and eventually to Redshift database
• ◦ Implemented stats API to check the status of the Airflow dag, Kubernetes job, and pod

Jan 2022 – Jun 2022 · 5 mos · Noida, Uttar Pradesh, India

• ◦ Reduced the running time by 93% of the Gitlab CI-CD pipeline by reducing the number of operations
• ◦ Made scripts to maintain an ECR registry that keeps the dump of the customer environments, documenting it on confluence and end to end testing
• ◦ Integrating and migrating GChat to Slack notification service

May 2021 – Aug 2021 · 3 mos

• Key Skills:- Docker, Testing, Debugging, Google Cloud, AWS, Databases
• Dockerized a server application for deploying it on Google Cloud.
• Made a script for moving Bigdata from Google Cloud SQL to Google Cloud Storage and then to the Docker container.
• Merged two projects and Dockerized them to work in Continuous Integration.
• Improved unit test case coverage to 90% for a Django application.
• Made a script to remove data from the Elastic Search database present in the Postgres database, based on some filters passed.
• Made a Shell Script for automating the data upload on AWS S3 and updating AWS Lambda Functions

Mar 2021 – Jul 2022 · 1 yr 4 mos

Jun 2020 – Jul 2022 · 2 yrs 1 mo

• Managed all the important Data Structures in C++

Mar 2019 – Mar 2019 · 0 mo

• The event is based on the fundamental idea of providing an individual with real-life experience managing his venture and collaborating with his partners. The event offers the student a platform to experiment, test their skills, and shape their ideas with absolute liberty.

Jan 2019 – Jan 2019 · 0 mo · Rajasthan, India

• SIF- It aims to bring the budding startups and aspiring students all under one umbrella. Associated startups found the right interns, and the aspiring students got their internships on one platform.
• We succeeded in bringing more than 25 startups and more than 400 students from other prestigious colleges of Jaipur in a one-day event.
• Managed to get a sponsorship of Rs.16000 by creating a database of the companies and pitching them on online platforms in SIF, an event in our techfest plinth.

Oct 2018 – May 2021 · 2 yrs 7 mos · Jaipur, Rajasthan, India

• Promoting the Startup culture and a spirit of Entrepreneurship among youngsters.
• Organised various events like Sell with E-Cell ( SWEC ), Startup Intern Fair ( SIF ).