PeopleSoft Analysis IV (139202)

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, CST-ACCTG)-Project Costing (PC) Reconciliation-Monitoring queries -Exception Reporting ()-Potential partnership with the BI Team to use their front-end dashboard for presenting results.-Updated query training material for section.-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 : -Inefficient -Incorrect-Incomplete-Ambiguous-Outdated (New functionality)-Lack of understanding by the query writersCandidate MUST be a WI resident or willing to relocate to WI prior to starting the role at their own expense.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