SUMMARY:

• Confidential has been working as Confidential Applications/Core DBA for 20 years.
• His recent project was as Confidential Apps DBA with Confidential CMS HIGLAS R12 Confidential EBS GL Accounting system .
• Worked as one of the DBAs doing production support of CMS HIGLAS is R12 EBS Federal Applications on Confidential Exadata X7 - 2 of size 60 TB Production database for the last 2 years. His latest experience includes Production Database Maintenance, monthly Exadata patching on Compute Nodes,IB Switches,CellNodes.
• Performance tuning of R12 EBS Batch jobs on Exadata. 13c OEM monitoring of R12 EBS Application,SOA,OBIEE,Exadata .
• Experienced with all adop on-line patching of R12 EBS for monthly CPU patching.
• He is experienced in cloning of R12 EBS instances from production for different monthly,quarterly deployments.
• He has worked as Senior Principal Consultant/Principal Consultant/Apps DBA/Core DBA/ATG System Analyst for sixteen years .
• He has worked with many clients some of the client projects are listed under work experience.
• Experienced in implementing Confidential Fusion Applications installation on Confidential cloud.
• He is experienced in setting dataguard for R12 EBS Applications .
• Experienced with R12EBS migrations from R12.0.3.
• Performed R12 Ebs upgrade at CSRA for CMS HIGLAS R12 EBS Instance, R12.2 upgrade at Confidential .
• Performed cross platform migrations of Confidential databases using data pump,transportable tablespaces from IBM Aix to Confidential Linux 6.
• Experience in providing technical support for Confidential Financial s modules Confidential Payables,Iexpense,CRM Field services
• Experienced in 12C OIG,OIM,OID SSO for R12 EBS.
• Maintained ALM applications on MS Sql server at Confidential .

KEY TECHNICAL SKILLS:

• Installation,Cloning,migration of R12.2 EBS on RAC/Non - RAC. adop,adclone,admerge,adsplice.
• CEMLI conversion, OAF Pages design, Forms customization, Workflow customization, AME setup for Expense Report approval .
• KFF, DFF setup for all the Financial Modules. Auto Invoice, iProcurement.
• Familiar with all the interface and seeded tables for OM,INV,PO,AP,GL.
• Confidential RDBMS 12c Multi-Tenant Container and PDB Database setup.
• Confidential Valuet setup/Realm,VPD for EBS Applications tables.
• RAC/Non-RAC database Performance tuning using trace analysis,awr level 12 tracing. Tuning using Confidential EM Grid Tuning and Diagnostic
• Pack.SQLTXT,stats export/import and Histogram for skewed data.
• RAC performance tuning and Load management using services.
• Confidential EM Grid cloud 12c for all type target discovery,cloning,setting up standby databases.
• Confidential Active DataGuard with DG Broker. Familiar with switch-over and failover using DGMGRL.
• Installing and Configuring Golden Gate for Tables replications for ERP
• Schema synchronization. Experienced with both Classic Capture and
• Integrated Capture .Command Familiar with ggsci command line interface commands.
• Setting up Confidential Identity Management 11g OAM/OID, Webgate, Access gate, User Management, Fusion Middleware Web-logic J2EE Application
• Deployment. installing Confidential Applications on Windows Datacenter on
• Vmware,Unix,Linux.
• Confidential workflow, AME Approval Chain with HR Hierarchy.Account
• Generator customization.
• CEMLI legacy data conversion for Order management, PO and AP
• Modules. Troubleshooting OA Fraework issues.
• OAF Extension using Jdeveloper.
• PLSQL,SQL Tuning, AWR Report Analysis, ADDM, SQL Pro le, Advanced
• Tracing of PLSQL codes,OEM Grid Tuning Advisor, RMAN for cloning backup and Recovery.
• Migration of Confidential Applications Database using Transportable tablespace,Datapump methods.
• Migration of EBS Database into Exadata Engineering System.
• Confidential Application Management Pack for E-Business Patching, Code
• Migrations.
• Trained in Confidential Managed Cloud Services . On-Hand experience in setting up instance,storage,cpu, memory allocations and REST API
• , Orchestration, Migration of SOA Composite Applications from On-Premise to Confidential SOA cloud. Familiar with Accessing ERP Cloud Analytical applications.
• Exposure of EBiz functions as services and wsdl. Confidential Cloud Integration using EBS Adapters. Using EBS adapters in the SOA Composite application.
• Experienced in weblogic domain setup in different configuarions with clustering for many different fusion applications.
• OBIEE/IPM/SOA and R12 EBS Applications..,monitoring of servers,instances, clustering for more than six years.
• Confidential SOA Database Performance tuning and Capacity planning and DR setup.
• Project Planning and Confidential Unified methods for Project Management.
• Experienced in Orde-to-cash and Procure to Pay setup and SOA integration with OTM. Experienced with EDI Gateway,XML Gateway.
• Plsql,Jdeveloper extension for ADF,Forms Extension and Retrofit of Legacy
• Data Migration.

WORK EXPERIENCE:

Database Administrator

Confidential

Responsibilities:

• Worked as R12 EBS Federal Applications/Core DBA for Center for Medical Services maintaining Confidential Applications on Exadata X7-2 of size 60 TerraBytes.
• Experienced on R12 EBS Production Application support on X7-2 Confidential exadata .
• Experienced in all application,database patching .
• Maintained Confidential GRC Applications for SOD, Provided production ALM applications on MS Sql server.
• Performed R12.2 upgrade from R12.0.3 for this Higlas R12 EBS Application.
• Worked as Production support DBA for Higlas R12 EBS Applications of 60 TB size.
• Experienced with Partitioning,performance tuning of R12 EBS modules.
• Experienced in Autosys/CMOD/Websphere applications used for Batch operations.
• Experienced with troubleshooting user login issues for R12 EBS.

Senior Principal Consultant

Confidential

Responsibilities:

• Migration of Confidential On Demand R12 EBS data to ERP cloud using web services. Data Migrated on premise Endeca Instance into IAAS cloud. Enabled integration with on premise EBS instance for Endeca Extension.
• Worked on Database cloud for setting up the R12.2 EBS database and Endeca for Doosan and used the Database Backup cloud for all the on-premise and cloud instance.
• Worked on setting up a complete Fusion Application Instance on Confidential Fusion Lab for an on-demand client. Performed IDM for setting up Fusion GL and AP. Enabled the Workflow for approvals. Used Fusion IDM for user provisioning and RBAC role assignment.
• Implemented Confidential Endeca Extension for R12.2 EBS. Endeca ETL processing
• Used transportable tablespace for migration from HP-UX to Exadata. Configured OEM 12c for Exadata monitoring.
• Migrated Confidential ERP Database from HP-UX to Confidential Exadata X6-2.
• Installed R12.2 on Windows datacenter OS on vmware. recovery.
• Performed sysadmin for their redhat Linux Endeca Instance.
• Implemented DR using Active Dataguard in two node RAC configuration using 12cEMgrid.
• Helped client to go-live on RAC from Non-RAC using Primary to Standby failover method. installed and configured Demantra R12.2 with 12c Database.
• Implemented Confidential E-billing 6.2.
• Done extensive performance tuning on OLAP and OLTP schema using different partitioning method.
• Done performance improvement with Partitions for OLAP Schema.
• One of the DBAs upgraded Federal Financial R12.1.3 to R12.2 for CMS using inline upgrade driver method .
• Performed capacity planning for Accounting Engine, SLA Account Generator Performance improvement/scaling.
• Performed Tuning to improve Create Accounting in GL process.
• SLA Data Migration and Range Partitioning of GL Tables for improving Accounting Process.
• Helped client with using setting up concurrent managers for integration of different legacy system accounting entries into Confidential GL with Accounting Hub.Helped Client is gathering custom interface design and functional setup documents for legacy data conversion into R12.2 EBS for GL, AP modules .
• Architected and implemented single sign-on for OBIEE,IPM and other weblogic based domain based appllications with Fusion 11g Identity Management for SSO with EBusiness Instances for Invoice Imaging.Configured Managed Servers High-Availability in the weblogic.Installed complete 11g IDM suite, configured OIM,OAM,OID and provisioned users for EBS and Fusion Middleware applications.
• Performed EUS and Kerberos authentication for the database user accounts.
• Lead dba assisted client with technical upgrade from R11I of R12.
• Implemented 12c OEM and configured AMP for Patch Management and CEMLI configuration management.
• Consultant for converting R12.1.3 to RAC. Upgraded their g rid Infrastructure. Worked on cloning R12.1.3 using RAC to RAC cloning methods.
• Implemented Confidential R12.1.3 EBS Helped client to migrate from Veritas Active/ Passive cluster to Active/Active 11g RAC of their R11.2.0.3 EBS environment on IBM AIX. Helped client with Install base data migration.
• Helped client with concurrent manager,ascp instance and Apps server capacity planning on IBM Power 7 series servers.
• Migrated R11i EBS from cluster file system to RAC with asm and erformed cross platform migration of ERP from HP-UX to Linux. Performance tuning for iSupplier and iRecruitment applications.Setup configurator wallet setup and ssl certificate setup. Implemented iRecruitment in DMZ.
• Helped client with performance tuning of JDE. Validation of Data Guard setup .Resolved the time lag, DG node crashing issue.Fixed performance issues with queries from JD Edward Application that were using sub-optimal plan.Visited the control M perl script issue with not updating child tables with triggers. Provided script to analyse the time lag between primary and Data guard standby db in redo apply for any given period. Enabled OSWatcher for analyzing the Disk I/O issue and DR instance crash.
• Architected Exadata for their new R12.2.3 ERP instance migration.Performed extension performance tuning of Confidential R12 Payroll applications at Metrolinx Canada. Worked on export/import of Advanced queues for R12 EBS on 11gR2 RAC environment.
• Administered Exadata for Peoplesoft Environment. Configured the complete scan listener setup for the Exadata RAC instances. Adminstered the storage cell and used the Exadata smart scans and offloading features.Replaced streams synchronization with Golden Gate Replication for Tables used in the Advanced queue propogations. Worked on troubleshooting enquire/dequeue contention in AQ used in EBS workflow.
• Helped client with deployment server and EI servers on Windows 2003 MS cluster with Confidential failsafe for JD Edwards 9.1 Application. Configured the Confidential Failsafe server on MSCS Active/Passive cluster. Used Failsafe manager to discover services and did failover test.

Confidential

Senior Technical Support Engineer

Responsibilities:

• Worked as OracleAppsDBAforOracle hosted Application Databases.
• Worked on technical issues with installation,upgrade,migration of Confidential
• Applications over phone and on webex for different Confidential applications clients.
• Worked as Team Lead for the Advanced resolution team involved in troubleshooting workflow, flexfields, concurrent managers, forms, reports and OA Framework issues.
• Supported the Confidential Payables, Iexpenses modules.Worked on Project
• Account Generator , Accounting Flexfield, Create Accounting events performance issues, Payable Open interfaces,GL transfers, Journal Entries,
• Troubleshooted Creating Accounting issues.

Associate Technical Analyst

Confidential, Orlando, Florida

Responsibilities:

• Worked on plsql, forms, reports, Confidential Applications 10.7,11i.
• Assisted clients w ith Technical issues from ATG Tech stack.
• Worked on Apache, Confidential Web Server, Installation and auto upgrade issues.
• Worked on issues with concurrent managersload balancing issues and many windows client issues with accessing Confidential Applications.

Research Assistant/Unix sysadmin

Confidential, Melbourne, Florida

Responsibilities:

• Research Assistance - Fiber Optics /Unix Data Center with Fiber Optics Sensor Lab.
• Developed Data acquisition system with Confidential database for Speed data collection.
• Worked as Lab Unix sysadmin.
• Worked on the Fiber optics sensors for Confidential .

Divisional Engineer

Confidential

Responsibilities:

• Implemented Confidential switches from Siemens.
• Implemented Long distance Fiber
• Optic and Microwave Communications throughout India. Worked on
• Implementing Confidential Payroll .

Quality Control Engineer

Confidential

Responsibilities:

• Worked as QA engineer for Mig-27 Fighter Jet.
• Trained from Indian Institute of
• Technology on Aeronautical Engineering