EXPERIENCE SUMMARY:
Over ten years of PeopleSoft 7.x, 8.8, 9.0 HCM/HRMS/Payroll/Benefits/Time & Labor systems
implementation, development, conversion and upgrade technical experience.

Excellent development and customization skills in Student Administration, Financials, HRMS,
eApps, Payroll, Benefits and Time & Labor, using PIA, PeopleTools, PeopleCode, XML Publisher,
Application Engine, Process Scheduler, SQR, SQL, COBOL, IBM Mainframe
Windows NT, AIX and Unix servers.

PROFESSIONAL SUMMARY:

Industry: Confidential,
CT
Duration: November, 2011 – June, 2012
Role: Sr. Peoplesoft Technical Developer
Environment: PeopleSoft 9.1, Tools 8.51, HCM/Payroll, PeopleCode, Application Designer, Application Package, Application Engine, Process Scheduler, SQR, STAT, Oracle and UNIX.

• Developed a HCM/Payroll bolt-on employees Multi-State Tax application using Application Designer, Application Engine, Peoplecode, Process Scheduler, Oracle, STAT and Unix.
• Developed technical specifications for the custom employees Multi-State Tax application.
• Developed a custom employees department roll-up Peoplesoft table to support the HR Analytics team using Application Designer, Application Engine, Process Scheduler, Oracle and Unix.
• Developed technical specifications for the custom department roll-up table.
• Performed Payroll modifications and unit testing in the Retirement Health System.
• Developed test Paygroups, Benefit Plans, Pay Run ID, hired test employees in HRMS, performed Paysheet, Pay Calculation and Confirm Pay processes.

Industry: Confidential,
MI
Duration: August, 2010 – September, 2011
Role: Sr. Peoplesoft Technical Developer
Environment: PeopleSoft 9.0, Tools 8.49, HCM/ePerformance, PeopleCode, Application Designer, Application Package, XML Publisher, Application Engine, Process Scheduler, SQR, STAT, DBArtisan, DB2 and UNIX.

ePerformance Baseline Implementation:

• Implemented baseline customizations in the ePerformance Documents business process using Application Designer, PeopleCode, Application Package, DBArtisan, STAT, Process Scheduler and UNIX servers.
• Modified several baseline SQRs and Application Engine processes to mass create and maintain Appraisal Documents and Manager Groups using Application Designer, Process Scheduler, STAT, DBArtisan, PeopleCode, Application Package, File class for Application Engine report files and UNIX.
• Designed XML Publisher Report Definitions, Templates and Data Sources to generate ePerformance reports using PeopleCode and Process Scheduler.
• Designed XMLP Data Sources using PSQuery, XMLFile and Connected Query.
• Performed XMLP troubleshooting and reverse engineering in the CONQRSMGR, QUERYITEMPROMT and ProcessReport Application Packages to resolve Connect Query queries prompt values.
• Designed several extract SQRs to provide FIAT Motors with Peoplesoft ePerformance files using SQCs, UNIX and SQR.
• Views for both on-line and batch business processes to steamline PeopleCode, AE and SQR queries.
• Performed on-line and batch mode unit testing, PeopleCode and SQR debugging. Troubleshooting in Application Engine Create Documents business process to resolve technical issues.

Industry: Confidential,
GA
Duration: May, 2008 – January, 2010
Role: Sr. Peoplesoft Technical Analyst/Developer
Environment: PeopleSoft 9.0, Tools 8.49, HCM, NA Payroll, Portal, Iscript, PeopleCode, Application Designer, Process Scheduler, SQR, COBOL, ETL, UNIX and NT Servers

• Designed ETL objects, Map groups, Translation/Edit rules and source data extraction

to populate Peoplesoft entry point tables using PIA and Application Designer

• Engaged with cross functional teams, department managers, business analysts, and

technical staff to translate complex requirements into PeopleSoft technical specifications.

• Performed conversion analysis, requirements gathering and reviews with the business units
• Implemented Web Service CI\'s to insert HR and Payroll data using Integration Broker,

Application Engine, Application Designer and PeopleCode.

• Designed and tested Peoplesoft menus, components, pages, PeopleCode and Process

Definitions to allow the business unit to submit the SHIPS data conversion processes

• Developed SQRs to convert SHIPS Peoplesoft Payroll tables using external csv files
• Modified several eSTARS (Southern Company Time and Attendance Reporting System)

COBOL programs for data conversion using UNIX

Industry: Confidential,
Stream, IL
Duration: January, 2007 – April, 2008
Role: Sr. Technical Developer
Environment: PeopleSoft 8.9, Tools 8.48, HRMS/HCM, Benefits Administration, ePay, eProfile, Global Payroll, PeopleCode, Component Interface, Application Designer, TSO, SQR, SQL, COBOL, DB2, MVS JCL and OS/390.

• ePay and eProfile on-line and batch customization and development.
• Modified the DDP001/DDP003 Advice/Check Print SQR\'s to generate all pay slips in PDF

format and tested all code changes on the Mainframe and Process Scheduler.

• Designed PeopleCode programs to kick-off the DDP003 SQR process.
• Designed Peoplesoft functions to fire a custom Component Interface from the ePay

Component.

• Designed ePay View Paycheck control application for viewable payments
• Analyzed and documented eBenefits, Benefits Admin and Open Enrollment PS Tables, Pages,

Components and PeopleCode processes.

• Modified Direct Deposit effective date to process ESS direct deposit transactions submitted

during the week of the payroll cycle

• Performed payroll setup and testing to verify the direct deposit transactions results
• Designed an ePay Metrics application to report ePay transactions page hits by the hour using

Component Interface, Peoplecode, Application Designer and SQR

• Developed programming specs

Industry: Confidential,
IL
Duration: November 2006 – January 2007
Role: Sr. Technical Developer
Environment: PeopleSoft 8.8, Tools 8.45.12 HRMS/HCM, NA Payroll, Benefits Administration, Application Designer, TSO, SQR, SQL, COBOL, DB2, MVS JCL and OS/390.

• Performed year end requirements gathering
• Managed ADP\'s Quarter/year end W2 Extract process for the prior year W2-C balances.
• Developed interface SQRs to create vendor extract files concerning employee data change activity including termination, hire, rehire and transfers in the Peoplesoft HRMS system.
• Performed data conversion extracts from Peoplesoft 8.3 (OS/390 DB2 tables) to flat files
• Designed SQR’s to convert the Peoplesoft HRMS 8.3 data to the HRMS 8.8 requirements

Industry: Confidential,
MI
Duration: September 2006 – November 2006
Role: Sr. Technical Developer
Environment: PeopleSoft 8.8 SP1, Tools 8.45.12 HRMS/HCM, Global Payroll, eProfile, eDevelopment, Application Designer, Application Engine, PeopleCode and Workflow.

• Collaborated in the implementation of the GM multi-lingual eProfile and eDevelopment modules.
• Collaborated in the deployment of the Global eProfile and eDevelopment applications to the Enterprise Portal.
• Collaborated in the design of the Peoplesoft PDI/LDAP authentication strategy for single

signon and syncizing net userids using enterprise portal, Peoplecode, Application Messaging,
CI\'s and Application Designer.

• Collaborated in identifying all salary employee’s managers for workflow routing and email notifications using LDAP server.
• Documented all delivered eProfile and eDevelopment data pages for thrid party language translation.
• Modified eProfile and eDevelopment Peoplecode to apply country specific business rules and trig Workflow.
• Designed workflow route controls and dynamic query roles for worklist and email routings.
• Designed Application Engine processes to interface with LDAP servers and update PS Security tables.

Industry: Confidential,
VA (Blue Cross Blue Shield of Illinois)
Duration: September 2005 – January 2006
Role: Sr. Technical Developer
Environment: PeopleSoft 8.8 SP1, Tools 8.45.12 HRMS, Global Payroll, Benefits, eRecruit, Application Designer, PeopleCode Workflow, Security, Portal, SQR, DB2 SQL, and OS/390.

• Designed Peoplecode events in the Employee Services Tracking system to enforce business rules, Workflow and validate all cases/issues data entry.
• Designed Workflow processes to route cases/issues from one CSR to another and assign cases/issues from one department to another in the Employee Services Tracking system.
• Developed technical specifications for the custom Staffing Bonuses system including

Workflow technical specifications.

• Designed records, pages, components and Peoplecode events to validate all bonus requests initiated through the Staffing Bonuses system.
• Designed Workflow processes to route email notification from one Recruiter to another and initiate the Manager Self Service bonus approval process via Workflow worklist.

Industry: Confidential,
Detroit, MI
Duration: September 2004 – December 2005
Role: Peoplesoft Technical Developer
Environment: PeopleSoft 8.3 SP1, Tools 8.20.1, HRMS, NA Payroll, Time & Labor, Benefits, Application Engine, SQR, SQL, Windows NT, Oracle and Unix

• Responsible for all tasks involved in the ongoing operation of the HRMS, NA Payroll, T&L and Base Benefit systems.
• Managed the day-to-day HRMS, Payroll and T&L incident reports and user support.
• Performed T&L functional analysis and troubleshooting for Task Profile tracking for different funding sources in Payroll and Actual Distribution process.
• Designed Application Engine application to update Payroll table to designate the funding source for T&L Task Profile time reporters in Payroll.
• Designed all required Application Engine objects to run from the web client.
• Performed functional analysis and troubleshooting in the Payroll Check Reversal/Adjustment Component to remove prior period reversal/adjustments for retired employees.
• Performed functional analysis and troubleshooting in the HRMS Multiple Jobs component to

fix system duplicate row insertion error.

• Performed PeopleCode analysis, modifications, system test and implementation using Application Designer, Peoplesoft PIA, PeopleCode Debugger and PeopleCode trace file.
• Modified the Payroll Direct Deposit SQR process to report additional employee and benefit plan data for all retired and active employees.
• Performed Application Engine troubleshooting and resolution in the Time Administration and Time Load processes.
• Performed maintenance, enhancements and customizations in HRMS, T&L, Payroll and Benefits modules.
• Used Maintain Security data panels to authorize Menus, Components and Pages access for all existing security definition.
• Designed all required Peoplesoft and Process Scheduler objects to run SQR’s from the web client.
• Performed SQR programming analysis, design, modifications, unit test and implementation.

Industry: Confidential,
Duration: October 2001 – March 2004
Role: Lead Technical Developer/ PeopleSoft Administrator
Environment: PeopleSoft 8.3/8.8 HRMS, NA Payroll, Benefits, e-Applications, PeopleTools, Upgrade Assistant, SQR, Crystal Reports, SQL, Windows NT, Oracle, DB2, AIX, OS390 and z/OS

• Responsible for all tasks involved in the ongoing operation of the HRMS, Payroll and Benefits . systems
• Designed Crystal Reports using PSQuery and SQL.
• Managed the PIA infrastructure; IBM Web Sphere, Application servers, Tuxedo, Process

Scheduler, UDB DB2 server, Security Administration and AIX server.

• Implemented all required HRMS, eApplications, Payroll and Benefits patches, bundles and

tax updates.

• Designed HRMS 8.3 to 8.8 upgrade tasks and steps using Peoplesoft Upgrade Assistant.
• Managed all Peoplesoft UDB DB2 database instances and data migrations on the NT and

AIX servers.

• Managed the day-to-day PeopleSoft open issues and user incident reports.
• Performed PeopleCode and Component Interface troubleshooting in the HRMS, Payroll and

Benefits modules.

• Migrated and system test all required HRMS, Payroll and Benefits patches, fixes and bundles . for the current release
• Designed several Component Interfaces for Payroll and Benefits integration with external

systems.

• Designed several Application Engine processes to create flat files for all trading business

partners.

• Performed Application Engine fixes and troubleshooting using Application Engine Debugger

and PeopleCode.

• Performed requirements gathering, documented user requirements and developed system

specifications to meet user requirements.

• Performed maintenance, enhancements and customizations to Peoplesoft HRMS, Workforce . Administration, Payroll and Benefits applications
• Used Maintain Security data panels to authorize Menus, Components, Pages and

Component Interfaces access for an existing security definition.

• Managed the day-to-day PeopleSoft open issues and user incident reports.
• Implemented all required Peoplesoft eBenefits and eRecruit patches and fixes for the current

release.

• Performed SQR and PeopleCode programming analysis, design, code, system test and

implementation.

• Designed all required PeopleSoft objects, Process Scheduler definitions and Mainframe JCL . for on-line and batch application deployment
• Performed all required COBOL compiles on the AIX and NT servers.
• Maintained and supported batch processes running on the Mainframe server submitted via the Process Scheduler and MVS JCL.
• Designed several batch jobs to execute COBOL and SQR on the Mainframe server.
• Managed and performed all Peoplesoft production data migration requests.
• Performed SQR, COBOL, SQL, and Peoplesoft Query troubleshooting and performance tuning.

Industry: Confidential,

Duration: April 2001 – September 2001
Role: Lead Technical Developer
Environment: PeopleSoft Financials 7.5, 8.0 Assets Management, GL UDB DB2, OS390, AIX

• Performed required upgrade steps for Financials 8.0 including applying required fixes and patches.
• Performed PeopleSoft records and DB2 table creates, table alters and views
• Designed several conversion SQR’s to extract GL transactions in the Walker Financial system to populate PeopleSoft’s GL databases.
• Customized the delivered SQR Shell for all Batch processes submitted through the Process Scheduler using MVS JCL, Process Scheduler and TSO/ISPF.
• Retrofited several custom SQR’s for release 8.0 table processing.
• Designed MVS JCL and PROCS to test all developed SQR’s submitted through the Process Schedule.
• Performed SQR programming analysis and customizations in several delivered AM Depreciation and Cost activity reports to print on MVS 390 Printers via SAR.
• Designed several interface SQR’s to populate the PS_INTF_FIN and PS_INTF_PHY PeopleSoft tables to customize asset processing beyond Mass Change functionality.
• Analyzed and modified SQR/SQL Select statements for performance issues using DB2 EXPLAIN, DB2 Command Center, SQR Trace and DB2 system indexes table.
• Customized all required run control tables, pages, components, menu items and MVS batch JCL for running batch processes on the AIX and NT Servers.

Industry: Confidential,
MI

Role: Lead Technical Developer
Environment: PeopleSoft Financials 7.5, 7.57, GL, PC, AR, AP, PO, OS390, UDB DB2, Oracle and AIX

• Performed several PeopleSoft/DB2 DBA functions in this Oracle to DB2 migration engagement.
• Designed Create, Alter and Index database SQL scripts for PeopleSoft and DB2 application t ables.
• Modified PeopleSoft and DB2 table space settings for application tables and indices.
• Developed data migration strategies to load DB2 tables and convert Oracle data formats to DB2 using COBOL, SQR, SQL, Data Mover, DB2 Load, Copy, and Runstats Utilities.
• Performed database audits to verify PeopleSoft and DB2 table structures are in synchronization.
• Performed programming analysis and modified all required PeopleSoft delivered and custom SQRs and SQCs to run on the OS390/DB2 server.
• Performed DB2, SQR and SQL performance tuning using DB2 monitor and DB2 Explain Plan table definitions
• Performed programming analysis and customizations in the journal edit and post processes using Process Scheduler, DB2, MVS JCL, TSO/ISPF and COBOL.
• Performed COBOL compiles, debugging, and system test in the journal edit process to verify customization results meet user requirements.
• Gathered user requirements, developed programming specifications, documented all required PeopleSoft Financial tables and trees for reporting requirements.
• Coded and tested SQRs from design specifications.
• Analyzed and modified user queries to replace Oracle SQL statements with an equivalent DB2 format.

Industry: Confidential,
MI
Duration: January 2000 – October 2000
Role: PeopleSoft Functional/Technical Analyst

Unix/AIX, IBM Mainframe, DB2 and Windows NT servers

• Setup Academic Course lists, Enrollment Course list, Academic Requirements and

Requirement groups using several Academic Advisement tables

• Designed data conversion strategies to extract, transform and load historical records from

the legacy system

• Implemented several on-line and batch customizations in the Academic Advisement module

using COBOL, Application Engine, Application Designer, SQRs, and PeopleCode.

• Designed several Academic Advisement custom reports using Application Engine, Application

Designer, SQR and PeopleCode.

• Developed test plans and acceptance testing for several Academic Advisement business

processes.

• Discussed go-live dates and coordination with Students Records, Financial Aid, Technical

Team and Portal Team.

• Provided weekly status report for the Academic Advisement implementation project..

Education & Training: B.S. in Computer Science – Mississippi Valley State University.