Project Plan and Proposal Development

Professional Consulting In Information System -Project Plan and Proposal Development

Please review the attached PPT for my project idea.

Don't use plagiarized sources. Get Your Custom Essay on

Just from $13/Page

Order Essay

It’s about the automation of assisted living website to improve health service for edlerly people.

I need to crate detailed project plan and project proposal.

It must use

1. Important-Requirment-ProjectPlan-ProposalDevelopment-Instruction

2. AssistedLivingAutomation.pptx for my original idea

3. SampleFormat – Master Project Management Plan or the best one you have if cover everything in # 1 Important-requirement…

Subject:Professional Consulting In Information System –
Output expected: Project Plan and Proposal Development
=========================================================
******** I must include a detailed project plan.
*** The Project Plan describes what you plan to do; what your project is all about.
Refer: Page-4 to 7 PPT AssistedLivingAutomation.pptx

*** The plan includes an introduction to the business/organization that has the IS problem,
information on the problem you have identified, a literature review of previous efforts relating to your project that will validate the need to complete your project, a description of how you plan to solve the problem (i.e., your approach or plan of action), and includes a description of the anticipated deliverables (e.g., feasibility study, program, database, etc.).
*** The plan is a detailed document that answers the questions why, what, and how.
*** It includes the following sections and information:
• Introduction
o This should be a very brief overview of the business and the problem you are attempting to solve.
• Statement of problem or question [This section answers the question WHY?] — refer PPT
o Why are you doing this?
▪ To solve a problem or meet a need. Identify the problem you have identified and are addressing in this project.
o Include a review of the current situation (or literature review) to describe what is going on in this area or discipline now.
Page 4 to 6: what technology in current and future
AssistedLivingAutomation.pptx Page 6
********How is the problem being addressed now?
▪ What solutions or techniques are being used?
▪ What technology is current and is it effective?
• Objectives (Goals, purpose) [This section answers the question WHAT?]
o What do you plan to achieve?
o What is the desired outcome of this project?
o Deliverables
********Describe what you will actually have once you have completed your project.
Important: For example, this could be a ***feasibility study**, an information system, a website, a program, theoretical review, etc.
****Be specific here – e.g.,
(1) A website that allows visitors to enter their name, e-mail address, and question;
(2) a database that stores all visitor information (name, e-mail address, question, etc.);
(3) a program that automatically determines the nature of the questions and returns an automated answer
********Scope of the Project. (Scope of work, Plan of action, Activities)
[This section answers the question HOW?]
o Describe how you plan to achieve the objectives.
o Discuss the activities you have identified that will help reach your desired result. These are the specific activities you will undertake to solve the problem or meet your objectives.
o Here you describe how your project or idea will differ or improve on what is being done and how you intend to accomplish this.

Error!Unknown document property name.
July 2,

997

Master

Project Management Plan

Health and Human Services Agency,

Office of Systems Integration

Revision History

Revision/WorkSite #

Date

of Release

Owner

Summary of Changes

Initial Draft 2513v7

7/31/2004

SID – PMO

Initial Release

OSI

Admin #5603

8/29/2008

OSI – PMO

Major revisions made. Incorporated Master Project Management Plan tailoring guide information in this template.

Remove template revision history and insert Master Project Management Plan revision history.

Approvals

, OSI Project Director

Date

, OSI Project Manager

Template Instructions:

This template offers instructions, sample language, boilerplate language, and hyperlinks written in 12-point Arial font and distinguished by color, brackets, and italics as shown below:

· Instructions for using this template are written in purple bracketed text and describe how to complete this document. Delete instructions from the final version of this plan.

· Sample language is written in red italic font and may be used, or modified, for completing sections of the plan. All red text should be replaced with project-specific information and the font changed to non-italicized black.

· Standard boilerplate language has been developed for this plan. This standard language is written in black font and may be modified with permission from the OSI Project Management Office (PMO). Additional information may be added to the boilerplate language sections at the discretion of the project without PMO review.

· Hyperlinks are written in blue underlined text. To return to the original document after accessing a hyperlink, click on the back arrow in your browser’s toolbar. The “File Download” dialog box will open. Click on “Open” to return to this document.

Table of Contents

Introduction

1.1
Purpose

1.2
Scope

1.3
References

1.3.1

Project Centralized Document Repository

1.4
Acronyms

1.5
Document Maintenance

1.6

Master Project Plan

(

MPP

) vs. Project Management Plan (

PMP

)

Project Planning

2.1
Scope Management

2.1.1

Scope Statement

2.1.2

Scope Management

2.1.3

Work Breakdown Structure

2.1.4

Formal Acceptance of Scope

2.2
Time Management

2.3
Cost Management

2.4
Quality Management

2.5
Staff Management

2.6
Risk Management

2.7
Communication Management

2.8
Configuration Management

2.9
Contract Management

7
2.10
Governance Plan and Issue Escalation Process

2.11
Organizational Structure

2.12
Project Assumptions and Constraints

2.12.1

Project Assumptions

2.13
Project Constraints

Project Execution

3.1
Project Management Plan Execution

3.2
Information Distribution

3.3
Application Customization

Project Control

4.1
Integrated Change Control

4.2
Scope Change Control

4.3
Schedule Control

4.4
Performance Reporting

Unanticipated Tasks

Project Schedule

Phase Close-Out & Lessons Learned

7.1.1

Conducting Formal Lessons Learned

7.1.2

Contract Close Out

7.1.3

Administrative Closure

A-1

Appendix A – Work Breakdown Structure

B-1

Appendix B – Project Schedule

1. Introduction

1.1 Purpose

The purpose of the Master Project Management Plan is to capture ‘how’ the project will be managed throughout the project life cycle.

The purpose of the Master Project Management Plan (MPP) document is to provide the project stakeholders with an approved working guide for how the Project will manage the project. The MPP describes how to manage the activities of the Project, the prime contractor, and other supporting organizations throughout the project life cycle phases to ensure a timely, efficient, and effective system acquisition as defined in the Project Charter.

1.2 Scope

This Master Project Management Plan identifies the activities, processes, and procedures used to manage . Define the parameters that this plan encompasses.

The MPP describes the overall purpose and scope of the MPP as a document. It provides how the Project office will be organized, staffed, and describes who the project stakeholders are. The MPP further details the methodology for project management that will be employed for each project life cycle phase, as well as a brief description of each of the component plans of the MPP.

1.3 References

Project Management Institute (PMI)

Project Management Book of Knowledge

(

PMBOK

3rd edition)

Institute of Electrical & Electronics Engineers

(

IEEE

)

Software Engineering Institute (

SEI

) at Carnegie-Melon University

Statewide Information Management Manual

(

SIMM

)

OSI Best Practices website (

BPWeb

)

http://www.bestpractices.osi.ca.gov

1.3.1 Project Centralized Document Repository

Refer to the WorkSite repository located at for all project-specific documentation. If the project is not using WorkSite, indicate the location of the project’s electronic document repository as well as the project’s hardcopy library. If the project is using a tool to track staff information and the staffing profile, indicate the name and location of the tool.

1.4 Acronyms

Work Breakdown Structure

BPWeb	Best Practices Website
DGS	Department of General Services
DOF	Department of Finance
DTS	Department of Technology Services
IEEE	Institute of Electrical & Electronics Engineers
MPP	Master Project Plan
OSI	Office of Systems Integration
PMBOK	Project Management Book of Knowledge
PMP	Project Management Plan
SEI	Software Engineering Institute (SEI) at Carnegie-Melon University
SIMM TA	Statewide Information Management Manual California Technology Agency
WBS

1.5 Document Maintenance

This document will be reviewed annually and updated as needed, as a project proceeds through each phase of the system development life cycle. Lessons learned as a result of continuing staff management efforts will be captured at the end of each project phase and used to improve project and OSI standards. If the document is written in an older format, the document should be revised into the latest OSI template format.

This document contains a revision history log. When changes occur, the version number will be updated to the next increment and the date, owner making the change, and change description will be recorded in the revision history log of the document.

1.6 Master Project Management Plan (MPP) vs. Project Management Plan (PMP)

The MPP is developed and controlled by the project office and is the highest-level project management document. The MPP is for the project office to manage the entire system effort.

The PMP is a contractually defined management document developed by the contractor to manage his obligations. The PMP is subordinate to the MPP and must be integrated via the appropriate contracting vehicles.

2. Project Planning

The project management plan is based primarily on the project management processes described in the PMBOK, 3rd edition. The methodology for planning the project utilizes the aspects of the PMBOK where applicable to the project based on its size, complexity, and staff resources.

2.1 Scope Management

2.1.1 Scope Statement

The scope of the project is to procure and implement a centralized, integrated information management system at to ensure that conditions are monitored and tracked according to program guidelines that meet the intent of the Project.

The scope of the Project is to:

· Secure and retain project approval and funding

· Define business requirements for the

· Upgrade facilities to implement

· Ensure Verification and Validation, and Independent Project Oversight are performed

· Procure a vendor to design, customize, test and implement the , and the needed interfaces to and from existing OSI systems

· Ensure the program organization and staff are prepared for the implementation

· Retire the previous system(s) software and documentation components

· Complete the Post Implementation and Evaluation Report

The scope of the project does not include:

· Exploring non-automated solutions, due to the court order.

· Installing the system at locations other than .

· Providing functions outside those required

2.1.2 Scope Management

The project scope will be managed through the various management plans, project documents, reviews, and change control processes established throughout the project’s phases. The project plans will be developed to ensure that the project scope baseline is maintained and consistent. Project documents will be reviewed to ensure the scope as establish in the Project Charter, Feasibility Study Report, and in this Project Management Plan is not inadvertently altered or changed. The project scope will primarily be managed through the project’s scheduled reviews such as Weekly Status Meetings, Bi-Weekly Vendor Meetings, and monthly Steering Committee Meetings, and through the change control process. Communication will play a key role in scope management. The project has establish several forms of verbal and written communication described in the Communication Plan to ensure stakeholders, sponsors, executive management, team members, external agencies, and vendors involved in the project have a clear understanding of the project scope. There are so many elements that could affect a project’s scope within a project that the very nature of scope dictates that its management is integrated in all aspects of the project.

Although the objective is to have little or no change to the project scope, some changes should be anticipated. In the event that scope changes occur, the changes will be identified through the Change Control process established in the Configuration Management Plan. As changes to technical and business requirements, hardware, software, documents, and system design are identified, the impact to the project’s scope will be assessed and addressed during the formal Change Control process.

Scope changes will be classified as internal or external, and project-level or management-level. The following defines what constitutes an internal versus external scope change:

Internal Scope Change – Change that is generated or results within the project organization and structure within the OSI. Examples are changes in business policies, OSI policies, functionality, technical design, resources, etc.

External Scope Change – Change that is generated or results from entities external to the project organization and structure. These changes may be generated or result from external control agencies, legislation, court orders, State mandates and policy, public sector, or environment.

Both the Team and the Vendor will identify any potential internal scope changes. Any external scope changes will be identified through the Executive Steering Committee, Project Director, sponsors, and the Project Managers.

The project-level scope changes, internal or external, are considered those changes that meet the established criteria and can be approved by the Project Change Control Board as described in the Configuration Management Plan. Management-level scope changes, internal and external, will constitute those changes that require the approval of the Management or Steering Committee Change Control Board as described in the Configuration Management Plan.

2.1.3 Work Breakdown Structure

The WBS is a hierarchical decomposition of the work to be executed by the project team, to accomplish the project objectives and create the required deliverables. The WBS organizes and defines the total scope of project. The WBS subdivides the project work into smaller, more manageable pieces of work.

The Project work breakdown structure is provided in Appendix A.

2.1.4 Formal Acceptance of Scope

The formal acceptance of the project scope was accomplished through the Project Charter. The Project Charter was prepared and submitted by the Project Managers and the Project Director. The charter was distributed and coordinated through the project sponsors and executive management staff with final approval by the Project Director.

2.2 Time Management

Time Management Plan includes the processes required to accomplish timely completion of the project. Time Management processes would be the schedule development, management and control throughout the project life cycle.

The Time Management Plan of the project centers on the overall project schedule. The project used a top-down approach to develop the project work breakdown structure that was used as the foundation for the development of the overall project schedule. The project consists of six major parts 1) Infrastructure Upgrades; 2) Data Center Implementation; 3) Vendor Development; 4) OSI Management; 5) Verification and Validation; and 6) Independent Project Oversight Consultant as shown in the work breakdown structure, Appendix A. These six major parts were then broken down further into the major activities that make up each of these parts. With the exception of the Vendor Development activities, all the major activities were broken down into subordinate activities and finally down to the task level. Each of the Team members was then assigned specific areas to identify the activities and tasks in their respective areas. The schedule provided by Vendor was used to establish the Vendor Development part and the Data Center provided a schedule for the Data Center Implementation part.

A combination of bottom-up and top-down approach was taken to establish the durations depending on the activity, task, or dependency. Through several iterations and alignment of activities and tasks, the overall project schedule was produced and established.

The project uses Microsoft Project as a tool to integrate, monitor, manage and control the overall project schedule. The schedule is password protected to allow only write access to the Project Scheduler and the Technical Project Manager. All other Project Team members have read only access. This prevents any unauthorized or inadvertent changes to the schedule. The overall project schedule is baselined and any changes or variations to the schedule are reflected and captured in Microsoft Project, and can be viewed using the Tracking GANTT view function in the application. The Project Scheduler will assess schedule impacts on a weekly basis, monitor the progress, and identify areas where the schedule is or may fall behind. The Project Scheduler will bring any items that potentially impact the schedule’s critical path to the User and Technical Project Managers’ attention. The Project Scheduler will use Microsoft Project to continually re-assess the project’s critical path and recommend actions to avoid schedule slips or mitigate impacts.

The schedule will follow a formal change control process for any proposed changes to the schedule. The change control process for the project schedule is described later in this document.

2.3 Cost Management

Cost Management Plan is to ensure the project and its contractors will complete the project within budget. Cost management also includes analysis of options and issues to determine the potential effect on the project’s budget and operations.

The Cost Management Plan will be provided as a separate plan and addresses the how project cost will be managed and controlled for the project.

2.4 Quality Management

Quality Management Plan will define, measure, and improve the quality of the project’s processes and products in order to fulfill the success criteria. Quality management establishes the processes by which project products and processes must adhere to specified requirements and established plans throughout the project life cycle.

The Quality Management Plan will be provided as a separate plan. The Vendor will provide a Quality Management Plan for their portion of the project as a deliverable product of the contract.

2.5 Staff Management

Staff Management Plan identifies the process and procedures used to manage staff throughout the project’s life. The plan describes the planning and acquisition of both state staff and consulting staff, describes the responsibilities assigned to each staff, and discusses transition of staff to other assignments.

The Staff Management Plan will be provided as a separate plan and addresses the how staff acquisition, training, tracking & management and transition will be managed and controlled for the project.

2.6 Risk Management

The Risk Management Plan includes processes by which potential threats to project success are identified, mitigated, or eliminated. Risk considerations will include technical, management, solicitation and contracting, performance, budget resources, political, natural disasters, security etc. Risk management is an integral part of project management from project initiation through project completion.

Refer to the Risk Management Plan for more information on risk management.

2.7 Communication Management

The Communication Management Plan includes processes by which project information is developed, maintained, and managed for both internal and external project stakeholders.

Refer to the Communication Management Plan for more information on communication management.

2.8 Configuration Management

Configuration Management Plan establishes the processes by which system documentation items are defined, maintained, and managed.

Refer to the Configuration Management Plan for more information on configuration management.

2.9 Contract Management

Contract Management Plan identifies the activities to be performed or initiated by project staff to manage, track, amend, and close a contract. Contractor activities and activities performed by other state organizations are discussed at a high level only to facilitate an understanding of the complete process.

Refer to the Contract Management Plan for more information on contract management.

2.10 Governance Plan and Issue Escalation Process

Governance Plan identifies the key governance roles and responsibilities for the project and covers who by role, is responsible for approving project documents, establishing contracts in support of the project, approving contractor deliverables, and making the final decision to accept the automated system and contractor products. The Executive Steering Committee is the primary entity within this project guiding the governance processes. The Issue Escalation Process identifies the governance and escalation process that will be used to manage issues, problems, change, or approvals.

Refer to the Governance Plan and Issue Escalation Process for more information.

2.11 Organizational Structure

The following is a list of internal and external organizations impacted by the Project. Other entities include OSI (for project management), Department of Technology Services (DTS) (for system & network hosting), Department of General Services (DGS) (for procurement support), Department of Finance (budgetary) and the California Technology Agency (TA) (for project oversight).

List organizational structure here

2.12 Project Assumptions and Constraints

2.12.1 Project Assumptions

In order to execute and accomplish the project within the time constraints is based on the following assumptions:

· Control Agencies have approved an accelerated schedule of approval and procurement.

· Control agencies provide approvals by MM/DD/YYYY and funding by MM/DD/YYYY.

· Potential vendor has a developed system that contains the majority of the components to satisfy the business requirements.

· Vendors do not contest the procurement and ultimate award of contract.

· Vendors will clearly understand the requirements defined in the RFP.

2.13 Project Constraints

The major constraints facing the project are:

· Time constraint ordered by the Program.

· The system must operate within the electrical capacity and environment provided or planned at the facilities.

· The system must be implemented and maintained with the funds approved by the State.

· Resources to support the project are limited to existing staff and skill levels available.

· Control Agencies (California Technology Agency (TA), Department of Finance (DOF), and Department of General Services (DGS) must review and approve key deliverables before proceeding to the next phase of the project.

· The Vendor (the selected Bidder) will conform to IEEE or equivalent and PMI or equivalent standards (per direction from the DOF, OCIO, and DGS).

3. Project Execution

3.1 Project Management Plan Execution

Describe the Project Management Plan execution phase and the activities involved.

The Project Management Plan execution will be initiated through a Project Kick-Off Meeting. The Project Kick-Off Meeting provides the forum to integrate all parties involved in the project and focus everyone toward a common set of project objectives. The objective of the kick-off meeting is to provide background and an overview of the project, and to establish a common set of management processes and procedures that the project will use to execute the project through implementation. Completion of this meeting constitutes the formal execution of the Project Management Plan.

The Project Management Plan will continue to be executed throughout the project through the established processes and procedures documented in the various management plans developed by the Team and the Vendor. The Project Manager is responsible to monitor the execution of the plan and will use status meetings, reports, and project metrics to ensure that the project management plan is being executed. The various meetings and reports are described in the Communication Plan.

3.2 Information Distribution

Describe how information will be distributed throughout the project life cycle.

The Communication Plan describes how the information distribution will be executed for the project. In addition, the Configuration Plan identifies the various project records and describes how these items will be accessed and maintained.

3.3 Application Customization

Describe the application customization that may be applicable to your project during the execution phase.

The project is solution with some customization. The Vendor is accomplishing the customization to the application. As such the methodology being used for the technical development on the project is primarily utilizing the Vendor’s processes with technical staff providing oversight of the Vendor.

The detailed areas of the technical execution will be found and described in the following documents:

System Requirement Specification

Detailed Design Specification

Database Schema

Test and Evaluation Master Plan

Data Conversion Plan

User Reference Guides

Training Plan

Implementation Plan

In addition to these documents being developed over the course of the project, several technical review meetings and work sessions are scheduled to review, assess, and monitor the technical aspects of the project.

4. Project Control

Describe the change control process that is necessary for controlling factors that create changes to make sure those changes are beneficial, determining whether a change has occurred, and managing the approved changes, including when they occur.

4.1 Integrated Change Control

The description on how integrated change control is accomplished can be found in the Configuration Management Plan.

4.2 Scope Change Control

The Scope Change Control Plan will follow the processes and procedures described in the Configuration Management Plan. The project-level scope changes, internal or external, are considered those changes that meet the established criteria and can be approved by the Project Change Control Board as described in the Configuration Management Plan. Management-level scope changes, internal and external, will constitute those changes that require the approval of the Management or Steering Committee Change Control Board as described in the Configuration Management Plan. Refer to the Configuration Management Plan for the formal change control process.

The magnitude and overall impact as a result of scope variation needs to be identified to assess the impact to the project in terms of cost, schedule, or performance. The Project Managers and Team members will evaluate and assess the magnitude and overall impact for each change proposed, initiated or imposed. The performance measurement in terms of the degree (magnitude) and the severity (overall impact) of the individual scope changes will be used to assess the variation in scope. The scope variation will be monitored and tracked through each phase of the project using the measured impact of cost, schedule, and performance attributed to scope changes.

4.3 Schedule Control

The Project schedule will be monitored, tracked, and controlled by the Project Scheduler. The Project Scheduler will establish and maintain the overall project schedule using Microsoft Project. Once the final project schedule is established and approved, the baseline will be set. Progress and schedule changes will be tracked against the baseline to identify variances.

As part of the time management process and procedures, the Project Scheduler will use established forums within the project to manage the Project schedule. The following will be utilized to monitor and track the project schedule:

· Weekly Team Status Meetings

· Bi-Weekly Team/Vendor Status Meetings

· Vendor Monthly Status Reports

· Daily communication (as required)

All potential impacts to the project schedule must be reported (verbally or written) to the Project Scheduler prior to a schedule slip occurring. Only activities and tasks on the overall project schedule must be reported to the Project Scheduler.

Project Schedule change requests must be submitted to the Project Scheduler and include the following:

· the activity/deliverable/milestone impacted

· how and why the change is being requested

· alternatives to meet the original end date

· revised end date

· action plan to meet the revised end date

Approval, through the Change Control Process described in the Configuration Management Plan is required to change the overall project schedule and/or baseline.

4.4 Performance Reporting

The project performance reporting will be accomplished through established status meetings, reports, and internal project tracking systems. The following are a list of mechanisms used that provide performance reporting:

Weekly Status Meeting

Vendor Bi-Weekly Status Meeting

Monthly Steering Committee Meeting

Monthly Status Report

TA Monthly Project Status Report

Vendor Monthly Status Report

Action Item Tracking System

Risk Database Tracking System

Deliverable Tracking System

The two major performance metrics being reported are cost and schedule. The cost is being tracked in terms of variances to the approved budget and spend plan. The schedule is being monitored in terms of variances to the established baseline.

5. Unanticipated Tasks

As the project evolves, items may arise which would cause unanticipated tasks, scope changes, or enhancements that may be beyond the original contract. The process for addressing unanticipated tasks, scope changes, or enhancements that are beyond the scope of the original contract will be to follow the Scope Change and Contract Change procedures described. Enhancements beyond the original contract will be prioritized and postponed until after the implementation of the Project unless the enhancement is critical to the successful implementation. If the enhancement is critical to the success of the implementation, then the Scope, Cost, and Schedule Control procedures will be followed.

6. Project Schedule

Refer to the Project Schedule for the detailed overall project activities, tasks, and milestones. The high-level depiction of the major activities and milestones can be found in Appendix B.

7. Phase Close-Out & Lessons Learned

Phase Close-Out & Formal Lessons Learned are project management activities performed at the end of each OSI life cycle phase to ensure the proper closure of a current life cycle phase before proceeding to the next phase. Close-out activities include review of all goals and objectives of the phase, final status and closure of issues and risks related to the phase, and review of documentation and files for archival or destruction.

7.1.1 Conducting Formal Lessons Learned

At the close of each life cycle phase, the project prepares a lessons learned report. This includes an analysis of project objectives achieved during the completed phase. Lessons Learned reports are imported into the Best Practices WorkSite Repository for use by other projects and identifying areas for process improvement action.

7.1.2 Contract Close Out

The following close out items referenced in the Contract Management Plan Template for this function should be reviewed for applicability, tailored, and summarized. The summary should describe actions taken by the project office in performing close out for each of the items below (as applicable).

· Contract Final Reports

· Contractor Evaluation

· Invoices and Disencumbering Funds

· Archiving Contractor Records

The following items from the Contract Management Plan are established for specific instruction related to contract closeout.

The following tracking and execution items referenced in the Contract Management Plan Template (for consultants) should be reviewed for applicability, tailored, and summarized. The summary should describe actions to be taken by the project office in performing close out for each of the following items (as applicable).

Contract Final Reports

Contractor Evaluation

Invoices and Disencumbering Funds

Archiving Contractor Records

The following items from the Contract Management Plan (for consultants) are established for specific instruction related to contract closeout.

7.1.3 Administrative Closure

The Administrative Closure is the process of preparing closure documentation of the project deliverables for the customer as well as taking other administrative actions to ensure that the project and its asset are redistributed.

· Financial Closure and Audit – completing and terminating the financial and budgetary aspects of the project being performed.

· Archiving- creating and storing a hard and/or soft copy of all documentation related to the project

· Personnel and Facilities – reassignment and reallocation of personnel and equipment that have been used during the project

Appendices

Appendix A – Work Breakdown Structure

Appendix B – Project Schedule

� EMBED MSPhotoEd.3 ��

Printed at 07/11/11 11:02 AM

DRAFT

_1182151892.bin

Assisted living
automation solution
Increase the efficiency of the senior healthcare facilities

Establish the most efficient methods of offering healthcare services in our Assisted Living facilities. The ultimate goal is to provide efficient, effective, and high-quality healthcare services to the patients.
OUR BIG
IDEA

ALF – Assisted Living Facility
SNF – Skilled Nursing Facilities
IL – Independent Living
By 2030, 20 percent of Americans, about
70 million people were age 65 and older.

Why automation of assisted living facility?
Assisted living healthcare services involves a healthcare setup within which patients inside the community life and are offered healthcare services, especially the elderly population.
The sector is faced with an issue whereby patients keep waiting for longer time periods before they are served within the healthcare center. This is a threat to their lives, especially when they are in critical condition.
Timely patient care is among the most prevalent issues that reduce inefficiency in any healthcare facility. This leads to poor provision of services and also a reduction of service quality.
Consequently, community members tend to have minimal access to healthcare services, which is a threat to their lives.
Among the main issues facing the senior management of any healthcare facility is the delayed communication between different levels of the facility staff. In some cases, this has led to the failure of projects and even delayed operations within the facility.
4

automation of assisted living facility
To solve the issue, there is a need to establish an automated system through which the facility management is able to receive the information and act promptly.
The system must be linked to the facility website in such a manner that information will be transmitted directly into the website and also the organizational managers.
Any projects happening within the community could be posted on the website at ease and the management would be in a position to access them at ease.
This will reduce the duration spent between the different levels within which information is passed.
5

what technology in current and future
Current:
Currently my company is using plain html/java script based website.
This website helps company’s purpose marketing and facility management through email channel.
The company’s critical data are stored in Microsoft excel format along with physical papers copies.
Future:
Developed interactive website to accept input from different channel including email, phone (text message or voice mail), website, excel and external vendors to accept data and update it on website in near real time. Send alerts and immediate response for critical situations.
Performed system analysis and design
Generate Entity Relationship Diagram (ERD)
I am planning to use Microsoft SQL Server Express database and .Net Framework to achieve the same.

objectives
The main objective of the idea is to reduce the healthcare service delays through enhancing automation.
This would be through creating a channel whereby the facility management and other stakeholders within a region are able to pass information easily and automatically through an application.

The expected outcome of the idea is increased speed by 20 % of service delivery to the assisted living members within a healthcare facility.
The main expected result of the idea is that the community members will easily access healthcare facilities within a short period of time.
This implies that overall management will be more efficient.

7
Results

Project Timeline
The project timeline includes processes involved in meeting the technological implementation in healthcare sector.
The use of automation is expected to take about six months prior to its implementation into the healthcare system.
This is mainly for the reason that the technology department need to be well trained on the importance of using the tool and the best way of ensuring its efficiency.
It is also important for the other healthcare providers to be educated on how to use the application for better results.

SNF1,800,000ALF1,500,000IL350,000Hospice150,000
Chart1

SNF
ALF
IL
Hospice

Where Seniors Live
SNF
1,800,000
ALF
1,500,000
IL
350,000
Hospice
150,000
1800000
1500000
350000
150000

Sheet1

Where Seniors Live
SNF 1,800,000
ALF 1,500,000
IL 350,000
Hospice 150,000
To resize chart data range, drag lower right corner of range.

ASSISTED LIVING AUTOMATION SOLUTION 2

Assisted Living Automation Solution

Name: Bhumikaben Desai

Institution: Minot State University

Date: 03/05/2020

Table of Contents
Introduction 3
Statement of problem 3
Overview of the current situation 4
Which solutions and techniques currently in use. 4
What technology is effective currently. 4

Project objectives

5
Desired outcome of the project. 5
Scope of the project 5

Assisted Living Automation Solution

Introduction

Assisted living automation calls for efficient software solutions. so that all the issues can be addressed. By all issues means that The software to beeing adopted needs to takes into consideration the security, wellbeing, satisfaction. and proper management of residents. being impacted. Fundamentally, assisted living software are designated to enhance communication amid residents and their families. They also aim at improving on the quality of the existing services. The software also lets the personnel schedule, optimize, and have a proper control of the activities which they take part in. In order for

For a product to be included in Assisted Living category, it has to meet the following conditions (Shah & Patel, 2018):. (1)mMust be in a position of assessing the needs of the residents in terms of gender, age, health and other important aspects; . Secondly, it (2) must be in a position of developing standards of service delivery and comply with any agreement which might need (Thanh & Au, 2017); . They (3) should be in a position of being customized so as to meet the user needs; and (4). Lastly, must be in a position of tracking the schedules made at some point depending withmeeting the needs of the patients.

Statement of problem

Existing methods of offering healthcare facilities have been questioned multiple times with authors pointing out the needs to have technology fully integrated into healthcare centers. Poor technology integration into the healthcare sector has resulted to a number of issues including but not limited to provision of poor-quality services to patients. Another challenge which that is facing the healthcare sector that with the automation solution will be sought to address is long waiting times to receive treatment services. This has posed a greater threat to the health wellbeing of the patients, specifically when they are in a critical condition. The aforementioned conditions will eventually result to provision ofin the offering of poor services. This project aims at coming up with solutions which will help address these issues. Comment by Lori Willoughby: Comment by Lori Willoughby: Offering what?

OVERVIEW OF THE CURRENT SITUATION

Which solutions and techniques currently in use.

There exists a number of solutions which that are in place currently to address prolonged delays in hospitals prior to receiving treatment. One of the is the decentralization of the hospital administration, with the goal of ensuring that different patients are being addressed from diverse locations, so as to reduce congestion. Although the technique has helped in reducing the delays, there is still needed to have better more efficient ways that can make this challenge null. Another way the challenge is being addressed currently is by having online reservation of nurses and doctors prior to arriving for medical conditions. This also was helpful in a way but was not efficient. Comment by Lori Willoughby: Do you need a citation here? Be sure to include the references and in APA format.

What technology is effective currently.

The technology currently in use in the company is plain html/java scripts which are purely script based. The websites allow the organization to display some of its information, but only after being through a number of parties. The technology is also reliant on Microsoft Eexcel formatting along with physical papers in trying to maintain its data. This is dangerous as some of the information can easily be lost or misplaced.

In the future, there is need to develop an interactive website to:

1. accept input from different channels including email, phone (text message or voice mail), website, Eexcel and external vendors to accept data and update it on the website in near real time,.

2. Ssend alerts and immediate response for critical situations.

3. The technological systems to be used must be capable of linking the facility website within a manner that information moves directly to the website free of any potential stopovers. With such technology, any activity taking place within the organization will be available on the website and any reference will be made easil, and

4. y. The company should also consider into generating an Entity Relationship Diagram (ERD) to ensure that any information stored is safe.

FEASIBILITY STUDYPROBLEM STATEMENT

Establishment of an interactive website and information system will enhance the communication between different entities within the organization. It will also ensure easier and better service provision especially because it will be able to send alerts about any critical situations and also provide immediate response. This will benefit the organization significantly in that the communication would be directly transmitted to the website and the entire information system without necessarily having to pass through different stages. In this manner, installation of the new system will be vital towards improving the strategic plan of the organization and also enhancing its long-term plan. The project objective is to

Project objectives

The main objective of the idea is to reduce the healthcare service delays through enhancing automation .

This would be through by creating a channel wherebywhereby, the facility management and other stakeholders within a region are able to pass information easily and automatically through an application. The desired outcome of the project is to

Desired outcome of the project.

The desired project outcome is havinghave an automated healthcare facility in which patients will always be receiving efficient services.

Scope of the project

The main objective for this project is to reduce medical services delays. This is mainly for the realization that among the issues within the healthcare facility whereby patients are kept waiting for long time before they receive the healthcare service that they need. This leads to project failure and even delays in facility operations.

How to achieve the objectives

To solve this issue, the project aims at developing an automated system within the assisted living facility. This would play a key role in minimizing the time spent to carry out different operations within the system. Most importantly, the members of staff within the facility and alsoand other stakeholders will be in a position to easily and efficiently share and receive important communication among them. Faster communication would also ensure faster implementation of operations within the facility. Comment by Lori Willoughby: Is the scope of the project to complete the feasibility study, analyze the problem, design the solution, and implement it. Or is the scope of the project the feasibility study. It seems that there are several phases to the project and you might want to indicate that this project is doing one or more phases but not the entire project.

The scope of this project is limited to complete the feasibility study, analyze the problem and design the solution for it. The implementation will be done in different phase and it is not part of this project.

Activities that will help in achieving the objective Comment by Lori Willoughby: Write this section in a way that will reflect the scope statement, detailing what will be completed.

There are specific activities that the project aims at carrying out as far as achieving the objective is concerned. The project will link the facility system to its website in such a way that data is directly transmitted through the website. For instance, if the facility management wishes to communicate some changes to the organizational staff members, they would update the online noticeboard via the facility website and the system will be automatically informed. Also, any community projects would be posted on the website and this information would be passed to other entities within the facility. The website will also work in an interactive manner, in such a way that community members can communicate to the facility about any healthcare issues and the organization will respond to the enquiries in good time. Through this, the healthcare services delays will be reduced significantly for the betterment of the facility and the patients as well.

How the project would differ or improve on what is being done.

Upon successful completion of the project, the assisted living facility will switch from manual communication system to the automated system. This would significantly improve the quality of healthcare services, which had been undermined by the issue of delays. This way, the project will have reduced cases of deaths and even project failures that are caused by delayed services.

References

Shah, J. H., & Patel, A. D. (2018). Ambient assisted living system: The scope of research and development. In International Conference on EECCMC, manuscript accepted. Retrived from https://www.academia.edu/download/60128194/AALSystems20190726-111056-mik6oz

Thanh, T. T. B., & Au, T. T. A. (2017, October). Application of home automation system for assisted living services in home healthcare. In 2017 International Conference on Advanced Technologies for Communications (ATC) (pp. 150-155). IEEE. Retrived from https://ieeexplore.ieee.org/abstract/document/8167606/

Final Project Report
——————–
Requirement: Final Project Report and Power Point presentation of the project
Subject: BIT595-03438 Professional Consulting In Information System(IS)
1. Draft approved project plan is attached with name “ASSISTED LIVING AUTOMATION SOLUTION”
file name: “AssistedLivingAutomation-Website-DetailDesign x”.
I also included draft EntityRelationship diagram with basic data modeling.
3. I am also attaching former student approved project “Sample-Approved-Project ” from same univerisity.
The updated “Final Project Report” must include following the “Sample-Approved-Project ” and follow the “ProjectFinalReport-Details.txt”
1. Use Case Diagram (13 to 16)
2. Use Case Details (page 17 to 19)
3. Data Flow Diagram (page 19 to 22)
4. Data Modeling with column name, PK, FK, data type and size (page 26 to 29))
5. Entity Relationship diagram (page 30)
6. HTML wireframe/screen shots (page 34 to 37)
4. Power Point presentation of the project.
16 slide without title/references using “Final Project Report”.
Copy paste important things from “Final Project Report”.

4. The :”Final Project Report” must follow University guideline attached “FormatGuidelines “.

The Project Report (see guideline in attached FormatGuidelines )
————————————————————————–
While the plan described what you were going to do, the report tells what you have completed.
You will build upon the written plan. All reports should include the following sections:
1. Executive Summary
a. A concise summary or the important points of the report (one page maximum).
Write this last.
2. Introduction
a. Brief overview of the report
3. Statement of problem or question you identified
a. Restatement of the problem you identified and addressed in the project proposal.
b. Is it the same problem described in your plan? If not, why not? How and why did it
change? Did your committee approve the change?
i. Repeat what you discovered in your literature search describing how the problem
is typically addressed and add any new material you discovered about this
problem.
ii. What solutions or techniques are being used?
iii. What technology is current and is it effective?
4. Objectives (Goals, purpose)
a. Present the project objectives. Very specifically discuss the outcomes expected.
b. What are the deliverables?
5. Results and Conclusions
a. Describe what you did to achieve your objectives. In your plan, you indicated what
activities you planned, what actions you intended to undertake to complete the
project, and your project plan. Now in this section you describe how this actually
worked. What you actually did and how you did it.
b. Cite any references you used to help with the project solution.
c. Did you achieve your objective?
d. Do you create all the anticipated deliverables, if not why?
e. What did you learn? Document any lessons learned.
f. What do you see for future or additional work?
6. Submit the final version of your written report to your professor at least one week prior
to the date on which you wish to make your formal presentation. You will not be given a
presentation date until you and the course professor agree that the written report is
complete.
Presentation (see Presentation Guide document)
You are expected to make a formal presentation of your project at its completion. Students and
faculty will be invited to all presentations.
If the project presentation contains proprietary information and you intend to require your
committee and any audience present to sign a non-disclosure agreement you must inform the
committee in advance so they can determine the best course of action.

FORMATGUIDELINES FOR MSIS PAPERS AND FINAL PROJECT

General Guidelines

All papers written for any MSIS course will follow these guidelines (see the Specific

Formatting Features section for more detail).

• double spaced

• no paragraph or page border

• no extra space before or after each line or between paragraphs, extra space can be left

before or after a table/figure/chart (see paragraph menu for options, by default MS Word

adds extra space after a paragraph, ensure you set that to 0 before and 0 after)

• all text should be in black, no special colors

• headers/footers maybe used in course papers except for the final paper in BIT 595

• Times New Roman or Arial are acceptable fonts and 12pt

• tables/charts/graphs should be single spaced and can be presented landscape and in

smaller point size

• all tables/charts/graphs must have a caption, placed after the discussion, and listed in the

appropriate List of Figures, Tables, or Charts.

o use the caption feature

o change the color of the font to black and the size to the same in the document

• use hard return (ctrl enter) to create a page break, do not use several returns to move text

to new page

• Table of Contents/List of Figure/List of Charts should be in the same font and size as the

rest of the document, no color, no italics, with numbers right aligned (create a right dot

leader tab at the right margin)

The components of the final project/thesis includes:

• Title page

• Copyright page (or blank page)

• Signature page

• Executive Summary or Abstract

• Acknowledgments (optional)

• Table of Contents

• List of Tables

• List of Figures

• Introduction

• Project Detail (this will vary depending on the type of project completed)

• Results/Discussion

• References Cited

• Appendices (optional)

Each of these components is discussed in full detail in the Thesis and Major Paper Guide

provided on the Graduate school website,. It is highly suggested that you download and print a

copy.

These guidelines will apply to all papers written in each of the classes as well as the final

capstone project. There may be some sections not included for specific class assignments. Be

sure to check with the course professor on what must be included.

http://www.minotstateu.edu/graduate/_documents/theses_guide/thesis_and_major_paper_guide

SPECIFIC FORMATTING FEATURES

Preliminary Material

The formats used for preliminary material (Title Page through List of Figures, or List of

Plates) are illustrated in the example pages provided in Appendix A of the Thesis and Major

Paper Guide. Students should follow these examples carefully in preparing these preliminary

pages.

Margins

The margins on all four sides of every page must be a minimum of 1 inch. Only page

numbers (placed upper right in a header) are placed outside of the margins. The required margins

apply to tables and figures as well as the text, and they apply to all pages, including preliminary

material and appendices.

Page Numbers

All pages of the thesis are counted with the exception of the blank or copyright page that

follows the Title Page. All preliminary pages (all pages prior to the Introduction) should be

numbered with lower case Roman numerals (ii). The only exception is the Title Page, which is

assigned a page number (i.e., counted as page i), but it is not paginated (no page number is

shown). Beginning with Introduction, and continuing through the References and any

appendices, all pages are counted and paginated (with some exceptions) with Arabic numerals

(2, 3). The only page that is not paginated is the page (if present) labeled “Appendices” or

“Appendix”.

Page numbers, whether Roman or Arabic numerals, are placed at the upper-right corner

of the page. They should be located inside the right-hand margin. To set the page number in

Microsoft Word, use Insert/Page Number/Top of Page–Plain Number 3. The page number can

then be formatted as needed (to be either lowercase Roman numerals or Arabic numerals).

Changing the type of page number (Roman numerals to Arabic numerals) or omitting the

page number from a page requires use of a section break within word processing programs. The

places that require a section break are before (transitioning to) the first page of each chapter and

before the page (if included) labeled “Appendices” or “Appendix.” The section break should be

inserted after typing on the preceding page is completed. In Microsoft Word, select… Page

Layout/ Break /Section break – next page. The cursor will move to the top of the next page, and

the section number increases by one. The section break allows the pages of different sections,

including headers and footers, to be formatted differently.

To set the type of page number to be used: Double-click in the header area, to activate the

headers and footers. In the Header and Footer section of the Formatting Palette, select… Format

Page number. In the window that appears, you can choose the format of the page numbers.

Within the preliminary materials section, select the i, ii, iii… format. In the Headings the APA

Manual defines five possible levels of headings. However, in most reports or projects, all five

levels will not be needed. Headings help readers navigate the report or project; but using too

many levels can be more intrusive than helpful. The five levels of headings set forth in the APA

Manual are formatted as follows:

Level 1 centered, boldface, uppercase and lowercase (capitalized) heading.

Level 2 flush left, boldface, uppercase and lowercase (capitalized) heading.

Level 3 indented, boldface, lowercase (only first word capitalized) paragraph heading,

ends with a period.

Level 4 indented, boldface, italicized, lowercase (only first word capitalized) paragraph

heading,

ends with a period.

Level 5 indented, italicized, lowercase (only first word capitalized) paragraph heading,

ends with a period.

These heading formats outlined in the APA Manual 6th edition differ from those outlined

in the 5th edition. In a report or project, the highest level heading is used to title the chapter. Both

the chapter number (e.g., Chapter 1) and the title of the chapter (e.g., Introduction) are

considered to be part of the same heading, even though they are typed on separate lines, double-

spaced.

Typeface and Spacing

The MSIS Faculty prefers Times New Roman or Arial. Acceptable font sizes are 10 pt

and 12 pt. For Times New Roman and Arial, 12 pt text works best; 10-pt text is rather small, and

more difficult to read. The same typeface must be used throughout the report or project, with the

exceptions of lettering that is part of the body of a figure and material in appendices, for which a

different typeface may be used. One additional exception to the font size requirement relates to

table notes, which may be a smaller font (e.g., 10-pt Times New Roman).

Text should be written using left justification (i.e., text aligned with left margin, except

when indented). Full justification, which spreads the text to align with both the left and right

margins, should not be used.

The MSIS Faculty prefers double spacing throughout the document. However,

appropriate use of larger line spacing (triple or quadruple) in some places can improve the

readability of the reports or projects. Triple line spacing (two blank lines) is required above

and/or below tables that appear on a page with normal text, to more clearly offset them from the

text. Larger line spacing (triple spacing should suffice) may also precede headings, particularly

higher-level headings. Consistency in spacing is the key.

In Text Citation and Reference Page

The MSIS Faculty has agreed on a modified APA format. Each reference should be listed in

alphabetical order, according to proper APA format, on the reference page and numbered. The

carry over line will be indented such that it aligns with the first line. Examples follow:

1. Baker, E. J. (2011). Household preparedness for the Aftermath of Hurricanes in

Florida, Applied Geography, 31, 46-52.

2. Carleton, R. N., Collimore, K. C., & Asmundson, J. G. J. (2010). It’s not just the

judgements—It’s that I don’t know: Intolerance of uncertainty as a predictor of social

anxiety, Journal of Anxiety Disorders, 24, 189–195.

The number will be used as the in text citation and the number enclosed in brackets [1]. The

numbers will not be in numerical order in your document, rather will refer to the listing on the

reference page. For example:

Baker [1] found that preparedness was strongly related to factors like income level, home

ownership, race, age, and type of housing.

Intranet System

A Project Submitted in Partial Fulfillment for the Requirements in

Degree of Masters in Information Systems

Rohitkumar Trivedi

Department of Business Information Technology

College of Business

Minot State University

Minot, ND

Spring 2017

iii

Approval
This Project is Submitted by

Rohitkumar Trivedi

Graudate Committee

__________________________________________________________________
Dr. Lori Willoughby, Committee

Date of Defense: April 13, 2017

Abstract
Many larger companies have offices located around the world. This can create challenges for

employees to stay connected with each other. A common platform is needed for the companies to share

news, department updates, and other vital information. An intranet system enables companies to have a

common platform where employees can stay connected even though they are in different places. Global

TPA is a large company and needs a common platform such as the intranet system. This system was

developed using web-based application and is monitored and maintained regularly. This system has many

benefits and makes it easier for the employees to stay connected, especially because it is easy to use by

everyone. Even though the outcome was positive from this system, there are many potential areas in the

system that can be furthered. This system is a rudimentary step for bigger companies and more research

would help companies communicate easily and efficiently.

Acknowledgement
This project was implemented successfully with the help of many. Some of the people who

helped me through this project were the project manager, Vice-President, and President of the Global

TPA, Freedom healthcare. With the support of my team members, and testers we were able to deliver the

project on time and with limited budget. Also, I was able to apply the ideas and knowledge presented in

books regarding ASP .Net. I am grateful for the help from Dr. Lori Willoughby and her feedback for my

thesis. Lastly, I am thankful for my family’s help and support throughout the process of this thesis. My

wife and children have helped me immensely with their inputs and feedback on the thesis.

Table of Contents
INTRODUCTION …………………………………………………………………………………………………………….1

METHODOLOGY ………………………………………………………………………………………………………………………..

PROJECT CONCEPTION AND INITIATION …………………………………………………………………….3

PLANNING ………………………………………………………………………………………………………………………………..

REQUIREMENT GATHERING AND ANALYSIS………………………………………………………………………………….

Compliance Department …………………………………………………………………………………………………………

Enrollment Department ………………………………………………………………………………………………………….

Information Technology Department ……………………………………………………………………………………….

Information System Department ………………………………………………………………………………………………

Human Resource Department ………………………………………………………………………………………………..

Important Web Sites ……………………………………………………………………………………………………………..

Nonfunctional Requirement …………………………………………………………………………………………………..

Supervisor Role …………………………………………………………………………………………………………………… 12
User Role ……………………………………………………………………………………………………………………………

USE CASE …………………………………………………………………………………………………………………….. 13
…………………………………………………………………………………………………………………………………….. 13
USE CASE ……………………………………………………………………………………………………………………..

5.0 DATA FLOW DIAGRAM …………………………………………………………………………………………..

5.1 DATA FLOW FIGURE 1 …………………………………………………………………………………………….

5.2 DATA FLOW FIGURE 2 …………………………………………………………………………………………….

5.3 DATA FLOW FIGURE 3 …………………………………………………………………………………………….

5.4 DATA FLOW FIGURE 4 …………………………………………………………………………………………….

SECURITY ……………………………………………………………………………………………………………………………….

WEB SERVER ………………………………………………………………………………………………………………………….. 24
DATABASE SERVER …………………………………………………………………………………………………………………. 24
PROJECT MANAGEMENT …………………………………………………………………………………………………………..

DATA MODELING …………………………………………………………………………………………………………………….

Master Tables …………………………………………………………………………………………………………………….. 26
Transaction Tables ………………………………………………………………………………………………………………

ARCHITECTURE DIAGRAM …………………………………………………………………………………………

…………………………………………………………………………………………………………………………………….. 31
DEVELOPMENT ……………………………………………………………………………………………………………

TESTING ………………………………………………………………………………………………………………………

IMPLEMENTATION……………………………………………………………………………………………………… 38
PRODUCTION SUPPORT ………………………………………………………………………………………………

CONCLUSION ………………………………………………………………………………………………………………. 39
FUTURE ENHANCEMENT …………………………………………………………………………………………….

REFERENCES ……………………………………………………………………………………………………………….

vii

List of Figures
Figure 1 SDLC Diagram ……………………………………………………………………………………………………4
Figure 2

Use Case

Diagrams…………………………………………………………………………………………….13
Figure 3 Data Flow Diagram ……………………………………………………………………………………………19
Figure 4 Entity Relationship Diagram ……………………………………………………………………………….30
Figure 5 Asp.NET MVC

Architecture Diagram

………………………………………………………………….31
Figure 6 Intranet Visual Studio 2013 Solution Screen …………………………………………………………33
Figure 7 Intranet System Home Page ………………………………………………………………………………..34
Figure 8 Intranet System Compliance Department Page ……………………………………………………..

Figure 9 Intranet System Enrollment Department Page ……………………………………………………….35
Figure 10 Intranet System IT Department Page ………………………………………………………………….35
Figure 11 Intranet System IS Department Page …………………………………………………………………..36
Figure 12 Intranet System Human Resource Page ………………………………………………………………36
Figure 13 Intranet Portal Management Page ………………………………………………………………………37

viii

List of Tables
Table 1 Planning Step ……………………………………………………………………………………………………….5
Table 2 User Case …………………………………………………………………………………………………………..22
Table 3 Data Modeling ……………………………………………………………………………………………………31
Table 4 Advantages of Intranet system ……………………………………………………………………………..40

Introduction

Global TPA offers healthcare insurance through Freedom Health, Optimum care and

Americas1st choice company. Freedom Healthcare Company offers Medicare and Medicaid

health care insurance. The company has multiple locations: the corporate office, HR office, and

customer service/ call centers in India. All departments are in different locations.

Many organizations need a common platform where everybody can access information,

share information, and/or get required information. Intranet system can be used as a common

platform. Simply defined, an intranet system is a secure website that contains private information

intended for a specific audience of organization. The Intranet system is the best platform,

because without login they can access all forms, document, power point presentation, videos, and

applications of government site. This system shows all departments company holiday’s list,

Special offers, Frequently Asked Question (FAQ), compliance, policy and procedure, training,

forms, news, products and important external website links. Because employees for Freedom

Healthcare are in different places, the Intranet will provide a facility to see and get information.

Employees can download forms, important document, event information, and videos.

Statement of the Problem

Global TPA is a very fast growing company with offices in many different locations. They don’t

have a common system for employees to access and share information about the company,

Medicare, Medicaid, compliance, policy and procedure and training. Instead, employees must

contact other departments and/or coworkers for such information. This becomes an issue as it

takes away from employee productivity. The intranet system will help the company and its

employees operate more efficiently.

Literature Review

Literature review is a combination of synthesis and summaries of information from

different sources that is associated with this topic. These sources can vary anywhere from books,

articles, journals, blogs, other web-pages, and e-books. Many of these sources had the same

problem, which was the lack of a common platform for larger companies. One solution that was

common in these sources was the use of an internal system for companies. There are some

existing systems that allow for internal communication and sharing. Systems such as SharePoint

and Biz talk server are often used by companies, however, these intranet solutions are costly and

require skilled developers.

Project geeks source shows a project that uses Java for intranet system. In this project,

employees were able to privately communicate with each other without the internet connection.

Many employees often use other outside server such as g-talk, yahoo messenger, however, with

intranet system, employees can communicate with each other using a common platform. This

also allows companies to have a professional environment when using intra-communication

outlets. The system was accessed using a unique IP address and the same idea would be

incorporated in the intranet system used by Global TPA.

One of the problems with existing system is that sending documents to one department

from another can be time-consuming. Employees have to manually send documentation and

having an intranet system would allow for secure sharing. This problem in existing system is

taken into account and would be incorporated in the intranet system for Global TPA.

Objective

The main goal and objective was to develop an Intranet system to help Global TPA

employees. The employees can share and access the company’s information and other crucial

information while being able to connect to all other departments through the intranet portal. This

allowed them to work more efficiently through a single source application.

Methodology

Deciding on the correct methodology is important for the project to be successfully completed on

time. This decision depends on the company’s policy, budget, culture, team member knowledge,

and comfort level. Waterfall is a standard methodology to implement software projects and it is

easy to use by all team members. A technical feasibility study and an economic feasibility study

are also essential, and the company used the .Net MVC technology for this project. The company

did not have .Net MVC expert developer member in the team, however, the team learned quickly

and adjusted readily. The Intranet portal was very inexpensive when compared to other

readymade software available on the market, especially since the company is using their own

internal resources. This type of application system’s development life cycle (SDLC, Figure 1) is

divided into 8 steps. The project scope is limited to the five departments and eight functions of

the organization. This portal can be accessed by company employees using company’s network

anywhere at any time and also from different locations using the company’s VPN.

Project Conception and Initiation

The project is examined carefully to determine the costs and benefits in order to predict the

project’s duration. In this stage, the feasibility of the project is determined through discussion

with different department stakeholders. Once stakeholders agree with the terms of the project, a

project charter, outlining the purpose and requirements, of the project is created. This step does

not focus on technical requirements.

Figure 1 Software

Development

Life Cycle (SDLC) Diagram

Planning

The planning phase is essential for a successful project. For this project planning, the S.M.A.R.T.

(Specific, Measurable, Attainable, Realistic, and Timely) method is utilized. During this phase,

cost, quality, resources, and time are defined along with the baseline and performance measures.

These performance measures are created using scope, schedule, and cost of a project. This step

would also be used to determine the type of hardware, software, and HR needed for this project.

Also, the type of architecture, technology, and database is decided in this step (Table 1).

Manpower

Software

Architecture

Database

Hardware

Planning

Requirement

Analysis

Design

Coding

Testing

Project
Manager
(500 hrs)

Business
Analyst
(120
hours)

Developer
2 (450
hours)

SQL
Developer
1 (80
hours)

Tester 1
(100 hrs)

Window 2012
server
(Development,
QA, UAT and
Production)
IIS server 7
(Development,
QA, UAT and
Production)
SQL server
2012
(Development,
QA, UAT and
Production)
Team
Foundation
2013
Visual Studio
2013

MVC 4 (Model
View Controller)
Languages,
Tools and
Technology
C#, Razor, CSS,
Java Script,
JQuery, JSON,
Generic, LINQ,
WCF, Entity
Framework,
.NET
Framework 4.5
and Design
Pattern

SQL2012
(Intranet_Dev,
Intranet_QA,
Intranet_UAT,
Intranet)

Web Server

IIS 7

Dell PowerEdge R230 Server,
Hard Drive 3.5” 2TB
Enterprise SAS 7.2K HDDs
Base PowerEdge R230 Server
Processor Intel® Xeon® E3-
1240 v5 3.5GHz, 8M
cache, 4C/8T, turbo (80W)
Operating System Windows
Server® 2012R2
Memory 32GB UDIMM,
2133MT/s, ECC
Drive Bays 4 x 3.5” hot
swappable
Slots 2 x PCIe 3.0 slots
RAID Controller H730
Communications 2 x 1GbE
LOM
Power 250W cabled PSU
Device Access 5 USB 2Rear
2Front 1Internal
Dimensions 19.5” x 1.68” x
18.99”

Table 1 Planning step

Requirement Gathering and Analysis

In this step, the business analyst gathers the requirements from business users. A business analyst

must set up meetings with the business owner and asks the universal questions: when, who, why,

and how. If stake-holders are not available, then telephone conference or a JAD session must be

arranged. The analyst should use a tool case to understand the requirements and then conduct a

gap analysis and reengineering of process, if required. When these requirements are complex,

they must be divided into sections to make it easy to understand. The analyst would then create a

use case to understand the current system and explain the proposed system design. Then the

functional and non-functional requirements must be gathered. Functional requirements include

all business rules and non-functional requirements include access to web server, database server

and security.

All department supervisors, including administrators, can post and remove news from intranet

portal using intranet portal management page. All news has a start date and an end date, with

start dates matching with the current date will show automatic in news and public/private

section. As soon as the end date passes, news would be automatically removed from the news

and public/private section. All department supervisors could post forms, policies, and

procedures. Training documents are kept in a folder that will automatically show on the intranet

portal. To add, update, or remove FAQ from intranet system, the department would submit a

SYS Aid ticket and assign it to the intranet portal admin so admin will inactive using SQL query

and assign back ticket to use with completed and user will verify and close the ticket. Error and

exception handling will be done through a custom error page. Errors will be logged into a table

and stored into error files for further analysis.

Compliance Department

News: This news section is divided into two: public and private. The public news section appears

to all global employees while the private news section is visible to compliance department users

only. This page will show news related compliance for all employees and news for the

compliance department. Department news is only seen by department users, supervisors and

administrators.

Forms: The forms section is divided into two as well, public and private. The section is

accessible to all Global TPA employees. It has CSM, HIPPA and PHI Forms which are available

for all employees and department users. Private section forms are only available to only

compliance department supervisors, users and administrators.

Compliance Policy and Procedure: Compliance policy and procedure PHI and HIPPA regulation

public section access by all employees and private section access by only compliance department

user, supervisor and administrator.

Training: All employee training is available in the compliance Public training section. The

private section of department training cannot see by other users and supervisors; however,

admins are able to see that. Training can include training documents, power point presentations

and videos. Employees take trainings to get certified.

FAQ: The FAQ section is available for all employees and users. All users can search for

questions and/or answers. What is PHI? PHI means protected health information so all crucial

information will not be in the open.

Enrollment Department

News: This page will show news related to Medicare and Medicaid enrollment public section

news all employees can see. Private section news is viewed by administrators, supervisors and

department users.

Form: Public section forms can be accessed and download by all Global TPA employees but

private section forms can only be accessed by enrollment department supervisors, users and

administrators. Member enrollment forms, CMS, Address change request, Medicaid and

Medicare forms will be located here.

Training: Enrollment training documents, power point presentation and videos are available in

public and private sections. All employees can access public training sections to get training and

certification. Private section access is restricted to enrollment department users, supervisors and

admin.

Policy and Procedure: Policy and procedure about enrollment department for who can enroll and

eligibility for Medicare and Medicaid will be found here. Public section can be accessed by all

employees and private section can be access by department users, supervisor

and admin.

FAQ: FAQ is available for all employees and users. All users can search for question and/or

answer for enrollment period and plan benefits. Who is eligible for Medicare? Member must be

citizen, and age above 65 and has Medicare care number.

Information Technology Department

News: This page shows news related to Information Technology department and public news as

well. All employees can see and get knowledge of the IT department outside and inside of

company. How to install application? A PDF document for employees will be available on their

desktop or laptop. It also helps to determine what type of software is used for a specific

department and user. How to request for new application? If the department needs software, then

this portal would be used to request a new application. It will also show the estimated time for

the request to be completed. If the request is anticipated to take longer, then the department can

buy users when they have permission to buy using a license. IT department private news is

viewed by administrators, department supervisors, and department users.

Training: IT department can post documents, power point presentations and videos about IT

training. This includes: Window Operating System, Microsoft Word, Microsoft Excel, Microsoft

Power Point, Microsoft Outlook and Internet Explorer. Public section Training can be accessed

by all employees and private section training only by IT department user, department supervisor

and admin.

Policy and Procedure: Here, the IT department can upload policies and procedures of the

department. The public section, all employees can access and private section, only department

user, department supervisor and admin can access.

FAQ: All users can search for questions and answers about IT. How to get access of software

and tools? An employee has to submit sys aid ticket and supervisor has to approve and after

approval 24 hours, the IT department would install.

Information System Department

News: This page shows both information system related news, how many applications are

available and who can access how you can use all applications. New upcoming releases can be

seen by new app users. The department can share all applications related news to all company

employees and external useful and government links.

The department would not have to remember links and can go on the page directly to use

it. They can share their coding standard and technology using an application. Public section news

all employees can see and private section only IS department and department supervisor and

admin can see.

Training: The department can upload documents and videos for training. Public section

documents, power point presentation and videos can access by all company employees and

private section training can access by department user, department supervisor and admin.

Policy and Procedure: Information System policies and procedures of who can access the

applications can be seen by all on the Public section and private section information can only be

seen by department users, supervisors and admin.

FAQ: All employees can see questions and answers of IS. They can also ask questions on this

page. How to find out version and release date of application? All application showing current

version and last release date in footer.

Human Resource Department

News: This section shows international, national, and local company news for the HR

department. Employees can see their current department and position on this page. Things such

as employee work anniversaries are present on this page. Public section news, all employees can

see and private section only HR department and department supervisor and admin can see and

access.

Forms: The HR department can put forms for all employees into the public section so all

employees can access. Private section forms only department user, department supervisor and

admin can access.

Benefits: All employee can access (Health, Dental, Vision, 401, Health Saving Account and

Life)

a. Employee available health plan

b. Dental plan available for employee

c. Vision plan available for employee

d. 401 plan for employee

e. Health saving account

f. Life insurance plan

Holiday: All employee can access; Current year’s holiday list

Special Offers: All Employees can access, HR can post current offers and upcoming offers on

company’s employee computer, laptop, iPad, phone, auto insurance, and finance.

Training: Public section HR training all employees can access, while private section training

section only HR department user, department supervisor and admin can access.

Policy and Procedure: Public section policy and procedure can access by all employee and

private section policy and procedure only department user, department supervisor and admin can

access.

FAQ: Employees can see HR related FAQ’s and search for question and answers. Where I have

to submit my timesheet? You have to register with our company Payroll system (paycore) and

then go to benefit section and then select timesheet and current time period and hit submit it w ill

show you successfully submitted message.

Important Web Sites

1. Social security

2. CMS

3. Medicare

4. Web MD

Users can access based on their active directory account and based on their role, they can see

information and access functionality. The internet application was very useful for all departments

and employees and will be the most popular application used by employees. It is very user

friendly and employees get information from a single source. One does not need to login for

access and they do not have to remember all departments’ contact and employee information.

One can get training anytime from training links on all department pages and check FAQ’s if

they have any questions. Company’s update is on intranet. The company’s policies and

procedures are available to download and read, and HR can show new offers and benefits to

everyone. Event documents and upcoming event information are also present on intranet. They

can go and see the company holiday list. They can go and find all government import links.

Intranet system has a powerful network of organization employee and can be used for any kind

of announcement within a second. It has very important frequent use government website links

on intranet portal.

Nonfunctional Requirement

Nonfunctional requirement includes: development, test, UAT and production environment setup

and give access to relevant user. A Digester Recovery plan is created to execute every quarterly.

Intranet application performance and load balance testing was performed in testing time.

Recovering of intranet system from back that time, the department had to show maintenance

page so user cannot access the application. When fixing the production issue, the application was

kept in maintenance mode and the department deployed the new code. News, Forms, Policy &

Procedure, Training, FAQ, Benefits, Holiday list and Special Offer sections has collapse and

expandable features default all section are collapsed on click on section heading user can expand.

News, Forms, Policy & Procedure and Training has public and private information but it was not

shown as public or private because it is for admin purpose. Test application from different

geographic location is done to avoid surprise after production.

Administrator Role

Administrator role can access all functions of the intranet and can assign roles to the current

users and new users as well. Administrator is responsible for inactive users. Administrator is

responsible for adding, updating, and removing News, Forms, Training, and Policy and

Procedure section from intranet. To do so, submitting sys aid ticket is required.

Supervisor Role

Supervisor role can have more access on their department page and can see all users. Supervisor

is responsible for the department News, Forms, Training, policy and procedure document, and

FAQ’s.

User Role

User can see their department’s function and other public functions on individual department

page. All users can access News, Training, FAQ, Benefits, Special Offer, current year Holiday

list and all government website.

Use Case

Administrator Role

Figure 2.1 Use Case Diagram

Compliance
Department

Enrollment

Department

HR Department

Information
Department

Information
System Dept.

Intranet portal
management all

department and all
function types

Private & Public
News, Forms,

Training, P&P,

Training &

FAQ

Private & Public
News, Forms,
Training, P&P,

Training & FAQ

Private & Public
News, Forms,
Training, P&P,
Training & FAQ

Private & Public
News, Forms, Training,
P&P, Training, FAQ,

Benefit ,

Offer & Holiday

Supervisor Role (Compliance Department)

Figure 2.2 Use Case Diagram

Compliance
Department
Enrollment
Department
HR Department
Information
Department
Information
System Dept.

Intranet portal
management of

Compliance
Department

Public News,
Forms, Training,
P&P, Training &

FAQ

Public News,
Forms, Training,
P&P, Training &
FAQ

Public News,
Forms, Training,
P&P, Training,
FAQ, Benefit,

Offer & Holiday

Private & Public
News, Forms,
Training, P&P,
Training & FAQ

Public News,
Forms, Training,
P&P, Training &
FAQ

User Role (Compliance Department)

Figure 2.3 Use Case Diagram

Compliance
Department
Enrollment
Department
HR Department
Information
Department
Information
System Dept.
Public News,
Forms, Training,
P&P, Training &
FAQ

Public News,
Forms, Training,
P&P, Training &
FAQ

Public News,
Forms, Training,
P&P, Training &

FAQ

Public News,
Forms, Training,
P&P, Training,
FAQ, Benefit,
Offer & Holiday

Private & Public
News, Forms,
Training, P&P,
Training & FAQ

User Role (Finance Department)

Figure 2.4 Use Case Diagram

Compliance
Department
Enrollment
Department
HR Department
Information
Department
Information
System Dept.
Private & Public
News, Forms,
Training, P&P,

Training & FAQ

Private & Public
News, Forms,

Training, P&P,
Training & FAQ

Private & Public News,
Forms, Training, P&P,

Training, FAQ, Benefit,
Offer & Holiday

Private & Public
News, Forms,
Training, P&P,
Training & FAQ

Use Case
Use Case ID UC-01
User Case Name Access Intranet
Actor Administrator
Description To access Intranet user need valid active directory account of

windows domain server. User Must be added to the Intranet user
table account with administrator role. Administrator has highest
level of access of intranet.

Pre-Condition User must be active
Flow of Event Basic Flow

• Open Internet Explorer
• Check user account with active directory
• Check user account intranet account intranet user table
• Check user role into user table
• Check user account is active
• Take user name, role and department

Post Condition After User account authenticated open intranet portal home page
with user name, department name and role welcome message.
Administrator must be able to access all functionality of the intranet
system.

Use Case ID UC-02
User Case Name Access Intranet
Actor Supervisor (Department Head)
Description To access Intranet user need valid active directory account of

windows domain server. User Must be added to the Intranet user
table account with supervisor role. Supervisor has 2nd highest level
of access of intranet.

Pre-Condition User must be active
Flow of Event Basic Flow

Post Condition After User account authenticated open intranet portal home page
with user name, department name and role welcome message
Supervisor must be able to manage their department and be able to
submit News, Forms, Policy and Producer, FAQ of department.
Also, the supervisor can access another department’s general
functionality.

Use Case ID UC-03

User Case Name Access Intranet
Actor User (Belong to Intranet Department)
Description To access Intranet user need valid active directory account of

windows domain server. User Must be added to the Intranet user
table account with supervisor role. Intranet Department user has 3rd
level of access of intranet system.

Pre-Condition User must be active
Flow of Event Basic Flow
• Open Internet Explorer
• Check user account with active directory
• Check user account intranet account intranet user table
• Check user role into user table
• Check user account is active
• Check user Department
• Take user name, department and role

Post Condition After User account authenticated open intranet portal home page
with user name, department name and role welcome message
Intranet Department user must be able to see all department
information but not able to add News, Forms, Policy and Producer,
FAQ of department and able to access another department’s general
functionality.

Use Case ID UC-04
User Case Name Access Intranet
Actor User (Belong to not Intranet Department)
Description To access Intranet user need valid active directory account of

windows domain server. User Must be added to the Intranet user
table account with supervisor role. Intranet Department user has 4th
level of access of intranet system.

Pre-Condition User must be active
Flow of Event Basic Flow

Post Condition After User account authenticated
open intranet portal home page with user name, department name
and role welcome message
User able see all common functionality of Intranet System

Table 2 User Case
5.0 Data Flow Diagram

5.1 Data Flow Figure 1 Administrator Role

Figure 3.1 Data flow diagram for Administrator Role

5.2 Data Flow Figure 2 Compliance Department Supervisor role

Figure 3.2 Data flow diagram for Compliance Department Supervisor Role

5.3 Data Flow Figure 3 Compliance Department User Role

Figure 3.3 Data Flow Diagram for Compliance Department User Role

5.4 Data Flow Figure 4 Finance Department User Role

Figure 5.4 Data Flow diagram for Finance Department User Role

Department Role

6.0 Design

This section explains Intranet system design and what the software is used for. The Intranet

application is web based application. Visual studio 2013 is used for development team.

Microsoft visual studio is used to design and develop web based, client server, iPad, and Mobile

app. Microsoft Visual studios launches new version every two years. Microsoft visual studio

2013 is the latest version available in the market and it ties up with source safe control. This will

help with version control, task management, bug tracking, and building. It is very user friendly

and has multi-user comprehensive tools.

Visual studio 2013 is used for this project because the company has a license available for it.

Visual studio 2013 allows for C++, C#, VB.NET, F#, WCF, Web service, LINQ, Entity

Framework, Design Pattern and JavaScript, JQuery, JSON, Razor, HTML, XML, XLTS, CSS.

These languages and scripts, CSS (Cascading Style Sheet) are helpful to design a web-page.

The company will use MVC architecture and language C# and Razor for web-page design. Also,

JavaScript, JQuery, and JSON would be used for client side validation. CSS was used for web

page color, font size, style, and alignment. Images were used to make the system interactive and

user-friendly. Visual Studio 2013 had powerful tools to develop any kind of application. It

allowed multiple frameworks, both old and new. The company used framework 4.5 because it

supports all kinds of browser.

MVC 4.0 (Model View and Controller), MVC Model View and controller was used because they

are very tightly bound with each other and the page is light because it has no view state. This

model has all fields and can define required fields validation, minimum, maximum, data type and

regular expression. The View was used for design web-page and is also used with Razor, CSS,

JavaScript, JQuery and JSON for apply style and client side validation. View model showed and

accepted input from users. Controller is tightly bind with view so view sent valid request to

controller using WCF web service and controller will send request to SQL server database and

SQL server send back response to controller and controller will send back to view. Web.Cinfig

file is xml file, it is case-sensitive, and stores SQL server connection information. MVC allowed

shared folders with layout which was used to set application header, footer, and content. Hidden

field is used for temporary data and session to pass information from one page to another.

Security

MVC was used because it is very secure and certified. One can send and receive data using

serialization and deserialization. The department uses passport authentication, and form

authentication with active directory user (LDAP) to access site. Role based access to the intranet

system is allowed, so unauthorized user cannot access the application. The document full-path is

not shown while downloading the document.

Web Server

Intranet system is going to deploy on the IIS 7.0 which is very secure and support HTTP,

HTTPS, SMTP, FTP, FTPS. Intranet system is going https to use SSL certification to make more

secure.

Database Server
Microsoft SQL server database was an excellent RDMS database because it is reliable and

secure. It is a user-friendly database solution. SQL server management studio allows user to T-

SQL statement. SQL 2008 is offering SQL Database, SSIS, SSRS and SSAS tools. It has SQL

profiler so it is very easy to trace store procedure and SQL. The company created an index on

table as and when required. The company used nolock command to all sql select statement to

avoid dead lock and better performance.

SQL server 2008 R2 was used for Intranet system. CRUD operation was used for Intranet

system. The department will create tables, store procedure, functions, and trigger. It also allowed

the company to create ER diagram of system (Figure 4). A store procedure was created and it

allowed group of logical statements into procedure and then was selected, inserted, updated

and/or deleted through store procedure. In the Intranet system, any record from the table was not

deleted. Soft delete using IsActive flag is used. If IsActive flag had true value then it is active

record, otherwise it is an inactive record. All exception and error would be stored into logger

table with an error message. The department used no Lock with all SQL select statement for

better performance and avoiding locking. Exact parameter data type was used and length was

assigned to sql local variable before any type of operation to avoid SQL injection. All tables had

an identity column as primary and detail table has foreign key to build relation and avoid

inconsistence data. The company did not use a unique, check, not null constrain for required

column. A default constrain for inset date time was used. Intranet tables are normalized so

developer had to use join to pull data but performance will be the best.

Project Management

For this, agile methodology was used to develop Intranet system. Daily scrum call was set-up to

get status of development of Intranet system. The project was closely monitored to ensure

delivery on time. Impact on deliverable was also determined according to the progress of the

project. If someone finished a task early, then they would be asked to help with other things to

meet deadline earlier. If anybody was facing any kind of challenges, then they discussed it in

meetings. JIRA project management tool was used to track all project activity.

Data Modeling

Master Tables

DepartmentTbl
Column Name Data Type and Size Allow Null
DeptID Int PK No
DeaprtmentName Varchar(25) No
IsActive Bit No
InsertedBy Int No
InserrtDateTime DateTime Current DateTime
UpdatedBy Int Yes
UpdateDateTime DateTime Yes

Table 3.1 Data Modeling- DepartmentTb1
RoleTbl
Column Name Data Type and Size Allow Null
RoleID Int PK No
RoleName Varchar(25) No
IsActive Bit No
InsertedBy Int No
InsertDateTime DateTime Current DateTime
UpdatedBy Int Yes
UpdateDateTime DateTime Yes
Table 3.2 Data Modeling- RoleTb1
UserTbl
Column Name Data Type and Size Allow Null
UserID Int Identity (PK) No
FirstName Varchar(25) No
LastName Varchar(25) No
Email Varchar(100) No
DeptID Int (FK) No
RoleID Int (FK) No
Phone Varchar(10) No
DOB DateTime No
JoiningDate DateTime No
Designation Varchar(25) No
IsActive Bit No
InsertedBy Int Current DateTime
InsertDateTime DateTime No

UpdatedBy Int Yes
UpdateDateTime DateTime Yes

Table 3.3 Data Modeling- UserTb1

Transaction Tables

NewsTbl
Column Name Data Type and Size Allow Null
NewsID Int PK No
DeptID Int FK No
NewsHeading Varchar(max) No
News Varchar(max) No
NewsType Varhcar(1) No
StartDate DateTime No
EndDate DateTime No
IsActive Bit No
InsertedBy Int No
InsertDateTime DateTime Current Date Time
Updated By Int Yes
UpdateDateTime DateTime Yes
Table 3.4 Data Modeling- News Tb1
FromsTbl
Column Name Data Type and Size Allow Null
FormID Int PK No
DeptID Int FK No
FormName Varchar(255) No
FormType Varchar(1) No
StartDate DateTime No
EndDate DateTime No
IsActive Bit No
InsertedBy Int No
InsertDateTime DateTime Current DateTime
UpdatedBy Int Yes
UpdateDateTime DateTime Yes
Table 3.5 Data Modeling- FormsTb1
TrainingTbl
Column Name Data Type and Size Allow Null
TrainingID Int PK No
DeptID Int FK No
TrainingName Varchar(255) No
Traing Varchar(max) No
TrainingPath Varchar(255) No
TrainingType Varchar(1) No

IsActive Bit No
InsertedBy Int No
InsertDateTime DateTime Current DateTime
UpdatedBy Int Yes
UpdateDateTime DateTime Yes
Table 3.6 Data Modeling- TrainingTb1
PandPTbl
Column Name Data Type and Size Allow Null
PandPID Int PK No
DeptID Int FK No
PandPName Varchar(max) No
PandDescription Varchar(max) No
PandPType Varchar(1) No
StartDate DateTime No
EndDate DateTime No
IsActive Bit No
InsertedBy Int No
InsertDateTime DateTime Current DateTime
UpdatedBy Int Yes
UpdateDateTime DateTime Yes
Table 3.7 Data Modeling- PandPTb1
FAQTbl
Column Name Data Type and Size Allow Null
FAQID Int PK No
DeptID Int FK No
Question Varchar(max) No
Answer Varchar(max) No
StartDate DateTime No
EndDate DateTime No
IsActive Bit No
InsertedBy Int No
InsertDateTime DateTime Current DateTime
UpdatedBy Int Yes
UpdateDateTime DateTime Yes
Table 3.8 Data Modeling- FAQTb1
BenefitTbl
Column Name Data Type and Size Allow Null
BenefitID Int PK No
BenefitName Varchar(max) No
StartDate DateTime
EndDate DateTime
IsActive Bit No
InsertedBy Int No
InsertDateTime DateTime Current DateTime

UpdatedBy Int Yes
UpdateDateTime DateTime Yes
Table 3.9 Data Modeling- BenefitTb1
HolidayTbl
Column Name Data Type and Size Allow Null
HolidayID Int PK No
HolidayName Varchar(max) No
StartDate DateTime
EndDate DateTime
IsActive Bit No
InsertedBy Int No
InsertDateTime DateTime Current DateTime
UpdatedBy Int Yes
UpdateDateTime DateTime Yes
Table 3.10 Data Modeling- HolidayTb1
OfferTbl
Column Name Data Type and Size Allow Null
OfferID Int PK No
OfferName Varchar(max) No
StartDate DateTime
EndDate DateTime
IsActive Bit No
InsertedBy Int No
InsertDateTime DateTime Current DateTime
UpdatedBy Int Yes
UpdateDateTime DateTime Yes
Table 3.11 Data Modeling- OfferTb1
LoggerTbl
Column Name Data Type and Size Allow Null
LoggerID Int PK No
Logger Varchar(max) No
DeptID Int No
SectionName Varchar(100) No
IsActive Bit No
InsertedBy Int No
InsertDateTime DateTime Current DateTime
UpdatedBy Int Yes
UpdateDateTime DateTime Yes
Table 3.12 Data Modeling- Logger Tb1

7.0 Entity Relationship(ER) Diagram

Figure 4 Entity Relationship(ER) Diagram

Architecture Diagram

SQL Server

Database
Intranet

Model View

Controller

Router

IIS7 Web Server

Firewall

Browser

Figure 5 Asp.NET MVX Architecture Diagram

Development

Development stage was very crucial for project because the project is dependent on the

development team. Development time developers faced many unexpected changes because of

technology. MVC was a new technology for the team and the team had never worked on MVC.

MVC is not event based development so all developer had to re-learn and start development.

MVC was very structured and light weight because it did not have view state.

Developers started the design, and developed Intranet application using Visual Studio 2013 and

TFS 2013 as source and version control. They used MVC 4 C#, as language, Razor, WCF,

Generics, LINQ Cascading Style sheet (CSS), JQuery, JSON and AJAX, SQL 2008 Database.

They used coding standard Pascal case for class name, method name, function name, and camel

case for variable and parameters. Common functions create public class so other developer and

module can access it. They are responsible for create store procedure to retrieve data from

database. Inline SQL statements are not allowed for security. They have to catch exception and

store into logger table and error file so easy read and understand error. They should not allow

unauthorized and unauthentic access to the application. After completing, the development team

lead reviewed the code and checked whether developers had followed coding standard and

comments. Developers did a unit test and recorded the result into file. As soon as development

completed successfully deployed the code and database, they sent it into test environment for

testing.

Intranet Visual Studio 2013 Solution (MVC)

Figure 5 Intranet Visual Studio 2013 Solution Screen

Home Page

Figure 7 Intranet System Home Page Diagram
Compliance Page

Figure 8 Intranet System Compliance Department Page

Enrollment

Figure 9 Intranet System Enrollment Department Page
IT

Figure 10 Intranet System IT Department Page

Figure 11 Intranet System IS Department Page

Figure 12 Intranet System HR Department Page

Administrator/Supervisor

Figure 13 Intranet Portal Management Page

Testing

Testing phase is a crucial phase in system development life cycle. After development is

complete, then this stage will start. Developers would do Unit Testing development time, so

users will not get basic bugs and issues.

Based on requirements of Intranet system, the design tester wrote the test. They used manual

testing for Intranet system. They executed all test cases scenarios for functional, positive,

negative, security, performance, and load.

Testing team had to open defect, if the system was not working as design. Based on the defect,

they have to select a bug category and have to assign it to the developer. Tester had to mention

steps to generate defect and attach screen shots to the defect. Developer had to fix the bug and

send it back to the tester with developer comment. Tester had to do regression test for the entire

function. If it was working according to requirement and design, then they had to close defect

with comment and change status to verified and close it.

After successful testing, the department deployed the code and system into UAT so business

people can test and verify. If there was any kind of suggestion from users or change requests

from users, then the developers deployed it in testing for test. If change request is big, then

developers will do analysis to keep in mind for future release. Developers will get to sign off

from UAT and deploy code and database into production.

Implementation

Visual studio and Team Foundation server was used because it will help us share code and

manage code version. History of code of who is changing code on date and time and user

information can be seen. For implementation, the company set up a development environment,

test environment, UAT environment, and production environment.

As soon as the development is completed, the company deployed it in the test environment. Once

the sign-off from QA team is received, the department deployed the code and database into UAT

environment. After successfully sign-off from UAT, the department will deploy code and

database into production environment. Copy all code from UAT virtual directory server and pate

into production server virtual directory and copy SQL Intranet_UAT database to SQL production

server Intranet. Change the connection string into web.config UAT to Production. Test and

verify intranet production URL if it is not working check logger table and log. File fixes issue.

After successfully deployment into production, an email is sent to user and there will be new

URL information so they can use new Intranet system.

Production Support

If user finds any kind of issue, then they can submit a Sys Aid Ticket. This will be used by the

support team to fix the issue. If it is shore-stopper issue, then they will fix it immediately and

deploy into production. If it is not shore stopper issue, then they will fix it and deploy after

office-hours. If it is a new requirement or change request then QA and UAT sign off is required

before it is deployed into production.

Conclusion

Intranet application would be a common platform for all Global TPA employees. Employees can

access this application and take advantage of it. It has lots of useful features and functions in

order to get and share information. It also has important government website link and will take

employees directly to government site so all employee can go access more information about

SSN, Medicare and CMS.

Future Enhancement

Intranet includes only five department and a few functions of department. In phase two, there

would be more departments like finance, sale and marketing, MRA, provider relation and claim

department so all employees can share information about their department and function. A light

weight mobile app for smart phone user would also be the next step.

Table 4 Advantages of Intranet System

Advantages

Share information
Easy to use

Easy to access
Easy to share knowledge between

department
Single access point

See vacation schedule of department
Share benefits

Post company requirement
Share special offer

Share company news

Annoounce for a department
Share event information

Secure
Encrypted access to highly available

information
Secure communication between employee

Increases Employee Productivity
Allows for Greater Collaboration

Simplifies decision making
Provides employees a networking platform

Streamlines Data Management

References

Ben-Gan, I. (2012). Microsoft SQL Server 2012 T-SQL fundamentals. Redmond, Wash:
Microsoft Press.
Better information. Better health. (n.d.). Retrieved April 12, 2017, from http://www.webmd.com/
Freeman, A. (2012). Pro ASP.NET MVC 4; Fourth Edition. Apress.
Home. (2017, March 14). Retrieved April 12, 2017, from https://www.cms.gov/
Medicare.gov. (n.d.). Retrieved April 12, 2017, from https://www.medicare.gov/
Morris, R. A. (2008). The everything project management book: tackle any project with
confidence and get it done on time. Avon, MA: Adams Media
P. (2014, July 12). Intranet Mailing System project in Java. Retrieved April 14, 2017, from
http://projectsgeek.com/2014/07/intranet-mailing-system-project-java.html
Social Security. (n.d.). Retrieved April 12, 2017, from https://www.ssa.gov/
(n.d.). Retrieved April 12, 2017, from http://ww2.galaxyeduplanet.com/?folio=7POYGN0G2
(n.d.). Retrieved April 12, 2017, from https://www.microsoft.com/en-us/cloud-platform/biztalk
(n.d.). Retrieved April 12, 2017, from https://msdn.microsoft.com/en-
us/library/dd831853(v=vs.120).aspx
R. (n.d.). ASP.NET MVC 4. Retrieved April 12, 2017, from https://docs.microsoft.com/en-
us/aspnet/mvc/mvc4
SharePoint: Empowering teamwork. (n.d.). Retrieved April 12, 2017, from
https://products.office.com/en-US/sharepoint?legRedir=true&CorrelationId=81009a4e-
5303-417e-b8c5-cf759441aa3e
Siddiqui, Z. (2013, October 21). The Pros and Cons of Intranets. Retrieved April 12, 2017, from
https://www.techopedia.com/2/29572/networks/the-pros-and-cons-of-intranet

http://www.webmd.com/

https://www.cms.gov/

https://www.medicare.gov/

http://ww2.galaxyeduplanet.com/?folio=7POYGN0G2

https://www.microsoft.com/en-us/cloud-platform/biztalk

https://msdn.microsoft.com/en-us/library/dd831853(v=vs.120).aspx

https://docs.microsoft.com/en-

https://products.office.com/en-US/sharepoint?legRedir=true&CorrelationId=81009a4e-

https://www.techopedia.com/2/29572/networks/the-pros-and-cons-of-intranet

Use Case
Use Case
Security
Web Server
Database Server
Project Management
Data Modeling
Master Tables
Transaction Tables

Architecture Diagram
Development
Testing
Implementation
Production Support
Conclusion
Future Enhancement
References

What Will You Get?

We provide professional writing services to help you score straight A’s by submitting custom written assignments that mirror your guidelines.

Premium Quality

Get result-oriented writing and never worry about grades anymore. We follow the highest quality standards to make sure that you get perfect assignments.

Experienced Writers

Our writers have experience in dealing with papers of every educational level. You can surely rely on the expertise of our qualified professionals.

On-Time Delivery

Your deadline is our threshold for success and we take it very seriously. We make sure you receive your papers before your predefined time.

24/7 Customer Support

Someone from our customer support team is always here to respond to your questions. So, hit us up if you have got any ambiguity or concern.

Complete Confidentiality

Sit back and relax while we help you out with writing your papers. We have an ultimate policy for keeping your personal and order-related details a secret.

Authentic Sources

We assure you that your document will be thoroughly checked for plagiarism and grammatical errors as we use highly authentic and licit sources.

Moneyback Guarantee

Still reluctant about placing an order? Our 100% Moneyback Guarantee backs you up on rare occasions where you aren’t satisfied with the writing.

Order Tracking

You don’t have to wait for an update for hours; you can track the progress of your order any time you want. We share the status after each step.

Order Now Talk to Us

Areas of Expertise

Although you can leverage our expertise for any writing task, we have a knack for creating flawless papers for the following document types.

Essay

Thesis

Presentation

Dissertation

Term Paper

Research Paper

Book Review

Assignment

Report

Case Study

Letter

Article

Coursework

Speech

Q & A

Critical Thinking

Areas of Expertise

Although you can leverage our expertise for any writing task, we have a knack for creating flawless papers for the following document types.

Essay

Thesis

Presentation

Dissertation

Term Paper

Research Paper

Book Review

Assignment

Report

Case Study

Letter

Article

Coursework

Speech

Q & A

Critical Thinking

Trusted Partner of 9650+ Students for Writing

From brainstorming your paper's outline to perfecting its grammar, we perform every step carefully to make your paper worthy of A grade.

Preferred Writer

Hire your preferred writer anytime. Simply specify if you want your preferred expert to write your paper and we’ll make that happen.

Grammar Check Report

Get an elaborate and authentic grammar check report with your work to have the grammar goodness sealed in your document.

One Page Summary

You can purchase this feature if you want our writers to sum up your paper in the form of a concise and well-articulated summary.

Plagiarism Report

You don’t have to worry about plagiarism anymore. Get a plagiarism report to certify the uniqueness of your work.

Free Features $66FREE

Most Qualified Writer $10FREE
Plagiarism Scan Report $10FREE
Unlimited Revisions $08FREE
Paper Formatting $05FREE
Cover Page $05FREE
Referencing & Bibliography $10FREE
Dedicated User Area $08FREE
24/7 Order Tracking $05FREE
Periodic Email Alerts $05FREE

Our Services

Join us for the best experience while seeking writing assistance in your college life. A good grade is all you need to boost up your academic excellence and we are all about it.

On-time Delivery
24/7 Order Tracking
Access to Authentic Sources

Academic Writing

We create perfect papers according to the guidelines.

Professional Editing

We seamlessly edit out errors from your papers.

Thorough Proofreading

We thoroughly read your final draft to identify errors.

Thorough Proofreading

We thoroughly read your final draft to identify errors.

Delegate Your Challenging Writing Tasks to Experienced Professionals

Work with ultimate peace of mind because we ensure that your academic work is our responsibility and your grades are a top concern for us!

Check Out Our Sample Work

Dedication. Quality. Commitment. Punctuality

It May Not Be Much, but It’s Honest Work!

Here is what we have achieved so far. These numbers are evidence that we go the extra mile to make your college journey successful.

0+

Happy Clients

0+

Words Written This Week

0+

Ongoing Orders

0%

Customer Satisfaction Rate

Process as Fine as Brewed Coffee

We have the most intuitive and minimalistic process so that you can easily place an order. Just follow a few steps to unlock success.

Call Us +1 (877) 657-8180 Discuss Order Details Now

See How We Helped 9000+ Students Achieve Success

We Analyze Your Problem and Offer Customized Writing

We understand your guidelines first before delivering any writing service. You can discuss your writing needs and we will have them evaluated by our dedicated team.

Clear elicitation of your requirements.
Customized writing as per your needs.

We Mirror Your Guidelines to Deliver Quality Services

We write your papers in a standardized way. We complete your work in such a way that it turns out to be a perfect description of your guidelines.

Proactive analysis of your writing.
Active communication to understand requirements.

We Handle Your Writing Tasks to Ensure Excellent Grades

We promise you excellent grades and academic excellence that you always longed for. Our writers stay in touch with you via email.

Thorough research and analysis for every order.
Deliverance of reliable writing service to improve your grades.

Place an Order Start Chat Now