CIS499 Project Deliverables (1,2,3,4,5,6) Complete Solution

Question: #7

Project Deliverable 1: Project Plan Inception

This assignment consists of two (2) sections: a project introduction and a project plan. You must submit both sections as separate files for the completion of this assignment. Label each file name according to the section of the assignment it is written for. Additionally, you may create and / or assume all necessary assumptions needed for the completion of this assignment.

You are a newly appointed Chief Information Officer (CIO) of a $25 million dollar data collection and analysis company that has been operating less than two (2) years. It is expected to grow by 60% over the next eighteen (18) months. Your company currently collects data using Web analytics and combines it with operational systems data. Web analytics is an increasingly important part of most business marketing plans. Your company is looking for ways to leverage the collected data but wants to ensure that the information technology infrastructure will support the expected growth that the company is anticipating. The Chief Executive Officer (CEO) has given you sixty (60) days to deliver a comprehensive information systems project plan to address the organizational growth that the company is experiencing. The company will be expanding from one (1) floor to three (3) floors within six (6) months. Since this is a relatively new company, there is currently limited technology infrastructure to support the business. All information technology (hardware and software) must be redesigned to meet organizational needs. The solution should be implemented in either a hosted solution, on-site solution, or a hybrid model. The CEO is expecting you to integrate different technologies from different partners and incorporate industry best practices and cost-effective solutions in connection with the development of technological systems. In addition, the CEO is extremely interested in cloud computing technologies and Software-as-a-Service (SaaS) but is leery of security issues that may be associated. However, he is sure that you will implement proper security protocols. The company currently consists of twenty (20) employees of which four (4), including yourself, are dedicated to the IT organization.

Section 1: Project Introduction 1.Write a four to six (4-6) page project introduction that documents the current state of the organization, expands upon the information given above, and includes the following: ◦Background information of the company.
◦Details regarding the type of business that the company is engaged in.
◦A description of current outsourcing and offshoring activities.
◦Identification of current skilled information systems personnel in position and responsibilities.
◦The specific types of data that the company collects.
◦A description of the information systems that the company currently has to support the business. The description at a minimum should include the following: ◦Operational Systems and Databases
◦Analytics and Interfaces
◦Infrastructure and Security

◦The use of at least two (2) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.

Your assignment must follow these formatting requirements: •Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
•Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.

Section 2: Project Plan
Use Microsoft Project to: 2.Create a project plan (summary and detailed) using Microsoft Office Project. The project plan should: ◦Record all tasks, subtasks, resources, and time related to the project.
◦Outline the planning, analysis, design, and implementation phases.
◦Develop in accordance with the systems development life cycle (SDLC).
The specific course learning outcomes associated with this assignment are: •Describe the various functions and activities within the information systems area, including the role of IT management and the CIO, structuring of IS management within an organization, and managing IS professionals within the firm.
•Use technology and information resources to research issues in information systems.
•Write clearly and concisely about strategic issues and practices in the information systems domain using proper writing mechanics and technical style conventions.

Project Deliverable 2: Business Requirements

This assignment consists of two (2) sections: a business requirements document and a project plan. You must submit both sections as separate files for the completion of this assignment. Label each file name according to the section of the assignment it is written for. Additionally, you may create and / or assume all necessary assumptions needed for the completion of this assignment.

Procuring quality business requirements is an important step toward the design of quality information systems. Completion of a quality requirements document allows user needs and expectations to be captured, so that infrastructure and information systems can be designed properly. Your company, which is a data-collection and analysis company that has been operating less than two (2) years, is seeking to create a repository for collected data beyond standard relational databases. Your ten (10) terabyte data warehouse is expected to grow by 20% each year. You are mindful of data warehousing best practices which will aid you immensely in your requirements gathering effort. Using the requirements document provided in the course shell, you are to speculate on the needs of the company. You must consider current and future requirements; however, assumptions should be realistic and carefully considered.

Section 1: Business Requirements Document
Write a four to six (4-6) page original business requirements document for the project plan using the template provided. Note: The template is provided under the Additional Resources in the Student Center tab of the online course shell.
Describe the project including the following:
Describe and define the scope of the project.
Speculate as to how to control the scope.
Identify possible risks, constraints, and assumptions.
Describe the relationship and integration between systems and infrastructure. Note: Database and Data Warehousing, Analytics, Interfaces and Cloud Technology, and Infrastructure and Security should be considered.
Speculate upon potential outsourcing or offshoring needs.
Identify and justify the necessary resources including staffing that are necessary.
Define relevant terms that will be used throughout project.
Use at least two (2) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.

Your assignment must follow these formatting requirements:
Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.

Section 2: Revised Project Plan
Use Microsoft Project to:
Update the project plan from Project Deliverable 1: Project Plan Inception, with three to five (3-5) new project tasks each consisting of five to ten (5-10) sub-tasks.
The specific course learning outcomes associated with this assignment are:
Evaluate an organization through the lens of non-IT senior management in deciding how information systems enable core and supportive business processes as well as those that interface with suppliers and customers.Use technology and information resources to research issues in information systems.
Write clearly and concisely about strategic issues and practices in the information systems domain using proper writing mechanics and technical style conventions.

Project Deliverable 3: Database and Data Warehousing Design
This assignment consists of two (2) sections: a design document and a revised project plan. You must submit both sections as separate files for the completion of this assignment. Label each file name according to the section of the assignment it is written for. Additionally, you may create and / or assume all necessary assumptions needed for the completion of this assignment.

One of the main functions of any business is to be able to use data to leverage a strategic competitive advantage. This feat hinges upon a company’s ability to transform data into quality information. The use of relational databases is a necessity for contemporary organizations; however, data warehousing has become a strategic priority due to the enormous amounts of data that must be analyzed along with the varying sources from which data comes. Since you are now the CIO of a data-collection company which gathers data by using Web analytics and operational systems, you must design a solution overview that incorporates data warehousing. The executive team needs to be clear about what data warehousing can provide the company.

Section 1: Design Document 1.Write a four to six (4-6) page design document in which you: ◦Support the need for data warehousing within your company and elaborate on the best practices that the company will adhere to.
◦Create a schema that supports the company’s business and processes. Explain and support the database schema with relevant arguments that support the rationale for the structure. Note: The minimum requirement for the schema should entail the tables, fields, relationships, views, and indexes.
◦Create an Entity-Relationship (E-R) Diagram relating the tables of your database schema through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length but must be included in the design document appendix. Explain your rationale behind the design of your E-R Diagram.
◦Create a Data Flow Diagram (DFD) relating the tables of your database schema through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length but must be included in the design document appendix.
◦Illustrate the flow of data including both inputs and outputs for the use of a data warehouse. The diagram must map data between source systems, data warehouses and specified data marts. The diagram should map data between source systems, data warehouses, and specified data marts. Note: The graphically depicted solution is not included in the required page length.

Section 2: Revised Project Plan
Use Microsoft Project to: 2.Update the project plan from Project Deliverable 2: Business Requirements, with three to five (3-5) new project tasks each consisting of five to ten (5-10) sub-tasks.
The specific course learning outcomes associated with this assignment are: •Summarize how information systems represent a key source of competitive advantage for organizations.
•Develop information systems-related activities to maximize the business value within and outside the organization.
•Use technology and information resources to research issues in information systems.
•Write clearly and concisely about strategic issues and practices in the information systems domain using proper writing mechanics and technical style conventions.

Project Deliverable 4: Analytics, Interfaces, and Cloud Technology
Gantt chart or project plan. You must submit both sections as separate files for the completion of this assignment. Label each file name according to the section of the assignment it is written for. Additionally, you may create and / or assume all necessary assumptions needed for the completion of this assignment.

Large companies have been using the power of business analytics for quite a while now. Your company desires to get in on the action; company executives believe that using advanced data analysis will enable the company to make smarter decisions and improve business performance. Business analytics gives companies the ability to look at past realizations and performance as well as set up new expectations and performance goals. Analytics-as-a-Service is a new delivery model that uses cloud technology to provide business insights without enormous infrastructure enhancements. The executive team has heard great things about analytics and cloud technology but is apprehensive because they are unfamiliar with the look and feel of the technology. The executive team is interested in your recommendations and eagerly awaiting your forward-thinking viewpoint.

Section 1: Design Document
Write a four to six (4-6) page design document in which you:
Support the need for the use of analytics and cloud technology within this company.
Create a workflow diagram to illustrate how analytics and cloud technology could align with the company’s business processes. Note: The graphically depicted solution is not included in the required page length but must be included in the design document appendix.
Create three to five (3-5) screen layouts that illustrate the interface that organizational users will utilize. Note: The graphically depicted solution is not included in the required page length but must be included in the design document appendix.
Give one (1) recommendation for solution providers that could help your company secure a firm advantage by using analytics and cloud technology.
Your assignment must follow these formatting requirements:
Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
Include charts or diagrams created in MS Visio or Dia as an appendix of the design document. All references to these diagrams must be included in the body of the design document.

Section 2: Revised Project Plan
Use Microsoft Project to:

Update the project plan (summary and detail) template, from Project Deliverable 3: Database and Data Warehousing Design, with three to five (3-5) new project tasks each consisting of five to ten (5-10) subtasks.

The specific course learning outcomes associated with this assignment are:

Demonstrate an understanding of existing and emerging information technologies and strategic impact on organizational operations.
Explain how to develop reasoned responses to the major forces shaping the role of IT in organizations competing in a global economy.
Use technology and information resources to research issues in information systems.
Write clearly and concisely about leadership issues and strategic insight of the Information systems domain using proper writing mechanics and technical style conventions.

Project Deliverable 5: Infrastructure and Security
This assignment consists of two (2) sections: an infrastructure document and a revised Gantt chart or project plan. You must submit both sections as separate files for the completion of this assignment. Label each file name according to the section of the assignment it is written for. Additionally, you may create and / or assume all necessary assumptions needed for the completion of this assignment.

The infrastructure which encompasses the network solution and security considerations is a major consideration for your company. Considering that the company will be expanding from one (1) floor to three (3) floors in the very near future you, as the CIO, are responsible for the design of the infrastructure and security protocols. You have been tasked with designing a network that is stable, redundant, and scalable. In addition, speed and reliability are important considerations. Assumptions should be drawn regarding network usage in relationship to network services and resources. All the established criteria that were set at the onset should be adhered to within your plan. The network solution that is chosen should support the conceived information system and allow for scalability. The network infrastructure will support organizational operations; therefore, a pictorial view of workstations, servers, routers, bridges, gateways, and access points should be used. In addition, access paths for Internet access should be depicted. Additionally, the security of the network should be in the forefront of your design because protecting your data is a primary consideration.

Section 1: Infrastructure Document 1.Write a four to six (4-6) page infrastructure document in which you: ◦Justify and support the relationship between infrastructure and security as it relates to this data-collection and analysis company.
◦Present the rationale for the logical and physical topographical layout of the planned network.
◦Design a logical and physical topographical layout of the current and planned network through the use of graphical tools in Microsoft Word or Visio, or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length.
◦Illustrate the possible placement of servers including access paths to the Internet, intrusion detection systems (IDS), and firewalls. Note: Facility limitations, workstations, databases, printers, routers, switches, bridges, and access points should be considered in the illustration.
◦Create and describe a comprehensive security policy for this data-collection and analysis company that will:

•Protect the company infrastructure and assets by applying the principals of confidentiality, integrity, and availability (CIA). Note: CIA is a widely used benchmark for evaluation of information systems security, focusing on the three (3) core goals of confidentiality, integrity, and availability of information.
•Address ethical aspects related to employee behavior, contractors, password usage, and access to networked resources and information.
Your assignment must follow these formatting requirements: •Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
•Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
•Include charts or diagrams created in MS Visio or Dia as an appendix of the infrastructure document. All references to these diagrams must be included in the body of the infrastructure document.

Section 2: Revised Project Plan
Use Microsoft Project to: 2.Update the project plan from Project Deliverable 4: Analytics, Interfaces, and Cloud Technology, with three to five (3-5) new project tasks each consisting of five to ten (5-10) sub-tasks.
The specific course learning outcomes associated with this assignment are: •Develop information systems-related activities to maximize the business value within and outside the organization.
•Demonstrate an understanding of existing and emerging information technologies, the functions of IS, and its impact on the organizational operations.
•Evaluate the issues and challenges associated with information systems integration.
•Use technology and information resources to research issues in information systems.
•Write clearly and concisely about strategic issues and practices in the information systems domain using proper writing mechanics and technical style conventions

Project Deliverable 6: Final Project Plan
This assignment consists of four (4) sections: a written project plan, a revised business requirements document, a project plan PowerPoint presentation, and the finalized project plan. You must submit the four (4) sections as separate files for the completion of this assignment. Label each file name according to the section of the assignment it is written for. Additionally, you may create and / or assume all necessary assumptions needed for the completion of this assignment.

While taking all business and project parameters into consideration, make quality assumptions to support the following requirements.

Section 1: Written Project Plan
You are now in the final stage of the project plan development. All previous documentation should be combined into one (1) document that will serve as the statement of work for the project. Your goal is to have the project approved by the executive team. The project plan should be very detailed, which is appropriate to accomplish the monumental task of implementation; however, the executive team is only interested in a thirty (30) minute summation. Therefore, you also must create a compelling executive summary that is supported by your detail that convinces the executive team that it should move forward with your solution.

Develop a thirty to forty (30-40) page project plan in which you:
Write a five to ten (5-10) page executive summary in which you provide a high-level technical overview of your project where you address the following:

Describe the scope of the project and control measures.
Describe the goals and objectives of the project.
Give a detailed, realistically estimated cost analysis of the entire project, including technical resources (human capital) that may be needed to complete the project.
Relate the value of the project plan solution to the competitive advantage that information technology will afford the organization.
Provide all aspects of the information technology implementation into the project plan.
Recommend solution providers who can assist with development and implementation. Include a cost analysis of at least three (3) providers.
Combine all previous documentation for Project Deliverables 1-5 in which you:
Provide all aspects of the information technology implementation into the project plan.
Revise the documentation based on feedback from the earlier evaluation of the deliverable.
Use at least five (5) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.

Your assignment must follow these formatting requirements:

Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
Include charts or diagrams created in MS Visio and MS Project as appendix of the Word document. Make reference of these files in the body of the Word document.

Section 2: Revised Business Requirements Document

Document all revisions made to the written project plan in the Document Control section of the business requirements document from Project Deliverable 2: Business Requirements. Note: This documentation must outline the revisions made to the previous deliverables required in Section 1: Written Project Plan.

Section 3: Project Plan PowerPoint Presentation

Additional to your detailed executive summary you must present your findings to the executive team and the venture capital group that along with the executive summary will convince the group that your solution is optimal.
Create a ten to fifteen (10-15) slide PowerPoint presentation in which you:

Illustrate the concepts from the executive summary in Section 1 of this assignment.
Create bulleted speaking notes for your presentation to the executive board in the Notes section of the PowerPoint. Note: You may create or assume any fictitious names, data, or scenarios that have not been established in this assignment for a realistic flow of communication.
Use a professional technically written style to graphically convey the information.

Section 4: Finalized Project Plan

Use Microsoft project to:

Finalize your project plan from Project Deliverable 5: Network Infrastructure and Security to include all necessary changes in assumptions, tasks, and / or subtasks.

The specific course learning outcomes associated with this assignment are:

Describe the methods and best practices in implementing process change in IT organizations.
Describe the role and methods of technology-induced process improvement in organizations.
Develop an integrative technology project plan to address and solve a proposed business problem.
Use technology and information resources to research issues in information systems.
Write clearly and concisely about leadership issues and strategic insight of the Information systems domain using proper writing mechanics and technical style conventions.

Solution: #7

CIS499 Project Deliverables 1 2 3 4 5 6 Complete Course New Solution

In an uber globalized market of today, companies are faced with challenges in each and every step of their business. Our analytics and research services are geared towards giving those companies that extra edge over the competition. We process and analyze terabytes of data and break down all the fuzz and chatter around it to give our customers meaningful insights about their competition and the market they are engaged in.

By leveraging our data collection, processing, and research and analytics expertise and by focusing on operational excellence and an industry standard delivery model, we help the leading companies making insightful business decisions.
A comprehensive portfolio of our services include, Market, Business and financial research, Domain based analytics and Data processing services. Our industry wide focus is into Banking, Finance, FMCG, Insurance, Retail and Manufacturing industries.
Role and responsibilities
On studying the company’s profile, it seems that company has following resources which form the personnel of its information systems:
a.    Chief Information Officer - It provides assistance to senior management on IT related tasks.
b.    Develop and maintain IT infrastructure.
c.    Develop efficient design to implement operations of the company.