Business Requierments
Essay Preview: Business Requierments
Report this essay
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 of Oracle, Business Objects and Informatica on test and production servers will be done. This activity will also include configuring reporting environment and creating user groups. We will also install client software on development workstations and validate connectivity.
Phase 3 – ETL Development and testing
Develop code and perform testing for
Historical data load
Incremental ETL
The development of the ETL will be done based on the Data Warehouse target marts designed during Phase I. The Data Warehouse target data mart will be same for departments. The target data mart for the Universe will be designed during this phase and testing will be based on test data from each business unit before the actual implementation for each site.
Phase 4 – Universe and Reports Development
Write specifications, develop code and perform testing for
Business Objects reporting Universe.
Reports as per detailed design.
Additionally, building system documentation we begin.
Note: The report specification development (except for the initial report/s) and development will be done in parallel. Business units will signoff on each report specification before development on the particular report can begin.
Phase 5 – User Acceptance and Training
Support acceptance testing. Any discrepancies from the specifications will be fixed. Any deviation from specifications will be subject to the Change Request Process as described in later section of this document.
Phase 6 – Implementation & Support
The Implementation phase will consist of the following:
Transfer of Final Code to Production
Go-Live Load of Data Warehouse
Will be done for each Business Unit.
PROJECT PROCESS
In order to meet the implementation schedule as per this document the project MUST start ASAP.
Develop a standard scheme, which will be same for all business units.
Development will be done on test/Development servers.
All server hardware will be available and installed.
Install and set up Oracle.
Install and set up Informatica with software and licenses.
Install and set up Business Objects with software and licenses.
Set up network IDs and passwords for all personnel.
Once the specification and layouts of reports are provided, a proposal to analyze, design, develop and implement these reports will be provided.
Conversion of reports that are currently available for a specific will be subject to Riordans ownership of the reporting application.
Example: Balance Sheet reporting will be available for the Accounting & Finance only.
Each department will be responsible for providing the functional specifications and layouts for the reports in a timely manner.
CHANGE REQUEST PROCESS
The purpose of defining a change request process is to manage changes to the projects scope. To implement this process,
each department must do the following:
Provide a single point of coordination for capturing