Resume of John A. Hayes
Mr. Hayes is a senior systems professional with over 20 years of overall IT experience with the past 10 years as a PeopleSoft Consultant. He has extensive skills working with PeopleSoft (DB2, Oracle, SQL Server) and Client/Server Enterprise systems. John has a wide applications integration experience and can perform as a Technical Architect, Database Administrator. He has also worked extensively with PeopleSoft upgrades and new implementations; and has a solid background in configuration and change management.
|
SPRINT/NEXTEL, EMBARQ |
OVERLAND
PARK, KS |
10/05
to 7/07 |
Installed,
configured and maintained web servers, application servers and process
schedulers. Applied Tuxedo/Jolt patches, and JVM updates.
Was part of team on creation/copy of
Sprint Financials system to Embarq Financials system. Reinstalled all
environments on new hardware as part of the split from Sprint/Nextel. Provided strategy, design, and testing
methodologies. Analyzed any performance issues problems and provided technical
solutions. Performed day-to-day problem resolution and troubleshot system
failures/abnormalities. Performed mainframe JCL migrations and processed
jobstreams.
Environment:
PT 8.42, DB2/OS390, Financials 8.4 – AM, BI, DM, ePro, GL, IN, PR, PU, PY, sPro
|
NORTON HEALTHCARE INC |
|
9/05
to 10/05 |
Reviewed the current Production environment setup/configuration and performed performance tuning and troubleshooting. Conducted stress test of Production environment in preparation for rollout of eBenefits to all active employees (9000). Created and sized parallel Production environment to support 600 concurrent users. Setup and tested load balancing and failover. Prepared executive summary report detailing setup, configuration, hardware sizing, etc.
Environment:
PT 8.44, SQL Server, HCM 8.4
|
NSS/ADVANCE MAGAZINE GROUP |
|
2/05
to 6/05 |
Responsible for the day-to-day management of PeopleSoft
8.8 Financials and HRMS technical environments. Responsibilities included technical
administration of web servers, application servers and process schedulers;
object and data management for all PeopleSoft environments; application
performance tuning; and application of patches and updates. Applied PeopleSoft patches
and updates, coordinating and prioritizing the application of patches with the
functional teams. Coordinated performance troubleshooting (acting as the required
single point-of-contact for a multi-disciplinary approach). Worked very closely with the DBAs during
instance restore/refresh efforts and acted as a subject matter expert on the
technical aspects of the PeopleSoft application.
Environment:
PT 8.44, Oracle, FSCM 8.8, HCM 8.4
|
|
|
8/04
to 12/04 |
Performed Financials upgrade from version 7.5 to version
8.8 utilizing the Upgrade Assistant. Identified and
applied updates and fixes utilizing Change Assistant. Installed, configured and maintained integration
brokers, web servers, application servers and process schedulers. Modified
Application Engine data conversion programs, wrote SQL scripts and SQR programs
to support upgrade/conversion process. Mentored and consulted on methodologies,
practices and tools usage for development team. Provided strategy, design, and
testing methodology. Analyzed any upgrade problems and provided technical
solutions. Performed performance tuning and troubleshooting.
Environment:
PT 8.45, SQL Server, FSCM 8.8 – AM, BI, CN, GL, AP, AR,
|
CDW CORPORATION |
|
3/04
to 7/04 |
Performed Financials 8.4 installation and applied
maintenance packs. Installed, configured
and maintained integration brokers, web servers, application servers and
process schedulers. Performed PeopleTools upgrades from 8.43
to 8.44. Applied Tuxedo/Jolt patches, Weblogic Service
Packs and JVM updates. Identified and applied updates and fixes
utilizing Change Assistant. Opened and
resolved cases with PeopleSoft. Provided strategy, design, and testing
methodologies. Analyzed any performance issues problems and provided technical
solutions. Performed day-to-day problem resolution and troubleshot system
failures/abnormalities. Reinstalled HRMS 8.0 Demo environment. Applied
Tax updates and performed upgrade to HRMS 8.3.
Performed compare between Demo and Production environments.
Environment: PT 8.44,
SQL Server, Financials 8.4 SP1, HRMS 8.3
|
AMERICAL MEDICAL SECURITY |
|
8/03
to 2/04 |
Installed, configured and maintained web servers,
application servers and process schedulers. Performed
PeopleTools upgrades from 8.42 to 8.44. Applied
Tuxedo/Jolt patches, Weblogic Service Packs and JVM updates. Installed 3rd-party applications. Configured
Correspondence Management for CRM. Opened and resolved cases with
PeopleSoft. Provided strategy, design, and testing methodologies. Analyzed any
performance issues problems and provided technical solutions. Performed
day-to-day problem resolution and troubleshot system failures/abnormalities. Customized TuxConsole application for AMS.
Environment: PT
8.43, SQL Server, Financials 8.4 SP1, HRMS 8.8, CRM 8.8, Portal 8.8
|
EMPIRE DISTRICT ELECTRIC COMPANY |
|
7/03 |
Performed Financials application
upgrade from version 7.5 to version 8.4 utilizing the Upgrade Assistant.
Performed PeopleTools upgrade from 7.5 to 8.42.09.
Installed, configured and maintained web servers, application servers and
process schedulers. Modified Application Engine data
conversion programs. Wrote SQL scripts and SQR
programs to support the upgrade/conversion process. Opened and resolved
cases with PeopleSoft concerning upgrade issues. Mentored and consulted on
methodologies, practices and tools usage for development team. Provided
strategy, design, and testing methodologies. Analyzed any upgrade problems and
provided technical solutions. Performed performance tuning
and troubleshooting for both HRMS and Financials.
Environment: PT
8.42, SQL Server, Financials 8 SP3, HRMS 8
|
ALTA RESOURCES, INC. |
|
6/03
to 7/03 |
Performed CRM application upgrade from
version 8.4 to version 8.8 utilizing the Upgrade Assistant. Performed PeopleTools upgrade from 8.42.04 to 8.42.09 for CRM 8 and
Portal 8.8. Installed, configured and maintained web servers,
application servers and process schedulers. Modified
Application Engine data conversion programs. Wrote SQL
scripts and SQR programs to support the upgrade/conversion process.
Opened and resolved cases with PeopleSoft concerning upgrade issues. Mentored
and consulted on methodologies, practices and tools usage for development team.
Provided strategy, design, and testing methodology. Analyzed any upgrade
problems and provided technical solutions. Performed
performance tuning and troubleshooting.
Environment: PT
8.42, SQL Server, CRM 8, Portal 8.8
|
|
|
11/02
to 04/03 |
Performed
upgrade from version 7.6 to version 8 utilizing the Upgrade Assistant.
Installed, configured and maintained web servers, application servers and
process schedulers. Modified Application Engine data
conversion programs. Wrote SQL scripts and SQR
programs to support upgrade/conversion process. Mentored and consulted
on methodologies, practices and tools usage for development team. Provided
strategy, design, and testing methodology. Analyzed any upgrade problems and
provided technical solutions. Performed performance tuning
and troubleshooting.
Environment:
PT 8.18, SQL Server, LS 8 SP1 - CC, SA, SF, SR - HRMS 8 SP3 - HR, BB, PY, ST
|
|
|
7/01-10/02 |
Performed upgrade of Financials and HRMS from version 7.02 to version 8. Performed server sizing for Windows 2000 servers (27 production servers). Installed and configured PeopleTools upgrades, web servers, application servers and process schedulers. Performed load balancing/testing with LodeRunner. Authored TuxConsole application to manage/monitor/log application servers and domains. Worked with the DBAs on performance tuning and troubleshooting. Served as 3rd level lead technical support person. Responsible for opening and resolving cases with PeopleSoft. Wrote SQR process to purge expired reports from report repository and to clean up the process request tables. Worked with functional leads in implementing divisional and regional reporting process and allocations from external data sources into PeopleSoft.
Environment:
PT 8.18, DB2/OS390, Financials 8 SP3 -
|
PEOPLESOFT, INC |
|
4/01-6/01 |
Worked in the GSC support center for HRMS division. Worked with customers on resolving cases with versions 7.02 to 8 on all platforms and HRMS modules. Large bulk of cases was version 8 upgrade script problem resolution. Resolved tax update, position management, pay step and multi-currency issues. Environment: PT 7.02 - 8.12, All Supported RDBMs, HRMS (all modules)
COUNTY OF ALAMEDA |
|
12/00-3/01 |
Served as a technical consultant for Accenture providing
installation support for SQL Server and DB2 environment.
Revised existing development standards to include changes
between version 7.5 and 8.0 by documenting differences in Application Designer,
PeopleCode and SQR. Provided naming standards and
programming standards for new development objects. Evaluated various
change control vendors and provided change control methodology for HRMS v8
Environment:
PT 8.12, DB2/OS390, HRMS 8 - HR, PI, BB, TL
|
TÉLÉGLOBE |
|
8/00-11/00 |
Harvest Implementation Consultant - Performed integration of Téléglobe applications (approximately 50 applications) in CCC/Harvest (enterprise change management). Wrote UDPs (user defined processes) for nonsupported platforms utilizing Perl and SQL scripts. Implemented custom security and management reports. Provide mentoring on CCC/Harvest administration and database administration. Provided mentoring on CCC/Harvest reporting capabilities.
Environment:
Windows NT, Unix
|
NORTHEASTERN UNIVERSITY |
|
6/99-8/00 |
Performed
pre-conversion to post implementation of PS HRMS/SA 7.5.
Developed internal Release Tracking System (RTS) with
PeopleTools. Identified and applied updates and fixes. Performed mod migrations to various instances and environments.
Performed data conversion from legacy to PS utilizing Convoy.
Develop and test interface programs and reports using SQR. Customize panels,
records and menus using PeopleTools. Served as Harvest change
control administrator. Gathered response times
statistics for various departments and processes and performed database tuning.
Assisted in data loading using XML. Provided
technical support to other developers.
Environment: PT
7.54, AIX, DB2/UDB, HR, SA, SR, SF
|
20th CENTURY FOX FILM CORP. |
|
6/97-4/99 |
Installed and configured HRMS 7.0/7.5 plus individual modules after initial installation (Time & Labor, Benefits Administration). Setup job-scheduling process utilizing AutoSys. Performed data conversion from legacy to PS utilizing SmartDB. Composed Development Standards. Authored Migration Procedures. Applied Updates and Fixes, Tax Updates. Implemented 3-Tier (Configured Application Servers (logical and physical) and Process Schedulers). Configured remote sites. Served as knowledge resource for developer and functional leads. Wrote numerous SQRs and SQL scripts to support Systems Administration/Development activities. Performed DBA activities. Also assisted Financials 6.0 in implementation and ongoing technical support.
Environment: PT
7.51, Unix, Oracle, HRMS 7.5 - HR, PR, PI, TL, BB, GL
TECHNICAL
ENVIRONMENTS
Windows 2000/2003 Server/Advanced Server, Windows NT Server, Sun Solaris,
OS/MVS/JES2, VM/SP, VSE/SP, DOS/VSE/POWER, CICS/ICCF, TSO/ISPF, CMS, Data
Manager, OWLE, RMDS
Windows NT/95,98/2000/2003/Windows For WorkGroups/Windows (v2.0-v3.11), OS/2
LAN Server, OS/2, (v2.10-v6.22), PeopleSoft HRMS 6.0-8.8, PeopleSoft Financials
6.0-8.8, PeopleSoft CRM 8.0-8.8, PeopleSoft Portal 8.0-8.8, HR-1
(Repertoire/Encore), ADP, JD Edwards, Tesseract, SQR, SQL, LoadRunner, Harvest,
SmartDB, AutoSys, Convoy, QMF, SPUFI, VSAM, JCL, COBOL, DYL280, DITTO, FOCUS,
REXX, Visual Basic, PCL, PVCS, Stat!, Visual SourceSafe, Oracle, DB2, SQL
Server, IMS, Advanced Revelation, XDB
1984 Diploma Computer Science.
1997-1998 PeopleTools I,
PeopleTools II, Data Administration, SQL/SQR for PeopleSoft, PeopleCode,
PeopleSoft Security -