ENVIRONMENTS

• Microsoft NT
• UNIX
• RS6000
• IBM
• Toshiba

DATABASES

• Oracle
• Sybase
• SQLBase
• DB2
• IMS
• IDMS
• MS Access

SOFTWARE

DEVELOPMENT TOOLS

• PeopleSoft
• TSO, ISPF
• UNIX, ADS/A
• OLM, OLQ,
• IDD, DML/On-line
• MFS, SDF
• EZtrieve,
• DataXpert
• Xpediter
• Librarian
• Panvalet
• Lotus Notes
• Word
• Excel
• WordPerfect
• OfficeWriter
• dBASE
• Diagram Master
• Flow3, File-Aid, IMS Xpert

LANGUAGES

PeopleCode, SQR, SQL, SQL/Plus, PL/SQL, Perl, VBScript, JavaScript, Transact SQL, Visual Basic, BASIC, PASCAL, CICS DLI, COBOL, IDMS/ADS/O, FORTRAN

CAREER SUMMARY

Confidential has over 30 years of information systems experience with nearly 10 years of PeopleSoft development experience. His background includes experience in all phases of the software development lifecycle including programming, analysis, design, architecture, project leadership/management, testing, and software quality assurance. Mr. Hayslett's strengths include PeopleSoft development and production support with various Financial, Human Resource and Order Entry modules.

PROFESSIONAL EXPERIENCE

Confidential

Present Peoplesoft Developer

• PeopleSoft 9.0 HR and Financials development of User Request For Change involving modifications to Application Engine and , SQR programs, Search Records, Components, Pages, Records, and Views. Upgraded the customizations to the Tax Updates for years 2012 and 2013.

Senior Programmer Analyst - Peoplesoft

• PeopleSoft 8.4 custom development of SQLs to create output data to the server in Erlanger that is then processed in the nightly batch to be transmitted to the server in Michigan for the users to be able to extract the data for reporting purposes. Custom development of 3 Application Engines and supporting objects to input spreadsheet data created by the users and output to the Projects functional area of the PeopleSoft 8.4 database. Developed SQR to extract PeopleSoft 8.4 data from multiple PS financial areas and output to CSV delimited flat files to be used by users in New York for financial reporting.

Senior Programmer Analyst - Peoplesoft

• Upgrade from PeopleSoft 9.0 to PeopleSoft 9.1 custom data conversions from custom tables to delivered tables and Query conversions that were using the custom tables to use the delivered tables that the data was loaded into.

Confidential

Senior Programmer Analyst - Peoplesoft

• Implementation of PeopleSoft 9 and Oracle converting from Cost Point. Developed Custom reports using Query Manager, Crystal, and SQR. Support team member for defects and issues during User Acceptance Testing and Production as the modules were moved into the Production environment. Corrected the delivered AR AutoMaint Application Engine program so that it would run at the current Bundle level so that the team would not need to install 6 more Bundles and start testing all over again. Investigated some performance issues and corrected where necessary.

Senior Programmer Analyst - Peoplesoft

• Upgrade form PeopleSoft 8.4 to PeopleSoft 9 and conversion from DB2 to Oracle I was the primary production support person. I converted several Mainframe SQR programs to PeopleSoft SQR and Mainframe COBOL II programs to SQR. I created 6 Component Interfaces to load GL data. Took over responsibility of an Application Engine program that would not run to correct errors in the code and fine tuned the SQL for better performance.

Senior Programmer Analyst - Peoplesoft

• Solely responsible for program design, testing implementation and programming in PeopleSoft Asset Management, Accounts Payable, Accounts Receivable, General Ledger, Inventory, Order Management, and Purchasing modules both on-line and batch. Served as the Technical Lead for an Inventory implementation. Designed, coded, and tested enhancements and modifications. Analyzed and made modifications to fix problems in various applications.

Environment: Windows NT and UNIX, PeopleSoft, PeopleCode, PeopleTools, SQR, Oracle SQL Plus, K-shell scripting, and Perl scripting, Oracle 7 and Oracle 8.

Confidential

Peoplesoft Development/Support

• Production support for PeopleSoft Manufacturing for Toyota Motor Manufacturing of Kentucky and Indiana. Analyzed production problems and modified PeopleSoft PeopleCode and SQRs. Modified PeopleSoft Manufacturing Order Management and Inventory objects for customer requested enhancements.

Peoplesoft Development/Support

• Customized PeopleSoft Order Management and Inventory for the Pre-metered Pricing of inventory items on orders shipped in the Continental US. Downloaded UPS Zip to Zone and Zone Freight Charges by Max Weight tables from the UPS Internet Home Page. Created PeopleSoft Oracle DB tables and wrote SQR programs to load these tables from the downloaded UPS tables and created Run Control Parameter Panels to be used when the jobs are run from the Process Scheduler. Created Panels and Panel Groups for Inquiry/Update of these tables on-line. Modified the Menu and added the Panel Groups to the new menu items. Customized PeopleSoft Order Management for the AwardBanq System. Wrote SQR program to Edit, Load, and Update Campaign Participants table from a file extracted from the legacymainframe IDMS database. Wrote SQR program to insert rows to the AwardBanq Card Issuance table from the Campaign Participant table for those participants that were enrolled in the campaign but did not yet have an award banq card issued for the campaign. Assigned a new card number only for those participants that were not already enrolled in another campaign co-redeeming . Wrote and SQR program to extract participant records for a campaign between a selected date range. Modified the menu and created Panels and Panel Groups for all SQR programs to accept Run Control parameters from the users for processing from the Process Scheduler.

Environment: SQR, PeopleSoft, Oracle DB, AwardBanq System.

• Analyzed packaged systems for year 2000 compliance. Modified programs for Payroll Automated Data Collection and Productivity. Modified PL/l programs to be year 2000 compliant. Modified SQL Windows programs to be year 2000 compliant accessing both DB2 and SQLBase. Modified PeopleSoft Order Management Modules for customer enhancements.

Environment: SQL Base, DB2, PeopleSoft

• Designed and developed programs for the Service Order Entry system for on-line and batch using IMS, MSF, and COBOL 370. Modified COBOL programs to be year 2000 compliant.

Environment: IMS, MSF, COBOL 370

• Designed and developed programs for the CORE system on-line entry of user parameters for both issuer and acquirer financial limits for online and batch using DB2, ISPF, and COBOL II.

Environment: CORE, DB2, ISPF, COBOL II

• Designed and developed programs for the Activity Based Costing Multidimensional Driver system for on-line and batch using ADW/APS, COBOL II, DB2 and CICS. Designed and developed programs for the Budget system for on-line and batch using ADW/APS, COBOL II, DB2 and CICS. Performed other miscellaneous maintenance tasks to legacy financial systems for on-line and batch using ADWAPS, Cobol II, DB2 and CICS. Used Visual Basic with Access to develop 2 pedigree systems.

Environment: ADW/APS, COBOL II, DB2, CICS, Visual Basic, Access

• Designed and developed programs for the conversion of batch order entry programs from IDMS to DB2 on an IBM mainframe and Sybase/Client Server on a RS6000 using MQueue to transfer data from the mainframe to the server . Used PowerBuilder for the development and testing of order entry and shipping client windows. Used DB2 with COBOL II for mainframe development and Xpediter for testing. Used MicroFocus COBOL for PC development and testing of batch programs. Used Microsoft Word and Excel for documentation. Attended C/C programming and Object Oriented design classes.

Environment: IDMS, DB2, RS6000, Mqueue, PowerBuilder, COBOL II

• Designed and developed enhancements to existing billing system programs for a client of the Cellware Wireless Division. Used IMS with COBOL II for mainframe development and Xpediter for testing. Used MicroFocus COBOL for PC development and testing. Used Microsoft Word and Excel for documentation.

Environment: IMS, COBOL II, Xpediter, COBOL, Microsoft Word, Excel