Curriculum Vitae of Rohit S.Gulati

Email: Rohit_S_Gulati@hotmail.com
Homepage: http://gulati.cjb.net/homepage

Total Work Experience: 3 years 8 months

Skills:

Operating Systems	MS Dos, Windows 95,Windows NT, Windows 2000, Linux
Web-related	ASP, IIS4, HTML, JavaScript, CSS, DOM, SAX
Programming Languages	Visual Basic 6 & C, C++, Java Basics
GUIs	Visual Basic 6 & X-Motif, Lotus Notes
Reporting Tools	Crystal Reports, XQL, XSL, XPath
Databases	SQL Server 7, Oracle 7.3, FoxPro 2.6, MS-Access
Others	PVCS Dimensions Configuration, Administration & Implementation

Computer Qualifications:

Completed the following certificate courses from the Indian Institute of Technology (IIT), Kharagpur:

Course Description	Year of Passing	Grade
C & UNIX	1999	B
C++ & X-Motif	1999	B
RDBMS Design & Oracle	1999	B

Foreign Language Proficiencies:

Elementary French	Have done French as a subject in school and college, covering a period of five years.
Elementary German	Have undergone training at Max Mueller Bhavan (Goethe Institut) for a period of 2 months. Implemented multi-lingual interface in Pro-ActiveX Object Oriented SAP Interface (POSI) with German as a linguistic option in the product.

Work Experience:

Company / Institution	Period	Job Profile
Satyam Computer Services Ltd.	15th June, 1999 7th Feb, 2001	Requirement Collection, Coding, Database & Screen designing, Documentation
Zenith Infotech Ltd.	12th Feb, 2001 to 31st August	Requirement Collection, System designing - Database & Screen designing, Documentation, Coding
Kanbay Software (India) Pvt. Ltd.	9th Sep, 2001 to date	Process mapping, Defining coding standards, Requirement Collection, System designing - Database & Screen designing, Documentation, Coding

Company / Institute Profiles:

Satyam Computer Services Limited is a SEI-CMM Level 5 company and has been providing quality software services to large corporations in United States, Canada, Europe and Japan. The company virtually pioneered the concept of remote software development using high-speed satellite communication circuits in India.

Satyam Computer Services Ltd. is a 100% E.O.U and certified with ISO 9001. The company has more than 6000 professionals working in various development centers spread over three major cities in India. It's clientele includes many fortune 500 companies such as Caterpillar Inc., Ford Motors, General Electric Company, State Farm Insurance, Selective Insurance, Volkswagon and so on.

Zenith Infotech Limited provides product and technology development services to startups and established technology companies. The companies comprehensive development services and knowledge resources, make it easy for the customers to build products and technology in the shortest possible time. Zenith Infotech is a Bombay Stock Exchange listed company housing a revolutionary Dedicated Lab, Product Co-development services and just in time development and center of excellence concept.

Kanbay Software (India) Pvt. Ltd. is a multi-million dollar American Company based at Chicago. It is a thousand strong, ISO 9002 company providing business solutions throughout the world. Like its motto, it enables businesses to excel through the quality and timely delivery of software.

Major Professional Achievements:

White Paper on multilingual sites and applications	Wrote a white paper detailing steps for creating multi-lingual web-sites and applications. The paper explains the entire process right from designing databases, storing and retrieving information, coding precautions, use of Unicode etc.
Coding Standards for open system projects	Wrote a document explaining and listing the coding standards to be followed for open system projects involving VB, ASP and SQL Server.
Creation of Build Management and automation of  Dependency Management processes for Erie Insurance Project	Played an active role in creation of build management and automation of the dependency management processes for Erie Insurance Project. Mapping item and product lifecycles to the defined processes and automating the process of change management.

Details of Professional Assignments:

Project	PVCS Implementation Enhancements
Client	Household Inc.
Server OS	Solaris
Software	C, Oracle, PVCS
Description	Project Description The project was carried out to ease the use of PVCS to the clients using the system. Selective customization of interfaces as per client requirements.
Contribution	Defined the requirements and identified potential places for enabling ease of use Was involved in the requirements definition and deployment process
Role in project	Team lead – Defined requirements and coded on the application. Identified areas of potential improvement from the previous implementation process. Configured and setup the system for use. Interacted with the client and Merant consultant for help regarding the modification to the default event handling mechanism of the software.
Duration	from 10^th November 2002 to date

Project	PVCS Implementation
Client	Household Inc.
Server OS	Solaris
Software	PVCS Client, VAJ
Description	Project Description The project involved porting of code from VAJ Central Repository to PVCS Repository. Change management and source code and baseline lifecycles had to be implemented for the same. Training the users after implementation to PVCS was completed.
Contribution	Participated and defined the source code and baseline lifecycles. Ported code from VAJ Central Repository to PVCS Repository Involved in training users and explaining concepts of change management and the process of baselining and baseline lifecycles.
Role in project	Team lead – Defined source code and baseline lifecycles. Responsible for implementing and training users. Incorporated VAJ and PVCS. Migrated source code of 14 Websphere projects into PVCS.
Duration	from 2^nd July 2002 to 30^th October 2002

Project	Erie Insurance (Diamond Cluster)
Client	Erie Insurance, Erie (Washington)
Server OS	Solaris
Software	Java 1.4, Oracle
Description	Project Description The project involved porting of Erie Insurance's DOS based application software to a web enabled interface with additional functionality The web pages had to be browser compatible, with a complete application like functionality built into the web pages. Java applets were created to enable application interface within the web pages Compatibility of old data with new changes had to be ensured.
Contribution	Participation in defining the change management, build management and dependency management processes Automating the change, build and dependency  management processes. Client interaction.
Role in project	Participation in defining the change, build and dependency management processes. Acting as a temporary configuration manager. Delivering code to the client after ensuring QA and participating in pre-integration testing to ensure that the code is bug free. Setting process of delivering code and OpenMake builds.
Duration	from 17^th March 2002 to 21^st June 2002

Project	SRMS CMM Enhancements
Client	Global Kanbay
Server OS	Windows 2000
Software	VB, ASP, SQL Server 7
Description	Project Description SRMS is an existing system which enables keeping track of tasks allocated to associates and the related timesheet entries to be done against such tasks. Kanbay aiming for SRMS Level 3, wanted the software to incorporate more measurement features like defect tracking, estimation, work breakdown structure etc. Optimization of existing functionality Compatibility of old data with new changes had to be ensured.
Contribution	Requirements collection Optimizing the code. Co-ordination with the team, task allocation, coding and testing
Role in project	Team Leader Identifying task allocation, implementation schedule, co-ordinating team work, client interaction and support and maintenance after implementation.
Duration	from 4th March 2002 to 15^th June 2002

Project	Project Work Room HTML (Document Management System)
Client	Global Kanbay
Server OS	Windows 2000
Software	ASP, SQL Server 7
Description	Project Description PWR HTML is a conversion project, involving conversion of existing Plugin to ASP / HTML It has to be designed a cross browser compatible application, retaining the existing functionality and backward compatibilty with the existing Plugin. Clear specifications of the project involve making maximum use of existing middleware and not recoding on any existing functionality which the plugin provides. This involved a complete reverse engineering of the application.
Contribution	Research into the workings of the existing plugin. Optimizing the code. Making the code more sleek by removing repeated steps and placing them into a common Include file. Ensuring cross-browser functionality. Coding and Testing the product
Role in project	Team Member Identifying the processes and functionality inbuilt into the existing plugin by reverse engineering the same. Coding on the application and testing. Providing client support.
Duration	from 15^th Sept 2001 to 15^th February 2002

Project	Rules Engine (Dell E-Commerce Portal)
Client	Dell Computers Inc., USA
Server OS	Windows NT
Software	ASP, SQL Server 2000, OpenXML, XPath
Description	Project Description The rules engine was designed to be an addon to the existing E-Commerce portal. It has to be designed flexible enough to merge with the existing portal with minimum changes on the same. The Rules Engine provided the flexibility to add and update rules according to the manufacturers terms of sale. Rules engine exploited the advanced features of OpenXML to hit the server only once for validating all rules against items selected for purchase.
Contribution	Research into the use and implementation of OpenXML Co-ordinating with the onsite team regarding the requirements and flexibilty sought for creating the rules engine. Coding on the rules engine which were created as a set of stored procedures, invoked from a central stored procedure, according the rules fed into the application. Testing the product
Role in project	Team Member Responsible for designing and deciding the level of flexibility that the rules engine could offer. Coding on the application and testing the same. Giving support till client acceptance for the engine is acquired.
Duration	from 16^th May 2001 to 31^st August, 2001

Project	Papyrus Conductor (Document Management Software)
Client	Papyrus Inc., USA
Server OS	Windows NT
Software	Visual Basic 6, SQL Server 7, XML DB, XQL
Description	Project Description The product is a document management software which provides the functionality to manage and manipulate documents, with or without a connection to the server. Documents can be uploaded to the server and shared by providing various rights by the owner of the document. Papyrus Conductor provides a web based interface as well stand alone interface, with both a provision for offline and online transactions Papyrus uses advanced XML features to implement the offline mode.
Contribution	Research into the use of XML in relation to Papyrus Conductor Making specifications for inducting XML into Papyrus and documenting the features which Papyrus would provide in offline mode efficiently Coding on Papyrus offline, using VB and XML Providing features with XML like sorting XML files, joining XML files, converting XML NodeList to DOMDocument, getting distinct values from XML files other features like max, min. Testing the product
Role in project	Team Member Responsible documenting the features to be provided by Papyrus offline. Researching the role that XML DB would play in the Papyrus offline product. Coding on the application and testing the same. Making generic DLLs to convert Recordset information into Papyrus offline required formats.
Duration	from 14^th February 2001 to 15^th May, 2001

Project	Pro-ActiveX Object Oriented SAP Interface (POSI)
Client	Kalyani Sharp Industries, Koregaon Bhima
Server OS	Windows NT
Software	Visual Basic 6, Oracle 8, MSXML
Description	Project Description The application should act as an interface between SAP implemented at a location and SAP implemented at the companies HQ. Data comes in from locations in the form of XML files. POSI will then pick up data and check the validity of it as such. Invalid data should be rejected and any such invalidity pointed out specifically. The system should scan the data for proper inputs and then generate the flat files for import into SAP system at the HQ ensuring validity and consistency of the data as well Phase II covered the conversion of the tool into a multi-lingual product, German being the first language as such.
Contribution	Performance Tuning Coding and coordinating with other team members Converting the application into a multi-lingual product. Testing the product
Role in project	Team Member Responsible for performance enhancements, GUI modifications and multi-lingual enabling the application. Adding new features to the existing application. Making the application DB unspecific.
Duration	from 15^th September to 7^th February

Project	Joining Process Automation System (JPAS)
Client	Satyam Computer Services Ltd., Corporate
Server OS	Windows NT
Software	HTML, JavaScript, VBScript, ASP, Visual Basic 6, MS-IIS, MS-SQL Server 7.0, MS-Exchange Server
Description	Project Description Develop application and set up a system that automates the joining of associates into Satyam Computer Services Ltd. by capturing the associate data and generating hard copies of legal and internal documents. The system should integrate with MS-Exchange and MS-Office and mail the required reports to the respective departments, including the American Embassy, with details of the associate joining Satyam. The system should reuse the data and port it into the Satyam HRMIS package. The system is designed to be accessible from the Satyam Intranet.
Contribution	Preparation of the Documents involved in the development process such as URD and SRS. Coding and coordinating with other team members Monitoring the development of the application. Testing the product
Role in project	Module Leader Responsible for collecting user requirements and documenting the same. Coding and monitoring the development according to the schedule. Implementing the Beta version and giving customer support.
Duration	from 15^th May to 15^th August

Project	E-Wallet
Client	Satyam Computer Services Ltd., Corporate Finance
Server OS	Windows NT
Software	Visual Basic 6.0, HTML, VBScript, JavaScript, MS-Asp's, MS-IIS, MS-SQL Server 7.0, MS-Exchange Server.
Description	Project Description e-Wallet is a total web-based B2B e-Commerce solution provided to automate the financial transactions that take place between the various internal groups / circles in Satyam. Each internal group is viewed as a profit center in the Organization and all transactions are conducted on virtual money and bank accounts. The main purpose of e-Wallet is to provide the circle-head and the finance desk personnel with up-to-date information regarding the financial position of the circle and help in the decision making of the circle and therefore the organization vis-…-vis its financial activities by way of various on-line status and other reporting features.
Contribution	Requirements collection. Architecture design and implementation Providing training to the end users Coding Testing and deploying the product
Role in project	Team Member Responsible for collecting user requirements and documenting the same. Coding and monitoring the development according to the schedule. Giving customer support.
Duration	from 10^th January, 2000 to 11^th May, 2000

Project	Commercial Information Systems (CIS)
Client	Satyam Computer Services Ltd., Corporate Services
Server OS	Windows NT
Software	Visual Basic 6, Oracle 7.3, Crystal Reports
Description	Project Description Develop application and set up a system that enables the Corporate Services (Commercial Section) users to completely automate their processes right from a purchase request to warehousing and final dispatching to the ordering party. The application also takes care of the bills and payments processes that arise during such transactions The system completely automates the process of imports right from Insurance, Import Certificate, Letter of Credit etc. and also foreign currency transactions. The system should also be able to generate official and government correspondences using the data fed into the system at any stage of purchase and distribution transactions. The system also takes care of asset and material management ..
Contribution	Preparation of the Documents involved in the development process such as URD and SRS. Development of the application using VB6, Oracle, Open-Database Connectivity (ODBC). Testing the product
Role in project	Team Member. Responsible for stabilizing the system and building on the PHASE I modules. Coding for the entire PHASE II Modules which involved Bills & Payments, Imports and CT3 processes. Adding new features like User Log, Multiple Record Ownership, and Generating Executive Queries on all the transactions.
Duration	6 Months, from 1^st July, 1999 to 1^st January, 2000

Project	Oracle Tables View (Tool), Packaged into CIS
Client	Satyam Computer Services Ltd., IIS
Software	Visual Basic 6
Description	Project Description Develop application that would enhance the development of applications using Oracle. The system completely does away with the SQL prompt and provides a SQL Query Analyzer like interface for executing queries on Oracle Database. Provides an easy reference to all tables in an Oracle database and their structures. Provides with a Query Building interface
Contribution	Preparation of the Documents involved in the development process such as URD and SRS. Development of the application using VB6, Oracle, Open-Database Connectivity (ODBC). Testing the product
Role in project	Conceiving and developing the software.
Duration	20 Days.