| Table of Contents |
|---|
Definition
This process is required for any Decision Support (Data Warehouse and/or Business Intelligence) projects that will require over 80 hours of work.
...
- Project Lead - Develops and maintains project plan, coordinates efforts across each team involved
- Subject Matter Expert(s) - One subject matter expert per subject area, these resources are typically provided by the functional office responsible for the business processes
- Business Analyst - Develops functional and/or technical requirements
- Data Warehouse Architect - Designs data model and technical specifications documents
- Extract Transform Load (ETL) Developer - Develops data integration (ETL) processes to load and transform data from the source system into the data warehouse
- Cognos Framework Developer - Creates Cognos packages used for ad-hoc reporting as well as predefined (canned) reports for end users
- Report Developer - Develops predefined (canned) reports for end users
- Production Control Lead - Coordinates nightly schedules for data warehouse loads, production turnover requests for both reports and ETL mappings
- Quality Assurance (QA) Lead - Develops QA documentation (test plans), leads QA process for the project
- Unit Tester(s) - Develops unit tests for ETL, Cognos Frameworks and Reports
- User Acceptance Testers - Validates that the data, reports and Cognos packages meet functional requirements. Usually the end users of the reports and Cognos packages.
...