SUMMARY:

• PeopleSoft Functional/Technical with over 16 years of experience working with PeopleSoft 8.x, 9.2 HCM/Financials/Campus Solutions/NA Payroll/Benefits/Time and Labor, eCompensation, Base Compensation, Approval Framework (AWE), Desktop Manager and People Tools 8.55.
• Excellent user interface, analysis, development, upgrade and implementation experience using PeopleSoft
• Update Manager (PUM), Work center, Activity Guide, People Code, Application Engine, Application Package,
• Portal, Application Messaging, Component Interface, Process Scheduler, SQR, Oracle, DB2/AIX, STAT and UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, Warrenville, IL

Lead Sr. PeopleSoft Conversion Technical Developer

Responsibilities:

• Developed Application Engines and Component Interfaces for data validation and loading HCM 9.2 staging tables.
• Performed Component Interface troubleshooting to verify that all prompt tables, required key fields and Translate table values in the staging environment are consistence with the HCM 9.2 record definitions.
• Performed Component Interface troubleshooting to verify that all prompt tables, required record fields and Translate table values in the staging environment are consistence with the HCM 9.2 record definitions.
• Resolved all Component Interfaces Save Edit People Code errors preventing the staged data to post in the HCM 9.2 tables.
• Investigated the row security setup for several delivered security views preventing the application engines data validation processes from verifying rows on the SJT Person and PS Names tables.
• Collaborated with the functional team to resolve data cleansing and missing employee rows in the HCM 9.1 environment.

Environment: PeopleSoft 9.1/9.2 HCM, Benefits, NA Payroll, Time & Labor, People Tools 8.55, People code, Application Designer, Application Engine, Component Interface, Process Scheduler, Oracle and UNIX.

Confidential, Alpharetta, GA

Lead Sr. PeopleSoft Functional/Technical Analyst, Alpharetta, GA

Responsibilities:

• Setup Benefit Programs, Plans, Rates, Credits, Deductions, Calculation and Event Rules.
• Developed custom Eligibility Rules using delivered user - defined fields and People code.
• Setup eBenefits Life Events using PeopleSoft delivered functionality.
• Developed test cases for Open Enrollment, Event Maintenance and Payroll processes.
• Developed 3rd party RESTful web service integrations to provide benefit participants information to Plan Administrators using Integration Broker and People code.
• Designed NA Payroll Earnings and GL Account codes mapping to support the GL Interface process.

Environment: PeopleSoft 9.2 HCM, Base Benefits, Benefits Administration, eBenefits, Financials, NA Payroll, Time and Labor, AWE, People Tools 8.54.04, People code, Application Package, Application Designer, Application Engine, Application Messaging, Process Scheduler, SQR, Oracle and UNIX.

Confidential, Marietta, GA

Sr. PeopleSoft Functional/Technical Analyst, Marietta, GA

Responsibilities:

• PeopleSoft HCM 9.2 upgrade and reapplication using Compare Reports, Application Designer, Portal, Fields, Records, Menus, Components, Pages, People Code and Application Packages.

Environment: PeopleSoft 9.2 HCM, Financials, NA Payroll, Time and Labor, AWE, People Tools 8.54.04, People code, Application Package, Application Designer, Application Engine, Application Messaging, Process Scheduler, SQR, Oracle and UNIX.

Confidential, Edison, NJ

Lead PeopleSoft Functional/Technical Analyst

Responsibilities:

• Developed data conversion programs for the PeopleSoft 9.2 Payroll implementation project for 100,000 US and Canada hourly employees using Application Engine, Application Package, and People code Application Designer and Application Messaging.
• Lead the end-to-end NA Payroll module implementation for all weekly and bi-weekly employees including requirement gathering, assessment, fit-gap, design, configuration, system/UAT testing and deployment.
• Provided best practice strategy based on business requirements and PeopleSoft delivered payroll functionality for multiple job payments, Benefits premium, Earning/Deduction programs and custom business processes to extend the delivered payroll functionality.
• Supported the payroll users and technical team through-out the payroll module configuration and deployment.
• Designed custom Time & Labor rules for exception and positive time reporters using PIA, SQL Objects, and Rule Templates and Application Engine exits.
• Configured Work Centers, Pivot Grids and Activity Guides for a corporate wide implementation using Enterprise Component, Manage Work center Component, Configure Pagelet Component, Portal and Application Package.
• Lead eCompensation implementation project activities including gathering/documenting all stakeholder requirements, configured Compensation Rate Codes/Rate Code groups, Salary Plans/Grades/Steps, Wage Progression rules for bargaining unit agreements and setup MSS reporting groups, approvals and security definitions. Facilitated QA testing/user acceptance and go-live support activities.
• Designed multiple approval steps for compensation increases using Approval Workflow Framework (AWE).
• Created custom change packages to apply PeopleSoft updates and fixes using
• PeopleSoft Update Manager (PUM) and Change Assistant.
• Provide payroll production support in the custom HR integration module to supply
• Job, Employment, Personal Data, Deductions and Tax information into PeopleSoft 9.2 HCM and Payroll tables.
• Provide production support for on/off cycle 24 Hour Check, Weekly, Bi-Weekly and Monthly US/Canada payrolls including Pay Calculation and Pay Confirm fix/break issues.
• Developed Components, Pages, records and Process Definitions for Application
• Engine and SQR processes using Application Designer, People code, Application
• Package, Component Interface, Process Scheduler, Security and STAT.
• Developed and maintained inbound/outbound interfaces to post business partners deductions, adjustments, additional pay/hours, vacation, wage attachment and
• Dashboard ePay transactions.
• Developed People code to disable the Check Reprint process from running while
• Pay Confirm is executing. Detail analysis demonstrated this contention was the source of duplicate check numbers created in the Pay Confirm batch process.
• Collaborate with the offshore team to resolve production fix-break and code migration issues.
• Resolved HCM/Payroll related trouble tickets and enhancements, analyzed code to determine the root cause and created test plans for code revisions and QA Acceptance Test.
• Developed BRD technical specifications for all code changes and SeRV enhancements.
• Performed performance improvement for several production SQR payroll processes which ran over eight (8) hours. After applying database and code changes, these processes ran under ten (10) minutes.

Environment: PeopleSoft 9.2 HCM, NA Payroll, Time & Labor, eCompensation, MSS/ESS, AWE, People Tools 8.54, People code, Application Package, Application Designer, Application Engine, Application Messaging, Process Scheduler, SQR, STAT, DB2/AIX and UNIX.

Confidential, Naperville, IL

Lead PeopleSoft Technical/Functional Developer

Responsibilities:

• Implementation HCM, Payroll and Time & Labor incident tickets reported by the business unit using Application Designer, Application Engine, People Code, Process Scheduler, SQR, MANTIS, Mainframe, JSS, Oracle, STAT and Unix.
• Performed analysis and developed technical specifications to meet the business unit requirements.
• Developed test plans, performed unit test and migrated HCM, Payroll and Time & Labor application enhancements to production using STAT 5.6.1.
• Updated PeopleSoft Portal Registry Content Structure, Folder Security, Component and Page Permission List.

Environment: PeopleSoft 9.1 Tools 8.51, HCM, Payroll, Time & Labor, Portal, People Code, Application Designer, Application Package, Application Engine, Process Scheduler, SQR, STAT 5.6.1, MANTIS, Mainframe, Toad, Oracle and UNIX.

Confidential, Stamford, CT

Sr. PeopleSoft Technical Developer, Stamford, CT

Responsibilities:

• Developed a HCM/Payroll bolt-on employees Multi-State Tax application using Application Designer, Application Engine, People code, Process Scheduler, Oracle, STAT and UNIX.
• Provided support for conversion team implementing PeopleSoft Inventory & Purchasing, as well as AP to convert their legacy Financials data
• Developed technical specifications for the custom employees Multi-State Tax application.
• Designed Time & Labor Rules for Multi-State time payers and custom page for time entry.
• Developed a custom employee’s 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 Pay groups, Benefit Plans, Pay Run ID, hired test employees in HRMS, performed Pay sheet, Pay Calculation and Confirm Pay processes.

Environment: PeopleSoft 9.1, Tools 8.51, HCM, GL/AP, Purchasing, Payroll, Time & Labor, People Code, Application Designer, Application Package, Application Engine, Process Scheduler, SQR, STAT, Oracle and UNIX.

Confidential, Bloomfield Hills, MI

Sr. PeopleSoft Technical Developer Bloomfield Hills, MI

Responsibilities:

• Implemented baseline customizations in the ePerformance Documents business process using Application Designer, People Code, 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, People Code, 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 People Code and Process Scheduler.
• Designed XMLP Data Sources using PS Query, XMLFile and Connected Query.
• Performed XMLP troubleshooting and reverse engineering in the CONQRSMGR, QUERYITEMPROMT and Process Report 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 streamline People Code, AE and SQR queries.
• Performed on-line and batch mode unit testing, People Code and SQR debugging. Troubleshooting in Application Engine Create Documents business process to resolve technical issues.

Environment: PeopleSoft 9.0, Tools 8.49, HCM/ePerformance, People Code, Application Designer, Application Package, XML Publisher, Application Engine, Process Scheduler, SQR, STAT, DBArtisan, DB2 and UNIX.

Confidential, Alpharetta, GA

Sr. PeopleSoft Technical Analyst/Developer

Responsibilities:

• 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 People Code.
• Designed and tested PeopleSoft menus, components, pages, People Code 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

Environment: PeopleSoft 9.0, Tools 8.49, HCM, NA Payroll, Portal, Iscript, People Code, Application Designer, Process Scheduler, SQR, COBOL, ETL, UNIX and NT

Confidential, IL

Sr. Technical Developer

Responsibilities:

• 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 People Code 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 People Code processes.
• Modified Direct Deposit effective date to process ESS direct deposit transactions submitted for the current pay 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, People code, Application Designer and SQR

Environment: PeopleSoft 8.9, Tools 8.48, HRMS/HCM, Benefits Administration, ePay, eProfile, Global Payroll, People Code, Component Interface, Application Designer, TSO, SQR, SQL, COBOL, DB2, MVS JCL and OS/390.

Confidential, Itasca, IL

Sr. Technical Developer

Responsibilities:

• 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

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.

Confidential, Detroit, MI

Sr. Technical Developer

Responsibilities:

• Collaborated in the implementation of the GM multi-lingual eProfile and eDevelopmodules.
• 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 sign on (SSO) and syncizing net userids using enterprise portal, People code, 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 third party language translation.
• Modified eProfile and eDevelopment People code to apply country specific business rules and trigger Workflow processes.
• 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.

Environment: PeopleSoft 8.8 SP1, Tools 8.45.12 HRMS/HCM, Global Payroll, eProfile, eDevelopment, Application Designer, Application Engine, People Code and Workflow.

Confidential, Chantilly, VA

Sr. Technical Developer

Responsibilities:

• Designed People code 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 People code 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.

Environment: PeopleSoft 8.8 SP1, Tools 8.45.12 HRMS, Global Payroll, Benefits, eRecruit, Application Designer, People Code Workflow, Security, Portal, SQR, DB2 SQL, and OS/390.

Confidential, Detroit, MI

PeopleSoft Technical Developer

Responsibilities:

• 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 People Code analysis, modifications, system test and implementation using Application Designer, PeopleSoft PIA, People Code Debugger and People Code 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.

Environment: PeopleSoft 8.3 SP1, Tools 8.20.1, HRMS, NA Payroll, Time & Labor, Benefits, Application Engine, SQR, SQL, Windows NT, Oracle and UNIX

Confidential

Lead Technical Developer/ PeopleSoft Administrator

Responsibilities:

• Responsible for all tasks involved in the ongoing operation of the HRMS, Payroll and Benefits systems
• Designed Crystal Reports using PS Query 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 People Code 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 People Code.
• 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 People Code 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.

Environment: PeopleSoft 8.3/8.8 HRMS, NA Payroll, Benefits Administration, e-Apps, People Tools, Change Assistant, SQR, Crystal Reports, SQL, Windows NT, Oracle, DB2, AIX, OS390 and z/OS

Confidential

Lead Technical Developer

Responsibilities:

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

Environment: PeopleSoft Financials 7.5, 8.0 Assets Management, GL UDB DB2, OS390 and AIX

Confidential, Itasca, IL

Lead Technical Developer

Responsibilities:

• Performed several PeopleSoft DB2 DBA functions for the DB2 migration engagement.
• Designed Create, Alter and Index database SQL scripts for PeopleSoft and DB2 application tables.
• 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 Run stats 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 SQR's and SQC's 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.

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