What are the responsibilities and job description for the PeopleSoft Analyst position at Novalink Solutions LLC?
Job Description
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
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 :
