Develop an add-on system, the WorkForce Planning system, for the Directions system, a personnel tracking and reporting system that uses data downloaded from the bank’s mainframe systems.
The WorkForce Planning system will extract and manipulate data from the Directions system and provides an interface for users to either display graph charts on-screen, print graph charts, or dump extracted graph data to MS Excel.
The system comprised the following functional areas:
| Resource Availability, |
| Current Estimated Potential, |
| Competency Analysis, |
| Promotability and Mobility, |
| Age Profile by SalaryGrade, |
| Age Range, |
| Performance Profile, |
| Time in Position, |
| Performance by Time in Position, |
| Employee Attrition, |
| Resource Availability. |
The Human Resources department of the National Australia Bank.
| Created an MS Access system according to the requirements specified by the NAB HR representatives. |
| Created a User Manual and Technical Manual as part of HR requirements. |
| Additionally, another database has been created to store employee attrition data for inclusion into Resource Availability as a projected percentage of attrition. |
| Created batch files to install the system at user sites throughout Australia. |
| Enhanced the initial system. |
|
Converted the system to MS Access97. |