EXPERIENCE SUMMARY

is an Oracle Certified Professional with Twelve years of experience in IT industry. He is an Oracle DBA, Oracle Applications DBA, PeopleSoft Admin and Application System Administrator/Architect on different platforms with different flavors of UNIX. He has worked on multiple versions of Oracle Applications such as R12.X, 11i, 11.0.3/10.7 NCA/10.7 SC (both GUI and Character based). Expertise in Installing, upgrading, performance tuning , Unix kernel tuning, table space management, monitoring database, backup, archiving ,recovery plans, database re-organizations and supporting multiple Oracle instances/application system in a 24 by 7 environment of oracle applications.

SKILL SETS

ERP - Oracle Ebusiness suite Applications 10.7.X through R12.X (Financials, Manufacturing, Order Management, SSWA, CRM, Oracle Sales Online, Quoting, Contracts, Advance Pricing, Federal, iProcurement, Benefits, HRMS, Payroll and FAH)
Oracle Financial Services -
Siebel Analytics - Oracle Business intelligence enterprise edition OBIEE 10.1
Revalues - Oracle Financial Service Analytical application Infrastructure OFSAAI 7.1
RDBMS/Software Tools - Oracle 7.x/8.x/8i/9i/10g/11g ; SQL*PLUS; PL/SQL; FORMS /10g/6.0/4.5; REPORTS 10g/6/2.5; Oracle Discoverer 3.1/4i, ADI (Application Desktop Integrator) ,Oracle Workflow 2.6, GLDI; Oracle Enterprise Manager.
Middle Tier - Jboss, Tuxedo, AI, Oracle 10gAS,Tomcat and Weblogic
Operating Systems - Solaris 2.5.1/2.6/2.8(SUN OS 5.5.1)/2.9, UNIX SVR4, IBM AIX, HP 9000, MS-DOS v7.0, Linux, Windows 95/98/NT/2000/XP and VMware
Hardware - SUN Ultra Enterprise Servers, Pentium Server, Pentium PCs
Languages - C; Unix Shell Programming (Bourn, ksh, csh), crontab, awk, perl and PL/SQL
Xclients - Hummingbird Exceed V7.1, Reflection, VNC Viewer

HIGHER EDUCATION

• Master In Computer Applications
• Bachelor Of Science(Mathematics)

AFFILIATIONS/CERTIFICATIONS

• Oracle E-Business Suite Applications Database Administration Certification Professional (OCP) in 11i and R12
• Oracle Certified Professional (OCP) in 9i and 10g
• 11i9 Oracle E-business Suite Technical Integration Champion.
• Oracle E-Business suite Accelerator(OBA) in R12.1 level 3.
• Diploma in Oracle Relational Database Management Systems.
• Member - Oracle Applications User Group.

TRAINING

• Completed one week classroom training in Oracle DatabaseXtender - Outerbay
• Completed the Instructor led training in Oracle 9i RAC - Oracle Corporation
• Completed the instructor led training in Administering SQL Server 2000 Database
• Completed the Instructor led training in PeopleSoft Admin - 8.48.08
• Capgemini- Engagement Management

RELEVANT EXPERIENCE

Project Title: Oracle Database/Application System Administration/Data Architect
Client: Confidential, NJ
Application Version: 11.0.3 through R12.X
Operating System: Sun Solaris ,HP-Unix, IBM AIX, Linux and Windows
Database: ORACLE 8i, 9i,10g and 11g
Duration: July'04 - Sept'2010

Role:
Oracle Database Maintenance/Oracle Application System administration/Solution Data architect Support for Oracle Applications (10.7.X through R12.X), running on various operating systems.

• Played the role of Oracle DBA ,Application DBA and Solution Architect responsible for implementation and support of Oracle Application environments for multiple clients including the Oracle Development Center at EY Newyork ADC.
• Played the lead architect and application dba for Migrated the Oracle Applications from the different flavours of Unix RHEL 2.5 to RHEL 5 & from Windows to Unix.
• Managed and coordinated the client DBA's, Offshore resources for on-time deliverables.
• Performed Installation and Configuration of Oracle Applications from R11.X to R12.X on various operating systems.
• Upgraded Oracle Applications from 11.5.9 to 11.5.10, 11.5.5 to 11.5.10 and installed all the Oracle application releases from 10.7 to R12.
• Installed and Maintained the Middle tier applications like Tuxedo, JBOSS, Apache, Weblogic and AI servers.
• Upgraded the Oracle Databases from 8.1.6.X to 8.1.7.X ,8.1.7.x to 9i and 9i to 10g.
• Cloning Oracle Applications using adclone, Autoconfig, Rapidclone
• Tuning the user defined SQL queries, procedures and functions using Toad, explain plan, tkprof.
• Troubleshoot Database performance issues using EXPLAIN PLAN, TKPROF, SQL TRACE,Analyze, Hints, Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM) etc.
• Worked on various database tools like Statspack, Data pump, Flashback tables, Oracle wallet manager (OWM), ASM and SQL Tuning Advisor etc.
• Installation and Configuration of Oracle 10g Real Application Clusters (RAC) and Automatic Storage Management (ASM).
• Good knowledge of Oracle 10g Streams and data encryption techniques.
• Applied the latest Oracle Applications, Oracle CPU (Critical Patch Updates) and DST (Daylight savings) patches.
• Configured and maintained Oracle read-only standby databases and fail over databases(Data guard).
• Responsible for code migration to all respective instances.
• Involved in Oracle Data Guard and Grid control implementations of Oracle 10g R2
• Implemented the Oracle RMAN for backups and developed the shell scripts for backups and monitor the database performances.
• Implemented & configured the the Oracle enterprise Manager (OEM)/database control/Oracle DB Grid control and managed the Oracle Instances.
• Converted the PeopleSoft Application database from Non Unicode into Unicode
• Upgraded the PeopleSoft tools 8.2.0 to 8.48.08 and HRMS applications from 8.0 to 9.0
• Installed and configured the OBIEE 10.1,OFSAAI 7.1 & Demantra 7.3

Project Title: Oracle Database/Application System Administration
Client: Confidential, New York
Application Version: 11.5.9
Operating System: Sun Solaris 2.8
Database: ORACLE 8i and 9i
Duration: Aug'03 - July'04

Role:
Oracle Database Maintenance / Oracle Application System administration Support for Oracle Applications 11.5.9, running on Sun Solaris.
Oracle Apps DBA:

• Led the applications DBA team for conversion from PeopleSoft HR to Oracle HR and the associated Customizations.
• Managed 15 instances by accessing the development team of 50 users daily.
• Installed and configured NLS/MLS and implemented the additional languages like Japanese, Chinese,.spanish...etc
• Installed and configured Oracle Enterprise manager (OEM), Discoverer and Portal, Single sign on and Oracle Internet Directory (OID)
• Audited HRMS tables at application level.
• Installed and configured stats pack.
• Applied Latest HRMS (US/JA) Maintenance Patches to various application Instances.
• Maintaining application source code version control system using PVCS.
• Made recommendations for the purge of workflow tables, analyzer scripts to be run, change the key application/database user passwords.

Project Title: Oracle Database/Application System Administration
Client: Confidential, NJ.
Application Version: 10.7.X through 11i
Operating System: Sun Solaris 2.8/2.6/2.5.1, Windows NT, HP-UX, Linux Intel, AIX
Database: ORACLE 8.X / 8i/9i
Duration: Jun'01 - Aug'03

Role:
Oracle Database Maintenance / Oracle Application System administration Support for Oracle Applications (10.7.X through 11i), running on various operating systems detailed above.
Oracle Application Database Administration:

• Performed Installation and Configuration of Oracle Applications 11i on Sun Solaris UNIX
• Installed Oracle 9i and migrated from 8i to 9i to use Oracle Applications 11i
• Upgrade from Oracle Applications 10.7 to 11.5.X, 11.0.X to 11.5.X and 11.5.X to 11.5.8 and 11.5.9
• Migrated Oracle Applications 11i from HP-UX to Solaris.
• Applied Latest Oracle Application Maintenance Patches to the various instances like PROD, TEST and Development Instances by using the Oracle tool adpatch, admrgpatch and external tools like Kintana,Ringmaster..etc
• Rebuild the Highly fragmented objects by using the Proper storage structure
• Loaded flat files and other data files from some non-networked application and populated into Oracle Database using direct path method of SQL* Loader and import/export.
• Scheduling concurrent processes to perform routine housekeeping activities and also for improving Application performance (Gather Statistics etc.,)
• Configure the Form server Load Balancing and web server load balancing
• Configure the Apache Single Listener
• Upgraded the Workflow from 2.5 to 2.6
• Installed the Developer 6i Patch sets for Upgrading forms and reports
• Configure Oracle application into SSL mode ( http to https).
• Installed Multiple Reporting Currency (MRC)
• Installation and configuration of Application Desktop Integrator (ADI)
• Installation and configuration of Oracle Discoverer 3i/4i

Project Title: Oracle Database/Application System Administration
Client: Confidential, Boston,MA
Application Version: 11.5.3
Modules: Financial, Manufacturing and CRM Modules
Operating System: Sun Solaris 2.6/2.5.1, Windows NT, HP-UX, Linux Intel,
Database: ORACLE 8.X / 8i
Duration: Apr'01 - Jun'01

Role:
Oracle Database Maintenance / Oracle Application System administration Support for Oracle Applications 11.5.3 running on various operating systems detailed above.
Oracle Application Database Administration

• Performed Installation of Oracle E-Business Suite R11I (11.5.3) On HP-UX 11.0
• Implementing All the Financial, Manufacturing and CRM Modules like OE, AR, AP, GL, BOM, Engineering, Self Service Time, Isupport, Istore, Ipayment, etc.
• Configure the Form server Load Balancing
• Migrate the Oracle Applications Database from 8.1.6.0.0 to 8.1.6.3.1
• Creating and assigning Responsibilities to the respectable Users
• Applying Latest Patches to the Test and Prod Instances
• Upgrading Oracle Developer 6 to Developer 6I Patch 3(6.0.8.12.x)
• Refreshed Oracle Applications from Prod to Test From One Unix Box to Another Box

Project Title: Oracle Database/Application System Administration
Client: Confidential, Chicago,IL
Application Version: 10.7.X through 11i
Modules: Financial, Manufacturing and CRM Modules
Operating System: Sun Solaris 2.6/2.5.1, Windows NT, HP-UX, Linux Intel
Database: ORACLE 8.X / 8i
Duration: Dec'00 - Apr'01

Role:
Oracle Database Maintenance / Oracle Application System administration Support for Oracle Applications (10.7.X through 11i), running on various operating systems detailed above.
Oracle Application Database Administration

• Performed Migration of Oracle Applications from HP UNIX to Sun Solaris UNIX
• Upgrade from Oracle Applications 11.0.2 to 11.0.3
• Configuring the Web Server for Oracle Applications
• Installation/Upload of Quantum Vertex 2.0 (Tax calculation tool which interface with Accounts Receivables taxes)
• In-charge of the maintenance team supporting nearly 20 instances of Oracle Applications 11.0.3 and 11.1.5.2 with Oracle 8.0.5 and 8.1.6 running on Sun 4 servers
• Have designed, developed and implemented backup strategies and database refresh procedures
• Design space allocations and relocations of custom oracle applications form one server to avoid the maintenance nightmares and also to avoid downtime of other applications running on the same machine

Project Title: Oracle Database/Application System Administration
Client: Confidential, Freemount,CA
Application Version: 10.7.X through 11i
Modules: Financial, Manufacturing and CRM Modules
Operating System: Sun Solaris 2.6/2.5.1, Windows NT, HP-UX, Linux Intel
Database: ORACLE 8.X / 8i
Duration: July'00 - Dec'00

Role:
Oracle Database Maintenance / Oracle Application System administration Support for Oracle Applications (10.7.X through 11i), running on various operating systems detailed above.
Oracle Application Database Administration

• Refreshed Schemas in development databases from production databases on demand
• Developed and implemented procedures written using shell scripts for monitoring the databases running on different machines
• Applied and Upgraded Customized Modules in Apps
• Wrote scripts for Phased loading of data from Legacy system to interface tables
• Monitored Database for Max extents and for invalid objects using scripts and rectify them
• Installed Discover 2000 on NT server
• Called Oracle Support for internal errors and flex bugs
• Created new custom Application tops
• Defined Concurrent Managers and scheduling
• Defined Concurrent requests and scheduling it for time intervals
• Registered forms and reports on financial tops

Project Title: Oracle Database/Application System Administration
Client: Confidential, Bangalore India
Application Version: 10.7.X through 11i
Modules: Financial, Manufacturing and CRM Modules
Operating System: Sun Solaris 2.6/2.5.1, Windows NT, HP-UX, Linux Intel,
Database: ORACLE 8.X / 8i
Duration: Jun'98 - Jun'00

Role:
Oracle Database Maintenance / Oracle Application System administration Support for Oracle Applications (10.7.X through 11i), running on various operating systems detailed above.
Oracle Database Administration

• Refreshed Installing and upgrading the Oracle7 Server and Application tools
• Designing and creating database, Create Primary Database Storage structures and Primary objects, Allocate system storage and plan future storage requirements for database
• Modify database structure, Enroll users, Grant and Revoke database privileges, Control and Monitor user access to the database
• Backup and recover the database
• Maintain System security, Monitor and Optimize database, Performance
• Wrote shell scripts to monitor trace files
• Wrote Cold backup shell script to take complete cold backup, Implemented automatic startup of databases during system boot process
• Oracle Application Database Administration
• Managed three independent Database servers running Under Sun Solaris each with forty users accessing concurrently
• Monitoring users system activities and debugging their system related problems
• Monitoring system performance by using Server Manager
• Daily, Weekly, Monthly backups (Export, Online, Offline)
• Completely recovered all databases when system crashed
• Solved SQL*NET connectivity problems and Listener Configuration
• Reconfigured All Databases in Multithreaded Server, Archive mode