Oracle Manager

Objective

Executive

Profile

Experience

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.

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.

NavASoft as Independent Contractor since

November '08

> Implement Oracle e-Business Suite R12 as single node, on VM Ware on Linux

(Virtual Machines for DB and Apps Tier) and as RAC instances on VM Ware

for high availability architecture and upgrade / migrate, patching,

cloning, troubleshooting, performance tuning, maintenance and handling

custom developers / conversions / end-users requirements

> Upgraded R12 (12.0.4) with 32 bit 11gR1 DB to 64 bit 11gR2 and R12.1.1

for two languages (NLS) along with translation patches and performance

tuned the system end-to-end on VSphere (latest version of VM Ware) on

Oracle Enterprise Linux 5.4

> Installed Oracle Grid Control (both 10g and 11g) and deployed agents

(both 32 bit and 64 bit for various OS platforms) with Oracle Application

Management Pack 2.2 / 3.0 / 3.1 / 4.0

> Implemented Oracle Discoverer 10g and 11g with Oracle E-Business Suite

and setup users

> Providing guidance and mentoring client technical staff in installing,

troubleshooting and maintenance of User Productivity Kit and other Oracle

products

> Member of the OBIEE architecture and implementation team in providing

technical guidance and design of hardware / software layout based on

usage, install, performance and for easy maintenance

> Patch advisory and analysis, troubleshoot user and product issues

> Install Oracle development tools on Citrix for use by developers and end-

users

> Implement customizations and extensions, conversion scripts and monitor

for performance tuning and enhancement and issues resolution and support

to the end-users on a GSI environment

> Mentoring friends and colleagues in Oracle Database and Oracle

Applications in installing / implementing / troubleshooting and

maintenance

> Installed and upgraded Vertex with Oracle Applications to work with

Oracle HRMS for payroll processing

Technical

Leadership

&

Applications

DBA

Applications

Architect

Applications

DBA

Deloitte Consulting February '08

to August '08

> Designed and implemented high availability solutions for a diverse group

of clients running Oracle9i, Oracle10g, using Data Guard, RMAN, Oracle

Real Application Clusters (RAC)

> Technical lead for a large implementation project

> Been hands-on in identifying issues and long-term resolutions to

technical issues

> Provided DBA and programming support for all internal and client based

Oracle implementations

> Provided mentoring and knowledge transfer to DBAs and developers on

Oracle architecture, Oracle10g new features, tuning methodologies, RMAN

backups

IBM Business Consulting Services May '05

to February '08

> Managed Oracle Financials implementation for many clients with

contractors and client staff

> Reviewed and assessed current Oracle Applications DBA Support

environment, related processes and procedures, plans for future, and

provide recommendations to improve the DBA Support environment

> Reviewed and commented on existing Oracle Applications DBA Support

documentation including hardware, load balancers, firewalls, disks,

operating systems, Applications versions, Real Applications Clusters,

Production, Quality Assurance / Test, Disaster Recovery, Instance

strategy, Cloning and Patching processes

> Provided recommendations around reporting, performance management,

applications management, and Disaster Recovery

> Provided recommendations around Single Sign On and Identity Management

processes

> Identify potential interim and long-term fixes, and work with the Sherwin-

Williams team to identify the most appropriate implementation approach

> Documented further options to enhance the Oracle Applications DBA Support

environment

> Created and refined "Strategic Assessment List" of identified Oracle

Applications DBA Support environment issues and potential solutions

focused on long-term solution

> Developed long-term support and implementation strategy

> Prioritized long-term solutions based upon technical and business

criteria

> Interfaced with other teams in developing solutions to issues and also

plan activities foreseeing them occurring at a future date of the

implementation

Oracle Consulting Services October

'97 to May '05

> Define Architecture needs of various clients for implementing Oracle e-

Business Suite and other custom software.

> Technical Architecture design for GSI and SSO

> Designing Applications hardware for implementing in the DMZ / reverse

proxy

> Mentoring the Oracle DBA's and Oracle Applications DBA's

> Performance tuning and audit of Oracle Applications on the whole and the

individual product families, products, and also analyzing and

implementing End-to-End Performance Tuning including Apache and forms

server

> Defining standards and procedures for developing, testing and performance

tuning customizations / extensions before implementing

> Always adhered to the Best Practices for the product, so that the

implementation and maintenance is made easier in the long run

. Been a Technical Architect, Systems Architect and also Performance

Architect on various assignments

> Infrastructure and DBA / Apps DBA Team Lead.

> Installing R11i (all versions) and R12 and later upgrades (single node

and multi node configurations) RAC, of all product families and modules

(Financials, Distribution / Supply Chain, HRMS, CRM, Manufacturing) on

Unix / Linux Operating System platforms for which Oracle Applications was

released

. Upgraded Oracle Applications 10.7 and 11.0.x to 11i and from 11i to R12

. Migrated Oracle Applications to New Oracle Applications Table Model

(OATM)

. Integrated Oracle 10g AS Portal and SSO with Oracle e-Business Suite

(11.5.10.2)

. Configuring Oracle Applications for Load Balancing and also true multi-

node and pseudo multi-node architecture using hardware Load balancers,

DMZ's, hosts file and DNS

. Implemented Oracle Applications with SSL for web and forms servers inside

/ outside the firewall

. Configuring Workflow using Oracle Applications Manager

. Migrated Oracle Applications Middle tier from UNIX or Windows to Linux

. Migrated Oracle Applications and databases across data centers and OS

platforms

. Moved Oracle Applications between various UNIX platforms

. Implemented Oracle Applications 11i and R12 on RAC and configuring PCP

and custom Concurrent queues

. Migrated the databases between managed file system and ASM

. Performed benchmarking of Oracle Applications for a very large volume of

data processing with time constraint

. Implemented and performed End-to-End testing of various scenarios for

Oracle Applications 11i and R12 on RAC with ASM, Operational Readiness

and Disaster Recovery using Data Guard

. Cloning from single node to multi-node or vice versa, using Oracle

provided methodology or other proven successful methods

Trouble-

Shooting

and

Performance

Tuning

Database

Administration

Education

Trainings

Skills

Clientele &

Reference

> Installed and upgraded Vertex / Taxware for Oracle HRMS product family.

> Tuning and distribution of I/O, tuning kernel parameters, tuning

application queries for efficiency

> Applications Tuning, Migration, Troubleshooting & End User Support

> Monitoring and configuring parameters pertaining to SGA, hit rates, latch

contention, row chaining, fragmentation and db block buffers to optimize

performance

> Analyzing current performance and implementing recommendations on

expensive SQL operations

> Detecting and resolving application bottlenecks

> Reviewing application design to implement database features for better

performance

> Has tuned very large databases for insert and updates for optimal

performance and to the user satisfaction

> Oracle Enterprise Manager was used to monitor Oracle Database and Oracle

Applications, performed application, SQL, and database instance tuning

using a wide range of technologies including ADDM, AWR, extended SQL

trace (event 10046 trace files), OEM Performance Manager, and custom

scripts

> Used other 3rd party tools like Precise, Quest products apart from self-

developed SQL scripts to monitor Oracle Applications performance

> Installing and tuning of 10g ASM, CRS and RAC with data guard.

Integrating the RAC instances with 10g enterprise grid control

> Installing and tuning various versions of Oracle database including 9i

RAC (two-node cluster) and 10g RAC

> Migrating Oracle 32 bit database to 64 bit

> Implemented Oracle Identity Management with / without SSO on various

platforms for various clients

> Designing I/O architecture based on hardware availability

> Monitoring space usage, implementing sizing and growth strategies

> Developing database-partitioning strategies

> Designing and implementing backup strategies involving hot and cold

backups. Used RMAN for backups and also built backup strategy for many

clients. Also implemented Streams for with Voters Registrations custom

application

> Testing failures and recoveries including complete and partial, on-line

and off-line

> Performance Tuning, Day-to-Day Maintenance & Troubleshooting

> Defining procedures for Change Management

V Master of Science (M.Sc) May '87

Loyola Autonomous College, University of Chennai, India

Major: Statistics

V Diploma in Computer and Applications Software August

'90

University of Karaikudi, India

At IBM Corporation

. Architectural Thinking for Experienced Professionals

. Architectural Thinking workshop

. Six Sigma - Green Belt with nearly 100 hours of training covering every

topic

. IBM Global Services Method for Technology Integration Professionals

. Project Management Orientation (PMTO)

. Performance Engineering: Delivering Successful Projects

. The IT Architect: An Introduction

. Problem Solving and Decision Making for IT Professionals

At Oracle Corporation

. Solution Architect Master

. AIM Advantage 3.0 for Practitioners

At National Informatics Center

. Structured Systems Analysis and Design Methodology

. Client / Server Application Development

. Introduction to Data Communications - Digital Equipment's India Ltd.,

. Network Standards and Protocols - Digital Equipment's India Ltd.,

Databases: Application Servers:

Oracle RDBMS (5.x - 11g) Oracle 9iAS, 10g AS, Web Logic

Server

e-Business Suite Operating Systems:

Oracle Applications 10.7 SC, 10.7 NCA, Sun Solaris, HP-

Unix, AIX, Linux

11.0, 11i, R12, R12.1

Languages: Methods:

PL/SQL, SQL Loader, Unix Shells SSADM, AIM, EMM

V Available upon request.

Contact this candidate