28-08-2009, 02:58 AM
Distributed Atonement Pursuit System
ABSTRACT
Category: Application Development, Enterprise.
Objective:
The aim of the project to create a distributed system to provide a structured method of submitting and managing payroll queries. The system will enable management from across a number of different sites to submit queries in a structured way to a centralized payroll department. Payroll personnel will be able to use the system to retrieve and manage the queries that will be stored in the database. The payroll manager will be to query the database to produce weekly statistics for their reports. A web based solution will ensure that management with interact access will be able to use the system without installing additional software and having to update that software when system changes are made.
Description:
The centralized payroll department of a large organization spread across a number of sites processes the salary of thousands of employees who receive their wage on a weekly or monthly basis. If an employee feels that their wage is wrong they will report this to their manager who will then submit a query to the payroll department and await a reply.
In order for the payroll department to process the query they need a number of details relating to it, a system that ensures that all the required information to process a query exists is needed. All managers should be able to submit and retrieve replies to their queries. Also should a manager submit another query relating to one previously submitted or an employee re queries an issue it is essential that their previous submitted queries can be quickly retrieved by the payroll department?
The payroll department aim to resolve all queries within two days of receiving them under their service level agreement therefore an efficient automated system would make sure this is met. Payroll personnel need to be able to view the history of a particular query and add comments to it to make sure they are not wasting time resolving queries already being dealt with and to hand queries over to a new person. A solution must be found that ensures queries are not lost and are resolved in order of arrival to make sure the department meets its service level agreement.
The payroll manager uses the queries to provide statistics e.g. the number of queries in the last week which were caused by the employee's manager and those that were caused by the payroll department in the form of reports to the sites which take a considerable amount of time to compile; this means that all queries must be stored for this purpose. The payroll manager would also like to monitor the performance of the payroll personnel who resolve the queries e.g. amount of queries resolved on a particular day.
Some of the features are:
The minimum requirements are the follows:
An online web based system for payroll queries.
The system will allow managers to submit and retrieve replies to payroll queries.
The system will allow payroll personnel to view and reply to payroll queries.
The system should have a well Presented Instruction Manual.
The system shall keep a history of payroll personnel interaction with a query which can be viewed any payroll personnel and the payroll manager.
Validation ensuring that all the required details needed to resolve the query are presented before the manager is allowed to submit a query.
A Graphical User Interface allowing to payroll manager to count the number of queries matching the criteria stated to compile their reports and to view the performance of each payroll personnel.
Security measures preventing any user other than payroll personnel and payroll manager to view and add reply to queries.
KEYWORDS:
Generic Technology Keywords: Database, User Interface, Programming
Specific Technology Keywords: Asp.Net 3.5, C#.Net, MS SqlServer-05
Project Keywords: Analysis, Design, Implementation, Testing
SDLC Keywords: Presentation, Business Object, Data Access Layer
ENVIRONMENT:
Servers:
Operating System Server: Windows XP or later
Database Server: Microsoft SQL Server-2005
Client: Microsoft Internet Explorer
Tools: Microsoft Visual Studio .Net-2008
User Interface: Asp.Net with Ajax
Code Behind: VC#.Net
Hardware Specification:
Processor: Intel Pentium or More
Ram: 512 MB Ram
Hard Disk: PC with 20GB
