Summary: A technical PeopleSoft consultant with twenty-five years of experience in the design and implementation of HR/Payroll information systems. As project leader for implementation projects involving both packaged and in-house developed systems, has worked with all phases of the systems development lifecycle. Ability to learn new technologies quickly has led to role as a technical and database resource in addition to assigned role on projects. Twenty years of in-depth PeopleSoft experience.

Employment History:

PeopleSoft Technical Consultant

• Built batch Job Upload Component Interface process allowing HRIS to load large CSV files by specifying Job fields to include, and update mode Add/Update/Delete .

• Created Dynamic Outbound Interface process to reduce number of programs for demographic/indicative interfaces. Configuration allowed PSQuery, SQL, PL/SQL, Connected Query and BI Publisher data sources to be published to XML, delimited or fixed file types.

• Wrote Reverse Feed interface to provide Office Max with HR data changes, allowing existing security provisioning to continue after SAP HR updates were discontinued.

PeopleSoft Technical Consultant

• Created several integrations between HCM 9.2 and Student Admin 9.0 which became necessary after splitting the databases.
• Created Tuition Reimbursement Fee Authorization interface between Student Admin and HCM Database utilizing delivered remote query QAS web-service to obtain data needed to calculate the fee codes.

• Wrote custom salary encumbrance AE process to more accurately reflect amounts to be paid thru the end of the year or contract length based on payroll projections. Included department budget allocation table to split funds.

• Customized Commitment Accounting processes paygl02, paygl03, and retro distribution process to accommodate child HR accounting record with reporting information, and to properly charge accounts as per business requirements.

• Customized delivered student transcript BI Publisher report and Job Application report

• Customized Grad School Application process to include and populate custom entities and display the information online

• Life Event and e-Benefits Enrollment defect resolution

PeopleSoft Technical Consultant

• Designed new custom associate auto-scheduler, schedule management MSS pages, and associate self service page

• Developed replacement employee auto-scheduler App Engine using 1/3 less code, reduced run-time by half, and allowed plug-in configurable business/store/country/state-specific rules to handle labor laws for employees in 20 countries.

• Replaced existing custom cursor-based MSS store management pages with efficient, easy to use MSS suite.

• Implemented Time Labor for A F Distribution Centers and Home Office employees which included Kronos conversion, custom pages, reports, T L rules and attendance programs.

• Built 12 BI publisher reports to replace SQR reports, screen print functionality, and Kronos reports.

PeopleSoft Functional and Technical Time Labor Lead

• Worked with 38 city departments and county agencies on numerous legacy time entry methods to capture requirements and implement PeopleSoft Time and Labor with minimal customization.
• Developed bolt-on query page for reported and payable time to allow timekeepers to create simple queries without granting PeopleSoft Query Manager.
• Configured PeopleSoft Time and Labor system tailored for each agency/department requirements.
• Developed conversion process to enroll time reporters and create task profiles based on legacy chartfield allocations.
• Developed TL rules and Group Security for the 38 agencies

PeopleSoft Time Labor Technical Consultant

• Developed 25 online customizations and 17 batch jobs to align timesheet and approval pages with requirements, and provide automated email notifications and reports.
• Developed custom security sync process to automatically generate TL groups and permissions so delivered security could be used without extensive maintenance.
• Used BI Publisher to produce several TL reports for period end analysis, and online spreadsheet generation for staff timesheet data queries.
• Wrote 24 custom TL Rules to produce exceptions, populate chart fields and transform time.
• Developed timesheet data file load front end to edit and transform timesheet data, using delivered app message to submit time to the system.
• Performance tuned Time Admin process to fit processing windows.

PeopleSoft HCM Technical Consultant

• Developed several T L rules for various agencies
• Used BI Publisher to produce many reports
• Created ESS portal for managers and employees

PeopleSoft Enterprise Portal Consultant

• Developed New Hire Onboarding website with navigation system, digital forms, and custom content manager using PeopleTools.
• Created custom java class and PS App Package to interface Tools 8.47 with the iText java class to form-fill existing PDF templates and create brand new PDF reports from online PeopleCode.
• Developed new Enterprise Portal homepage and pagelets to launch New Hire onboarding site, using delivered content manager, and separate branding for applicants and employees. Developed and administered all enterprise portal security for HCM and onboarding sites in development and test databases.

PeopleSoft Technical Team Lead

Confidential

PeopleSoft Technical Consultant

Business Analyst

Confidential

PeopleSoft Technical Consultant

Confidential

PeopleSoft Technical Consultant

Confidential

PeopleSoft Technical Consultant

Confidential

PeopleSoft Technical Consultant

Confidential

Senior Programmer Analyst

Skills and Abilities:

BI Publisher, PeopleCode, SQL, HTML, PeopleSoft Application Messaging, Oracle, Java, Visual Basic, PeopleSoft Application Packages, PeopleSoft Portal Technologies, SQL Server, COBOL, PeopleSoft Application Engine, XML/SOAP, Cocoa Touch, Objective-C, iPhone SDK, X-Code