Chapter Seventeen. Human Resource Allocation Matrix


graphics/hand_icon.gif

Listed in this matrix are roles , not people! Multiple roles can and probably will be assigned to one individual; occasionally, one role may be assigned to multiple individuals.

Development Step [a]

Vital Roles Involved in the Step [b]

1. Business Case Assessment

  • Business representative

  • Business sponsor

  • Data quality analyst

  • Project manager

  • Subject matter expert

2. Enterprise Infrastructure Evaluation

 

Section A. Technical Infrastructure Evaluation

  • BI infrastructure architect

  • Database administrator

Section B. Nontechnical Infrastructure Evaluation

  • BI infrastructure architect

  • Data administrator

  • Data quality analyst

  • Meta data administrator

3. Project Planning

  • Application lead developer

  • Business representative

  • Data administrator

  • Data quality analyst

  • Database administrator

  • ETL lead developer

  • Meta data administrator

  • Project manager

  • Subject matter expert

4. Project Requirements Definition

  • Application lead developer

  • Business representative

  • Data administrator

  • Data quality analyst

  • Meta data administrator

  • Subject matter expert

5. Data Analysis

  • Business representative

  • Data administrator

  • Data quality analyst

  • ETL lead developer

  • Meta data administrator

  • Stakeholders (including data owners )

  • Subject matter expert

6. Application Prototyping

  • Application lead developer

  • Business representative

  • Database administrator

  • Stakeholders

  • Subject matter expert

  • Web master

7. Meta Data Repository Analysis

  • Data administrator

  • Meta data administrator

  • Subject matter expert

8. Database Design

  • Application lead developer

  • Data administrator

  • Database administrator

  • ETL lead developer

9. Extract/Transform/Load Design [c]

  • Data quality analyst

  • Database administrator

  • ETL lead developer

  • Subject matter expert

10. Meta Data Repository Design

  • BI infrastructure architect

  • Data administrator

  • Meta data administrator

11. Extract/Transform/Load Development

  • Business representative

  • Database administrator

  • ETL developers

  • ETL lead developer

  • Subject matter expert

  • Testers

12. Application Development

  • Application developers

  • Application lead developer

  • Business representative

  • Database administrator

  • Subject matter expert

  • Testers

  • Web developers

  • Web master

13. Data Mining

  • Business representative

  • Data mining expert

  • Database administrator

  • Subject matter expert

14. Meta Data Repository Development

  • Business representative

  • Database administrator

  • Meta data administrator

  • Meta data repository developers

  • Testers

15. Implementation

  • Application developers

  • Application lead developer

  • Data mining expert

  • Database administrator

  • ETL developers

  • ETL lead developer

  • Meta data administrator

  • Meta data repository developers

  • Web developers

  • Web master

16. Release Evaluation

  • Application lead developer

  • BI infrastructure architect

  • Business representative

  • Business sponsor

  • Data administrator

  • Data mining expert

  • Data quality analyst

  • Database administrator

  • Developers (ETL, application, meta data repository, and Web)

  • ETL lead developer

  • Facilitator (not on the BI project team)

  • Meta data administrator

  • Project manager

  • Scribe (not on the BI project team)

  • Stakeholders (including data owners)

  • Subject matter expert

  • Web master

[a] Steps that can be performed in parallel are boxed together to indicate potential overallocation of resources, depending on how the roles are assigned (if different overlapping roles are assigned to the same person).

[b] Only the roles that perform vital development work are listed. Supporting roles, such as data owner, IT auditor , network services, technical support, and so on are not listed in this matrix.

[c] Although all design activities can be started and performed in parallel, the design of the BI target databases must be finalized before the design of the ETL process can be completed. This mainly affects the time allocation for the database administrator, who must actively participate in both steps.



Business Intelligence Roadmap
Business Intelligence Roadmap: The Complete Project Lifecycle for Decision-Support Applications
ISBN: 0201784203
EAN: 2147483647
Year: 2003
Pages: 202

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net