Peoplesoft Analyst-IV (PeopleSoft Query Writer)

Madison, Wisconsin 53703 (Remote with Travel)

Contract

Job Description

Position Goals:

We are looking for a query writer with an emphasis on Commitment Control (KK) and General Ledger (GL). Experience with nVision preferred.

Project Details (project overview, who the contractor will work with, soft skills needed, etc.):

Will recommend and implement a reconciliation approach and methodology that uses/develops Standard Robust queries for agencies to perform system reconciliations and monitoring. Will review backlog of agency queries, evaluate current reconciliation methodologies, evaluate current queries, create new queries and potentially work with new nVision layouts. Will work with STAR Finance Team, SCO, and agencies for business requirements.

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:

1. ·Queries

• ·Potentially nVision and/or BI Team’s front -end dashboard for presentation of results
• ·Query training for section

Thanks

Lalit