Data Warehousing & Smart Reporting System for ADFCA - Project

This project outlines the implementation of a data warehouse and smart business system for the Abu Dhabi Food Control Authority (ADFCA). It details the project's business case, objectives, requirements, and work breakdown structure, including feasibility analysis, resource identification, and system prototype design. The project aims to leverage extensive data available within ADFCA to create smart reports that support decision-making in food safety and security. The solution covers aspects such as Oracle database connectivity, ETL design, UML diagrams, and testing phases, culminating in stakeholder sign-off and a post-system maintenance plan. The estimated time and cost for the project are 125 days and AED 70,000, respectively, with a communication plan and risk register included. The document also references various sources related to communication management and project management.

Data Warehousing
Student Name:
Course name:
Student Id:
Abu Dhabi Food
Control Authority

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.

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.

Project business case (contd.)
 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.

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

Requirements
The detail steps for implementing the project
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

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

Formulated project team

Gantt chart for data warehouse
development project

Schedule for the data warehouse
development project (using CPM method)
0 5 5
0 0 5
Identification of problems
84 8 92
84 0 92
Functionality testing
9 5 14
9 0 14
Resource identification
68 6 74
68 0 74
System prototype design
74 5 79
74 0 79
Oracle database connectivity
33 8 41
33 0 41
Contingency and procurement
management plan
22 5 27
23 1 28
Feasibility analysis
14 8 22
14 0 22
Resource gathering and analysis
5 4 9
5 0 9
Developing project scope
statement
92 10 102
92 0 102
Performance and user acceptance
testing
79 5 84
79 0 84
Unit testing
60 8 68
60 0 68
Checking business logic
60 7 67
70 0 74
Checking mapping sources to
target
55 5 60
55 0 60
Naming standard checking
50 5 55
50 0 55
UML diagram presentation
41 9 50
41 0 50
Hardware and software
specifications
22 6 28
22 0 28
Time/ schedule and cost
estimation
102 15 117
102 0 117
Post system maintenance plan
117 2 119
117 0 119
Stakeholder’s signoff
28 5 33
28 0 33
Risk and Quality management

Estimated time and cost
 The net time and cost estimated for the successful
implementation of the data warehouse for Abu
Dhabi food control authority are:
 AED 70,000
 125 days

Communication plan

Risk Register

References
 DeviKrishnaya, S., Jamaludin, K. R., & Ismail, S. (2017). Communication Management during
Design Phase in Construction Project. In MASTER PROJECT SYMPOSIUM ON ENGINEERING
BUSINESS MANAGEMENT (Vol. 13, p. 29).
 Greenaway, K. H., Wright, R. G., Willingham, J., Reynolds, K. J., & Haslam, S. A. (2015). Shared
identity is key to effective communication. Personality & Social Psychology Bulletin, 41(2), 171-182.
 Ham, T. J., Aragón, J. L., & Martonosi, M. ((2015), December). DeSC: Decoupled supply-compute
communication management for heterogeneous architectures. In Proceedings of the 48th International
Symposium on Microarchitecture (pp. 191-203). ACM.
 Heagney, J. (2016). Fundamentals of project management. AMACOM Div American Mgmt Assn.
 Kaiser, M. G., El Arbi, F., & Ahlemann, F. (2015). Successful project portfolio management beyond
project selection techniques: Underst&ing the role of structural alignment. International Journal of
Project Management, 33(1), 126-139.
 Kerzner, H., & Kerzner, H. R. (2017). Project management: a systems approach to planning,
scheduling, & controlling. John Wiley & Sons.
 Malhotra, N., & Ackfeldt, A. L. (2016). Internal communication & prosocial service behaviors of
front-line employees: Investigating mediating mechanisms. Journal of Business Research, 69(10),
4132-4139.
 Men, L. R. (2014). Strategic internal communication: Transformational leadership, communication
channels, & employee satisfaction. Management Communication Quarterly, 28(2), 264-284.