SUMMARY:

• I am a Senior IT Professional with extensive experience working with Information Systems.
• I have proven expertise in the installation, configuration, implementation, upgrade, tuning, and support of Oracle and PeopleSoft Enterprise applications including Financials, Human Resources, Enterprise Performance Management, Employee Portal, and Customer Relationship Management having supporting Oracle Databases and PeopleSoft Environments..
• I have also been providing Fusion Technical Support for Clients performing: Data Mapping to Fusion Objects, Oracle Fusion File Based Loader (FBL) data loads, HCM Data Loader (HDL), and Oracle Business Intelligence Reporting for 4 years.

EXPERTISE AREA:

• Oracle 7/8/8i/9g/11gr2
• Application Server
• Process Scheduler
• Web Server
• Application Designer
• Change Assistant
• PeopleCode/SQR/Application Engine
• Oracle Tuning/Sizing and Upgrades
• PeopleTools Upgrades
• Installations
• Fusion Tech. Support R5//7/9/10
• HCM Data Loader (HDL)
• PeopleSoft Tuning
• Oracle Business Intelligence
• PeopleSoft DPK
• Maintenance Pack Upgrades
• Fusion File Based Loader
• PeopleSoft PUM / PI

TECHNICAL SKILLS:

• PeopleTools
• PeopleCode
• SQR
• Cobol
• Crystal Reports
• nVision
• Query
• Application Designer
• Oracle 9i/10g/11g
• Oracle SQL Developer
• Oracle SQLPlus
• AIX, HP - UX, Solaris, Linux
• Tuxedo
• WebLogic
• Windows XP, NT, 200x
• Unix VI Editor/Scripting
• Toad
• HCM Data Loader (HDL)
• Oracle Enterprise Mgr
• Fusion File Based Loader (FBL)
• Oracle Business Intelligence

PROFESSIONAL EXPERIENCE:

Confidential

Oracle & PeopleSoft DBA

Responsibilities:

• Chicago Tribune move to Workday from PeopleSoft required a significant Data Archiving Effort to retain data for reporting.
• Oracle 8i Database Backups (Export) and Oracle 11gR2 (Import) of Oracle PeopleSoft Financials and HCM Databases off Sun Solaris to Windows 2012 R2.
• Nine Databases moved, approximately 900GB each, from older versions of Sun Solaris and Oracle Database 8i to Windows 2012 R2 Servers Oracle 11gR2.
• SQL Scripts were executed to extract database sizing from the Sun Solaris Oracle Databases prior to rebuilding them on Windows 2012 R2 Servers. PeopleSoft Software Installs on Windows 2003/2007.
• Oracle Backups (EXP) and Restores (IMP) to Windows 2012 R2 Project was due to a move off PeopleSoft to Workday.
• PERL Scripting used to Start/Stop Oracle/PeopleSoft Applications on Virtual Windows.
• Oracle Client and PeopleSoft Software Installs on Windows 2003/2007 for PeopleSoft Financials and Human Capital Management. Older versions of PeopleSoft not available from Oracle/PeopleSoft.

Oracle DBA / PeopleSoft Administrator

Confidential

• Oracle Database 11gR2 Unicode implementation for Multi - Lingual support (9 Additional Languages).
• Oracle Backups and Restores moving Production Database and recovering to Test/UAT/Dev environments
• PeopleSoft 9.1 FSCM 9.1 Multi-Lingual Installation and Manual Upgrade FSCM 9.0 AM/GL into 9.1 Implementation
• Oracle Administrator performing all installations on Virtual Windows 2008/Linux 5.7 Servers. Datacenters located in Europe.
• PERL Scripting to Start/Stop Oracle/PeopleSoft Software on the Virtual Windows 2008/Linux 5.7 Servers.
• Oracle Exports and Imports from Oracle SQL Scripting to convert Oracle/PeopleSoft Chart Fields for Asset Management(AM)/General Ledger (GL) manual upgrade.
• Performed all PeopleSoft DBA related tasks in regards to the installation / upgrade / project migrations.
• Analyzing program Oracle SQL performance issues; capturing Oracle SQL statements being executed; recommending and implementing performance improvements: SQL Code Modifications/SQL Hints; Cost Base Analyzer Statistics; Index Additions.

Oracle Fusion Technical Lead Support

Confidential

• While working for Confidential, Inc., the Director of IT at DPS called me for a Part Time contract with Confidential /DPS to help identify and resolve severe Oracle Database performance issues following Oracle/PeopleSoft Upgrade. Oracle 11.2.0.4 / PeopleSoft HCM 9.1 / PeopleSoft FSCM 9.1 / PeopleTools 8.53.

Confidential

Technical Lead Oracle DBA & PeopleSoft Administration

• Client on older versions of Oracle 8.1.7 and PeopleSoft.
• Production and Development Support, troubleshooting Performance Issues.
• Client has experienced Oracle Online and Batch Severe Performance Issues for last number of years (8) resulting in database lockups lasting for 40 minutes or more in the FSCM and HCM production databases. HCM Payroll experienced lockups for 15 to 20 minutes during CalcPay and Confirm payroll batch COBOL Programs.
• Previous DBAs performed hard shutdown/abort/restart of the databases to resolve these database lockups.
• Monitored Databases and researched locking issues using Quest/Toad Software. Oracle tables and indexes in the database files were in an Oracle Storage Wait (ST) Lock Status, meaning the files were attempting to extend but were unable to do so with good performance.
• Database DBA DATA FILES were set to auto-extend although next extent values were set At 1 Oracle Block (8K). The combination of Dictionary Managed Tablespaces (DMT), not Locally Managed Tablespaces (LMT), and the next extent set to 1 physical Oracle Block resulted in the severe storage waits, database lockups, and the hard shutdown/abort of the databases to resolve..
• InitiallyExtended tablespace files to allow for growth which prevented database lockups for file extension. Then modified the next extent for the files experiencing the (ST) locks to 16M.
• Extending the file sizes and modifying the next extent resolved the severe database locking. Ultimately data and index tablespaces were converted to LMT and the databases were then upgraded to 9i using LMT for all tablespaces including the SYSTEM tablespace. Database locking was resolved and response time was improved dramatically.
• Oracle Upgrade from 8.1.7 to 10g
• W2 Load Program TAX910LD.sqr has been running for 24+ hours for the past 7 years. Tuned the program/tables/indexes and program now runs typically in under 10 minutes. Other online and batch tuning efforts were successful also increasing performance.
• Tuning Efforts resulted in: Oracle SQL Hints in PeopleSoft PeopleCode, Structured Query Reports (SQR), PeopleSoft Application Engine Programs, Adding Indexes, and Updating Object Statistics.
• Responsible for post PeopleTools 8.49.18 upgrade support.

Confidential, Northville, MI

Oracle DBA & PeopleSoft Administrator

• Installing Oracle Database and Client Software for HP/PeopleSoft ASP Clients.
• Database upgrades from 8i to 9i to 10g
• Telecommute/Work From Home Project for 4 Years.
• Performing as Oracle DBA and PS Administrator for all Prod/Test/UAT/Dev/Demo environments

Confidential, Northville, MI

• Contracted through a preferred vendor, ComSys, Inc. in St. Louis, MO..
• End client was Express Scripts, Inc.
• In house implementation/migration out of the HP eCenter ASP Oracle Databases and PeopleSoft Application to Express Scripts datacenter.
• Installed PeopleSoft and all 3rd party software for production, test, development, demo, and disaster recovery.
• Tuxedo 8.1 RP 309; Weblogic 8.1 SP7 with jrockit patch; PeopleTools 8.46 with patch 8.46.11; HRMS 8.9 MP3.
• Oracle 9i Client and Oracle 9i Database Software installed and configured on Linux Redhat 4.0 and Windows 2003 Servers

Oracle DBA & PeopleSoft Administrator

Confidential, Northville, MI

• Contracted through a preferred vendor, Redwood Solutions, Livonia, MI. Performed as Primary Productionand emergency/development database administrator.
• Database servers were Compaq AlphaServer GS60E 6/700 with 8 cpu’s and 8 gig of memory. Three servers containing 8 instances.