Job Requirements
DETAILS:
The State of Wisconsin seeks a PeopleSoft Consultant IV. The role will focus on query writing, emphasizing Commitment Control (KK) and General Ledger (GL). Tasks include recommending and implementing reconciliation approaches, developing robust queries, and collaborating with various teams to define business requirements. Outputs will include reconciliation queries, monitoring queries, exception reporting, updated query training materials, and updated documentation for query standards.
REQUIRED SKILLS:
- Financial functional understanding of system data, not just technical expertise.
- Commitment Control (KK) experience.
- Understanding of General Ledger (GL) and KK reporting.
- Understanding multiple SetIDs.
- Experience with query performance issues.
- Experience with nVision.
TASKS AND DELIVERABLES:
- Review backlog of agency queries.
- Evaluate current reconciliation methodologies.
- Edit, modify, or discontinue outdated queries.
- Create new queries and potentially design new nVision layouts.
- Collaborate with STAR Finance Team, SCO, and agencies for business requirements.
- Reconciliation queries for GL accounts, funds, appropriations, operating units, and departments.
- Exception reporting, such as transactions not journal-generated from subsystem modules.
- Developing queries and potentially partnering with BI teams for dashboard presentations.
- Query training for the section.
- Application engines and BI Publisher.