Rutgers University

ACTIVE SECRET SECURITY CLEARANCE.
Security+ Certification
Oracle EBS Apps DBA  -  OAM and OID  -  OBIEE 12c

Nazareth, Pennsylvania

Performed Oracle E-Business Suite (11i and R12) DBA tasks for various clients. Tasks included installation, upgrades (most recently 11i to 12.2.5), and support. Also performed these tasks for other tools and products used in the E-business Suite environment, such as, Discoverer, Demantra, OBIEE, OBIA, Oracle Access Manager, Identity Management, etc.• ACTIVE SECRET SECURITY CLEARANCE• Medical Equipment Manufacturer: Upgraded EBS 11.5.10 to EBS 12.2.5 and Oracle DB from 11gR1 to 11.2.0.4 on Solaris 10. Cloning and support of EBS 12.2.5 environments (dev, test, integration, etc.).• Government Agency: Upgraded EBS 11.5.10.2 to EBS 12.2.4 and Oracle DB from 10g to 11.2.0.4 on RHEL6. Cloning and support of EBS 12.2.4 environments (dev, test, integration, etc.). Installation of OBIEE 11.1.1.7 on RHL6. Configured Single Sign-on integration from EBS to OBIEE. Installation of ODI and OBIA 11.1.1.8.1 and upgrade to 11.1.1.9.2. Setup and ran Data Loads for Supply Chain and Order Management.Installation and administration of Active DataGuard and creation of EBS standby database used by OBIEE. Installation and configuration of OBIEE Database using RAC and Active Data Guard of EBS Database on RAC.Upgrade OBIEE 11g to 12c. Implement SSL/TLS 1.2 for OBIEE 12c and OHS 12c. Configure OBIEE to use OID as external LDAP.

Independent Consultant

Oracle E-Business Suite DBA

- CUNA: Support of Demo, Development and Production OAM 10g environment. Creation and modification of Domain Policies to protect internal and externally facing Web Application resources for Single Sign-on.• MMI: Installation and configuration of OID 11g, OAM 11.1.2, Webgate/AccessGate 11g for EBS 12.1.3. One internal node containing OID, OAM and Accessgate for Internal EBS nodes. Also, installed WebGate/Accessgate for external EBS node.• RAND Corporation: Performed the installation and configuration of OAM 11g and OID 11g on Linux for integration with Oracle EBusiness Suite R12. Performed the integration of the Java plugin between OID and Active Directory for authentication. Performed the installation of the Development, Test and Production environments.• Celgene: Installation, patching and cloning of Value Chain Planning (VCP 12.1.3.7). Installation of Loftware label software 10.0 on Windows server with Oracle connector 3.1 for 10g DB and Loftware 10.1 with Oracle Connector 4.1 for 11g DB environments. Installation of Demantra 7.3.1.4 with Analytical Engine running on Linux with WebLogic 10.3.6. Installed and configured EBS 12.1.3 Validation environment with a 2 node 10g RAC (ASM/CRS).

- Praxair: Installation and configuration of OBIEE 11.1.1.7, OBIA 11.1.1.8.1, ODI 11.1.1.7, and WebLogic 10.3.6 on Linux RHEL5. Installed Oracle GoldenGate 11.2.1.0.1 on Target database server (Linux RHEL5) and Source database server (EBS 11.5.10.2) with Oracle 11gR2. Created SDS, generated SDS DDL, generated OGG Params, and created SQL for Initial Load using ODI Studio. Implemented ODI J2EE Agent on WebLogic Server running on a Linux RHEL5 Application Server. Implemented a Stand Alone ODI Agent on the Target Database Server. Developed and delivered complete documentation of the installation and configuration procedures. Conducted training sessions for the client’s engineers. • Extendicare: Staff augmentation for major HealthCare Services company. Patching, Cloning, Vertex 6 updates, deployment of OAF customizations in an EBS R12.1.3 environment. Installed Oracle Application Testing Suite and FlowBuilder on Linux 64-bit server. Supporting testers and OpenScript developers in OATS environment. Monitoring production and performance tuning. • Huntington Bank: Backfill for DBA Team. Production support of Financials and HRMS environments which includes patching (Finanicals RPC1, HRMS Quarterly, CPU), Vertex Tax updates, Cloning, user support (logins, OIM/OAM, etc.). Providing support for the upgrade from OSSO (10g) to OAM (11g).

- Lumos: Installation of OBIEE 11.1.1.7 with EBS 12.1.3. Performed the installation of ODI and OBIA components in the OBIEE environments. Implemented the “Center for Internet Security (CIS) Benchmark” for database and server hardening in the OBIEE environment. This included the installation of the latest Application and database patchsets (CPUJan2014), Java 7, and OS patches.• FTD/TransWorld: Install and implement OID 11.1.1.7 with Active Directory, OAM 11.1.2 configured for EBS 12.1.3 Dev and Test environment. Documentation and knowledge transfer to client’s DBA team.• Vertex Pharmaceuticals: Installation of OBIEE 11.1.1.6.5 with APCC for Centralized VCP 12.1.3.9.1 instance on Oracle Linux 5.8 (Exadata) and ZFS Storage.• ValueOptions/FHS Health Systems: Upgrade of EBS 11.5.10.2 to EBS 12.1.3 on AIX 6. Financials only. Migration and configuration of Discoverer 10g for EBS 12.1.3.• Penn State University: Upgrade of Oracle Database 9i to 11gR2 for EBS 11.5.10.2 Solaris 10. Implemented OATM and SSL for EBS 11.5.10.2. Installed OEM Grid Control 12c on RHEL 5. Upgraded Discoverer 10g to Discoverer 11.1.1.7 with WebLogic on RHEL 5.• NUCOR Steel: installation of EBS R12.1.3 with 11gR2 RAC on Oracle Enterprise Linux. Development and Test using 2 node RAC. Production using 4 node RAC. RAC and EBS cloning.• ADT Security Systems: Installation of EBS 12.1.3.8 for Value Chain Planning (VCP) on AIX 7.1. Installation of Demantra 7.3.1.4 on Windows 2008 using Oracle 10gAS on AIX 7.1. Installation of OBIEE and configuration of Advanced Planning Command Center (APCC). Installation of UPK Pro 11.1 using MS SQL Server on Windows 2008.

- Maricopa Community College: Upgrade of EBS 11.5.10.2 to 12.1.3 on RHEL 5. Installation and configuration of OID 11g, Access Manager 11g with Active Directory for EBS 12.1.3 Single Sign-on. •  Parson Brinckerhoff Engineering: Troubleshooting and implementation of Oracle Access Manager 11g and OID 11g for EBS 12.1.3 on RHEL 5.•  Nashville Metro City Government: Installation of EBS 12.1.3 on RHEL 5. Installation of UPK 11, OID 11g, Access Manager 11g for EBS 12.1.3. •  America LaFrance: Administration and Support of EBS 11.5.10.2 on RHEL 5.•  NESL: Accelerator installation of HR (EBS 12.1.3) on RHEL 5. •  Technip: Installation of EBS 12.1.3 on Windows 8.•  SESAC: Administration of new installation of EBS 12.1.3 on RHEL 5. SAN and Linux administration. Installation of Oracle VM and OCFS. Administration, LUN creation using Navisphere for EMC Clarion CX4.

- City of Chattanooga: End of Year payroll patching on EBS 11.5.10.2 on Windows 8.•  Bank of America: Upgrade of EBS 11.5.8 to EBS 12.1.2 and platform migration from Solaris 8 to RHEL 5. Installation and configuration of Oracle OID 11g and Oracle SSO 10g integrated with CA Siteminder. Installation and Administration of Discoverer 11g.•  MMC Financials: Implementation of iProcurement and iSupplier portal for EBS 11.5.10.2 on RHEL 4.•  NAVTEQ: Installation of EBS 12.1.1 on Windows 2008. Oracle PIM Data hub.•  Innophos: Installation of Demantra 7.2.02 on Windows. Installation of Advanced Supply Chain EBS 12.1.1 on RHEL 5.• JD Irving: Installation of Advanced Supply Chain EBS 12.1.1 on RHEL 5. Upgrade of Oracle Database to 11gR1. • SunGard Recovery Services: Upgrade of EBS 11.5.9 to 12.0.6 on Solaris 8. Administration of 4 node 10g RAC cluster. Installation of OEM Application Management Pack for EBS R12.• OIC LLC: Installation of EBS 12.0.4 on RHEL 4. Upgrade to EBS 12.1.1. Installation of Universal Content Manager for Governance, Risk, and Compliance (GRC) Suite.• Volvo Construction Equipment: Migration of EBS 11.5.10.2 on Solaris 8 to a new Data Center. Financials only.• ACT: Administration of EBS 11.5.10.2 on RHEL 4. Administration of Oracle 10g RAC 4-node cluster on IBM p-series 64-bit servers running RHEL 4. Financials, Manufacturing, MSCA, HR. Tasks included patching (ATG RUP6), Critical Patch Updates, cloning, and tuning. Assisted in migration of EBS environment to a new Data Center.

- Wilson Greatbatch: Installation of Demantra 7.1.1 on HP/UX for EBS 11.5.10.2.• The Pampered Chef: Installation of EBS 11.5.10.2 on RHEL 4. Installation of MSCA, ASCP, Demantra, iSupplier, Discoverer 10g on 10gAS and Oracle Email Server 5.2.2. Installation and configuration of DMZ and reverse proxy server of iSupplier.• University of Alabama: Performance tuning of EBS 11.5.10 on Solaris 8 and Oracle Database 9.2.0.6. Performance assessment include patches, database tuning, and JVM tuning.• The City of Philadelphia: Installation of EBS 11.5.9 on RHEL 3. Platform migration of EBS 11.5.9 from Solaris 8 to RHEL 3. Upgrade from EBS 11.5.9 to 11.5.10. Financials.• Sungard Recovery Services: Support of EBS 11.5.9 on Solaris 8. Administration and cloning of Oracle AS10g with Oracle Portal, Webcache, Oracle Internet Directory syncing to AD. Financials, HR, Sales online, Marketing online, iProcurement.• The Hibbert Group: Installation of EBS 11.5.9 on Solaris 9. Installation of Oracle 9i RAC using Veritas Advanced Clustering 3.4.Installation and administration of Discoverer 10g. Financials, iPayment, Mobile Supply Chain.• Subaru of America: Installation of EBS 11.5.5 on Solaris 8. Upgrade to EBS 11.5.8. Database upgrade from 8.1.7.4 to 9.0.3. Discoverer EUL upgrade and Administration.• GE (Casi Rusco): Support of EBS 11.5.4 on HP/UX 11. Financials, HR, Manufacturing, iStore.• Agility Communications: Installation of EBS 11.5.2 on HP/UX 11. Financials, Manufacturing, Shop Floor Management. Upgrade to EBS 11.5.3. Discoverer 4 admin.

Dan Hooper