SUMMARY:

Over Twenty Two years of strong upgrade, configure, maintenance and support experience in Oracle Applications Rel 12(12.2.6/12.1.3,12.0.4,11.5.10 cu 2/11.5.9/11.5.4/11.5.3/11.5.2),11.0.3/10.7 SC, 10.7 NCA/10.4 CUI using Oracle11g,10g(10.1.0.4),9i(9.2.0.5),9iAS,8.1.7.4, 8.1.7, 8.1.6, OEM 2.2/2.1, OBS 4.4, OAM, SQL*PLUS, SQL* Loader, Shell Scripts, SVRMGR, ADPATCH, Data Mart Suite 2.0, Pl SQL, C, Pro*C, LINUX SUSE,LINUX AS 2.1,IBM - AIX 5.3, HP

TECHNICAL SKILLS:

Applications: Oracle Applications 12.2.6(Rel 12(12.1.3,12.0.4) 11.5.9/11.5.7/11.5.3/11.5.2),11.0.3/10.7SC, 10.7 NCA/10.7CUI

RDBMS: Oracle 10g, 9i, 9iAS, 8.1.7, 8.1.6, 8.0.5, 8.0,7.1.3, 6.0

Modules: Automotive, Financial and Inventory, Order Management, Purchasing, CRM (Sales & Marketing), ERP - (Financials, Supply Chain, Order Management, HRMS Family)

Tools: SQL*DBA, SVRMGR, Oracle Enterprise Manager (OEM 2.2/2.1), Oracle Replication Manager, RMAN, EBU, SQL*Forms 3.0, SQL*Plus, PL/SQL, SQL*Loader, Import and Export, Oracle Developer/2000, Designer /2000

Languages: C, Pro*C, UNIX Shell, awk, Visual Basic 5.0/J2EE/PERL

Data Warehouse: Oracle Express Server 6.2, Oracle Webserver (9iAS)

Operating System: Sun Solaris 5.8/2.6, Linux Red Hat 2.6,Linux AS 2.1,SCO UNIX 3.2, IBM-AIX 5.3,Windows NT/95, Citrix Servers

Domain: Healthcare, Banking, Manufacturing, Telecom, Pharma

PROFESSIONAL EXPERIENCE:

Confidential, TX

Lead Oracle Apps DBA

Responsibilities:

• Leading implemented DR Solution for Oracle E - Business.
• Leading DBA team operational support and Migrations.
• Supporting Demantra implementation & R12 .2.6 upgrade for Endeca an m R12 implementation for applications
• Strategic Support for MDM, SOA, CTMS and Aurgus rollouts.
• Strategized, designed, vendor selected and implementing Global Support Team under offshore Model.
• Coordinating offshore team on daily operations support
• The SAP R/3 Order Management pipeline is Intel's online ordering processing system
• Database (>250GB + 10GB/month growth) environment that processed $6 to over $8 billion dollars
• in revenues per quarter.
• Experience with SAP modules MM, SD, FI, CO Experience with SAP Configuration, MRP, Demand Forecasting, Production Planning, Inventory Mgmt, Sales and Delivery
• Experience creating Business Objects reports using Web Intelligence
• Experience creating Business Objects universes
• Experience creating and supporting material, customer and vendor Master Data
• Planned, designed and implemented SAP initiatives based on case studies
• Experience in gathering client requirements to design database solutions.

Environment: Oracle 12c,SAP FICO and BO, OEM12c, CVS, Call Tracking, Standby database, SUN SOLARIS 10

Confidential, TX

Lead Development Apps DBA

Responsibilities:

• Performed database installations, upgrades, monitor, and performance tune and support operations of mission critical high available Linux clustered Oracle11g Enterprise databases running in a heterogeneous environment along with SAP R/3& Non SAP environments.
• Production and development support to developers/users for all database service needs across Oracle versions and instances on Linux, AIX and Solaris environment.
• Patch Application - application latest CPU patches/PSU db patches.
• Maintained Oracle databases version 11g, 10g, 9i and 8i.
• Performed user and security administration activities, such as enrolling users, granting privileges to users and maintaining system security. Troubleshooting the instance and database server. Performing export/ import of different database Objects/Schemas using Oracle Data pump utility.
• Managed database size ranging from 50GB to 4 TB. of Oracle apps from 12.1.1 t0
• worked intensively clonning oracle apps prod to dev,converted multi node to single node,merged with database server with apps node used XML file to merge the two node to single node
• Applied current level patches and upgraded the oracle database and oracle applications.
• Developed Cluster Simulation environment for I/O Performance and Simulation Testing on HP
• Created users and give the responsibilities and give the grand permission.
• Upgraded of Oracle database from 9i to 10.2.0.2 Design and implementation of backup and recovery strategy using tools, such as VeritasNetbackup and RMAN. Database and system monitoring tools.
• before rel 12i upgrade, converted the Oracle APPS DB to OATM model
• Configured the single node to multinode server with cluster file system(ACFS)
• Apply Apps patches and DST patch and Data Base applied Interpretability patch compile the invalid object through admin
• Complied flex field and change the mode maintenance mode thru ADADMIN
• Apps server configuration used autoconfig the change the server setting
• worked intensively cloning oracle apps prod to dev,converted multi node to single node, merged with database server with apps node used XML file to merge the two node to single node

Environment: Oracle 11g,SAP SOLMANAGER,Oracle Business Intelligenge,Oracle 11g,10 g, OAM, CVS, Oracle Enterprise Manager (OEM), Call Tracking, Standby database, SUN SOLARIS 10, SQL Navigator, PDL, Java, Apache, SSL

Confidential, NC

Lead Development Oracle Apps DBA / Production Support

Responsibilities:

• Installation of EBS R12.1.3.8 for VCP project. Also, installation of Demantra 7.3.1.4 on Windows 2008 and AIX 7.1 using Tomcat and Oracle 10gAS. Implement cloning of Demantra environment. Installation and configuration of Fusion Middleware OBIEE 11.1.1.6 with Weblogic 10.3.6 on AIX 7.1Implemented latest Oracle apps technologies like shared application top technology, OID/SSO, Confidential etc.
• Performance tested multi-tier Oracle Release 12 application deployments for use in Oracle E- business Suite.
• IInstalled new oracle 11g to Linux
• Focusing on Exadata administration. With nodes ranging from 2 to 8 and incorporating DataguardedExadata clusters for maximum availability.
• Disaster recovery of ExadataDataguard Physical Standby. Failover/Switchover/Loss of service/Rebuild/Corruption/Loss of datafile testing.
• Provided capacity planning for new database server as a new plan was coming online.
• Lead DBA role in 10gR2 to 11gR2 database upgrades on multiple database simultaneously.
• Proficient in Exadata maintenance/support/dataguard/backup/recovery/failover/switchover.
• Migrated and Installed OEM 12 c and RMAN backup and 11g rel2 on AIX and Linux
• MIGRATED Using RMAN Convert Script to windows to AIX
• Extensive Oracle E-business production support of HR, Financials and Manufacturing.
• Installed and Configured Fusion Middleware, Discoverer, SOA, BPM, OBIEE, APCC, SSO, OIM, Access Manager, and OID
• Implemented and configured multi tier Oracle Release 12.
• Upgraded several instances of Oracle Applications version 11.5.10 cu 2.
• Upgraded Oracle apps from 11.5.10.2 to R12.
• Configured the single node to multi-node server with cluster file system (ACFS).
• Applied Apps patches, DST patch and Data Base applied Interpretability patch
• Compiled the invalid object through admin.
• Complied flex field and change the mode maintenance mode thru ADADMIN.
• Configured apps server using autoconfig to change the server setting.
• Worked intensively cloning Oracle apps products to develop converted multi-node to single node.
• Merged with database server with apps node using XML file to merge the two-node to single node.
• Applied current level patches and upgraded the oracle database and oracle applications.
• Developed Cluster Simulation environment for I/O Performance and Simulation Testing on HP.
• Created users, gave the responsibilities and gave the grand permission.
• Configured Oracle 11g (Release. 1 and 2) database for an on-line customer service application.
• Upgraded databases from earlier versions of ORACLE 9i to ORACLE 11g.
• Tuned the production database towards optimal performance based on the changes in database storage structures due to application change requirements.

Environment: Oracle Applications Rel12, Oracle 11g Release 2, OAM, CVS, Oracle Enterprise Manager (OEM)

Confidential, TX

Lead Oracle Applications DBA

Responsibilities:

• Involved in implementing Oracle Advanced Benefits modules and System Administration of Oracle Applications
• Experienced in use of business intelligence, predictive analysis, and OLAP (online analytical processing)
• Involved in every aspect of project life cycle, including collaborative requirements gathering, creating work plans, functional requirements and unit testing plans
• Responsible for application development, project management, and Rapid Application Development (RAD)
• Installed Oracle 9iAS Web Server on Confidential .
• Installed and configured ETL,Setupcron jobs in UNIX to monitor the Databases
• Implemented SSL setup thru using firewall setup DM.
• Performance tested multi-tier oracle Rel 12 application deployments for use in oracle E- business Suite. Implemented and Configured Oracle Self Service Web Applications (SSWA) and Concurrent Manager processing.
• Applied current level patches and upgraded the oracle database and oracle applications.
• Configured and implemented Oracle Applications Manager (OAM) with Rel 12.0.4.
• Configured Self Service Web Applications for CRM and iProcurement
• Implemented and configured multi tier oracle Rel 12.

Environment: Oracle Applications Rel 12.0.4, 11.5.10 cu 2, Oracle 10 g,10 g AS, OAM, CVS, Oracle Enterprise Manager (OEM), Call Tracking, Standby database,HP-SUPER DOME,SSL

Confidential, TX

Sr. Oracle Manufacring/ Financial DBA

Responsibilities:

• Implemented and configured multi tier oracle 11i application
• implemented SSL setup thru using firewall setup DMZ.
• Performance tested multi tier oracle 11i application deployments for use in oracle E- business Suite on Demand Hosted Service
• Fusion Middle ware and SOA Configuration on Development Server
• Installed and configured weblogic 10.3 with UCM
• Lead Architect and Database Administrator for multi-terabyte data warehouse
• Logical and physical data modeling
• DDL generation and synchronization
• Participated in Performance and code review of oracle cluster manager for ORACLE 9i Confidential . Installed, Deployed, and administered Novel/Linux SUSE and Oracle 9i(both Confidential and NON Confidential ) With EMC and Network Applience.
• Implemented and configured multi tier oracle 11i application deployments for use in oracle E- business Suite on Demand service.
• Outline all standards for the DBA Group including installing/upgrading Oracle, creating databases, DBA tools, administration and monitoring, naming standards, policies, practices and procedures.
• Successfully maintained peak performance of all databases by providing advanced tuning methods, customized scripts and Oracle Enterprise Manager (OEM).
• Configured and implemented Oracle RMAN Backup

Environment: Oracle Applications 11.5.10 cu 2, Oracle 10 g,10 g AS, OAM, CVS, Oracle Enterprise Manager (OEM), Call Tracking, Standby database, LINUX SUSE, SQL Navigator, PDL, Java, Apache, SSL

Confidential, TX

Sr. Oracle Financial DBA

Responsibilities:

• Installed and Configured Oracle Application Instance 11.5.10 cu 2
• Created scripts for monitoring the Databases.
• Setup cron jobs in UNIX to monitor the Databases .
• Installed and applied patch, upgraded, configured, tuned, and maintained the Oracle 11i E-business suite and 9i databases. Provides support (on-call 24x7) for the production environment, which includes business-critical applications.
• Configured and implemented Oracle Confidential (Realtime application cluster architect with oracle APPS 11i)
• Involved in Custom Migration of Project Accounting, Purchasing, GL, AP and INV Modules of Oracle Applications.
• Cloned instances from production.
• Configured and implemented Oracle Applications Manager (OAM) with 11.5.10 cu 2
• Configured Self Service Web Applications for CRM and iProcurement
• Carried out bug fixing, trouble shooting, altering and debugging Java programs in the applications.
• Recompiled the Forms and Pl SQL Libraries.
• Designed and implemented the Hot and Cold backups for the Oracle Instances.
• Installed the Oracle 9iAS portal on the IBM-AIX 5.3Enterprise server

Environment: Oracle Applications 11.5.10 cu 2, Oracle 9iAS, 10g,9.2.0.5, OAM, Forms 6i, Reports 6i, Pl SQL, Sun APPS Modules: GL, AR, AP, FA, WIP, OE, INV, PO, QP, ASO, Oracle Projects

Confidential, NJ

Oracle Manufacturing DBA

Responsibilities:

• Upgraded and configured Oracle Applications 10.7 cui to 11i (11.5.5) on Sun Solaris 5.8 on a Multi Nodes.
• Installed 9i Application Server portal on the Sun Solaris server
• Configured Self Service Web Applications for CRM and iProcurement
• Participated in Performance and code review of oracle cluster manager for ORACLE 9i Confidential . Installed, Deployed, and administered Linux AS 2.1 and Oracle 9i(both Confidential and NON Confidential ) With EMC and Network Applience.
• Installed and configured ADI (reporting tool for financials) with Oracle Applications 11.5.4.
• Did cloning of Oracle Applications 11i (11.5.3, 11.5.4) instances from PROD to test environments on SUN Solaris.
• Installed and configured Oracle Discoverer with applications and MRC and Autoconfig.
• Installed and configured Oracle Balanced Scorecard (4.4) with Oracle Applications 11.5.4 Vision instances.
• Did conversion of Oracle Applications to Multi Org.
• Recompiled forms and PLSQL libraries.
• Designed and implemented hot and cold backups for Oracle instances.
• Maintained and trouble shooted scripts for database instances.
• Wrote PL/SQL procedures, triggers and packages.
• Managed concurrent requests and concurrent managers.
• Created and registered custom schemas, custom apps and forms with AOL.
• Installed and configured Oracle Enterprise Manager 2.2.
• Installed mobile applications, demand planning and configured with Apps 11.5.5.

Environment: Oracle Applications 11.5.9/11.5.3, Oracle 8.1.7, 8.1.6, 9iAS, OEM 2.2 OAM, Sun Solaris, AIX, Kintana, Oracle Enterprise Manager (OEM), BLT Remedy, Call Tracking, Standby database, IBM AIX 4.2, SQL Navigator, PDL, Java, Apache, SSL

Confidential, NY

Sr. Oracle/Applications DBA

Responsibilities:

• Installation, Upgrade, patching and managing Oracle Applications 10.7NC & Smart client and 11.0.3
• Tuning Concurrent Managers, Defining Work Shifts, etc.
• Installation, Upgrade and Configuration of Oracle (7.1.6, 7.3.4, 8.0.5, 8i).
• Defragmentation of database using export import.
• Removing row chaining fot better performance.
• Data Modelling, Database Design and Creation
• Deciding the naming conventions of datafile, redo log files, tablespaces, segments.
• Writing scripts for backup and recovery, Import and export procedure.
• Unix Shell scripting in csh, ksh for automating startup/shutdown of databases.

Environment: Oracle (7.3.4/8.0.x/8i), Oracle APPS 10.7 NCA, Pro*C, C, Unix Shell Scripting, SQL, Scripting, Forms (2.3, 4.5), Unix CRON jobs, Oracle Application Object, Library (AOL), BMC patrol monitoring.

Confidential, FL

Sr. Oracle Applications DBA

Responsibilities:

• Installed and configured 10.7 NCA, 11.0.3 applications.
• Upgraded Oracle Applications 10.7 NCA to 11.0.3
• Installed Oracle Applications 11i using Rapid Install.
• Installed and configured Oracle Server 8.1.6 (8i).
• Did migration of Oracle Applications 9.4.2 to 10.7 and 10.7 to 11.0.3.
• Installed oracle web application server.
• Created and maintained staging and development databases.
• Applied patches to application tier and database tier using ADPATCH.
• Wrote scripts for automation of database monitoring.
• Installed and did setup of HP printer in Oracle Applications.
• Did recovery of data at the table level using until time option.
• Installed and configured Oracle Server 7.3.4 and 8.0.5.
• Defined and maintained concurrent managers and programs.
• Created Snapshot Replication, Snapshot Logs and Updateable Snapshots.
• Configured master sites and replication groups.

Environment: Oracle Applications 11.0.3, Oracle (7.3.4/8.0.x), Pro*C, C, Unix Shell Scripting, Perl, SQL Scripting, Forms ( 4.5, 6i), Unix CRON jobs, Oracle Application Object Library (AOL), Reports 6i, BMC patrol monitoring.

Confidential, SC

Oracle APPS DBA

Responsibilities:

• Upgraded Oracle Applications 10.7 NCA to 11.0.3
• Installed and configured Oracle Server 8.1.6 (8i).
• Did migration of Oracle Applications 9.4.2 to 10.7 and 10.7 to 11.0.3.
• Installed oracle web application server.
• Created and maintained staging and development databases.
• Applied patches to application tier and database tier using ADPATCH.
• Wrote scripts for automation of database monitoring.
• Installed and did setup of HP printer in Oracle Applications.
• Did recovery of data at the table level using until time option.
• Installed and configured Oracle Server 7.3.4 and 8.0.5.
• Defined and maintained concurrent managers and programs.
• Created Snapshot Replication, Snapshot Logs and Updateable Snapshots.
• Configured master sites and replication groups.

Environment: Oracle Applications 11.0.3/10.7SC/NCA/9.4.2, 11i (General Ledger, Payables, Receivables and workflow), Sun Solaris, HP-UX, Windows NT

Confidential

Oracle APPS DBA

Responsibilities:

• Installed oracle application 10.7 sc server and client
• Oracle Application DBA
• Oracle Alert
• Oracle Common Modules and Oracle Financials using auto install.

Environment: Oracle Financial 10.7 SC (GL, AP, AR, HR, PR, OE)

Confidential

Consultant - Financial and Material Management Systems

Responsibilities:

• System analyzes material flow and stock maintenance, material allocation, vendor maintenance, purchase order system, maintenance of inflow and outflow of stocks. Preparing bill of material, issue of stock, preparing purchase order.
• Custom Application was developed with using Forms 2.3 and Reports 2.0 using Application Object Library Easy form, to test out the functionality and registration as custom application and reports.

Environment: Oracle Financial 10.4.2 (GL, AP, AR, PO and INV) Oracle 7.1, PL SQL, Reports 2.0, Forms 2.3

Confidential

Software Developer

Responsibilities:

• Accepting Deposits from the public for various deposits like Fixed Deposit, Cumulative Deposit, Recurring Deposit and cash certificate. Interest Warrants will be given to depositors periodically for fixed deposits. Online update will be done for any payment and receipt made through this system to financial accounting system.
• Involved in the following module: Designed the system in Object-Oriented Design methodology. Created Forms for data entry screens of Masters, Transactions and Reports.
• Created reports for Masters and Transactions Daily and Monthly collection, discharges and renewals, checklist and printing

Environment: Oracle 7.1/ Developer 2000 (Forms 4.5, Reports 2.5 and Graphics 2.5)

Confidential

Software Developer

Responsibilities:

• This system maintains the stock sales & purchase information, master updating, bill preparation, bill cancellation
• Credit Notes, receipt entries. It provides following reports
• Customer ledger, customer list, invoice register and item price list.

Environment: Oracle 7.0, CDE Tool Set (Forms 4.5, Reports 2.5)