Summary
Overview
Work History
Education
Skills
Projects
Accomplishments
Websites
Timeline
Generic

Abhishek Ginani

Bangalore

Summary

Backend-focused Software Engineer with over 9 years of expertise in Node.js and various databases including MySQL, PostgreSQL, MongoDB, and SQL Server. Proven track record in developing scalable APIs, optimising database performance, and implementing efficient data pipelines. Skilled in automation and system integrations within enterprise and IoT environments, with additional experience in ReactJS for web applications.

Overview

11
11
years of professional experience

Work History

SDE II

Yellow AI
Bangalore
09.2020 - Current
  • Built a unified Knowledge Base (KB) platform aggregating content from PDFs, websites, ServiceNow, Salesforce, etc.
  • Developed rate limiter in Node.js for request handling across services.
  • Created a Generic Integration Framework to onboard 3rd-party systems (ServiceNow, Microsoft D365, Azure sync).
  • Developed a Notification Engine: RabbitMQ consumer + Node.js APIs for multi-channel notifications (WhatsApp, SMS, Email, Voice), with delivery tracking.
  • Integrated Zendesk support and extended platform to multiple channels and live agent systems.
  • Tech: Node.js, MySQL, PostgreSQL, MongoDB, RabbitMQ, Kubernetes

Senior Analyst

Infosys
Jaipur
06.2019 - 09.2020
  • Developed Python automation scripts for SSH directory/file scanning and loaded data into Google BigQuery.
  • Designed BigQuery partitioned tables for efficient querying of large datasets.
  • Built IPython/Jupyter automation scripts for reporting and financial analytics.
  • Optimized PostgreSQL stored procedures and created functions for backend reporting.
  • Tech: Python, BigQuery, PostgreSQL, Pandas, Jupyter, Shell

Software Engineer

AirLinq (formerly Teramatrix)
Jaipur
06.2014 - 06.2019
  • Designed ETL pipelines for IoT performance data in PostgreSQL and MongoDB.
  • Developed Python scripts for device polling (SNMP, routers, switches), storing in MongoDB/MySQL.
  • Designed partitioned, large-scale databases and implemented stored procedures for data aggregation and reporting.
  • Built xFusion IoT platform with dashboards (ReactJS), push notifications (FCM), and reporting.
  • Maintained database servers (MySQL, PostgreSQL, SQL Server) with replication, partitioning, and tuning.
  • Automated deployments using Jenkins jobs for databases and web apps.
  • Tech: Python, MySQL, PostgreSQL, MongoDB, SQL Server, ReactJS, C#, Azure

Education

B.Tech - Computer Science

MACERC, RTU
Jaipur
01.2013

Higher Secondary -

Rajasthan Board
JAIPUR
01.2009

Senior Secondary -

Rajasthan Board
JAIPUR
01.2007

Skills

  • Nodejs and Express
  • RESTful APIs
  • Kafka
  • MySQL and PostgreSQL
  • PL/pgSQL programming
  • MongoDB
  • SQL Server
  • Stored procedures development
  • Python programming
  • Shell scripting
  • Kubernetes
  • Version control with GitHub and Bitbucket
  • ReactJS
  • SNMP

Projects

  • Unified KB Platform (Yellow AI), Centralized KB integration (websites, PDFs, ServiceNow, Salesforce) with continuous ingestion and AI chatbot enhancement.
  • Notification Engine (Yellow AI), RabbitMQ + Node.js consumer for WhatsApp/SMS/Email/Voice notifications with delivery tracking APIs.
  • Generic Integration Framework (Yellow AI), Reusable framework for onboarding ServiceNow, Microsoft D365, Azure sync, Zendesk.
  • File Indexing Tool (Infosys), Python SSH + BigQuery loader to scan Linux directories and build structured datasets.
  • Music Streams Reporting (Infosys), Automated reporting pipelines in Python/Jupyter with PostgreSQL optimization.
  • XFusion IoT (AirLinq), IoT platform for device data ingestion, MySQL ETL pipelines, dashboards (ReactJS), and reporting.
  • Database Job Scheduler (AirLinq), MySQL-based scheduler to dynamically configure and run stored procedures.
  • NOCOUT (AirLinq), PostgreSQL-based telecom monitoring system with custom PL/pgSQL functions for performance reports.

Accomplishments

  • Stack Overflow: 4.5K+ reputation, active contributor in backend/database questions.
  • Open-source Contributor: React Query Builder.
  • Published automation scripts for Postgres Backup & MySQL Partitioning.

Timeline

SDE II

Yellow AI
09.2020 - Current

Senior Analyst

Infosys
06.2019 - 09.2020

Software Engineer

AirLinq (formerly Teramatrix)
06.2014 - 06.2019

B.Tech - Computer Science

MACERC, RTU

Higher Secondary -

Rajasthan Board

Senior Secondary -

Rajasthan Board
Abhishek Ginani