Life @ IIT Bombay

Hi! I am a CS Grad student at IIT Bombay.
I joined here as an Research Assistant back in 2011. This is undoubtedly the awesomest campus I have ever been in my (short academic) life! And during monsoon, its just "Ohh Myy Gwaad!"

About Me

I am originally from Chandannagar, a sweet little town approximately 30 kms north of Kolkata. Chandannagar was one of the oldest French colonies in India. It is hugely popular for the "Jagadhatri Puja" festival held one month after the "Durga Puja". Every year thousands of people come to watch the city lit with its world famous lights. Here are some photos from previous years. [images taken randomly from internet]

  • Illuminous Chandannagar
  • Illuminous Chandannagar
  • Illuminous Chandannagar

 

I did my Bachelor of Engineering in Information Technology from Bengal Engineering and Science University, Shibpur popularly known as "Shibpur B E College". BESU is the 2nd oldest engineering institute in India (after IIT Roorkee).

Currently I am in the final semester of my 21 year long academic life. Phew! My areas of interest span Database Systems, Program Analysis and Computer Networks, though my main concetration is in Database. Presently I am working with Prof. S Sudarshan, co-author of the famous database book Database System Concepts.

In most of the times when I do not study I play FIFA on my 5-years old laptop :) I love Music, of all genres. I like to meet people and make friends. I don't want to brag about it but I played for my local academy in a state level cricket tournament (CAB U-13 Cricket).

Courses

  • Advanced Database Systems
  • Implementation Techniques for DBMS
  • Program Analysis
  • Mobile Computing
  • Advanced Computer Networks
  • Cryptography and Network Security
  • Artificial Intelligence

Academic Details

ExaminationInstituteYearCPI/%
M.Tech.(CSE)Indian Institute of Technology Bombay20148.8*
B.E.(IT)Bengal Engineering and Science University, Shibpur201182
Higher Secondary(+2)Kanailal Vidyamandir (WBCHSE)200786
Madhyamik(10)Kanailal Vidyamandir (WBBSE)200587

*Not Final CPI

Where Can You Find Me!

During office hours I am mostly in my lab, SIC 212, KReSIT bldg. Or at least I plan to be there. Otherwise you can look for me in Sysad Room, Old CSE bldg, ground floor. If I am not at either of these places, then I am definitely at B-311, H-14.

Labs and Lectures

I am not taking any courses in the spring semester but I do have some labs to conduct/assist as part of my sysad duties. I might as well sit-through a few courses. I have not yet decided.

Autumn 2013 Calendar

Masters Thesis Project

Currently I am working with Prof. S Sudarshan on the project titled Holistic Optimization of Database Application. The aim of this project is to combine the techniques of Query optimization and Compiler optimization/Program Analysis to improve the perfomrance of applications that use Hibernate Object Relational Mapping tool.

This project has been going on for quite some time now, and we have developped a program analysis/transformation tool called DBridge. This tool analyzes a java program (which uses JDBC APIs), identifies opportunities for optimizations and automatically transform the program to incorporates the optimizations. So, my main task is to expand the applicability of this tool adding necessary support for optimizing programs which does not use JDBC but use ORMs such as Hibernate. More about the project can be found in here.

Other Projects and Seminars

  • Conditional Dependency Analysis in Database Application

    In this project, we (it was done in pair, though most of the work was done by my partner :)) extracted the dependency between the dynamically constructed query and the request parameters of a given servel program. We also identified the correctness of the query thus constructed and the conditions under which it is exectuted. This project is kind of prequel to my MTP.
  • Query String Analysis for Servlet Programs

    This project is an extension of the above project. We extracted the mapping between fields of an object and the query attributes. Eliminated unnecessary attributes from query based on the program's need. For each query parameter, found out which request parameter it is dependent on and under what conditions.
  • Periodic Materialized View Maintenance in PostgreSQL

    Added support for user defined materialized views in PostgreSQL 9.1.2. Used logs of all transactions to automatically update the materialized view after a certain user defined period.
  • Location and Activity Sensing Using Smartphones | Masters' Seminar

    Presented a comparative analysis of recent location sensing technologies used in smartphones to determine accurate geographical location of the user.
  • Minor Projects

    Performance Comparison of Mobile Adhoc Network Protocols (AODV, DSDV, DSR)
    Modification of Routing Information Protocol (Shortest route calculation based on link cost, instead of hop-counts)
    SQL Injection: Vulnerabilities, Attacks and Defenses, 2nd Order Inject Attacks.

Personal

Facebook

Google+

Twitter

Linked In