PROFESSIONAL SUMMARY:

Hands on technology professional with over twenty 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 .

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, Ultrix, Digital Unix, Sun OS, Windows Data Center Servers, Fedora & Ubuntu

Hardware: Solaris Confidential and Intel Servers, IBM Mainframe, IBM AIX and Linux Servers, HP HP/UX and Linux Servers, SUN Enterprise Servers, Tandem, DEC, Stratus, EMC 3930, 8830, EMC VNX 7500 (SAS 600 GB 15k RPM) SAN, Hitachi Multi-Tiered Storage (incl Solid State Disks)

Oracle Features: Oracle RAC 10,11,12, Enterprise Manager 12c, Data Pump, STATSPACK, TKPROF, Data Migration, RMAN, Partitioning, Replication, Data Guard

PeopleSoft: People Tools 8.49/8.45/7.63/7.02 , PeopleSoft FSCM & HCM 9.2/9.1/9.0 MP4/8.8, PeopleSoft HRMS/Payroll 7.02/7.5/8.3/8.8/9

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

RDBMS: Oracle 7,8,9,10,11gR1/11gR2/11gR2/12cR1 - RAC(32/64bit)/10g/10g11 and 12c RAC Clusters, SQL Server 2000/2005/2008/2012

Methodologies: SDLC, Agile, Lean Six Sigma

Applications: IBM’s Rational Suite, AutoSys, Hyperion EPM Hyperion Financial Management 11.1.2.2 and Hyperion Planning 11.1.2.2, 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)

Languages: Linux Shell Scripting - bash, zsh, Perl

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Database Consultant/Architect

Responsibilities:

• Hardware Platform consisted of Oracle Solaris Confidential T-5 Servers running Oracle Solaris 11.3 and Oracle Solaris Zones using Hitachi Storage Subsystems including Solid State Disks offering 3 Storage Tiers and using ZFS as the file system.
• G6 (Motel 6) had a co-location facility that served as their failover solution for critical applications including EBS and their Oracle OBIEE / BIAPPS Production environment. The QA Data Warehouse Environments were hosted at the co-location facility and in the event of a failure at their primary data center this was the environment that would assume Production responsibilities.
• Responsible for Performance Tuning Motel 6's Multiple Data Warehouses, ODI, and OBIEE environments - Development, QA, and Production.
• Oracle 12c was the database platform for all the environments, RMAN and Data Pump were used for the Backup and Schema exports, Enterprise Manager 12c was used to help manage, monitor, and tune the various environments.
• Moved a Custom OBIEE Data Warehouse database schema into client's BIAPPS Data Warehouse (separate schema but shared RPD).
• Responsible for all performance Tuning for the OBEE Middleware (WebLogic) for Development, QA and Production environments
• Designed and implemented Data Pump Data Warehouse Schema refreshes
• 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. New Oracle 12c Initialization Parameter and addressed issues with Automatic Query Optimization. Implemented Oracle Shared Memory to optimize Oracle’s use of shared memory and determined best set of initialization parameters to sustain high level of performance for EBS Nightly Loads and Complex OBIEE Query Performance.
• Analyzed RMAN Backup process and provided performance tuning recommendations that once implemented streamlined and improved backup performance and efficiency.
• 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 OBIEE Reports using Enterprise Manager 12c and wrote shell scripts to export to export the Production SQL Tuning Profiles and import the SQL Tuning Profiles into Development and QA.
• Updated 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.
• Performed analysis of the Web Logic and Middleware Tiers, ODI, Solaris, ZFS, Network, and Database layers compared to Oracle’s Best Practices standards for each layer and generated a document outlining recommendations to tune each component.
• 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.
• Performed an analysis of the ZFS configuration and thus optimized ZFS to conform to Oracle’s best practices for using ZFS for Oracle Database objects across the storage fabric.

Confidential

Oracle Enterprise Performance Management (EPM) Consultant

Responsibilities:

• Responsible for supporting the Oracle Enterprise Performance Management Applications for the Global Financial Planning and Analysis user community
• Confidential 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 Confidential ’s FP&A requirements.
• One of my responsibilities is to review the existing COA and prepare Confidential 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, Lifecycle Management, and Hyperion Financial Management Applications
• Designed and implemented a Backup/Recovery process for the HFM Applications and Shared Services metadata.
• 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.
• Use 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 Confidential

Confidential

Oracle Enterprise Performance Management (EPM) Consultant

Responsibilities:

• Member of Confidential ’s Starwood Hotels account team responsible for integrating Oracle’s HFM ODI, FDM and ERPi Applications with Starwood’s SAP Financials implementation (IBM i Series on DB2).
• Starwood’s HFM application uses SQL Server 2008 and consists of Development, Test, and Production environments running on virtualized Windows 2008 R2 machines.
• One of 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.
• 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

Responsibilities:

• Providing expertise on Confidential ’s Oracle Cloud Management Service platform and installation.
• Responsible for reviewing architecture, overall design, performance, and advising on best practices for Disaster Recovery and Problem Resolution.
• PeopleSoft Instance consolidation from two PeopleSoft Finance Instances to one Global Unicode PeopleSoft Financial Instance
• 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.
• 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.
• In addition, to the aforementioned application projects Hilton decided to outsource their Data Center to first IBM and then Dell. During the course of this project all of the environments were first installed and built in IBM’s Raleigh Data Center and then again in Dell’s Florence, Kentucky’s Data Center.
• 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.
• 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.
• Performed Linux administrator 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.
• 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) Hyperion HFM and Hyperion Planning environments (Foundation, Shared Services, Workspace, WebLogic, EPMA, Lifecycle Management (LCM), FDM, Security, FR Reports…)
• 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

Responsibilities:

• 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 as well as various ancillary applications.
• Responsible for upgrade of Oracle Database from 9i to 10g RAC and then to 11G RAC
• Implemented Oracle Enterprise Manager 10 and 11
• Responsible for tuning Complex PeopleSoft HCM and Financial Batch Processes such as ARUPDATE, Payroll CALC and Confirm, Journal Edit and Post as well as nVision Reports and extracts for Hyperion HFM version 9
• 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 Arrays.
• Responsible for Application and Database Strategies using NetBackup.
• 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 CBO strategy for PeopleSoft and Data Warehouse 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 11g R1.
• Served as the resident PeopleSoft Enterprise Architect specializing in Oracle Cluster Databases and Tuning for Confidential Corporation.

Confidential, Ft. Lauderdale, FL

Technical Consultant/Architect

Responsibilities:

• 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

Responsibilities:

• 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

Responsibilities:

• 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

Responsibilities:

• 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.