Objective
Experienced and knowledgeable Information Technology Professional seeking to contribute training and acquired skills within a Tier One Technical Support and/or Help Desk role. Work well independently, or in a group setting, providing all support such as troubleshooting, installations, and maintenance. In-depth knowledge and understanding of numerous software packages and operating systems. Skilled in providing Customer and End-User Help Desk Support. Easily identify and resolve technical issues and concerns.Excellent communication and presentation capabilities.
Experience
Torm Shipping India Pvt. Ltd., Mumbai 17 May 2004
Database Administrator
Solutions-focused, team oriented System Administrator with broad-based experience and hands-on skill in the successful implementation of highly effective helpdesk operations and the cost-effective management of innovative customer and technical support strategies. Proven ability to successfully analyze an organization's critical support requirements, identify deficiencies and potential opportunities, and develop innovative solutions for increasing reliability and improving productivity. A broad understanding of computer hardware and software, including installation, configuration, management, troubleshooting, and support.
-
-
SCOPE OF WORK
Environment : Sybase ASA 5.0, ASA 8.0, Sybase ASA 9.0, Amos replication server. Amos Business Suite 8.2 to 8.6.14 (Plan & Maintenance Program, Amos for windows(4.2)Ms Access 2000 and 2003,PowerBuilder 6.0,9.0 and 10.0,Crystal Report, Diver Program,Consoltas Plan & Maintenance Program,ShipNet,Diver Program -Reporting Tool, SQL 2000 and 2005
Role : System Administrator (DBA): Sybase ASA DBA providing 24x7 supports for 23+ production, staging and development server. As a primary DBA handling 23 large database servers and replication servers.
•Installations, EBF upgrades and setting up of SYBASE ASA 9.0.x , Amos replication Server 6.3.x ,Amos for windows and Amos Business Suite 8.6.17 on Windows server 2003 and Office XP.
•Migration of databases across different versions, windows platforms.
•Backups and Recoveries. Scheduling of Backup Recovery and other maintenance jobs.
•Configuring different server and database wide parameters.
•Setting up, maintaining and troubleshooting of database and Amos Replication.
•Solving/Troubleshooting problems like user and system Database Corruption.
•Administering health of Amos Business Suite, Sybase, ASA, SQL 2000 and Amos Replication Servers.
•Monitoring Amos Replication data flow.
•Providing standardized solutions to recurring Problems/requests
•Analyzing and optimizing the queries.
•Automating various operations by writing small programs in Ms Access And Power Builder.
•Visualisation and Implementation of the planned maintenance system used by OMI Corporation (Principals of OMCI) on their fleet of oil tankers from the inception stage.
•Responsible for team creating ship specific databases (around 50 databases have been created for OMI Corporation), implementing AMOS on board the vessels and training of ship and office staff.
•Provide backend support for the AMOS databases on board the vessels and in office.
•Responsible for the backup, upgrades and day to day functioning of the databases on board vessels and in office.
•Visualising, Designing and implementing various reports in Powerbuilder and MS Access, as required by Technical, Purchase and Accounts departments.
•Designing and implementing templates for various forms in AMOS, to be reported as part of planned maintenance (For instance, Main engine performance forms, Crankshaft Deflection forms).
•Making utilities in Powerbuilder, the language used in creating front-end of AMOS, for remotely fixing any problems in vessel databases.
•Creating triggers in AMOS program for customizing the working of AMOS.
•24x7 based support being on Call.
Education
University of Mumbai , Mumbai, Jun 1998 - Mar 2001
B.Com in Commerce
Certification
•Advance Diploma in Software Engg. from Aptech - Mumbai
•MCDBA from Karrox - Mumbai
Skils
•SQL 2000,Sybase ASA and ASA 9.0
•PowerBuilder 6,9 and 10
•Ms Access 2000 and 2003
•Crystal Reports
•Amos Program and Amos Replication(Marine Plan and Maintenance Program)
•Diver For Creating Reports
•Shipnet & ShipServe
Torm Shipping India Pvt. Ltd. Mumbai
1. Utility For Data Export Import
Environment : Amos 4.2.4,Amos Business Suite , Sybase ASA 5.0, Sybase ASA 8.0,Sybase ASA 9.0 and Powerbuilder 6 & 9.
Role : Asst. System Administrator
Project Summary : Amos Export Impot utility is a tool used for data exoprt and import for Amos.This utility is created for the Purchase department to send and receive the quotation from various vendors for the requisition raised in Amos.
Purpose of the project is to save the time of purchaser and auotmate the process of creating and importing quotes.
2. Utility For Po and MR number For the purchase order form.
Environment : Amos Business Suite , Sybase ASA 8.0,Sybase ASA 9.0 and Powerbuilder 9.
Role : Database System Administrator
Project Summary : This tool is used for generating MR(Maintenance) and PO(Purchase Order) Number for the Amos approved purchase orders.This program is used for generating MR and PO number after the Purchase order is approved by techinal Head.
Purpose of the project is to avoid paper work and manual entries in register.
3.ME Performance Temaplte
Environment : Amos Business Suite , Sybase ASA 8.0,Sybase ASA 9.0 and Powerbuilder 9.
Role : Database System Administrator
Project Summary : This template is stored in each vessel and attached to a particular job in Amos.
Purpose of the project is to major the performance of the main engine on the vessel by autocalculation.
4.Generic Export Import
Environment : Amos Business Suite , Sybase ASA 8.0,Sybase ASA 9.0 and Ms Access 2000.ShipNet
Role : Database System Administrator
Project Summary : This Program is made in Ms Access 2000 to import and Export the data from Amos to the another software called Shipnet (Purchase Module)
Purpose of the project is to transfer all new requisitions to Shipnet from Amos and also from Shipnet to Amos.
5.Upgradation To ABS 8.2.16
Environment : Amos 5.0,Amos Business Suite 8.2.10 and pathces (8.2.11 to 8.2.16) , Sybase ASA 8.0,Sybase ASA 9.0.
Role : Database System Administrator
Project Summary : Upgraded the Amos older version(4.2.4) to Amos Business Suite(8.2.16) and Sunbase ASA 5.0 to Sybase ASA 9.0. for office and Vessel Database.
PUrpose of the project is to make availabe new function of the program to users.
6.Setup Of Amos Replication Program for the Fleet and Office.
Environment : Amos Business Suite ,Amos Replication Program,Sybase ASA 9.0.
Role : Database System Administrator
Project Summary : Setup the Amos Replication program for full fleet and Office.
PUrpose of the project is to automate the process of export import of the data between vessel and office database on regular basis.
7.New Triggers in Amos
Environment : Amos Business Suite ,Sybase ASA 9.0.
Role : Database System Administrator
Project Summary : New trigger added in Amos database to overcome the bugs in Amos Business program
In ABS 8.2.16 version we found the few problem of auto updation of quotationline unitid and quantity and also auto generating the number in backend.To avoid this we made one trigger to check and update the particular data as and when user open it.
Purpose of the project is to avoid the bugs in ABS and quick solution for the userS.
8.Followup Issues Program
Environment : MS Access 2003
Role : Database System Administrator
Project Summary : This program is created in Ms Access 2003 for the techinal department and use on daily basis to register and maintain vessel daily issues.
Purpose of the project is to maintain a register where every techinal head and related department can have access to view the daily
issues of the vessel (solved and unsolved) to take a quick action.
9.Amos Orbit Import Program
Environment : MS Access 2003,Sybase ASA 9.0(Amos Database),Orbit (Accounting Program)
Role : Database System Administrator
Project Summary : This program is used to transfer only required data from purchase order and voucher in Amos to orbit.
Purpose of the program is to transfer only required data to orbit from Amos on daily basis.
10.Batch File For Database Backup on Local Machine
Environment : Sybase ASA 9.0
Role : Database System Administrator
Project Summary : Batch File created for automatic backup of online Amos and Replication database on local machine everyday.
Purpose of the project is to avoid downtime for the backup.
11.Me Performance Program
Environment : Ms Access 2003,Sybase ASA 9.0
Role : Database System Administrator
Project Summary : This program is created in Ms Access 2003 for full fleet and office.
Purpose of the project is to get the required data from the vessel through the text file generated by the Me Performance program and import the same in office Me perfomance program.In this program vessel have the rights of only entering the data and sending it to the office.where as in office every techinal head has rights to import the data recieved from vessel and the generate the excel sheet for the last five records whichever the want for graphical presentation and comparison in Excel template.
12.Reports in Excel
Environment : Ms Access 2003,Sybase ASA 9.0
Role : Database System Administrator
Project Summary : This program is used for generating the report in Excel.
Purpose of the project is to get the required data into excel as per users requirement.