OPPapers.com

Business Req

BUSINESS REQUIERMENTS
Listed below are different phases ordered by how they will be executed.   Detail activities within each phase are listed in "Execution Approach" section of this document.

Phase 1 - Business Analysis and Design
Phase 2 – Informatica/Business Objects Installation
Phase 3 – ETL (Extract, Transform, Load) Development and testing
Phase 4 – Development of reporting universe and reports development
Phase 5 – Implementation support and user training
Phase 6 – Production Implementation and Support

Project Deliverables
• Historical data load and data mapping from current systems to new data warehouse. A standard mapping scheme that will be same for all business units will be created. Once approved, each department is required to provide all data from all business units in this standard scheme if connectivity to the source data cannot be achieved using Informatica.
• Historical data mapping will only be done for as much data as available and may not all historical data requirement in some cases.
• Report specifications document and code for reports
• Design document and code for web based portal
• Document showing Entity/ Relationships in data marts.
• Document showing Business Objects Universe.
• Business Objects Universe.
• Technical Design Document for ETL and Reporting.

EXECUTION APPROACH
Phase 1 – Business Analysis and Design
Work with users from the various business units to clearly identify business requirements and design the solution.
• Analysis and design of the historical data load from various sources within all business units.  
• Design of web based Advertising Portal to link different reporting areas to the data warehouse; this portal will also have ability to connect to external data sources using FTP to download data (CMR).
• Design for the data warehouse target data marts.
• Creation of detailed design document covering above for signoff.

Phase 2 – Software Installation
During this phase installation...