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.

Find Another Essay On Business Requirements

1458 words - 6 pages
Our business will need a number of specific requirements for operational purposes. These requirements will aid in our day to day activities and structure our operations. In the following discussion, we will address some of the basic questions about how to run a business and what tools will we need to manage our hat shop. As a start up business, our concern is how we can effectively produce a system that would benefit our operational needs. As

1140 words - 5 pages
What are the aims of inventory management?
The aims of inventory management are the following: a) provide both internal and external customers with the required service levels in terms of quantity and order rate fill, b) ascertain present and future requirements for all types of inventory to avoid overstocking while avoiding ‘bottlenecks’ in production, c) keep cost to a minimum by variety reduction, economical lot sizes and analysis of costs

2192 words - 9 pages
Networking Basics and requirements:
1- Ethernet is easily the most popular networking system available today. It is also one of the widest ranging systems. The equipment needed for an Ethernet-based network can be as simple as two network interface cards (NIC) and a cable, or as complex as multiple routers, bridges and hubs. It is this versatility that makes it so useful to businesses

1172 words - 5 pages
. Background reading
Background reading is the aim of analyst to understand the organization and the business objective, this method includes the report of company requirement, organization chart, policy manual, job description and documentation of existing systems. The advantage of this method is help to understand the organization before meeting the people who work there and the documentation of existing system my help to identify requirements for

2390 words - 10 pages
-FILES receiving and sampling.
During the creation of this document, the author has interviewed the business users of this computer system, resolved conflicting requirements among business users, and considered compliance with policies, procedures, standards and conventions.
This introductory section lists the ensuing sections, defines the purpose of the URS, and identifies the terms and acronyms used in the document.
1.1 Document Purpose
The

594 words - 3 pages
Interior design is the art or process of designing the interior decoration of a room or building. ”Interior designers are creative, imaginative and artistic. They also need to be disciplined, organized and skilled business people.” states Careers in Interior Design (n.d.). Interior designers depend on their ability to satisfy clients. Interior designers must understand all the requirements such as artistic, technical, interpersonal communication

931 words - 4 pages
. Keeping in mind the end goal to fulfill specific clients an organization must set up some regulated variables or Marketing Mix. Item, put advancements, and value make up the marketing blend and are known as the four P's.
Summary
Advertising is about dissecting the requirements of the buyer, foreseeing the purchaser's needs and evaluating what number of purchasers needs the item. Marketing necessities to focus the area the products and

4284 words - 17 pages
throughout Riordan Manufacturing. Overall, the objective of implementing an MRP is to reduce on hand raw materials and finished goods inventory costs. The intent of this paper is to provide summary information to upper management by demonstrating the business requirements definition for the development or acquisition of an MRP system to support this objective.Material Requirements Planning (MRP) System - Riordan ManufacturingIntroduction and

1664 words - 7 pages
IT platform were key resources for understanding and controlling the business processes and, similar to other key resource within the organization, had a need for essential controls and auditability. As a response to this, the publication of the Control Objectives for Information and related Technology (COBIT) followed, which allowed organizations to demonstrate their adherence to regulations and legal requirements for computer controls (Senft

1319 words - 6 pages
genuinely interested, willing to fulfill the job requirements, be able to cope with death on a daily basis, and still maintain a positive outlook on life.
Usually, people take on the profession of becoming a funeral director, or mortician, because of exposure to a family business or pure interest. An anonymous mortician shares that he “was fascinated by the industry as a kid (Giang. 2013.).” As a twelve year old, he witnessed a terrible accident

Similar Essays

2142 words - 9 pages
1 Business Requirements
1.1 Project Overview
SMB Computation, a data collection and analysis company has been operating for less than two years and has grown exponentially. SMB Computation is seeking to create a repository for collected data beyond that of standard relational databases and their ten-terabyte data warehouse has been forecasted to grow about twenty percent each year. A plan of action to compensate for the growth of the company

785 words - 3 pages
Business RequirementThis paper will detail Business requirement definitions in the form of business topics, such as Inventory tracking, Accounting, Marketing Communication/Research, Sales and salesperson production, Manufacturing production and service tracking. As they pertain to Malone Savings and Loan business requirements.As the business requirements needed to identify our new customer identification systems program (Program Assist) several

1419 words - 6 pages
TO: (Insert Name) DATE: (Insert Date) RE: Business Setup Requirements INTRODUCTION With starting and setting up a new small business, many tasks and requirements must be undertaken. These requirements allow the organisation to operate legally, without infringing on others ideas, products or names. Below, many of the tasks are listed and explained, for your benefit and convenience.STATUTORY REQUIREMENTS Before your small business can commence

781 words - 3 pages
Business RequirementsIntroductionFor new electronic point of sale (ePOS) there are hundreds of base business requirements that should exist in the product. From how operations should complete, to the cosmetics of the exterior; from where icons should be placed and how they look, to the type of electrical plug the unit requires. This document will highlight a select list of high priority items that have the most impact to the outside stakeholders