Resume of                                                  Subhasish Bhandari

The resume in word document format                                                                                                                                                                            The resume in Ascii format

Personal Details
Email address: 

[email protected]

Telephone: +91. (0) 33-4349477/4343565(R)
+91. (0) 33 98300 23061 ( mobile) 
Communication 
Address:
Bank Colony , R.K. Palli 
Sonarpur, 24 Parganas(s) 
West Bengal, India 
Pin - 743369
Date of Birth : 27 January, 1975
Nationality : Indian
Educational Qualification

Qualification

 Institute

Major 

Class

Year

B. E.

Jadavpur   
University, Calcutta

Electrical

First

1998

Technology Skillset(s)
Profile Summary:             Skilled Database Administrator (DBA), Skilled Project Leader and Developer.
Expertise  Description
UNIX O/S
HP UX
Solaris
AIX
Sco
IRIX
Linux
Windows O/S
Win3.0/3.1
Win95/98
Win NT/2000
Oracle
Oracle 8i,8.x,7.x
Forms 2.0, 3.0
Pro* C
Internet Application Server
Oracle Application Server
Oracle Portal ( Webdb)
Developer 2000Jdeveloper
Oracle Portal-to-go
Enterprise Manager
Java
Applications
Applet based modules
JDBC
Servlet
EJB
JSP
XML
Microsoft
Visual Basic
Ms Access
Ms SQL Server
Ms Internet Information Server( IIS )
ASP
Web/ Application
Servers
Apache Web Server /Jserv and Tomcat
Allaire JRUN
BEA WebLogic
IBM WebSphere
WAP 
Oracle Portal – to – go
WML/XML
Internet
HTMLDHTML using JavaScript and VBScript
CGI using perl, 
Oracle Stored procedure, 
shell script, bat file etc

Work Experience – 3 years (1998-2001)

PBanerji Telemedicine

Designation: IT Advisor

Duration:    March’2001 – till date

Workplace:  Calcutta (India)

  1. Analyze and provide technology solution to be used in creating a Health Portal for the patients and doctors consulting Dr. P. Banerji across the world.
  2. Design , develop and in the process of implementing an user friendly and robust web-based application to enable the users avail the facility and treatment of Dr. P. Banerji . Presently it’s a B-B portal, which will be extended to a B-C portal in the next phase.
  3. The website www.pbanerji.com will be hosted along with the application at an ISP place and the site will be maintained in terms of content and application.

Rubber Exchange

E-Com Pvt. Ltd.

Designation: IT Advisor

Duration:    January, 2001-Feb, 2001

Workplace:  Calcutta (India) & Cochin (India)

  1. Analyze and provide technology solution to be used in creating an Enterprise Portal for the rubber Industry, to enable rubber trade across the globe
  2. Design, develop and implement an user friendly and robust web-based application to enable rubber trade on the internet by developing a B-B portal
  3. Host the website www.rubberexchange.com and the application at an ISP place and the site will be maintained in terms of content and application.

IndiaisOnline (I) Pvt. Ltd.

Designation: Manager Systems

Duration:    March’2000 – December, 2000

Workplace:  Calcutta (India)

  1. Database and Server Administration of both London and Calcutta office
  2. Analyze and provide technology to be used for ASP model (Application Service provider Model) of IndiaisOnline.
  3. Manage the website www.indiaisonline.com  and other websites like www.dbsofficebusinesscenter.com,www.mba-world.com,etc at the London server through remote administration. The websites were hosted in the same machine and web hosted through Oracle Application Server using multi-hosting feature.
  4. Administer the free email service provided by IndiaisOnline.
  5. Manage the distance learning initiative iLearn of Indiaisonline
  6. Manage the B-C application iShop of IndiaisOnline
  7. Database Engineering of all web-based applications like iChannel ( Supply Chain Management) , iContrak ( Consignment Tracking Application) , HealthNet ( Health Portal Application ) and TravelNet( Travel Industry Portal)
  8. Provide pre-sales assistance to sales team in selling IBX ( an Internet Server Appliance) and IPIX ( a 3D imaging solution)
  9. Provide pre-sales and prototype assistance in developing web-based applications for Indiaisonline customers /prospects like IPIX, SmithKline Beecham , IFB, etc
  10. Resolve any implementation/design issue during development phase.
  11. Project Leader of the following projects of IndiaisOnline

    CPN network for IPIX

    Tools: Webdb2.2

    Database: Oracle8i

    Team size: 3

    Duration: 15 days

    The system was to register new photographer for and they were assigned jobs by IPIX processing center. The IPIX center or the customer registered the jobs. The whole process till the image is uploaded for public viewing is done in the online system. The responsibility includes analysis, table design and part of the development.

    Chat Server:

    Tools: Java

    Database: Oracle8i

    Team size: 3

    Duration: Ongoing till December, 2000

              The system is to authenticate users from the database and let them chat on different lounge. They can do private chatting with any person he/she likes who can ignore if need be. The system is initially being built on java and likely to get extended to some installable messenger (like Yahoo). The use of Networking, Applet, and servlets are being used predominantly in this project. The design phase is complete and implementation phase was going on.

    Shopping mall mail:

    Tools: Java

    Database: Ms Access

    Team size: 3

    Duration: 5 days

    The system is a java application that sends mail to selected candidates on placing order to a shopping mall whose database was in Access. Have developed the mailing part, alone which uses SMTP mail to send mail to the candidates. The program only uses SMTP server for sending mails. Have given guidance to the other person involved to pick the mail-id and the orders from the database and using the mail-program to send mail.

    In-house inventory database

    Tools: Webdb2.2

    Database: Oracle8i

    Team size: 3

    Duration: Ongoing till December, 2000

    The system was to keep track of the software and hardware of the entire company along with the capital involved in them. The system was to keep the HR info of a person as what's his/her bank account, leaves taken etc. The system was to be viewed as per profile and people were given selected views. The system was halted for other projects.

    Design of a cyber cafe operation

    Tools: Webdb2.2

    Database: Oracle8i

    Team size: 2

    Duration: Ongoing till December, 2000

    The system is to take care the day-to-day transactions in a cyber cafe taking care of the timings, type of customer, and type of service availed, etc. The analysis and the table-design are completed.

    Migration of webdb2.0 to webdb2.2:

    Tools: webdb2.0/2.1/2.2

    Team size: 1

    Duration: 2days

    WAP enabling of application Softwares: Tools: Oracle portal to go, WML
    Database: Oracle8i
    Team size: 1
    Duration: 15days

    The flight-timings software was made WAP enabled using Oracle's portal-to-gob’s development and the service designer. The development machine was RAS configured and using WAPlite as the WAP-gateway. The temporary system was like this:

      1) From a WAP enabled mobile, an ordinary telephone line was called which is connected to a modem and to the RAS.

      2) The RAS connects the mobile through WAPlite and then to portal-to-go application.

      3) The mobile then sends WML requests to the PTG, which then resolute it with the page located in the Internet/Intranet

         The function of PTG is to map any form level requests and then executes it to extract the result from that website and send back the request to the requester. The requester can be anything starting from mobile, PDA, computer or other devices. The online updating on the iContrak system and a few others using XML were developed but not implemented.

Tata Technologies India Limited

Designation: Consultant (Oracle DBA)

Duration:    July’1998 – February, 2000

Workplace:  Telco,Jamshedpur( India)

1.        Consultant Systems:  Primary role was Oracle DBA responsible for administration/maintenance of around 15 Oracle databases from version 7.1.6 to 8.0.5 with sizes varying from 2-20GB across various platforms

2.        Was also responsible for the design, development and maintenance of several in-house development applications.

3.        Responsibilities also included designing   and conducting training courses on Basic and Advanced Oracle features and Java for other in-house application developers and other trainees.

4.        Y2K   Support  Responsible  for   providing  Y2K  support  and      consultancy  to the entire  division  during  conversion  of    application  software  to Y2K compliant  versions as well as migration of all the Oracle databases to the y2K supported software. Also being deputed at Tata Refractories India Limited( Belpahar,Orissa ), to configure and installed the system which was running in Oracle7.0.x was upgraded to Oracle7.2.3 for their y2k migration.

5.        Training: a) Designed  and conducted  Basic  and   Advanced  Oracle Training    courses for the new recruits  98 batches. The  courses were spread     out  over  a  period of  24  days  and covered topics like SQL*PLUS    ,SQL* Forms , PL/SQL , Pro*C,user-exits,database  triggers , stored    procedures and functions , integrity constraints ,backup and    recovery techniques ,    advanced replication with snapshots ,       Oracle architecture, packaged  procedures  and   functions  and     Developer  2000     features.

                                  b) .  Designed and conducted training in Developer 2000 release 2.1 for    in-house developers.

                        c) Designed and conducted training in Java courses for in-house    developers. The course was spread for 10 days which included hands    on training and elaborate exercises on using of various Java    Packages   likeutil, Networking,io,etc.  

  1. Software Development  :

Developed   Unix shell scripts for Image backups, hot backups, archive backup, user and table level   export and import, restoration, monitoring scripts for archiving, hit ratio, object fragmentation, table space utilization, locking   etc

 Developed modules for Reverse Engineering Tool that would generate      creation scripts for various schema objects like tables, indexes, constraints, grants, views, synonyms, database links, procedures, functions, packages from their definitions in the data dictionary     in Forms 5.0.

Developed the above system in Java and correlated it with the Oracle Application Server

  Work Flow management system for Telco ‘s project submission. The system was developed in pl/sql stored procedures using OAS3.01 and Oracle8.0.3 as the database