Implementation of Data Warehouse in Abu Dhabi Food Control Authority
Verified
Added on  2023/04/20
|30
|5426
|227
AI Summary
This document discusses the implementation of a data warehouse and smart business system in Abu Dhabi Food Control Authority to classify extensive data into smart reports for decision-making, prioritizing, and shaping the future of Abu Dhabi in food safety and security.
Contribute Materials
Your contribution can guide someone’s learning journey. Share your
documents today.
Running head: PROJECT MANAGEMENT Project Management: Implementation of Data Warehouse in Abu Dhabi food control Authority Name of the student: Name o the University:
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.
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 InformationSystem(IS)anddatawarehouse.Itisidentifiedthatimplementationofan 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. Economicmodel:Theeconomicmodelisreferredtoasaverysimplebenefit 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
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
4PROJECT MANAGEMENT 1.3 Project objectives The objectives for the project are as follows: ï‚·Toimplementadatawarehouseandsmartbusinesssystemintermsof 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 ï‚·ToaccomplishtheISimplementationanddatawarehousedesignand 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 implementedthenitwouldbeabletointegrate,increaseandpreserveallkeyaccurate 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.
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.
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 whilerequired. 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,costandschedulemanagementplaninthisproject development phase. Project design and execution:In this phase the project prototype will be designedand 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. Projecttesting:Whethertheprojectdesignissuccessfulfromthebusinessand 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.
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
10PROJECT MANAGEMENT 2.2 Formulation of the project team Project team members RolesResponsibilities Project ManagerInternalThe 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 AnalyzerExterna l Responsibilityistoanalyzecurrentbusinesssituationand possibleinformationanalysistomakethedatawarehouse implementation successful senior Data Design Engineer InternalTo 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 supportInternalTo 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 WBSTask NameDuratio nStartFinish 0Scheduling smart reporting system for Abu Dhabi Food Control Authority121 daysMon 4/15/19 Fri 9/27/19 1Project initiation23 daysMon 4/15/19 Wed 5/15/19 1.1Identification of problems in Abu Dhabi Food Control Authority5 daysMon 4/15/19Fri 4/19/19 1.2Developing project scope statement6 daysMon 4/22/19 Mon 4/29/19 1.3SRS12 daysTue 4/30/19 Wed 5/15/19 1.3.1Resource identification5 daysTue 4/30/19Fri 5/3/19 1.3.2Resource gathering and analysis8 daysMon 5/6/19 Wed 5/15/19 2Project planning19 daysThu 5/16/19 Tue 6/11/19 2.1Feasibility analysis5 daysThu 5/16/19 Wed 5/22/19 2.2Time/ schedule and cost estimation6 daysThu 5/16/19 Thu 5/23/19 2.3Risk and quality management plan5 daysFri 5/24/19Thu 5/30/19 2.4Contingency and procurement management plan8 daysFri 5/31/19Tue 6/11/19 3Project design and execution38 daysWed 6/12/19Fri 8/2/19 3.1Hardware and software specifications9 daysWed 6/12/19 Mon 6/24/19 3.2UML diagram presentation5 daysTue 6/25/19 Mon 7/1/19 3.3ETL design and code review13 daysTue 7/2/19Thu 7/18/19 3.3.1Naming standard checking5 daysTue 7/2/19Mon 7/8/19 3.3.2Checking business logic8 daysTue 7/9/19Thu 7/18/19 3.3.3Checking mapping sources to target7 daysTue 7/9/19Wed
13PROJECT MANAGEMENT Figure 2: Gantt chart for the data warehouse development project (Source: Created by Author)
14PROJECT MANAGEMENT Figure 3: Schedule for the data warehouse development project (using CPM method) (Source: Created by Author)
Running head: PROJECT MANAGEMENT 2.4 Estimate cost and budget The net cost estimated for the project is $70,000. It is the responsibility of the project manager to accomplish the project within this estimated timeline and budget. WBSTask NameDuratio nResource NamesCost 0Scheduling smart reporting system for Abu Dhabi Food Control Authority121 days$64,992.00 1Project initiation23 days$5,248.00 1.1Identification of problems in Abu Dhabi Food Control Authority5 daysProject Manager$800.00 1.2Developing project scope statement6 daysProject Manager$960.00 1.3SRS12 days$3,488.00 1.3.1Resource identification4 daysresource manager$480.00 1.3.2Resource gathering and analysis8 daysRepresentative Group (2),resource manager$3,008.00 2Project planning19 days$4,200.00 2.1Feasibility analysis5 daysFinance manager$600.00 2.2Time/ schedule and cost estimation6 daysProject Manager$960.00 2.3Risk and quality management plan5 dayssenior Data Design Engineer$720.00 2.4Contingency and procurement management plan8 daysRepresentative group (1)$1,920.00 3Project design and execution38 days$50,008.00 3.1Hardware and software specifications9 daysHardware cost[1],software cost[1]$45,000.00 3.2UML diagram presentation5 dayssenior Data Design Engineer$720.00 3.3ETL design and code review13 days$2,592.00 3.3.1Naming standard checking5 dayssystem developer$680.00 3.3.2Checking business logic8 daysapplication programmer$960.00 3.3.3Checking mapping sources to target7 dayssystem developer$952.00 3.4System prototype design6 dayssystem developer$816.00 3.5Oracle database connectivity5 daysDBA$880.00 4Testing23 days$2,576.00 4.1Unit testing5 daystester$560.00 4.2Functionality testing8 daystester$896.00 4.3Performance and user acceptance testing10 daystester$1,120.00
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
1PROJECT MANAGEMENT 5Project implementation and closure phase17 days$2,960.00 5.1Post system maintenance plan15 daysResearch Analyzer$2,640.00 5.2Stakeholder’s signoff2 daysProject Manager$320.00
2PROJECT MANAGEMENT Assignment 3 3.1 Development of a Human Resource Plan In order to manage the human resource for the project there are certain basic steps those are needed to be followed by the assigned project associates. The Human resource knowledge area is comprises of four processes in terms of development of human resource plan, acquiring project team, developing project team and project team management. The process needs to cover organizational behavior, psychology and human resource theories. The main purpose of the human resource management team is to motivate and lead their project team members. Every one of the project associate requires playing respective roles, responsibilities in the project development plan. Individual’s contribution will help to meet the project goal and objectives. Activity resource requirements: For each project activity what resource is actually required identified in this phase. In order to complete theses activities the planning processes are to be carried out. Analysis of environmental factor: In this phase the organizational structure, values, norms and ethics need to be followed by the project associates are elaborated. Organizational process assets:This particular process deals with different aspects in terms of resource project plan, social corporate of competencies, organizational guidelines, policies and procedures. Development of human resource plan: The human Resource management plan is about assigning roles and responsibilities to each team members, giving title to them and finally describing their level of authorities, skills and competency level.
3PROJECT MANAGEMENT Designing resource histogram: The resource histogram estimates the actual time spent by each resource. The graph shows the actual schedule spent by an assigned resource for a particular time phase. In order to detect the problems and fix them at the very early stage of development the histogram, design is very essential. Organizational chart and position description: Organizational chart is a hierarchy which starts with a top sponsor and end with project manager at the extreme lower level explaining regarding the project details. Design of RACI chart/ RACI matrix: The RACI matrix, also known as responsibility assignment matrix identified the responsibility assigned for each project associates at each activity. Organizational theory: The assigned project manager should ensure that each project team members are following the norms and regulations complete professionally. 3.2 Development of Quality plan In order to deliver a quality project to clients, the project manager should gather input information in terms of scope statement, stakeholder management, risk register and project implementationschedule.Thescopestatementdefinestheprojectboundaries,project assumptions and project deliverables. The products scope identifies the function and features of the Information System. The project manager should develop a risk register to identify the potential risks, their possibilities, impact and respective mitigation strategies. In order to accomplish the project within estimated timeline and budget the project manager must develop a timeframe also.
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.
4PROJECT MANAGEMENT Data analysis: Each data collected for successful implementation of the (IS) project data analysis is very essential. As soon as input information is received by planning team they must conduct a cost benefit analysis to ensure the project success. The project manager should develop a quality management plan with taking support from the other project team members. Setting quality matrix: The Abu Dhabi Food Corporation Authority should develop a quality matrix plan where the team requires selecting the service details they are going to deliver to the clients. In order to assure project quality and control activities quality matrix must be prepared. Design of the improvement plan: This is the final step of developing a quality management plan. This improvement plan used to analyze the performance quality, product values, project boundaries, process matrices and objectives. The designed document is required to be approved by project manager. 3.3 Development of communication plan Purpose of communicationFrequencyTimeWhoMedium To demonstrate the objectives oftheprojecttotheproject team members Weekly2 hours Projectmanager and project team members Facetoface meeting, presentationand video conference Developtheprojectscope statement Weekly3 hours Projectmanager andproject sponsor Facetoface meeting, presentationand video conference
5PROJECT MANAGEMENT To identifythepossiblerisks that may interrupt the project success Weekly2 hours Projectmanager andresource manager Facetoface meeting, presentationand video conference Discussiononcurrentproject status Monthly1 hour Projectteam membersand manager Presentationand video conference TodiscussdetailsofIS implementationproject procurementplanforAbu Dhabi Food control Authority Monthly2 hours Projectmanager, procurement manager Facetoface meeting, presentation 3.4 Risk plan Risk Id Risk nameDescription of the risks Likelihoo d Consequ ences ScoreMitigation strategy R0Interconnecti onand integration risks If proper technical specificationsare notdesignedand consideredthen lackofintegrity and interconnection amongthedata Rare (1)Catastrop hic (5) Low (5)Propertools and techniques are neededtobe usedbythe system developersof AbuDhabi
6PROJECT MANAGEMENT will occur. It will impact the overall process flow of the datawarehouse andOracleERP system Foodcontrol Authorityto make interconnectio namongthe stored information. R1Technical risks Iftheproject managerfailsto identifythe technical specificationthat isrequiredto design and develop theISforUAE foodcontrol authoritythenthe alltheavailable discretedatamay not be stored and fetched successfully Likely (4)Major (4)High (16) Theproject manager should considereach technical specifications attheproject initiation phase to make surethatno issuesare arising. R2LackofIf it is found thatPossibleModerateModeratTheowner
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
7PROJECT MANAGEMENT special training amongthe projectteam members theprojectteam membersare laggingessential technicalskills thentheproject will fail to meet the objectives. (3)(3)e (9)authority should arrange technical trainingand development programto makethe associates familiarwith theIS development technical knowledge R3Operational risks Ifthedeveloped systemfailsto meetall operationaland functional requirements Unlikely (2) Major (4)Low (8)Theoperation manageris responsibleto includeall operational specifications tomakesure thatthe projectis meetingits
8PROJECT MANAGEMENT requirements and objectives. R4Improper cost management Iftheproject managerfailsto estimateneedful costthenitwill resultissueswith cost management Almost likely (5) Major (3)High (15) Atthe initiation phasethe project finance manager should conducta feasibility studyto ensure whetherthe project will be successfulor not. R5Inaccurate time management Overrunningtime forproject completionis referredtoasa major risk for this Possible (3) High (4)High (12) Basedon complexityof eachproject development activity
9PROJECT MANAGEMENT projectthatmay interruptthe project success accurate project schedule must be prepared by theproject manager R6Inadequate resource allocation Inaccurate identificationof project resources Most likely (5) High (4)Extreme (20) Considering project requirements and objectives resources (humanand physical) shoulde identifiedby theproject manager. 3.5 Procurement plan The procurement plan developed for this specific project is comprises of five different phases such as specification, selection, contracting, control and measurement. The aim of Abu Dhabi Food control Authority is to use the discrete data available in different departments and use them successfully to make the reporting format smarter to allow the sponsors make easy
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.
10PROJECT MANAGEMENT decision making. In order to convert the manual discrete data management system of Abu Dhabi Food control Authority, to an automated one the phases to be followed to develop the procurement plan are as follows: Initial plan the procurement: In order to design, develop and approve the procurement items the marketing and management department needs to communicate with the project manager. The marketing and management department needs to specify all approved items to their external vendors. This allows the project planners to determine if the expectations are found to be completely realistic. In this phase the procurement objectives will be identified with a detail scope statement, Scope of the procurement: In this phase, the project the assigned project manager of Abu Dhabi Food Control Authority data warehousing project needs to determine whether the services to be purchased are subject to coordinated procurement arrangements those must be used. The value of procurement needs to be estimated with a details market research. Selection of suppliers: In this phase accurate project suppliers and vendors should be selected.In act if t is found that, bidding is needed then, bidding processes are needed to be specified counting minimum bidding numbers. In this phase the term that needs to be considered before the implementation of the project is identified. It helps to check that whether the preferred vendors are nominated by the project manager for implementing the data warehouse system or not. Bidding and acceptance: In this phase the procurement department issues a proposal as a proposal that is also known as Request for Proposal (RFP) which details the project scope, objectives and actual needs. The response of the suppliers for the proposals will help to provide
11PROJECT MANAGEMENT the details of cost, time and schedule details related to the project. It is the responsibility of the project manager and project team members to develop a procurement management plan to implement the Oracle based ERP system successfully within assumed timeline and budget as well.
12PROJECT MANAGEMENT Bibliography Ahern, T., Leavy, B., & Byrne, P. J. (2014). Complex project management as complex problem solving: A distributed knowledge management perspective.International Journal of Project Management,32(8), 1371-1381. Cohen-Vogel, L., Tichnor-Wagner, A., Allen, D., Harrison, C., Kainz, K., Socol, A. R., & Wang,Q.(2015).Implementingeducationalinnovationsatscale:Transforming researchers into continuous improvement scientists.Educational Policy,29(1), 257-277. Conforto, E. C., Salum, F., Amaral, D. C., da Silva, S. L., & de Almeida, L. F. M. (2014). Can agileprojectmanagementbeadoptedbyindustriesotherthansoftware development?.Project Management Journal,45(3), 21-34. Conger, S. (2015). Six sigma and business process management. InHandbook on Business Process Management 1(pp. 127-146). Springer, Berlin, Heidelberg. First, M. B. (2016). Adopting a continuous improvement model for future DSM revisions.World Psychiatry,15(3), 223-224. Fleming, Q. W., & Koppelman, J. M. (2016, December). Earned value project management. Project Management Institute. Heldman, K. (2015).PMP project management professional exam deluxe study guide: updated for the (2015) Exam. John Wiley and Sons.
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser