Sep 2024 – Jun 2025 · 9 mos · Chandigarh, India · Remote

• Developed a scalable data pipeline, integrating data from diverse sources including APIs, Google Sheets, and Google Drive, seamlessly ingesting into BigQuery for analytics and reporting.
• Built and deployed an Admin Portal backend using FastAPI and MySQL on Google Cloud Platform VMs, providing secure and efficient management capabilities.
• Created an isolated multi-tenant deployment system, leveraging Terraform and Google Cloud Run, to automate provisioning of individual agency portals and microservices directly from private repositories. Ensured robust isolation of agency data, streamlined deployment processes, and maintained centralized administrative control over agency access and permissions.
• Created reusable GitHub Actions YAML templates for setting up continuous deployment (CD) pipelines from GitHub repositories to Google Cloud Run, significantly simplifying the deployment workflow.
• Built an automated pipeline starting from Google Drive that triggers Cloud Functions to initiate Cloud Run jobs, loading data into BigQuery, generating Excel dashboards, and automatically sharing these reports with clients via email.

Aug 2023 – Aug 2024 · 1 yr · Chandigarh, India · Remote

• Optimized existing codebase, performance enhancement while simplifying setup procedures for seamless implementation.
• Deployed Docker images on Google Cloud Run on a scheduled basis, ensuring optimal resource utilization.
• Additionally, designed and developed a user-friendly web form to streamline the creation and updating of user data.
• Written and executed SQL queries for comprehensive data validation and testing in Google BigQuery.
• Created Library with reusable code for marketing data collection though API from various platforms and add them on Big query and google cloud bucket.
• Developed and implemented a Python automation script, streamlining the generation of custom views for BigQuery tables within the Google Cloud environment.
• Designed and deployed a data pipeline on AWS Glue, including the setup of infrastructure components such as Amazon RDS and VPC, to streamline data processing and enhance ETL workflows.
• Managed a product lifecycle that involved extracting data from APIs, uploading it to BigQuery, and validating the data integrity. Additionally, set up the necessary infrastructure to support these processes.

Jun 2023 – Aug 2023 · 2 mos · Kolkata, West Bengal, India · Remote

• Developed responsive and user-friendly web interfaces using React and Material-UI to streamline data collection processes.
• Implemented a secure ticket-raising system with Multer for file uploads and Twilio for OTP-based user authentication.
• Integrated Gmail communication through Nodemailer to automate and enhance user interactions.

Sep 2022 – Mar 2023 · 6 mos · Chennai, Tamil Nadu, India · On-site

• Build API for collecting data about air quality from 360 cpcb station all across India and store them into postgresql.
• Build a microservice which get weather data from EMCWF, store and send as csv file via another api endpoint.
• Implemented OTA (over the air) using Nodejs , to update stationary IOT firmware built by Kaatru.
• Used docker to containerize the service and enable it to deploy it in AWS lambda.
• Build a fullstack Node + React application to download the air quality data which was generated by the IOT device.
• Wrote test cases for node backend to test the APIs and setup github action to run this on push.