PeopleSoft Analyst

PeopleSoft Analyst

  Not Disclosed

  Madison, WI

  4.0 Months

  Not Disclosed

  Not Disclosed

  Government - State

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 the client to perform system reconciliations and monitoring. Will review backlog of the client queries, evaluate current reconciliation methodologies, evaluate current queries, create new queries and potentially work with new nVision layouts. Will work with the client Finance Team, SCO, and the client for business requirements.


Position goals:
• Recommend and implement a reconciliation approach and methodology that uses/develops Standard Robust queries for the client 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 the client queries
• Evaluate current reconciliation methodologies
• Evaluating current queries – edit/modify or discontinue use
• New Queries
• Potentially New nVision layouts
• Work with the client Finance Team, SCO, and the client for business requirements

Add’l Info:
• Many queries written around go-live were/are:
• Inefficient
• Incorrect
• Incomplete
• Ambiguous
• Outdated (New functionality)
• Lack of understanding by the query writers

Note:
8:00 AM-5:00 PM
Mostly remote with occasional onsite days required.
Candidate MUST be a resident or willing to relocate prior to starting the role at their own expense.
VIVA is an equal opportunity employer. All qualified applicants have an equal opportunity for placement, and all employees have an equal opportunity to develop on the job. This means that VIVA will not discriminate against any employee or qualified applicant on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.