Job Title: PeopleSoft Analyst IV (REMOTE)
Location: Madison WI
Duration: 06 Months
Job Description:
The client is 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:
- 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 CSTACCTG)
- Project Costing (PC) Reconciliation
- Monitoring queries
- Exception Reporting (E.g. Transactions not JGENed from a subsystem module. Budget Exceptions by module.)
- Potential partnership with the BI Team to use their frontend dashboard for presenting results.
- Updated query training material for section.
- Update documentation for query standards.
In Scope:
- Queries
- Potentially nVision and/or BI Teams 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
Additional Info:
- Many queries written around golive were/are:
- Inefficient
- Incorrect
- Incomplete
- Ambiguous
- Outdated (New functionality)
- Lack of understanding by the query writers
Top Required Skills & 5Years of Experience:
- Must have Financial Functional Understanding of system data (Not just technical) Commitment Control (KK) experience is critical.
- Must have an understanding of GL and KK reporting
- Must understand Multiple SetIDs.
Nice to Have Skills:
- Experience with Query Performance Issues (preferred)
- Experience with nVision (preferred)