SUMMARY:

• Most recent experience involved PeopleSoft to Workday data conversion and Company acquisitions to existing Workday environment.
• Over the past nineteen years worked on a full range of projects related to the PeopleSoft Application as a consultant/contractor. Including all of the major components of PeopleSoft development. This includes the use of PeopleSoft related tools and third party tools such as Application Designer, PeopleTools, PeopleCode, SQR/SQL, Data Mover and ExcelToCI. Involved with projects requiring the development of completely bolt on solutions for clients. It includes modification to delivered code only when absolutely necessary . Worked on Workday and have good experience on the same.
• The majority of my work has involved the HR and Benefits modules. Experience with Payroll from technical troubleshooting standpoint. Confident and competent enough to jump into any module to assist where a client needs additional resources. While with Carpenter Technology January 2009 March 2011 my role also included that of Security Administrator with a primarily role based security setting.
• Used SQR and SQL extensively for multiple purposes including - reporting, database mass updating, third party outbound and inbound interfaces, data reconciliation and conversion.
• Past experience includes working within the UNIX environment. This involved writing of shell scripts for repetitive tasks and/or nightly processes. Also, often used UNIX system calls within SQRs for archiving files, emailing generated files and/or messages and for ftp purposes.
• Worked on assignments with a few large corporations in the fields of finance, pharmaceuticals, retail and manufacturing, often servicing them multiple times. Each assignment offered its own unique challenges requiring creative solutions. These clients include Carpenter Technology, Merrill Lynch, Toys R Us, Novartis Consumer Health / Gerber Foods, Deutsche Bank and Hoffmann LaRoche.

TECHNICAL SKILLS:

• PeopleTools
• PeopleCode
• SQR
• SQL ORACLE
• UNIX Shell Scripts
• Application Engine
• PeopleSoft HR/Benefits
• Limited Payroll Interface
• Benefits Administration
• Base Benefits
• Basic PS Query
• Security Administrator
• Workday-custom reports, Integrations and transformation XSLT
• Experience with EIB inbound data loading for acquisitions.

PROFESSIONAL EXPERIENCE:

Confidential

• Assisted with EIB load for seven acquired companies consisting of approximately 350 employees. Most data planning and gathering had gone through an initial test load. My responsibility included the analysis of the second collection of data, modification to data as it related to the proper reference id values required and appropriate data cell population that required related values.
• Three EIB's would require troubleshooting and loading in the order listed .
• Job Profile
• Create Position
• Hire Employee
• Each EIB would be 'test loaded' with the run in validation mode checkbox on until a zero error validation completed.

Confidential

PeopleSoft/Workday Consultant

• Led the data extract project from PeopleSoft to Workday. This involved extracting data out of PeopleSoft initially to help configure all the required hierarchy organizational data required in Workday prior to extracting the employee transactional data.
• Worked on the data extract for Workday HCM, and led the team on providing the data extract from PeopleSoft training data for load into their new training module Cornerstone scheduled to go live simultaneously with the new Workday system.
• Assisted with the generation of Workday Advanced Custom Reports and Integrations EIB Enterprise Integration Builder . EIB is a tool used in Workday to handle inbound files to Workday or outbound files from Workday to vendors or Web Services. Since Workday is heavily object oriented strong understanding of calculated fields is a requirement for advance report writing and integrations. Additionally, the use of writing XSLT to transform data from the advanced reports is common. Generated several XSLT xsl for the purpose of generating flat files for vendors.

Confidential

Security Administrator

• Acquired to assist as a temporary Security Administrator due to an unexpected departure of their administrator. The security role was very basic in that the majority of the workload was password resets, new personnel access and terminating access.
• Modified nearly 250 SQRs to account for POI types either by exclusion or inclusion depending on the purpose and modified the SQR code for all processes as well as some PeopleCode modification related to the POI changes.

Confidential

IT Consultant

• Worked on nearly 110 SQR programs and many queries for paygroup and benefit program populations.
• Assisted in many PeopleSoft online modifications and new development that were needed to accommodate this acquisition. As the year progressed, was asked to stay on to assist them through the Open Enrollment paper process.
• During the acquisition work, advised Carpenter that there were many areas of SQR coding that needed some fine tuning. Much of their code included a great deal of hardcoding which generated the need of maintenance for even minor changes. Was able to significantly reduce the hardcode by including additional code that could use setup and configuration values from within PeopleSoft. In some cases, new tables and pages were developed and used as 'storage points' where the functional team could maintain values themselves for value changes thereby reducing their dependence on the technical side to make coding changes as these values changed.
• Assisted Carpenter Cartech with some production support while a couple of members of the team get more involved in a Kronos implementation.

ENVIRONMENT: PeopleSoft version 8.9, PeopleTools version 8.47, ORACLE

Confidential

IT Consultant

• Main function was to backfill production support during the Sheetz upgrade from PeopleSoft Version 8.9 to 9.1.
• Work included the day to day production support of benefits and payroll processes, the development of new and modified SQR programs used in state tax reporting processes.
• Worked on the development of a new interface to a third party vendor TALX for transfer of data related to HR, Compensation including regular and bonus earnings both historical and current. TALX would supply Workforce Analytics and Compliance Services for Sheetz based on this data.

ENVIRONMENT: PeopleSoft version 8.9, PeopleSoft Version 9.1, PeopleTools version 8.47, ORACLE

Confidential

IT Analyst IV

• Joined Carpenter shortly after their implementation of PeopleSoft converting from ADP Horizons product . Primary function was in development and support of HR and Benefits.
• Within a few months of joining Carpenter, they expressed a desire to catch up on unapplied bundle updates to the PeopleSoft system Bundles 6 through 9 . They preferred not to apply one bundle at a time and making the needed modifications to their customizations with each step. They were looking for a possibility of applying all bundles in a short period of time. Led the effort to make this happen over a period of three months.
• Placed into the role of PeopleSoft Team Lead and Security Administrator.
• As team lead was the primary liaison between the technical and functional PeopleSoft areas. Gathered specifications and designed solutions for meeting the needs of the functional area.
• As Security Administrator, outlined permission lists, defined roles and created user profiles normally by copy . In addition, maintained query trees and query security, processed the Portal Sync and the Security Join Tables Processes SJT .
• Advanced the support into areas such as, ePerformance, Employee Self Service and Manager Self Service. Assisted with several tax updates including impact analysis. Also took the initiative to incorporate the use of the ExcelToCI tool for several areas of data load previously requiring manual data entry directly to PeopleSoft including merit increases.
• Most challenging effort was designing a Variable Compensation solution within PeopleSoft to move Carpenter's process away from an Excel Spreadsheet solution.

ENVIRONMENT: PeopleSoft version 8.9, PeopleTools version 8.47, ORACLE

Confidential

IT Consultant

• Assigned to assist with outstanding issues and post implementation support and development.
• This included development of new interfaces, records, pages and PeopleCode development, as well as, day to day support of help and issues tickets.

ENVIRONMENT: PeopleSoft version 8.8, UNIX, ORACLE

Confidential

• The focus of this assignment was the extraction and conversion of PeopleSoft data into comma and tab delimited files, via SQR, for import to the ORACLE financials suite. Was responsible for the creation of several sqrs to accomplish this task. Primarily, the focus was related to Fixed Assets, Quantity On Hand and assistance to Bills of Materials and Routings.
• Several crosswalks or mapping tables were developed for use in translating data from PeopleSoft values to ORACLE values where needed. This allowed for flexibility for data conversion changes reducing the need for code changes.
• The project required passes through two unit test processes and several mock conversion steps in order to ensure data was ready for go live . Because of the tight deadline on this project code modifications were expected to be completed and ready for new testing within two hours of discovered issues.

Confidential

IT Consultant

• Fast paced retail environment that required the ability to react quickly to issues from many different aspects of the Toys R Us TRU PeopleSoft system related to HR, Time and Labor and outsourced payroll while continuing to meet deadlines for major new development.
• Involved in a major role in a high profile project to limit hourly employees to punch times that were within a defined range of times based on their scheduled time. This involved coding for multiple SQRs, PeopleCode and an App Engine process. Profiles for the restricted range of valid punch times are updated via custom developed PeopleSoft records and pages.
• Another major project was to move the dependency of TRUs Adjusted Service Date system completely from a legacy system into PeopleSoft. This was a custom bolt-on developed in the PeopleSoft system.

ENVIRONMENT: PeopleSoft Version 8.3, UNIX, ORACLE

Confidential

IT Consultant

• Responsible for configuration of Payroll Interface for a new company value including three new pay groups to an already existing company. New company and pay groups were also configured for ADP PCPW and ADP Connector application.
• Provided knowledge transfer to the full time staff as well as document the steps necessary to accomplish the tasks above in the event of future configuration additions.
• Assisted in troubleshooting and implementing solutions for some minor issues for which the client had developed temporary work around processes.

ENVIRONMENT: PeopleSoft Version 8.3, UNIX, DB2

Confidential

IT Consultant

• Developed two SQR inbound interfaces for new 401k vendor Fidelity Investments . One interface contains the 401k deferral elections, loan information and catch-up deferral data single client feed . This information is used to generate a comma-delimited file for load into the ADP for windows system for employee deductions, as well as, a hardcopy report of data contained in the file. The second interface contained stock purchase and stock exercise data. Included in this project was the ability to automate running of this process through Process Scheduler and give end user the optional ability to manually run through a menu option.
• Other tasks included use of PeopleTools to create new menu items, pages, run controls and object security. Tasks also included the use of PeopleCode for the purpose of coding specific requirements for data entry verification edits, as well as, date reasonability coding.

ENVIRONMENT: PeopleSoft version 8.18

Confidential

IT Consultant

• Modules include HR and Ben Admin with some Payroll Interface. Responsible for development and support using PeopleCode, PeopleTools, SQR and basic UNIX shell scripts.
• Wrote a series of SQR programs to help with cleaning and tuning of Ben Admin related data.
• SQR interfaces written for creating Open Enrollment files of eligible employees and dependents for third party use in managing the open enrollment process. SQR also developed for data returned by the vendor into the Ben Admin system of elected benefits.
• PeopleCode and PeopleTools development included new record definitions, views and related data edits as well as data triggered edits. PeopleCode functions for frequently used calculations and field value pre-filling.
• Created a process to automate the running of the Ben Admin processing on a daily basis rather than depend on the need of a user to manually kick off this process. This allowed the processing to be handled by Merrill Lynch's preferred AutoSys process scheduling tool.
• Heavily involved with providing transition training for the offshore group that were to take over the routine production support tasks. Part of this training was the inclusion of step-by-step instructional documentation, as well as, technical process documentation.

ENVIRONMENT: PeopleSoft version 7.59

Confidential

IT Consultant

• Primary duties included regular support and maintenance of PeopleSoft system for HR, Payroll Interface ADP and limited Ben Admin initially included Ben Admin, but this module was dropped during upgrade process .
• Assisted in the upgrade process of PeopleSoft from version 7 to 7.5.
• Was a part of project to merge two separate PeopleSoft systems Novartis and Gerber Foods into a single PeopleSoft entity. Process involved merging of all PeopleSoft data, rewriting of all interface sqrs, and inclusion of new companies for Payroll Interface.
• Managing open enrollment processing for several years was part of my experience here. This included generating outbound eligibility file for third party voice / web enrollment, loading of new elections from voice enrollment process back into PeopleSoft system.
• Bonus and Merit increase processing were also part of responsibilities. This involved the generation of csv files for ADP Payroll for Windows bonus load and an SQR to mass update PS JOB with Merit increase data.
• Created many basic public queries using the PS/Query Tool for end users as needed. Most used to reconcile data provided to third party vendors. Also used for reporting of issues pertaining to database integrity between parent and child tables.

ENVIRONMENT: PeopleSoft version 7.0, 7.5

Confidential

IT Consultant

• Responsibilities included development of records and panels for custom Compensation Planning project. This included summary and detail panels for current, as well as, historical data.
• Wrote several SQR processes for the sharing and planning of compensation data between a global and local PeopleSoft system.
• Completed a project for 401k SQR interface to exchange election and loan information to and from Fidelity Investments, which fed to the Ceridian payroll system. This project included the development of new records and panels for end users to view and report from.
• Used PS/Query to create public queries for end users as requested or required for data reconciliation.

ENVIRONMENT: PeopleSoft versions 5 and 6

Confidential

IT Consultant

• The primary objective was the development of the interface for voice open enrollment of health benefits and flexible spending accounts, as well as, year-end processing and reporting.
• Modified existing SQRS and PeopleCode.
• Developed SQRS to gather data for export to spreadsheets for data too complicated to retrieve using the PeopleSoft query tool.
• Wrote a series of UNIX based scripts to aid in the testing process for the payroll implementation team. Primary code was used for file comparison purposes to ensure that changes to deductions and compensation were properly captured in PeopleCode and SQRS.

ENVIRONMENT: PeopleSoft version 4

Confidential

Programmer/Analyst

• Involved with PeopleSoft development in all phases from design through testing and tuning. Worked and designed modifications and creation for large number of sqrs. This involved heavy customization of PeopleCode.
• A rather large project was the development of a custom in-house COBRA module including identification of qualifying events, generation of qualification letters, billing and accounting.
• Tasks also included a large number of PeopleCode customizations required to fit several diverse divisions of the corporation.
• Developed UNIX shell script processes for night batch processing, file manipulation tasks, systems monitoring tasks.