SUMMARY

• EBS R12 Installation - Multi node installation with shared APPL TOP.
• EBS upgrade from 12.1.1 to 12.1.3 version.
• Supply Chain Planning (VCP 12.1.1) Installation.
• Supply Chain Planning upgrade from 12.1.1 to 12.1.3 and 12.1.3.8 version.
• Database upgrade from 11gR1 (11.1.0.7) to 11gR2 (11.2.0.4) version.
• Oracle Demantra Upgrade to 7.3.1 and 7.3.1.4 version.
• Oracle Demantra Upgrade to 12.2.4.1 from 7.3.1.4 Version.
• Oracle Demantra Web deployment on Linux (Weblogic Server)
• Demantra Analytical Engine Configuration on Linux (Weblogic Server).

TECHNICAL SKILLS

Database: Oracle 11g, 11i/R12, Oracle 9i, 10g RAC Database and 11gR2

Operating System: Solaris 5.10, Windows NT, Windows 2000 & 2012, Oracle Enterprise Linux, Weblogic Server.

Languages: PL/SQL, Shell Script

ERP: Oracle Applications Manager, Application Administrator Oracle Demantra version 7.3.0, 7.3. 1, 7.3.1.4 & 12.2.4.1 Oracle E-Business Suite Release 12.1.3.8 and 12.2.4.1 PL/SQL Developer Support Central (GE Tool), Kintana

PROFESSIONAL EXPERIENCE

Confidential, Wisconsin

Oracle Apps Admin and Demantra Admin

Responsibilities:

• Regular project status review meetings with client and team members.
• Participated in teh hardware estimation for teh VCP and Demantra.
• Worked as VCP and Demantra Architect to design and implement VCP and Demantra.
• EBS upgrade from 12.1.3 to 12.2.4
• Involved in Online patching cycle using ADOP.
• Clone 12.2.4. EBS system on Linux.
• Co-ordinate with different vendors to keep smooth continuation of project.
• Oracle Demantra Upgrade to 12.2.4.1 version from 7.3.1.4 on Windows server 2012
• Weblogic 11g Installation
• Demantra Web deployment on Linux (Weblogic Server)
• Distributed Demantra Analytical Engine Deployment on Linux (Weblogic Server).
• Resolve day-to-day issues related to EBS.
• Resolve day-today issues related to Demantra Web application and Demantra Analytical Engines.
• Proactive monitoring of concurrent managers and concurrent requests.
• Resolve day-to-day issues related to Oracle Application database, database administration and maintenance.
• CCM Profiling for RAC instances.
• Patch technical analysis.
• Co-ordinate Patch deployments.
• Coordinate, schedule, and communicate outages and maintenance
• Coordinate, schedule and communicate refreshes
• Access and database password management.

Confidential

Oracle Apps Admin and Demantra Admin

Responsibilities:

• Regular project status review meetings with client and team members.
• Co-ordinate with different vendors to keep smooth continuation of project.
• Oracle Demantra Upgrade to 7.3.1.4 version from 7.3.1 on Windows server 2000
• Demantra Web deployment on Solaris (Oracle Application Server)
• Distributed Demantra Analytical Engine Deployment on Linux (Weblogic Server).
• Resolve day-to-day issues related to VCP.
• Resolve day-today issues related to Demantra Web application and Demantra Analytical Engines.
• Proactive monitoring of concurrent managers and concurrent requests.
• Resolve day-to-day issues related to Oracle Application database, database administration and maintenance.
• CCM Profiling for RAC instances.
• Patch technical analysis.
• Co-ordinate Patch deployments.
• Coordinate, schedule, and communicate outages and maintenance.
• Coordinate, schedule and communicate refreshes
• Access and database password management.

Confidential

Oracle Apps DBA

Responsibilities:

• Managing oracle instance and databases.
• Managing oracle database server
• Managing oracle application server
• Maintaining control files and redo log files.
• Managing Tablespaces, data files and undo data.
• Managing Tables, indexes and maintaining data integrity.
• Managing users, privileges and roles.
• Configuring teh database in archiving mode.
• Managing automatic archiving and manual archiving.
• User managed online and offline backups and recovery.
• Daily backup using RMAN and recovery catalog for local and remote databases.
• Daily backup using RMAN Incremental backup and recovery catalog for local and remote database, control file, spfile and archive log.
• Unix CRON job for daily backup operation and cleaning up of logs.
• Written automated scripts for backups.
• Written shell script and awk script to automate teh complete procedure.
• Monitoring and detecting lock detection.
• Maintaining of Alert Log file.
• Resolving performance problems
• Implementation of ltom for database performance monitoring.
• Generating XPLAIN and XTRACT of SQL query using sqlt.
• Monitoring and tuning teh high CPU usage.
• Tuning with measurable performance enhancement with AWR, ADDM, TKPROF files.
• Defragmentation of tables in production and clone.
• Creating Database link.
• Hard disk addition in production.
• Monitoring and managing Oracle collaboration suit (OCS)
• Creating new user in OCS
• Solving problems related to OCS mail
• Maintaining OCS database server and application server.
• Tunings OCS related issues.
• Performing patch analysis for database and application patches
• Performing cloning from production database to clone, development and training database.
• Monitoring teh concurrent process so dat performance of teh system is maintained.
• Monitoring and Maintaining Concurrent Manager.
• Write shell script to monitor concurrent requests and concurrent managers.
• Creating new users and assigned responsibilities using E-Business Suit.
• Deployment of .rdf, .fmb, .ldt and .oaf files on productions
• Analysis of trace and log files to determine and resolve potential problem areas.