Saturday, April 10, 2010

PS Query Classification Tool

As the manager of HR Shared Services one of the major initiatives Anand took up was to streamline the auditing processes of each business activity. This was needed as the organisation was growing bigger leading to larger HR transaction volumes, higher employee churning leading to the need to have documented processes to enable business continuity and the need for data accuracy. The biggest factor playing in Anand's mind was Payroll accuracy - given that his company was using Peoplesoft Global Payroll which had multiple feeder systems like Peoplesoft Absence Management, Time and Labor and Benefits - it was a nightmare for his team to ensure data consistency across the various modules. Anand worked closely with Praveen from the IT team to build audits at every stage of the payroll process and overtime the sheer number of audit queries became too large for the team to handle manually. With no tools at his disposal, Anand was forced to maintain the list of audit queries in an excel sheet which again had to be updated everytime a new query was added or retired. Praveen came to realise this constaint while working with Anand's team and thought why he could not develop a simple tool that will help Anand map a PS Query to the appropriate business process and also provide another page which would list all the PS Queries corresponding to a business process and let the users execute the query directly. He immediately got working on the idea and came up with the PS Query Classification Framework which he christened - QBox.
Anand just loved the tool as it helped him manage his audit process much better, his team mates could just access the QBox page and view all the up-to-date queries for a business process, now there was no way anyone would miss running a query and maintaining the query list was as easy as clicking a button!

No comments: