A Data Warehouse system for Human resource Management in a Distributed Software Development

Abstract: The study proposed a new concept called as „Responsibility Index‟ (RIndex) that can administer all responsibilities of members involved in developing a team in a distributed team. This Index recorded and automatically updated roles changes. This research study uses the concept of a data warehouse system for data management. The objective of this study is to tracking and monitoring the performance of a developer using RIndex. A data warehousing system implemented to store the data require for the management of all the roles require of a project. The usages of this warehouse support the higher management team to manage the team without much technical knowledge because most of the analytical facilities are integrated with this system itself. Several interesting reports are a generatedallocated hour for each task, the status of the percentage of hours utilized so far. From such report, a development team can get some information about the progress of the project per task wise-Analysis, testing, etc. A report shows the group projection of status of the project such as total hours allotted for a task 'Analysis' or 'Design' etc., the percentage of hours allocation as per a task, used hours and its percentage of usages against each task and percentage of the entered projects hours. It represents almost all data appears in WBS and Gantt chart of a project. Based on the data available, the project team or manager can plan further actions. Keywords: Data Warehouse system, responsibility index, Distributed Software Development, resource management (Article History: Received 10 September 2016 and accepted 26 December 2016)