Download
1 / 33
330 likes | 436 Views
Resource Allocation Tracking System Final Design Presentation. Dec 0909 Client: Zirous Inc. Faculty Adviser: Tien Nguyen Team Members: Kirk Olson Tyler Lamb Jimmy Woestman Ben Petersen. Problem and Need Statements. Problem
E N D
Resource Allocation Tracking SystemFinal Design Presentation Dec 0909 Client: Zirous Inc. Faculty Adviser: Tien Nguyen Team Members: Kirk Olson Tyler Lamb Jimmy Woestman Ben Petersen
Problem and Need Statements • Problem • Zirous Inc. is a growing company whose employees are working on numerous different projects. Managers are required to create and maintain reports on the progress and status of their employees, which are presented to upper management. • Need • An easy to use web application to track employees and projects. Reports need to be easily generated based on the submitted tracking information.
Functional Requirements FR01: Provide a web interface that allows managers to view project and resource information.FR01.1: Resource Utilization Overview.FR01.2: Project Overview.FR01.3: Personnel Overview. FR02: Provide a web interface to allow Managers to modify personnel and project information.FR02.1: Add new personnel to a project.FR02.2: Edit personnel attributes.FR02.3: Edit project attributes.FR02.4: Update project progress. FR03: Provide printable reports.FR03.1: Resource Availability Report.FR03.2: Client Program/Project Report. FR04: Interface with T2 database to retrieve personnel information. FR05: Interface with Sugar database to retrieve project information. FR06: RATS must use Zirous’ existing LDAP lookup for secure user authentication.
Non-Functional Requirements NFR01: RATS must be able to be accessed from any location with internet access. NFR02: RATS must be able to scale as Zirous grows in size. NFR03: RATS must be easier to use than the current spreadsheet solution. NFR04: RATS must be able to handle multiple concurrent users using the system. NFR05: The following technologies must be utilized: Java Oracle XE Oracle Application/ OC 4 J Apache Struts2 Toplink Apache Ant AJAX NFR06: The web interface must be responsive to user input. NFR07: RATS must be developed in a manner that makes it easy to maintain and improve in the future.
Market and Literature Survey • Resource Tracking applications currently do exist • Zirous wants a custom built application that will interface with their internal software
Deliverables • RATS Application • RATS Source Code • Integration manual • User Manual • Documentation
Risks • Learning Curve • Many technologies must be used that are new to the team. Will need to learn how they work and how to use them effectively. • Communication with Client • Zirous Inc. is located in Des Moines. Our schedule of available time is the opposite of theirs. • Integration with T2 and Sugar • Will need to learn how to connect to external databases and be able to work with the data given to us.
User Interface Specification 1: Navigation Bar The navigation bar contains direct links to Home, Employee Projects and to Logout. The Projects link expands to a list of links: All Projects, Create Project and Update Project. 2: Bread Crumbs This will contain links to the last pages the user has visited.
The Homepage Description 1: Filter Criteria Here the user can enter any criteria they wish to filter by. Pressing Filter regenerates the Resource Grid below. 2: Resource Grid Every Resource is listed in this grid, with their name also being a link to their specific Employee Project page. The grid lists the Resource’s allocation percentage for each week. This percentage is an average for the week, so for example if a Resource has a day off, but is allocated 100% for the other four days of the week, his/her percentage would be 80%. The colors behind each percentage correspond to the Key above and are there to indicate the status of the project(s) the Resource is working on. When the user is filtering by a Client and/or Project, the percentages displayed will be specific to the filter. Also, when filtering this way, different background colors will be used that will indicate if the resource is allocated to other projects during the week. When the user hovers over a percentage block a list of all Projects that Resource is allocated to for the week will be shown in a pop-up window. This pop-up window will list each Project’s Status and percentage allocation of the Resource to that Project. This list will be sorted by Project status in this order: Closed/Won, Negotiation Review and finally Proposal Price Quote. 3: Key This key simply explains what each color in the grid means. Each color corresponds to a possible status of each project, Closed/Won, Negotiation/Review or Proposal Price Quote. Projects with statuses other than these three are not shown on this page. When the user is filtering by a specific Client and/or Project the key will change to reflect the new meanings of the colors. 4: Excel File When this button is pressed the user is prompted to download an Excel file containing the data shown in the grid below (a Resource Allocation report).
Create A Project Description • The Client, Project Name and Project Manager are already tied together in the T2 and Sugar Databases and cannot be changed in RATS. The drop-down fields for these pull the possible selections from those databases. Thus, if a Project is selected then the Client and Project Manager will be selected automatically. If a Client or a Project Manager is selected first, then only applicable Projects will be available in the Project Name drop-down menu. • The other drop-down field is Project Status and the possible selections are: Closed/Won, Negotiation/Review, Proposal Price Quote, Complete, Canceled and Invalid. • Clicking the Close Button will abandon any text that was selected or inserted and return the user to the previous page. Clicking Save will add the Project to RATS. If the user enters an invalid date or leaves a required field blank, then he will instead be prompted to fix those fields before saving.
Time and Percentage Update Subpage Description 1: Title Bar This simply lists the Client, Project Name and Resource Name that is currently being modified. It is listed so that the user doesn’t have to scroll to the top of the page if he/she forgets. 2: Date, Rate and Percentage Here the user enters the start date, end date, hourly rate and allocation percentage for a new duration of time that the Resource is assigned to the Project. The Hourly Rate field will automatically be filled with the previous Hourly Rate for the Resource, as it will usually not change. The Allocation Percentage is the percentage of the Resource’s time that will be designated for this Project during the specified time period. Clicking Close will abandon any text inputted into the fields and close this sub-page. Clicking Save Time Period will add this time period to the list below. If the time periods overlap with any existing time periods then the user is instead prompted to enter different dates. If the time period covers a paid holiday then the time period is automatically broken into two time periods on both sides of the holiday and then added. 3: Time Period Listings Here all the existing time periods in which the Resource is assigned to the Project are displayed, along with the corresponding percentage and hourly rate. Clicking Edit will allow the user to modify the time period and clicking Remove will remove the time period assignment of the Resource.
Update Project Page Description 1: Project Fields The fields Client, Project Name and Project Manager are tied together in the T2 Database. The data in these fields cannot be modified for a Project, but are instead used to select a specific Project. Once a Project is selected, text can be added or modified in any of the other fields. If the user navigates to this page by selecting a specific Project from another page, then this page is already loaded with that Project’s information. 2: Add Resource This field will allow the user to type in a Resource Name. The field will have auto-complete capability, so the user will only have to type in the first few letters of the Resource Name. Clicking Add Resource then adds the Resource to the list below. Clicking Add Like allows the user to select an already assigned Resource and then the new Resource is added with the same time periods and percentages (see Time and Percentage Update below). 3: Save or Close Clicking Save will save all the changes/additions to the RATS Database. Clicking Close will abandon all the changes/additions (if any) and return the user to the last page he/she was at. 4: Remove Project Clicking this will remove the Project from the RATS Database. A pop-up confirmation will first ask the user if he/she is sure they want to remove the Project. 5: Resource List This list will contain all the Resources assigned to the Project. Clicking Remove will remove the Resource’s assignment to the Project. Clicking Edit will cause the Time and Percentage Update sub-page to be displayed below. 6: Time and Percentage Update Area This area will initially be blank, but when a Project is selected then the Time and Percentage sub-page specific to the current Project and Resource will be displayed here.
All Projects Page Description 1: Filter Criteria The user may enter any criteria he/she wishes to filter by. Pushing the Filter button regenerates the Project Grid below. 2: Project Grid This grid lists every project along with its corresponding Client, Manager, Start Date, End Date and number of Resources each week. The Client, Project and Manager names are also links to their corresponding Employee Project or Update Project page. The headers for each column can also be clicked with will sort the data by that field. The number of resources per week is calculated by the total number of Resource hours allocated divided by 40. The colors behind these numbers correspond to the status of the Project and are defined by the Key above it. Hovering over a Project Name will display a pop-up window with a list of all Resources assigned to that Project along with the total hours each Resource is assigned to that Project. This will be the total hours for the duration of the Project and will not be based on the search criteria. Also, hovering over a “Number of Resources” block will display a pop-up window with a list of Resources assigned to the Project that week along with the number of hours that each Resource is assigned to the Project for that week. 3: Key This key simply explains what each color in the grid means. Each color corresponds to a possible status of each project, Closed/Won, Negotiation/Review or Proposal Price Quote. Projects with statuses other than these three are not shown on this page. Also clicking any of the three statuses in the Key will sort the Projects in the grid by their status during the first week that is currently displayed. 4: Excel File When this button is pressed the user is prompted to download an Excel file containing the data shown in the grid below (an All Project report).
Employee Page Description 1: Return This button will allow the user to return to the Resource Allocation Overview page if they navigated to this page by choosing an employee from the Resource Grid. 2: Resource Name Filter A Resource can be selected from the drop down menu. Clicking the Filter button displays the Employee Project List below for that Resource. If the user navigated to this page from the Resource Allocation Overview Page, then this page is already filtered for the specific Resource they chose. 3: Employee Project List When filtering by a Resource, a list of all the Projects that Resource is assigned to is displayed along with the Client, Project Manager and Status of that Project. Projects with a status of Complete, Canceled or Invalid will not be displayed. Clicking a Project Name will cause the Time and Percentage Update sub-page to be displayed below. 4: Time and Percentage Update Area This area will initially be blank, but when a Project is selected then the Time and Percentage sub-page specific to the current Project and Resource will be displayed here.
Use Cases Login Logout
Use Cases Cont. Create A Project Assign Employees To Project
Use Cases Cont. Remove Employee From Project Update Project
Use Cases Cont. Remove Project Edit Employee
Use Cases Cont. Generate Project Status Report Generate Resource Allocation Report
User Privileges Manager Employee • Since the RATS Web-Application is designed with the Zirous Inc. Managers in mind, the “Manager” role is given the most privileges. A user of the “Manager” role can do anything in the RATS Application. • A User of the “Employee” role is not afforded as many privileges as a User of the “Manager” role. A User of the “Employee” role is allowed to access their own employee page as well as the page of any project the User has been allocated to. While on these pages the User is not allowed to enter any data or make any saves to the database. It is a read-only mode.
Test Plan • Main method of testing will be Unit Testing • JUnit • Test the boundaries of values and methods • Ensure individual methods work • Using DJUnit as a code coverage tool. • User Acceptance Testing with Zirous Inc. • Integration Testing with Production Environment at Zirous Inc.
