CAPPS Financials Reports Analyst (PeopleSoft Financials version 9.2)

Role: CAPPS Financials Reports Analyst (PeopleSoft Financials version 9.2) Location: Austin, TX (Hybrid) Duration: Long Term Perform highly advanced 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. Plan, design, develop, implement, support, and maintain the information technology security measures to safeguard system information. Participate in project‑level activities, including expansions that include additional module implementations or enhancements for agencies, cyclic processes such as fiscal year‑end, calendar year‑end, State of Texas legislative changes, federal mandates, and third‑party integrations. Perform all duties following CPA processes, policies, and procedures within project scope and on schedule in accordance with milestones, deliverables, and due dates. Responsible for the CAPPS Financials 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). Provide 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. Ensure 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. Work 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. Validate that only accurate data is produced, security including multi‑tenancy is enforced, the system performs efficiently, and all applicable policies are enforced. Perform 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 participate in CPA Major Incident Management (MIM) process for P1 and P2 incidents according to module responsibilities. Participate in Disaster Recovery and Upgrade Testing activities. Make presentations at CAPPS User Groups and the CAPPS Steering Committee. Participate 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. Perform other related work as assigned. Minimum Requirements 8+ years of experience working directly for or supporting a Texas State Government agency. 8+ years of experience providing reporting support for PeopleSoft Financials 9.2 modules. 8+ years of knowledge and understanding of State of Texas policies and procedures. 8+ years of experience with Financial Table Entity Relationship Diagrams (ERDs). 8+ years of experience preparing WCAG 2.1‑compliant materials and reports. 8+ years of experience designing, executing, and documenting User Acceptance Testing (UAT) and Regression Testing for upgrades, PUM cycles, and patch deployments. 8+ years of experience interpreting contractual language and ensuring vendors meet contractual obligations. 8+ years of experience with data integration, data quality, and Software Development Life Cycle (SDLC) methodologies. 8+ years of experience developing and supporting cross‑module reports involving General Ledger (GL), Accounts Payable (AP), Purchasing (PO), Asset Management (AM), Inventory (IN), Travel & Expense (T&E), and Project Costing (PC) modules. 8+ years of experience analyzing PeopleSoft FSCM data structures, including effective dating rules, table relationships, and multi‑row logic. 8+ years of experience writing CAPPS Complex Reports using SAP Business Objects. 3+ years of experience supporting CAPPS Central production and expansion activities for more than 100 agencies and five Hub instances. 3+ years of knowledge and experience with ITIL principles and practices, including IT Service Management (ITSM) and IT Asset Management (ITAM). Preferred Experience 4+ years of CPA experience participating in Fiscal Year‑End processes, organizational changes, and legislative mandates for CAPPS. 4+ years of customer‑facing experience supporting CAPPS expansion efforts for Central and Hub agencies. #J-18808-Ljbffr Innovee Consulting LLC