Loading...
HomeMy WebLinkAbout2009-03-09-Meeting Agendawww.augustaga.gov Public Safety Committee Meeting Committee Room- 3/9/2009- 1:30 PM PUBLIC SAFETY 1. Approve Standard Software Maintenance Agreement with New World Systems, Inc. for the period covering January 1, 2009 - December 31, 2011. Attachments 2. Approve contract with Palatine Technology Group to provide software, hardware, and services related to Electronic Warrant Interchange. Attachments 3. Receive the Information Technology (IT) 2008 Annual report as information. Attachments 4. Approve the acquisition of software and services related to the redundancy of the Sheriff's Office Jail and Records Hardware and Software. Attachments Public Safety Committee Meeting 3/9/2009 1:30 PM 2009 New World Maintenance Agreement Department:Information Technology Caption:Approve Standard Software Maintenance Agreement with New World Systems, Inc. for the period covering January 1, 2009 - December 31, 2011. Background:This is an ongoing maintenance agreement for Public Safety-related software which is up for renewal. Analysis:This software maintenance agreement will allow the organization to continue to receive maintenance and support for the New World Systems applications used by various Public Safety Departments to include the Sheriff's Office, E911, and the Fire Department. Financial Impact:The funds are allocated in the 2009 Operating Budget. The costs will be allocated according to the contract for each succeeding year of the agreement unless Augusta purchases additional applications during the contract period. The cost for 2009 is $255,166. Alternatives:N/A Recommendation:Approve Standard Software Maintenance Agreement with New World Systems, Inc. for the period covering January 1, 2009 - December 31, 2011 Funds are Available in the Following Accounts: 101015410.5223110 $184,051 216037110.5223110 $51,682 274034110.5232114 $14,433 REVIEWED AND APPROVED BY: Clerk of Commission Cover Memo Attachment number 1Page 1 of 1 Attachment number 1Page 1 of 1 Attachment number 1Page 1 of 1 Attachment number 1Page 1 of 1 Attachment number 1Page 1 of 1 Public Safety Committee Meeting 3/9/2009 1:30 PM Electronic Warrant Interchange Project Department:Information Technology Caption:Approve contract with Palatine Technology Group to provide software, hardware, and services related to Electronic Warrant Interchange. Background:When a person is arrested and booked, the arresting officer must obtain a warrant from the Warrants Office in the Law Enforcement Center (LEC). Typically, this involves the officer physically going to the office and his/her time is spent working on paperwork as opposed to being on patrol. Richmond County Sheriff's Office personnel, as well as IT personnel and Civil & Magistrate Court staff, have viewed multiple demonstrations of "electronic warrant interchange" (EWI) technology. This involves the use of computer networks, computers, and video cameras in order to shorten the warrant process by eliminating the travel component. Images as well as warrants are transmitted electronically so that the warrant can be obtained more quickly and the deputy can return to duty. Analysis:Palatine Technology Group (PTG) is recognized as a leader in providing EWI technology. The company has a strong presence in Georgia. According to Judge Jennings with Richmond County's Civil & Magistrate Court "based upon my conversations with Judges across Georgia, this is the only system with a proven record of reliability, performance, and safety. As Chief Judge of Civil Court, this is the only system I will consider using." Personnel from IT, the Sheriff's Office, and Civil & Magistrate Court have seen the technology and validated that it will save time and effort on the part of law enforcement personnel. Financial Impact:This project will cost approximately $107,975. The cost of the software/hardware/service contract with the vendor is $71,745. Additional hardware (servers, PCs, and printers)and interface costs between this product and New World will increase the final cost to $107,975. This is funded through approved 2008 IT Capital funds. Alternatives:N/A Recommendation:Approve Contract with Palatine Technology Group to provide software, hardware, and services related to Electronic Warrant Interchange Funds are Available in the Following Accounts: 272015410.5424220 2008 carryover Cover Memo REVIEWED AND APPROVED BY: Procurement. Information Technology. Finance. Law. Administrator. Clerk of Commission Cover Memo Attachment number 1Page 1 of 1 Attachment number 1Page 1 of 1 Attachment number 1Page 1 of 1 Attachment number 1Page 1 of 1 Attachment number 1Page 1 of 1 Attachment number 1Page 1 of 1 Attachment number 1Page 1 of 1 Attachment number 1Page 1 of 1 Attachment number 1Page 1 of 1 Attachment number 1Page 1 of 1 Attachment number 1Page 1 of 1 Attachment number 1Page 1 of 1 Attachment number 1Page 1 of 1 Attachment number 1Page 1 of 1 Attachment number 1Page 1 of 1 Attachment number 1Page 1 of 1 Attachment number 1Page 1 of 1 Attachment number 1Page 1 of 1 Attachment number 1Page 1 of 1 Attachment number 1Page 1 of 1 Attachment number 1Page 1 of 1 Attachment number 1Page 1 of 1 Attachment number 1Page 1 of 1 Attachment number 1Page 1 of 1 Attachment number 1Page 1 of 1 Attachment number 1Page 1 of 1 Attachment number 1Page 1 of 1 Pr o j e c t B u d g e t a n d C o s t s Pr o j e c t El e c t r o n i c W a r r a n t I n t e r c h a n g e I m p l e m e n t a t i o n Ve n d o r Pa l a t i n e T e c h n o l o g y G r o u p ( P T G ) Bu d g e t e d A m o u n t 13 7 , 5 0 0 . 0 0 $ Ac c o u n t N u m b e r s 27 2 0 1 5 4 1 0 . 5 4 2 4 2 2 0 Bu d g e t Y e a r 20 0 8 So f t w a r e a n d I m p l e m e n t a t i o n C o s t s Ve n d o r I n v o i c e s ( a d d C o l u m n s a s N e e d e d ) It e m Co m m e n t s U n i t s Es t i m a t e d U n i t Pr i c e Es t i m a t e d Am o u n t Ac t u a l A m o u n t Ve n d o r / M a n a g e m e n t C o s t s EW I J u s t i c e S u i t e W a r r a n t S e r v e r L i c e n s e F i r s t ye a r ( v e r s i o n 4 . 0 ) PT G - S R V - 1 0 0 0 1 $ 9 , 9 9 5 . 0 0 $ 9 , 9 9 5 . 0 0 $ - EW I S e r v e r S u p p o r t f o r O n e Y e a r , p r o v i d e s au t o m a t i c s o f t w a r e u p g r a d e a t n o c o s t PT G - S U P P O R T 5 1 $ 3 , 5 0 0 . 0 0 $ 3 , 5 0 0 . 0 0 $ - EW I J u s t i c e S u i t e W a r r a n t C l i e n t L i c . (V . 4 . 0 ) i n c l u d i n g S e a r c h W a r r a n t PT G - E W I - C L 1 0 0 8 $ 2 , 4 9 5 . 0 0 $ 1 9 , 9 6 0 . 0 0 $ - EW I J u d g e ' s J u s t i c e S u i t e W a r r a n t C l i e n t L i c . C:\ P r o g r a m F i l e s \ N e e v i a . C o m \ D o c u m e n t C o n v e r t e r \ t e m p \ P D F C o n v e r t . 9 2 0 4 . 1 . E W I P r o j e c t B u d g e t . x l s 3/5 / 2 0 0 9 Pa g e 1 o f 5 EW I J u d g e ' s J u s t i c e S u i t e W a r r a n t C l i e n t L i c . (V . 3 ) i n c l u d i n g S e a r c h W a r r a n t { J u d g e ' s re s i d e n c e s ( 2 ) a n d M a g i s t r a t e C o u r t ( 1 ) } F i r s t y e a r Li c e n s e PT G - E W I - C L 2 0 0 4 $ 3 , 2 9 5 . 0 0 $ 1 3 , 1 8 0 . 0 0 $ - In s t a l l a t i o n i n c l u d e s : I n s t a l l a t i o n o f S e r v e r , O S , Ap p l i c a t i o n s o f t w a r e , V i d e o c o n f e r e n c i n g ha r d w a r e a n d s o f t w a r e a n d t e s t i n g o f a b o v e f o r ma x i m u m p e r f o r m a n c e PT G - I M P - 1 0 0 1 $ 4 , 5 0 0 . 0 0 $ 4 , 5 0 0 . 0 0 $ - EW I S e r v i c e C o n t r a c t f o r a b o v e s y s t e m . O n s i t e an d P h o n e s u p p o r t f o r F i r s t Y e a r ( 2 4 hr s / 7 d a y s / 3 6 5 d a y s a y e a r ) - F i r s t y e a r PT G - S U P P O R T 2 12 $ 8 9 5 . 0 0 $ 1 0 , 7 4 0 . 0 0 $ - EW I T r a i n i n g S e s s i o n ( o n e d a y a t $ 1 5 0 0 p e r d a y ) P T G _ T R N 2 $ 1 , 5 0 0 . 0 0 $ 3 , 0 0 0 . 0 0 $ - Po t e n t i a l N e w W o r l d I n t e r f a c e ( P a l a t i n e p o r t i o n ) No t e : N O T c u r r e n t l y s p e c i f i e d a s p a r t o f c o n t r a c t - t h i s w i l l b e ad d e d a f t e r s y s t e m a n d p r o c e s s i s a s s e s s e d . P r i c e i s a n es t i m a t e . 1 $ 7 , 5 0 0 . 0 0 $ 7 , 5 0 0 . 0 0 $ - Ne w W o r l d I n t e r f a c e ( N e w W o r l d p o r t i o n ) No t e : N O T c u r r e n t l y s p e c i f i e d a s p a r t o f c o n t r a c t - t h i s w i l l b e ad d e d a f t e r s y s t e m a n d p r o c e s s i s a s s e s s e d . P r i c e i s a n es t i m a t e . 1 $ 2 0 , 0 0 0 . 0 0 $ 2 0 , 0 0 0 . 0 0 $ - TO T A L $ 9 2 , 3 7 5 . 0 0 $ - $ - $ - $ - Tr a v e l / M e a l s / L o d g i n g ( b i l l e d a s i n c u r r e d ) It e m Co m m e n t s U n i t s Es t i m a t e d U n i t Pr i c e Es t i m a t e d Am o u n t 0 0 0 0 A c t u a l A m o u n t In c l u d e d a s p a r t o f p r o j e c t c o s t , s o t h e r e s h o u l d be n o b i l l i n g s f o r t h i s u n l e s s w e a s k f o r a d d i t i o n a l tr a i n i n g , e t c . 0 - $ $ - $ - TO T A L T R A V E L / M E A L S / L O D G I N G $ - $ - $ - $ - $ - Ha r d w a r e S u p p l i e d B y V e n d o r C:\ P r o g r a m F i l e s \ N e e v i a . C o m \ D o c u m e n t C o n v e r t e r \ t e m p \ P D F C o n v e r t . 9 2 0 4 . 1 . E W I P r o j e c t B u d g e t . x l s 3/5 / 2 0 0 9 Pa g e 1 o f 5 Attachment number 2Page 1 of 5 Pr o j e c t B u d g e t a n d C o s t s It e m Pa r t # U n i t s Es t i m a t e d U n i t Pr i c e Es t i m a t e d Am o u n t 0 0 0 0 A c t u a l A m o u n t EW I A c c e s s o r i e s P a c k a g e : i n c l u d e s U S B I I c o l o r ca m e r a w i t h e c h o c a n c e l l i n g m i c r o p h o n e , am p l i f i e d s p e a k e r s , S o f t w a r e C o d e c a n d v i d e o co n f e r e n c i n g s o f t w a r e , S i g n a t u r e P a d a n d so f t w a r e . PT G - A C C - 3 0 0 12 $ 5 5 0 . 0 0 $ 6 , 6 0 0 . 0 0 $ - 0 - $ $ - $ - To t a l H a r d w a r e C o s t $ 6 , 6 0 0 . 0 0 $ - $ - $ - $ - Ha r d w a r e S u p p l i e d B y I T It e m No t e s U n i t s Es t i m a t e d U n i t Pr i c e Es t i m a t e d Am o u n t 0 0 0 0 A c t u a l A m o u n t PC 2 i n b o o k i n g , 1 i n C I D , 1 i n N a r c o t i c s , 1 a t P h i n i z y R d 5 $ 1 , 0 0 0 . 0 0 $ 5 , 0 0 0 . 0 0 $ - Pr i n t e r s 1 i n b o o k i n g . A l l o t h e r s s h o u l d b e n e t w o r k e d t o e x i s t i n g pr i n t e r s 1 1 , 0 0 0 . 0 0 $ $ 1 , 0 0 0 . 0 0 $ - Se r v e r 1 3 , 0 0 0 . 0 0 $ $ 3 , 0 0 0 . 0 0 $ - 0 - $ $ - $ - 0 - $ $ - $ - 0 - $ $ - $ - To t a l H a r d w a r e C o s t $ 9 , 0 0 0 . 0 0 $ - $ - $ - $ - In v o i c e T o t a l s $ - $ - $ - $ - Ov e r a l l P r o j e c t T o t a l s Pr o j e c t e d $ 1 0 7 , 9 7 5 . 0 0 A c t u a l $ - C:\ P r o g r a m F i l e s \ N e e v i a . C o m \ D o c u m e n t C o n v e r t e r \ t e m p \ P D F C o n v e r t . 9 2 0 4 . 1 . E W I P r o j e c t B u d g e t . x l s 3/5 / 2 0 0 9 Pa g e 2 o f 5 Ov e r a l l P r o j e c t T o t a l s Pr o j e c t e d $ 1 0 7 , 9 7 5 . 0 0 A c t u a l $ - Ma i n t e n a n c e ( A c c e p t a n c e + 1 5 m o n t h s ) EW I S e r v i c e C o n t r a c t fo r a b o v e s y s t e m . O n s i t e an d P h o n e s u p p o r t f o r F i r s t Y e a r ( 2 4 hr s / 7 d a y s / 3 6 5 d a y s a y e a r ) - F i r s t y e a r PT G - S U P P O R T 2 12 $ 1 , 1 3 5 . 0 0 $ 1 3 , 6 2 0 . 0 0 EW I S e r v e r S u p p o r t f o r O n e Y e a r , p r o v i d e s au t o m a t i c s o f t w a r e u p g r a d e a t n o c o s t PT G - S U P P O R T 5 1 $ 3 , 5 0 0 . 0 0 $ 3 , 5 0 0 . 0 0 Pr o j e c t e d A n n u a l O p e r a t i n g / M a i n t e n a n c e C o s t $1 7 , 1 2 0 . 0 0 Bu d g e t e d A m o u n t 13 7 , 5 0 0 . 0 0 $ Pr o j e c t e d P r o j e c t A m o u n t 10 7 , 9 7 5 . 0 0 $ Pr o j e c t e d B u d g e t S u r p l u s 29 , 5 2 5 . 0 0 $ Am o u n t S p e n t o n P r o f e s s i o n a l S v c s - $ Am o u n t S p e n d o n T r a v e l - $ Am o u n t S p e n t o n H a r d w a r e - $ Am o u n t R e m a i n i n g 13 7 , 5 0 0 . 0 0 $ C:\ P r o g r a m F i l e s \ N e e v i a . C o m \ D o c u m e n t C o n v e r t e r \ t e m p \ P D F C o n v e r t . 9 2 0 4 . 1 . E W I P r o j e c t B u d g e t . x l s 3/5 / 2 0 0 9 Pa g e 2 o f 5 Attachment number 2Page 2 of 5 Pr o j e c t B u d g e t a n d C o s t s 90 D a y s f o l l o w i n g A c c e p t a n c e Mo d u l e Li c e n s e s EW I S e r v e r S u p p o r t 1 EW I S e r v i c e C o n t r a c t On s i t e a n d p h o n e s u p p o r t b e g i n n i n g 2 nd y e a r ( 2 4 h r s / 7 d a y s / 3 6 5 d a y s a y e a r ) Re m a i n i n g Am o u n t PO N u m b e r N o t e s $ ( 9 , 9 9 5 . 0 0 ) $ ( 3 , 5 0 0 . 0 0 ) 15 M o n t h s f o l l o w i n g A c c e p t a n c e $ ( 1 9 , 9 6 0 . 0 0 ) 12 To t a l L i c e n s e F e e C:\ P r o g r a m F i l e s \ N e e v i a . C o m \ D o c u m e n t C o n v e r t e r \ t e m p \ P D F C o n v e r t . 9 2 0 4 . 1 . E W I P r o j e c t B u d g e t . x l s 3/5 / 2 0 0 9 Pa g e 3 o f 5 $ ( 1 3 , 1 8 0 . 0 0 ) Mo d u l e L i c e n s e s $ ( 4 , 5 0 0 . 0 0 ) EW I S e r v e r S u p p o r t 1 $ ( 1 0 , 7 4 0 . 0 0 ) EW I S e r v i c e C o n t r a c t $ ( 3 , 0 0 0 . 0 0 ) On s i t e a n d p h o n e s u p p o r t b e g i n n i n g 2 nd y e a r ( 2 4 h r s / 7 d a y s / 3 6 5 d a y s a y e a r ) $ ( 7 , 5 0 0 . 0 0 ) $ ( 2 0 , 0 0 0 . 0 0 ) $ ( 9 2 , 3 7 5 . 0 0 ) Re m a i n i n g Am o u n t PO N u m b e r N o t e s $ - $ - To t a l L i c e n s e F e e 12 C:\ P r o g r a m F i l e s \ N e e v i a . C o m \ D o c u m e n t C o n v e r t e r \ t e m p \ P D F C o n v e r t . 9 2 0 4 . 1 . E W I P r o j e c t B u d g e t . x l s 3/5 / 2 0 0 9 Pa g e 3 o f 5 Attachment number 2Page 3 of 5 Pr o j e c t B u d g e t a n d C o s t s Re m a i n i n g Am o u n t PO N u m b e r N o t e s $ ( 6 , 6 0 0 . 0 0 ) $ - $ ( 6 , 6 0 0 . 0 0 ) Re m a i n i n g Am o u n t PO N u m b e r N o t e s $ ( 5 , 0 0 0 . 0 0 ) $ ( 1 , 0 0 0 . 0 0 ) $ ( 3 , 0 0 0 . 0 0 ) $ - $ - $ - $ ( 9 , 0 0 0 . 0 0 ) $ ( 1 0 7 , 9 7 5 . 0 0 ) $ 1 3 7 , 5 0 0 . 0 0 C:\ P r o g r a m F i l e s \ N e e v i a . C o m \ D o c u m e n t C o n v e r t e r \ t e m p \ P D F C o n v e r t . 9 2 0 4 . 1 . E W I P r o j e c t B u d g e t . x l s 3/5 / 2 0 0 9 Pa g e 4 o f 5 $ 1 3 7 , 5 0 0 . 0 0 C:\ P r o g r a m F i l e s \ N e e v i a . C o m \ D o c u m e n t C o n v e r t e r \ t e m p \ P D F C o n v e r t . 9 2 0 4 . 1 . E W I P r o j e c t B u d g e t . x l s 3/5 / 2 0 0 9 Pa g e 4 o f 5 Attachment number 2Page 4 of 5 Pr o j e c t B u d g e t a n d C o s t s Co s t P e r L i c e n s e To t a l F e e $3 , 5 0 0 $3 , 5 0 0 $1 4 , 2 4 0 $8 9 5 $ 1 0 , 7 4 0 C:\ P r o g r a m F i l e s \ N e e v i a . C o m \ D o c u m e n t C o n v e r t e r \ t e m p \ P D F C o n v e r t . 9 2 0 4 . 1 . E W I P r o j e c t B u d g e t . x l s 3/5 / 2 0 0 9 Pa g e 5 o f 5 Co s t P e r L i c e n s e T o t a l F e e $3 , 5 0 0 $ 3 , 5 0 0 $1 7 , 1 2 0 $1 , 1 3 5 $ 1 3 , 6 2 0 C:\ P r o g r a m F i l e s \ N e e v i a . C o m \ D o c u m e n t C o n v e r t e r \ t e m p \ P D F C o n v e r t . 9 2 0 4 . 1 . E W I P r o j e c t B u d g e t . x l s 3/5 / 2 0 0 9 Pa g e 5 o f 5 Attachment number 2Page 5 of 5 Attachment number 3Page 1 of 1 Attachment number 3Page 1 of 1 Attachment number 3Page 1 of 1 Attachment number 3Page 1 of 1 Public Safety Committee Meeting 3/9/2009 1:30 PM Information Technology 2008 Annual Report Department:Tameka Allen, Director, Information Technology Department Caption:Receive the Information Technology (IT) 2008 Annual report as information. Background:The Information Technology Department provides the Information Technology Annual Report to all department heads and elected officials each year outlining the technology activities that took place the previous year. Analysis:The Information Technology Annual Report provides informative data as one means to measure the overall performance of the Information Technology Department and its continuous strive to provide the technical tools necessary for the overall organization. Goals are established to motivate the Information Technology Department to maintain current technology, develop and support a stable technology infrastructure, and provide exceptional customer service support. Financial Impact:NA Alternatives:NA Recommendation:Receive the Information Technology (IT) 2008 Annual report as information. Funds are Available in the Following Accounts: NA REVIEWED AND APPROVED BY: Clerk of Commission Cover Memo To: Fred Russell, Administrator Department Heads and Elected Officials From: Tameka Allen, Director, Information Technology Date: March 4, 2009 RE: Information Technology 2008 Annual Report The Information Technology Department (IT) is continuously working to provide our customers with quality technological services and support. Following are a few of the Information Technology Department highlights for the previous year of 2008: IT Customer Satisfaction annual survey demonstrated a 96% approval rating. Conducted 23 days of Camp Data for the City of Augusta youth as part of our continuous outreach efforts. Received an estimated 2,101,975 visitors to www.augustaga.gov Received an estimated 407,233 visitors to GIS Maps Online. Blocked 17,973,680 spam emails and 25,583 virus emails. Migrated from Exchange 2003 server to Exchange 2007 servers. Implemented VMWare Virtual Infrastructure for server virtualization. Installed an HP EVA 4400 SAN for storage expansion. Continued the Information Technology replacement schedule for replacing end of life cycle technology equipment. (Desktops, printers, servers, etc.) GIS staff in conjunction with Augusta State University and Columbia County participated in the nationwide annual GIS Day event. GIS received the 2007 aerial photos from Kucera and updated the Maps Online website with the new aerials. Implemented a new after-hours support protocol to provide better support to our users. Reduced the radio maintenance costs for the county by 17%, resulting in a savings of $30,000. Supervised and negotiated the replacement of 617 obsolete radios with Sprint Nextel. Estimated cost savings to the county exceeded $1.5M. Trained over 317 users in Office Automation. Completed telecommunications audit. Completed ITIL training and certification for first line supervisors. Completed implementation of Cisco 2008 EOS. Upgraded the Information Technology work order system to Track It 8.5. INFORMATION TECHNOLOGY Tameka AllenTameka AllenTameka AllenTameka Allen Director Michael F. BlanchardMichael F. BlanchardMichael F. BlanchardMichael F. Blanchard Gary HewettGary HewettGary HewettGary Hewett Assistant Director Assistant Director Attachment number 1Page 1 of 29 Page 2 Upgraded and replaced the Oracle Database Server. Upgraded and replaced the IFAS – Informix Server. Implemented various modules for the new CLASS Software Recreation Application. (Program Registration, Point of Sale, Touch Screen Monitors, Biometrics, Finance Link, Membership and League Scheduling) Managed and facilitated the enQuesta Web Connect & Pay Connect Implementation for the Utilities Department. Upgraded FBO Manager Merchant Services for Augusta Regional Airport. Implemented .NET Boart of Elections database. Began implementation of the Palatine Electronic Warrant Interchange System. Upgraded the communications for the Coroner’s Office. Upgraded the Blackberry system. Upgraded the Cisco Unity voice mail system. Installed and activated Cisco Unified Operations Manager. Decommissioned Nortel PBX and integrated users to VoIP. Installed power and line protection on county KSU equipment. Migrated EDMS Image storage to UDO Optical storage. Installed the new Symantec Endpoint Protection software. Implemented Microsoft Configuration Manager and deployed it to the county desktops. Implemented Microsoft Operations Manager for server monitoring. Performed analysis and redesign of DBE software to accommodate the new LSBOP. Implemented the Universal Call System application for EMA. Updated the AED Heartstart application at all the fire stations. Continued the implementation and support of the COPLINK application. Implemented EDMS solution for ticket scanning in the Sheriff’s Office. Implemented the New World application upgrade for the Sheriff’s Office. Implemented new database servers for the iaLicense and iaPermits Application for the License & Inspections Department. Implemented IFAS Document Imaging Online. Implemented Phase I of City of Augusta Bid Data Online. Upgraded the communications for the Solid Waste Facility. Implemented the BIS Digital Court Recorder System for the State Court. Completed the Bus Schedule Map for the Transit Department. Upgrade the enQuesta application to version 3e for the Utilities Department. More detailed IT activities by department are on the following pages: Attachment number 1Page 2 of 29 Page 3 ADMINISTRATION º Trained 2 users for 24 hours. º Completed 33 Work Orders. º Provided service and support for 1 portable radio. ANIMAL SERVICES º Trained 4 users for 48 hours. º Completed 25 Work Orders. º Provided service and support for 15 portable radios and 8 mobile data terminals. º Provided ongoing support for the Chameleon Application. º Provided ongoing support for IT related purchases. AUGUSTA CARES º Trained 3 users for 36 hours. º Completed 17 Work Orders. º The GIS Group completed 1 Work Orders for Augusta Cares. º Provided ongoing support for GBA software. º Made modifications to GBA reports. º Provided training and support for the CityView implementation for Code Enforcement. º Provided necessary Code Enforcement reports from the new CityView Application. AUGUSTA LIBRARY º Provided ongoing support for the Encumbrance Application. º Provided ongoing support for the Acquisitions Application. AUGUSTA REGIONAL AIRPORT º Trained 3 users for 36 hours. º Completed 116 Work Orders. º Provided service and support for 101 portables and three repeaters. º Upgraded FBO Manager Merchant Services. º Planned and archived FBO database. º Managed 16 equipment orders. º Began planning process of Excel Sheet migration into web application. º Began conversion of Excel spreadsheets into a flight activity-tracking database. BOARD OF ELECTIONS º Trained 1 user for 12 hours. º Completed 53 Work Orders. º Provided ongoing support for IT related purchases. º Completed implementation of .NET Board of Elections database. CEMETERY - MAGNOLIA º Completed 2 Work Orders. º Provided ongoing support for GBA application. Attachment number 1Page 3 of 29 Page 4 º Provided ongoing support and modifications of the Graveside Cemetery Management program. CEMETERY- WESTVIEW º Provided ongoing support for GBA application. CIVIL & MAGISTRATE COURT º Completed 60 Work Orders. º Managed 1 order related to IT equipment or software. º Began implementation of the Palatine Electronic Warrant Interchange system. º Provided ongoing support for the New World application. º Provided ongoing support for all IT purchases and services. º Replaced 10 computers. CIVIL & MAGISTRATE COURT - WARRANTS º Completed 31 Work Orders. º Responded to and closed 21 application related work orders. º Provided ongoing support for Warrant-specific applications. º Provided ongoing support for the New World application. º Provided ongoing support for all IT purchases and services. º Replaced 2 computers. CIVIL & MAGISTRATE COURT- JUDGE º Completed 10 Work Orders. º Provided ongoing support for the New World application. º Provided ongoing support for all IT purchases and services. º Replaced 4 computers. CLERK OF CIVIL & MAGISTRATE COURT º Completed 1 work order. º Provided ongoing support for the New World application. º Provided ongoing support for all IT purchases and services. º Investigated the need for a custom New World report. º Responded to and closed 20 application related work orders. º Expansion of department. CLERK OF COMMISSION º Completed 13 Work Orders. º Provided ongoing support for MuniAgenda application. º Replaced 2 computers. º Operated the Voting and Presentation System during Commission Meetings. CLERK OF COURT º Trained 14 users for 168 hours. º Completed 97 Work Orders. Attachment number 1Page 4 of 29 Page 5 º Provided ongoing support for the New World application. º Responded to and closed 85 application related work orders. º Provided ongoing support for the ICON application. º Managed 3 orders related to IT equipment or software. º Conducted monthly status meetings to stay on top of all IT needs. º Provided ongoing support for IT related purchases. º Provided ongoing support for the CDIMS Applications. º Provided ongoing support for the COTT Applications. º Processed multiple security requests. º Created Miscellaneous Grantor/Grantee Index Report for COTT. º Provided troubleshooting for large Plat Scanner and other Scanners. º Provided ongoing support for the FiFa Interface process. º Installed CDIMS Web Public for multiple County departments. º Implemented new database server for CDIMS Applications. º Set up multiple users for the large Plat Scanner. º Relocated the High Tech Payments application as needed. º Provided support for the Windows XP upgrade for client workstations. º Provided support for the replacement of the Print/FAX Server. º Installed a new modem for the Print/FAX Server. º Installed one HP LJ 4350n printer. CLERK OF STATE COURT - LEC º Completed 28 Work Orders. CORONER`S OFFICE º Trained 3 users for 36 hours. º Completed 21 Work Orders. º Provided service and support for 5 portable radios. º Provided ongoing support for all IT purchases and services. º Provided ongoing support for Coroner-specific application systems. º Responded to and closed 4 application related work orders. º The Network Group switched the Coroner’s office from a T-1 to Altanga wireless for connectivity. º Replaced 3 computers. º Provided support for Coroner's Software Application. COUNTY ATTORNEY º Completed 9 Work Orders. º Relocation to new building. DANIEL FIELD AIRPORT-OPERATION º Completed 1 Work Orders. º The Network Group installed a wireless bridge to Utilities Central Avenue for network connectivity. DISADVANTAGED BUSINESS ENTERPRISE º Completed 8 Work Orders. º Performed Analysis and Redesign of DBE software to accommodate the new LSBOP. Attachment number 1Page 5 of 29 Page 6 DISTRICT ATTORNEY º Trained 2 users for 24 hours. º Completed 170 Work Orders. º Provided ongoing support for all IT purchases and services. º Provided ongoing support for the New World application. º Provided ongoing support for the Prosecutor's Dialog application. º Responded to and closed 62 application related work orders. º Managed 6 orders related to IT equipment or software. º Replaced 34 computers. º Replaced 2 Scanners. DISTRICT ATTORNEY VICTIM`S ASSISTANCE º Completed 8 Work Orders. º Replaced 1 computer. E911 DISPATCH º Trained 2 users for 24 hours. º Completed 75 Work Orders. º Provided service and support for 12 dispatch positions. º Provided service and support for 27 radios. º Supervised the installation of a new Fire Station Alerting System. º Modified 12 dispatch positions to pull their central database from a local server instead of going to Columbia resulting in a more stable database location. º GIS completed 2 Work Orders for E-911. º Upgraded the ProQA application. º Installed and Updated the New World / ProQA Interface. º Implemented an Application Training Environment for the ProQA and New World applications. º Provided ongoing support for the Cross Search application. º Provided ongoing support for all the ProQA applications. º Updated the 3SI Security Systems Tracker. º Updated the Cross Search application on a quarterly basis. º Assisted with the Freedom Call application updates and support. º Upgraded the AQUA application to the latest version. º Provided ongoing support for all IT purchases and services. º Provided ongoing support for the New World CAD application. º Responded to and closed 32 application related work orders. º Managed 3 orders related to IT equipment or software. º Assisted with the development of an automated Wrecker rotation application. º The Network Group installed a cable modem and wireless VPN access for E-911 training. EMERGENCY MANAGEMENT AGENCY º Completed 10 Work Orders. º Provided service and support for 10 radios. º Implemented the Universal Call System application. º Provided ongoing support for all IT purchases and services. º Managed 1 order related to IT equipment or software. º Responded to and closed 1 application related work order. º The Network Group installed a cable modem and wireless internet access for the EMA EOC Room. Attachment number 1Page 6 of 29 Page 7 ENGINEERING º Completed 13 Work Orders. º Provided service and support for 21 radios. º Provided coordination of IT purchases and services based on user needs. º Provided ongoing support for GBA application. º Provided ongoing support for GBA applications. º Managed 17 equipment orders. ENGINEERING - TRAFFIC ENGINEERING º Provided service and support for 30 radios. º Processed 3 orders. EQUAL OPPORTUNITY EMPLOYMENT º Trained 1 user for 12 hours. º Completed 33 Work Orders. º Managed equipment order for laptop floppy drive. º Processed 1 order. EXTENSION SERVICES º Installed new infrastructure and telephone KSU. º Completed 11 Work Orders. º The Network Group installed a cable modem and a PIX/VPN for network connectivity. º Processed 1 order. FINANCE ACCOUNTING º Completed 34 Work Orders. º 1 In - House maintenance request completed. º Processed 2 orders. º Installed one HP LJ M3027x MFP copier/scanner. º Replaced 1 Computer. FINANCE DEPARTMENT º Completed 50 Work Orders. º Roll JL accounts from year 2007 to 2008 º Modified and completed Budget Item Detail process for 2008. º Managed 5 equipment orders. º Processed 9 orders. FIRE DEPARTMENT ADMINISTRATION º Trained 9 users for 108 hours. º Completed 104 Work Orders. º Provided service and support for 358 radios. º Supervised the installation of a new alerting system at all the fire stations. Attachment number 1Page 7 of 29 Page 8 º Provided training to all fire personnel on the operation of the mobile data terminals in the trucks. º Provided service and support for 27 radios with EMS. º Began Implementation of the FireHouse software application to be completed in 2009. º Provided ongoing support for all IT purchases and services. º Provided ongoing support for the Emergency Reporting Software. º Responded to and closed 39 application related work orders. º Managed 12 orders related to IT equipment or software. º Decommissioned the Fire Programs (Arrakis) application. º Updated the AED Heartstart application at all the Fire Stations. º Processed 9 orders. FIRE PREVENTION º Provided ongoing support for all IT purchases and services. FIRE STATION #1 º Trained 10 users for 120 hours. º Trained 10 users for 120 hours. º Completed 16 Work Orders. FIRE STATION #10 º Completed 10 Work Orders. FIRE STATION #11 º Completed 6 Work Orders. FIRE STATION #12 º Completed 2 Work Orders. FIRE STATION #13 º Completed 13 Work Orders. FIRE STATION #14 º Completed 4 Work Orders. FIRE STATION #15 º Completed 7 Work Orders. FIRE STATION #16 º Completed 7 Work Orders. Attachment number 1Page 8 of 29 Page 9 FIRE STATION #17 º Completed 7 Work Orders. FIRE STATION #18 º Completed 5 Work Orders. FIRE STATION #19 º Completed 3 Work Orders. FIRE STATION #2 º Completed 3 Work Orders. FIRE STATION #3 º Completed 48 Work Orders. FIRE STATION #4 º Trained 1 user for 12 hours. º Completed 2 Work Orders. FIRE STATION #5 º Trained 1 user for 12 hours. º Completed 13 Work Orders. FIRE STATION #6 º Completed 10 Work Orders. º 1 In - House maintenance request completed. FIRE STATION #7 º Completed 9 Work Orders. FIRE STATION #8 º Completed 31 Work Orders. FIRE STATION #9 º Completed 7 Work Orders. FLEET - MANAGEMENT º Trained 4 users for 48 hours. º Provided service and support for 16 radios. º Managed the procurement of two All-In-One printers. Attachment number 1Page 9 of 29 Page 10 º Processed 2 order. FLEET MAINTENANCE - LUMPKIN ROAD º Completed 10 Work Orders. FLEET MAINTENANCE - TOBACCO RD. º Trained 1 user for 12 hours. º Completed 2 Work Orders. FLEET OPERATIONS & MAINTENANCE º Completed 56 Work Orders. º 1 In - House maintenance request completed. FORESTRY º Provided ongoing support for IT related purchases. º Processed 1 order. HOUSING & COMMUNITY DEVELOPMENT º Trained 3 users for 36 hours. º Completed 14 Work Orders. º Relocated sub-office to Telfair Street. º Assisted with evaluation and planning of In-house software application to replace SpecRight. º Researched and completed Technology Plan for department. º Provided coordination of IT purchases and services based on user needs. º Expansion of facility to accommodate new employees. HOUSING & ECONOMIC DEVELOPMENT º Completed 104 Work Orders. º The Network Group installed a cable modem and a PIX/VPN for network connectivity at the Telfair Street location. º Processed 8 orders. HUMAN RELATIONS COMMISSION º Completed 32 Work Orders. º Provided ongoing MuniAgenda support. º Assisted with IMS access problems. º Made modifications to customer MS Access database after Office2007 upgrade. HUMAN RESOURCES º Trained 3 users for 36 hours. º Completed 52 Work Orders. º Created CDD reports in IFAS to assist with new pension conversion. º Provided ongoing IFAS support. Attachment number 1Page 10 of 29 Page 11 º Researched and began planning for process to reconcile BCBS billing. º Began research and planning process for HR Technology Plan. º Began planning process for implementation of Employee OnLine application to be completed in 2009. º Provided coordination of IT purchases based on user needs. º Generated reports from IFAS data. º Began planning process for implementation of NeoGov web application to be completed in 2009. º Implemented IFAS Document Imaging for Employee Records. º Replaced 9 computers. º Processed 6 orders. º Replaced 1 Laptop. INFORMATION TECHNOLOGY º Trained 317 users for 3748 hours in Office Automation. º Conducted 23 days of Camp Data for 84 youth for the City of Augusta º CSS completed 525 Work Orders. º Completed ITIL training and certification at first line supervisor level. º Upgraded Blackberry system. º Telecom completed 711 Work Orders. º Ongoing updates to online phone directory. º Attended Visio training. º Completed Blackberry support agreement. º Provided E911 e-mail to departments. º Decommissioned four T-1 circuits. º Upgraded Cisco Unity voice mail system. º Completed 2008 inventory control. º Completed 2008 inventory. º Completed Intrado (E911) testing. º Decommissioned Nortel PBX and moved users to VoIP. º Installed power and line protection on county KSU Equipment. º Updated 2008/09 AT&T White Pages. º Installed and activated Cisco Unified Operations Manager. º Completed Cisco 2008 EOS. º Upgraded Cisco Unified Communications Manager. º Completed Telecom Audit. º 2,101,975 visitors to www.augustaga.gov. º Blocked 17,973,680 spam emails. º Blocked 25,583 virus emails. º 407,233 visitors to GIS Maps Online. º Upgraded and Replaced External DNS Server º Upgraded and Replaced Primary AS400 for the E911 and Jail Management º Upgraded to Track-it8.5 for IT internal use. º Upgraded and Replaced Oracle Database Server º Upgraded and Replaced IFAS - Informix Server º Migrated EDMS Image storage to Newer Technology UDO Optical Storage. º Processed 1,697 website update requests. º Completed update of current inventory with all communication equipment. º Reduced maintenance costs to the County by 17% resulting in a savings of $30,000.00 º Supervised and negotiated the replacement of 617 obsolete radios with Sprint Nextel. Estimated cost savings to the County exceeded 1.5 million dollars. º The GIS Group completed 3 Work Orders for Information Technology. º The GIS Group along with Augusta State University and Columbia County participated in the world Attachment number 1Page 11 of 29 Page 12 wide annual GIS Day Event November 19th. º GIS received the 2007 Aerial Photos from Kucera and updated the Maps on Line website to reflect the 2002 and 2007 aerials. º GIS contracted with Pictometry to bring oblique aerial photography for the 2009 upgrade of Maps on line. º The GIS Group upgraded the ESRI software to version 9.3 for various departments in the City. º GIS has contracted with Web-GIS Solutions to update the Maps on Line Website to a new version and new software enabling Apple computers to access the web site. º Provided ongoing support for MuniAgenda application. º Assisted with migration to new IFAS UNIX server on 10-18-2008. º Upgraded IFAS application to version 7.7.2. º Began planning process for implementing upgrade of IFAS 7i Core Financials implementation. º Began IFAS 7i testing. º Assisted with planning and implementing moving the GBA database to a new server. º The Network Group installed the new Symantec Endpoint Protection software and deployed it to the City's PCs. º The Network Group upgraded the Cisco LMS product for infrastructure monitoring. º The Network Group successfully implemented Microsoft Configuration Manager and deployed clients to desktops. º The Network Group successfully implemented Microsoft Operations Manager for server monitoring. º The Network Group successfully migrated from one Exchange 2003 server to three Exchange 2007 servers. º The Network Group implemented the APC UPS monitoring solution for proactive closet power issue resolution. º The Network Group implemented VMWare Virtual Infrastructure for server virtualization. º The Network Group installed an HP EVA 4400 SAN for storage expansion. º The Network Group coordinated the installation of 202 network cables. º The Network Group replaced 10 bad network switches. º The Network Group supported 102 servers. º The Network Group supported 13 applications. º The Network Group installed 14 servers. º The Network Group deleted 132 network accounts. º The Network Group created 33 email accounts. º The Network Group completed 1556 work orders. º The Network Group created 333 network accounts. º Processed 118 orders. º Replaced 49 computers. º Replaced 9 Laptops. º 4 In - House maintenance requests completed. º Selected CivicPlus as the vendor to update web site design and implement content management solution. JURY CLERK º Completed 8 Work Orders. º Provided ongoing support for all IT purchases and services. º Provided ongoing support for the Jury System application. JUVENILE COURT º Completed 14 Work Orders. º Provided ongoing support for the JCATS application. Attachment number 1Page 12 of 29 Page 13 º Provided ongoing support for all IT purchases and services. º Responded to and closed 8 application related work orders. º Replaced 7 computers. LANDBANK AUTHORITY º Processed 1 order. LAW DEPARTMENT º Completed 67 Work Orders. º Managed 10 orders related to IT equipment or software. º Responded to and closed 3 application related work orders. º Provided ongoing support for all IT purchases and services. º Began Implementation of the Abacus Law application to be completed in 2009. º Installed WinGAP Application - Guest access. º Installed VCS Tax 2000 Application - Inquiry Access. º Installed Clerk of Court Web Public Application. º Processed 5 orders. LAW LIBRARY º Completed 2 Work Orders. LICENSE & INSPECTION º Trained 1 user for 12 hours. º Completed 156 Work Orders. º Provided service and support for 42 radios. º GIS completed 1 Work Orders for L & I. º Converted, tested, trained and provided support for the CityView implementation for Code Enforcement. º Provided support for the annual Alcohol License Renewals. º Provided support for the annual Business License Renewals. º Provided support for the annual Urgent Reminder process. º Provided ongoing support for the CityView Application for Code Enforcement. º Provided ongoing support for the iaLicense Application. º Provided ongoing support for the iaPermits Application. º Conducted monthly status meetings to stay on top of all IT needs. º Provided ongoing support for IT related purchases. º Created digital copies of the Special Inspection Program Forms. º Created Permit Construction Projects spreadsheet to replace manual tracking. º Created Stop Work Order spreadsheet to replace manual tracking. º Created multiple reports for Code Enforcement within the CityView Application. º Created multiple reports within the iaLicense Application. º Evaluated performance of computers to accommodate the new CityView Application. º Implemented new database server for iaLicense Application. º Implemented new database server for iaPermits Application. º Ensured backup procedures were in place for the new CityView Application. º Evaluated, Ordered and Installed necessary hardware for the CityView implementation. º Processed 6 orders. º Coordination of carpet installation. Attachment number 1Page 13 of 29 Page 14 º Setup of training lab. º Coordinated office expansion. º Replaced 31 computers. º 2 In - House maintenance requests completed. º Coordination of painting of offices. MARSHAL SUBSTATION º Completed 11 Work Orders. º Installed one HP L1965 monitor. MARSHAL`S DEPARTMENT º Trained 10 users for 120 hours. º Completed 59 Work Orders. º Provided service and support for 62 radios and 6 MDT units. º Implemented the Live Scan Fingerprinting system. º Moved the Marshal Integrated System application to a new server. º Managed 6 orders related to IT equipment or software. º Responded to and closed 7 application related work orders. º Provided ongoing support for all IT purchases and services. º Provided ongoing support for the New World application. º Provided ongoing support for the Marshal Integrated System application. º Relocation of the department. º Processed 7 orders. º Installed one HP L2065 monitor. º Replaced 4 computers. MAYOR º Trained 1 user for 12 hours. º Completed 22 Work Orders. º Replaced 1 Laptop, Docking Station, and Monitor. º Processed 2 orders. NEIGHBORHOOD ENHANCEMENT º Completed 12 Work Orders. º Provided coordination and managed IT purchases based on user needs. º Began planning process on future technology needs. º Processed 2 orders. OLD GOVERNMENT HOUSE º Completed 4 Work Orders. PAYROLL º Completed 27 Work Orders. º Moved 85 employees to new minimum wage of $6.55/hour º Applied $2000 ATB increase to Public Safety employees Attachment number 1Page 14 of 29 Page 15 º Processed Magnetic Media for 1099 and W2's º Updated poll worker pay rates effective 2-5-08 payroll. º Applied 3% COLA to County Employees Effective 2-1-08 º Processed W2's and 1099's for year 2007 º Assisted with GMEBS and pension deductions during implementation of new pension plan. º 1 In - House maintenance request completed. PLANNING & ZONING º Trained 7 users for 84 hours. º Completed 48 Work Orders. º The GIS Group completed 9 Work Orders for Planning and Zoning. º The GIS Group has taken over the updating of the Zoning Maps from Planning and Zoning. º Processed 3 orders. PRINT SHOP º Completed 9 Work Orders. º Replaced 1 computer. PROBATE COURT º Trained 3 users for 36 hours. º Completed 37 Work Orders. º Provided ongoing support for the Probate application. º Provided ongoing support for all IT purchases and services. º Responded to and closed 4 application related work orders. º Processed 1 order. º Replaced 1 computer. º 3 In - House maintenance requests completed. º Performed modifications to existing Probate Software Application. PROBATION º Completed 32 Work Orders. º Provided ongoing support for all IT purchases and services. º Provided ongoing support for the New World application. º Responded to and closed 9 application related work orders. PROCUREMENT º Trained 2 users for 24 hours. º Completed 50 Work Orders. º Implemented IFAS Document Imaging Online. º Implemented Phase I of City of Augusta Bid Data Online. º Applied year end changes. º Generated reports form IFAS data. º Provided ongoing support for IFAS application. º Replaced 7 computers. º Processed 6 orders. º Replaced 1 Laptop. Attachment number 1Page 15 of 29 Page 16 PUBLIC DEFENDER º Trained 3 users for 36 hours. º Completed 191 Work Orders. º Provided ongoing support for all IT purchases and services. º Provided ongoing support for the New World application. º Provided ongoing support for the JCATS application. º Responded to and closed 80 application related work orders. º Managed 1 order related to IT equipment or software. º Processed 1 order. PUBLIC SERVICES º Trained 2 users for 24 hours. º Completed 31 Work Orders. º Updated pay rates in the GBA application. º Provided ongoing support for GBA application. º Made modifications to GBA reports. º Replaced 6 computers. º Processed 3 orders. PUBLIC SERVICES - FACILITIES MANAGEMENT º Trained 7 users for 76 hours. º Completed 8 Work Orders. º Provided service and support for 30 radios. º Processed 2 orders. PUBLIC SERVICES - FACILITIES MANAGEMENT-B&G-JLE º Completed 2 Work Orders. PUBLIC SERVICES - FACILITIES MANAGEMENT-B&G-MUNICI º Completed 8 Work Orders. PUBLIC SERVICES - FACILITIES MANAGEMENT-CONSTRUCTI º Installed Emergency Call Box at 8th Street water fountain. º Provided service and support for 67 radios. PUBLIC SERVICES - LANDFILL º Provided service and support for 5 radios. PUBLIC SERVICES - MAINTENANCE º Completed 1 Work Orders. º Provided ongoing support for GBA application. º Managed equipment order for telephone headset. º Replaced 2 computers. º Processed 1 order. Attachment number 1Page 16 of 29 Page 17 PUBLIC SERVICES - ROADS & BRIDGES º Trained 1 user for 12 hours. º Completed 3 Work Orders. º 1 In - House maintenance request completed. PUBLIC SERVICES - TREES AND LANDSCAPES º Trained 3 users for 28 hours. º Provided service and support for 36 radios. º Provided ongoing support for GBA application. º Researched and managed order for landscape design software. º The Network Group installed a cable modem and a PIX/VPN for network connectivity at Eastview Cemetery. PUBLIC WORKS º GIS completed 4 Work Orders for Public Works. PUBLIC WORKS - ENGINEERING º Completed 91 Work Orders. º 1 In - House maintenance request completed. PUBLIC WORKS - LANDFILL º Completed 59 Work Orders. º Relocated Solid Waste scalehouse telephones. PUBLIC WORKS - MARVIN GRIFFIN º Completed 27 Work Orders. PUBLIC WORKS - PRE-CONSTRUCTION º Completed 12 Work Orders. PUBLIC WORKS - STREET LIGHTING º Completed 4 Work Orders. PUBLIC WORKS - TOBACCO ROAD º Completed 18 Work Orders. PUBLIC WORKS - TRAFFIC ENGINEERING º Completed 52 Work Orders. RCCI º Completed 40 Work Orders. Attachment number 1Page 17 of 29 Page 18 º Provided service and support for 42 radios. º Provided ongoing support for all IT purchases and services. º Responded to and closed 3 application related work orders. º Managed 2 orders related to IT equipment or software. º Implemented Cell PhoneTracking system at RCCI. º Processed 3 orders. º Replaced 3 computers. RECORDS RETENTION º Completed 1 Work Orders. RECREATION - ADMIN º Trained 26 users for 312 hours. º Provided service and support for 51 radios. RECREATION - ADMINISTRATION º Completed 152 Work Orders. º Processed multiple security requests. º Setup CLASS on-line reconciliation of Active Network payment checks. º Implemented multiple reports within the CLASS Application. º Performed a CLASS Upgrade to version 6.2. º Implemented the new CLASS Software Application for Program Registration. º Implemented the new CLASS Software Application for Point-of-Sale. º Implemented the new CLASS Software Application for Touch Screen Monitors. º Implemented the new CLASS Software Application for Biometrics. º Implemented the new CLASS Software Application for Finance Link. º Implemented the new CLASS Software Application for Membership. º Implemented the new CLASS Software Application for League Scheduling. º Provided connectivity for 22 Recreation sites for the CLASS implementation. º Provided ongoing support for the CLASS Application. º Ensured backup procedures were in place for the new CLASS Application. º Provided ongoing support for IT related purchases. º Processed 4 orders. RECREATION - AQUATIC CENTER º Completed 20 Work Orders. º The Network Group installed a cable modem and PIX/VPN for network connectivity. º Processed 1 order. RECREATION - AQUATICS º Installed Emergency Call Box at Woods Water Park. RECREATION - AUGUSTA GOLF COURSE º Completed 1 Work Orders. Attachment number 1Page 18 of 29 Page 19 º Moved the Golf Course Server to IT. º Setup Golf eNetwork (GeN) Trainer environment. º Installed CLASS on Golf Course computers to facilitate Augusta Wellness Program. º Provided ongoing support for the Golf eNetwork (GeN) Application. º Performed a Golf eNetwork (GeN) Upgrade to version 8.3. º The Network Group installed a cable modem and PIX/VPN for network connectivity. º Processed 1 order. RECREATION - BERNIE WARD CERAMIC º Trained 1 user for 12 hours. RECREATION - BERNIE WARD COMMUNITY CENTER º Completed 2 Work Orders. º The Network Group installed a cable modem and PIX/VPN for network connectivity. º Processed 1 order. RECREATION - BLYTHE PARK º Completed 2 Work Orders. º The Network Group installed a cable modem and PIX/VPN for network connectivity. RECREATION - CARRIE J. MAYS º Trained 3 users for 36 hours. º Completed 2 Work Orders. º The Network Group installed a cable modem and PIX/VPN for network connectivity. º Processed 2 orders. RECREATION - DIAMOND LAKES º Trained 1 user for 12 hours. º Completed 2 Work Orders. º Assisted with setup of the remote monitor/maintenance system for the HVAC. º Processed 2 orders. RECREATION - EISENHOWER PARK º Completed 1 Work Orders. º The Network Group installed a cable modem and PIX/VPN for network connectivity. º Processed 3 orders. RECREATION - FLEMING ATHLETIC OFFICE º Completed 1 Work Orders. º The Network Group installed a wireless bridge set to Bernie Ward for network connectivity. º Processed 1 order. Attachment number 1Page 19 of 29 Page 20 RECREATION - GARRETT COMMUNITY CENTER º Completed 3 Work Orders. º The Network Group installed a cable modem and PIX/VPN for network connectivity. RECREATION - H.H. BRIGHAM COMMUNITY CENTER º Completed 4 Work Orders. º The Network Group installed cabling from the Senior Center to the Gymnasium for network connectivity. º Processed 3 orders. RECREATION - H.H. BRIGHAM SENIOR º Completed 3 Work Orders. º The Network Group installed a cable modem and PIX/VPN for network connectivity. RECREATION - H.H. BRIGHAM SWIM COMPLEX º Completed 1 Work Orders. º The Network Group installed cabling from the Gymnasium to the Swim Center for network connectivity. RECREATION - MAY PARK COMMUNITY º The Network Group installed a cable modem and PIX/VPN for network connectivity. RECREATION - MAY PARK COMMUNITY CENTER º Completed 3 Work Orders. º Processed 2 orders. RECREATION - MCBEAN PARK º Trained 1 user for 12 hours. º Completed 3 Work Orders. º The Network Group installed a cable modem and PIX/VPN for network connectivity. RECREATION - MCDUFFIE WOODS PARK º Completed 2 Work Orders. º The Network Group installed a cable modem and PIX/VPN for network connectivity. º Processed 2 orders. º Setup of new training lab. º Setup of new Sheriff's substation. RECREATION - MINNICK PARK º Trained 3 users for 36 hours. Attachment number 1Page 20 of 29 Page 21 RECREATION - NEWMAN TENNIS CENTER º Completed 13 Work Orders. º Processed 5 orders. RECREATION - SAND HILLS COMMUNITY CENTER º Completed 1 Work Orders. º The Network Group installed a cable modem and PIX/VPN for network connectivity. º Processed 1 order. º Expansion project for new program. RECREATION - WARREN ROAD COMMUNITY CENTER º The Network Group installed a cable modem and PIX/VPN for network connectivity. º Processed 1 order. º Expansion of network at facility. RECREATION - WOOD STREET PARK º Setup new facility. º Processed 1 order. RISK MANAGEMENT º Trained 1 user for 12 hours. º Completed 47 Work Orders. º Managed 3 equipment orders. º Replaced 4 computers. º Installed one Canon DR2580 Color Scanner. º Processed 1 order. º 1 In - House maintenance request completed. º Completed multiple modifications to the RiskNET software program. RIVERWALK SPECIAL EVENTS º Completed 4 Work Orders. º Processed 15 orders. SHERIFF`S OFFICE - ADMINISTRATION º Trained 1 user for 12 hours. º Completed 85 Work Orders. º Provided service and support for 640 radios. º Provided service and support for 268 MDT units. º Installed 77 new computers and hardware, replacing obsolete equipment. Generating a cost savings of $7,700.00 to the County. º Continued the Implementation and Support of the COPLINK application. º Provided ongoing support for all IT purchases and services. º Managed 31 orders related to IT equipment or software. º Responded to and closed 18 application related work orders. º Implemented EDMS solution for Ticket scanning. Attachment number 1Page 21 of 29 Page 22 º Provided ongoing support for the New World application. º Implemented New World upgrade to version 8.0.4. º Installed QuickBooks 2008 for 'petty' fund tracking. º Implemented New World upgrade to version 8.0.5. º Replaced 16 computers. º Relocation of the Sheriff Financial Department to new facility. º Processed 8 orders. º 1 In - House maintenance request completed. SHERIFF`S OFFICE - BAILIFFS º Completed 4 Work Orders. º Replaced 1 computer. SHERIFF`S OFFICE - BOOKING º Completed 90 Work Orders. º Provided ongoing support for the New World application. º Responded to and closed 57 application related work orders. º Implemented new Camera System for the Booking Station. º Provided support as needed for the Identix Fingerprinting system. º Replaced 7 computers. º Processed 2 orders. SHERIFF`S OFFICE - CID º Trained 4 users for 48 hours. º Completed 282 Work Orders. º Provided ongoing support for the New World application. º Provided ongoing support for the Data Analysis and Mapping application. º Provided support as needed for CID specific applications. º Responded to and closed 92 application related work orders. º Installed Tag Search Application on multiple computers. º Replaced 52 computers. º Replaced 4 Laptops. º 4 In - House maintenance requests completed. º Performed modifications of EDMS application to enable additional scanning features. SHERIFF`S OFFICE - CIVIL º Completed 20 Work Orders. º Provided ongoing support for the New World application. º Responded to and closed 7 application related work orders. º Replaced 6 computers. SHERIFF`S OFFICE - CRIME SCENE º Completed 14 Work Orders. º Responded to and closed 1 application related work order. º Ordered new Video Conversion software. Attachment number 1Page 22 of 29 Page 23 º Provided ongoing support for the New World application. º Processed 1 order. º Replaced 3 computers. º Replaced 1 Laptop (Reassigned to CID). SHERIFF`S OFFICE - DANIEL VILLAGE º Trained 1 user for 12 hours. º Completed 72 Work Orders. º Responded to and closed 9 application related work orders. º Provided ongoing support for the New World application. º Processed 2 orders. º Replaced 8 computers. º 2 In - House maintenance requests completed. SHERIFF`S OFFICE - DARE º Trained 3 users for 36 hours. º Completed 15 Work Orders. º 2 In - House maintenance requests completed. º Processed 1 order. º Replaced 6 computers. SHERIFF`S OFFICE - EVIDENCE º Completed 4 Work Orders. º Provided ongoing support for the New World application. º Responded to and closed 3 application related work orders. º Processed 1 order. º Replaced 1 computer. SHERIFF`S OFFICE - INTERNAL AFFAIRS º Completed 8 Work Orders. º Responded to and closed 3 application related work orders. º Provided ongoing support for the New World application. º Replaced 2 computers. SHERIFF`S OFFICE - JAIL ADMIN º Trained 1 user for 12 hours. º Completed 88 Work Orders. º Provided ongoing support for the New World application. º Responded to and closed 140 application related work orders. º Processed 4 orders. º Replaced 5 computers. º Replaced 1 Laptop. Attachment number 1Page 23 of 29 Page 24 SHERIFF`S OFFICE - K-9 º Completed 4 Work Orders. SHERIFF`S OFFICE - NARCOTICS º Trained 1 user for 12 hours. º Completed 52 Work Orders. º Responded to and closed 16 application related work orders. º Provided ongoing support for the New World application. º Assisted in providing a custom OS reinstallation solution for Data-Sensitive projects. º Assisted in providing Narcotics with Internet Access outside of the Augusta Infrastructure. º Installed Business License Inquiry Application for Greg Meagher. º Processed 2 orders. º Replaced 7 computers. º 2 In - House maintenance requests completed. º Replaced 1 Scanner. SHERIFF`S OFFICE - PHINIZY º Trained 1 user for 12 hours. º Completed 71 Work Orders. º Provided ongoing support for the New World application. º Responded to and closed 29 application related work orders. º Processed 2 orders. º Replaced 12 computers. º Installed one HP LJ 3005n printer. º 1 In - House maintenance request completed. SHERIFF`S OFFICE - QUARTERMASTER º Responded to and closed 1 application related work order. º Provided ongoing support for the New World application. º Replaced 1 computer. SHERIFF`S OFFICE - RECORDS º Completed 142 Work Orders. º Responded to and closed 109 application related work orders. º Provided ongoing support for the New World application. º Provided ongoing support for the DataMaxx application. º Processed 1 order. º Replaced 10 computers. º 1 In - House maintenance request completed. º Replaced 7 Scanners. SHERIFF`S OFFICE - SOUTHGATE º Completed 66 Work Orders. º Responded to and closed 11 application related work orders. º Provided ongoing support for the New World application. º Processed 1 order. Attachment number 1Page 24 of 29 Page 25 º Replaced 8 computers. SHERIFF`S OFFICE - TRAINING CENTER º Completed 9 Work Orders. º Replaced 2 Laptops. º Replaced 1 computer. º Processed 1 order. º The Network Group installed a cable modem at the Myers Building for internet connectivity. º The Network Group installed a cable modem at the EVOC Building for internet connectivity. º The Network Group installed a cable modem at the K-9 Building for internet connectivity. º The Network Group installed a cable modem at the Armory Building for internet connectivity. SOLICITOR GENERAL º Trained 13 users for 156 hours. º Completed 145 Work Orders. º Provided ongoing support for all IT purchases and services. º Provided ongoing support for the New World application. º Responded to and closed 99 application related work orders. º Provided ongoing support for the Prosecutor's Dialog application. º Replaced 32 computers. º Replaced 3 Scanners. º 2 In - House maintenance requests completed. SOLICITOR GENERAL VICTIM`S ASSISTANCE º Completed 31 Work Orders. º Provided support as needed for the Freedom Call application. º Replaced 6 computers. SOLID WASTE LANDFILL º Trained 17 users for 204 hours. º Relocated call detail recording equipment and infrastructure. º Completed 12 Work Orders. º Provided ongoing support for GBA application. º Planned, managed, and implemented Phase II of Insight Environmental application. º Provided coordination of IT purchases and services based on user needs. º Provided ongoing MuniAgenda support. º The Network Group switched the Solid Waste Facility from a T-1 to Altanga wireless for connectivity. º The Network Group installed new hardware and connectivity for the new Scale House. º The Network Group installed a new 48 port switch in the Administration building for expansion. º Coordination of cabling for new scale house. º Processed 10 orders. º 3 In - House maintenance requests completed. STATE COURT JUDGE º Completed 21 Work Orders. º Coordinated IT purchases and services based on user needs and requests. º Managed 1 order related to IT equipment or software. Attachment number 1Page 25 of 29 Page 26 º Implemented the BIS Digital Court Recorder system. º Replaced 5 computers. º Processed 2 orders. º Setup of new offices in Fulcher Building. SUPERIOR COURT JUDGE º Trained 6 users for 72 hours. º Completed 131 Work Orders. º Coordinated IT purchases and services based on user needs and requests. º Managed 8 orders related to IT equipment or software. º Provided support during carpet installation. º Performed relocation of judges’ technology equipment. º Processed 4 orders. TAG OFFICE – FARMER’S MARKET º Completed 12 Work Orders. º Installed Tag Search Application. º Implemented the Sign-In Board. º Repaired the automated download process for the Tag Search Application. TAG OFFICE – SOUTHSIDE º Completed 4 Work Orders. º Implemented the Sign-In Board. TAX ASSESSORS º Trained 13 users for 156 hours. º Completed 113 Work Orders. º GIS contracted with Pictometry to bring change analysis software to the Tax Assessors Office to use with the oblique photography. º GIS completed 4 Work Orders for the Tax Assessors Office. º Conducted monthly status meetings to stay on top of all IT needs. º Provided ongoing support for IT related purchases. º Modified TACS Application to accommodate State homestead value. º Modified TACS Application to accommodate new tax districts. º Processed multiple security requests. º Performed the Year End procedures for new businesses. º Provided ongoing support for the TACS Application. º Provided ongoing support for the WinGAP Application. º Provided support for the WinGAP Year End process. º Performed the Year End procedures for GA Boats. º Setup WinGAP Check-In/Check-Out process for Motion 5 Tablet. º Installed and updated WinGAP SQL. º Ran the NCOA process and updated WinGAP accordingly. º Processed 7 orders. º Coordination of carpet installation. Attachment number 1Page 26 of 29 Page 27 TAX COMMISSIONER º Trained 8 users for 86 hours. º Completed 83 Work Orders. º Ran the NCOA process and updated WinGAP accordingly. º Provided ongoing support for the VCS Tax Application. º Provided ongoing support for the Peachtree Application. º Provided support for the Property Tax Billing process. º Provided support for the Tax Digest Preparation process. º Provided support for the Mobile Home Tax Billing process. º Processed multiple security requests. º Provided support for the Peachtree Year End process. º Upgraded Peachtree Application to newer version. º Provided ongoing support for the FiFa Interface process. º Created a report of all businesses in WinGAP without a Business License. º Restored 2006 data in the Peachtree Application. º Provided ongoing support for IT related purchases. º Participated in periodic status meetings to stay on top of all IT needs. º Coordination of carpet installation. º Processed 6 orders. º 2 In - House maintenance requests completed. TRANSIT DEPARTMENT º Trained 1 user for 12 hours. º Completed 38 Work Orders. º Provided service and support for 59 radios. º GIS has completed the Transit Departments Bus Schedule Map for printing. º Provided coordination of IT purchases and services based on user needs. º Assisted with upgrade of Trapeze Database to SQL Server 2005. º Upgraded MaintStar Software application on 2/27/08. º Upgraded Trapeze application in TEST environment to version 8. º Planned, managed, and implemented Mobile Data Terminals for use on buses. TREES AND LANDSCAPE º Completed 17 Work Orders. UTILITIES - BAY STREET º Trained 50 users for 592 hours. º Completed 136 Work Orders. º Provided service and support for 34 radios. º The GIS Group completed 6 Work Orders for Utilities. º The Network Group installed a cable modem and PIX/VPN for network connectivity at Fort Gordon. º Installed one Canon DR 2580c scanner. º 5 In - House maintenance requests completed. UTILITIES - CENTRAL AVE º Trained 3 users for 36 hours. º Completed 42 Work Orders. Attachment number 1Page 27 of 29 Page 28 º Provided service and support for 30 radios. º 1 In - House maintenance request completed. UTILITIES - HIGHLAND AVE FILTER PLANT º Provided service and support for 14 radios. UTILITIES - HIGHWAY 25 º Trained 6 users for 72 hours. º Completed 67 Work Orders. º Provided service and support for 40 radios. º 3 In - House maintenance requests completed. UTILITIES - MUNICIPAL BLDG. º Trained 24 users for 280 hours. º Completed 55 Work Orders. º 1 In - House maintenance request completed. º Coordination of carpet installation. UTILITIES - N. MAX HICKS WATER TREATMENT PLANT º Trained 6 users for 72 hours. º Completed 43 Work Orders. º Provided service and support for 55 radios. º 1 In - House maintenance request completed. UTILITIES - PLANT 2 º Provided service and support for 9 radios. UTILITIES - RAW WATER PUMPING STATION º Trained 2 users for 24 hours. º Completed 6 Work Orders. º Provided service and support for 6 radios. UTILITIES - WASTE WATER TREATMENT º Trained 2 users for 24 hours. º Completed 34 Work Orders. UTILITIES ADMINISTRATION º GIS completed 6 Work Orders for Utilities. º Installed 3 HP DX5750 computers, 3 HP L1965 monitors, 1 HP LJ 2605DN printer. º Setup of Fort Gordon facility. º Assisted with Technology Planning for New Highland Avenue Filter Building. º Coordinated IT resources for the network wiring reconfiguration at Peach Orchard Road. º Assisted with Technology Planning for setup of Operators office with network access at Goodrich Attachment number 1Page 28 of 29 Page 29 Street Raw Water Pumping Station. º Assisted with Technology Planning for the planned expansion of Utilities to Fort Gordon. º Provided support for Operator 10 application. º Coordinated 59 IT related purchase Orders. º Managed and facilitated the enQuesta Web Connect & Pay Connect Implementation. º Coordinated efforts with Logicalis to facilitate upcoming implementation of new IVR system. º Planned and initiated the GBA barcode scanning implementation. º Managed reconfiguration of GBA database to enable auditing and accountability among AUD facilities. º Supported and coordinated the Annual Utilities Rate Change process in enQuesta. º Provided ongoing support for GBA application. º Provided ongoing support for enQuesta application. º Provided support for MVRS application. º Upgraded enQuesta to version 3e. º Upgraded Operator 10 to version 8. º Upgraded MVRS. º Upgraded ESS Compliance Suite. º Assisted with GraniteXP upgrade to version 3.4.2. Attachment number 1Page 29 of 29 Public Safety Committee Meeting 3/9/2009 1:30 PM New World System Redundancy for Corrections and Records Department:Information Technology Caption:Approve the acquisition of software and services related to the redundancy of the Sheriff's Office Jail and Records Hardware and Software. Background:IT currently maintains an IBM AS400 which houses the Jail/Corrections Software as well as the Sheriff's Office Records Management System (RMS). At present, when this system is down for maintenance, Corrections and Records do not have access to their software. The AS400 is an exceptionally dependable hardware platform, but maintenance is a requirement in order to keep the operating system and software functioning at an optimal level. Analysis:In order to ensure that public safety is not compromised in any way, New World offers "redundancy" for their system. This means that when the AS400 is unavailable, the software functions will be transferred to another AS400 so that operations are restored within minutes with no loss of data or functionality. This is being procured as an additional license to our existing solution from New World. Financial Impact:This solution is being funded using $27,000 from IT's 2008 Capital Budget. Alternatives:N/A Recommendation:Approve the acquisition of software and services related to the redundancy of the Sheriff's Office Jail and Records Hardware and Software Funds are Available in the Following Accounts:272015410.5424120 (carryover from 2008) REVIEWED AND APPROVED BY: Procurement. Information Technology. Finance. Law. Administrator. Clerk of Commission Cover Memo Attachment number 1Page 1 of 1 Attachment number 1Page 1 of 1 Attachment number 1Page 1 of 1 Attachment number 1Page 1 of 1 Attachment number 1Page 1 of 1