project report sample 1

8/12/2019 Project Report Sample 1

1/14

Final Project Report for Media Management System Page i

Final Project Report

for

Media Tracking System

Version 2.0 approved


2/14

Final Project Report for Media Management System Page ii

Table of ontents

1. Final Project Summary.....................................................................................................i ii

2. Future directions............................................................................................................viiThe portable backup media tracking system produced from this project was intended to be a lowcost solution developed by in house staff at the ationwide !hildren"s #ospital. $s long as the

organi%ation maintains staff with the appropriate skill sets& the product can continue to be

updated with new capabilities and features added as needed for automation tasks of this business

process. .............................................................................................................................viiShould the ationwide !hildren"s #ospital re'uire upgrading to a more robust database server

in the future such as (icrosoft S)*& the $ccess 2++, data can be upsi%ed and migrated to the

new database server. Such an upgrade would re'uire an additional investment in hardware& butthe current solution provides a foundation that would make the transition fairly seamless for

administrators. ..................................................................................................................vii

-. $nnotated ibliography................................................................................................vii


3/14

Final Project Report for Media Management System Page iii

Revision !istory

"ame #ate Reason For $anges Version

Kenneth Wright 07/01/2010 Initial Draft 1.0

Kenneth Wright, et al 07/15/2010 With contributions and edits fromall team members, we refined thedocument

1.5

Kenneth Wright, et al 07/2/2010 !t"le, editing, additionalinformation from all team members

1.#

Kenneth Wright, et al 07/0/2010 $inal editing and %roofreading 2.0

%ro&p Members

"ame Role Responsibilities

Kenneth Wright &ro'ect (anager) Infrastructure!(*

+ersee %ro'ect actiities, su%erise solutionintegration into e-isting infrastructure

oe ettinger Database )ardware !(*

Install ) design database, su%erise sererhardware im%lementations

reg obison Interface )*ncr"%tion !(*

uild user interface and ma3erecommendations for secure networ3 traffictransmission


4/14

'. Final Project S&mmary

42 4echnologies is the go to source for small and intermediate sie business loo3ing for

%rogressie and cost effectie I4 solutions.

ecentl" 6ationwide hildren8s os%ital contracted 42 to create a cost effectie mediamanagement s"stem to organie, trac3 and manage their large inentor" of bac3u%ta%es, D/D9D and other media that is stored and their main data center and at theiroffsite storage facilit". 4his s"stem is designed to better manage and trac3 the mediaas well as %roide regulator" com%liance for data safet" in accordance with federalI&&: ;ealth Insurance &ortabilit" and :ccountabilit" :ct< and &I ;&a"ment cardindustr"< laws and guidelines.

'.'. ontent S&mmary

Scope

4his engagement %roides for an electronic database with a standard =I interface toinentor" and trac3 %ortable media. 4he engagement also includes a web interface foroffsite em%lo"ee usage. 4his web interface will hae limited function and onl" be forinentor"ing or trans%ort of media.

Sc$ed&le

4his engagement began on :%ril 2#, 2010 and will continue through :ugust, 2010 withthe im%lementation of the s"stem and first two wee3s of inentor"ing the customer8sta%e inentor".

osts

ardware costs include the & to interface with the database, the scanner and other%eri%heral hardware re>uired at both the customer site as well as the offsite facilit".

:ll additional costs hae been deelo%ment, software and %rogramming time.

Risks

:s outlined in the sco%e document, the ris3s are as follows


5/14

Final Report for Media Management Page ii

Risk Impact Probability Mitigation

The solution wil l be cumbersome and not

adopted quickly or compliance will be

sporadic. High Moderate

Regular reporting and auditi ng from

management wil l ensure compliance after

ini ti al training. Design considerations to

make the system easy to use wil l also aid in

compliance

The tape and other media usage wi ll reduce

to such a level as to make this solut ion

obsolete Low High

The natural progression is to move from

portable medi a for back ups so thi s will be a

natural reduction. However tracking for

the portable media must be maintained

until all media has reached e!piration

"eb based entry #browser incompatibility$ Moderate Low

%rior to implementation we wil l ensure

that all computers that access this system

are at the same level of browser.

Lack of web development e!perience with

our team %otentially high High

"e are planning to use a combination of

int ernal team members as well as outside

resources to assist in the web development

and connection to the database. &n

addition M'access ())* offers the abili ty

to create web pages from forms.

omm&nications Strategy

4he team utilied seeral communication methods to collaborate with each other?including email, instant web meeting technolog", oice calls and oicemail. 4he teamalso used both email as well as (icrosoft +ne6ote to 3ee% notes on meetings, andother conersations.

We utilied regular meetings with both the customer as well as the business %ractitionerto solicit feedbac3 for im%roements and changes.

'.2. (essons (earned

+ur %rimar" lesson learned was to dig dee%er into the actual use of the final %roduct.Who would use it, what would be their wor3flow. :fter careful consideration, wedetermined that the web %ortion of the s"stem should hae been added to a futureenhancement since the em%lo"ees at the offsite storage would not be granted access to6ationwide hildren8s networ3.

: redesign of the screens would hae been unnecessar" for this %ro'ect, had the designteam gone to the customer sites %rior to designing the management screens and donea wor3flow stud". 4his resulted in changes to the %rimar" management interface toallow for easier wor3flow when creating and sending dail" cases of media to the offsitestorage facilit".

'.). (earning *&tcomes S&mmary

4he learning outcomes were met b" a ariet" of wa"s the following is a summar" foreach section and then following the summar" is the detail for each section.


6/14

Final Report for Media Management Page iii

1..1 ommunications outcomes are met through email, Web*- meetings, and%hone calls are documented in the ommunications @og in :%%endi- *.

:dditionall", ideas deelo% into wor3ing com%onents, and the flow of ideas canbe seen in the transition from :%%endi- : to :%%endi- .1..2 ritical 4hin3ing outcomes are seen b" the team8s a%%roach to soling the

management of %ortable media through email communications in theommunications @og and the %ro'ect white %a%ers in :%%endi- *.

1.. 6etwor3 Design outcomes were met as demonstrated through diagramsand with a 9&6 to access the networ3 in section 1.2 of !tatus e%ort 1 in

:%%endi- .

1..A (anagement Information !"stems outcomes are document in emailcommunications in the ommunications @og in :%%endi- * and !ection B of!tatus e%ort 1 in :%%endi- where the business %ractitioner %roided feedbac3to the team.

1..5 !"stems :dministration and !cri%ting are documented throughout !tatuse%ort 1 in :%%endi- . +ne e-am%le of !"stems :dministration is the bac3u%%lan in section 1.2 of !tatus e%ort 1.

1..# !ecurit" is documented and ac3nowledges that ulnerabilities ma" beintroduced when adding a new serer and describes the encr"%tion used for thewireless networ3 in section 7 of !tatus e%ort 1 in :%%endi- and in furtherdetail in 1..# of this section.

1..7 *m%lo"abilit" is documented in section of the 9ision and !co%e in

:%%endi- :. configuration files, diagrams, securit" %lans, etc., that "ou haeincluded in the :%%endices to this document.

'.+. omm&nications

:ll members of the team hae res%onded, contributed, and interacted well with eachother throughout the ca%stone %ro'ect. :ssignments hae been com%leted in a timel"manner with few grammatical errors, using correct terminolog", and in an organiedeas" to read fashion in the correct :&: format. !%ecificall", the wee3l" delierablesdemanded enough wor3 that teammates would hae to >uic3l" diide the wor3,com%lete tas3s, and submit the wor3 bac3 to the grou% for reiew. !ubmitting tas3sbac3 to the grou% gae teammates an o%%ortunit" reiew the wor3 and %roidea%%ro%riate feedbac3.

4he $ran3lin @ie and Web*- meetings were focused on the %ro'ect delierables and%roided o%%ortunities for brainstorming, %lanning, and feedbac3 on submitted tas3s. :ll%artici%ants were %re%ared for the meetings with ideas or >uestions that were %ertinentto the %ro'ect.


7/14

Final Report for Media Management Page iv

During the meetings and through email, there were times that teammates wouldchallenge each other on the direction or selected method for com%leting a %articulartas3. 4hese Cchallenges8 often would %roide uni>ue insight to the %roblem anddemonstrated the s"nthesis and understanding of the to%ic leading to an enhancedsolution to the %roblem at hand.

'.,. ritical T$inking

4he team members did an outstanding 'ob in the anal"sis of the management %roblemwith %ortable media at 6ationwide hildren8s os%ital. 4he team8s a%%roach to solingthe management of %ortable media was based on the following ideals and methods.

uild a %roduct that considers alternatie future uses that is reliable.

om%letel" define the %roblem.

Decide the fastest and most cost effectie wa" to sole the %roblem.

=se the !oftware Deelo%ment @ife "cle using the Waterfall (ethodolog". Deelo% with trouble shooting tools or methods that will aid in trouble shooting

%roblems.

+ne e-am%le of the foreword thin3ing was the suggestion of a team member to addseeral fields to the database that would aid in troubleshooting %roblems. 4he troubleshooting fields added were for date and time stam%s, the user who created the record,and the user who modified the recorded. !ome deelo%ers would not add these fields toconsere dis3 s%ace, reduce deelo%ment time, and to s%eed u% the a%%lication.oweer, the number of tables and the e-%ected sie of the database will not consumetoo man" resources or noticeabl" affect the s%eed of the a%%lication. :dditionall", it is

easier to add the fields during initial deelo%ment than it is to go bac3 and add fieldsafter the %roduct has been released.

'.-. "etork #esign

4his %ro'ect did not re>uire the team to design a networ3 because 6ationwide hildren8sos%ital alread" had an established networ3. 4he %ro'ect inoled one serer to beadded to a networ3 consisting of oer 50 serers and oer a thousand wor3stations.oweer, the 6ationwide hildren8s os%ital networ3 administrator %roided the teamwith an oeriew of the networ3 that described the %h"sical la"out and how the D6!,

D&, and 9&6 were setu%. =sing the oeriew of the networ3, the team reiewedwhat was re>uired to connect to the %ortable media management serer both internall"and e-ternall". 4he following are the networ3ing com%onents that were used andreiewed to ensure the team could access the necessar" resources.

ow to determine if name resolution is wor3ing or not.

4he use of %ing, ar%, and netstat in the command %rom%t for trouble shooting.

emotel" logging into com%uters with the use of emote Des3to% &rotocol

;D&


8/14

Final Report for Media Management Page v

:ccessing networ3 resources using a 9irtual &riate 6etwor3.

(a%%ing networ3 dries.

'./. Management nformation Systems

4he %ortable media management s"stem deelo%ed for 6 will control mediainentor", the %rocess for trac3ing media sent to offsite storage facilities, and I4anal"sts re>uest for restore 'obs. 4he s"stem will trac3 when media is destro"ed andre%orts will identif" the media can be destro"ed according to retention %olicies.

:dditionall" the s"stem is com%liant with I&:: and other %riac" statutes.

4he s"stem will eliminate illegible %a%er logs and s%eed u% %rocessing with a barcodescanner to trac3 the media identification number. 4he loo3 u% %rocess will be muchfaster, a built in >uer" will identif" the location of the media with the media identificationnumber for the last bac3 u% of a serer instead of thumbing through a %a%er log. 4heI&:: com%liant s"stem will aoid inadertent or miss %laced %ortable media,

eliminating or reducing the %ossibilit" for fines associated with I&:: com%lianceiolations.

4he business %ractitioner that adised our team was hel%ful in %ointing out a few errorsin our initial %lans along with good standard %rocedures for database deelo%ment. +nesuggestion was to include the table name or abbreiation into each field name and notto abbreiate the field name if it is not clearl" understood b" a new user. 4he reason forusing this %rocedure is that the database becomes selfdocumenting, which is hel%fulfor new %ersonnel who need to deelo%, modif", or maintain the s"stem.

'.1. Systems dministration and Scripting4he additional s"stems administration and scri%ting associated with the new %ortablebac3u% media trac3ing s"stem at the 6ationwide hildren8s os%ital comes withminimal oerhead. 4he database runs on a la%to% com%uter in :ccess 2007 andDot6et$ramewor3 2.0. 4he com%uter will be 'oined to the domain for securit" andintegration as well as receie regular u%dates from the W!=! serer and a managedantiirus a%%lication. +%erating !"stem and software u%grades will be a%%lied asneeded, ensuring that sufficient testing is done before hand to reduce an" bugs thatcould interru%t serice on the %roduction networ3.

4he wireless hand scanners running (icrosoft Windows * #.0 will be configured toreceie im%ortant o%erating and software u%grades as well. :dditional the" will used ona rotational schedule that ensures that the" will regularl" be returned to administratorsso that regular ins%ections for u%dates and com%atibilit" can be conducted.


9/14

Final Report for Media Management Page vi

'.3. Sec&rity

:n"time a new serer or deice is introduced to a networ3 it re%resents a new %otentialulnerabilit" and access %oint for malicious actiit" if not %ro%erl" safe guarded against

threats. 4he new management s"stem for %ortable bac3u% media that will beim%lemented at the 6ationwide hildren8s os%ital b" 4eam 2 consists of seeralcom%onents that hae been thoroughl" researched to determine the most effectiemethods for establishing a strong securit" %osture. :lthough the s"stem is %rotected b"the e-isting securit" controls on the 6ationwide hildren8s os%ital networ3, itintroduces seeral new features and ca%abilities that warrant additional securit"im%lementations. 4o start, the new serers will hae securit" %atches and softwareu%dates a%%lied in accordance with the 6ationwide hildren8s os%ital current %olicies.

:ntiirus software will be installed and maintained in the same fashion ma3ing the newserers securit" com%liant to the 6ationwide hildren8s os%ital information assurancestandards.

4he new management s"stem for %otable bac3u% media also ma3es use of seeraldifferent web interfaces that will be %rotected using 4rans%ort @a"er !ecurit" ;4@!< anduser authentication b" username and %assword. $irewalls will be configured to onl"allow re>uests for the web interface to be %ermitted from the internal networ3 to hel%%reent its e-%loitabilit" from e-ternal threats. 4he mobile scanners used for the s"stemintroduce a new o%erating s"stem to the networ3, (icrosoft Windows * #.0 that willalso re>uire monitoring for securit" %atches and software u%dates as well. 4he" will be%laced on a rotational use s"stem that will ensure that administrators will hae%rocession of them on a regular basis to 3ee% them current. ommunication betweenthe handheld scanners and the serers will be %rotected with 4@!, and the wireless

traffic from the scanner to the wireless access %oints will be %rotected with W&:2 usingthe :danced *ncr"%tion !tandard ;:*!


10/14

Final Report for Media Management Page vii

2007 is also a robust enough a%%lication that could be used to run custom a databasewith re%ort generating ca%abilities and %roide remote data in%ut through web forms iamulti%le sources. 4he hand scanners with wireless networ3ing ca%abilit" %roide thenecessar" %ortabilit" scan, trac3, indentif" and re%ort %ortable media at multi%lelocations simultaneousl". 4he database and web interfaces were deelo%ed with in

house staff, %roiding future su%%ort for database changes, u%grades or the addition ofnew features or ca%abilities should the need arise.

4he final %ortable bac3u% media trac3ing s"stem %roduced b" this %ro'ect successfull"meets all the %redetermined design re>uirements and o%erational criteria. 4he ma3esuse of all %ossible networ3 infrastructure in %lace, an re>uires minimal additionalcom%onents to %urchased and no outside contracting to com%lete the softwaredeelo%ment.

2. F&t&re directions

4he %ortable bac3u% media trac3ing s"stem %roduced from this %ro'ect wasintended to be a low cost solution deelo%ed b" in house staff at the 6ationwidehildren8s os%ital. :s long as the organiation maintains staff with the a%%ro%riates3ill sets, the %roduct can continue to be u%dated with new ca%abilities and featuresadded as needed for automation tas3s of this business %rocess.

!hould the 6ationwide hildren8s os%ital re>uire u%grading to a more robustdatabase serer in the future such as (icrosoft !E@, the :ccess 2007 data can beu%sied and migrated to the new database serer. !uch an u%grade would re>uirean additional inestment in hardware, but the current solution %roides a foundationthat would ma3e the transition fairl" seamless for administrators.

$or 42 onsulting, this database is a launching %oint to remoe the branding, conert toa !E@ database with a full web front end to create a commerciall" mar3etable %roduct.

). nnotated 5ibliograp$y

n article t$at compares different 6eb development platforms

.Net Comparison Chart. ;200A, $ebruar" 5


11/14

Final Report for Media Management Page viii

128 Barcode.:dams 1.

rticle regarding 2 dimensional barcodes and t$eir &ses

2 Dimensional Barcode. ;n.d.


12/14

Final Report for Media Management Page ix

dynamic ebsite alloing &sers to searc$ for broser &sage based on inp&t date

Bro'ser Mar(et Share. ;2010, une 2#%ridH0)>%timeframeH()>%s%H12A)>%n%H1)>%ctH

T$is site describes t$e softare development life cycle and several met$odologies

ha%man, . . ;2007, anuar" 1


13/14

Final Report for Media Management Page x

,o ac( for Bac( p #apes. ;n.d.


14/14

Final Report for Media Management Page xi

!ilwa, . ;2002, (a" 20uence. ;2010

project report sample 1

Documents