HomeMy WebLinkAbout2004 12 13 Informational Item 303
COMMISSION AGENDA
ITEM 303
Consent
Informational
Public..Hearing
Regular /
x
December 13.2004
Regular Meeting
Mgr. 1
Authorization
REQUEST:
Information Services wishes to update the commission on
the status of the I.T. Plan created in FY 2002.
PURPOSE:
The purpose of this item is to update the commission on the LT. Plan
which was created in FY 2002. Additional projects and tasks have also
been added to the end of this document.
CONSIDERATIONS:
See attached Projects worksheet
The Information Services (LS.) Department strives to complete assigned
projects in a timely manner. However, things sometimes happen that
prohibit us from meeting those deadlines. Thus, we are forced to move
our projected completion dates further out.
FUNDING:
RECOMMENDATIONS:
ATTACHMENTS:
COMMISSION ACTION:
None
None
LT. Projects worksheet - Attachment 1
S :\Information _ Services\Admin _ Docs\Agenda Items\FY 2005\December
2004\121304_ COMM _ Informational_303 _Information_Technology ]lan _ Update. doc
I.T. Strategic Plan
Status of Projects for FY 2004
. .
.. ~ ~
... " "
_~ / f:
17
tnfarnudlan, rec~ogy
--l'IllIrtnasnOt;
Items
Project Orlglnal compleled as
Number Project Grouping Code Projected of this date
Due Date denoled with Revised
./
Due Dale Comments
I.T. Strateolc Plan Pro ects and Tasks
101. Centrall%ed Backuo -Cltv HaU Side louie Netwol1<
101... Networ1clbackuo analvsis oerlonned Network 9130/2003 ./
101-b Obtain Commission authorization 10 ourellase eauioment from state conlmct Netwol1< 9130/2003 ./
101-c Eauiament and software aurellase Network 9/30/2003 ./
101-d Installation & Imnlementalion - General servers Network 11/30/2003 ./
101~ RMAN confia Network 6/10/2004 ./
101-f Inslallation & Imnlemenlation . SOL & Orade Network 6130/2004 ./
10/29104 Oracle CD has been received. However, we will wait until the Kiva support person is
101-g Testing of database reslores Network 8/20/2004 1/31/2005 hired to coordinale both the server migration as well as the Orade 9i upgrade and backup
testina.
103 CItv Forms Conversion to PDF IJacaul Other - Forms Cooversion Done Decided 10 wait for new Kiva oerson so we don't soend monev now.
103-a Research deoartmental fonns and eslablish alan for conversion Other - Forms Conversion 10/31/2003 in PlUllress 12/1512004 Met with HR. Researchina technoloav usina XML Adobe and ASP.
103-b Beain lmolemenlation of conversion olan Other. Fonns Conversion 12/31/2003 not vet started 11212005 Need to aet Inlmnet ua and runnino before this can hapoen.
'104'. DoeiJnli!iit Manaaement SYStom(JaCClul & RMS Team Records Mom!
l04-a Retain consultant Records Mom! 11/11/2003 ./
l04-b Research and cuttino toaether imolementation olan Records Mam! 2/29/03 ./
104-c FLC submits Dlan to Citv Staff for revisions and aaaraval Records Mam! 4/2612004 ./
104-d FlC submits alan to Citv Commission for aDDraval Records Mgm! 5/24/2004 ./
104-0 Seetin Ian imnlementation Records Mom! 5/25/2004 ./
l04-f Meetino between I.S. and Clerk's Office {Records Manaaement Team Records M mt 11/4/2004
104-0 Create Worl< Plan for 2005 RecordsM m! 11/24/2004
l04-h Overview with Deoartment Head Staff - FLC & Records Manaoement Team Records M m! 11/24/2004
l04-i Create Worl< Plan for 2006 Records M m! 6130/2005
104-. End alan imolementation (ooal date) Records M m! 9/30/2006 Ian is 3 year plan FY 04-06 with onarnna costs after the 3 Vl>ars
106 Munls 2004 Release Imalementatlan Jacaull Munis
10&-a Load into test Munis 7/27/2004 ./
10&-b Jacaui to create ar6ectlwor1< alan Munis ./
10&-c Status Meelinos comolete (11/15104 - 2/14105 Munis 2/2612005
106-d Trainina Phase: Establish Trainina Needs 111/15/04 -11/16104) Munis 11/1612004
106-0 Trainina Phase: Execute Trainina of Testers 11/17/04 - 11/23/04 Munis 11/23/2004
l06-f Trainino Phase: Execute Training of Users 1/18/05 - 1/25/051 Munis 1/25/2005
1 06-ll Trainina Phase: General User Trainina Sessions 11/20/05 - 2/17105 Munis 2/2012005 31812005
10&-h Test Phase: Unit Teslina 111/24/04 - 1/19/05 Munis 1/1912005 31812005
10&-i Test Phase: Intearation Testina 11/20/05 - 3/2105 Munis 3/11/2005
lQ6.j Unload Munis 2004 Release into Live environment Munis 3/18/2005
10&-k Uoarade Unix oIs fram 5.05 to 5.07 OR 5.5 Munis tbd
101 .. Munls E'l'un:has....Order Imniementatlon Jaeaul Munis
.107... Beain research linterview deots research cooies location of documents ete Munis Ibd
107-b Process Desion Munis tbd This has been moved to a lower priority in order to accommodate Finance request for Munis
107-e Setuo with ForMunis Munis lbd Crystal Reports and Munis 2004 implementation. Want to do the 2004 release first, then the
107-d lmolement & OJA Munis Ibd Munis Receivino before we aet 10 this nem
109 Munls,.A""""lance of credit cards for utllltv bill oavments Jaeoull Munis
109-3 Establish FinanciaVcredit card aolieles {Reaular G - JulY 14 2003 Commission Meetinol Munis 9/3012003 ./
109-b Started over on this aroiect - issues with vendor and contract Munis 11212004 ./
109-c Researchina OPC & SpeedPay Munis 517/2004 ./
109-<1 Determine best vendor Munis 517/2004 ./
109-0 Finance and I.S. auestions answered Munis 5/28/2004 ./
109-1 Create Policv (Finance) Munis 7/13/2004 8120/2004
109-g Create lmolementalion Plan Munis 8/25/2004 ./
109-11 Policv review by Citv attomey Munis 1011/2004 ./
109-i Commission aooroval of vendor. DOIicv and imolementalion alan Munis 6/14/2004 10/11/2004
109-i Testino Phase Munis
R-.d12J5'2C01
M.4STE/'lnPtqlcb~IQgOloConVDiaion
P.- 10fl
I.T. Strategic Plan
Status of Projects for FY 2004
. .
~.' ~.'. "
.: -::' ~
IY
tnfonnatJon Techno1og't
-....wlntol'llllrt"lI.n...g
Items
Project Orfglnal completed as
Number Project Grouping Code Projected of this date
Due Date denoted with Revised
'" Due Dale Comments
109-k Trainina Phase Munis
109-m Advertisina and aublicisino of this credit card caaabilitv Munis 1/1/2005
109-n Go live for Credit Card AccePtance Munis 1/1/2005 Meet with Michelle
110 Munls . Bank Draftlna for utility bill Davments Jacoull Munis
Ilo.a Testina. Prenates. 4 cvcIes (ADriI22- Mav 201 Munis 5/2012004 '"
l1()'b Testina. Bank Drafts. 4 cvdes (June 22- Julv 131 Munis 7/2012004 '"
l1Q.c Policy creation Munis 7/31/2004 '"
11Q.d Policy Review: LS. Munis 8/2012004 '"
llQ.e PoIicv Review: Leoal Munis 911/2004 '"
II()'f Commission aaaraval of Policy Munis 9/1312004 '"
110-0 Mailauts/applicalions to residents comolete Munis 10/20/2004 '"
II()'h live Prenates to bank. 4 cvcIes Munis 12/31/2004
11()'i Live Bank Drafts. 4 cvcIes Munis 1/2812005
M,~~~eceMng . automated receMng of goods and selVices. purdlase orders Munis . . .;,'~y..
112 'ItJa III ,.... ... ......., '.". .....i.. .. This has been moved to a lower prlotity in order to accornmodate Finance request for Munis
112-3 Set un trainino Munis 5/1512004 Ibd Crystal Reports and Munis 2004 implementation, Wail until after Munis 2004 release
112-b Testinp & Traininp for small test proup Munis 6/18/2004 tbd implementation
112-<: Trainina Munis 8/2512004 tbd
112-d lmolemenl Munis 6/28/2004 Ibd
,115. CIlv Hall Access ... Other. Kiosk , ,.' On hold until further notice per City Manager
115-a Kiosk in lobbv /this nro.ect was cut out for FY 03 and FY 04 bv City Manaper Other. Kiosk
... . ,'x..: ::.,,~..
... , ... .,., ,/ Other.CrystaIRe~ ...,.
11h' CNSbIReDorls . train the Traii.er (ClaSSes fa 2 of 41-60 daYs to finish (""""ull
117-a class 1 of2 Other. CIYStal Reoorts 5/31/2004 '"
117-b class 2 of 2 Other. CIYStal Reports 21412005 Rescheduled
118 . Crvstal Reoorts Entemrfse Setuo (Jacqul & Teaml Other.. CIYStal Reoorts .;.,...... '. '>:,;';';"',;$:~;'''?i;
118-a ourchase server Other. Crystal Rennrts 5/31/2004 '"
116-b traininp for Jacaui Other. CIYStal Reoorts 6/1/2004 '" 9/20 . 9/23
118-c Set ua server comolete Other. CIYStal Reports 6/1/2004 12/31/2004
116-d Set un Users comolete Other.CrystalReoorts 1/14/2005
116-e traininp for users bepin Other. Crystal Reoorts 6/15/2004 1/21/2005
116-f proiecl comoletian Other.. CIYStal Reports 6130/2004 1/24/2005
."Au'. ' ColleCtIon aitil'l:I'eation of Wireless Documentation Bill Network ., Wireless' . .,..'.., ., ... ''',~'~:ll:'~
123-3 Document wireless eauioment (Access Points Print Servers 1 Network. Wireless 6/1512004 '"
123-b Basic Standard Confipuralon for Access Points Network .. Wireless 6/1512004 Ibd Dependent upon Commission Decision on Wireless
123-<: Wireless Host Confiauration Nelwor1< . Wireless 6/1512004 lbd
123-d Creale nrocedure (or addino wireless clients Nelwor1< . Wireless 6/1512004 lbd
126:. WebSense reconfiaurallon (BIIO Network. Web$ense ... ... ..~.,~ ~>. :'.".~,,:" MAY be unnecessary after Pix and ISA install (11/29/04- 12110104); need to further investigate
128-a WebSense reloaded Nelwor1< - Websense 4/1312004 '"
126-b Reconfinure Nelwork~ 71212004 10129/2004 the reporting available with ISA
'126." Exchanlle ReDOrts and Monltcirfnli (louie). . ... - ,. ., Network - noe 6/1612004 - 3/31/2005' Look at this AFTER Exchanpe Mi ration 11/29/04-12110/04
130 Exchanae 2003 Mlaratlon (Bill & louie . Network l:XCI1anpe . 1/3112005 .12/1012004
13Q.a User instruction/procedure sheet for cleaning out and maintenance of mail boxes Joanne emailed Andrea with Iisl of questions that need to be answered before document can be
written
Document to contain the following criteria: user to perform routine maintenance on a scheduled
13()'b User training on instruction/procedure document basis; 300mb limit on mailbox; 5MB limit on attachment size; how user can view mailbox size;
etc.
13Q.c Actual user cleanun of mailboxes completed
13()'d
13Q.e
131 Pix 520 Firewall reconfiauratlon (BUll. Network. Pix :913012004 '" Unnecessary as Pix 520 Firewall wili be realaced (11/29/04-12/10/04\ Removed
132 McAfee GrouDSllleld on Exchanae Server Louie Network' McAfee & Exchanne.
132-a Install and conftaure previous version Nelwor1< . McAfee & Exchanpe 5/21/2004 12/31/2004 will wait until after minration 10 Exchanae 2003 Sometime after 12110104)
135 USB Handhelds Datarnatlc) Utility Billino . Handhelds 5/28/2004 8/31/2004
R......,l2..'&'2l>>!
w.sTERJT~~~toDllID~
p. 2 on
. .
..~.:.~ .~, ,.
:. ~. t.
-.
17
tnfannaUanrechhah;>>gy
--"'PI'lnQSfLotil
Projecl
Number
Project
135-a
135-b
135-<:
135-<1
137
137-a
137-b
137-<:
137-<1
138
138-3
138-b
138-c
~;:O--:140
:157
15703
157-b
157-<:
.t57-<I
157-e
157-f
157-<1
.'158
158-a
156-b
158-c
158-d
158-d1
158-d2
158-d3
158-d4
158-e
Trainina
Eauioment and Software Installed
Testina
lmolementation
Web Site llntemetl Enhancements Jacoui & Team
Seoarate web n~ne for Utilitv Biillnn to indude oarbaae issues
Creation of Permittina and Zonina Custorrer Service web n~ne
lmoravements to 1.5. Mae on Internet web site
Add bid autorrntian to web site bid annlication Jacaui
KIva UDQrades lKIva Admlnlstrala" .
Uoorade database to Orade 9i - booin aroiect
Additional user traiaina needed for enhancements/new features
Uaorade Kiva annlication to 7.X
Domain mklratlon.fr()rn Windows 2000 to Windows 2003 1811I & Team
, Pentaonatlan- riilnrauon 10 new server Bun
obtain auotes & order hardware
install & canfiaure server & Unix OS
install & canfiaure hardware - OOW<!rvaull backuo
install & confioure software - Infomix Database
miorate Pentamation database over to new server
war\( with Pentamation on PrintinalPrinter issue - can1 arint to line arinter
Policies 10 be wrtllen& Farms 10 revtse fJoanne & Teaml
Architectural Standards PoIiev
T echnoloov Policies & Procedures ntan
Disaster RecoveN Plan
Wireless Poliev - Dn<sibtv combine with Nlmnuter use & oerinheral device nnlirv
PoIicv Creation
Staff Revisions
Attornev review
Camnlssion annraval
Reauest for MultiMedia Services
draft to be reviewed bv 1.5. Staff
revisions to be cr.mnleted and nn1irv to be issued no later than....
Go To Mv PC
New and Deoartino User Forms
Proiects Re uest and Status Form
Software/on, lication Troubleshootina Procedure
NetworK Pa inn Procedure
Computer Use Policy - Revision needed - possibly combine with peripheral use and
wiretess OOirv
Peripheral Devices Access Policy - possibly combine with computer use and wireless
OOicv
Web Postinn noliev ICitv Attornev\
Overtime and callout ooliev
Policv & Procedure for web site submission and oostinas (Jacnuil
Fulllmolementatlon of Blue Ocean Track-ltllJacoui & Louie
Table deanun
Priorities Table and Dates Functionalilv Cleanuo and Confiaure
User lmoor!
Set uo audition
User trainino
Go live
Issue Pa....r 10 be wrtllen fOr discussion Jacnun
153-1
1 S8.<J
158-11
158-i
158-i
153-k
153-1
158-m
158-n
153-0
159
159-a
159-b
158-c
159-d
159-e
159-f
160
RftiMd12/a12OOf
UASTERITPlqK1s~lCIl1Ola~
I,T. Slrategic Plan
Status of Projects far FY 2004
Grouping Code
Utility Billion - Handhelds
Utility Billinn - Handhelds
Utililv Billinn - Handhelds
Utililv Billinn - Handhetds
Web Site
Web Site
Web Site
Web Site
Web Site
Kiva
Kiva
KIVa
Kiva
Nelwofk - Domain Mi=tion
Pentamation
Pentamation
Pentamation
Pentamation
Pentamation
Pentamation
Pentamation
Pentamation
Policies
Policies
Policies
Policies
Policies
Policies
Policies
Policies
Policies
Policies
Policies
Policies
Policies
Policies
Policies
Policies
Policies
Policies
Policies
Policies
Policies
Policies
NetwOrl< - Track-ir.
NetwOrl< - Track-ill
NetworK - Track-it!
Network - Track-it!
NetwOrl< - Track-il!
Network - Track-ill
NetwOrl< - Track-it!
Other-Issue Pa""r
Original
Projected
Due Date
6/18/2004
7/3112004
8/2012004
8/3112004
5/1412004
71912004
71912004
tlJ<l
8/1112004
8/1112004
11/12/2004
12/3112003
12/3112003
12/3112003
5/28/2004
5/28/2004
6/1112004
8/28/2004
10/512004
10112/2004
613012004
11/112004
7/1612004
9/1312004
10/1112004
10/1312004
10/2712004
Items
completed as
ofthls dale
denoted with
~
Revised
Due Dale
~
~
~
~
~
~
~
Ibd
tbd
Ibd
.. 12/1012004
~
~
~
~
9/3012004
12/112004
.... "."
in arooress lbd
in arooress Ibd
in nrooress Ibd
~ tbd
~
~
~
~
~ 101712004
'2/2412004
1/3112005
1/3112005
Comments
Did not go as anticipated; awaiting software patch
Steve is slow to respond for testing.
tbd
tbd
After attending the Kiva Conference, I recorrrnend we relook at this project and carefully
consider what needs to be done. Shoutd wail until Kiva Administrator position is filled in
NovemberlDecember '04.
migration done; printing not working. Bill in touch with Pentamation on fixing this problem.
1M
Ibd
tM
tbd
tbd
Ibd
Ibd
Joanne emailed Cilv attornev on draftinn of nolirv on 10/7/04
p.. 3of'
. .
:_ot._'~~. t ~
I"
InfornurlJon Tectudog:r
__reprlngsIL.otg
Project
Number
Project
160-3
161
161.a
161.b
161.c
162
162-a
162-b
162-c
Commercial Customer Enterprise Setup re: business license, uijlity customer. customer
#
Munls Messenaer . aDDrovals and notlficatlons Jarnun
Testinn
How-to doc sent out
nro.ect comolete
Munis Enhancement Reauests JaMun
UB Fonn Unrlate
Delinquent bill fann revision
Delinouent card indices revision
163-<1 Resolve issue of Public Records redaction on UB Online (Jacqui)
163-e Redaction of exemot emnlCM!es from Munls BL and UB \
163 Resoun:e.ReservatlonSlmem via calendarlnn 'Louie
.", ',.'-'--' ., "" - -.. ...-
:1fl.4,~ ~IiFj~iijR~nG;,;;,.;;e;,tiSei ..n6MznSil. ImnillrnointatlOll/Bill &loulel ..,
166, .. AD/GPO/OUreo'" & nn1lcles creationtBlllloule AdaR1l
166-a Police Deoartment imolementaijon and testi~
166-b review rest ofCitv
166-<: imnlement nnlides
175 ld8nutl~cii.J~.i.vBad~~' ..
176,,: Autornatel>Ostlna (If aaendas & minutes for Clerk's Office IJustln & JaCl:lull. .
-. 178.',' Autoinatea....nd3lti!ms...........n for Pro ects Clerk 'Justin & Jacaull. , ,."
179,,;' Munls'AIlinlri'lIndFonns Dot Tralnlno - after 2004u""radefAorlt20051 ._ _ ..
f8~~,;SI~~cry~~~e!>"rts(PrlOrlty/partlal project). this Is, not the entire Munls Crystal
I mentatlort/~n:. _ , n .. ,
180-a load CMltal on 2 machines
18O-b set un tables and views
18lk: download reoorts
l8O-d test reDorts
18Ck! no live
18()'f draft commenl and concern documenl to Finance -,;;nardinn C"^'tal
181 Direct Notifications via SMTP .
181-a APe PoNerChute UPS Software
181-b LanSafe PowerWare UPS Software
182 Public Work.fCOrl'lDlex Data &.Phone Communications
182-a P1anninD Dhase with Public Wori<s
182-b Imnlementation - fiber & conduit infrastructure
182-c Imolementation - data eouioment
182-d lmolementation - ohone eDuiDment
18208 lmolementalion - kevless entrv eDuiDment (BulldinDs 1 & 31
183 E-Bllllnn for Utllltv Bills Ja=u
183-a Check for Munis feature availabiliiV
183-b Submit enhancement reouest to Munis
183-c Submil enhancement nuote to Citv Mananer
183-d Research
183-8 Take item back 10 Commission as RMUlar Anenda Item
183.f Review this al a later date as to when it will be available from Munis
184 Deooslt Refunds for Utllltv Bllllnn 'Jacnul'
184-a Review with Utilitv Billinn
R--.:l1:tA.~
WASTERITPrai-;ts~lCIlPlCI~
I.T. Strategic Plan
Status of Projects for FY 2004
Grouping Code
Other -Issue Paper
Munis
Munis
Munis
Munis
Munis - Enhancement RMuests
Munis - Enhancement R""uests
Munis - Enhancement Requests
Munis . Enhancement Renuests
Munis - Enhancement Requests
Munis - Enhancement RADuests
Other - Resource Reservations
,.,...
"~<WtJfK ' ,
..'
.
, Netwofk
Netwofk
Networl<
Netwofk
-,-
',. -~.
. Other - automated ~tinn
, Other.- aulofrated """tinn
... ,_ Munis--
~
Munis
Munis
Munis
Munis
Munis
Munis
Netwotk ' N01ffications
Netwotk - Notifications
Netwotk. Notifications
Netwotk- PW Facifl tv
Netwotk - PW Fadli
Netwotk - PW Fadli
Networl< - PW Faciii
Networl< - PW Faciii
Networl< - PW Faciii
Munis
Munls
Munis
Munis
Munis
Munis
Munis
Munis
Munis
Original
Projected
Due Date
6/1812004
5/10/2004
5/1212004
5/1212004
8/13/2004
7/1/2004
5/1512004
tbd
lbd
7/3112004
12/31/2004
.
7/9/2004
8120/2004
8120/2004
too
tM
lbd
4/3012005
7/23/2004
7/23/2004
7/23/2004
812712004
9/10/2004
9/10/2004
10/1/2004
too
6/1/2005
Items
completed as
of this date
denoted with
,
Revised
Due Date
12/31/2004
Comments
10/2212004 Jacqui needs to get sign-off from JudVthese dates still good per Jacqui on 10/5/04 staff
10/2212004 meeting:Need emall addresses
10/2212004
,
10/29/2004 Wants to put the $5 late fee on the posl cards. waiting on BL 10 be completed first Then GBF
will worl< on this form
,
,
Jacqui submitted enhancement request to Mullis: Moois responded that it will cost $3,000 to
complete this enhancement;Joanne wrote 10 Mr. Peterson asking for assistance with this matter;
he said it would be induded in a Mure release at no cost 10 us 1 st Olr 2005.
JaM,,; to submit an enhancement ""'uest to Munis
10/29/2004-
.- 1211012004. Netwotk Uoorades 111/29/04 - 12/10104\
..,..
,
10/31/2004
10/31/2004
,..
,
~
;.c
."
H. .
Research complete on several optionslCOl1ll3nies. Joanne to proceed with HR to see what
funds need 10 be anornnrialed to finish this UD. AnDroved bv C.itv Mananer.
,
, Training with Paul. Judi. and Rosanne has been done. Roseann getting pennissions error.
, 8/13/2004 Jacqui to check with JudL
9/24/2004
, 9/24/2004
, 9/24/2004
in orooress
10/29/2004 Need technical assistance from TIBI - no consutting money available
10/29/2004
,
,
,
,
,
,
Not available at this time - Jacqui submitted enhancement requesl to Munis: received letter
stating they can do this for $4,000. City Manager wants more information such as what % of
cuslomers would actually use this. Working with Finance Department on this research. Per
Michelle. Ihey did not have this capability at Oviedo with HTE. Need to revisit this after 2004
retease to see whenflf they are going 10 implement in near future.
PIIg.4ofl
I.T. Strategic Plan
Status of Projects for FY 2004
. .
:7) .
I,.
.~~,.J~~~1
Items
completed as
of this date
denoted with
.-
Ortglnal
Projected
Due Date
Project
Number
Project
Grouping Code
Revised
Due Date Comments
Bug fix 2003.04 did not fix problem. Laurie Uttlejohn (Munis) wor1<ing on this problem as a bug
fix at this time.
Munis lrainina
Buos found - reoorted to Munis
Bun Fix 2003.04 to be loaded
lmolement orocess
BellSouth Phone Book Protect AdamI
installinn and testino comnlete
imolementation 10 desktoos
imolementation to taotoos
Plannlna and ImDlementatlon of Xcad AdamI
UnaradeVldeo Devices In Bulldlnn . Police Den.artment AdamI .
external
Internal
lB4-b
lB4-c
lB4-d
184-e
185
185-a
185-b
185-<:
18L
, 194.'.
194-3
19441
,'.,
Munis
Munis
Munis
Munis
POlice Pro.ects
Police Pr6ects
Police Pro. ects
Police Pro. ects
Police Proiects
Police Proiects
Police Projects
Police Proiects
Police Projects
"
"
"
9/16/2004
9/24/2004
" 8130/2004
.-
Not a hune nrioritv
11/112004
12/112004
913012OO4
3/112005
"
tbd
..
. . ~ 913012004
-:~... ,
,
mD18inentatlon. of MATRIX 2.0 Accessfodnvestlaatlo,,~6n WorkStatlonsr AdamI
/.. .,,'.' ..." . ",. ,. ... ...... ..,.c......
.rt.;I~;,;;.;;t.;.u,,~and dG"';IODment Ofj,"';;'Ver;;loii AVLGPS ,0rMcrs IAdam'
:T\:">';"_<_.'>-, :'_ ',':- ">: :-~.,.:. ':~~< ' ->.'-':" _'_:-~,':~ -- -<:','2:,.:"-'_:- :r.,'-_~:"'_'
. ;emeritatl';" andcon;,~vi';' tosemi;,o";CO:;-~";:DI~I"".cS~~;"I..tIamL
'..lenB~t~~D~~~l~'~~~nti04i';Ada~'.';'."
o':.-of E-Aoarit~~are'to '",i,Ilice'Dai;;miixx (AdamI,. ...
,:. InS1altatlon :.' .",c. ,fEE:..}.:.:: ......., .:-... '..' .""}
.,.:.":?;',Tralrilna'. . .... " ,'- ,.,
201 RaDld PavIJacauO .. . .. .
201 -3 Research with Munis to see if thev can automate
201.0 Workinn on manual orocess
201-<: Detennine if automated is feasible
201-<1 lmolement manual orocess
201-e lmolement automated orocess
. 202. ,. Rentace TounhbookKe_rds Adam
202-3 testino
202.0 imolementation
.205;'" PD I'tlone FalloverIDlsaster Plan AdamI' . '.'".c'"
205-3 Coordinate wlBellsouth & SC Public SafelY IAdam
. 208'..~ InstalUlmotemenl new APS Software IAdaml
206-3 -Voice
206.0 -Swioes
206-<: -Crash & t=Ticl<et
206-<1 Printer Install for Crash & Ticket
209 ReloCate PD se1Vers Adam .
.210. Renlace'()ldCabllnn, PD. DISPATCH AND EOC AdamI.
210-3 Patch Panels
210.0 Under Floor Boxes dlsnatchl
210-<: Under Floor Boxes EOCl
211 . Install Prole<:lors In EOC From Chambers IAdaml
.. .212. " RoolaceSwitch at PW AdamI
215 EOC Disaster Plan AdamI
215-3 -Phone setuns
215.0 .comDuter SetuDs
215-<: -Plan Created
217 Web Site items Submission and Postlna Pollcv & Procedure IJacaul
218 Firewall Install ..'
219 VPN Concenlr3tor
10/3112004., MCTs workino fine. Awaitino Countv connectivitv to FDLE Matrix svstem for wort<stations
,., ': Awaitino SCSO Develooment
.
. Police Projects
POlice Projects
',':
'\;~..:~: Jit
. .., ...,!; ,... '.'
...~~'>:'
.. '. ...
. .....'.. . '.-.
," . ,
..,. .
.- ..
"
"
"
f'o!i~~ojects
POliCE! Projects
Police Prniects
POlice Proiects
. Munis
Munis
Munis
Munis
Munis
Munis
PorJCe Proiects
Police Pro. ects
Police Pr6ects
. 'Police Proiects
Police Pro. ects
Police Proiects
Police Proiects
Police Projects
Police Proiects
Police Pro. ects
, Police Proiecls
,. POlice Pmiects
Police Pro. ects
Police Pr ects
Police Pr ects
Police Pr .ects
PoIicePr .ects
POlice P .ects
Police Pro'ects
POlice Pr6ects
Police Pro. ects
Web Site - Intemet
NetworK C'eoui"""'nt
Networt< - ""uinment
10.26.04 awaltlno shlnment
1;13il~
,.....
.';'.,
10/812004
1011112004
12/1012004
101412004
Ibd
Awaitinn Resnnnse from Munis for enhancement reouest
...
,
,1111/2004
.-
"
Awaitinn on Panasonic. All on back order. 10.26.04
Meetings with PD. BellSouth, County E-911 Coordinator, IS, Fire Chief; 151 meeting on 10/6104;
2nd meetino 10/13104. final meetino scheduled for 11/10104
11/1512004
, . . 11/112004
.. .
11/1512004
11/3012004
12/1512004
12/1512004
12/112004
...:~.
1/112005
1/112005
1/112005
12/112004
11/1512004
-
./'
Motors
1111/2004 Motors Done-Need Bike Hardware Purchased.
ON HOLD
Data cabling quotes received! still need electrical quotes/unable to obtain an electrical
contractor at this time;Waiting on Public Works for Electrician.
Awaitino Proiectors
Channe of Plans . Bill
.
.-
.-
Ibd "
11/1212004
12/1012004 "
12/1012004
R.....-.cl'21ll..2OQ.l
M.l.$TEFlITPlqec:I.~lggICIIO~
P.5ofl
. .
~.j."" -"., 10
.'. ~.,' ~
I"
l~nnaUcn Tec.hnatogy
__rspr\ng!!fLorg
Project
Number
Project
2 Switches for Public Works
Redeslan County Ucense Fee Collection Process Ja""ull
oet aooroval of new desion with Max
oet nuote for wor1< to be done bv Forrrunis
ilTlDlement new orocess
Web Site /Intranell Enhancements (Justin & Jacaull
Create Intranet Home Paoe comoletion
Create HR Intranet Pane
Create LS. Intranet Paoe
Emolovee Classified Paoe
Track'lt Version Uaarade to fix lumbled ticket aroblem Louie .
XP SP2Testina & Imalemenlatlon Bill Louie Adam
Testina
lmolementation Plan
lmolementation RolJ-out
OffIc:laICltv Loao Justin & Jacaull
Find alllooo-related items fumished to us bv our orevious PR firm
Write UP Anenda Item - take to commission to have them make decision
,,',,': .";'.','> .~, ,.,;::.,~;:u ';.,'t' ... ".':,.' .." :"~.,,.f. ,.
.C"' ..~.,:.,.,. .,".','." ..,:" '.,., ,;.""",.;.,'.,
i,: ~esoNeJsSue of,6!IISOuth Muxes nllfidlng to be moved so they ",III be on .'. . .,
1<m"eratorIBlli:AiI3m:Joon'iief",;.,":,. :.., ;,;.'!F'. .,/,'~"" ,:, ;"
229-3 Meetina scheduled with BellSouth County E-911 Coordinator, PO IS FD
229-b 2nd Meetina scheduled with all oarties listed above
231 Install New EOC SwltchlAdaml .
4232,>", ImolemenlallonofFl'Dala Sharlna Consortium Access IAdaml.'
220
223
223-a
223-b
223-c
224
224-a
224-b
224-c
224-<1
"225.
228".'
226-a
226-b
226-c
..227.
227-a
227-b
.,.
",,..,"$:' H,el'!",e>rltl~f~~tu",& Slij)~lnlllatlves .tOlmp!""venetwork'~~l1Il3nceand ..
."102'" toavOlddalaloss, . '., u,..'.",
102-a Networ1< analvsis - entire networ1< lavout - hubs switches routers etc.
102-b Obtain Commission authorization to purchase eauipment from state contract
102-{: Networ1< analvsis - Eauioment and software ourchase
102-d Networ1< analvsis -Installation and lmotementation - 3 GB networ1< switches
102-e Reroote ControVSuocort of Workstations
102,f UPS for each workstation
102-a
102-h
102-;
105
10!;.a
10!;'b
105-c
10!;.d
105-c
105-<1
108
106-a
106-b
10!l-c
108-d
111
111-a
Ooeratina SyStems Uoarade from Windows NT4ta Windows 2000 Server olatform
VPN of 1.5. Suooort
Full imolementation of worI<orouo orintino
Munls 2003.03 Release Imalemenlallon IJacoul
Loaded into test area
Waitina for Buildino Deot (Svlvialto test
Database reload
Dennis will test bill nrintinn
Waitina for Finance (Judil to review test results
Load into Live
Munls . Online Vlewlna of Ulllllv Bills via Internet - (Jacaul
software enhancemenl needed 10 make this WOf1<
Deroo for Ulilitv Billino staff mananement
Utilitv bill revision (move customer number and account numberl
Put link on web sitelPr6 eet comoletion
Munis Positive Pav .0revenUon of check fraud Jacaun
Pro. eel benin
R_-.l12.'!I2lI04
MASTER ITF'lqedII~I"gaIOC__
I.T. Strategic Plan
Slatus of Projects for FY 2004
Grouping Code
Networ1<-f>lluinment
County Oce License
Web Sile -Intranet
Web Sile - Intranet
Web Site - Intranel
Web Site. Intranet
Web Site - Intranet
Network- Track-it!
Software - Testina
Software - Testina
Software - T estin
Software - Testin
Other. CItv lDoo
Other - City Loao
Other - City Loao
'. ...Netwoit.
. .,
.c .
..'. ,
.
Onglnal
Projected
Due Date
Items
completed as
ofthls date
denoted with
./
./
Revised
Due Date Comments
Moved 1 switch to Water Treatrrent Plant for VLANS
Just waitinn to be tested bv SYlvia in Buildino Deaar1ment as of 10/5/04
10/9/2004
./
./
12113/2004 ./
211412005
3/2112005
5/15/2005 ./
10/15/2004 ..
tbd
Ibd ./
tbd ./
tbd ./
9130/2003
913012003
9/3012003
./
./
./
113112005 ". Ron said he'd look for what he had and Kip said Alan had some items. I emailed Justin with this
2/2412005 info and asked him to get with Jan and Alan.
..:' I.. . ..,::' ,'r"':'. AD previously not replicating; now it is; we have decided to wait until all our new equipment is
.,. .' :.:ihd:. I",'.. ;", .,.' .,' c"',~');f:,,.:::' installed with Neirs help (Dyntek) and then we" review the issue with Neil and County
.,. ,'..,:'. ...: :<~st Meeling took place on 10/6/04; several options were presented by BellSouth; other options
." " . " . ~ were discussed as well as funding for each. The general concensus was that we first need to
10/6/2004./ move the Muxes from the 2 points of failure into secure facilities with generation power
10/13/2004 capabilities. Will wait to see what 2nd meeting scheduled for 10/13/04 produces.
1113012004 ...... , ..
1211~~" i.
9/3012003 ./
913012003 ./
913012003 ./
1113012003 ./
913012003 ./
913012003 ./
4/16/2004
51312004
5/2612004
5/2812004
61212004
61312004
./
./
./
./
./
./
6/1012004
6/1012004
6/1012004
2/2912004
4/1712004
513012004
6/112004
./
./
./
./
4/5/2004
./
.. due to shiD on Fridav 10/6104 - will need to install afterreceived sometime week of 10/11-10/151
,
Test failed. Waiting on new fix from Munis
P~lafSl
. .
...... "~., ...
... '..
I"
tnfonnatJan. TechOo'louy
__"'pr\J>gllILot~
Project
Number
Project
111-b Trainina
111-c Sel uo with bank
111-d Determine ff Munis must create an enhancement far file format
111-e Testinwtransferrina file cnmnlete
111-f Go live
113 KIVA Interface Joanne
113-a Research and outline scooe at work for MunislKiva interface
113-b Plan with imtllementorslnroorammers/Citv Staff
113-c Imnlement this interface
114 MultiMedia Productions
11403 Create multimedia oroductions for SGTV
116 OccuD3tlonal Ucense Fee Collection for Counlv /Jacaun
116-a finish data entrv
116-b form modifications
116-c testina at forms
116-d reoort creation
116-e report testina & clean un
116-f trainina for end user
,n;oL ~ldth for Police CAFEADollcatlon with Countv
'''''120... .~rauon (Ja""ul & Team ..
120-a Beoin imolementation
120-b I uf.:'~ correletion
~ I'fmIIsl9A5.lsee Item 162\
~&E . .
~ .
~. "
~
~
~
.122-ll
"]24<', CIJerifUPS'cenlrallZed inonltorlna and canflauiaUon
': 125:',,," Centralliedbacku".flrliiWare uodateslc:onflauratlol1
,127 .., EPOMlriraUon!'...:c,;:,;' ;,
127-a Install SQL database and confinuration
IS,127-b ,ICe~fift:: NM :.fl~fi~~~:~td~:I~ uoarade
,~,1U.4'" .,..
, '134" HubMan electronic: DOor Securltv Softwarel mlaraUon to server Louie "
134-3 miaration to server
134-b instalUconfiaure IP aealSS unit
136. 5enrerlCllent Defranrnentatlon annllcatlOI1 DlskKeeoerl
Server install of Diskkeeper - installed on CH1, CHServices, WSmail1, wspd - 1 extra
136-a DOSsiblv will inslall on nr1 services server
136-b Client side -
awaitina auote for site license Louie a may be too exoensive
order dient licenses
receive and install client license
.139 . CllV-wlde Reconfla/Restructure of Dornalnnp Scheme (Bill & Team
141 Cartearaoh SOftware
141-a Trainina and imnlementatian at Carteoraoh software for Public Works
142 Munls 2003.01 Release Imolementatlon
142-a Testina with all denartments/dala
Ebff reo 'i&iom.
.
.-
-
.
,.~ .. -.',
o-pulklllachme~
R__l~
UASTER IT ~ ______ \0 lI'" to CclmmiMbl
I.T, Strategic Plan
Status of Projects for FY 2004
Grouping Code
.
,
Original
Projected
Due Date
511412004
5/2112004
5/2812004
6/412004
6/1112004
913012003
121112003
3/112004
5/3112004
5/3112004
5/3112004
511012004
71912004
4/2312004
.
101112004
12/3112004
li,I;W2OO4
li,I;W2OO4
~
5ImOO4
a.4OOOO4
9A4I2OO4
6/3012004
418/2004 '"
.c-",
4/1912004 ,/
4/1912004 ,/
12/31/2004
I.
llI<lOI2OO4
4/2612004
5/2112004
5116/2004
6/15/2004
6/15/2004
6/3012004
7/1112004
913012003 ,/
1211912003 ,/
12/1212003 ,/
Items
completed as
of this date
denoted with
,/
./
in orooress
not vet slarted
,/
,/
,/
,/
in Droaress
,/
,/
"'..
Revised
Due Dale
,/
,/
,/
,/
,/
Comments
Waiting on Sylvia to review discrepancy in reports - then forward to County. Jacqui to meet with
816/2004 Max today 9/14/04.
6/112004
81112004
101112004
NO longer a priority or project
Remove this from the plan, Too expensive and some additional unknown expenses on Munis
side.
x
X
.., ,'". "T
-"~' '" Spoke to Munis about this. They do not reconmend that we move to Windows. They
cancelled recorrmend staying on the platform we are currently on unlil further notice. We are ok with that
cancelled for security reasOllS.
'c
812012004
Canl be done
..".
, too exoansive - serao this oroiect
.. ~;:'
.
,/
,/
,/
./
will have consultant wor1< on this week at June 7 -11th
6/1812004 found anotherwav to do this without restructurino ios
tbd
tbd
tbd
6/1112004
Quotes came in around $10,000. Not in current budget Would need additional appropriation
this year OR bUdget for next year.
P-u- 7 ofl
I.T. Strategic Plan
Status of Projects for FY 2004
. .
~._ '0-.. ..
.: --;:".
19
tnfannatJon Tec.hna4OQ)'
.........._"'p--;
Items
Project OrigInal completed as
Number Project Grouping Code Projected of this date
Due Date denoted with Revised
0/
Due Date Comments
142-b lmolementation of .01 release 1211912003 0/
143 Munls 2003.02 Release lmolementaUon 3/1112004 ./
14J.a Testina with all de""rtmentsldata 3/3112004 ./
143-b lmolementatian at .02 release 3/3112004 ./
144 Online Com Int Tracklnn 'Better Place
144-a BetterPlace Online camnlainl trackinn (this will be imolemented with new web site) 9/3012003 ./
145 Munls OffIce Imnlementatlon
145-11 ImDlemenl and train on Munis Office 913012003 ./
146 New Web SItil Deslon
Survey and research changes needed for new web sile ta be roore robusl and effective
146-a for e-aavemment 913012003 ./
146-b Creale demo at new web site and nresenllo the Citv Corrmissian 9/3012003 ./
146-c Obtain Carrmission autharization 10 nroceed - new web site should be un and runninn 913012003 ./
. -147. New Position - Media ~lIst - ,.. '.
147-a Hire new Media ~ecialisl Web Multimedia and Aoolleation S""""lisl' 913012003 0/
146 GeoaraDhlc Information Sustems
Purchase of Wor1<Station GIS saflware for Community Development- Planning Division _
148-8 1 wor1<station 9130/2003 ./
.149 WorkSlaUorrUDorades ... . ... .... c>.
Analysis at systems thaI need 10 be upgraded in order to move away from Windows 98
149-a Iatform 913012003 ./
149-b Purchase at Phase I Svslems PII or below runnino Windows 98 1213112003 ./
150 Server Uoarades C AltemDt to move toward flat Windows 2000 environment .
H;O-a City Hall PDC move 10 Windows 2000 Server 9/3012003 ./
1SQ.b Exchanoe move to Exchanne 2000 and Windows 2000 Server 9/3012003 ./
1so.c Track-It Server 'move 10 Windows 2000 Server) 913012003 ./
1SO-d WebSenselSuoerScout (move 10 Windows 2000 Serverl 913012003 ./
150-0 File and Print Server (move from City Hall PDC to secarale Windows 2000 Serverl 9/3012003 ./
"151 Aitlor Ucense Creation, & SeW.. . 41812004 ./ ...
"152. WiiitetSoI1ri';;'s - . ... '-'" .:;. - 3/31/2004 l' ./
152-a Investioate broken trust relationshin 3/3 1 12004 ./
152-b Identifv and fix DNS records 3/3 1 12004 ./
152", Add new seso servers/domain controllers into our DNS zones 3/3 1 12004 ./
152-<1 ._"M_'.;;;~re 3/3 112004 ./
153 MonthlY moor! tet dents\ ._ 1/3112004 ........0/ .,. ..
<>;154-,- Payroll El1mloy" rt,. .... .... ~h>i, ,'-- - ;., ..., .... . .... ...... ,. "3/3112004', ....v. .'. "".-
. 155 New, 8/racelve Install co um ,'..' ....... .'. .. 5/112004':
- 156-' Tial um lor wll'l!le$s ,," -. . - --c 0412612004' . , ./. '",.
165 Nelw . .'. 8/3112004. ./ .....
167 uDtoD'lmDlemenlatlon. Police Deoartment .. _. _. .' H'_ 7/3112004 Ialchl10ck still nol workino orooer1vllechnician called in aoain
167-a Leaistics 80% camnlete 0/
167-b Hardware 70% can;;;lete\ ./ Exchanoe 2003 will resolve this issue
167", Saflware 50% camolete) ./
167-<1 Distribution 60% camelete ./
167... SUDDort 9/3012004 ~
168 Domain controller to be located at seso
168-a Bill 10 meel with Art SCSO ./
168-b 1m lemenl ./
169 Rear East door. electrOnic door lock. need to molace latch 61712004 ./ 6/1812004
170 Dlsclalmerlconfldentlalltu clause lannua_ to be added to outnOiiihemalls
l70-a Ihis is an issue related 10 routinn at outbound email. 1/3112005 ./
R--., 12.'&'2O:)l
MASTERITPrajKlIi~logcl:l~
P...8oft
. .
.4"'-">... .
. --,c"
"
tnfonnatJon Techna1Gg)'
_wtnto",prlng9tLotg
Project
Number
Project
172
172-a
172-b
173
174
186
Trusllssue between Cltv and Countv. creale secondaN.lnJsllo PO services
(NAT to PO services as secondarv - add dns entries
tesl to insure trust is not broken durino dtv hall rebools
Red Alert Software Installation for Fire Denartmenl
ResolYe Issue' of Public Records redaction on UB Onllne/Ja=un'
?11???????????? >
I '.187' Com"IIance";llh CJIS -lFDl.E.IFBn~';rIlvon ~il MCrs with FCIC Access lAdaml
;,C 189/,., InstaJlatlonnmnlementatlonof ke""'-door MIrV sYSlem /Adaml ..
.190':'; Aoolv and Install PKI Certlflcates for all PO /C netl/Adam
.,191 Relocation of Patrol Division to new Addition Adam
191... P1annino and Installation of new Cisco 3750
191-b Relocation of Enui ment IPC'S Printers Cooiers Phones Etc
192 . , , 0 SWitches 10 new Cisco 10S 12.1.19Ea1D
I" I;~~~.'<~""~~M_'_.~"__' .
'mplementation of.~~~~n~ stations .Wllh p~ntlng .and ~nnlng ~pabll1tlesln MCP
'~203'';;; m . ",..,.cc .',c,'.
~204::':! m); "":. ,- '"X' ':i':',:.- ". I,c..
207 '!'. no for DISoatcl Adami' ...
'208.' IImDlement Web Based Locator for DB:/Adam ,,',',. . ..:'c___ . .
'213;;" 'ffll!d()"!s.~SP2.cTestl,,ga,ndlmplemen\aUOfl(Adamr ". ,.: :'i.
214.: LaDtciDIMCTUndaUlslAdam.." .,'.
. '216 '. _OblleAntennasforMcrs AdamI.
.- 220 2 Switches ' ".
. 221 "" 2 SWitches f ., .,',
'222 1 Switch for""'.>:"'. ,..,.
230 . Mloratlonof FII9 Printers to NAS Server
R..rn.d12ltl'2Ol)l
IAASTER(TP\'gjKls~llogol.llCarrunilIJicln
I.T. Strategic Plan
Status of Projects for FY 2004
Grouping Code
Police Projects
. Police Prn;ects
Police Pmiects
Police Prolects
Police Pro.ecls
Police pfciiecls
Networ1<
. .,., Police Pr"""'ts.. .
. .',. - ~.: .- . .. .
. ,..
..
.',' "_.,, . ':-c.
.'., .
.. ,.::..,.. "."'... ..." '.
.. " ,.,-:;C,.
",.. , Pollee Proiects
. Networ1< . eouiDll'lAnl
. . 'Networ1<, AOuinmP.Ot
'. Network _ PnUiOment
.
8/112004
8/1512004
8/112004
. "8/112004 ..
, I..
913012004, . " ..-. - -
9I2OJ2004 . ., ./' .
,JM112.004 .. duplicate
.121112004'. . . ./'.'.
:111112004. ./' ..
. . ,... : duplicate: . ..ci-
911512004 .. ./'
. .11/112004. ./;-.... ",:..-'~..
1 01912004 ./' . .. '.
, 101912004' ../' = . "
.c 1 01912004,. ,. ./, . ..
10/1512004. ./'
Original
Projected
Due Date
Items
completed as
of Ihls dale
denoled with
./'
7/3112004
tlXl
./'
./'
./
913012004
8I3OJ2OO4
9/1512004 .
./'
./'
./'
./'
./'
./'
./'
Revised
Due Dale
.
. .
.,'
.,;
-::-:
: ;.
, Remove this - this is a duplicate of 199
Remove this - this is a duplicate of 226
added this to another oroiect 162
Comments
PIIge Rail