MCA/OCA(DBA) 9i
Resume:
Vikas Gupta
Phone: - +91-094******** (Mobile)
E-mail: - *****.*****.***@*****.***
Objective
To upgrade my skills and the existing strengths, in an organization, which can provide me the profile and conducive environment, to contribute and grow by virtue of constant learning.
Experience
I have 3 Yrs experience in IT industry out of which 1 year in the areas of ORACLE 9i/10g, SQL*Plus, PL/SQL,SQL-Server 2000 and Visual Basic 6.0. I am having 1 year of experience as an Oracle Database Administrator. I am an Oracle 9i Certified Associate in Database Administrator. I have worked in design, development and testing phases of project life cycle. I have good programming, analytical and communication skills.
Organisational Details
• Since April 08 working with Lohia Starlinger Ltd, Kanpur as Software Developer.
• Nov’ 06-March 08 working with Dataman Computer Systems (P) Ltd., Kanpur as Jr. Programmer (DBA).
• Sep’ 05-Oct’ 06 working with Radiant Technology, Kanpur as Jr. Programmer .
IT skills
Operating Systems : Windows 98/2000/XP, MS-DOS
Environment : Oracle 8i, PL/SQL, SQL LOADER, SQL*PLUS, OEM
DBMS/RDBMS : ORACLE PL/SQL , FORMS 6I/9I ,8i/9i/10g,MS Access, SQL Server 2000
GUI Tools : Visual Basic 6.0,HTML,Crystal Report
Tools/Utilities : SQL*Plus,PL/SQL
Technical Summary
PROJECT DETAILS
Central UP Gas Limited (July 2007 – till date)
Client: CUGL , Kanpur
O/s: Windows 2000 S/w: Oracle 10g and VB
Tools/Utilities: SQL*Plus, PL/SQL, Export, Import and Oracle Enterprise Manager.
Project Details:
CUGL is UP govt.’s company in India. The company is dealing with CNG & PNG products. The company is having various departments and all of them are computerized. The major departments are Marketing, Systems, Finance, Personal and Costing etc. The company is having one database at Kanpur office all the modules are installed in this server , which has main production database.
Role:
• I am responsible for Oracle database administration .
• Responsible for user management in database level as well as OS level.
• Responsible for monitoring database growth, space management and planning for backup and recovery strategies.
• Conducting training program for the developers for solving the performance issues in application level.
• Technical consultant for the development team.
• Evaluating the application code to make sure that there are no performance issues in the application.
Aarogya (Feb’ 07 – July’ 07)
Client: Rama Dental College, Kanpur.
O/s: Windows 2000 S/w: Sql Server 2000 & VB
Tools/Utilities: SQL Server 2000 EM
Project Details:
RDC is the Dental College & Hospital. They have several Front Office Systems (FOS), which are accessed by different departments of the Hospital, and they are settled through the Middle Office Systems.
Role:
• I was involved in providing production support for their Middle Office System and Front Office System.
• I was involved in writing scripts for the enhancement of existing reports according to the user request.
• I was involved in modifying stored procedures for enhancement.
Aabhushan (Dec-‘06 to Feb’ 07)
O/S: Windows 2000,VB. S/w: Oracle 10g,
Tools/Utilities: SQL*Plus, PL/SQL, Import/Export.
Project Details:
The propose of this project is to migrate Aabhushan application currently in Microsoft Access database to a more robust, multi-user, scaleable, and industry standard Oracle 10g database.
Role:
• I was involved in System study and functionality study of the system. Job includes analysis, design
• Responsible for Oracle Database Administration, as a DBA my responsibilities are to manage database objects, space management and planning for backup and recovery.
CALL CENTER APPLICATION (NOV-‘06 TO DEC-‘06)
Client: JSL Call Center Application Database Migration, USA
O/S: Windows 2000.
S/w: Sql Server
Tools/Utilities: SQL server 2000 EM
Project Details:
The propose of this project is to migrate JSL Call Center application currently in Microsoft Access database to a more robust, multi-user, scaleable, and industry standard Microsoft SQL Server database.
Role:
Involved in Migrate project to Sql Server,Create Stored Procedures, Views, tables, And Functions .
TELEPHONE DIRECTORY SEARCH SYSTEM
O/S: Windows 98.
S/w: MS-Access/Visual Basic 6.0.
Project Details:
This s/w is developed for in - house Purpose. This helps the user to searching customer’s Information either by providing single alphabetic character or no. or address. It supports full text searching thus making it a modern system with virtual Directory implementation. It is a powerful search engine for finding any customer information from the databases.
Role:
• Working on Development of new module of Coding, testing along with the maintenance of existing modules.
• I was involved in database design for System .
Professional Training
Done Training on VB from Radiant Technology since April 2004 to Oct 2004.
Certification/Awards
• Successfully Completed Oracle Certified Associate (OCA) in DBA track From Oracle Corporation, USA with 93% in August 2006.
Academia
• MCA from IGNOU, New Delhi with 1st Division in 2005.
• CIC From IGNOu New Delhi with 1st Division in 2001.
• B.Sc. from CSJM University, Kanpur with 2nd Division in 1998.
• 12th from UP Board with 2nd Division in 1995.
• 10th from UP Board with 2nd Division in 1993.
Personal Details
Father’s Name : Sh. Durga Prasad Gupta
Marital Status : Unmarried
Date of Birth : 11-Dec-1978
Passport : Yes
Communication Address : SiriFort Road ,
New Delhi-110012
References : References are available on request.
Contact this candidate