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 Supply Chain modules.

TECHNICAL SKILLS

Windows NT and UNIX, PeopleSoft, PeopleCode, PeopleTools, SQR, Oracle SQL Plus, K-shell scripting, and Perl scripting, Oracle 7, 8, 9, and 10g. SQL Server 2005, DB2, and IDMS.

PROFESSIONAL EXPERIENCE

Confidential

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.

Confidential

Senior Programmer Analyst

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

Confidential

Senior Programmer Analyst

• 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

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

Confidential

Senior Programmer Analyst

• Upgrade form PeopleSoft 8.4 to PeopleSoft 9 and conversion from DB2 to Oracle Primary production support person filling in for a lady that was on maternity leave.
• Converted several Mainframe SQR programs to PeopleSoft SQR and Mainframe COBOL II programs to SQR.
• 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.

Confidential

Senior Programmer Analyst

• Financials: Solely responsible for program design, testing implementation and programming in PeopleSoft Asset Management, Accounts Payable, Accounts Receivable, Billing, Contracts, Expenses, General Ledger, Inventory, Order Management,, Projects 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.
• HR: While upgrading from PeopleSoft version 7 to version 8 rewrote all of the custom queries that were request by the user to be migrated to the new release because there was no tool to convert them directly from version 7 to version 8.
• Also upgraded any associated Crystal reports.
• Modified the custom payroll extract for California change requirements.
• Developed the interface for new recruits to be input to the HR system from a file sent by the vendor. This included inserts or updates to all tables which were involved in inputting a new employee into the HR system.

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.

Confidential

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 legacy mainframe 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.