Vishal Gandhi                                                                                                                            

Microsoft Certified Solution Developer

 

Tel:                                         Mobile: 9820502308

                                                Res: 91-22-9223215501

 

Email:                                     vishal_gandhi86@hotmail.com

 

Present Employer              Travelex India Private Limited (Thomas Cook Financial Services)

URL                                        www.Travelex.com

 

Awards

 

·          Strive for Excellence for 4th Qtr. Feb 2002, Dun & Bradstreet India

·          Travelex Value Champion – May 2004

·          Nominated for Can Do Attitude – Travelex Exceed Awards

 

Summary

 

 

·          Handled Overseas projects, been to United Kingdom for development and enhancements of biggest software project for Travelex UK

 

·          Experience in Development, Designing and Deployment of Credit Card Processing Servers using XML, COM, ASP

 

·          4+ years of experience in the IT industry and work experience in developing/debugging various Projects with Large databases in Microsoft SQL Server 6.5/7.0 and application development and maintenance in Microsoft Visual Basic 5.0/ 6.0, Microsoft Visual Interdev.

 

·          Experience in Maintenance, handling, Designing, Querying and troubleshooting large Central Database.

 

·          Managed and lead technical projects where all members of the team resided in different geographical locations

 

·          Rich Experience in Handling Complex SQL Join Queries, Stored Procedures and Triggers, SQL SERVER 6.5, SQL SERVER 2000, Device, Databases, Backup, Restore, Schedule Tasks Operations.

 

·          Experience in Developing COM/DCOM based DLL's / EXE Servers Components using Visual Basic 6.0 For accessing databases in Microsoft SQL SERVER 6.5 / 7.0 for a client-server based architecture.

 

·          Development Experience in DOM with XML SDK 3.0

 

·          Integrating COM Components in Client/Server Architecture with ASP, MTS

 

·          Development experience in ASP, HTML, VBScript, JavaScript, and IIS.

 

 

 

Certifications

Microsoft Certified Solutions Developer

Microsoft Visual Basic 5.0

Microsoft SQL Server 6.5

Windows Architecture I

Windows Architecture II

               

Brainbench

·          Brainbench Certified SQL SERVER 7.0 Administrator.

·          Brainbench Certified SQL SERVER 6.5 Programmer.

·          Brainbench Certified SQL SERVER 6.5 Administrator.

·          Brainbench Certified Visual Basic 6.0 Developer.

·          Brainbench Certification in ActiveX.

·          Brainbench Certified ASP Programmer.

·          Brainbench Certified MS Visual Interdev 6.0 Developer.

·          Brainbench Certified Master VBSCRIPT 5.5 Programmer.

·          Brainbench Certified JavaScript Programmer.

·          Brainbench Certification in XML.

·          Brainbench Certification in HTML 3.2

·          Brainbench Certification in Internet Concepts.

·          Brainbench Certification in Internet Explorer 4.0 Administration.

·          Brainbench Certification in E-Commerce Concepts.

·          Brainbench Certification in WWW concepts.

·          Brainbench Certification in Computer Industry Knowledge.

·          Brainbench Certification in MS Internet Explorer 4.0 Fundamentals.

·          Brainbench Certified Windows 98 Administration.

·          Brainbench Certification in Windows 98 Navigation.

·          Brainbench Certification in Master Computer Concepts (Win95/Win98).

·          Brainbench Certification in Internet Industry Knowledge.

·          Brainbench Certification in Internet Security.

 

 

 

Technical Skills

 

·          Languages                                           C++

 

·          Operating Systems                            

 

o         Windows 95/98

o         MS Small Back Office Server 4.5                     

o         Microsoft Windows NT 4.0

o         Windows 2000 Advance Server (Configuring MTS/COM+ Components)

 

 

·          RDBMS                                 

o         Microsoft SQL Server 6.5 / 7.0

o         Microsoft SQL Server 2000

o         Sybase 11

 

·          ISAM                                                       Microsoft Access 2000

       

·          Web Technologies                              HTML, ASP 2.0/ASP 3.0,XML

 

·          Scripting Languages                          VBScript, JavaScript

 

·          Administration Tools                         Microsoft SQL Server Enterprise Manager, MTS Explorer, IIS 4.0

 

·          Development Tools                            Microsoft Visual Basic 5.0/6.0, MS Visual Interdev 6.0

 

·          Middleware                                           COM/DCOM, MTS (Microsoft Visual C++ IDL, COM Development)                                          

 

·          Data Access Technologies                               ADO, DAO, RDO

 

·          Data Transformation                         DTS

 

 

Work Experience

 

Thomas Cook Plc, UK is into the business of Holiday planning and providing Foreign Exchange in different forms. They have a set of agents who buy foreign exchange from them. This foreign currency can be in any form - Bank Note, Travellers Cheque, VTM (Visa Travel Money) etc. The purpose of the Atlas system is to automate and encapsulate the entire process of taking in the Order (which comes under Sales Order module), checking its validity, to process the order to fulfilment, printing and dispatching it to the appropriate courier. The responsibility of Atlas also involves doing stock balancing and other associated jobs. This is part of the Inventory management. Not only does Atlas takes care of selling forex, it has to buy it from some agents. This is part of the Purchase module. Then last but not the least Atlas takes care of adding new agents, new users, new contracts as well as modifying existing ones. This is all part of maintaining static data. This comes under maintenance module.

 

The Flow:

 

Heart of all Thomas Cook's operation is the Call Centre in Peterborough and the distribution centre in Peterborough. Call Centre is where Atlas is running. There are people sitting in front of computer terminals with phones waiting for the orders to come in. Agents call up the call centre and place their order. This order is taken into Atlas after verifying that it's a valid order. If it is a valid order it goes down the line to the next module for fulfillment. This process is called batching and bucketing in Atlas. It is here that all filters are set up which decide on which order is to go into which batch and which bucket.

                Then there is a printing module that takes care of all the printing jobs for all the different orders. This printing module does all the printing for different documents that need to be sent with the dispatch. This printing can be manual printing or automatic printing. In manual printing the batches (of orders) are selected manually from a screen and printed. If the mode is set as automatic printing then all the printing is done by the print server. There is no need for any human intervention. The print controller just takes up the unprinted batches and prints them.

                But where does all the things that come into Atlas and go as part of Sales Order come from? Well this part of the puzzle is solved by Purchase module. PO Quote and Purchase Order along with Batch Control, Sales Return and Part Balancing are the part of the Purchase module that is the answer to this problem.

                But where do you enter the static data? Well the static data - that comprises of different agents, their contracts, adding workstations, Atlas itself manages all managing users etc.. This part is maintained by Maintenance module. Here different contracts are set for different agents. New agents are added. New users are added. Passwords are reset. Product Categories are added, viewed and modified. Adding Despatch methods and identifying their limits on each dispatch method is also part of the same maintenance module.

 

Features of Application

·          End to end order entry/processing system without manual intervention in between until picking and packing.

·          Scheduled automated jobs executed by Task scheduler.

·          High-speed document printing with the help of OCE printers.

·          Easier to interface with other systems through Atlas interfaces.

·          Index Maintenance

·          Application Maintenance

 

 

 

 

Centralized Database Administration System                                                            May 15th2001 to March 06th 2003

Company: Dun and Bradstreet Information Services India Private Limited

URL:           www.dnb.com

 

Data from online transaction processing (OLTP) and Line of Business (LOB) applications and other sources is selectively extracted and organized on the data warehouse database for use by analytical applications and user queries. 

Central Database (CDB) is Centralized Enterprise Data Management System developed for 3 tier Client / Server based Environment to support Information Service Dept. of the Company and serve its global clients with wide range of database / information of Corporates in India. Information into the central database comes in from various offices situated in India, and offline Sync happens on day-to-day basis to keep database updated. De-duplication Engine is used to identify duplicates at various levels e.g. Company, Locations and Contacts

 

Responsibilities / Developments

·          Database Normalization, Entire database relational design for Data Warehousing and Data mining

·          COM Based Component Development Database Extraction for Global Clients

·          Consolidating Client Databases to a Centralized Repository

·          Maintenance of Centralized Database, which includes Historical Data

·          Maintenance and Storage of IT Level Database of Indian Corporates

·          Complex analysis of Data using Microsoft Pivot Services (OLAP)

·          Tools for Offline Synchronization of Database with Offices spread throughout Country

·          Migration of database from SQL SERVER 6.5 to 2000

·          Programmed Complex Joins for Data Extraction

·          Query Optimizations

·          Security Module – Used application based security feature of MS SQL SERVER 2000

·          Creation/Design and Maintenance of More than 100 Master and Reference Tables at Backend

·          Integration with ASP, ADO for Intranet Pages

·          Designing and Programming Front End business logic for Information services

·          COM based DLL’s for Business Logic / Validation Logic

·          Spell Check Feature COM DLL

·          Third Party ActiveX Control Programming - Far Point Spread

·          Developed and Integrated Mail Return Resolution System for Direct Marketing Activities

·          Handled Migration from MS Access 2000 to SQL SERVER 2000

 

Environment: MS Visual Basic 6.0, ADO 2.5, MS SQL SERVER 7.0, and MS SQL SERVER 2000

 

Watchdog (Computer Activity Monitoring System)                                                                   01ST April 2001 to May 13th 2001

Company: Rhombus Technologies Pvt. Ltd., Mumbai

www.rhombustechnologies.com

  

It's like a camera inside your computer, which will keep track of all the activities, which the computer-user is performing. Watchdog can also be used for conferencing. You will be able to chat with one or multiple people in your Organization. Watchdog also gives you the power to see all the applications running on any computer of your network at any given point of time. You can also see a screen shot of that computer or shut it.  Client has 10 branches with one computer each. Each branch just has 1 or 2 Computers as they are booking centers for their consignments. All the branches were connected through the net. They wanted to monitor the activities of the Computers from Mumbai. We developed a module through which they receive the logs of the computer activities from 10 different locations in their Mumbai Office. It is an invisible module, which runs in the background and integrates the data through the Internet. 

 

Responsibilities

·          Transfer of Application LOG to Remote SQL SERVER with Disconnected Recordsets using ADO

·          Retrieving Log files from Local clients connected to Watchdogs Server using Winsock.

·           Integrating ASP Pages with the System for viewing remote Data Log

 

Environment: MS Visual Basic 6.0, Winsock, MS Access (Client), ADO, and SQL SERVER 7.0(Server)

  

Client: Electronic and Power Control Co. Pvt. Ltd.                                     Jan ‘ 2001 to March 2001

Developer

Sales Accounting Management System

For automating act of marketing department for the requirements of maintaining their client list and tracking product(s) according to clients, that are suppose to be inline with ISO 9001.The system is developed in a 3 tier architecture with SQL SERVER 6.5 on database layer with COM Components on middle layer and ASP, Visual Basic Clients on Client Layer Modules included Purchase Order verification, Generation of Invoices, Product Categorization into groups, Sales Forecasting and maintaining Transaction Summary of each Client.

 

Responsibilities

 

·          Creation of Views in SQL Server 7.0

·          Development of generic ActiveX DLL's for accessing, updations, Deletion of records using MS Visual Basic 6.0. Transaction Support through Microsoft Transaction Server.

 

Environment: MS SQL Server 7.0 on Microsoft Back Office Small Business Server 4.5, MTS, MS Visual Basic 6.0, ASP, Windows 9x clients.

 

Client: CMH Hospital, India                                                                               June ' 2000 to December 2000

Developer

Hospital Management System.

Involved in development of COM/DCOM based Components for hospital management System to computerize Administrative operations of the hospital. This has facilities to handle admissions of patients, appointments, patient information, diagnostic tests, treatment schedules, and employee information and duty assignments. Development of COM DLL's for Updation, Maintenance of Administrative records & Login Information. Sophisticated report generation using Data Reports feature in Visual Basic 6.0.

 

Responsibilities:

·          Involved in Database Designing, Component Designing.

·          Creation of Views, Triggers and Indexes.

·          Development of Components as ActiveX DLLs for Updation, Addition and Deletion of Records of Patients.

·          Separate Class Module for Patients Account Details (Class Modules)

·          Used ADO for accessing the database.

·          Report Generation Using Data Report / Data Environment Feature of Visual Basic 6.0

·          Daily Transaction Summary Report.

·          Daily Doctors / Patient Report Generation

·          Client side Testing of Components in MS Visual C++ / MS Visual Basic 6.0.

 

Environment:  Visual Basic 6.0, Win 98 Clients, Back office Small Business Server 4.5, MS SQL SERVER 6.5

  

KEPL,                                                                                                     Feb'2000 to June'2000

Developer.

Voice Recognition / Text Reader System.

 

Involved in Design, Development and Implementation. The System Developed for Recognizing Voice Actions and Text Reader for reading data from sources like web pages emails. Designed and Developed using COM Components Microsoft Speech SDK Xvoice Speech Synthesizer and other Windows 2000 Voice Sub Components. System also Controlled Interactive voice control for Power Point Slide Navigation.

 

Responsibilities:

 

·          Involved in Designing User Interfaces

·          Microsoft SDK Voice.DLL for Voice Components

·          Event Trapping

·          Macro for Power Point Presentations

·          Implementation of Interfaces XVoice

·          Testing and Debugging

 

Environment: Windows 2000 Server, Windows 98 Clients, Visual Basic 6.0 and MS Access 2000

                 

Advance Technologies Labs Pvt. Ltd                                                            June'99 - September ' 99

Chennai

COM Consultant  / Developer.

 

Online Advertisement Subscription

 

Before this site deployment the paper would take advertisements through manual means in which ad would be taken down and price of the ad was calculated the ad was then sent to the accounting department where the cost was calculated this  resulted in delay and subsequently lesser input on advertisements and revenues . Now the user simply logs onto the site and submits the ad once after becoming a member of the site and a unique login id is mailed to him after clearance of Cheque sent by customer. Involved in Development of Components for updating, deletion of advertisements and calculation of cost of Advertisement.

 

Responsibilities:

·          Used VBScript for Server Side Scripting

·          Form Validations for Registration of Users

·          Component Development in Visual Basic 6.0

·          Implementation of Transaction Monitoring System, MTS

·          Integrating ASP with COM Components Developed in Visual Basic 6.0

·          Used ADO for database connections that were included in Include File.

·          Used ASP for server-side scripting to increase the functionality of the modules.

 

Environment: HTML, VB Script, ASP, ADO, MS Visual Interdev 6.0, MS Visual Basic 6.0 and MS SQL Server 6.5

 

Advance Technology Labs Pvt. Ltd. , Chennai ,  India                                               Jan'99 -  June'99

Developer

 

Workflow Management  -

 

A fully distributed approach. The project developed for Clients Administration office, the client required a paperless workflow system in which cross flow of communication between different departments can be managed. For Example Document originating from Marketing Department and routed through purchase to finance could be tracked at run time.

 

Responsibilities:

 

·          Designing Business rules for Components.

·          Development of COM Components in Visual C++ 6.0.

·          Writing of IDL files for Components written in Visual C++ 6.0 Security Components

·          Used MS Visual Basic 6.0 for Client Side testing and Development of ActiveX Components

 

Environment: Windows NT Server 4.0 ,MS SQL server 6.5 , MS Visual Basic 6.0 and

MS Visual C++6.0

 

Sheina Soni Associates, India                                                        March'97 to April'98

Programmer

Inventory Control System

Inventory Control System maintains the stock flow for a Construction Company, Materials. This system also keeps track of the availability of stock, orders placed by the customers, transactions between the departments.

 

Responsibilities:

·          Involved in the database design and development and also in designing user interface.

·          Wrote procedures/Modules for frequently used logic and code reusability.

·          Implementation of Customer Cards / Stock Planning.

 

Environment: Visual Basic 5.0, Oracle, and Windows 9x.

 

Education:

 

·          Business Professional Programmer, DOEACC SOCIETY, NEW DELHI GOVT. OF INDIA.

·          Higher Diploma in Software Engineering, Aptech Ltd., Bhilai, India.

·          Bachelor Of Commerce, Ravishankar University, Raipur, India.