Email:- rohit@ghanara.com

Summary:

·        6 years of experience in the IT industry involving analyzing and development of various Business applications using tools like VANTIVE CRM ,  Visual Basic with SQL Server 6.0/6.5/7.0, Oracle 7.1/7.3/8i and MS Access as backend along with ASP, HTML 4.0,IIS, COM/DCOM, delphi2.0, C and Developer 2000.

Certification:

      Brainbench certified Visual Basic 6.0 Programmer, Transcript ID: 2437545.

Educational Qualification:

BE (Computer Science and Engg)   1991- 1995

Contact Numbers:

Work   -   630-734-5425

Mobile – 630-290-2925

Home   - 630-268-0230

Technical Skills:

Languages                  :           C, SQL, Pascal, and Delphi

Operating Systems    :           Windows 95, Windows NT, Windows2000, HP Unix release IV

RDBMS                     :           Oracle 7.1/7.3/8i, MS Access, SQL Server 6.0/6.5/7.0

Tools                           :          Vantive 8.0.2, VanTool , Tuxedo, VB 3.0/4.0/5.0/6.0, Crystal Reports, Report Smith, IIS 4.0, MTS,  Active-X, RDO,                   ODBC,  ClearCase, Visual  Source Safe.

Web Technologies     :           HTML, DHTML, ASP 2.0, VB Script, Java Script, and IIS  4.0

Methodology              :           COM/DCOM.

Work Experience:

Crescent Systems, Maryland, US                                          Jan’2001 to present

Responsibilities:

·        Currently I’m involved in development of a project in Visual Basic using COM/DCOM methodology with MTS, at the client site, ie. Mediware Westmont Illinios. The COM components are written in VC++ as well as in Visual Basic but the front end is completely in Visual Basic, It also involves thorough knowledge of TruDBGrid (A third party tool from Apex.com).

·        Hemocare is one of the country’s leading stand-alone integrated data management system for the hospital blood bank. The system was designed in collaboration with Memorial Sloan-Kettering Cancer Center in New York City. Hemocare’s software programs are organized into subsystems performing over 200 functions some of which are the ability to manage and control blood inventory; perform long-term donor and transfusion record keeping; store and manage characteristics of blood products to be transfused; maintain patient and transfusion records; maintain the records of patient test results, and automate billing and workload recording.The product contains a Testing Module for testing the blood products,Patient Module which keep tracks about the patients.

Environment: Visual Basic 6.0,VC++ 6.0, SQL Server 7.0, MTS, ADO, IIS4, on Windows 2000.

US Interactive Inc, California, US                               May’2000 to Dec’2000

Was outsourced to India development center mumbai.

TelcoCare  - Vantive Consultant

Responsibilities:

·        Involved in Installing the Vantive package, including the installation of VanTool, VanClient and VanServer.

·        Installing the Oracle 8i and creating the instances of Oracle.

·        Setting up / Installing the databases and tables for Vantive applications.

·        Cataloging of  tables and the columns to the Vantive applications, using the Van Tools.

·        Created Groups using the VanTools.

·        Then created Users and assigned them to the created group.

·        I was also involved in providing rights to the various users.

·        Used CRM package, Vantive to customize the application so as to abridge the gap between the sales and services for the Telecom Industry.

·        Was involved in writing SQL stored procedures to establish the communication between the Front End and the Oracle database.

·        Was involved in troubleshooting and testing of the application as a whole.

Environment: Vantive 8.0.2, CRM, Tuxedo 6.5, Oracle8i, ConnectEx 2.2.3 on Windows NT.

Bankers Trust, Sydney,Australia                                 Jan’2000 to Apr’2000

ELMO

Responsibilities:

·        Used VBScript for effective client-side scripting.

·        Used Visual Basic using the COM/DCOM methodology to code various (about 7) Active-X components.

·        Used MTS to manage the COM components across the network.

·        Used ASP to get the report from the COM components which in turn used the ADO connectivity to the databases.

·        Lastly was involved in testing, debugging and troubleshooting any bugs, then finally Installation of the product at the client PCs.

·        Was configuration manager for the team and used Clear Case for version management.

Environment: HTML, Visual Basic 6.0 using COM/DCOM methodology, VBScript, ADO, MTS, IIS4.0 and ASP with SQL Server 7.0 as back end on Windows NT.

MISYS Financial Systems, UK                                     Aug’1999 to Jan’2000

Word Integration & Reporting

Responsibilities:

·        Analyzed the existing system to capture the business functionality of the insurance product and modeling that into this module.

·        Involved in building database connections using DSN less ADO connections to communicate with the database.

·        Identified objects, their attributes and behavior from the requirement document delivered functional specifications.

·        Designed classes based on functional specifications and object interactions.

·        Coded classes and ActiveX controls using Visual Basic 6.0 to support the design and prototype construction.

·        Used VSS for version control. I was the configuration Manager of my team as well.

Environment: Visual Basic 6.0 using COM/DCOM methodology, ADO, MTS, IIS 4.0, Active-X Controls, Oracle8i on Windows NT.

Experian, Nottingham, UK                                           May’1999 to Aug’1999

Re-Engineering - LINK-SM

Responsibilities:

·        Involved in designing and making strategies for converting the existing 16-bit visual basic 3.0, VC++ 1.52 versioned application to the latest 32-bit Visual Basic 6.0, VC++ 6.0 application.

·        As a team leader was involved in smooth conversion from the VB 3.0 to VB 6.0for the front end part.

·        Was involved in converting to a 32-bit .ocx from an existing 16-bit .vbx using VC++ 6.0.

·        Used VSS for version management.

·        Was also involved in testing and debugging the application.

Environment: Visual Basic 6.0, MS Access, VC++ 6.0 on Windows NT.

Kindle Banking system, Ireland                                   May’1998 to May’1999

ATM, Overdraft

Responsibilities:

·        Involved in building database connections using DSN less ADO connections to communicate with the database.

·        Involved in coding of ATM and over drafting COM components.

·        Used MTS for DCOM implementation of the COM components over the network.

·        Coded various Pro *C programs to communicate to the Oracle database on the Unix.

·        Was also involved in testing, debugging and installation of the application.

Environment: Visual Basic 5.0 using COM/DCOM methodology, Pro*C, Oracle 7.1, C on HP-Unix.

American Express FRC (East)                                     Dec’1997 to Apr’1998

AJENTS

Responsibilities:

·        Analysis and design of the system to make it Y2K compliant.

·        Incorporation of toolbar and security of the system.

·        Provided the MDI functionality to the application.

·        Coding for the further modification in journal voucher generation and Budget Calculation Module.

·        Development of Unit Test Plan (UTP) for the different module of the system.

Environment: Visual Basic 6.0, Crystal Reports, Oracle 7.3, ADO on Windows 95

ECICS Coface, Singapore                                           May’1997-Dec’1997

GMS

Responsibilities:

·        Was involved in development of the screens in Visual basic 5.0

·        Was also involved in writing few stored procedures in Oracle.

·        Used ADO connection to communicate with the database.

·        Was also involved in testing, debugging and installation on the product.

·        The product was a pure Visual Basic application with Oracle at the back end.

Environment: Visual Basic 5.0, Oracle 7.1, Crystal Reports on Windows 95.

Unique Business Solutions, US                                     Feb’1997 to May’1997

MS2TP

Responsibilities:

·        Analysis of MS Pascal code

·        Finding suitable alternatives and solutions in TP7.

·        Finally conversion of MS Pascal to Turbo pascal using BTRIEVE.

·        Testing and debugging the application.

Environment: Turbo PASCAL 7, BTREIVE on DOS 6.22

ASSET (Apple Industries), India                                  Nov’1996-Jan’1997

Office Automation

Responsibilities:

·        Was involved in coding and testing of the visual basic screens.

·        Was also involved in coding of various Stored procedures in Oracle.

·        Finally was involved in testing and debugging on the application.

Environment: Visual Basic 4.0, Oracle 7.1 on Windows 95

Indian Space Research Organization, India                Sep’1996-Oct’1996

Data Simulation for Testing of INSAT 2-C

Responsibilities:

·        Was involved in simulating the data for testing of the INSAT 2-C using C on Windows 95.

Environment: C on Dos 6.0

Steel Authority of India Limited, India.                        Aug’1995-Aug’1996

History Card Maintenance system, Asset Verification Package and Purchase Management System

Responsibilities:

·        Was involved with the above three projects which involved coding in pre Visual Basic 3.0.

·        Wrote some stored procedure in Oracle to interact with the database.

·        Finally, was involved in debugging and testing of the application.

Environment: Visual Basic 3.0, Oracle 7.1 on Windows 95