PeopleSoft Analyst - Novalink Solutions LLC

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

Requirements

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.

Top Required Skills & Years of Experience: 5+ years

• Must have Financial Functional Understanding of system data (Not just technical) Commitment Control (KK) experience is critial.

• 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)

Skill Required / Desired Amount of Experience Proven work experience with enterprise data governance Required 3 Years Proven work experience with the OneTrust platform (Data Mapping, Data Discovery, Data Catalog, Assessments) Required 2 Years Proven work experience creating documentation for internal and external audiences, technical and business audiences Required 3 Years Proven work experience supporting the creation and presentation of knowledge and training Required 3 Years