PeopleSoft Payroll Functional Consultant

*** Very long term project; Remote; need 3 references 

Webcam interview

The selected Vendor''s Candidate will be part of CPA''s Fiscal Management Statewide Fiscal Systems team, supporting the Centralized Accounting and Payroll/Personnel System (CAPPS) Program. The CAPPS Program for this engagement comprises the following components:

• HR/Payroll (inclusive of Recruit functionality)
• Financials
• STARR
• All ancillary systems

The selected Vendor''s Candidate must be adaptable and able to learn and integrate new systems and platforms as needed, such as CGI Advantage.

CAPPS System Defined

CAPPS HR/Payroll is the State of Texas Enterprise Resource Planning (ERP) system, built on Oracle PeopleSoft Human Capital Management (HCM) version 9.2, Image 53. The system includes Human Resources, Payroll, Position Management, Commitment Accounting, Time and Labor, Performance Management, and CAPPS Recruit (TAM/CG).

Annual Professional Training Requirement

In addition to other CPA training requirements, the following professional training requirement applies on an annual basis during the CPA Contract Term, including each renewal term, under the CPA Contract resulting from this solicitation:

• For no compensation from CPA, the selected Vendor''s Candidate shall be required to complete a minimum of ten (10) hours of professional training in a relevant area of expertise associated with the Services provided under the CPA Contract.
• The professional training, as determined by the Vendor and/or the selected Vendor''s Candidate, shall be conducted and completed by the selected Vendor''s Candidate on personal time.
• If the professional training is intended to be conducted during the CPA-approved work schedule, the selected Vendor''s Candidate must coordinate the associated time off with the CPA Supervising Manager, as applicable.
• The Vendor and/or the selected Vendor''s Candidate shall be fully responsible for all associated costs, including but not limited to tuition, materials, conference fees, and/or travel expenses.
• CPA will not approve or make payment for any hours associated with the professional training requirement.
• By July 31st of each CPA Contract Term, the Vendor shall provide the CPA Contract Manager () with an annual professional training report, documenting the completed professional training hours and courses.

Position Requirements

The CPA Work includes, but is not limited to, the following:

Performing highly advanced (senior-level) consultative services and functional assistance work

Related to supporting the CAPPS Program.

Responsible for functional CAPPS HR/PY Payroll module support

• Provide day-to-day functional support for the PeopleSoft 9.2 Payroll module.
• Troubleshoot payroll issues, including calculation errors, retro pay, tax discrepancies, and integration failures.
• Support the full payroll cycle: pay calendars, paysheets, payroll calculation, confirmation, and post-confirmation auditing.
• Maintain payroll configuration, including earnings codes, deduction codes, garnishments, tax setups, pay groups, and tax reporting.
• Collaborate with Time & Labor and Human Resources (HR) teams on end-to-end process accuracy.
• Create, modify, and troubleshoot PS/Queries for payroll reporting and data validation.
• Work with technical teams to support enhancements, integrations, data loads, and application fixes.
• Assist in applying PUM updates, testing patches, and validating tax updates.
• Document functional procedures, test scripts, and configuration changes.
• Provide user support, training, and guidance to payroll operations teams.
• Participate in audit activities and ensure adherence to internal controls.
• Provide agencies with assistance with quarterly 941 reconciliations to resolve discrepancies.
• Perform CYE configurations specific to CAPPS Central processing.
• Perform W-2 validation, and reconciliation.
• Collaborate and coordinate with Payroll Policy to file W-2/W-3s with the Social Security Administration on time and accurately.

Responsible for assisting with payroll configurations and processing

• Setting up earning codes, accumulators, pay groups, rate codes, pay calendars, deductions, garnishments, and commitment accounting.
• Running payroll cycles (On-Cycle, Off-Cycle, Return Monies, Cancellations/Reversals).
• Troubleshooting payroll errors and resolving payroll production issues.
• Creating and validating W-2 form during CYE.
• Oversight for tax update implementations.
• Handling Right-to-Stop incentives.
• Oversight for 3rd-Party Sick Pay during CYE.
• Creating and supporting the synchronization of CAPPS payroll with SPRS/USAS using an online interface in CAPPS.
• Supporting payroll approval workflows between systems.

Responsible for assisting with functional configuration skills

• Setting up tables (job codes, positions, departments, compensation, etc.)
• Understanding HR business units, Set IDs, and Table structures.
• Configuring workflow (AWE-Approval Workflow Engine).
• Creating queries using PS/Query and SAP Business Objects.

Responsible for providing functional support for the CAPPS HR/PY applications

Shall be a point of contact for CAPPS agencies as applicable.

Responsible for the CAPPS HR/PY functional design phase

Which includes creating and/or reviewing Functional Design Documents (FDDs), performing functional configuration system changes, and other functional activities assigned. Functional configurations include, but are not limited to, PeopleSoft delivered features (e.g., Page and Field Configurator, Drop Zones, Event Mapping, Page Composer, and others). Additionally, responsible for assisting with AWE – Approval Workflow Engine, including but not limited to:

• Workflow Configuration and Setup.
• User and Role Management.
• Notifications and Worklist Management.
• Monitoring and Troubleshooting.
• Customization and Extensibility.
• Performance and Maintenance.
• Testing and Documentation.

Responsible for technical skillsets for applicable tools

• Understanding Application Designer (records, fields, pages, components).
• Integration Broker (Web Services, REST/SOAP Integrations).
• SQR and BI Publisher report customization.
• SQL Proficiency.
• Understanding of PeopleSoft security, inclusive of State of Texas multitenancy requirements.

Planning, designing, developing, implementing, supporting, and maintaining information technology security measures

To safeguard system information.

Responsible for assisting with monitoring all payroll batch jobs

• Tracking job schedules.
• Monitoring job execution.
• Detecting and responding to failures.
• Validating output.
• Managing dependencies.
• Performance tuning.
• Documentation.
• Proper communication and escalation.
• Ensuring compliance when schedules must be altered.

Responsible for assisting with tools and environment knowledge

• PUM (PeopleSoft Update Manager) and Change Assistant.
• Fluid UI changes and page navigation.
• Lifecycle management and selective adoption.
• Elasticsearch/Search Framework.
• Data migration and compare reports.

Responsible for cross-functional collaboration

• Strong problem-solving and troubleshooting.
• Ability to interpret the State of Texas HR policies into system configuration and code modifications.
• Requirements gathering for applicable break/fix or system enhancements.
• Documentation and testing (UAT, regression testing).
• Incident management in systems like ServiceNow and BOSSDesk, with the ability to keep multiple systems synchronized with timely updates.
• Communication skills when working with policy personnel, other analysts, 100+ agencies, and our Managed Services Tier 3 vendor.
• Understanding and accounting for interdependence on legacy systems (SPRS, HRIS, etc.).
• Providing structured cross-training to support junior analyst capability growth.
• Providing comprehensive training and support to agency personnel in accordance with established requests and organizational requirements.

Responsible for project-level participation

• Expansions that include additional module implementations or enhancements for agencies.
• Cyclic processes such as fiscal year-end, calendar year-end, W-2 validation for distribution, State of Texas legislative changes, federal mandates, and third-party integrations.

Performs all duties following CPA''s processes, policies, and procedures

Within project scope and on schedule in accordance with milestones, deliverables, and due dates.

Responsible for assisting with the Fiscal Year-End

• Reconciliations and Verifications.
• System Configurations and Maintenance.
• Budget Loads (BLS) as requested by agencies to assist with the large number of commitment accounting changes required.

Provides Level 2 Service Desk support

Including complex ticket handling, advanced troubleshooting, clear documentation, and basic system configuration, all following established, auditable processes in coordination with a Managed Services vendor responsible for Tier 3 work.

Responsible for ensuring that all digital products and content meet WCAG 2.1 accessibility standards

This includes maintaining perceivable, operable, understandable, and robust experiences for all users, regularly reviewing content for compliance, and implementing updates or remediation whenever accessibility issues are identified.

Works under minimal supervision

Relying on experience and judgment to plan and accomplish goals, independently performing a variety of complicated tasks. Established processes and procedures must be followed.

Responsible for overseeing and acting as the first line of support

To ensure that only accurate data is produced, security, including multi-tenancy, is enforced, that the system performs efficiently, and that all applicable policies are enforced.

Performs all work in accordance with Information Technology Infrastructure Library (ITIL) principles and practices

For IT activities such as IT service management (ITSM) and IT asset management (ITAM) that focus on aligning IT services with the needs of the business.

Actively participates in CPA''s Major Incident Management (MIM) process

For P1 and P2 incidents according to module responsibilities.

Participates in Disaster Recovery and Upgrade Testing activities

Makes presentations at CAPPS User Groups and the CAPPS Steering Committee as requested.

Participates as directed in an annual SOC-1 attestation audit

Designed to ensure that controls are effectively designed and operated to ensure the accuracy and security of all information contained/processed via CAPPS.

Any enhancements, process changes, or system fixes

Consider security, availability, processing integrity, confidentiality, and privacy as solutions are suggested, approved, and implemented.

Performing other related Work as assigned

Skills/Requirements

• Extensive knowledge of federal labor laws. Required 8 Years
• Extensive knowledge and experience performing system configuration changes. Required 8 Years
• Extensive technical skillsets needed with App Designer, Integration Broker, assorted SQR/SQL, BI Publisher, SAP Business Objects, etc. to support functional responsibilities. Required 8 Years
• Extensive knowledge of security best practices, NIST standards, and multi-tenancy applicability for a statewide ERP instance. Required 8 Years
• Extensive experience creating and managing a strategic roadmap by combining strong planning skills, functional insight, and effective cross-functional communication. Required 8 Years
• Extensive experience supporting the Payroll module in PeopleSoft HCM version 9.2. Required 8 Years
• Extensive knowledge supporting and providing support with batch jobs, i.e., Run My Jobs (RMJ) Required 8 Years
• Experience preparing and presenting executive-level presentations. Required 8 Years
• Experience gathering and presenting applicable data in support of a variety of audits and open records requests. Required 8 Years
• Experience in interpreting contractual language and integrating it into daily workflows, while consistently holding vendors accountable to contractual requirements Required 8 Years
• Experience in planning and coordinating the Fiscal Year Process at a statewide level Required 8 Years
• Extensive knowledge and experience managing the Approval Workflow Engine (AWE) Required 8 Years
• Experience preparing WCAG 2.1-compliant materials for distribution. Required 8 Years
• Extensive familiarity with support tools such as PUM, Fluid, and Elastic Search. Required 5 Years
• Experience providing direct payroll support to multiple agencies, including assisting with quarterly 941 reconciliations, resolving payroll discrepancies, and coordinating corrective actions across statewide systems. Required 5 Years
• Knowledge of Information Technology Infrastructure Library (ITIL) principles and practices for IT activities such as IT service management (ITSM) and IT asset management (ITAM) that focus on aligning IT services with the needs of the business Required 3 Years
• Experience participating in Disaster Recovery exercises. Preferred 8 Years
• CPA experience performing SQL actions needed to keep the CAPPS and SPRS systems in sync Preferred 8 Years
• Experience providing Tier 2 Service Desk Support for a large network (30 or more) of agencies with a Managed Services vendor providing Tier 3. Preferred 8 Years
• Experience performing functional project management activities in support of CPA’s CAPPS program Preferred 8 Years
• Extensive knowledge and understanding of State of Texas applicable policies. Preferred 8 Years
• Extensive Texas public sector experience, directly working for or supporting a large network (30 or more) of Texas state government agencies Preferred 8 Years
• Experience with and knowledge of production support activities for CPA’s legacy Statewide Financial Systems Preferred 8 Years