Venkata Subbaraju Nadimpalli

Client: GE AEROSPACE

• Upgraded databases from 12c to 19c with multitenant architecture
• Upgraded EBS applications from 12.1.3 to 12.2.9
• Upgraded EBS applications from 12.2.6 to 12.2.11
• Worked in MAA (Maximum Availability Architecture) enabled Oracle EBS environments.
• Cloned EBS 12.2 with 19c database.
• Automated EBS Cloning process using shell scripting.
• Analyzing and Applying CPU-PSU patches quarterly on both EBS and DB.
• Performed partial and full cloning/refresh of test instances from production.
• Completely redefined Backup and recovery strategy in OCI Object Storage.
• Setup all monitoring and housekeeping jobs.
• Automated Database, Applications and Oracle homes using shell scripting as per client retention policies.

Client: GE Corporate and MTN Group (Oracle)

• Daily Health check of the instances managed by us.
• Maintenance and support of Oracle Applications R12.1.3/R12.2.6/R12.2.8
  Patching of applications using adpatch and adop (adop cycle and downtime) on regular basis on application team’s requests.
• Monthly and weekly refresh of the Stage and Dev instances from Production in R12.1 and R12.2 environments.
• Expertise in administering Oracle Applications with ad utilities like adpatch, adop, adadmin, adconfig,adctrl, adrelink etc.
• Analysis and application of quarterly patches and patching of Database, grid, EBS and weblogic CPUs.
• Managing Managed servers, starting/stopping Managed servers including Content and portal.
• Performance Tuning - Troubleshooting long running requests in production databases.
• Generating AWR reports, execution plan of running sqls, finding best execution plan and sql_profiles and attaching it to current program and sqls.
• Working on Users issue based on the tickets raised by them.
• Schema, table level export using expdp/impdp.
• FNDCPASS utility to change Passwords including APPS password in R122.
• Experience on ticketing tools like Service Now .Raising Change requests, tickets , service requests and also dealing with the Problem ticket providing the RCA of the relevant issues.
• Experience on maintaining applications when downtime(Maintenance) required.
• Also, I am an active Team member involved in all the team activities, working at client site and dealing with client issues.
• Raising SRs in support Metalink and following up on the same to resolve the issues.
  

Client: Flowserve Corporation [OneNecK IT Solutions]

• Upgraded Oracle E-Business suite from 11.5.10.2 to 12.1.3+RPC3.
• Upgraded Oracle Database from 11.2.0.3 to 12.1.0.2. Performed cross-platform migration of database from Solaris SPARC to Oracle Linux. Upgraded JRE plugin from 1.6 to 1.7. Upgraded IAS Oracle home from 10.1.3.4 to 10.1.3.5.
• Upgraded java in Oracle E-Business Suite from JDK 1.6 to 1.7.
• Advanced Techniques in performing export/import of 4TB of EBS database within 10 hours.
• Implemented Oracle RAC, PCP and DMZ (iStore, iSupplier).
• Configuring and tuning the OC4J components in Oracle e-business suite 12.1.3.
• Installing and configuring 12c grid infrastructure.
• Tracing out and identifying issues at database, apache, forms and concurrent program levels.
• Performed long running sql tuning with OEM and AWR by applying sql profiles, gathering stats and creating/rebuilding indexes.
• Refreshing staging database with RMAN and applications using adpreclone and adcfgclone utilities.
• Performed Oracle Maintenance as per the schedules for regular and patching activities.
• Configuring FCF, SCAN listener and database services for session high availability and performance in Oracle E-Business suite.
• Performed table defragmentation with data pump and shrink commands.
• Identifying and Resolving Golden Gate data sync issues.
• Setup, configure and administrating local printing software- AventX for Oracle EBS