PROFILE:

• Confidential has been an Advanced Oracle OAM, OID, OVD, IM DBA for over 20 years.
• During that period Confidential managed Oracle software ranging from E - Business Suite, Oracle Weblogic, OBIEE , GoldenGate, Hyperion Planning , Exadata, Essbase, Financial Management, Financial Reports , Oracle Internet Directory Infrastructure, Oracle Applications 11 i , 12c, data warehouses and RAC databases. Andre has performed migrations of OAM/IM/OID Weblogic environments as well databases and applications from 7 to 12c.
• Andre is experienced in Programming, Dimensional modeling and architecture design. Andre ’s experience is cross-industry, including the public sector. Andre specializes in Maximum Availability systems and tools such as Oracle 9 i AS/10gAS, Oracle RAC, WebLogic, OBIEE, Oracle DataGuard, Veritas and Unix Shell scripting, EPM Hyperion, Oracle Access Manager, and Hyperion Infrastructure.

TECHNICAL SKILLS:

Software and Languages: SAML, Java, Rest API, Oracle Products ( Oracle Access Manager, Identity Manager, OVD, OUD, OBIEE 12c , OBIEE 11g and 10g, GoldenGate, Exadata, Hyperion EPM 11.1.2, 11.1.1.3 , Essbase, Weblogic , CA SiteMinder , CA SSO Federation , Workspace, BPEL, 9 iAS , 10 gAS , OCS, Portal, SSO, Forms and Reports, J2EE, OVD Oracle Virtual Directory, OUD Oracle Unified Directory, OID Oracle Internet Directory, Web Cache Clustering, RAC, OWB, DataGuard Disaster Recovery, Discoverer, Designer, 9iDS, Oacle 8i, 9i, 10g, Oracle Applications (e-Procurement, HRMS, Financials (10.7, 11.0.3, 11 i) ), Oracle WebDB, PL/SQL ); ASP.Net, Erwin, XML, Veritas DBE/AC, HP Service Guard and Service Guard Extension, Informix, Micro-Strategy, Siebel, Banner, SAP, Java, Business Objects.

Operating Systems: Linux (RedHat, SuSe), AIX, HP-UX (9.04, 10.10, 10.20. 11i), SOLARIS (2.7, 2.8, 5.9, 10), Windows NT, 2000, XP.

Hardware: Load-Balancer Routers F5 Big IP , Cisco, Nortel Alteon ACEDirector .

Servers: IBM RISC 6000, IBM z/OS Parallel Sysplex, IBM pSeries 690, HP 9000, HP AlphaServer SC45, T500, HP Superdome, SPARC 2000, E6500, SunF12K, SunF15K, EMC San, Fujitsu , NetApp NAS.

PROFESSIONAL OBIEE AND DBA EXPERIENCE:

Sr. Oracle OBIEE DBA

Confidential, Rockville, MD

Responsibilities:

• Andre was brought in by Confidential to fix issues the customer was having with their OBIEE Business Intelligence Cluster 12c for months.
• Troubleshot the Prod environment to identify the cause of the cluster instability.
• Resolved the OBIEE 12c Clustering issues and provided best practice recommendations to customer.
• Installed two OBIEE 12c environments that week and provided stability to their OBIEE project.
• Migrated client RDP and OBIEE instance from DEV onto Prod and made custom performance changes to improve OBIEE Dashboards

Sr. Oracle OIM/OAM Identity Management Architect

Confidential, Baltimore, MD

Responsibilities:

• Designed and implemented enterprise-wide access management and single sign-on infrastructure for both internal and external applications.
• Configured Oracle Identity Management and Oracle Access Manager identity manager and its connectors.
• Architected and customized the integration of multiple LDAP and various enterprise applications, including AD, OID, Novell.
• Responsible for architecting, implementing, configuring, customizing and defining the process flow for Identity and Access.
• Installed, configured and managed OIM 10g and it connectors (SAP, AD, Hyperion, OBIEE) including Password Sync.
• Installed and configure Oracle Unified Directory (OUD) and Oracle Virtual Directory (OVD) to pull user information from AD, OID, Databases, Web services.
• Migrated OIM 10g to 11g R2 and integrated with Microsoft AD.
• Troubleshot and resolved connectivity issues for external and internal customers using OIM/OAM. Troubleshot issues during customizations of OIM connectors.
• Created SaaS connectors to integrate protected applications sitting on AWS cloud.
• Built OAM custom connectors and different type of adapters for various applications.
• Deployed an Identity Manager (OIM) and Oracle Identity Analytics which included the automated provisioning for hundreds of connected systems and also configured the provisioning for an Identity Management system supporting over a million active users.
• Build Access Policies for auto provisioning resources to users based on defined criteria. Customized the web console to fulfilled different needs of the clients which includes customized attestation process, request for resource and other web UI changes. Also developed custom reports for the client.
• Also worked on Exchange connector and developed the scripts for remote manager.
• Installed, configured and upgraded Oracle Identity manager on development, QA and Production servers.
• Installed and configured CA SSO to allow access to multiple external web applications.
• Upgraded CA SiteMinder and integrated with EPM Hyperion for SSO purposes.
• Coded SAML integration procedures to enable SSO among heterogenous application codes, including ASP and Java applications.
• Designed the architecture of Oracle OBIEE clusters implementation and administered the Weblogic domains configured to support both OBIEE and Hyperion EPM.
• Designed and configured WebLogic disaster recovery, created backup scripts and recovery procedures for the Weblogic domains.
• Monitored thread usage, connection pool usage, CPU usage, Memory usage and preparing reports for the performance tests, dry run tests and load tests conducted on the Application Servers
• Configuring digital certificates, using java key tool for secured applications.
• Create methodologies for easy usage tracking and memory leaks detection for Weblogic managed servers.
• Integrated OBIEE with ERP using ODI and provide tuning support for OBIA application users and developers.
• Recovered OBIA applications and migrated OBIA applications from DEV to Prod and vice-
• Configured Oracle Data Integrator ODI to migrate data between Oracle E-Business Suite and OBIEE instances.
• Configured SSL on all levels of the Hyperion EPM systems (web server, Foundation, RDBMS, HFM, FR, Essbase and LDAP)
• Configured Hyperion Shared Services with Corporate LDAP directory in SSL mode.

Sr. Oracle OIM/OID Identity Management Architect

Confidential, Nashua, NJ

Responsibilities:

• Oracle Access Manager, Oracle Identity Manager, Oracle Internet Directory and Oracle Virtual Directory.
• Integrated Oracle Identity Manager (OIM) with other fusion middleware products like (OID, OAM) and third-party products (Active Directory, Sun Java System Directory Server.
• Performed Identity management, Provisioning and Reconciliation, Provisioning & Approval Workflows, Adapter Development and implementation.
• Administered and supported CA SiteMinder infrastructure applications, including creation of provisioning flows, adapters and development of policy rules for Access Managements Federations.
• Configured trusted reconciliation using Generic Technology connectors and Database Application Table connectors.
• Installed and configured dozens of OAM artifacts and dependent components.
• Performed SSO configuration of OAM with OIM and other integration help of webgate, access gate and sso agent and integrated OAM with Windows Native Authentication WNA.
• Served as Oracle IDM Security Engineer. Description by setting up a central repository for managing user data for the rapid deployment of new applications and services.
• The solution I deployed SSO to portal, SOA, PeopleSoft, OBIEE. I installed OAM, created application domains, defined protected policies, set up webgates and proxy configurations.
• Performed automatic provisioning of user accounts for OIM users in OID, and unmanaged systems through the user groups, access policies, workflows and other connectors.
• Set up attestation process and delegated administration as well as sync between OIM and AD, MS Exchange, and Oracle DB.
• Created Password policies in AD, OID and OIM. Integrated OIM and OAM applying Single-Sign on.
• Configured authentication and authorization policies for protecting web applications and providing SSO functionality.
• Performed installation, configuration and integration tasks in OIM, OVD, OID, MS AD, Sun one directory, web logic server, OAM, OHS web server in a Global Identity and Access Management environment.
• Performed day to day user support with security responsibilities such as Creating, Adding/Updating resources, Lock/Unlock - Enable/Disable and deletion of user accounts, user provisioning to MS- AD.
• Designed role/rule based provisioning policies as per Role/Access matrix of the Organization and also designed scheduled tasks for user re-conciliation and clean-up exercises.
• Designed and installed the Corporate Weblogic infrastructure to support an array of Fusion Middleware applications ranging from Golden Gate, Hyperion, OBIEE, SOA to OID.
• Developed strong expertise in handling code releases and deploying applications in Weblogic environments
• Configured SSL: 1- way SSL and 2 - way SSL handshakes, created users, groups and roles for different management groups’ through-out the organization.
• Coded Weblogic scripts to handle complex automation/administration tasks using Shell scripting, WLST and WLShell.
• Responsible for OBIEE security design: New Id creation, user profile setup, Account modification of existing users, Password reset and Deletion of accounts.
• Performed OID and Active Directory LDAP configuration with OBIEE for Single Sign-on authentication.
• Designed both Authentication and Authorization architecture for OBIEE users
• Provided admin support to OBIEE data modelers to Define the Joins between tables in the RPD.
• Responsible for ensuring that all OBIEE scheduler jobs run successfully, including validation reports against the data warehouse.
• Troubleshot OBIEE processes crash and assisted in tuning the SQL statements generated through the reports and dashboards.
• Installed and configured Oracle Portal 10gAS in a cluster environment.
• Designed holistic backups of the Oracle Portal Mid-Tier components.
• Upgraded Oracle Portal from 10gAS to Weblogic.
• Configured Oracle Streams to replicate Hyperion instances and OID instances.
• Installed, configured and maintained Weblogic server to deploy and support various applications.
• Configured Grid Control Mass deployment of patches, pushing CPU and upgrade patches to tens of servers in a single batch.
• Configured Mass deployment of Grid Control Agents.
• Provided recommendations to Unix system administrators on NetApp mount options for Oracle.
• Designed and installed the Hyperion system backup including logical backups of Essbase, Planning, RDBMS. Created jobs to backup OTL (outline files), configuration and security files.
• Wrote precise and step-by-step cookbooks documents on how to install and deploy OIM/IM/OUD/OID from building assemblies to checking the sanity of components.
• Designed a Hyperion validation methodology that DBA need to perform to ensure that Hyperion has been properly configured, including setting up applications and loading metadata and data to validate the product.

Sr. Oracle Applications RAC 11i Admin

Confidential, Atlanta, GA

Responsibilities:

• Installed, configured and maintained multiple instances of Oracle Applications 11i.
• Converted all Oracle Applications 11i databases over to RAC with 8 cluster nodes on the database Tier and 8 application clusters on the Mid-Tier.
• Configured Oracle Applications database with Oracle Data Guard for Disaster Recovery.
• Integrated Oracle Applications 11i with Oracle 10gAs OID by upgrading the Mid-Tier applications Tier to 10gAS.
• Used both RMAN Duplicate and Rapid Clone to quickly clone 11i environments
• Designed and implemented 11i Backup Strategy and integrated the Oracle Grid Control, including RMAN global scripts, retention policies, crash Recovery Test scenario.
• Set up Oracle 10g R2 database security features such as Transparent Data Encryption (TDE), Advanced Security Option (ASO), network encryption, coded audit trail scripts to mine the security audit data.
• Migrated Oracle Applications Server 9iAS to 10gAS and configured Mid-Tier apps clustering.
• Configured, troubleshot and maintained Active Directory-OID synchronization profiles.
• Configured and managed Oracle Internet Directory (10gAS) to synchronize user directories with Microsoft Active Directory and FND User in Oracle E-Business Suite.
• Installed and maintained Oracle Data Guard both for Disaster Recovery (Physical) and Reporting purposes (Logical).
• Configured and administered Oracle Streams to replicate data from AS/400 to Oracle, then from OLTP instances to multi-terabyte data warehouses.
• Converted single instance databases to RAC and cooked filesystems to Oracle ASM.
• Trained Confidential IT personnel on Application Server 10g AS and Collaboration Suite administration trained End Users on how to use the product. Built a knowledge based and deployed it as an OC4J application into the OCS portal.
• Upgraded OCS 9.0.4 to Oracle Collaboration Suite 10g, defined standards for OCS tuning, maintenance and set up custom start up and shutdown scripts.

Oracle RAC/10gAS OCS Admin

Confidential , Arlington, VA

Responsibilities:

• Hired by Bearing Point to get an advanced configuration of Oracle Collaboration Suite up and running for the U.S. Marines Corps at the Pentagon. Hired by BP as a last resort after numerous attempts have failed and undermined the relationship between BP and the Confidential .
• Helped Bearing Point regain the confidence of the client and save a contract in jeopardy, by providing from day one high level expertise, displaying deep knowledge of the subject matter and delivered a working system quickly.
• Designed and installed layout of Oracle Applications 11i instances in a high-availability environment with Oracle RAC and Data Guard
• Configured Oracle Applications 11i to use Oracle Internet Directory in sync with Active Directory.
• Integrated OID with Microsoft Active Directory and Oracle Applications 11i.
• Installed, maintained and tuned an 8-node RAC database for multi-purpose usage, including Collaboration Suite storage, Data warehousing and OLTP.
• Installed, managed and maintained ASM disk groups. Troubleshot issues related to CRS reboots, ASM presentation and Interconnect latency.
• Developed and implemented a methodology to tune Oracle RAC databases, including parallel queries, bitmap Join indexes and partition strategies, Global cache tuning, memory and I/O performance.
• Set up Windows Native Authentication with Kerberos to allow Synchronized Active Directory Users to log in to Oracle SSO-OID without being prompted for a password.
• Configured Active Directory-OID Synchronization and SSL for all traffic through the 10gAS instances.
• Provided hands-on training to Bearing Point and Confidential personnel on 10gAS administration procedures, provided step-by-step documents on how to maintain, tune, backup and cluster 10gAS applications. Customized and deployed backup and restore scripts for the Application Servers. Set up SSL across all components and configure Web Cache in front of the Mid-Tier to distribute browser requests.
• Installed Oracle OCS 904 and later migrated to OCS 10g.
• Designed, installed and maintained the Clustered architecture to implement the IRS Electronic Fraud Detection System, including a set of Oracle 9 iAS , 10 gAS applications servers, Oracle RAC Real Application Clusters, Disaster Recovery, Designer and Discoverer. Platforms in different RAC environments ranged from Solaris, Windows to Red Hat and HP UX 11i flavors.
• Configured RAC on HP UX 11i using Service Guard Extension and integrate it with Oracle Applications 11 i .
• Configured Oracle Data Guard to provide high availability to the Oracle 10g Infrastructure database. Set up Data Guard and Oracle streams as part of the enterprise database back up procedures.
• Installed, maintained and tuned an array of Oracle Applications 11 i instances set up with Set up Oracle 9iDS, created Discoverer EUL, worksheets, administered the 9iDS components such as Designer, Discoverer, OWB and integrated them into Portal as providers and Portlets.
• Synchronized Oracle Internet Directory with MS Active Directory with SSO and SSL enabled.
• Set up Web Cache Clustering and Load-Balancing behind F5 Big IP to increase performance, configured Portal with SSO. Built complex Portlets to support the registration of third-party as well as partner applications.
• Designed the security model for authentication and authorization through SSO/Portal
• Trained Government DBAs on the architecture of Oracle 10gAS, introducing them to the integration of components.
• Wrote a dozen of documents and project plans on 9iAS, 10gAS and 10g performance tuning for IRS Tax return web-applications, 4-terabyte databases, partitioning strategy, RAID configuration, and integration of RAC with EMC BCV and project plans.
• Installed and maintained instances of 11 i for Bellsouth Financials.
• Configured Data Guard stand-by databases and built refresh jobs to replicate data to many sites.
• Served as Oracle Financials DBA and Applications System Administrator.
• Installed and managed numerous 9 iAS universes, both on Unix and Windows platforms.
• Installed Oracle RAC and integrated the Mid-Tier with the shared multi-terabyte database, enabling transparent automatic fail-over.
• Designed the Oracle 9iAS cluster topology and deployed Oracle Portal, Discoverer and OC4J applications in a cluster environment.
• Performed 9iAS migration of SSO, Portals and integration of external directories into OID.
• Administered the Enterprise 9iAS architecture, applications and various components.
• Designed and documented the data warehouse architecture, the dimensional (Star and snowflake schemas) model using Erwin.