Bachelor of Information Technology

ITC306 - ProjectPreparation and Professional Practice

Project Title

Hotel Anna’s Network Integration and Standardization Project

Table of ContentsTable of Contents.........................................................................................................................................................................................2Part 1 – Project Charter................................................................................................................................................................................6

Project Background.................................................................................................................................................................................6Purpose of the Charter.............................................................................................................................................................................7Purpose of the Project..............................................................................................................................................................................7Project Vision and Business Need...........................................................................................................................................................8Deficiencies.............................................................................................................................................................................................8

Project Objectives/ Outcomes......................................................................................................................................................................9Objectives................................................................................................................................................................................................9Project Stakeholders..............................................................................................................................................................................10

Measurement Criteria................................................................................................................................................................................11Deliverables/ Scope of the Project.............................................................................................................................................................12

In-Scope.................................................................................................................................................................................................12Out-of Scope..........................................................................................................................................................................................13

Project Resources.......................................................................................................................................................................................15Client Resources....................................................................................................................................................................................15Project Team Resources........................................................................................................................................................................15

WORK Breakdown Structure (WBS)........................................................................................................................................................16Network Diagram:.....................................................................................................................................................................................18The Technical Environment......................................................................................................................................................................19

Hotel Anna’s Existing Corporate Environment.....................................................................................................................................19Existing applications..............................................................................................................................................................................19Existing physical layout.........................................................................................................................................................................20Technical details of the existing environment.......................................................................................................................................21

New Recommendation:.....................................................................................................................................................................22Requirements Specification.......................................................................................................................................................................26

Site requirements...................................................................................................................................................................................26User and Application Requirements......................................................................................................................................................27

Part 2 - Project management plan (a brief version)...................................................................................................................................30

Budget and Timeframe..............................................................................................................................................................................30Time Allocation.....................................................................................................................................................................................30Budget Allocation..................................................................................................................................................................................31

Communication Plan.................................................................................................................................................................................32Monitoring and controlling mechanisms...................................................................................................................................................34Risk Management Plan..............................................................................................................................................................................35

Risk Register..........................................................................................................................................................................................35Risk Assessment and Mitigation...........................................................................................................................................................36

References:................................................................................................................................................................................................37

Project Charter and Management Plan

Project Client: Organization: Hotel AnnaContact: Sanjay Jha

System Name: Network Infrastructure Integration

Date of Charter:

Document Status: Approved

Document Reference: Hotel_Anna_NIS_Project_version_1.doc

Version Number: Version 1

Prepared By: Group 1

Team Members:

Comments: Note this charter and PMP is subject to changes in the following stakeholder’s meeting

Change HistoryAll changes to the Project Charter must be recorded in the Change History, and the new version of the charter must be approved by the

client.

Date Version Change Descripti

on

Reason for

Change

Author

18/8/2009 1.0 Project Charter Initial Draft Rod Valencia25/8/2009 1.0 Project Charter

and Management

Plan

Includes Charter with Management Plan

Atif Dost

28/8/2009 1.0 Management Plan

Completion

Finalized the Charter and PMP with charts and diagrams

Atif Dost

Authorized by:

Name: ________________________ Signature: ________________________Date: ________________________

Part 1 – Project Charter

Project BackgroundHotel Anna is one of the successful hotel network owned by USA Group. The business started in New York, USA in 1998. In successful business run, the hotel business expanded throughout The US in 2000 with 5 branches in different states having New York as business North American Head Quarter. Because of the group’s outstanding performance, few other hotel chains merged into Anna Group from Europe and Australia, which included 5 hotels from Europe having headquarters at London for Europe and 6 hotels in Australia, with the centre of operations in Sydney. Currently Anna Group is facilitating more than 50,000 customers per year with annual revenue US$900 million with net income of US$200 million per year.

After 10 years from establishment, Hotel Ana is considered as a world class accommodation provider to different people around the globe. The hotel is known for its very hospitable staff, and excellent customer service.

However, Hotel Anna’s current corporate network infrastructure is incapable of effectively communicating because of various non-centralized and non-standard technologies being used at various locations. Each network site is independent entity and has very little connectivity based on the DSL internet technology installed. Each network has its own Business, Organizational, Technical and Cultural infrastructure. The decisions are made at each site independent of the other. Following are some of the major issues hampering business operations for Hotel Anna’s Management.

Currently, the applications and hardware used at each site is also independent and has very little or no standardization due to this the reporting formats differ within the organization. This is due to the non-central nature of the corporation’s organization. This is causing a lot of extra expenditure in maintaining various technologies. The current operational cost has made the business less competitive and in order to stay competitive the Hotel Anna’s Management decided to take an initiative to reduce the business operational cost by standardization of the technology across the board and integration of the currently separated networks into a single hierarchical network. For instance, at the time of this documentation the country managers at each site makes decisions about what technologies should be used to achieve a business goal. This will be changed after the implementation of standardized and integrated network technology providing greater control over the network infrastructure and information while reducing business operational costs.

Furthermore, the running network has very little or no security features that can help protect the business in today’s virtual hostility either by well-organized groups, script kiddies or competitors. By securely connecting each site to the head quarter the business will achieve security and peace of mind. Because of the security concerns, the hotels communicate with each other by means of telephone calls and due to geographical issues (e.g. different time zones) often the communication fails. The hotel chain is surviving only by telephone bookings and running a web server to accept bookings online.

Furthermore, for the customers to access internet inside the hotel, they need to go to the Internet café room where computers are provided in order connect. At the moment, a personal portable computer of every client has no means of access of the internet inside the hotel, except if they have their own internet provider.

Purpose of the CharterThe main intention of this document is to discuss thoroughly the agreement between Hotel Anna’s sponsors, shareholders, higher management and ITC306 Company about the changes and additional installation of network infrastructure across all branches of Hotel Anna worldwide. This paper will discuss the scope and boundaries of the project. Furthermore, this document discusses broadly the time allocated to begin the development and the time to conclude the project. Additionally, the charter also includes the estimated budget for the project. These parts of the charter will be discussed individually further in the report.

The aim of the project is to connect the headquarters in every country using VPN over WAN, having the New York office as the center of operations. Also, the project will build servers in every country located in the headquarters. Every main office will also have a LAN connection using switches and routers to join computers located in different departments. The team will use Microsoft Windows Server 2003 with the use of Active Directory to perform the network services. Moreover, inside each headquarter will have an installation of wireless network. Every Hotel Anna will have an installation of wireless access point. Lastly, permissions and layers of security protocols will be installed in the overall network design. All of these phases will be discussed further in the Requirements specification document.

Purpose of the ProjectThe purpose of the project is to provide Hotel Anna the ability to share and access up-to-date important data reliably between each main offices and branches located interstate, inter country, or locally. Also, the project will allow the company open and ready to the

rapidly changing environment of technology. This will also widen the opportunity to tying up with other businesses such as car rentals, booking agencies, and tourism promotions. Furthermore, it will be easier to collect information and updates to all branches of Hotel Anna once they extend their business using the World Wide Web. Overall, this project will give the higher management the easiest way to communicate with other businesses worldwide and save money in the long run. Furthermore, this will assure that sensitive information will be securely managed, and giving customers the highest quality of service in technology.

Project Vision and Business NeedThe vision of the project is to provide each of the branches the capability of sharing its important business information to other branches securely and efficiently. Information should be made available real-time and any time it is needed. Additionally, information should be backed up and safe as highly as possible from any type of attack or accidents.

The participants of the project envisions that this deployment will encourage all employees and other businesses connected to Hotel Anna, to participate and utilise the data exchange network which will give public view and private access to different components in the future. It will open horizons to new businesses and access that will make the participants at ease and satisfied.

As discussed in the purpose of the project, the need of this development is vital and significant for the future of the business. Most of successful worldwide businesses, not just in the hotel industry, implement a strong and robust installation of computer networking to facilitate and organize their reports and transactions. The need to be organized, standardized precise in reporting important data across different branches located in different countries saves a lot of cost, time, and scope of work in a business.

DeficienciesThe current system has problems standardizing communication to each of the branches. For example, every branch produces its own format of reports. The databases used in hotels in Australia uses Microsoft products, while the main branch in New York uses Oracle. Also, important documents such as reports, marketing strategies, holiday deals, are only available from head departments. Therefore, if the department heads are unavailable, which usually happens because of vacation leaves, the documents needs to wait to be available.

Project Objectives/ Outcomes

ObjectivesGoals Objectives

The project will provide fast communication and reliable connection in each branch of Hotel Ana

Achieve 40% increase of speed when transferring information, such as reports, marketing strategies, booking information, events, and legal documents from one branch to another 3 months upon completion.

Reduce down time of network connection to no more than 2%. Changes or updates to database information will be 80% faster

Remove redundancy and provide consistency of information.

By creating a centralize database, after a month from installation:

Reduce Reports, HR, Inventory, Payroll database size. Every branch will have a standard presentation of documents and standard storage of

information (database).The implementation of the network will lower the support costs.

At ease in monitoring and controlling the network traffic. To cancel existing third party vendors and other assistance to the network infrastructure

The project will improve transactions, inventory, and other information that needs network connections

To produce internet connectivity for clients that is faster, convenient and more reliable. Allow clients to connect wirelessly inside Hotel Ana Achieve 95% accuracy when checking inventory status information real time.

The project will prepare the system of Hotel Ana to future improvement

Successful installation will leave the system:

Open to expansion of network in the future Ready for on line transactions and E-commerce Ready for third party connections such as car rentals and touring booking companies.

The project will ensure the privacy, confidential information and security of data

The network architecture will:

Protect private information to unauthorized users. Assure consistency, accuracy and availability of information.

Project StakeholdersRole Name Availability

Project Sponsor Sanjay Jha ThursdayCIO John Harris AppointmentVP, Human Resources Robert Smith Wednesday, ThursdayDirector of Purchasing Tracey Dodd WednesdayIT Representative David Black Monday, Tuesday, WednesdayCountry Operation Managers

Michelle BrownSharon WilliamsDavid JonesMargaret Brown

Friday (9am-5pm)

Project Manager Atif Dost Full Time (Mon-Fri), Weekends if necessary for updates and upgrades

Business Analyst Sushil Aryal Full Time (Mon-Fri)IT Network Analyst Rod Valencia Full Time (Mon-Fri)Network Designer Rajenda Roka Full Time (Mon-Fri)Users Susan Chang

Sue JanjicJosh Kofman

Full Time (Mon-Fri)Full Time (Mon-Fri)Full Time (Mon-Fri)

Measurement CriteriaThe project’s success depends on the following factors:

First phase of the project must be finished in twelve weeks. The first phase will specifically deal with the concrete concept definition and the development of the project (aka Project Feasibility). This will include completing the draft of this document (Project Charter and Management Plan) and successfully getting approved by the Project Sponsor Mr. Sanjay Jha.

The second phase of the project must start in the 13th week and will be finished in the 24th week. The project must integrate Hotel Anna’s three network sites namely; New York (HQ), Australia, and Europe in order to

facilitate the Business and IT management greater control over the infrastructure and the information. The underlying network infrastructure must help facilitate the information to be centralized and then dispatched to

corresponding hotel sites, for instance, hotel room bookings and cancellation. The integrated network infrastructure should also provide basis for corporate application to gather real-time statistics for policy makers to introduce new and last minute deals in order to be more competitive and communicate these deals to its remote sales team via vpn.

The project must be completed within the budgeted cost of $999,999.00 and/or 10% of its variance. See Cost Management Plan for itemized details.

The project implementation must not interrupt current daily operations at the hotel premises during upgrades. The IT staff must be trained during the life of the project.

Deliverables/ Scope of the Project

In-ScopeIn scope Includes

System Functions Installation of Microsoft Windows Server 2003 as the network operating system, to manage

servers, administer policies, provide back up system, and provide default security and firewall. Installation of Active directory to manage administration for organizational units, storage for

users, search mechanism, and sign-on for authorised users. Setting up addressing and naming structure DNS and DHCP to the local network. Putting in switching and routing protocols to enable the centre of operations to communicate with

its branches, and its departments. Adding a Transport Layer Security to be used in web browsing, internet faxing, emails, and for

future online booking features. Installation of Cisco VPN over WAN connections that is used to communicate with command

centres nationwide. Constructing LAN connection and local wireless network in every main office for different

departments to connect and communicate. Installation of access points in every hotel to allow wireless technologies of clients to connect to

the internet. Installation of additional firewalls and HIDS to every access points.

System Documentation Providing documents of the following: Feasibility Study Project Charter Design Specification Project Management Plan Test cases and results documentation Maintenance Manual Logbook for the on going project containing details of progress (softcopy/ hard copy) Network architecture and configuration Network Architecture Organisational Chart Stakeholder Analysis

Training Providing guiding documents for IT department for: Monitoring and controlling the network. Perform fault tolerance in the network. IP addresses, ports, hosts, and naming structure used in the network.

Routing and switching configurations. Back up and recovery processes. Adding, deleting, and administering user accounts. Managing user privileges, authentications, and authorisations.

Device Configuration All network configurations to be installed in headquarters and branches of Hotel Anna are included in the project. This compose of LAN configuration, WAN, VPN, routers, switches, cabling medias, hubs, network protocols, and security configuration.

Out-of ScopeOut of scope Includes

On line services Creation of information website for Hotel Anna. Adding online features such as on line booking, promotions, and memberships. Checking status of bookings online. Gathering real-time statistics

System Enhancements Revisions and further suggestions that is not included in the scope after successful implementation of the project such as:

Installation of other management tools used by Hotel Anna Adding Computer Telephony Integration Additional transport technologies such as frame relay, ATM and others. Implementation of video conferencing, SECAM, voice mails, and Voice conferencing. Accessing the Active directory using mobile phone technology

Database Systems Enhancement of existing or creation of database system, tables, and connection to other databases.Maintenance and support after successful deployment

Monitoring, controlling, updates, and maintenance of the network and devices included in the project. This also includes the hardware warranty and technical support.

Project milestones and deliverables

Milestones for Anna project Deliverables Target DateKick off meeting Information to stakeholders

Assigning roles and responsibility12th Aug 2009

Approved Project Charter Vision of Project Future Planning

28th Aug 2009

Approved Management Plan Scope management plan Cost management plan Time management plan Risk Management plan Human resource management plan Quality assurance plan Communication plan

3rd Sep 2009

Finalized Specification Requirement

System requirement 7th Sep 2009

Final Design Document Logical network design Physical network design

13th Oct 2009

Approval of Project Final Project report 13th Oct 2009

Project Resources

Client ResourcesRole Name Availability

Client Manager Nicole Wilson Tuesday for first two weeksAnd rest by Appointment

Project Sponsor Maui Taylor Appointment

CIO John Harris AppointmentVP, Human Resources Robert Smith Wednesday, ThursdayDirector of Purchasing Tracey Morgan WednesdayIT Representative David Nguyen Monday, Tuesday, WednesdayCountry Managers Michelle Brown

Sharon WilliamsDavid JonesMargaret Brown

Friday (9am-5pm)

Project Team ResourcesRole Name/s Timeframe/s

Project Manager Rebecca Bradshaw Full Time (Mon-Fri)Business Analyst Sushil Aryal Full Time (Mon-Fri)Requirements Engineer Rajenda Roka Part Time (Mon-Tues)Designer Rajenda Roka

Atif DostPart Time (Wed-Fri)Part Time (Mon-Wed)

Network Engineer Atif Dost Part Time (Thurs-Fri)IT Network Analyst Rod Valencia Part Time (Mon-Wed)Test Engineer Rod Valencia Casual Trainer Rod Valencia, Atif Dost Casual

WORK Breakdown Structure (WBS)Following are the screen shots of Work Breakdown Structure (WBS) in project management software and Gantt chart

Network Diagram:Following is the graphical presentation of the network diagram showing dependencies

The Technical Environment

Hotel Anna’s Existing Corporate EnvironmentHotel Anna’s current corporate network infrastructure is divided into the major networks, namely; New York (Head Quarter) Network, Australia Network and Europe Network. Each one of them is independent run entity and has very little connectivity based on the DSL based internet technology installed at each site. Each network has its own Business, Organizational, Technical and Cultural infrastructure. The decisions are made at each site independent of the other.

The applications and hardware used at each site is also independent and has very little or no standardization due to this the reporting formats differ within the organization. This is causing a lot of extra expenditure in maintenance of various technologies at different sites and the management at the head quarter has taken an initiative to reduce the operational cost by standardization and integration of the three network sites into a single hierarchical network.

Existing applicationsAs mentioned above, the network is a mixture of various technologies. This is due to the non-central nature of the corporation’s organization. For instance, the country manager at each site makes decisions about what technologies should be used to achieve a goal. Therefore in New York the network is based on Windows technology however, in Australia the network is a mix of Linux and some windows technology to keep the initial installation and operation cost to a minimum.

Existing physical layout

Technical details of the existing environmentHotel Anna Group Headquarter New York has been running with the following system:

Servers:1. File Server 22. Database Server 23. Windows server (DHCP/DNS/WEB) 24. Exchange Server 25. Router/Firewall 1________________________________________

Total 9

And the computers department wise

Higher Management: 10Human Resource: 30Information Technology 12Finance 24Research and Development 4Legal 10Call Center/Customer Support/Public Relation 10______________________________________________Total 100

Switches

24 Port Switches 7

New Recommendation:Servers:

License Server 2Application 3File Server 3Database Server 3Web Server 3Active Directory 2Firewall 2DHCP 2DNS 2VPN 2Exchange Server 2________________________________________

Total 26

With 520 Client Access Licenses

And the computers department wise

Higher Management: 50Human Resource: 150Information Technology 60Finance 120Research and Development 20

Legal 50Project Management 20Call Center/Customer Support/Public Relation 50______________________________________________Total 520

Switches24 ports switches 648 Ports Switches 10_____________________________________________Total 16

Routers2 Cisco routers4 wireless access routers

Backbone cable:: Fiber OpticsHosts connection: CAT-6

(Printers and faxes need to be estimated)

Software:1. Windows server 2003 server 3 user installation edition.(520 CALs02. Operating system-520 Licenses3. Licensing server 2 per seat4. Microsoft office 520 licenses

Requirements SpecificationCurrently hotel Anna group Headquarter located in New York currently running with 2 file servers, 2 database servers, 2 windows servers, 2 exchange servers and 1 firewall server. Since the offices were running in different infrastructure there was not really load for those server. The new purposed network going to have centralized so the server load balancing will be distributed to more servers as purposed. The new network will include more 16 servers, so in new network it is going to be 3 application servers, 3 files servers, 3 database servers, 3 web servers, 2 active directory servers, 2 firewall servers, 2 DHCP servers, 2 DNS servers, 2 VPN servers and 2 exchange servers. The main servers(Application, Database and Active directory server) having high load will be 3 HP ProLiant DL380 G6 Servers, where as for the normal servers having low load will be used the HP ProLiant ML150 G6 Server servers. All the servers will be running in windows server 2003 Platform.

Where as the office is running with 100 desktop computers for the current users which is not of course enough for the users since the number of users in the headquarter is going to be 520 including all the departments. So the new 420 desktop computers going to be added to fulfil the demands of the users. The new desktop computer is purposed from the vendor Dell is Vostro™ 220s Slim Tower which has the excellent features.In the new network wireless network access facility will be provided in top level of the building only so that the higher management will be benefitted. The network will use the 4 Cisco Aironet 1131AG - wireless access point (AIR-LAP1131AG-A-K9) wireless access point. And the new network will use 2 Cisco routers integrating the security bundle namedCisco Security Bundle, Cisco3825-HSEC/K9 which is the latest and the secure one in the market.The network also will use 10 48 port switches of Cisco named 48-PORT 10/100/1000 MANAGED SWITCH WITH WEBVIEW which is the fastest switch in the market. The entire network will also use the fibre optics cable as a backbone where as CAT 6 cable for connecting the devices.

The server operating system will be Windows Server 2003 Enterprise Edition with 520 CALS which will be managed by the terminal server where as the desktop computer will use the Microsoft office package 2007. Since the Hotel Anna Group has contact with another company to provide the software the new application server will be integrated with the software and the web based application will be installed to the web server to serve the customers throughout the world.

Site requirementsIn our client’s scenario three sites needs to be connected via leased lines. This will require network service providers at New York, Europe and Australian sites to physically inspect and install the E1/T1 lines for central connectivity. The leased lines will also be used for site internet connectivity and audio and video conferencing. The routers will be configured as Data Terminal Equipment (DTE) for voip, QoS and firewall etc.

The LAN will use cisco switches for inter and intradepartmental connectivity and enhanced performance and security. The switches will also provide VLAN capability. New server deployment will also be required for better performance, load balancing and redundancy.

The networks in each continental head office will also be equipped with wireless connectivity for mobile users and higher management.

User and Application RequirementsEach user desktop will have Microsoft Office suite, Internet Explorer and Hotel Anna’s legacy business application. On top of these applications each department will have their departmental application installed. For instance, Accounting department will use Accpac etc.

Voip telephony will be configured with QoS for low latency. The T1/E1 lines ensure 99.97% uptime for online transaction processing by the hotel management legacy application.

Table below shows the hardware and software needed for the project to be accomplishedSerial Number Item Name Vendor Quantity

1 HP ProLiant DL380 G6 Server HPMethod: Online

3

2. HP ProLiant ML150 G6 Server HP 123. Vostro™ 220s Slim Tower Dell 420

4. 48-PORT 10/100/1000 MANAGED SWITCH WITH WEBVIEW Cisco 105. Cisco Aironet 1131AG - wireless access point (AIR-LAP1131AG-A-

K9)Cisco 4

6. Cisco Security Bundle, Cisco3825-HSEC/K9 Cisco 2

7. CAT-6 Cable D-Link 17 (5000m)8. Fiber Optic Cable D-Link 200M9. Windows Server 2003 Enterprise Edition Microsoft

With 620 CALs3

10. Windows Terminal Server Microsoft 111. Microsoft office 520 Licences 512. Miscellanies