Oracle Software Engineer

Manjunath Nair

Senior Oracle DBA- ERP Apps

610-***-****

abifir@r.postjobfree.com

Manjunath has over thirteen years of experience in system analysis and

design, development, and implementation of Oracle ERP Application projects.

His areas of expertise include application installation, implementation,

upgrade, maintenance, system management, data analysis and support.

Professional Experience

Oracle E-Business Responsibilities include

Lead Architect Oracle ERP Application Installation and configuration

(Lead DBA) at Coordinate and perform Disaster recovery (both database

Unisys and Application) drill activities for Oracle ERP

Corporation, Blue Applications

Bell, PA. Oracle ERP patching and upgrades

Service Industry Coordinate and implement data replication systems (EMC

Jan 2003 - Present SRDF/Mirrorview and Oracle Data Guard) for various

application systems

Coordinate and implement EMC Storage activities for ERP

databases

Perform architecture design and capacity planning

activities.

Coordinate the custom code activities

Database tuning, data reorganization and SQL tuning

efforts

Patching and patch analysis activities.

Perform 2-tier and 3-tier clones of Oracle ERP

Applications instances.

Install and configure system alerts for Oracle

Application and database monitoring using VB scripts,

shell scripts and PL/SQL scripts.

Install and configure Data Archive solutions for Oracle

ERP databases using Informatica Archive solutions.

Database backup and restore activities for ERP databases.

Monitoring and management of Service Level Agreement

(SLA) for offshore support team

Coordinate various IT auditing activities for Oracle

Applications and databases.

Prior experience supporting Oracle 9i databases

Patching, cloning, and upgrading of Oracle Applications

Release 11i

Server and Operating System knowledge

Oracle database development using PL/SQL

Currently leading the Architecture DBA team for the

Oracle ERP R12/11g upgrade project.

Key contributions

Implemented and upgraded worldwide Oracle ERP PSA

solution for Unisys Corp

Upgraded Oracle DB from 9.2.0.6 to 10.2.0.3

Upgraded Oracle Apps from 11.5.8 to 11.5.10

Upgraded Oracle Apps from 11.5.4 to 11.5.8

Upgraded Oracle DB from 9.2.0.6 to 11.1.0.7

Configured Oracle Dataguard for PeopleSoft Database

Developed custom application using PL/SQL to support the

system monitoring activities

Oracle ERP Apps Responsibilities include

11i Production Customized the Oracle Applications using custom

Support and procedures, packages and triggers at Unisys.

Process Control at Customized the Oracle ERP application reports and forms

Unisys for various business requirements.

Corporation, Data analysis and mapping

Blue Bell, PA. Designed and developed custom data extract solutions

Service Industry (custom concurrent programs) using SQL/UNIX shell

May 1999 - Dec scripts.

2002 Coordinated the deployment of various application access

and control solutions.

Oracle database development using PL/SQL.

Designed and implemented custom patch analysis solutions

for Oracle ERP patches.

Designed and developed code/patch release history reports

using ASP.

Coordinated and managed the release schedules and system

outages for various IT applications.

IKON office On-site Project Lead/System Analyst from Infosys

solutions, Technologies Ltd, India Bangalore

Malvern, PA

Responsibilities include

Service Industry Managed the offshore development activities and

Apr 1997 - May coordinated the on-site product delivery.

1999 Designed and developed Real Estate Management System on

Oracle 7.0 using Developer 2000, Designer/ 2000 and

PL/SQL.

Designed and developed various applications using Forms

4.5 and Reports 2.5.

Written database packages, procedures, functions and

triggers using PL/SQL

Lead development tasks for FA and AR modules

Data analysis and mapping

Southern Senior Software Engineer at Infosys Technologies Ltd,

California Edison India Bangalore.

Corp

Energy Industry Responsibilities include

Sep 1996 - Apr Designed & developed Billing application system for

1997 Southern California Edison (It involved front-end

development using Power Builder 5.0 and back-end

development using DB2.

Prepared detailed design specification of front - end,

developed test plans

Involved in coding and testing of the billing application

system for SCE

Banking Analyst/ Implementer for Tata Consultancy Service's

Reconciliation banking solution, ISBS (Integrated Standard Banking

solutions, India Systems)

Banking Industry

Feb 1995 - Aug Responsibilities include

1996 Customization and implementation of banking system

software on Oracle 7.0 database using oracle tools like

Pro*C and Form 3.0.

Involved in coding and testing of customized oracle

reports and user screens (using Oracle forms) in various

banks.

Involved in the DBA activities like database maintenance;

database recovery; and data loading using SQL*Loader.

Skills Summary

Software Tools Developer 6i SQL*Navigator and Toad

AD utilities, Dataguard Oracle Statspack report

SQL * Loader Oracle RMAN

SQL* Plus HP Load runner and HP Win

Oracle 9iAS and 10g AS runner

Oracle Enterprise Manager Discoverer

(OEM 2.2) Oracle Data guard.

Databases Oracle 11g Oracle 8i

Oracle 10g Oracle 7

Oracle 9i DB2

Applications Oracle ERP 12i Informatica Archive Solutions

Oracle ERP 11.5.10

Oracle ERP 11.5.8

Programming PL/SQL UNIX, SED, AWK

Languages C and Pro*C HTML

Java Oracle Forms

OA Framework Oracle Reports

Perl Visual Basic 6

Hardware & IBM/AIX Unisys UnixWare

Operating Windows 2000 Advance Server EMC SYMMETRIX

Systems HP-UX 11.11 EMC CLARIION

Engagement Architectural design and Business & Technical Process

Experience implementations Reengineering

Application implementation, End User Training

upgrade and Support Data mapping

Database implementation, Configuration

upgrade and Support Data analysis and conversion

Applications Development SDLC

Other Accomplishments

Education Master of Engineering in Software Engineering, Penn State

University, PA

Bachelor of Technology in Electronics & Communication

Engineering, India.

Certificate/Trai In-house training in Oracle ERP 11.5.8 and 11.5.10

ning application, Oracle Databases 8i and 9i at Unisys Corp Ltd.

Training in Object Oriented methodologies and concepts at

Infosys Tech Ltd.

Java programming

In-house training in Mainframes at Infosys Technologies Ltd

(Training in JCL, MVS, CICS & DB2).

Note

. References are available upon request.

. United States Citizen. Do not need Work Visa Processing.

Contact this candidate