SUMMARY:

• Over 22 year experience
• Implemented, integrated and Supported OID/SSO/Oracle Access manager, Oracle Portal with
• Oracle r12.x and Oracle 11i in production and test environment
• Architected, Designed software and hardware requirements for running the Oracle application,
• Oracle Database, Oracle Middleware in High Availability (RAC/CRS) in production and test
• Highly Experienced in implementing and technical support to Oracle E - Business suite application (R12 12.x, 11.5.x), Oracle Database r7.x to r12.c,Oracle WebLogic, Oracle Applications Server (9i/10g/11g) in Sun Solaris, Red Hat Linux, AIX and Windows environment along with all maintenance tool for oracle application, oracle database, oracle web logic, oracle application server.
• Implemented external I-supplier along with R12.2.x.
• Experience with oracle oracle Exadata
• Highly experience in scripting doing automation for cloning /backup/recover/disaster recovery.
• Implemented, upgraded and patched sunflower /Prism /Markview.
• Implemented Oracle data gurad and automated the script for snapshot standby .
• Implemented, upgraded and Supported Oracle application R12.x and 11.5.10.x
• Applied latest security patches in oracle application and oracle database .
• Implemented, upgraded and supported Oracle Database r11g and r10g, RAC Database, CRS
• Performance tuned and monitored of the Oracle applications, Oracle Database, Oracle Middleware.
• Implemented, Upgraded and Supported Sunflower, Prism, SVN and PPM.
• Implementation, upgrade and maintenance experience with Oracle E-Business Suite R12.2.*, R12.1.*, R12.0.* and 11i
• Experienced in Planning, Installation, Physical and Logical Database Design, Backup and Recovery, Cloning or Refreshing Database and Oracle Applications.
• Expert in upgrading Oracle Applications to 11.5.10.2 to 12.2.3
• Highly experienced Performed database installation and upgrades.
• Highly Experience implementing Reverse proxy and load balancer along with siteminder and F5 technology.
• Expert in upgrading Oracle Applications Technology stack (java, JDK, J initiator etc).
• Expert in Cloning using ADCLONE, Rapid clone and ADCONFIG.
• Expertise in implementing Shared APPL TOP and PCP.
• Expertise in troubleshooting Workflow and Notification Issues.
• Expertise in using ORADEBUG, TKPROF and SQLT for fixing performance tuning issues.
• Proficient in analyzing and optimizing queries, performance tuning and providing reports using STATSPACK, TKPROF and Explain Plan.
• Experience in installation and configuration of Oracle SOA suite 10g/11g
• Proficient in handling Oracle Applications Manager which provides a powerful set of features to manage Oracle Workflow, Patching, Configuration Utilities and Concurrent Processing
• Great experience in handling and administering Oracle 11i Instances using AD utilities such as adadmin, adctrl, admerge, adsplice, adpatch etc.
• Development of automated RMAN scripts for both backups and cloning of Oracle Databases
• Experience in general troubleshooting, development of scripts, documentation, issue resolution, and TAR support.
• Well versed in implementing System Management and Monitoring procedures.
• Strengths include skills in Shell Programming, SQL and PL/SQL.
• Well versed with User Management, Performance Tuning, and Concurrent Processing Settings.
• Experience in Security Management and Database Auditing.
• Tuning the databases for optimal performance and monitoring CPU performance.
• Expertise in RMAN for recovery and cloning.
• Basic Administration of UNIX systems (Solaris, LINUX, HP-UNIX TRU64, AIX).
• Troubleshooting Login, Self Service Application, Initiator and Network related issues.
• Expertise in Cloning of databases from RAC to RAC and RAC to non-RAC.
• Strong Analytical skills and ability to interact with end-users, managers, and technical personnel.
• Quick learner of the new technology and very good team player with very good communication skill
• Ability to work effectively with all levels of personal & other groups and provide 24/7 production support.

TENHNICAL SKILLS:

ERP: Oracle E Business Suite Release R12.x, R11.5.10.x, R11.x, R10.7( Installation, Implementation, Administration, Upgrading and Troubleshooting )

Oracle Middleware: Oracle WebLogic, Oracle Access manager, Oracle OID, Oracle SSO, Oracle Web gate, Oracle access gate, Oracle Fusion application Server

Database: Oracle 12c,11g, 10G,9i, 8i,7.x, 6.x, RAC, CRS( Installation, Implementation, Administration, Upgrading and Troubleshooting)

Languages: SQL, PL/SQL,C, COBOL,HTML and Shell Scripts

Development Tools: Developer 2000/6i/10g, Forms 4.5/6i/10g, Reports 2.5/6i/10g, Toad, SQL Plus, SQL Loader, Informatica Power Centre 8.6.1 and XML Publisher

Tools: Oracle Designer, ERWin Data Modeler, Microsoft Visio, Visual Source Safe, Clear Case, Clear Quest, SVN and Kintana, PPM

Management Tools: MS Project, MS Office, SharePoint

Other Oracle Products: Oracle GRC, Oracle OACG, Oracle CCG, Oracle OBIEE, Oracle SOA,Oracle Golden gate

Other Software: Sunflower, Prism, Mark view, Apps Worx, Site Minder,F5

Operating Systems: Windows 2000/XP/NT/Vista/98/95, MS DOS, LINUX and UNIX

Storage/HA: EMC, RAID, VERITAS, BCV, RAC,CRS,ASM

PROFESSIONAL EXPERIENCE:

Confidential, VA

Senior Oracle Consultant

Responsibilities:

• Upgraded E-business suite applications from version from 11. .1.3 architecture with database version 10g to 11gR2.0.3 .The application is integrated with Oracle Access manager /Oracle Access gate/ Oracle web gate with Reverse proxy.
• Implemented Oracle access manager(OAM) and Oracle internet directory with oracle e-business R12.2.3.
• Upgraded E-business suite applications from version from 11. .2.3 architecture with database version 10g to 11gR2.0.3 .The application is integrated with Oracle Access manager /Oracle Access gate/ Oracle web gate with Reverse proxy
• Implemented Disaster Recovery site for the primary production database using Oracle data guard technology
• Implemented, Upgraded and Supported RAC database in 2 nodes using Oracle RAC and Oracle CRS Technology.
• Performed Capacity planning for Oracle Database and Oracle application for Five thousand users.
• Implemented Oracle I -supplier for the external users using DMZ.
• Performed system architect for running the Oracle application and Oracle database for a high availability and highly secured mission critical applications.
• Provided production support for all Oracle application databases in 24x7x365 and perform application DBA and Oracle DBA activities through the entire development cycle from development to Test then to Production.
• Implemented, Upgraded and Supported Prism(Contract Management) And sunflower (Assets Management ), SVN, PPM with Oracle Application .
• Implemented and supported OID/SSO integrating with Site Minder and Oracle Application.
• Implemented and supported load balancing of application server with reverse proxy and F5 with 2 node applications Server.
• Provided architect/implementation/support/tuning/backup/recovery/cloning of R12 application and R10.2.04 database
• Implemented /Up gradated /Supported of GRC (Governance & Risk Compliance Manager), Oracle CCG(Oracle Configuration Controls Governor), OACG, Oracle SOA, Oracle OBIEE .
• Provided application cloning, patching and data refreshes for development, test and production instances.
• Interact with oracle support in solving issue’s on Oracle products.
• Assist developers in compilation and execution of PL/SQL packages and procedures together with migration of custom code
• Perform database tuning and standard maintenance procedures to ensure maximum database performance in various production environments
• Implemented backup and recovery, Disaster recovery solutions for production environments using RMAN and Standby database.
• Performed patching and upgrades of E-business Suite Applications and databases
• Evaluated third party software in conjunction with E-business Suite applications, Oracle database.
• Provided daily support to developers and end users for various R12 and 11i application.
• Analysis on for migration the Existing system to Oracle Exadata with 12C

Environment: Sun Solaris 9.0/10.0, Oracle database 12c,10g and 11g, Oracle Application 12.2.3 and 11.5.10.2,Oracle Application Server 10Gr2,11G,Oracle Web Logic, Oracle Web gate, Oracle Access manager 11.1.2.2,Oracle internet directory 11.1.1.7.0, Oracle access gate, Sunflower, Prism, GRC,CCG.OACG, remedy, Linux,Windows, Oracle Web Logic, Oracle Middleware, Oracle Exadata .

Confidential

Senior Oracle Consultant

Responsibilities:

• Architect/Implementation/Support/Tuning/Backup/Recovery/Cloning of Federal Financial for a government client in a full development cycle form testing till production
• Implemented Load Balancing and OID/SSO with the federal Financial with Multi - node architecture and PCP with SOA and OBIEE
• Migrated Oracle Application 11.5.10.2 from Sun Solaris to Linux
• Performed all Application DBA and Oracle DBA activities during the entire development cycle from test to production.
• Implemented sunflower, prism

Environment: Red hat Linux, Oracle application 12.2.1, Oracle OBIEE, Oracle SOA.,sunflower, prism

Confidential

Senior Oracle Consultant

Responsibilities:

• Architect/Implementation/Support/Tuning/Backup/Recovery/Cloning of Federal Financial for a government client in a full development cycle form testing till production
• Implemented Load Balancing and OID/SSO with the federal Financial with Multi - node architecture and PCP
• Migrated Oracle Application 11.5.10.2 from Sun Solaris to Linux
• Performed all Application DBA and Oracle DBA activities during the entire development cycle from test to production.
• Implemented, Upgraded and Supported Oracle Database (9i, 10G), Oracle Application Server (9ias & 10G) and Oracle Application (11i).
• Executed Test plan for Upgrading R11.5.10.2 to R12.0 and upgraded R12.0 from R11.5.10.2 for a test instance for demonstration only.
• Applied Quarterly Patches keeping the Application and Database with the latest Patch set level
• Implemented Oracle Application R12.x for Demonstration to the client.
• Implemented SOX, Oracle 508 Compliance (Accessibility of Oracle application for Disabled Community) with Oracle Federal Financial.
• Performance Tuning and system Administration of Federal Financial.

Environment: Sun Solaris, Linux, Oracle Application 11.5.10.1 and 11.5.10.2, Oracle Database 9.2.0.6, Load Balancing, OID/SSO, Oracle Application R12.0, Oracle Database 10G,Jaws 8.0,Accessbridge, Oracle Forms, Oracle Reports, Shell scripts, PL*sql, Oracle Desktop ADI, Oracle Application Server 9ias & 10G, RMAN, Oracle data guard, TOAD

Confidential

Sr. Oracle Consultant

Responsibilities:

• Architect/Implementation/Support/Tuning/Backup/Recovery/Cloning of Oracle Application and Oracle Database for the client in a full development cycle form testing till production.
• Implemented the Oracle Application and Oracle database with Multi - node architecture.
• Performed all Application DBA and Oracle DBA activities during the entire development cycle from test to production.
• Involved in the development of Custom forms and Reports helping .developer to develop the custom programs or Reports.
• Performance Tuning of Oracle Application and Oracle database.
• System Administration in Oracle Application.

Environment: IBM - AIX 5.0, Oracle E-business suite 11.5.10, oracle database 9.2.0.x, Discoverer, Oracle Financial.

Confidential

Sr. Oracle Consultant

Responsibilities:

• Up gradation of oracle application 11.5.8 to 11.5.9(The modules
• Are HRMS, Finance)
• Support of oracle application 11.5.9
• Day to day Oracle Application DBA, Oracle DBA, Oracle system administration duties

Environment: Sun Solaris 8, Oracle application 11.5.8 and 11.5.9, Oracle HRMS, Oracle Financial

Client: Confidential, CA

Sr. Oracle Consultant

Responsibilities:

• Production support of Application 11.5.8 and 11.5.9 including Self Service application like i-procurement, i-expense
• Application Architect for running 11.i application and capacity planning, failover, running the application 24x7x365
• Database upgrade from 9.2.0.2 to 9.2.0.4
• Production support to oracle application 115.9, database 9.2.0.4, EMC, BCV, Cisco Load balancer.
• Cloning production instance to test in a regular basis using rapid clone
• Performance tuning and administration of Concurrent managers, Performance tuning of Oracle application 11.5.8 and 11.5.9 and Database 9.2.0.2 and 9.2.0.4
• Application of Oracle patches and extensive use of adadmin tools, Alert Management, Monitoring Concurrent processes, Resource Management, ADI related issues, Registering custom programs, implementing daily monitoring through shell scripts, Gathering Schema statistics for better performance
• Involved in customization, interface, custom programs, plsql etc.
• Up gradation of 11.5.8 to 11.5.9 and application support of 11.5.9
• Support for EMC/Time finder/snapshot jobs, BCV
• Technical support to RMAN backup
• Application and database support to all test, development, and patch instance.

Environment: Oracle 9.2.x., Oracle 11.5.8, Oracle Applications 11.5.9, Oracle Database 9.2.x, EMC, Veritas Cluster Server, Time Finder/Snapshot, Sun solrais-8, OEM, TOAD, BCV, RMAN, Veritas netbackup, mainframeIndependent Consultant

Confidential

Sr. Oracle Consultant

Responsibilities:

• Upgraded Oracle application .5.8.
• Upgraded Database from 8.1.7.2 to 8.1.7.4 on HPUX under RAC environment.
• Implementation of Oracle application R11.5.8 on HPUX
• Implementation of oracle 9i database on HPUX
• Tuning of auto upgrade and auto patch
• Implementation of oracle application in DMZ server

Environment: HP-11, Oracle 8.1.7.x. Oracle Applications 11.5.6, application R107, Oracle Database 8.i.x, EMC, RAC,Oracle application 115.8, HP -11.Oracle 9.i, OEM, Quest, Kintana, Linux, RAC, HPUX, 11.5.8

Independent Consultant

Confidential, Chicago

Sr. Oracle Consultant

Responsibilities:

• I designed the complete workflow for up gradation of R11.0.3 to 11.5.7
• Designed the procedure of Up gradation of oracle 8.0.5 to oracle 8.1.7.3
• Implemented the total up gradation process, which started from pre upgrade task in the application & database level, database-upgrade, auto upgrade, auto patch, post upgrade steps including application of certified patches till the client went live.
• Cloning of Production instance to test in regular basis
• Documentation of entire up gradation procedure
• Implemented Oracle Application R11.5.7 vision application for training.

Environment: Windows, Oracle 8.1.7.3. Oracle Applications 11.5.7, application R11.0.3, Oracle 8.0.5, Oracle 8.1.7.3, Windows - NT, Federal Financial and HRMS

Confidential, CA

Sr Oracle Consultant

Responsibilities:

• Designed the complete workflow for up gradation of R11.5.3 to 11.5.7
• Upgraded oracle 8.1.6 to oracle 8.1.7.3
• Implemented the total up gradation process, which started from pre upgrade task in the application & database level, db-upgrade, applying maintenance pack, post upgrade steps including application of certified patches.
• Cloning of Production instance to test
• Day to day to trouble shooting including solving performance issues, concurrent manager/Program issues, locking issues.
• Mission Critical technical support to all financial, Manufacturing, Supply and Distribution, CRM and self-service.
• Application Architect for running 11.i application and capacity planning, failover and running the application 24x7
• Designed the database specification, software and hardware requirements for running the oracle application 11.5.4 for database running around 1000 concurrent users for single production database running in 24x7x365. Also designed hardware /resource requirements for 1 test, 1 development, 1 patch and 1 training instances. All application was configured in a 3-node configuration.
• Designed the complete workflow for migration of R11.0.3 application on HP to 11.5.4 sun Solaris.
• Implemented the total up gradation process which started from pre- auto upgrade procedure, database upgrade, auto upgrade, post upgrade including application of certified patches, application of customization till client went live.
• Creating Test, Training, Development and Patching Environment
• Cloning of application from production to test/training/development/Patching.
• Day to day to trouble shooting including solving performance issues, concurrent manager/Program issues, locking issues.
• Making Backup/Recovery Strategy for Oracle Database/Oracle application including Disaster Recovery and testing of disaster recovery.
• Documentation all the activities including giving training to junior DBAs and knowledge transfer to others.
• Involved in migration of customization from R .5.4
• Design and Implementation of Backups and Restoration strategy.

Environment: Sun E-4500, Sun 420,Sun Solaris 8.0, HP N4000, HP-UX 11.00, Oracle8.0.x, 8i, Oracle Applications 11.5.4, Discoverer 4i, 9ias and Jinitiator 1.1.8.7, Windows NT, EDW.

Confidential, CA

Sr. Oracle Consultant

Responsibilities:

• Designed the database specification, software and hardware requirements for running the Oracle database & Oracle Applications
• I implemented Oracle Applications 107SC Upgraded 10SC to 107 NCA, 107NCA to 11.0.3 on Digital Unix.
• Provided sole Oracle Database Administration, Regular Trouble shooting of day-to-day problem in all the production & test database, Oracle Applications & systems.
• Tuning and Performance: Database tuning, performance tuning, application tuning, memory buffer management, lock management during transaction, using different Oracle tools.
• Upgraded of 107NCA application to 11.0.3 Application and 11.5.2 application

Environment: Windows NT-4.0, Windows 95, Digital UNIX 4.x, Sun Solaris 2.x, Oracle 7.x, Oracle 8.x, Oracle 8.i, Oracle OEM 1.x & 2.4, Oracle Web Server 3.x, Oracle Applications 107SC, 107NCA, 1103, 11.5.1, 11.5.2, 11.5.3, Oracle ADI 3.x, Oracle Financial Server 6.x, SQL*Net 2.x, Net 8, SQL*Plus 3.3, Oracle Financial Analyzer, GL Desktop Integrator, SUN E-5500