TX Govt CAPPS HRPeopleSoft HCM Analyst (15+)

Job ID: TX-304FM202727 ()

Remote TX Govt CAPPS HR/PeopleSoft HCM Analyst (15) with Payroll/Personnel WCAG UAT PUM data integration data quality ITIL/ITSM/ITAM/CG Query Manager/Viewer/PS BI/XML Publisher experience

Location: Austin TX (Texas Comptroller of Public Accounts)
Duration: 12 Months

Skills:
8 Required Extensive Texas public sector experience directly working for or supporting a Texas state government agency
8 Required Extensive experience in reporting support for the HR/Payroll modules in PeopleSoft HCM version 9.2
8 Required Extensive knowledge and understanding of State of Texas applicable policy.
8 Required Experience preparing WCAG 2.1-compliant materials for distribution.
8 Required Experience designing executing and documenting structured UAT and regression testing for reporting impacts during upgrades PUM cycles or patch deployments.
8 Required Experience in interpreting contractual language and integrating it into daily workflows while consistently holding vendors accountable to contractual requirements
8 Required Extensive knowledge of/experience with data integration data quality and SDLC processes and methodologies
8 Required Experience developing or supporting cross module reports that incorporate data from HR Payroll Time & Labor Position Management or related modules.
8 Required Extensive experience analyzing PeopleSoft HCM data structures including effective dating rules table relationships and multi row logic to support complex statewide reporting requirements.
3 Required Experience with CAPPS Central production and expansion functional support activities for more than 100 agencies and 5 Hub instances.
3 Required Knowledge of Information Technology Infrastructure Library 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
4 Preferred CPA experience participating in Fiscal Year-End processes specific to reorganizational changes and legislative mandates for CAPPS
4 Preferred CPA experience performing customer-facing responsibilities in support of the CAPPS expansion efforts for Central and Hub agencies

SCOPE OF SERVICES.
Services Overview. The selected Vendors Candidate will be part of CPAs 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 and all ancillary systems. The selected Vendors 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 ERP system. It is based on Oracle PeopleSoft Human Capital Management (HCM) version 9.2 Image 53. The system includes the following modules: Human Resources Payroll Position Management Time and Labor Performance Management and CAPPS Recruit utilizing TAM/CG.

The selected candidate must exhibit extensive knowledge of the HR/Payroll reporting tools with proficient knowledge of PeopleSofts integration with all other deployed modules and ancillary tools and systems.

Annual Professional Training 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 Vendors 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 Vendors Candidate shall be conducted and completed by the selected Vendors Candidate on personal time. If the professional training is intended to be conducted during the CPA-approved work schedule the selected Vendors Candidate must coordinate the associated time off with the CPA Supervising Manager as applicable.
The Vendor and/or the selected Vendors 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.
Develop modify and maintain Reports using PeopleSoft reporting tools such as:
Query Manager / Query Viewer
BI Publisher (XML Publisher)
PS/Query expressions and complex joins
Develop modify and maintain reports using CPA-provided tools such as SAP Business Objects.
Translate business requirements into technical specifications ensuring reports align with statewide policy regulatory requirements and agency specific needs.
Work closely with functional analysts and business owners to gather report requirements validate logic and ensure accuracy of data sourced from PeopleSoft tables and views.
Create and maintain report templates layouts and bursting setups (BI Publisher) ensuring consistency with statewide branding and accessibility standards.
Analyze PeopleSoft data structures including table relationships keys and effective dating rules to ensure correct data extraction.
Optimize report performance including tuning queries indexing recommendations and improving runtime for high volume statewide datasets.
Support reporting during upgrades patches and project releases including impact analysis remediation of broken reports and migration coordination through environments.
Ensure data security and compliance making sure reports respect row level and role based security sensitive data handling rules and statewide privacy standards.
Produce documentation such as report inventories design specifications data dictionaries run instructions and test plans.
Participate in system testing including UAT and regression testing focused on data integrity and report output accuracy.
Provide end user support training troubleshooting and resolution for reporting issues across agencies or statewide users.
Collaborate with Managed Services Tier 3 support staff on integration points data fixes audit reports and cross module reporting needs.
o Planning designing developing implementing supporting and maintaining the information technology security measures to safeguard system information.
Responsible for project-level participation including but not limited to:
o Expansions that include additional module implementations or enhancements for agencies
o Cyclic processes such as fiscal year-end calendar year-end State of Texas legislative changes federal mandates and third-party integrations.
o Performs all duties following CPAs processes policies and procedures within project scope and on schedule in accordance with milestones deliverables and due dates.
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).
Performs all duties following CPAs processes policies and procedures within project scope and on schedule in accordance with milestones deliverables and due dates.
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 validating 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 CPAs 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.
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.

304FM202727 docx

innoSoul Inc. is an Information Technology company and offers technology solutions in various platforms to different business domains. More specifically business solutions for Application Development System integration network or software installation support Custom Web Development Hosting solutions. Our value-added solutions leverage technology to enhance business performance increase productivity and secure data.