Somnath Ganguly

Full-Stack Developer & AI/ML Enthusiast

I am an MCA student at Kalyani Government Engineering College. I enjoy building web applications and exploring AI and machine learning.

Portrait of Somnath Ganguly in a navy suit and tie
MCA, KGEC Kalyani
NIC West Bengal intern

Experience

My professional experience.

Full-Stack Software Developer Intern

Jun 2024 – Jul 2024

National Informatics Centre (NIC), West Bengal State Centre, Kolkata

  • Worked on assigned modules across both the frontend and backend of the application.
  • Worked as part of a team to develop, integrate and test application features.
  • Helped debug issues and make improvements to existing modules.
  • Angular
  • .NET Core
  • PostgreSQL

Projects

Four applications I built end to end. Open a card for what I did.

BookStore Management Application

A full-stack MERN application for managing a bookstore's inventory and orders.

  • React.js
  • Node.js
  • Express.js
  • MongoDB
  • JWT
  • bcrypt.js

My contribution

  • Built RESTful APIs supporting complete CRUD operations backed by MongoDB.
  • Implemented secure user authentication and authorization with JWT and bcrypt.js.
  • Integrated React Hooks and Axios for efficient, API-driven UI updates.
GitHub Demo

Weather Forecast Application

A responsive weather forecasting app built in React.js that shows real-time conditions for a location the user enters.

  • React.js
  • OpenWeather API
  • CSS

My contribution

  • Developed the responsive interface in React.js.
  • Integrated the OpenWeather API through the Fetch API to display real-time data based on user input.
  • Displayed temperature, humidity, wind speed and current weather conditions.
GitHub Demo

RAG-Based Medical Chatbot

A retrieval-augmented generation chatbot that answers medical questions using information retrieved from uploaded medical documents.

  • Python
  • FastAPI
  • LangChain
  • RAG
  • Google Embeddings
  • Pinecone
  • Groq

My contribution

  • Built a document-based RAG pipeline for retrieving relevant information from medical PDFs.
  • Implemented document processing, chunking and vector search using embeddings and Pinecone.
  • Developed FastAPI endpoints for document ingestion and question answering.
  • Integrated an LLM with retrieved context to generate grounded responses.
GitHub Demo

Natural Language to SQL Query Generator

An AI-powered application that converts natural language questions into SQL queries for interacting with relational databases.

  • Python
  • FastAPI
  • Ollama
  • Llama 3.1
  • SQLAlchemy
  • SQL

My contribution

  • Built an API-based system that converts natural language questions into SQL queries.
  • Integrated a locally hosted Llama 3.1 model through Ollama for SQL generation.
  • Implemented database interaction using SQLAlchemy and SQL parsing utilities.
  • Developed FastAPI endpoints and Swagger UI support for testing the query generation workflow.
GitHub Demo

Skills

Technologies and tools I use to build software and AI-driven applications.

Programming Languages

C++, Java, Python, JavaScript

Web Technologies

HTML, CSS, React.js, Node.js, Express.js, REST APIs

Databases

MongoDB, PostgreSQL, MySQL

Machine Learning & AI

NumPy, Pandas, Matplotlib, SciPy, Scikit-learn

Generative AI & RAG

RAG, LLMs, Vector Databases, Pinecone, Ollama, Google Generative AI

Tools & Platforms

Git, GitHub, VS Code, Postman, Google Colab, Jupyter Notebook

Core CS Subjects

Data Structures & Algorithms, DBMS, Operating Systems, Computer Architecture, OOP

Education

Most recent first.

Master of Computer Applications (MCA)

2025 to 2027

Kalyani Government Engineering College, Kalyani

CGPA 8.84 / 10 (up to 1st semester)

B.Sc. (Hons) in Computer Science

2022 to 2025

Ramakrishna Mission Vivekananda Centenary College, Kolkata

CGPA 9.21 / 10

Higher Secondary (Science)

2022

Barrackpore Government High School, WBCHSE

91.00%

Secondary Education

2020

Titagarh Krishna Nath Municipal High School, WBBSE

86.28%

Academic achievements

Semester topper

4th, 5th and 6th semesters of B.Sc. (Hons).

GMR 60 in JECA 2025

General Merit Rank 60 in the exam conducted by WBJEEB.

3rd place, poster presentation

Inter-college poster presentation competition.

Volunteering

College tech fest activities and the National Service Scheme (NSS).