OBJECTIVE:

Provide unique and focused design and excellent quality results as a consultant working with Oracle e - Business Suite, Oracle Database and Oracle Application Server technologies

PROFILE:

• With over Twenty four years of extensive and diversified technical experience in Information Technology industry of which, over 15 years of consulting experience in a variety of Oracle software and customer environments, over six years as a trainer (Instructor) and over four years in software development using Oracle products
• With wide, varied and deep experience of Oracle’s internals, architecture and features, on various versions of Oracle products, Performance Tuning, implementing and maintaining Real Application Cluster (RAC) and GRID, Oracle Application Server as Oracle Applications DBA / Technical Architect, for many mission critical, high volume, VLDB Oracle projects for over 100 different clients throughout North America
• Experience includes I/O design for performance and troubleshooting on various UNIX / Linux Operating Systems and clustering tools
• Best practices and long term plan being followed makes me a unique and a capable candidate for lead and key roles in Installations, Upgrade, and Performance Tuning
• Technical skills include database management and administration, relational database design and implementation, capacity planning, benchmarking and mentoring.
• I have been an implementer and also played lead roles on numerous projects, and involved in post implementation support and technical workarounds.
• Having played the roles as Trainer / Developer / Designer, I am comfortable with the programming concepts. In short, I have been an Applications Architect
• With in-depth knowledge of result-oriented troubleshooting in Oracle Database, E-Business Suite and Oracle Application Server, I have been a customer-satisfied consultant
• The long experience has given me the opportunity to work with various Operating Systems (Sun Solaris, HP-UX, AIX, Linux) on a variety of hardware providing me with the deep knowledge of them
• Being part of the team in building successful proposals for fresh installs and upgrades, defining the hardware and other system requirements based on the implementation needs and along with manpower planning for various projects both for Private and Public sector. In short, been a Solution Provider for various projects
• Consistently produced high quality work results under time and cost constraints by leading heterogeneous teams of varying sizes.
• Quickly assume a productive lead role on any project and also provided Technical / Team Leadership to various clients.
• Efficient problem solving and reasoning skills on issues with innovative technical know-how is a specialty
• Team / Project Management with Leadership Capability to manage resources and to achieve the goals on time, Conflict Resolution capability, with excellent communication, interpersonal and organizations skills makes me the candidate.
• Managed teams of size between 12 and 30 members on various projects and as Consultant Manager

TECHNICAL SKILLS:

Databases: Oracle RDBMS (5.x - 12c), Oracle 9i AS, 10g AS, Web Logic Server

Operating Systems: Oracle Applications 10.7 SC, 10.7 NCA, 11.0, 11i (all releases), R12, R12.1, R12.2, Solaris, HP-UX, AIX, Linux

Methods: SSADM, AIM, EMM

CLIENT PROJECT EXPERIENCE:

Confidential

Responsibilities:

• Analyzed and implemented PCP for e - Business Suite instances
• Also, I am the primary DBA / Apps DBA for troubleshooting performance and data issues on these databases. A few of these Databases are on RAC
• I was also responsible for migrating code to various databases and also the DBA / Apps DBA for Production migration and maintenance
• Requirement Analysis / Patch Analysis was also performed by me for CPU and various other patches as and when necessitated
• Installed and implemented Golden Gate, documented the process and monitored and maintained it
• Installed 12c DB with container and pluggable DB's and migrated the container DB to pluggable DB
• Installed Oracle Grid Control 12c, documented the agent deploy and monitored non-Production Databases
• Installed Oracle e-Business Suite R12.2 and applied the patchset to make it R12.2.2 on a single node OEL

Confidential

Responsibilities:

• Configuring Oracle Grid Control for backup and recovery
• Using Oracle and third party tools in issue resolution and reporting

Confidential

Responsibilities:

• Implemented 11g Grid Control and deployed configured agents on various VM servers
• Configured RMAN thru Grid Control for backup and recovery
• Troubleshoot and resolved many day - to-day issues and documented them for future
• Designed, implemented, documented and monitored DR with EBS on 11g DB
• Administrating Weblogic server 10.3.3 which includes installation, application deployments, Domain Creation with templates, cluster servers management, nodemanager and troubleshooting
• Integrated 3rd party applications like More4Apps with Oracle R12
• Defined and implemented SOX guidelines for various clients

Confidential

Responsibilities:

• I was called in to, Perform an upgrade from R11i to R12.1.3 along with OATM migration
• Documented the OATM migration and the upgrade process with comments on issue resolution for further upgrade iterations

Confidential

Responsibilities:

• I was involved in Upgrading the Oracle e - Business Suite from 11.5.10.2 to R12 (12.0.6) on Linux RAC with Oracle 10g DB
• Implemented Oracle Time and Labor along with Oracle Federal Financials
• Test 11g R1 RAC install for learning and purpose of their DBA s on a Linux server
• Provided recommendations on Single Sign-On and Identity Management processes and implemented it
• Installing E-Business suite 12.1.3 with Database 11.2.0.3 and latest Technology stack (10.1.2.3 and 10.1.3.5) including post product specific patches planning for Gold, Development, Configuration, Conversion, system Testing, Integration Testing and UAT serving multiple projects and releases
• Having strong skills in Performance tuning and troubleshooting issues caused by very high concurrency. Tuned multiple queries and reduced the execution times from hours to minutes
• Integrated 3rd party applications like MarkView and Vertex with Oracle R12

Confidential

Responsibilities:

• Initially I went into this client to Stabilize and maintain the Oracle R12 (12.0.4) e - Business Suite application on Linux VM Ware (both the DB and the Apps Server) with the DB version being 11g R1
• Upgrade 12.0.4 to 12.1.1 with 2 other languages along with Database upgrade from 11gR1 to 11gR2 on a VM Ware guest OS.
• Implemented Oracle HRMS, SCM, EBS Tax along with Oracle Financials
• Implement 10g and 11g Grid Control for performance monitoring and tuning
• Planned, implemented and documented Data Guard for EBS 12.1.1 with 11g DB
• Tuning JVM and memory settings for garbage collection
• Responsible for managing Development and Production environments containing Databases, E Business Suite and Middleware and Architecting database solutions and delivering multiple projects with availability, scalability, adaptability and security features meeting the business needs
• Administrating Weblogic server 10.3.3 which includes installation, application deployments, Domain Creation with templates, cluster servers management, nodemanager and troubleshooting
• Integrated 3rd party applications like Hyperion and Taxware with Oracle R12
• Defined and implemented SOX guidelines for various clients

Confidential

Responsibilities:

• I was responsible for Upgrade re - implementation of Oracle Applications 11.5.9 to 12.0.6 on a single node RAC
• Architect for OBIEE and its integration with Oracle Applications
• Provided recommendations on Single Sign-On and Identity Management processes and implemented it
• Installed and supported UPK
• Integrated 3rd party applications like Hyperion, Maximo and Vertex with Oracle R12
• Assisted the client in HP Load Runner with R12

Confidential

Responsibilities:

• Upgraded the R12.0.1 to R12.0.4
• Initially the software installed on a single node server then migrated the DB to ASM and the converted it to RAC
• The E - Business Suite product families like Financials, SCM and OM was implemented
• I was also involved in performance tuning the server and the software
• Integrated 3rd party applications like Hyperion and Markview with Oracle R12

Confidential

Responsibilities:

• Implementing Oracle Financials with Financials Hub (FCH) and Enterprise Asset Management apart from maintaining the Oracle Benefits and related modules that were live
• This was three projects running concurrently and I was the point person for Technical Architecture with modernizing the backup and recovery
• Implemented Disaster Recovery and also instance / server management
• Managed 24 Oracle Applications instances, of which 7 where are on RAC on 3 node cluster
• Oracle Financial Hub (FCH) which was in a separate instance from the main production, hence we had to maintain a pair of instances and clone / patch them in tandem and keep them in sync
• Integrated a host of 3rd party applications like Hyperion and Taxware with Oracle E - Business Suite 11i (11.5.10)
• Assisted the client in HP Load Runner with 11i

Confidential

Responsibilities:

• I was responsible for the technical architecture and maintenance of the instances for Proof of concept for Oracle Federal Financials, Supply Chain and also Order Management product families
• I was leading a team of 3 Apps DBA s. Provided recommendations on Single Sign - On and Identity Management processes and implemented it
• Laid down the strategy for backup of Oracle databases and maintained the instances
• My job role also involved applying HP - UX, HP Service Guard patches
• After the RAC installation, I performed various testing scenarios involving hardware and software components
• Implemented 10g Streams and monitored it for the electoral database to maintain the history of changes for electorates

Confidential

Responsibilities:

• I was assisting the DBA team to build and implement best practices for their Global single Instance (GSI) implementation of Oracle Financials and Lease Management
• Co - ordinated the DBA team for assisting a team of offshore developers in India, near shore developers in Memphis and users in London, UK and Nashville, US
• The Apps DBA team was involved in day-to-day upkeep of the e-Business Suite applications and also involved in patching, cloning and tuning these applications
• Provided recommendations on Single Sign-On and Identity Management processes and implemented it

Confidential

Responsibilities:

• I was responsible for installing Linux Operating System on 3 Dell machines, prepare them for network connectivity, enable security and install Oracle Federal Financials
• Migrate the similar database from Sun Solaris Operating system into these Linux servers
• Responsible for cloning, patching and performance tuning this instance apart from migrating tables from the data warehouse database into the 11i e - Business suite
• At this IBM out sourced assignment, I was the DBA team lead for 5 consultants, performing
• Assisted ASP DBA team with maintenance, upgrades, patching, cloning and backup / recovery of Oracle Federal Financials
• Responsible for capacity planning and for setting up and enforcing performance budgets through a combination of developer, code reviews, tuning and architectural recommendations
• Architected solution for data warehouse using Streams technology and for Disaster Recovery using Data Guard and Veritas Volume Replicator
• Worked on migrating a single instance 1.2TB database from Sun Solaris to a two node Real Application Cluster instance with OATM on IBM AIX. PCP was configured for handling concurrent processing
• Designed and monitored stress tests to identify and resolve performance bottlenecks
• Assisted in the migration effort from one ASP to another. This involved O/S, storage and data center migration
• Assisted prime vendor on implementing efficient application setups for users, responsibilities and job scheduling and to evaluate various third party tools to assist application and database administration
• Led effort to Benchmark system at full load at the IBM - Oracle competency center
• Set and implemented audit guidelines and monitored and reported the guideline violations if any to the upper management

Confidential

DBA Team Lead

Responsibilities:

• Upgrading Oracle Applications from 11.5.3 to 11.5.6 and then to 11.5.8 (Financials, HRMS, Order Management and CRM)
• End - to-End Performance tuning and load testing using Mercury s Load Runner
• RMAN strategy, planning and implementation
• Import and export of Oracle Applications for uniform segment size and automatic segment space management
• Migrating middle tier from HP-UX to Linux (30 machines)
• Implement SSL for Apache based connectivity
• Configuring the hardware load balancer (Net Director)
• Defined and implemented SOX guidelines for various clients
• I was involved in technical audit of the Oracle Applications along with various components encompassing it
• Indentify and suggest remedies for Hardware and Operating system bottlenecks
• Indentify and suggest remedies for network bottlenecks
• Performed database and e - business suite tuning
• Suggesting steps and also laying down a template for future performance tuning and monitoring of the various subsystems