Overview
Skills
Job Details
Project is Remote within WI/Occasional onsite Mtg/Candidate must be local or willing to relocate to Madison WI before project start.
JD WI 139202
DOA/STAR PeopleSoft Analyst IV Job Description
DOA/STAR is looking for a query writer with an emphasis on Commitment Control (KK) and General Ledger (GL). Experience with nVision preferred.
Position goals: Recommend and implement a reconciliation approach and methodology that uses/develops Standard Robust queries for Agencies to perform system reconciliations and monitoring.
Required skills: (5+ years)
Must have Financial Functional Understanding of system data (Not just technical)
Must have an understanding of GL and KK reporting
Must understand Multiple Setids
Preferred skills:
Experience with Query Performance Issues
Experience with nVision
Outputs:
1- Reconciliation Queries by: GL Account Code, Fund, Appropriation, Operating Unit, & Department ID:
GL to KK
GL to Each Submodule (AR, BI, EXP, AP, AM, LA, PC, TR, CM, CST-ACCTG)
Project Costing (PC) Reconciliation
2- Monitoring queries
a. Exception Reporting (E.g. Transactions not JGENed from a subsystem module. Budget Exceptions by module.)
3- Potential partnership with the BI Team to use their front-end dashboard for presenting results.
4- Updated query training material for section.
5- Update documentation for query standards.
In Scope:
Queries
Potentially nVision and/or BI Team s front -end dashboard for presentation of results
Query training for section
Out of Scope:
Application Engines
BI Publisher
Tasks Include:
Review backlog of Agency queries
Evaluate current reconciliation methodologies
Evaluating current queries edit/modify or discontinue use
New Queries
Potentially New nVision layouts
Work with STAR Finance Team, SCO, and Agencies for business requirements
Add l Info:
Many queries written around go-live were/are:
o Inefficient
o Incorrect
o Incomplete
o Ambiguous
o Outdated (New functionality)
o Lack of understanding by the query writers