Devesh Surana
9102226129328 9820400806
201, Manish Apt, Nehru Road, VileParle(East), Mumbai400057
Current Location: Mumbai
Title: / Oracle Applications and Database AdministratorWork Experience: / 3.1 years
Skills: / Oracle Database Administrator, Oracle Applications DBA, Unix Administrator
Current Organization: / National Commodity and Derivative Exchange
Previous Organization(s): / Nicholas Piramal India Ltd.,HCL Infosystem, MRCPL
Industry: / Airlines,Pharmaceuticals
Highest Degree Held: / MCA/PGDCA (Computers) ,SIMSR, Mumbai
Gender: / Male
Date of Birth: / 4th January 1979
Current Annual Salary (Rs. in Lacs): / 7.0
Detailed Resume:
Devesh Surana
MCSA, ADCSSAA, B.Com
201, Manish Apartment, Nehru Road, Vile-Parle (East), Mumbai-400057.
Mobile Number: 9820400806
Email :
Career Objective
======
A challenging career in a professional organization like yours which will utilize my skills and abilities in the
Information Technology industry that offers professional growth while being resourceful, innovative, flexible,
supports and encourages my pursuit to provide services of highest quality under all possible circumstances.
Personal Skills
======
Comprehensive problem solving abilities, excellent technical, verbal and written communication skills, Ability
to deal with people diplomatically, willingness to learn, team facilitator.
Education & Professional Details
Post Graduation
======
Masters in Computer Software and Application. (MCSA)(2001-2003)
------
K. J. Somaiya Institute of Management Studies and Research, Mumbai.
Grade: Distinction. Aggregate: 75%.
Advanced Diploma In Computer Software System Analysis And Application. (ADCSSAA) (2000-2001)
------
Narsee Monjee Institute of Management Studies, Mumbai.
Grade: First. Aggregate: 69%.
Graduation
======
Bachelor of Commerce. (B.Com) (1998-1999)
------
Narsee Monjee College of Commerce and Economics, Mumbai.
Grade: First. Aggregate: 66%.
Higher Secondary School Certificate. (HSC) (1995-1996)
------
Narsee Monjee College of Commerce and Economics, Mumbai.
Grade: First. Aggregate: 64%.
Secondary School Certificate. (SSC) (1993-1994)
------
Parle Tilak Vidyalaya (English Medium), Mumbai.
Grade: Distinction. Aggregate: 80%.
Certification
======
* Oracle 10g Application Server Training and certification for J2EE, Portal and Web Services.
* IBM DB2 UDB V6.1/V7.1 Family Fundamental 512 Certified.
* IBM Web Sphere Studio Application Developer Exam 157 Certified.
Co-curricular Activities and Achievements
======
* Ranked 1st in Narsee Monjee Institute of Management Studies in the year 2000-2001.
* Ranked 2nd Trimester, 3rd in Second Trimester and 1st in Third Trimester.
Computer Proficiency
======
Database:Oracle 9i , FoxPro, Access 2000 and MS SQL Server 2000
Operating Systems:DOS, Unix, HP-UX , Linux, Windows 2000
Application Server:Oracle 9i Application Server
Languages:C, C++, Java
Front-Ends:Visual Basic 6.0, Developer 2000
Analysis:SSAD, OOAD, Software Engineering and Project Management
Markup Languages:HTML, DHTML, JavaScript and Visual-Basic Script, XML, ASP and JSP
Academic Projects
======
* Music Shop Management System using C.
* Contact List and Address Book using Access as backend and Visual Basic-6 as front-end application.
* Pay-slip generation system in PSAD.
* Development of Database Management System using C.
* Airline Reservation System using object oriented language C++.
* Projector Management System in UNIX (Shell Programming).
* MIS case study using Oracle 8i and Visual Basic 6.0.
* Payroll Management System using Oracle 8i and Visual Basic 6.0.
* Dental Clinic Management System using JDBC with Java.
Project Work/Case Studies in the industry
======
National Commodity and Derivatives Exchange (10th October, 2005 to Current)
------
Location of work: National Commodity and Derivatives Exchange, Exchange Plaza, Bandra-Kurla Complex, Mumbai-400051
Position Held: Manager
Profile: Oracle 9i DBA and Oracle Applications DBA
Activities
o Installation of Oracle 9i on AIX 5.3
o Administration tasks of Oracle 9i on Linux and AIX
o Configuration of RMAN backup to disk for Oracle 9i databases on Linux
o Performance Tuning of OLTP databases.
o Capacity planning for a Data warehousing oracle database.
o Teaming of Ethernet cards on RHEL 4.0.
o Formulating backup policy for Database and operating system.
o Formulating and implementing security policy for Oracle Database, AIX and Linux.
Nicholas Piramal India Ltd. (5th August,2004 to 10th October,2005)
------
Location of work: Nicholas Piramal India Ltd., Nicholas Tower, Peninsula Cooperate Park, Ganpatrao
Kadam Marg, Lower Parel, Mumbai-400012.
Profile: Oracle 9i DBA and Oracle Applications DBA
Activities:
o Administration tasks of Oracle 9i RAC on AIX 5.2 (64bit).
o Administration Task of Oracle 11i E-Business Suite (CRM - Sales Force Automation and Marketing) and Oracle 9i Olite on AIX 5.2.
o Configured Oracle 9i RAC on AIX 5.2 on two-node cluster on IBM RS6000.
o Cloned the concurrent manager and report services tier.
o Formulated and implemented backup policy in Tivoli Storage manager.
o Applying maintenance pack/patches on Oracle E-Business Suite 11.5.8
o Oracle 9i RAC on AIX 5.1 with Oracle E-Business Suite 11.5.8
o RMAN Integration with Oracle 9i RAC
o Oracle 9.2.5 upgrade patch applied on Oracle 9i RAC on AIX 5.1.
o Application of Security Patch# 68 on Oracle 9i RAC on AIX 5.1.
o Portal integration with Oracle E-business Suite 11.5.8 with Single Sign-on.
o Performance Tuning of queries for MGP (Replication Process for Oracle Lite 9i).
o Oracle Enterprise Manger to manage Oracle RAC instance.
o Installed Oracle 9.2.0.1 on AIX 5.2 for I2 Demand Manager. Create Oracle Databases for I2 Demand Manager and I2 Demand Manager Integration with Informatica.
o Upgraded the database version from 9.2.0.1 to 9.2.0.5. Configured Oracle 9.2.0.5 database for RMAN online backup.
o Carried out Application Performance tuning on JTF and AR schema for DVL and Chemist search.
o Applied Oracle Interim Oracle Patch 3072094 for CATSEARCH query through a view fails with OERI [20084]
o Installed BMC patrol with Oracle Applications and Oracle 9i RAC for predict and perceive, DB X-Ray and Oracle E-Business Suite Monitoring.
o Performed database recovery for database for I2DM database for system tablespace requiring recovery.
o Setting up and troubleshooting concurrent managers and concurrent requests.
o Applied required patches and family packs using adpatch, adadmin and adctrl utilities
o Configured Oracle 3.0.9.8.4 Portal with Oracle E-Business Suite 11.5.8
o Integration of custom application-ECRM with Oracle E-Business Suite 11.5.8
o Integration of Lotus Notes, ECRM and I2 with Single Sign-on in Oracle Portal and Oracle E-Business Suite 11.5.8
o Assisting developers to write efficient and cost effective queries.
o Helped developers in development of forms and reports for Oracle E Business Suite 11.5.8
o Creation of custom concurrent manager program with PL/SQL procedures and shell scripts.
o Active member in planning and designing of Disaster Recovery Plan.
o Applied AIX ML 6 Patch on AIX 5.2
o Implementation of proper security and audit measures at the database and UNIX level.
o Cloned two tier RAC database on raw file-system to single tier database on file system from RMAN cold backup.
Location of work :Nicholas Piramal Research Center, Nirlon Complex, Off Western Express Highway, Goregaon(East),Mumbai
Profile: Oracle 9i DBA and System Administrator
Activities:
o Installed AIX 5.2 on IBM P550 with HACMP console with two partitions
o Installed and configured Oracle Enterprise Edition 9.2.0.5 on AIX 5.2 for Chemoffice database
o Configured cold and hot backup script for backup of chemoffice database
o Configured chemoffice : E-Notebooks, Registration, Inventory and BioAssay modules on Windows 2000Server
o Installed and configures Oracle Standard Edition 9.2.0.5 on AIX 5.2 for LIMS database (Laboratory Information Management System)
o Installed and configures Oracle Standard Edition 9.2.0.5 on Windows 2003 for ECMS(Enterprise Content Management System) along with
installation of catridge.
o Configured ECMS software with Cyberlabs and Cyberprinter upload documents into ECMS database
HCL Infosystems Ltd. (19th May, 2003 to 4th August, 2004)
------
Location of work: Air India Ltd, Old Airport, Santacruz, Mumbai
Profile: System Administrator and Oracle9i DBA
Activities
o Includes all administration tasks of Oracle 9i Database which is on HP-Unix
cluster.
o Implementation done Oracle 9i installation on HP-UX cluster. Database
configured on HP-UX cluster, implementing the database structure creation,
which includes tablespace, rollback, performance management. Export/Import
of the database.
o Configured Oracle 9i Application server for deploying forms & reports on web.
Basic 9iAS administration.
o Installing Oracle 8.1.6 on HP-UX 11 in Anamica server.
o Migration of Priya database from Oracle 8.1.6 in IBM AIX to Oracle 9i in HP-UX 11i.
o Migration of payroll database from Oracle 7.1 on IBM AIX server to Oracle 9i on HP-UX 11i.
o Migration of OPS PRIYA database from Oracle 8i in Windows 2000 to Oracle 9i in HP-UX 11i.
o Carried out various system administration activities like installation of patches, creation of group, users.
o Creation of HP-UX high availability package Payroll.
o Configuring OMNI Back II for database and file-system back up.
o Oracle Forms Migration for payroll module from Oracle Forms 3.0 on IBM AIX to Oracle Forms 4.5 on IRIS.
o Creation of Stars Database and migration of database from FOXPRO to oracle database in HP-UX 11i. Use of tools like Visual Loader and SQL Loader.
o Involved in development of DSDC project using Visual Basic 6.0 with back-end in Oracle 9i (SID: Stars).
o Troubleshooting various constraints and index problems.
o Creating scripts for monitoring locks and session information..
o Deployment of Reports and forms on Oracle9i Application Server.
o Creation of physical and logical volume for mounting a new directory.
o Creation of PRAXIS database. Migration of database from Oracle 7.3 in IRIS 6.0 to Oracle 9i (SID: PRAXIS) on HP-UX 11i.
o Troubleshooting and resolving oracle internal error 600 in Oracle 7.3.
o Troubleshooting data block corruption with dbverify utility in Oracle 7.3.
o Recovering an instance from a corrupt control files due lost data file.
o Configuring OMNI and troubleshooting the errors.
o Assistance in migration of Forms 4.5 to Forms 9i for payroll.
o Performance tuning and changing of parameters like processes and sessions.
o Compiling and Deployment of Reports for OASYS and BEAS on Oracle 9i Application Server.
o Configuring OMNI BACKUP - II for taking online backup of PROD, stars, payroll, opspriya.
o Making point in time recovery after restoring the hot backup taken via OMNI using RMAN
Location of work: Allahabad Bank, Fort Branch, Mumbai (December, 2003)
Profile: Oracle DBA on Oracle 8.1.6 with Windows 2000 Advanced Server.
Activities
o Changing the oracle instance configuration for NDOPDS1
o Troubleshooting the oracle client-server connectivity for an application in Visual Basic 6.0 and Crystal Reports 8i.
o Migration of Oracle database from Oracle 8.1.6 on Windows 2000 server to Oracle 9.2.1.0 on Windows Advanced Server.
Location of work: High Court, Mumbai (December, 2003)
Profile: Oracle DBA on Oracle 9i with Red hat Linux 7.3.
Activities
o Installed Oracle 9.2.2.0 Enterprise Edition.
o Installed and configured Oracle 9i Developer Suite.
o Provided client connectivity over the network on Redhat Linux 7.3
Location of work: Bank of Maharashtra, Nariman Point , Mumbai (December, 2003)
Profile: Oracle DBA on Oracle 8.1.6 with Windows 2000 Advanced Server.
Activities
o Installed Oracle 8.1.6 Enterprise Edition.
o Migration of ITMS database from Oracle 8.1.6 on Windows 2000 server to Oracle 9.2.1.0 on Windows Advanced Server.
o Connectivity configuration for oracle server-client connectivity for PowerBuilder application provided by Synergy Login Systems.
Location of work: Syndicate Bank, Cuffe Parade, Mumbai (January, 2004)
Profile: Oracle DBA on Oracle 9i on Windows 2000 Advanced Server.
Activities
o Installed Oracle 9.0.2.1.0 Enterprise Edition.
o Migration of NDS and PDONDS database from Oracle 8.1.6 on Windows 2000 server to Oracle 9.0.2.1.0 on Windows 2000 Server.
o Client connectivity configuration for oracle server on various clients for Visual Basic and Crystal Report 8.5.
Location of work: MTNL City Exchange, Fort, Mumbai (February, 2004)
Profile: Oracle DBA for Oracle 8.1.6 and Forms 6i on HP-UX 11.0
Activities
o Installation of patches and Java 1.3 on HP-UX 11.0
o Creation of Volume group and Logical volume and mounting a newly added hard disk. Installation of Oracle 8.1.6 on HP-UX 11.0
o Installation of Forms 6i on HP-UX 11.0.
o Migration of Forms 4.5 to Forms 6i.Compilation and deploying the Forms.
Location of work: Reserve Bank of India, Fort, Mumbai (March, 2004)
Profile: Oracle DBA for Oracle 7.3 with SCO Open Server 5.05 as operating system
Activities
o Installation of SCO Open Server 5.05 on Compaq Proliant Server.
o Installation of Patch set on SCO Open Server 5.05.
o Installation of Oracle 7.3 on SCO Open Server 5.05 and creation of database.
Location of work: Reserve Bank of India, Fort, Mumbai (April, 2004)
Profile: Oracle DBA for Oracle 9i on Linux Enterprise Edition 3.0 and Oracle 9i Application Server on Windows 2000
Activities
o Installation of Oracle 9i Enterprise Edition on Redhat Linux Enterprise Edition
o Installation of Oracle 9i Application Server on Windows 2000 server.
o Database creation with SID as IESRBI.
o Database migration for INWARD database from Oracle 8.1.6 on Windows 2000 server to Oracle 9i on Linux Enterprise Edition 3.0.
o Deployment of Forms and reports on Oracle 9i Application Server.
Moores Rowland Consulting Pvt. Ltd. (4th February, 2003 to 4th May, 2003)
------
Location of work: EXIM Bank, Cuffe-Parade, Mumbai
Profile: System Analyst and Auditor
Activities
o Checking of Data-integrity after data migration through SQL Loader from flat files to EXIMDB database in Oracle 8.1.7.
o Checks for various security checks and creation of various databases trigger and PL/SQL procedures for monitoring of database security.
o System, functionality and unit testing for various General ledger, Voucher, Loan Accounting, Product Finance/Trade Finance, Overseas Investment Finance, Security, HRD and Admin modules of an banking ERP developed by Satyam for EXIM Bank.
Profressional Projects
------
Activities
o Website Hosting and Domain Name Registration
o Website Development and Web based Live Support Service
Personal Information
======
Age &Date of birth: 26 Years, 4th January,1979
Sex : Male
Marital Status : Single
Nationality : Indian
Languages : English, Hindi and Marathi.
References
======
Ashish Shom (Software Consultant)
Sagar Consultant
Telephone: 91-022-28956998
Email :
K.G.Dhopte (Sr. Manager Systems)
Department of Information Technology, Air India.
Telephone: 91-022-26263340
Email:
Resume of Devesh SuranaPage 1