Bibhas Chandra Debnath

Bangalore, India Backend developer with 15+ years of experience in building web applications and APIs, and working with databases.

Experience

Red Hat, Bangalore (MAY 2024 - PRESENT)

Senior Software Engineer

The Linux and Open Source company.

Tech stack - Golang, Snowflake DB, Fivetran, SQL, Terraform, Gitops, Openshift/Kubernetes Operators, Podman/Docker

Major Projects -

  • Build a data platform on top of Snowflake DB from scratch, following Gitops principals
    • Built and maintained a Golang library that syncs the company user accounts across platforms including Snowflake and Fivetran
    • Used CRDs in Openshift operator to reconcile the data product configurations with Snowflake DB
  • Helped build the process to track cost per data product based on role and tag usage on snowflake
  • Build an evidence collection framework for compliance and deployed it on Openshift
    • Control logics and schedules were stored as Python objects in a gitlab repo
    • Added support for Snowflake, Gitlab, Rover, Astro as sources, and Splunk as destination for logs
  • Build a AI MR review Bot for Gitlab to reduce toil of engineers
  • Setup a CRM workflow using Slack Lists to handle customer requests more efficiently and reduce toil on support engineers
  • Shifted the CI pipelines to self-hosted gitlab runners on Openshift from org managed runners. It currently handles 2000+ CI jobs per hour during peak hours.

Natural User Interface Technologies (NUITEQ), Remote (JULY 2021 - APRIL 2024)

Senior Software Engineer

Product company based out of Sweden that pioneered multi touch user interface in collaborative softwares and hardware, to be used in schools for teaching, and in private organizations for facilitating ideation and implementation.

Tech stack - TypeScript, NodeJS, CouchDB, PostgreSQL, Docker

Major Projects -

  • Porting existing vanilla Javascript code to TypeScript, introducing Nest JS, and PrismaJS ORM for better interaction with the database
  • Migrating existing data from CouchDB into an RDBMS (PostgreSQL) for better structure and performance. This involved -
    • Redefining data model for the existing NoSQL database via entity-relationship diagrams
    • Making sure all entities have valid relationship in the database
    • Write migration scripts for existing data
  • Build a new product entirely from scratch. I was primarily responsible for designing data models, and building the API for the user authentication system, role management system, and organization management system

HasGeek, Bangalore (APRIL 2017 - JUNE 2021)

Software Engineer

Media company that helps individuals grow their reputation and credibility, via peer‐reviewed events and conferences. I was part of the tech team that developed the software that ran the events.

Tech stack - PostgreSQL, Flask, SQLAlchemy, AWS

Repositories ‐

Responsibilities included ‐

  • Developing and maintaining software to run the HasGeek events, which included adding features to run online events during COVID‐19. Backend stack was Flask+PostgreSQL.
  • Overseeing application deployments, at first using fabric scripts, and then later on using github actions

Some major projects ‐

  • Designing and implementing a spam reporting and management system for comment moderation. Involved an automatic moderation system that considered repeated spam reports to take actions.
  • Porting Python 2.7 codebases to Python 3
  • Adding SSL support to all domains using LetsEncrypt, including multi tenant domains using wildcard certificates
  • Adding i18n support and help add Hindi support to the website
  • Setup automated daily, weekly, and monthly backup of Postgres databases to S3

Akshara Foundation, Bangalore (AUGUST 2013 - APRIL 2017)

Software Engineer

NGO in Karnataka that gathers and processes education related data and helps children get better education. I was part of the tech team that gathered all the data from sources like different xls/xlsx files, MySQL/Oracle DB dumps, CSVfiles, 3rd party APIs etc, and processed them to build an open API on top of it to help other NGOs and Govt bodies to make better decisions to help the schools.

Tech stack - Python, Django, PostgreSQL, Vagrant, PostGIS, Jenkins

Repositories ‐

Responsibilities included ‐

  • Gathered, cleaned and imported data from various sources using tools like pandas and OpenRefine, and then stored them in PostgreSQL and generated insight out of them.
  • Developed a data visualization tool for District Information System for Education (https://dise.klp.org.in/, no longer maintained.)
  • Building maps of schools created with PostGIS and OpenStreetMap data.
  • Managed servers and set up Postgres backups to S3.
  • Contributed in the development of an Android app for field data collection.
  • Involved in generating yearly PDF reports from the gathered data for providing insights into student performance to MPs and MLAs.

TaggLabs Technologies Pvt Ltd, Kolkata (JULY 2012 - JULY 2013)

Software Engineer

It is an event management company that uses technology to build interactive displays to be used by participants.

Tech stack - Python, PHP, RFID, Kivy, Tornado

Responsibilities included ‐

  • Building a touch screen capable desktop application. Initially built using an early version of Kivy, but later scrapped due to its complexity and compatibility with Windows OS. It was replaced with a Flask application server wrapped as a Windows executable. The website used to run on the local browser.
  • Adding RFID card/tag reader support to the application.

Yodl, Remote (DECEMBER 2011 - JUNE 2012)

Software Engineer

Update: Website and company no longer operating.

In short it was a Yelp‐like service in Austria, in the Alps region.

Tech stack - PHP, MySQL, Yii, AWS, Google API

Responsibilities included ‐

  • Working as a backend developer + DevOps. Stack was PHP(Yii Framework), MySQL, Hosted on AWS EC2.
  • Gathering place listings from various 3rd party services using their APIs.
  • Building a rating system that could be used by the users.
  • Building a search engine (Front and Back‐end) that helps lookup places based on their location, rating, and several other filters. Done using PHP+MySQL and no other specialized tools.

Education

Narula Institute of Technology, Kolkata (2007-2011)

Bachelor of Technology (B.Tech.) in Information Technology.