Uploaded File
John
johneberhardt@comcast.net
904-343-1415
1010 southside blvd
Jacksonville, FL 32225
PS Functional Consultant
28 years experience W2
0
Recommendations
Average rating
188
Profile views
Summary

John is a PeopleSoft HCM consultant with more than 20 years of technical, functional and project management experience in the Corporate and Higher Education projects. His background includes HCM Upgrades and implementations. In addition to managing large, complex projects and overseeing technical and functional staff.

CORE COMPETENCIES

PeopleSoft

HCM through 9.2: Payroll, Benefits, Time & Labor, Commitment Accounting; Campus, PS Financial integration

Technical

Application Designer, Application Engine, Component Interface, SQL, SQR, COBOL, Integration Broker

Experience
G/L Commitment Accounting Consultant
Education
Oct 2016 - present

Functional / Technical support

No skills were added
Remove Skill
Sr. HCM Consultant
Information Technology
Apr 2016 - Sep 2016

Interpublc Group, PeopleSoft HCM 9.2 upgrade Consultant for HR, Benefits, and Payroll.

PS HCM Peoplesoft
Remove Skill
HCM Commitment Accounting Functional Lead
Information Technology
Jan 2014 - Mar 2016

HCM Commitment Accounting Functional Lead

Peoplesoft HCM 9.2 and Financials 9.2

Responsible for the HCM Commitment Accounting fit gap testing, Request for Change, Modification design specifications and Quality Assurance. Completed the Position Funding Conversion and validation. Performed Payroll Distribution testing with PeopleSoft 9.2 Financials system, using Integration Broker for G/L and Accounting Payable Test. Expertise in legacy to HCM / Financials Chartfields, Combo Codes, and Project Accounting. In addition, completed additional enhancements in Department Self Service Funding Maintenance, Retro Distribution Funding, and Chartifield maintenance programming. Experience in PS HCM Conversion of HR, Payroll, Benefits, and Time/Labor conversions. My background includes HCM Functional and PeopleTools 8.54+ PeopleCode, Component Interface, Application Engine, and Integration Broker technical skills.

PS HCM Peoplesoft PeopleCode PeopleTools Quality Assurance
Remove Skill
Payroll Commitment Accounting Lead Consultant
Education
Oct 2012 - Jan 2014

Payroll Commitment Accounting Lead Consultant

PeopleSoft HCM 9.1 and Financials 9.1

Responsible for the requirements definition for the Commitment Accounting Conversion, Salary Source Hub, to provide for integration of HR, Funding, Budget Checking, and Workflow Approvals. This included development with the Gideon Taylor Electronic Personal Action Forms. Designed and developed Conversion specifications for the Department Budget Tables, to convert Staff and Faculty Employees. Completed Fit Gap Testing and develop customizations for Payroll Distributions, Retro Distributions, and Encumbrance processing. Defined custom specifications for the Conversion of Combo Code, for the Department Budget conversion, by mapping legacy Funding mapping to valid Chartfield combination and resolved ongoing conversion issues. Provided support for Production Systems, with support of HCM, Financials, and Campus Solutions production integrations.

Peoplesoft PS HCM
Remove Skill
HR Functional/Technical Consultant
Information Technology
Jan 2011 - Oct 2012

University of Texas / Cedarcrestone

HR Functional/Technical Consultant

PeopleSoft Implementation

  • Completed assignments in functional Fit Gap of HR Functional testing of a Multi School / Business Unit implementation. Developed specifications for custom solutions to provided extended functionality in the areas of Search Match, Consolidated Online Component/Page navigation, Template Based Hires, and Position Management. Developed and tested the HCM foundation tables and Security Role design. Coordinated with remote campus Functional Team members for the development of HCM Multi-Campus Configuration Guide. Provided Functional and Technical support of the HCM database conversions; developing translations, multi-job design, historical analysis and technical Component Interface debugging of Conversion programs.

Capella University/ Cedarcrestone

Upgrade Consultant

Campus Solutions 9.0 split / HCM9.1 Upgrade

  • Project performed retrofit of CS90 customizations from HCM89. Completed PeopleTools project upgrades for Student Admissions, Faculty Pay, and Integration Broker testing. In addition, completed retrofitted customization in the HCM91 HR, Payroll, and Talent Acquisition Management profile management functional areas.

CIGNA/ Cedarcrestone

Upgrade Consultant

PeopleSoft HCM

  • Provided On-Shore functional and Technical support of Business Unit Conversion, Benefits Provider, Time & Labor Workgroup automation, Demographic Integration, Recruiting Conversion, and Payroll testing. This included program development in Application Engine, Component Interface, SQR, SQL, and PeopleCode.

University of Southern California/ Cedarcrestone

HR Consultant

Workday HCM 14

  • Reviewed and designed Workday 14 HCM business processes. Completed discovery and design sessions in Position Budget, Compensation, Payroll Earnings and Payroll Deductions, reviewed with functional client staff.

Illinois State University/ Cedarcrestone

Functional and Technical Lead

PeopleSoft HCM

  • Served as the HR lead, supporting parallel production phase with functional and technical solutions. Provided support for the database conversion validation, Employee and Manager Self Service and HR reports conversion. Developed workflow configuration and program enhancements for the additional pay workflow. Completed HCM Security role and permission list development, and Query reporting for the PeopleSoft 9.0 HCM new system implementation. Developed business process guides for faculty and staff human resources.

Functional Testing PeopleCode Peoplesoft PeopleTools PS HCM SQL SQR (Structured Query Report) Technical Support Workday Workday HCM Project Management SAP HR
Remove Skill
PeopleSoft System Engineer
Information Technology
May 2009 - Jan 2011
  • Provide Customer Support for 20 PeopleSoft HCM/HRMS companies, providing Functional and Technical support of HCM production systems.

  • Customer Relationship Management (CRM) case management experience with Human Resources, Payroll, Benefits, Benefits Administration, Talent Acquisition Management, Self Service, Tax Releases, Time and Labor.

  • Technical Support for Case Management, providing PeopleCode, SQR, and COBOL support for six different PeopleSoft releases. Coordinating database upgrades for Clients upgrading to HCM platforms from earlier releases.

Systems Engineering Peoplesoft PeopleCode PS HCM PS HRMS SQR (Structured Query Report) Technical Support Database Upgrades
Remove Skill
Technical Upgrade Consultant
Education
Aug 2008 - Apr 2009
  • Lead Technical Consultant providing support to the programming staff, for work with CedarCrestone hosting upgrade service.

  • Completed Portal Registry of all custom components and folders for the P/S 9 Portal setup.

  • Application Engine / Component Interface development of the Electronic Personal Action Form distributed Job Action customization, install ePAF for Students and Temporary employees. Transaction entry facility for entry, approval, and processing of Hires, Rehires, Additional Jobs, Address Change, Payroll Distribution changes.

  • Time Entry and Time off Tracking – retro-fitted customizations to work with new table structures and redeveloped Application Engine processes to run in P/S 9.

  • Benefits Administration – converted Non-Benefits eligible employees to be removed from Open Enrollment and Event Maintenance, change eligibility requirements.

  • Setup PDF Checks and W-2’s for Self Service consent, reissue, view, and printing.

  • SQR Conversion – lead technician to retrofit all SQR’s to run in P/S 9 on the CedarCrestone host site.

SQR (Structured Query Report)
Remove Skill
Upgrade Consultant
Retail
Jul 2007 - Aug 2008
  • Bank Reconciliation project, designed Wachovia Bank Positive Pay and Paid Item file specifications for implementation of Check Reconciliation.

  • Application Engine/PeopleCode projects specifications for New Hires, Job Changes, Employee Reviews, and Personal Data changesfrom Unicru and distributed system file feeds.

  • System Administration, developed roles and Permission lists for Core Staff roles and Dynamic roles for distributed self-service staff. Completed trouble shooting, project migrations, Operator Security, Roles, and Permission list maintenance for all databases.

  • Completed analysis and Fit Gap of all customizations to be carried forward into the HCM 9.0

  • Completed analysis of 275 Custom SQR programs report requirements to be converted into HCM 9.0.

  • Designed Epolicy Application for distributing Company Policy documents and electronic signature capture, for store associates.

  • Managed the conversion of SQR and COBOL programs, provided direction to the programming staff to implement Person Model and test converted programs.

Cobol PeopleCode PS HCM SQR (Structured Query Report) System Administration
Remove Skill
HR/Payroll Consultant
Banking/Financial
Jan 2007 - Jun 2007
  • PeopleSoft HCM 8.8 project to support Post Implementation projects and problem resolution for HR, Payroll, and Benefits.

  • Provided support for Payroll production, G/L, Benefits 401K matching, and installed several Tax updates. Completed Payroll Performance tuning recommendations proposal, to consolidate Paygroups, Separate Pay Calendars for Weekly’s and Biweekly payrolls, and processing to split calendars for multi-processing.

  • General Ledger Interface – completed enhancements to balance debits and credits, production reruns, and issue resolution.

Peoplesoft Performance Tuning PS HCM
Remove Skill
Commitment Accounting Consultant
Education
Feb 2006 - Jan 2007
  • Commitment Accounting - designed bolt-on customization for the recalculation of Payroll Distributions. Developed program specifications and developed programs for mid-period funding changes.

  • Commitment Accounting – developed performance tuning requirements for the Payroll Distribution process, to expedite the correction of errors, removal of suspense items, and insure the all distributions where Appointment budget level distributions.

  • Time and Labor setup support for new departments, dynamic security setup, and TRC setup and Payroll testing.

  • Completed PeopleSoft HCM and Financials 8.8 to 8.9 conversions and upgraded. Provided technical support for Production System and Issues Resolution. Modified Benefits Interfaces for use on the HCM 8.9 release, completed program modifications and test transmissions to vendors. Redesigning and developing enhancements to support Commitment Accounting mid-period funding changes. Programming experience with Application Engine, PeopleCode, SQL, UNIX, FTP, and all functional modules within HCM.

Peoplesoft PeopleCode Performance Tuning PS HCM SQL Technical Support UNIX FTP
Remove Skill
HR Consultant
Utilities/Energy
Jul 2005 - Feb 2006
  • Cost Center Remediation Project – Developed PeopleSoft HRMS modifications to support the Unintelligent Cost Center codes, using PeopleTools, Application Engine, SQR, and Oracle.

  • TIBCO Web Services Middleware – developed Employee Services Programs for PeopleSoft HCM Interfaces, allowing real-time (Publish) updates from PeopleSoft Component Interface, MiddlewareInformation Bus, and TIBCO SOAP Subscriber services to updated Target Applications real-time.

  • Technical Training in TIBCO Business works, JDBC, JMS, SOAP, Topic and Subscriber Service programs.

JDBC Oracle Peoplesoft PeopleTools PS HCM PS HRMS SOAP SQR (Structured Query Report) TIBCO Training WebServices
Remove Skill
Payroll / Commitment Accounting Consultant
Education
Oct 2004 - Jul 2005
  • Time and Labor implementation with the initial HR, Payroll, Benefits modules; tested TRC and earning code definitions for Payroll and Leave Accrual processing.

  • PeopleTools development with Application Engine and Component Interface for Benefits, Time and Labor, and Payroll Commitment Accounting Modifications and Interfaces.

  • Commitment Accounting Project – completed the Funding Conversion for all employees and performed quality testing during all test phases. Programmed solutions for Split Funding, Funding End date edits, and Project & Grants funding validations. Provided technical supported for HRMS / Financial process of Payroll Distributions, Payroll Encumbrances, General Ledger Interface, and Application Messaging.

  • Account Payable Integration – completed the quality testing of Vendor / Deduction configuration.

PeopleTools PS HRMS
Remove Skill
HR Consultant
Insurance
Aug 2004 - Oct 2004
  • Equal Opportunity / Affirmative Action programming in the latest updates into PeopleSoft HRMS, installed HRMS HR Bundle 9 updates and modified custom programs to support multi-ethnicity processing.

  • Develop new programs to report Feeder Groups, Job Group Analysis, Workforce Analysis, Vets100, and EEO-1 Reporting. Developed PeopleTools project for new menu entries, table’s definitions, and SQR programs.

Peoplesoft PeopleTools PS HRMS SQR (Structured Query Report)
Remove Skill
HR Technical/Functional Analyst
Education
Jan 2003 - Jul 2004
  • Developed Health Assessments Position Management enhancement, tracking position requirements for Health Assessments and employee physical exam tracking. .

  • Designed and developed Commitment Accounting Payroll Distribution for component for employee level account distributions, interfacing with the Department Budget Comports.

  • Completed New Hire and Job Action PeopleCode enhancements for UF ID overrides setup.

  • Developed SQL and SQR development for support of HR, Payroll, Benefits, Time and Labor, e Recruit.

  • Completed Fit Gap Analysis for all Human Resources business processes.

  • Designed Decentralized Workflow process for New Hire, Rehire, and Hire Additional Job

  • Completed Human Resource current and future Business Process definitions.

Gap Analysis PeopleCode SQL SQR (Structured Query Report) Human Resource
Remove Skill
HR, Payroll, Benefits, T&L Consultant
Insurance
Sep 2000 - Jan 2003
  • Time and Labor- worked on the implementation Team for Time and Labor, developed T&L

  • Exception reports, TRC / Earning code mapping, Time Administration debugging, T&L Foundation table setup developed reporting programs to track Payable Time exceptions.

  • PeopleSoft 8.X Implementation – Converted from PeopleSoft 7.5 to 8.01 HRMS System. Developed conversion programs, customized and developed SQR programs for Payroll, HR, and Benefits. Performed fit gap testing of delivered functionality and identified areas of customizations. Experience with Payroll Production support, Installed tax releases, problem resolutions, and bundled fixes.

  • Converted Non-Employees into PeopleSoft developed Security Interfaces for LDAP.

LDAP Peoplesoft Production Support PS HRMS SQR (Structured Query Report)
Remove Skill
Lead Upgrade Consultant
Transportation
Jan 1999 - Sep 2000
  • Lead Consultant, supporting Payroll, Benefits, and Human Resource production system.

  • Developed Paysheet Load Programs coded from Timekeeping Systems, Bonus Payouts, Lump SumPayments, Time to Gross, and Legal Settlement Spreadsheets.

  • Completed Canadian Payroll implementation, customized ACH, Direct Deposits, Checks, and Production Jobs in CA7 – Unicenter. Coded all JCL, and IBM Advantis data transmissions.

Human Resource Unicenter JCL
Remove Skill
Conversion/Implementation Consultant
Government
Aug 1998 - Jan 1999
  • Technical Project Leader, responsible for System Installation, Upgrades, workstation rollout.

  • Performed Database Conversion from the GEAC payroll system, using OnDisplay toolkit.

  • Installed PeopleSoft HRMS 7.0, Application Server, and Oracle database environment.

  • Completed Upgraded PeopleTools 7.03 and P/S 7.01

  • Database technician, supported migration of Foundation, Employee, Tools, and Security Tables.

PeopleTools PS HRMS Peoplesoft Oracle Project Management
Remove Skill
Implementation Consultant
Transportation
Jan 1997 - Aug 1998
  • System Administrator for a Multi database environment, completed performance tuning.

  • Developed PeopleSoft Database strategy, providing technical direction for the Functional

  • System Administrator for Data Conversions, providing technical direction for the management andConversion of Foundation and Employee based tables. Completed Payroll and Benefits Performance Tuning Assignments.

  • Check and Direct Deposit printing, responsible for the printing and distribution of Checks and DirectDeposits SQR and Table customizations for Xerox MICR Check Printer.

Peoplesoft Data Conversion SQR (Structured Query Report) System Administration Xerox Performance Tuning
Remove Skill
Project Manager
Banking/Financial
Feb 1994 - Jan 1997
  • Technical Manager completed the installation of PeopleSoft HRMS / DB2 for Human Resources.

  • Managed the developers for the implementation of HR, Payroll and Benefits Administration.

PS HRMS Project Management Peoplesoft DB2
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Bachelor's in Business Administration and Computer Science
SUNY Brockport
Certifications
Workday HCM Certified
Skills
Peoplesoft
2016
16
SQR (Structured Query Report)
2012
11
PS HCM
2016
10
PeopleCode
2016
9
PS HRMS
2011
8
Peoplesoft (Human Capital Management)
2013
1
Peoplesoft (Payroll)
2013
1
Peoplesoft (Time and Labor)
2013
1
PS FI
2013
1
PS HR
2013
1
SQR
2013
1
PeopleTools
2016
5
Project Management
2012
4
SQL
2012
4
Technical Support
2012
4
SQL Server
2013
1
Human Resource
2004
3
Database Upgrades
2011
2
DB2
1997
2
LDAP
2003
2
Performance Tuning
2007
2
Production Support
2003
2
Quality Assurance
2016
2
System Administration
2008
2
Cobol
2008
1
Data Conversion
1998
1
FTP
2007
1
Functional Testing
2012
1
Gap Analysis
2004
1
JCL
2000
1
Oracle
2006
1
SAP HR
2012
1
Systems Engineering
2011
1
Unicenter
2000
1
Workday
2012
1
Workday HCM
2012
1
Xerox
1998
1
JDBC
2006
1
SOAP
2006
1
TIBCO
2006
1
Training
2006
1
UNIX
2007
1
WebServices
2006
1