SUMMARY

• Fifteen years of experience in teh Software Development.
• Data Modeling, Programming in PL/SQL, SQL*PLUS, Various tools like Oracle Developer/2000(Form4.5, Report2.5), Designer2000, A skilled Production Professional.
• A 15 years veteran as an Oracle Solution Architect, Sr. Architect - Sr. Oracle Application DBA on various Oracle E-Business Releases - 10.7 smart client, 10.7 NCA, All Releases of 11i and R12, OBIEE, SOA etc

TECHNICAL SKILLS

Language: C, C++, PL/SQL, SQL

Operating System: HP UNIX (RISC and Tru64), Sun Solaris, Windows 95, Window NT, Window 2000, Windows 2003, Linux and Confidential AIX GFS and HACMP

Database: Oracle 7.3, 8.0.x, 8i, 9i, 10g and 11g

Oracle Application Versions: 10.7 char, 10.7 SC, 11.0.3, 11i (all versions) and Release 12

Oracle E-Business Suite: Financials, Manufacturing (including Advance supply chain planning and Demand Planning or Demantra), Order Management, Iprocurement, CRM- Mobile Field Sales, Sales Offline, Quoting, Oracle HRMS etc.

Oracle Security Suites: Application Access Control Governor 8.2, Oracle Preventive Control Governor 7.2

Oracle application upgrades: 10.7 char to 11i, 10.7 SC to 11i, 11.0.3 to 11i, 11.5.x to 11.5.10 and R12

Tools: Erwin, Designer 2000, Oracle Application Manager (OAM), OEM Grid Control

Backup Recovery: Disaster Recovery RMAN, Standby Database, Data Guard, 9i/10g/11g RAC

Other Oracle Products: Oracle Application Server 10g, Oracle Discoverer, Oracle Express server, OFA, OSA, Oracle Tutor, DBI and ADI

Remote Support: Provide remote DBA support

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Working as Oracle Systems/Solution Architect
• Performed Platform migration (HP-RISC to Linux) for E-Business 11i
• Upgraded 11.5.10.2 release to 12.2.4 release
• Upgraded 11i to 12.1.3 release dat includes OATM migration
• Database upgrade from 10g to 11gR2 as a part of platform migration and upgrade
• Supported approx. 50 environments on various 11i as well R12
• Installed and Configured GENTRAN System for EDI
• Configured Oracle Systems, Database so it can communicate wif SQL Server
• Lay out Disaster Recovery plan and implemented it successfully
• Client has multiple 11i and R12 production environments due to Business needs
• Resolved performance issue on MRP system
• Supported various projects for R12 go-live environments as well as upgrade project. Duties includes SYSADMIN Support, Cloning, Patching, Performance tuning, Auditing and so on.
• 12c GRID Control Installation and Configuration to monitor various environments
• Managed and support HP Data Protector (formerly known as Omni backup) for all databases related backup as well as HP RISC and Linux file systems backup
• Integrated Data Protector wif Oracle RMAN
• Performed a successful Disaster Recovery activities for all production environments
• Supported systems consist of - VMWARE, Linux, HP PA-RISC. Databases runs on both virtual server as well as physical servers
• Installed and supporting E-Business Suite Release 12.2.x on Linux environment as client is evaluating upgrade path from existing release

Confidential

Responsibilities:

• As a Oracle System Architect, Designed and Delivered a project plan and later upgraded existing 11.2.0.3 database to latest oracle database 12c - 12.1.0.1
• Upgraded E-Business System 12.1.3 to 12.2.2 along wif database upgraded 12c
• Managed, Designed and Successfully delivered Enterprise Manager 12c -12.1.0.3 upgrade from existing 10.2.0.5 OEM/GRID Control for more TEMPthan 20 target servers
• Integrated latest Oracle Application Management Pack 12.1.0.1 wif 12c OEM/GRID to monitor and manage E-Business Systems
• As a Sr. Architect / Lead Application DBA - Architected, Designed and Delivered R12 - 12.0.6 multi-tiers MLS implementation on Oracle Enterprise Linux 5 for a Global Company. - Financials, CRM and Manufacturing Modules as well as Oracle GRC ( AACG 8.2 and PCG 7.2)
• Upgraded R12.0.6 to R12.1.3. It includes Project management, co-ordination wif functional as well as management team and hands-on entire upgrade process
• Integrated Oracle GRC (AACG 8.2) wif Oracle E-Business R12
• Successfully deployed Oracle CloneDB technology for client which allows to clone/refresh production database in minutes instead of hours
• Installed, Configured and Integrated OBIEE 11g wif E-Business 12.1.3
• Installed, Configured and Integrated Oracle UPK wif E-Business 12.1.3
• Installed, Configured and Used Oracle ACFS Files systems
• Mentored Client DBA team on R12 E-Business System
• Upgraded 10g RAC database to 11g RAC for Oracle E-Business Suite R12 in a multi-node environment
• System consists of R12 RUP6 wif 10g Database - Two node RAC, Three nodes Application Servers in Load Balanced mode using Cisco Switches and SSL
• Providing support for day to day activities - Cloning, Performance Tuning, User Support
• Implemented Disaster Recovery System
• Implemented release 12 wif BIG IP and SSL configuration on Solaris platform wif MLS environment using multi-tier architecture. Also Installed and Configured R12 on Redhat ES 4.0
• Providing day to day support of Release 12 - 12.0.6 as Sr. Application DBA and System Administrator
• Sr. Lead Application DBA supporting 4 nodes Oracle RAC wif multi-tier environments.
• Supported modules are financials, supply chain, HR, Mobile Supply Chain, i-store, i-payment, i-receivables etc
• Migrated 11.5.10.2 from Dell Servers to Confidential P5 Linux servers - Cross Platform Migration
• Worked wif RMAN, DATA GUARD and used rman for teh application cloning from ASM to ASM as well as ASM to non-ASM
• Built a 4 nodes RAC, Stand-alone PCP servers and 6 nodes web servers in load balancing and SSL mode using F5 for Oracle Application Release 11.5.10.2
• Sr. Architect/ Sr. Application DBA responsible for Disaster Recovery site setup / Data Center migration for E-Business 4-nodes RAC system
• Delivered, Implemented and Managed > 5 Terabyte E-business suite database system
• Setup and Implemented Confidential Tivoli TSM and RMAN integration for database backup
• Delivered a highly secured Oracle E-Business Suite environment by using oracle best practices
• Deployed and Configured MWA module for Oracle Application using two separate application servers in load balanced format
• Deployed and Configured More4Apps Product to work wif E-Business Suite
• Code Management deployment and support using Serena PVCS
• Deployed and Configured Oracle UPK 11.x Suites products (Content Development, UPK Player and Knowledge Center) on a separate servers as well as integrated wif E-Business Suite
• Assessed and setup a Proof of Concept for Oracle Streams between databases to compare wif other backup and recovery options as well as Disaster Recovery scenarios

Confidential

Responsibilities:

• Providing support for Oracle E-Business Suite 11i - 11.5.10.2 wif Oracle Real Application Cluster - RAC on Solaris and Linux environments.
• Deployed, Configured Oracle Grid Control, RMAN, 10g Discoverer to work wif Oracle E-Business Suite
• Handle activities like cloning, patching, code migration, performance tuning etc
• Configured Oracle E-Business Suite in a Load Balanced environment wif PCP - Parallel Concurrent Processing enabled on a 10g Oracle RAC
• Providing support for Active Directory - OID users and groups migration for single sign-on
• Mentoring Client DBA team
• Supporting approx 24 Oracle E-Business environments as Sr. Architect - Sr. Oracle Application DBA

Confidential

Responsibilities:

• Working as an Sr. Architect / Sr. Oracle Application DBA to support and implement 11.5.10.2 environment
• Worked as Lead Architect for Confidential AIX HACMP failover and Disaster Recovery achieving a less TEMPthan a minute down time during failover. Achieved maximum up-time on a non-RAC and non-Standby Database.
• Working as Lead Oracle Application DBA and mentoring Team members on application DBA duties
• Create and Maintain necessary technical documents
• Perform cloning on same server as well as cross-over servers depending on client need
• Worked wif Netezza and Supported Oracle Databases for Netezza System

Confidential

Responsibilities:

• Working as an Sr. Architect - Sr. Oracle Application DBA to support and implement 11.5.10.2 MLS environment
• Traditional Chinese, simplified Chinese, Korean, Japanese, Latin American languages are configured
• Working as Lead Oracle Application DBA and mentoring Team members on application DBA duties
• Create and Maintain necessary technical documents

Confidential

Responsibilities:

• Lead Architect as well as working as a Sr. Oracle Application DBA to support and implement 11.5.10.2 MLS environment
• Implemented Transparent Data Encryption (TDE), Virtual Private Database (VPD) and Database Audit/vault products. This was requires for HIPPA compliancy
• Wif TDE,VPD in placed, Even DBA can't see data from Sensitive tables
• Various European languages as well as Chinese languages are configured
• 11.5.10 implementation wif Oracle Financial Suite, Manufacturing and HRMS
• Upgraded Database upgrade from 9i to 10g and 8i to 10g Release 2
• Installed Oracle Application server 10g Release 2 as well as 10g Discoverer
• Configured single 10g Discoverer for multiple environments
• Applied HRMS Family Pack K
• Perform Cloning, Disaster Recovery, Patching as well as all regular Database Admin Duties
• Cross Platform upgrade of 11.5.10 as well as database for 250GB database size
• Migrated 11i application from HP Tru64 to Linux
• Migrated 8.1.7.4 database to 10g database on Linux

Confidential

Responsibilities:

• 11.5.10 financial, Manufacturing, Oracle Projects, HRMS and CRM implementation on HP-UX RISC system, Sun Solaris and Linux
• Use SHARED APPL TOP, OATM tablespaces, Distributed AD technologies, Rapid Clone, OAM cloning method
• 11.5.9 E-business suites wif RAC on Red Hat Linux Servers
• Working as a Sr. Oracle Application DBA-Architect
• Worked on Discoverer setup including EUL, Interface setup, ADI etc.
• Mentoring Jr. DBA
• Worked on Disaster Recovery setup, Backup- Recovery via RMAN and HP omni back
• Standby Database and Data Guard
• Configured Oracle CRM modules - Oracle Mobile Service, Sales offline, Oracle Quoting etc
• Created a clone environment on a single server from multi-server environment using shared APPL TOP using a custom cloning method
• System architecture assessment for newly install infrastructure

Confidential

Responsibilities:

• Implemented Oracle 9i RAC two node cluster on Confidential AIX p-series servers wif HACMP and raw devices
• Implemented Oracle RAC three node clusters on Sun Solaris wif Veritas3.5 which include ODM
• Implemented Oracle RAC on two node Linux clusters.
• Install, Configured, Implemented Oracle Application 11.5.10 financials, Supply Chain and Demand Planning application including Manufacturing modules as well as Oracle CRM modules.
• Upgrade 11.5.2 to 11.5.10 using modified upgrade method which takes very less downtime tan Oracle Standard upgrade process.
• Installed, Configured, Implemented Oracle Application 11.5.9 financials, Supply chain and Demand planning application including Manufacturing modules as well as oracle CRM modules on Sun Solaris
• Installed, Managed Daily business intelligence DBI 6.0
• Upgraded Oracle Application 10.7 smart client to Oracle Application 11.5.8 on HP-UX and Sun Solaris
• Converted Oracle 32-bit Application to 64-bit
• Oracle Database upgrade - 8.1.7.4 to 9.2.0.6
• Installed, Configured, and Managed Oracle Express Server 6.3.2, OFA 6.3.1, Report Server 6I on HP-UX 11.0 Integrated wif Oracle Application 11I.
• Designed, implemented Disaster recovery and backup strategy
• Used frequently Rapid clone method as well as custom cloning for single tier to multi-tier and vice-a-versa
• Worked as Tech Lead/ Sr. Oracle Application DBA
• Managed a team of 3 DBA’s and 10 plus Developers
• Worked on 9iAS Security setup which includes LDAP, OID single sign on
• Installed, Configured, administered Oracle Workflow which used new java mailer in 11.5.9. Also configured SENDMAIL utility which used by workflow on Unix Platforms for releases earlier tan 11.5.9. Tuned workflow back ground processes when ever it required.

Confidential

Oracle Application DBA

Responsibilities:

• Upgraded Oracle application 10.7 char to 11I on HP-UX 11.0 for 170GB size of Database
• Upgraded 9iAS 1.0.2.0 to 1.02.2.2 wif portal 3.0.6 to 3.0.9 on HP-UX 11.0
• Configured Different Version or Oracle PORTAL on one database (3.0.6, 3.0.9 on single Database)
• Working as Tech Lead/Application DBA
• Installed, Configured, Maintained 11I on HP-UX 11.0
• Installed, Configured, Managed Oracle 9I Application Server including portal on HP-UX 11.0
• Configured Oracle Portal to handle External Applications as well as Partner Application ( Oracle Application, Oracle Financial Analyzer etc)
• Cloned Oracle Application from Single Tier to Multi Tier and vise-a-versa
• Upgraded Database 8.1.6 to 8.1.7.2 for Oracle Application 11I
• Working as SYSADMIN of Oracle Application as well as Backup of Unix Admin
• Defined Tested and Implemented Disaster Recovery system for Oracle Application.
• Managing Standby Databases and OPS databases On Unix and NT
• Upgrade 11.5.3 Oracle application to 11.5.4, 11.5.5 on Sun Solaris and HP-UX 11.0
• Upgraded 10.7 char to 11i (11.5.3) Oracle Application on Sun Solaris wif database size 250 GB
• Upgraded 10.7SC to 11i (11.5.6) Oracle Application on Sun Solaris wif database size 170 GB (cross platform from Confidential AIX to Sun Solaris)
• Upgraded Database 7.3.4 to 8.1.7.2
• Upgraded Jinitiator 1.1.8.13,1.1.8.16,1.1.8.32
• Installed, Configured Oracle Tutor 11i
• Configured Oracle 11i Self service framework 5.6E
• Installed, Administered, Configured Oracle 11i CRM modules
• Sr. Oracle Application DBA for a Global Oracle 11i Implementation team
• Tuned Oracle application to get maximum performance, which includes 9iAS portion like Apache, Jserver, mod plsql etc.
• Install, Configured Oracle 9i Database on Windows Platform
• Global Implementation of 11i on Sun Solaris for Mattel Inc.
• Administered, Managed and supported approx. 12 Instances at any one point of time at Mattel Inc.
• Cloned 11i Instances from Multi Tiers to Single Tiers
• Installed, Configured Oracle Application Manager (OAM) for 11i
• European, Latin American Language patching management
• Upgraded Oracle application 11.5.6 to 11.5.8, which include 9iAS application server upgrade, database upgrade, Developer 6i upgrade, JDK upgrade, Jinitiator upgrade etc in less tan 36 hours.
• Global Implementation for French, Latin American Languages, Italian, Greek etc on 11.5.8 MLS environment on Sun Solaris.
• Implemented imarketing, ipayment, iexpense, tele sales etc CRM modules
• Successfully installed, configured, implemented ipayment wif Entrust software dat link to Citibank for online secure transactions.
• Tuned FSG’ Reports which was running > 6 hours to make it run < 1 hour
• Integrated ipayment wif entrust java toolkit which send secure transaction to Citibank directly from Oracle Application database
• Upgraded 10.7 char to 11.5.9 which includes financials, Manufacturing on sun Solaris
• Installed, Configured, administered Oracle Workflow which used new java mailer in 11.5.9. Also configured SENDMAIL utility which used by workflow on Unix Platforms for releases earlier tan 11.5.9. Tuned workflow back ground processes when ever it required.
• Successfully upgraded 11.5.3 to 11.5.9 on Windows Platform.

Confidential

Tech Lead/Sr. Consultant

Responsibilities:

• Working as a Sr. Architect in Ariba Central Practice.
• Responsibility includes Design, Install and Configure teh Technical Architecture of Ariba Trading Dynamics as well as Ariba Buyer.
• Working as Administrator/Bridge between Technical Developers and Management to identify teh need of missing Links such as Custom development etc

Confidential

Tech Lead/Oracle Application DBA

Responsibilities:

• Working as Technical Lead and Oracle Application DBA for Oracle Application 11I software on Sun Solaris as well as on HP-UX (RISC and Tru64) system.
• Successfully installed more tan 20 Oracle Application 11i on Sun Solaris and HP includes all oracle modules wif ORACLE IPROCUREMENT.
• Installed Single and Multi node for Oracle ERP.
• Working as Application System Administrator.
• Mentored Jr. Database Administrators.
• Integrate Ariba ORMS wif oracle applications.
• Done upgrade 10.7 to 11i on Sun Solaris
• Installed, Configured, administered Oracle Workflow. Also configured SENDMAIL utility which used by workflow on Unix Platforms. Tuned workflow back ground processes when ever it required.

Confidential

Sr.Consultant

Responsibilities:

• Working as Oracle Application DBA.
• Successfully completed 12 Oracle Application Implementation on Sun Solaris and HP Platforms.
• Installed Single and Multi node Implementation for Oracle ERP.
• Working as Application System Administrator.
• Installed and configured ARIBA Marketsuite integrated wif Oracle.
• Installed and configured CALICO Marketmaker suite integrated wif Oracle.
• Worked as Data Modeler using Erwin Tool.