Resume Gary Lamar Patrick Resume

E-mail: admofg@r.postjobfree.com Toccoa, Ga. 30577 Cell Phone: 706-***-****

I have specialized in PeopleSoft systems for almost 17 years, participating in conversions of legacy mainframe HCM (HR / Payroll / Benefits) to client-server and web-based platforms and subsequent release upgrades.

Previous experience includes heavy experience in mainframe manufacturing and financial systems and 4 years of health care experience with Blue Cross / Blue Shield of Alabama.

Education: B.S. in Business Administration, Freshman Honors program, Dean’s List, University of Alabama

The PeopleSoft HCM /HRMS clients I have worked with are:

•U.S State Department – (civil service retirement systems) – Charleston, S.C. (03/2013 – 06/2013)

•Alion Science and Technology - (IS for defense contractor) - McLean, Va. (02/2002 – 03/2009)

•Boeing Shared Services Group - (IS for all Boeing Aircraft Divisions) - St. Louis, Mo (01/2001 – 10/2001)

•Macy's Systems Group - (IS for Macy’s, Rich’s, Bloomingdales) - Atlanta, Ga. (04/1994 – 01/2001)

•Ernst and Young - (‘big 5’ accounting firm) - Lyndhurst, N.J. (01/1994 - 04/1994)

•Dana Corporation - (automotive parts manufacturer) - Toledo, Ohio (07/1992 - 01/1994)

•Tennessee Valley Authority - (electricity utility) - Knoxville, Tn. (08/1991 - 06/1992)

Have worked my way through PeopleSoft releases: 1.32, 2.2, 3.0. 4.0, 5.0, 6.0, 7.5, 8.0, 8.9, 9.1 and 9.2

Databases: Oracle11g, DB2, and SQLBase.

Platforms : UNIX, MVS, Windows NT, Windows XP

I’m proficient with PeopleTools, PeopleCode, PS Query, COBOL II, TSO, Micro Focus COBOL, SQR, SPUFI, SQLPlus, SQLTalk, TOAD, PL/SQL, MS Word, Excel, Autosys, VISIO, Araxis Merge, Crystal Reports, Control-M

I write well-structured, reliable, and maintainable SQR code. Have written scores of complicated interface and database update programs and have modified dozens of the PeopleSoft delivered SQR programs.

I provide a detailed logic structure chart (VISIO) for design / documentation/ maintenance purposes for important programs such as database updates or complex interfaces.

U.S State Department – (civil service retirement systems) – Charleston, S.C. (03/2013 – 06/2013)

•Maintenance and enhancements to SQR and App Engine programs that create outbound files used for civil service retirement reporting purposes.

•Set up Control-M recurrent process to run payroll prelim calc every 15 min. for selected days of the month.

•Lead role in HCM upgrade from 9.1 to 9.2 release and Oracle 11.1. Also upgrading Peopletools 8.52 to 8.53 release.

•Tested all custom SQRs and App Engine programs under 9.2 release. Ran multiple NA payrolls under 9.2 release.

ALION Science and Technology - (IS for defense contractor) - McLean, VA. (02/2002 – 03/2009)

•Developed a Self-Service page for employees to cash out PTO (Paid Time Off) earnings. The page displays prior PTO cash-out for the year and current accumulated PTO. The employee can request cash-out for the next 3 pay periods. Company business rules regarding allowable hours and business groups are enforced. Creates ‘Rapid Entry Paysheet’ records so that payroll manager can view EE Self-Service activity. Set up Approval Workflow Engine AWE for two level approvals.

•Participated in 8.0 to 8.9 PeopleSoft HRMS / HCM upgrade. Was responsible for the migration of all custom SQR reports and interfaces to the 8.9 release. This involved tracking user approvals thru development, QA, and production instances for the upgraded SQRs via an Excel spreadsheet.

Updated Portal and permission security lists.

I re-coded SQRs with new 8.9 tables and Fast Security view, established test cases, performed unit testing, and provided unit test documents. (PeopleTools 8.48)

•Designed and coded an on-line hierarchal reporting mechanism that allows the user to navigate thru 6 corporate levels as defined by the PeopleSoft reporting tree. This is used to build run-time parameters to drive SQR reports and processes. Modified many delivered and custom SQRs to use row-level security and the new hierarchal reporting mechanism. Lots of dynamic SQL.

•Wrote or modified SQR file interfaces for direct deposit, savings plans, COBRA, and health benefits enrollment for transmittal to Fidelity and Aetna. Also maintained G/L extract for JAMIS job cost system.

•Wrote SQRs to extract PeopleSoft data for downloading to SQL Server Data Warehouse for reconciliation purposes. This runs as a automatic ‘recurrence’ process or with operator input (dynamic SQL).

•Have modified / enhanced various Application Engine programs.

•Assisted DBA with tax updates and helped payroll manager with W-2 and year-end processing.

Boeing Shared Services Group - (IS for all Boeing Aircraft Divisions) - St. Louis, Mo (01/2001 – 10/2001)

•Designed and coded an SQR that uses run control parameters to report the HCM audit records by emplid, deptid, accounting business units, date ranges, audit tables, columns, activity type. The reporting shows ‘before’ and ‘after’ of all modified fields. Also designed the on-line run control panel and wrote PeopleCode edits. (St. Louis location).

•Participated in a project to stress test the payroll system by replicating payroll data and running multiple payrolls to measure the effect of moving from 50,000 to about 200,000 employees. Ran payrolls, wrote SQL balancing scripts. Used Autosys process scheduler, Metaframe from Seattle location.

•This contract was disrupted by the 911 attack on World Towers.

Federated Systems Group - (IS for Macy’s, Rich’s, Bloomingdales) - Atlanta, Ga. (04/1994 – 01/2001)

•Designed and coded a paysheet update program that builds paysheets from employee time files. This SQR also builds the tables used by the on-line balancing panels. Federated/Macy uses this pgm for all divisions. (over 100,000 employees)

•SQR program that reads a spreadsheet with data from multiple divisions, and edits the data across nine

different databases using dynamic database links. Also wrote the program that loads the spreadsheet data to the databases.

•A database replication program which builds multiple sets of employee data which are used by the training department for training users on the PeopleSoft system. Also wrote training related programs that eliminate much manual effort, such as transferring students from waiting lists to course sessions.

• A payroll to general ledger interface program that produces detail records and reporting of payroll earnings. This program also produces a temporary table that drives other summary interface programs, including gross-to-net, employee taxes, and employer taxes.

•Developed standards for customization within the PeopleSoft on-line system. The goal here is to be able to identify new and modified peoplecode, panels, and tables, so that problems at upgrade and new release time are minimized.

•Major enhancements to Macy’s custom on-line payroll front-end system. Also wrote the batch load, edit, paysheet update, and payroll balancing programs that support this system. Heavy payroll support.

Ernst and Young - (‘big 5’ accounting firm) - Lyndhurst, N.J. (01/1994 - 04/1994)

• Changes to Training Administration and Personnel Administration, including new business partner

needs and foreign country global requirements. (short assignment, have letter of reference)

Dana Corporation - (automotive parts manufacturer) - Toledo, Ohio (07/1992 - 01/1994)

•Participated in the design and implementation of an on-line system which accepts run-time variables, submits, schedules and monitors batch jobs. (PeopleSoft purchased this system from Dana Corporation, and it was the basis for PeopleSoft’s first version of ‘Process Scheduler’ )

•Worked with the teams converting Dana’s 121 business entities from legacy to PeopleSoft HCM.

Coded in Microfocus Cobol and SQR. Many data transfer, balancing and conversion pgms. Wrote EBCDIC to ASCII subroutines in both Cobol and SQR. We converted 55 business units

in 18 months.

Tennessee Valley Authority - (electricity provider) - Knoxville, Tn. (08/1991 - 06/1992)

•Wrote many Cobol and Easytrieve programs for a variety of reporting purposes, including a Cobol batch pgm that processes the PeopleSoft job records and calculates / updates the HR service-date according to business rules.

•Various modifications to PeopleSoft HR / Benefits panels.

•Designed and wrote skeleton / sample COBOL and CICS programs to assist client programmers

in accessing PeopleSoft tables. (First DB2 installation for PeopleSoft)

References: Upon request

Non-smoker

Contact this candidate