PROFESSIONAL SUMMARY:

Senior Oracle DBA hands on technology professional with over seventeen years’ experience specializing in working with complex architectures, enterprise implementations, re - implementations, platform migrations and maintaining enterprise class application systems, networks, databases and subsystems including but not limited to Unix, Oracle Applications, Databases and PeopleSoft Applications. Industry experience includes Hospitality, Healthcare, Retail and Stock Exchanges (American and New York).

TECHNICAL SKILLS:

OS: Solaris 11.3 (using ZFS and Solaris Zones), Oracle Enterprise Linus, HP-UX, Red Hat Linux 5.0/6/7, AIX, Windows Server 2004, 2008, 2012, Fedora, Ubuntu

Hardware: Solaris SPARC and Intel Servers, IBM Mainframe, IBM AIX and Linux Servers, HP HP/UX and Linux Servers, SUN Enterprise Servers

Storage Fabrics: EMC 3930, 8830, EMC VNX 7500 (SAS 600 GB 15k RPM) SAN, Hitachi Multi-Tiered Storage (Solid State Disks)

Oracle Database: Oracle RAC 10,11,12, Oracle Non-RAC 7,8,9,10,11gR1,11gR2,12cR1, Enterprise Manager 12c, Data Pump, STATSPACK, TKPROF, Data Migration, RMAN, Partitioning, Replication, Data Guard

People Tools: 8.53, 8.4, 8.45, 7.63, 7.02

PeopleSoft HCM/Payroll: 7.02, 7.5, 8.3, 8.8, 9, 9.1

PeopleSoft FSCM: 7.02, 7.5, 8.8, 9.0 MP4, 9.1, 9.2

DBA Tools: TOAD, Enterprise Manager 9/10g/11/12 & EM 12/13c and 12 DB Console, SQL Developer, Method-R Tuning Tools

Microsoft: SQL Server 2000/2005/2008/2012

Methodologies: SDLC, Agile, Lean Six Sigma

Applications: IBM s Rational Suite (UML based to support Agile and Lean Six Sigma), AutoSys, Hyperion EPM Hyperion Financial Management 11.1.2.3 and Hyperion Planning 11.1.2.3, Hyperion Enterprise and v9, DRM (Data Relationship Management), Oracle s SOA Suite, OBIEE - Oracle Business Intelligence Enterprise Edition, Oracle Data Integrator, Oracle Business Intelligence Applications (OBIA), APEX on Tomcat

Languages: Linux Shell Scripting - bash, zsh, Perl

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Database Consultant/Architect

• Responsible for reviewing the overall Enterprise Architect Models for the OBIEE/OBI/Data Warehouse environments and supporting architecture. G6 uses an Enterprise Architecture Model based on Agile that was developed and implemented by Blackstone consultants with the client’s participation. The Project Plan and Meetings were driven by this Agile methodology that is in alignment with the methodology for many of Blackstone’s Hospitality holdings.
• Responsible for conducting an architecture review of G6’s Hardware Platform and Infrastructure which consisted of Oracle Solaris SPARC T-5 Servers running Oracle Solaris 11.3 utilizing Oracle Solaris Zones and Hitachi Storage Subsystems as the Storage Fabric. The Hitachi solution included Solid State Disks offering 3 Storage Tiers. Using ZFS as the file system the ability to combine ZFS and Oracle 12c’s features allow us to create an optimized storage strategy to support the very large Oracle Data Warehouses.
• Responsible for implementing performance improvements for G6’s (Motel 6) Development, QA, and Production OBIEE, OBIA, and Data Warehouse environments. The QA Environment in addition to serving as the environment for testing Application changes, OS Updates, and Schema changes also served as the failover Production OBIEE/OBIA/Data Warehouse environment and it was in a separate colocation facility.
• Responsible for a comprehensive review identifying and optimizing the processes responsible for data transfers, ETL loads, and Schema refreshes to ensure that the QA environment could be brought online as quickly as possible in the event of a failure. The review included all components - RMAN Backups, Data Pump Processes, Network utilization, Job Scheduling, and capacity planning.
• Responsible for Performance Tuning Motel 6's Multiple Data Warehouses, ODI, and OBIEE environments - Development, QA, and Production using all of the features available via EM Cloud Manager, Method-R, and SQL Trace information.
• Reviewed and implemented changes to their existing RMAN Backup Jobs to improve execution times. Implemented Block Change Tracking, Incremental Backups, and compression. Used the Enterprise Manager 12c Job Scheduler to manage, monitor, and error handing for the RMAN Backup Jobs.
• Designed and implemented new Oracle 12c Data Pump shell scripts to streamline and decrease the amount of time required to refresh the Development and QA Schemas from the Production Data Warehouse Schemas. This resulted in the ability to shorten the refresh process from days to hours.
• Used Enterprise Manager 12c to create SQL Tuning Sets (STS) to capture long running OBIEE queries and nightly ELT Loads.
• Used Enterprise Manager 12c to create SQL Baselines to capture the ELT load activity for the purposes of tuning those processes and to use to compare performance after OS Upgrades, Database Patches, and Application changes (ADDM Compare Periods).
• Moved a Custom OBIEE Data Warehouse database schema into client's BIAPPS Data Warehouse (separate schema but shared RPD). This resulted in server and database consolidation and provided the user community with one OBIEE Dashboard instead of two separate OBIEE ones.
• Responsible for Performance Tuning the OBEE Middleware (WebLogic), ODI, Solaris kernel parameters, ZFS, Network and Database Layers for Development, QA and Production environments. Identified that G6 was using the 32-bit Java Model and among implemented numerous performance improvements based on Oracle’s Best Practices. I switched them to the 64-bit Java Model and optimized the Memory Model for WebLogic and the associated OBIEE processes.
• Migrated client's Data Warehouse databases to a new 8K Block Size Database from their existing 32K Data Block database.
• Created new Oracle Initialization Parameters for Production, Development and QA environments designed to support optimal User Experience and to support the daily ODI loads from client’s EBS Application. Created new Oracle 12c Initialization Parameter File to addressed issues with Automatic Query Optimization, Dynamic Sampling, Memory Management, Large Pool, etc.
• Implemented Oracle Shared Memory (OSM) to optimize Oracle’s use of shared memory segments and determined best set of initialization parameters to sustain high level of performance for EBS Nightly Loads and Complex OBIEE Query Performance.
• Wrote scripts to generate Optimizer Statistics for all environments and scheduled their weekly/daily execution via crontab.
• Generated SQL Tuning Profiles and SQL Tuning Sets for the OBIEE Reports using Enterprise Manager 12c. Wrote shell scripts to export and import the Production SQL Tuning Profiles into Development and QA Databases.
• Updated the ODI Model to separate Oracle ODI BIAPPS Tables and Indexes into their own tablespaces because current architecture does not provide this functionality out of the box. The intent was to improve execution times for the ODI Loads by distributing I/O to multiple ZFS storage pools.
• Responsible for tuning the Data Warehouse Production, QA and Development environments to reduce and improve SQL Execution for the extremely large and complex queries generated by Oracle’s OBIEE / BIAPPS software suite that was used to generated P&Ls for all Motel 6 Business Units including Corporate, individual properties, regions and various consolidated entities that aligned with their Oracle EBS Financials Chart of Accounts and reporting hierarchies.
• Performed analysis of Oracle disk utilization for all environments as well as comparing data file names, locations, tablespace names and implemented changes to remove unused tables, fixed data file names so that they matched making it easier to use RMAN to duplicate/clone environments, reviewed storage tier utilization and distributed data and index tablespaces to the various tiers. This was done to standardize and resolve inconsistencies between the Dev, QA, and Production environments.
• Performed an analysis of the ZFS configuration parameters to identify and implement changes to ZFS implementation with the goal of conforming and adhering to Oracle’s ZFS Best Practices for the Storage Fabric objects.
• Participated in Planning and Design Sessions in support of FPA implementation of Consolidation tool and Essbase to support Planning and Budgeting functions.
• Implemented APEX 5.1 including REST using Tomcat as the Web Server on Solaris 11.3

Confidential

Oracle Enterprise Performance Management (EPM) Consultant

• Responsible for supporting the Oracle Enterprise Performance Management Applications for the Global Financial Planning and Analysis user community in an Agile environment.
• KLX recently spun off from the parent company and went public at the beginning of the 2016 year. To accelerate the process of establishing their own Hyperion Application Environments they used the parent company’s Chart of Accounts and throughout the course of 2016 application changes were implemented to tailor the COA to meet KLX’s FP&A requirements.
• Responsible for reviewing the existing COA and preparing KLX for an upcoming project that will implement a new Chart of Accounts designed specifically to meet their Financial Reporting requirements using the latest release of the Oracle EPM Suite.
• Responsible for supporting FDQM, Shared Services, Application Security (HFM and Essbase), Lifecycle Management, and Hyperion Financial Management Applications.
• Designed and implemented a Backup/Recovery process for the HFM Applications, Shared Services Metadata, and Essbase Cubes used for EPM Planning and OBIEE Dashboards and Reports.
• Generated HFM Essbase cubes using EPM Essbase Analytics Link (EAL) providing Business Users familiar with Essbase access to HFM data in Essbase format.
• Designed and implemented a process to refresh the Development and QA Application and Shared Service environments with the Production metadata and data.
• Created Window shell scripts to execute the daily backup process and archive the backup data on a weekly basis.
• Used the Windows Task Manager to execute all relevant Window shell scripts for the Backup/Recovery process.
• Responsible for the SQL Server Database tasks required to support Oracle’s EPM Application Suite used at KLX.

Confidential

Oracle Enterprise Performance Management (EPM) Consultant

• Responsible for integrating Oracle’s HFM ODI, FDM and ERPi Applications with Starwood’s SAP Financials implementation (IBM i Series using DB2) as part of the Confidential Account Team.
• Responsible for the primary objectives of this project was to migrate their existing practice of using SAP extracts to populate Microsoft Access Databases where custom macros were executed to transform and map the SAP data into flat files that were then feed into KEDIT macros to a process that would be centered around FDM then eventually ERPi would be used to pull data from SAP, transform that data using FDM, load the data into HFM and automate the process as much as possible. (Agile)
• Responsible for Analysis and Review of the existing Financial Close process including methods and procedures used to move data from their SAP Financial Application into HFM.
• Responsible for technical tasks to install, setup and configure, and implement the Oracle ODI application architecture to access SAP and pull data into ERPi (configure the ODI technology to support the logical and physical models to access SAP and map the data in ERPi).
• Responsible for the FDM Mappings and Shared Service security.
• Worked very closely with the Confidential teams responsible for providing System Support for Starwood’s SAP environment including the BIAS team. Provided direction and technical expertise to facilitate the installation, configuration, and data access required on the IBM I Series server to support Oracle’s ODI/ERPi applications.

Confidential

Senior Architecture Hyperion Essbase

• Responsible for providing expertise and advise Confidential ’s on their Oracle PBCS and Oracle Hosted HFM Applications.
• Responsible for reviewing architecture, application design, infrastructure, performance, and providing expert advice for Best Practices focused on Disaster Recovery methodologies, architecture, and implementation.
• Reviewed Problem Resolution methodology including metrics designed to track problem assignment, time to resolve, solution quality, track user and business owner quality metrics, identify trends, and propose action to improve and resolve service issues.
• Review Application and Middleware patching strategies including Oracle’s roadmaps for EPM releases and Operating System maintenance and update strategy.

Confidential, McLean, VA

Senior Oracle DBA/Lead/Manager

• Responsible for migrating Hilton’s Oracle Databases and Oracle Applications multiple times. First to IBM’s Data Center in Raleigh known as the RTC and then to Dell’s Data Center in Florence, KY. During this project, all the environments were first installed and built in IBM’s Raleigh Data Center and then again in Dell’s Florence, Kentucky’s Data Center.
• Provided Oracle Database performance tuning and analysis for the PeopleSoft, Hyperion and Data Mart environments including but not limited to the AR Update, nVision Reports, the Payroll Process (CALC and Confirm), Journal Generator and Post, PeopleSoft Query, SQR programs
• Responsible for PeopleSoft Instance consolidation from two PeopleSoft Finance Instances to one Global Unicode PeopleSoft Financial Instance
• Responsible for PeopleSoft FSCM Upgrade from PeopleSoft 8.9 to 9.1, PeopleSoft HCM upgrade from 8.9 to 9.1, Hyperion Financial Management 11.1.2.2 and Hyperion Planning 11.1.2.2.
• Responsible for architecture, design, implementation of multiple Enterprise Class Data Marts using Oracle’s BI Application Suite and MicroStrategy for Executive Dashboards and Mobility.
• Performed platform reimplementation migrating Hilton’s existing PeopleSoft Financial Instances and PeopleSoft HCM from a SQL Server environment to a Linux and Oracle RAC platform using EMC VNX Series Storage Systems.
• Responsibility for architecture, design, installation and configuration of Oracle Enterprise Management 10gR1, 10gR2, 11gR1, 11R2 and then12cR2 Cloud Control and deployed over 300+ Agents on Windows and Linux servers.
• Responsibility for architecture, design, installation and configuration of 20+ Oracle Real Application Clusters 11gR2 for PeopleSoft Financials, HCM, Hyperion Financial Management, Hyperion Planning and Enterprise Data Marts.
• Responsible for overall ASM Architecture and implementation including analyzing and forecasting disk usage. ASM was used for all Oracle Database environments RAC and non-RAC.
• Performed Linux administrator (root) tasks to support Oracle software installation including native Linux multipath configuration (using native Linux multipath and EMC’s PowerPath, disk partitioning, and execution of root scripts.
• Responsibility for Database Backup and Cloning Strategy including writing the RMAN backup scripts and crontab shell scripts used to automate the cloning and backup processes. Used AutoSys for all daily, weekly, monthly, and one-off NetBackup task executions that used RMAN for Disk and Tape Backups.
• Leveraged EM 12c to produce AWR Reports, ASH Reports, generated SQL Tuning Profiles, SQL Workloads and monitored all managed RAC and non-RAC Oracle Databases along with Middleware components.
• Responsibility for architecture, design, configuration, and installation for High Availability (HA) EPM Hyperion HFM and Hyperion Planning environments (Foundation, Shared Services, Workspace, WebLogic, EPMA, Lifecycle Management (LCM), FDM, Security, FR Reports…)
• Responsible for scripts and process to identify Essbase fragmentation, update the statistics, and scripts to export and reload the Essbase cubes to remove fragmentation to ensure optimal performance.
• Reviewed and approved Standard Operating Procedures, Use Cases, Business Domain Models, Deployment and Operating Models, participated in Internal and External Audit Reviews
• Responsible for Change Management and Release Strategy including Application and Infrastructure Patching
• Responsible for PeopleSoft Security Model for FSCM and HCM including redesign of Permission Lists, Roles, Process Definitions and Portal Security. Familiar with Internal and External Auditing procedures involving Enterprise Security including PeopleSoft Applications, EPM (Hyperion Suite), PeopleSoft Portal, Data Integration products like Oracle’s Oracle Data Integrator and Informatica. Developed SQL Scripts to generate reports to use for understanding existing Security and to drive the design for the new Security Models based on Job Roles, Processes and Areas of Responsibility by Domain and User.

Confidential

Senior Oracle DBA/Lead/Architect

• Responsible for upgrade of Oracle Database from 9i to 10g RAC and then to 11G RAC
• Responsible for PeopleSoft Financials and PeopleSoft HCM environments along with providing DBA support for Kronos (Timekeeper feed to PeopleSoft for Payroll Processing), Hyperion Financial Management and Planning as well as various ancillary applications that supported the car rental operations and business for Alamo, National, and Enterprise.
• Implemented Oracle Enterprise Manager 10 and then 11 to manage all Oracle Databases deployed on Linux, Windows, HP-UX, and AIX hardware platforms.
• Responsible for performance tuning of all complex PeopleSoft HCM and Financial Batch Processes such as ARUPDATE, Payroll CALC, and Confirm, Journal Edit and Post as well as complex nVision Reports and extracts for Hyperion HFM version 9 and Essbase cubes.
• Responsible for all tasks related to upgrading Hyperion Enterprise HFM from Enterprise (v6) to version 9.
• Responsible for design, architecture, and interfaces that extracted data from the PeopleSoft Financials environment and populated the Hyperion HFM application and Essbase cubes.
• Responsible for hardware server selection, Operating System (HP-UX, Red Hat Linux and Oracle Linux), network topology to support Oracle RAC and non-RAC databases, software architecture and installation for PeopleSoft HCM and FSCM environments and Oracle Installations - RAC and non-RAC databases
• Implemented Oracle’s ASM software as soon as it was available in Oracle 10g and transitioned from using Raw Devices to ASM. All Storage was provided by EMC’s DMX Storage Fabric.
• Responsible for Application and Database Backup, Recovery, and Disaster Recovery Strategies.
• Coordinated and participated in annual Disaster Recovery exercise at Sun Guard’s facility in Philadelphia
• Migrated PeopleSoft HCM and FSM, Kronos TCS and various legacy applications using Oracle Database technology from Alamo and National’s Data Center in Fort Lauderdale to Perot’s Data Center in Plano, Texas
• Responsible for determining Oracle’s Optimizer CBO strategy for tuning the PeopleSoft FSCM, HCM, and Data Warehouse Oracle RAC and single-instance databases.
• Reimplementation of PeopleSoft Financials 7.02 to PeopleSoft 8.9, Hyperion Enterprise Upgrade to version 9.x, and several PeopleSoft HCM upgrades including PeopleTools on platforms ranging from Linux Oracle RAC based databases, HP Itanium Blades, HP Super Domes, Oracle 11g and PeopleTools 8.49.
• Completed a separate PeopleSoft Upgrade of Enterprise Car Rental’s Financials 8.3 environment to PeopleSoft 9.0, PeopleTools 8.49 and Oracle 11gR1 and subsequent upgrade to 11gR2. Production, QA, and Development PeopleSoft FSCM, HCM, and Data Warehouses ran on Linux Oracle RAC Databases. Other PeopleSoft Databases like the Delivered, Demo, Reference, Training, and PeopleSoft databases used for version control ran on Linux single-instance platforms.
• Responsible for Backup and Recovery strategies including Sun Guard’s Services for Disaster Recovery used for the critical Business Applications such as the Reservations System and PeopleSoft Payroll applications.
• Designed and implemented RMAN backup and recovery scripts for all Oracle Databases.
• Designed and implemented RMAN Duplicate scripts to clone PeopleSoft Development, QA, Training, User Acceptance Testing Databases for PeopleSoft Financials, HCM, and the Data Warehouse.
• Served as the resident PeopleSoft Enterprise Architect specializing in Oracle Cluster Databases and Tuning for Confidential .

Confidential, Ft. Lauderdale, FL

Technical Consultant/Architect

• PeopleSoft HRMS8.0 SP1/Kronos/PeopleSoft Financials
• (National and Alamo Car Rental Companies);
• Responsible for providing technical support for PeopleSoft 8.0 SP1 HRMS, Kronos’s Timekeeper Central System, PeopleSoft Financials 7.02 and planning future upgrades. Migrated Kronos application to an IBM HACMP Cluster consisting of two IBM p660 RS6000 AIX Serves connected to an EMC 3930 Storage Array to provide high availability for the Kronos’s Timekeeper Central System. Other responsibilities include planning and implementing Kronos’s Oracle migration from 7.3.4 to 8.1.7 Release Kronos Release 3.4, installation of Kronos’s Smart Scheduler Product Suite including importing data from the Internal Revenue Management System into Kronos for producing Schedules, design review and support for upgrading existing and new interfaces to import/export data between PeopleSoft and Kronos.
• Responsible for leading the migration and upgrade of the PeopleSoft Financial systems from 7.02 to 8.9, implemented new EMC Storage Arrays (DMX) and new HP/UX UNIX Servers.
• Implemented new PeopleSoft Security Models for both PeopleSoft HCM and FSCM introducing completely redesigned and organized Permission Lists, Roles, Process Definitions and Portal Security.

Confidential

Technical Architect/DBA Consultant

• Technical Architect/DBA Consultant for Production Support for a Healthcare Provider
• Provide Oracle, Informix and application architecture expertise.
• Responsible for capacity planning, tuning, backup and recovery support for several Enterprise Class applications running on IBM S80 RS/6000 AIX Servers.

Confidential

Technical Architect/DBA Consultant for Production Support for a Healthcare Provider

• Provide Oracle, Informix and application architecture expertise. Responsible for capacity planning, tuning, backup and recovery support for several Enterprise Class applications running on IBM S80 RS/6000 AIX Servers.

Confidential, Delray Beach, FL

Technical Architect / Consultant

• Responsible for PeopleSoft 8.3 HRMS and Financials 8.4 Architecture and Implementation of HRMS, Financials, and Portals on an IBM S/390 running DB2. Provided support to PeopleSoft during initial installation on the S/390. Served as Architect for assessment, requirements, design, and implementation phases. Responsible for PeopleSoft Internet Architecture including network design and implementation to handle load balancing, transparent Web and Application Server failovers and redundant NT and MVS network connections.

Confidential, Miami, FL

Technical Oracle Architect/Consultant

• Responsible for PeopleSoft Oracle Database architecture, performance tuning, PeopleTools upgrade, PeopleSoft Maintenance upgrades, implementation of patches, upgrades and overall design architecture for PeopleSoft Financials.
• Responsible for architecture and implementation of network security, intrusion detection software, network inventory, polling and monitoring software. Responsible for migration and consolidation of existing enterprise software applications to IBM’s S80 RS/6000 architecture, deploying Linux based servers, Web Development
• Application projects and introducing multi-tiered architecture for new software development projects. Responsible for supporting multi-platform database engines such as Informix, Oracle 7, 8i and 9i along with Microsoft SQL Server. Responsible for all IT contract negotiations, budgets, and worked with the Board of Directors on major acquisition purchases including other companies and imaging centers. Responsible for negotiating all hardware and software purchases including leases with major hardware and software vendors.
• Designed a new data center, oversaw all contractor, construction, migration and network-related cutover activities to support the company’s relocation and consolidation from three separate corporate office locations. Successfully integrated Medic Computer Systems’ Vision Application (Accounts Receivable) with GE’s ProgRIS (Fully integrated Radiology Information Systems package used for Centralized Scheduling, Transcription, Digital Imaging, etc.).
• Automated electronic submission of claims using HL7 to Medic’s centralized clearing facility for automatic claims submissions and electronic payments. Redesign of network from a mixture of point-to-point T1 connections to a fully redundant Cisco-based Frame Relay Multi-Service network carrying voice and data.