Deliverables Resulting from These Activities

Roles Involved in These Activities

• Application developers

  The application developers work with the operations staff to move the report programs, query scripts, interface programs, and online help function programs into the production application program library.

• Application lead developer

  The application lead developer supervises the implementation activities of the access and analysis portion of the BI application. He or she is in charge of setting up the production application program library and writing the access and analysis portion of the operating procedures and the reference guide. He or she also has the responsibility of setting up the application report programs on the job scheduler.

• Data mining expert

  The data mining expert works with the database administrator to create, revise , and maintain the data mining databases for the planned data mining activities. Data mining is an iterative and ad hoc endeavor that requires ongoing changes to the data mining databases, the analytical data models, and the data mining operations.

• Database administrator

  The database administrator creates the production BI target databases and the production meta data repository database and grants appropriate access authority for these production databases. He or she must run the initial load process and the historical load process to load the BI target databases. He or she schedules database maintenance activities ( backups , reorganizations) as well as ongoing database monitoring activities (for performance, growth, usage). He or she also reviews the capacity plans for processors, disk storage, and network bandwidth.

• ETL developers

  The ETL developers work with the operations staff to move the ETL programs into the production ETL program library.

• ETL lead developer

  The ETL lead developer supervises the implementation activities of the ETL portion of the BI application. He or she works with the operations staff to prepare the production environment and set up the production ETL program library. He or she should write the ETL portion of the operating procedures and the reference guide. He or she is also responsible for setting up the ETL process on the job scheduler.

• Meta data administrator

  The meta data administrator is responsible for moving all the meta data repository programs into the production meta data repository program library. He or she also has to run the meta data migration (load) process and schedule ongoing data quality monitoring activities, such as gathering meta data metrics and performing data quality spot checks.

• Meta data repository developers

  The meta data repository developers assist the meta data administrator with moving all the meta data repository programs into the production meta data repository program library.

• Web developers

  The Web developers are responsible for moving their Web pages and scripts from their local servers to the production Web server.

• Web master

  The Web master is responsible for setting up the production Web server. He or she also has to work with the staff of security services and network services to install and test the firewall and other required security features.