Project Management: Data Warehouse Implementation - Assignment 1

This project management assignment focuses on the implementation of a data warehouse and smart reporting system for the Abu Dhabi Food Control Authority. The assignment begins with a project business case, outlining the need for a system to manage extensive data and generate smart reports for decision-making. It details the project selection criteria, with payback period identified as the most suitable method. The project objectives include implementing a data warehouse within a specified timeframe and budget, and the goals involve integrating and preserving key information across the organization. The assignment further defines the project scope, requirements, and a detailed work breakdown structure (WBS), covering project initiation, planning, design, execution, testing, and closure phases. The WBS includes tasks such as problem identification, scope statement development, resource identification, risk and quality management, and system testing. The assignment emphasizes the use of Agile project development lifecycle and Oracle database connectivity for efficient data management and reporting.

Running head: PROJECT MANAGEMENT
Project Management: Implementation of Data Warehouse in Abu Dhabi food control Authority
Name of the student:
Name o the University:

1PROJECT MANAGEMENT
Assignment 1
Selected project: Extensive data available in Abu Dhabi Food Control Authority, and
how these data can be used to classify these data into smart reports that help in decision-making,
prioritizing and shaping the future emirates of Abu Dhabi in food safety and food security.
1.1 Project business case
The purpose of the project is to implement smart business system software as well as data
warehouse in terms of Information System to protect confidential information. The system help
Abu Dhabi food control Authority to build a data warehouse which include all information and
needful data. It can integrate, enhance and preserve the key accurate information across the
business organization. It also helps to provide a common data model for all types of data which
count regardless of the data sources and can add on values for business operation and all other
applications. In order to store the information Oracle database connectivity will be used to fetch,
insert and update key data in the database table. Oracle ERP system will be used to access
information stored in the database by running needful queries.
The Minister of State for Food Security released a roadmap for excellence technical
innovation driven food security in the Middle East. In order to improve the food security
performance the Abu Dhabi food control Authority has introduced certain tools and strategic
initiatives. The United Arab Emirates is bidding frequently to become world’s one of the top 10
food secure nations. It is determined that, extensive data are available in Abu Dhabi Food
Control Authority. Based on type and size, theses data can be classified and used in smart reports
so that the authority can take effective decisions for economic and commercial success.

2PROJECT MANAGEMENT
Discrete data are available in the Abu Dhabi Food control Authority. However, managing
large set of data has become a major challenge to the Abu Dhabi Food Control Authority. In
order to resolve this issue the food corporation authority has decided to design and develop an
Information System (IS) and data warehouse. It is identified that implementation of an
Information System and data warehouse will easily resolve all operational and functional
challenges. The Information System and data warehouse or smart reporting system will help the
authority to take effective decisions.
The project roadmap is dependent on some strong pillars such as building as well as food
data strategies, developing professional Research and Development (R&D) Strategies, nutritional
guidelines, regional trading environment and national food waste program that support regional
improvement in the improvement portfolio. The Food Control Authority was established in the
year of 2005 to make sure customer care with quality food delivery. In the year of 2009 the
Farmer’s service centre was established that offer technical agricultural services and technical
advice to the farmers.
1.2 Project selection criteria
This is not mandatory that every project will be successful in any business organization.
In order to implement any project successfully in the business organization it is mandatory for
the project manager and project team members to identify the possible project selection criteria.
Therefore, before selecting any project most of the project leaders consider all contingency that
may come up and use as a yardstick to select the project. The project sponsors are also needed to
get permission from the project manager before selecting the most suitable project for its
competitive advantages and commercial profit. The different project selection methods applied in
this project are as follows:

3PROJECT MANAGEMENT
Cost benefit ratio: This method calculates the ratio of project investment and expected
benefit from the project. It is an effective way of communication that provides easily understable
terms to the project manager and project team members. It calculates the investment done for any
project and the net return value that may generate from the complete investment. A project that
needs $50,000 as their resource allocation cost must complete with an expected return value of
$100,000 after a certain time period.
Economic model: The economic model is referred to as a very simple benefit
measurement model which describes the difference between the invested cost and the possible
revenue generated from it. It gives a cleat representation on quantifiable benefit of a project as
soon as it completed. In other words it gives solid return that is actually expected from a project.
Payback period: The payback period is referred to as measurement technique which
calculates the time that would be required to get the invested value as a return.
Discounted cash flow: The discounted cash flow is referred to as a value that calculates a
return value may be generated after a certain point of time period. The concept helps the project
managers to translate the future earning into present days.
Net present value: The net present value helps to put the entire project development
lifecycle into project earning perspectives.
Among the above mentioned project selection criteria the project manager and project
team members for this project is require to choose the most suitable project select method. For
this project, payback Period is referred to as the most suitable project selection method. The

4PROJECT MANAGEMENT
1.3 Project objectives
The objectives for the project are as follows:
 To implement a data warehouse and smart business system in terms of
Information System (IS)
 To discuss all the extensive data available in all sectors in Abu Dhabi Food
Control Authority and also identify how those data be used for smart reporting
system
 To accomplish the IS implementation and data warehouse design and
development project within estimated timeframe of 125 days and within the
estimated budget of $65,000
1.4 Goals
Abu Dhabi Food Control Authority is facing major challenges due to availability of huge
discrete data in different sectors. Managing these data is becoming very much challenging these
days. The goal of the project is to build data warehouse which include each type of discrete data
and needful information. It has been assumed that, if the data warehouse is successfully
implemented then it would be able to integrate, increase and preserve all key accurate
information across Abu Dhabi Food Control Authority. The warehouse can merge all data from
multiple sources and successfully provide a common data source and add values for effective
operational business applications. The data warehouse can restructure all information that
provides excellent query tools even for complex analytic queries without giving any negative
impact to the Operating System (OS). Deactivated Operating System can also keep the data
history stored.

5PROJECT MANAGEMENT
The goal of the project is to identify the ways through which discrete data available in
different sectors can be used by the Abu Dhabi Food Control Authority into smart reporting. The
smart reporting system needs to be designed in such a way so that it can take effective business
beneficial decisions and prioritization and future shaping. In order to develop the manual
reporting system to a smart one the Abu Dhabi Food Control Authority require to implement
Information System and data warehouse for food security, safety and quality improvement.
1.5 Requirements
After analyzing the business case in details data warehouse or a business Intelligence can
be developed for successful programs. The data warehouse can be developed successfully on
solid business requirements. It helps to demonstrate the solution requirements in business terms.
Some steps are there required to be followed by the project managers of Abu Dhabi Food
Control Authority while developing data house system. The detail steps are as follows:
 Determining the business objectives
 Collecting and analyzing Information details
 Identification of core business processes
 Construction of conceptual data model
 Locating data sources and planning for data transformation
 Set tracking duration
 Implementation of the plan
1.6 Preliminary project scope
Data warehousing business requirement demonstrate the needed solution in the business
terms. It helps to gather and manage all business requirements that include the following steps-

6PROJECT MANAGEMENT
business mission and operation, enterprise goals and objective setting, identification of user
groups, requirements interview, requirement workshops and sizing. The Rapid data warehouse
requirement can include increased productivity, improved solution quality, rapid resultant, longer
development cost and enhanced team work and productivity. The scope of the project is to
develop a data model with database layout, data strategy and roadmaps. The scope of the project
is to identify discrete data sources to gather needful information those are helpful for developing
smart reporting. The system will be used to merge multiple numbers of data from theses sources
to provide one common data model. The design data model can integrate, enhance and preserve
key accurate information throughout the organization. It has been assumed that with successful
design and development of a data warehouse the decision making process of Abu Dhabi Food
Control Authority will be improved and it can also successfully provide data quality analysis
report, dashboard and performance cards.

7PROJECT MANAGEMENT
1.7 Work breakdown structure
Scheduling smart
reporting system for Abu
Dhab Food Control
Authority
Project initiation
Identification of
problems in Abu
Dhabi Food Control
Authority
Developing project
scope statement
SRS
Resource
identification
Resource gathering
and analysis
Project planning
Feasibility analysis
Time/ schedule and
cost estimation
Risk and quality
management plan
Contingency and
procurement
management plan
Project design and
execution
Hardware and
software
specifications
UML diagram
presentation
ETL design and code
review
Naming standard
checking
Checking business
logic
Checking mapping
sources to target
System prototype
design
Oracle database
connectivity
Testing
Unit testing
Functionality testing
Performance and
user acceptance
testing
Project implementation
and closure phase
Post system
maintenance plan
Stakeholder’s
signoff
Figure 1: Work Breakdown Structure developed for the project
(Sources: Created by author)

8PROJECT MANAGEMENT
Assignment 2
2.1 Detail Work Breakdown Structure for the project
The Abu Dhabi Food Control Authority established a clear view to evaluate discrete data
those can be used in real field of application. In order to maintain the safety and quality of food,
UAE government body has started keeping their focus on each protection entities. The mission
of UAE is to achieve sustainability for effective improvement of each research activities.
Statistical database collection, research activities and government services are the sectors that are
improving continuously for long term agricultural sustainability and food safety. In order prepare
the database warehouse system/Oracle based ERP system Agile project development lifecycle
should be used by the system developers and project managers. The details of the Work
Breakdown Structure (WBS) and details work packages used are elaborated in the below section:
Project initiation: The project initiation plan stars with problem analysis, project scope
statement development and identification of resources. For this data house development project it
is identified that the Abu Dhabi Food control Authority used to apply manual data management.
Discrete data are available in different sectors of Abu Dhabi food. Though, application of these
data are very essential but due to lack of management and operational processes the Abu Dhabi
Food control Authority failed to use these data while required. After identification f this
problem, the project scope statement is designed. In order to implement the project scope
considering its goals and objectives it becomes necessary for the assigned project manager to
identify and analyze resources in this phase. Basically this project phase initiates the data
warehouse development project.

9PROJECT MANAGEMENT
Project planning: In this phase different project knowledge management areas come
under consideration. The project manager and other associates need to develop risk quality,
procurement, communication, time, cost and schedule management plan in this project
development phase.
Project design and execution: In this phase the project prototype will be designed and
the warehouse will be connected to the Oracle database. This warehouse will be able to store and
manage large set of data. The authorized users and employees of Abu Dhabi Food control
Authority will be able to access those while required regardless of time and budget by running
queries.
Project testing: Whether the project design is successful from the business and
consumers perspectives or not is checked through project testing phases. The three sequential
testing processes will be used for this project are respectively unit testing, integration testing and
user acceptance testing. The user accepting testing will ensure that whether the project will be
beneficial or not.
Project implementation and closure: After successful acceptance testing the project is
finally implemented in this phase. Tough, post project maintenance is a very important activity
should e followed by the project team associates. In this phase the post system maintenance plan
is developed and the project is gets finally closed with stakeholders signoff.

10PROJECT MANAGEMENT
2.2 Formulation of the project team
Project team
members
Roles Responsibilities
Project Manager Internal The responsibility of the project manager is to control and
monitor the project progress so that it can meet the expectation
of the customers. In addition to this, another responsibility of
the project manager is to accomplish the project within assigned
timeline and budget
Research Analyzer Externa
l
Responsibility is to analyze current business situation and
possible information analysis to make the data warehouse
implementation successful
senior Data Design
Engineer
Internal To design and integrate all data accurately
Representatives
AMS, AIRS &
VMS
Externa
l
To represent AMS, AIRS & VMS
Representatives
HR, FIN, CP &
INV
Externa
l
To represent HR, FIN, CP & INV
Technical support Internal To identify technical and non technical requirements so that it
can support the automated data management (data warehouse
system)

11PROJECT MANAGEMENT
2.3 Development of time management plan (schedule) using CPM based on resource
pool and resource allocation
WBS Task Name Duratio
n Start Finish
0 Scheduling smart reporting system for Abu Dhabi
Food Control Authority 121 days Mon
4/15/19
Fri
9/27/19
1 Project initiation 23 days Mon
4/15/19
Wed
5/15/19
1.1 Identification of problems in Abu Dhabi Food Control
Authority 5 days Mon
4/15/19 Fri 4/19/19
1.2 Developing project scope statement 6 days Mon
4/22/19
Mon
4/29/19
1.3 SRS 12 days Tue
4/30/19
Wed
5/15/19
1.3.1 Resource identification 5 days Tue
4/30/19 Fri 5/3/19
1.3.2 Resource gathering and analysis 8 days Mon
5/6/19
Wed
5/15/19
2 Project planning 19 days Thu
5/16/19
Tue
6/11/19
2.1 Feasibility analysis 5 days Thu
5/16/19
Wed
5/22/19
2.2 Time/ schedule and cost estimation 6 days Thu
5/16/19
Thu
5/23/19
2.3 Risk and quality management plan 5 days Fri 5/24/19 Thu
5/30/19
2.4 Contingency and procurement management plan 8 days Fri 5/31/19 Tue
6/11/19
3 Project design and execution 38 days Wed
6/12/19 Fri 8/2/19
3.1 Hardware and software specifications 9 days Wed
6/12/19
Mon
6/24/19
3.2 UML diagram presentation 5 days Tue
6/25/19
Mon
7/1/19
3.3 ETL design and code review 13 days Tue 7/2/19 Thu
7/18/19
3.3.1 Naming standard checking 5 days Tue 7/2/19 Mon
7/8/19
3.3.2 Checking business logic 8 days Tue 7/9/19 Thu
7/18/19
3.3.3 Checking mapping sources to target 7 days Tue 7/9/19 Wed