Loading...
HomeMy WebLinkAbout2008-03-10-Meeting Agendawww.augustaga.gov PublicSafetyCommitteeMeeting CommitteeRoom -3/10/2008 -1:20PM PUBLICSAFETY 1.Motion to approve establishing a checkingaccount t o purchasebustickets,releasepackagesandprovide gratuity checkstoeligibleinmatesatreleaseasrequiredb ystatute. Attachments 2.Receive the InformationTechnology (IT)2007 Annual Reportasinformation. Attachments 3.Approvethepurchaseofasecuritygateintheamou ntof $39,525fromOverheadDoorofAugusta. Attachments PublicSafetyCommitteeMeeting 3/10/20081:20PM DischargeGratuities Department:RCCIInmateStore Caption:Motiontoapproveestablishingacheckingaccountt o purchasebustickets,releasepackagesandprovideg ratuity checkstoeligibleinmatesatreleaseasrequiredb ystatute. Background:Gratuitypaymentsareprovidedtostateinmateswho are lawfullyreleasedfromanyfacilityunderthejuris dictionof theGeorgiaDepartmentofCorrections(DOC).Previo usly gratuitycheckswereprocessedbyD.O.C.,however; effectiveFebruary1,2008thereleasingfacilityi s responsibleforprovidingthereleasegratuity,tra nsportation andclothing.DepartmentofCorrectionswillbebi lled monthlyforthereimbursements. Analysis:In2007andpreviousyearsapproximatelyeighty-fiv e hundred($8,500.00)dollarswerespentongratuities .Request tenthousand($10,000.00)dollarstobeallocatedf orthis function.Checkswillbeproducedbystaffonanas needed basis.TheBusinessManagerwillsubmitaFieldPur chase OrdertotheDepartmentofCorrectionsmonthlyfor reimbursement. FinancialImpact:Thefinancialimpactistheinitialfundsneededto openan account.Fundsareinaccount101-03-3212.Thesefu nds weregeneratedfromthecommissionoftheInmate Commissaryandtelephone. Alternatives:Approverequest. Recommendation:Recommendapprovalofopeninganaccounttoprovide gratuitiesforinmateswhenreleased. Fundsare Cover Memo Item # 1 Availableinthe Following Accounts: Fundsavailableinthefollowingaccount:InmateSt ore RevenueAccount-101-02-3212/5317520$10,000tec/n s REVIEWEDANDAPPROVEDBY : Finance. Administrator. ClerkofCommission Cover Memo Item # 1 PublicSafetyCommitteeMeeting 3/10/20081:20PM InformationTechnology2007AnnualReport Department:TamekaAllen,InformationTechnologyDepartment Caption:ReceivetheInformationTechnology(IT)2007Annual Reportasinformation. Background:TheInformationTechnologyDepartmentprovidesthe InformationTechnologyAnnualReporttoalldepartm ent headsandelectedofficialseachyearoutliningthe technology activitiesthattookplacethepreviousyear. Analysis:TheInformationTechnologyAnnualReportprovides informativedataasonemeanstomeasuretheoveral l performanceoftheInformationTechnologyDepartmen tand itscontinuousstrivetoprovidethetechnicaltool snecessary fortheoverallorganization.Goalsareestablished tomotivate theInformationTechnologyDepartmenttomaintainc urrent technology,developandsupportastabletechnology infrastructure,andprovideexceptionalcustomerse rvice support. FinancialImpact:N/A Alternatives:N/A Recommendation:ReceivetheInformationTechnology(IT)2007AnnualR eport asinformation. Fundsare Availableinthe Following Accounts: N/A Cover Memo Item # 2 REVIEWEDANDAPPROVEDBY : Finance. Administrator. ClerkofCommission Cover Memo Item # 2 To: Fred Russell, Administrator Department Heads and Elected Officials From: Tameka Allen, Director, Information Technology Date: March 3, 2008 RE: Information Technology 2007Annual 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 2007: IT Customer Satisfaction annual survey demonstrated a 98% approval rating. Upgraded After-hours support protocol to provide more information to better support the users. Completed Municipal Building VoIP telephony upgrade/conversions. Citywide implementation of upgrade from Windows 2003 to Windows XP for continued system standardization. Implemented several wireless projects to include: Grand Jury Courtroom, 2nd Floor Municipal Building Courtroom, 8th Floor of the Municipal Building, 3rd Floor of the Municipal Building, Fleet on Walton Way and between the main recreational facilities and ballpark towers. Managed the Microsoft Exchange Server system that received 2,742,245 emails and sent 1,011,707 emails. Imported 251,800 images for 1993-1995 from microfilm into the CDIMS application for the Clerk of Superior Clerk. Upgraded Faster CS application for the Fleet Management system. Planned, managed and implemented SpecRight, new Housing Rehabilitation software for Housing & Community Development. Designed and developed web-based version of ATOMS application. Installed Cisco Automated Attendant – Standardized Voice. Implemented plan to begin network diagramming of all city locations. Upgraded city’s internet service link to AT&T 10MB Metro Ethernet. Upgraded Blackberry server software from Small Business Edition 3.x to Enterprise 4.x version for Microsoft Exchange. Telecommunications services audit conducted by ISI Telemanagement Solutions, Inc. INFORMATION TECHNOLOGY Tameka Allen Director Michael F. Blanchard Gary Hewett Assistant Director Assistant Director Attachment number 1 Page 1 of 28 Item # 2 Implemented Crisis Link failover for the telephony system. Upgraded Oracle Database server to 10g to support various county databases. Completed inventory of all of the communication equipment throughout the city. Completed manual technology inventory for all departments to include all computers, printers, monitors, laptops, and peripherals. Negotiated a 17% reduction in the annual maintenance costs with Motorola, resulting in a $35,174 a year cost savings. Added additional standard GIS maps for public download in PDF and JPEG format to Augusta GIS web site. Mapped over 155 locations of the Augusta facilities for GIS application. Created a dataset for Shopping & Major Retail – 91 locations including Anchor store 1 and 2, a number of stores and vacant stores. Added additional 260 road segments to the GIS road database. Created GIS Feature Dataset for License & Inspection. Performed year-end jury box balancing for the Jury Clerk. Provided project coordination and technical assistance for the renovation and move of the Marshal’s Offices. Upgraded the county wide GBA application to version 6.73 Developed Poll Worker Management software to track election worker assignments and pay. Installed infrastructure wiring in new administrative office for Public Services. Installed Cisco PIX and AT&T DSL for connectivity for the Augusta Golf Course. Installed Key Service Unit and telephone system for Johnson Community Center. Designed, developed, and implemented web-based accounting application for Civil & Magistrate Court. Planned, managed, and implemented BalanceAAP, new EEO software. Worked with the Sheriff’s Office to implement the COPLINK program in coordination with other local law enforcement agencies. Designed, developed, and implemented automated export of incarcerated inmates to Bealls to log inmate telephone calls. Created data layers and buffers to generate a Sex Offender Map for the Sheriff’s Office to become compliant with the new sex offender laws. Facilitated creation and posting of Records Division Web Page on the Augusta website. Planned, managed, and implemented Phase I of Insight, new Solid Waste application. Provided project management and technical support related to the movement of State Court Offices from the Law Enforcement Center to Greene Street. Trained a total of 894 city users in Microsoft Office products and vendor training. Responded to 807 work orders for Telecom related issues. Blocked 5,917,128 spam emails and 8,945 virus emails from entering the system. More detailed IT activities by department are on the following pages: Attachment number 1 Page 2 of 28 Item # 2 ADMINISTRATION º Completed 50 Work Orders. º Provided service and support for 1 portable radio. º Upgraded 1 PC to Windows XP. ANIMAL CONTROL º Completed 57 Work Orders. º Upgraded 9 PC's to Windows XP. ANIMAL SERVICES º Trained 3 users for 36 hours in Office Automation. º Completed 15 Work Orders. º Provided service and support for 15 portable radios. º Provided ongoing support for IT related purchases. º Provided ongoing support for the Chameleon Application. AUGUSTA CANAL AUTHORITY º Created Maps for the National Heritage Area for the Canal Authority. AUGUSTA CARES º Completed 50 Work Orders. º Made modifications to GBA reports. º Provided ongoing support for GBA application. º Assisted with the procurement of a wireless headset system. AUGUSTA LIBRARY º Trained 3 users for 36 hours in Office Automation. º Provided ongoing support for the Acquisitions Application. º Provided ongoing support for Encumbrance Application. AUGUSTA REGIONAL AIRPORT º Trained 1 user for 12 hours in Office Automation. º Completed 250 Work Orders. º Provided annual Masters Tournament telecommunications needs. º Installed universal telephone alert with strobe system in fire station equipment bay. º Provided service and support for 101 radios. º Assisted with procuring the following: digital signature pads for FBO Manager, a UPS for the Airport Fire Station, USB flash drives, parts for the ARA Fire Department Phone Strobe, replacement PCs for XP upgrade, VOIP telephones, and color printers. º Planned, managed, and implemented the IT components surrounding the Airport's move to the new terminal. º Installed new switch for Airport Administration in the new terminal. º Moved Marshal's equipment from temporary modular building to new terminal. Attachment number 1 Page 3 of 28 Item # 2 º Replaced 19 computers with HP DC5750 models and HP L1965 monitors. BOARD OF ELECTIONS º Developed PollWorker management software to track election worker assignments and pay. º Provided support and website programming for 4 elections. º Designed and developed Poll Worker Training Application. º Completed 72 Work Orders. º Upgraded 1 PC to Windows XP. CEMETERY - MAGNOLIA º Designed and Developed a web version of the Graveside Database used to record deceased persons and make their information available to the public. º Completed 34 Work Orders. º Provided ongoing support for GBA application. º Upgraded GBA application to version 6.73. º Upgraded Cisco 2507 to Cisco 2610 router. º Upgraded 2 PC's to Windows XP. CEMETERY- WESTVIEW º Trained 1 user for 4 hours in GBA. º Provided a cost analysis for establishing network connectivity at Westview and Cedar Grove cemeteries. CIVIL & MAGISTRATE COURT º Designed, developed, and implemented web based accounting application. º Completed 80 Work Orders. º Upgraded 10 PC's to Windows XP. º Upgraded from PBX to VoIP telephone service. º Provided ongoing support for the New World application. º Provided ongoing support for all IT purchases and services. º Began evaluation of alternatives for automated forms management. CIVIL & MAGISTRATE COURT- JUDGE º Completed 15 Work Orders. º Upgraded from PBX to VoIP telephone service. º Provided ongoing support for the New World application. º Upgraded 4 PC's to Windows XP. CLERK OF COMMISSION º Modified MuniAgenda Extended Functions application to work with new version of MuniAgenda database. º Completed 23 Work Orders. º Provided assistance and support during lawsuit concerning agenda items displaying on website. º Provided ongoing support for MuniAgenda application. Attachment number 1 Page 4 of 28 Item # 2 º Upgraded MuniAgenda application to version 2.8.2. º Installed one Nikon l14 camera. º Upgraded 3 PC's to Windows XP. CLERK OF COURT º Designed, developed, and implemented Judge Jail List report that combines ICON data with New World data. º Trained 6 users for 81 hours in Office Automation. º Trained 1 user for 2 hours in VoIP. º Completed 313 Work Orders. º Provided ongoing support of Icon application. º Facilitated purchase of multiple scanners for Clerk's staff. º Provided ongoing support for the New World application. º Assisted office staff with gaining access to criminal history records through new SSL VPN connection mandated by GCIC. º Provided ongoing support for the CDIMS Applications. º Provided ongoing support for the COTT Application. º Conducted monthly status meetings to stay on top of all IT needs. º Imported 251,800 images for 1993-1995 from microfilm into the CDIMS application. º Imported 77,493 images for 1992 from microfilm into the CDIMS application. º Installed six HP NC8430 laptops. º Replaced one PDA with new HP IPAC HX2790B handheld. º Replaced 30 Gateway computers and monitor with brand new Dell E4610. CLERK OF STATE COURT - LEC º Completed 65 Work Orders. º Provided ongoing support for all IT purchases and services. º Provided ongoing support for the New World application. CORONER`S OFFICE º Completed 42 Work Orders. º Installed 4 Channel CD call logger system. º Provided service and support for 4 radios. º Facilitated procurement and setup of phone recording system. º Provided ongoing coordination for all IT purchases and services. º Completed a study recommending high-speed network availability for the Coroner's Office. º Provided ongoing support for Coroner-specific computer programs. COUNTY ATTORNEY º Completed 16 Work Orders. º Provided ongoing coordination for all IT purchases and services. º Upgraded 2 PC's to Windows XP. DISADVANTAGED BUSINESS ENTERPRISE º Assisted with the procurement of USB flash drives. Attachment number 1 Page 5 of 28 Item # 2 DISTRICT ATTORNEY º Completed 271 Work Orders. º Conducted a class on Electronic Document Management System usage for ADA's to facilitate location and printing of case file information. º Provided ongoing coordination for all IT purchases and services. º Provided ongoing support for the New World application. º Provided ongoing support for the Prosecutor's Dialog application. º Assisted office staff with gaining access to criminal history records through new SSL VPN connection mandated by GCIC. º Configured 4 new HP DX7000 computers for Columbia County. º Installed 2 HP Color LaserJet 4700dn's. º Upgraded 29 PC's to Windows XP. DISTRICT ATTORNEY VICTIM`S ASSISTANCE º Completed 11 Work Orders. º Upgraded 2 PC's to Windows XP. E911 DISPATCH º Completed 212 Work Orders. º Installed 6 phone lines for E911 backup site at 2163 Central Avenue. º Created a rapid sign-on procedure for E911 operators to assist them in daily operations. º Provided service and support for 14 portable radios. º Provided service and support for 12 dispatch positions. º Assisted in the relocation of the dispatch positions. º Assisted in the upgrade of 12 new dispatch computers and loading software. º Supplied maps for the New World dispatch and 9-1-1 system. º Provided ongoing coordination for all IT purchases and services. º Provided ongoing support for the Cross Search application. º Provided ongoing support for the New world CAD application. º Provided ongoing support for the ProQA applications. º Explored options for wireless connectivity in conference room and made recommendations to E911. º Worked with E911 personnel on quality control of city street name database. º Reworked cabling at E911 and Installed new network equipment. º Installed one HP 4700n printer. º Installed one HP DC5750 computer. º Installed one HP TC4400 tablet. º Replaced old equipment with fifteen HP XW6400 workstations for dispatchers. EMERGENCY MANAGEMENT AGENCY º Upgraded administrative office to VoIP. º Completed 18 Work Orders. º Provided service and support for 8 portable radios and one base station. º Provided ongoing coordination for all IT purchases and services. º Explored options for phone system upgrade to VOIP. º Provided recommendations to EMA for the procurement of a wireless hotspot in the emergency operations center. º Began implementation of Emergency Notification System with Twenty-First Century Communications (completion scheduled in February 2008). Attachment number 1 Page 6 of 28 Item # 2 º Upgraded 2 PC's to Windows XP ENGINEERING º Relocated Administration offices from Marvin Griffin Road to Telfair Street. º Completed 326 Work Orders. º Relocated department from 530 Greene Street to 525 Telfair Street. º Upgraded from PBX to VoIP telephone service. º Provided service and support for 21 portable radios. º Planned, managed, and implemented the IT components involved in consolidating Engineering Offices at Greene Street office. º Began planning process of determining how to implement the Storm Water module in GBA. º Assisted with the procurement of the following: Hallmark Card software, Hydraflow software, VOIP phones, Flexi 8 software, ASCE Seminars on CD series, Adobe Acrobat Professional software, network drops, external hard drive, monitors and additional ram. º Installed cabling and network equipment in new buildings on Telfair for Engineering, Engineering Admin, and Traffic Engineering. º Installed one Canon 2580C scanner. ENGINEERING - TRAFFIC ENGINEERING º Trained 1 user for 15 hours in Office Automation. º Provided service and support for 25 portable radios. EQUAL OPPORTUNITY EMPLOYMENT º Completed 53 Work Orders. º Assisted with the procurement of the following: network drops, fax machine, VOIP phones, computer, printers, UPS backup unit, portable printer, LCD projectors. º Planned, managed, and implemented BalanceAAP, new EEO software. º Pulled data and prepared reports for EEO-4 report. º Attended BalanceAAP training class with department head in order to provide technical assistance. º Upgraded 1 PC to Windows XP. EXTENSION SERVICES º Completed 12 Work Orders. º Installed Cisco PIX and Comcast cable modem for connectivity and removed ISDN circuit. º The network group deleted approximately 800 expired and inactive computer accounts from Microsoft Active Directory. º Upgraded 3 PC's to Windows XP. FACILITIES MAINT-CONSTRUCTION º Provided service and support for 71 portable radios. FACILITIES MAINTENANCE º Provided service and support for 30 portable radios. Attachment number 1 Page 7 of 28 Item # 2 FINANCE ACCOUNTING º Upgraded from PBX to VoIP telephone service. º Completed 45 Work Orders. º Upgraded 2 PC's to Windows XP. FINANCE DEPARTMENT º Trained 2 users for 27 hours in Office Automation. º Trained 6 users for 12 hours in VoIP. º Upgraded from PBX to VoIP telephone service. º Completed 75 Work Orders. º Implemented additional departments on the IFAS 7i Budget Item Detail Module. º Implemented 2% Cost of Living Increase. º Applied year-end upgrade (2008 Tax Tables). º Assisted with the procurement of an additional network drop in the Payroll division. º Provided assistance with implementation of new pension plan into IFAS system. º Assisted in W-2/1099 balancing, processing, and printing for calendar year 2006. º Ran Magnetic Media for calendar year 2006. º Generated reports from IFAS data. FIRE DEPARTMENT ADMINISTRATION º Trained 26 users for 342 hours in Office Automation. º Completed 166 Work Orders. º Provided service and support for 169 portable and mobile radios. º Supervised the installation of 30 mobile data units in fire trucks. º Provided service and support for 30 Mobile Data Terminals. º Created maps and worked with staff to GPS fire hydrants, Fire Beats and Fire Station locations. º Began preparation of revised RFP for new Fire Records Software. º Provided ongoing support for Emergency Reporting Software. º Provided coordination of IT purchases and services. º Installed and supported defibrillator software at multiple fire stations. º Upgraded 4 PC's to Windows XP. FIRE PREVENTION º Provided ongoing support for IT purchases and services as needed. FIRE STATION #1 º Trained 27 users for 363 hours in Office Automation. º Completed 24 Work Orders. FIRE STATION #10 º Completed 13 Work Orders. Attachment number 1 Page 8 of 28 Item # 2 FIRE STATION #11 º Completed 7 Work Orders. FIRE STATION #12 º Completed 8 Work Orders. º Upgraded 1 PC to Windows XP. FIRE STATION #13 º Completed 10 Work Orders. FIRE STATION #14 º Completed 13 Work Orders. FIRE STATION #15 º Completed 18 Work Orders. FIRE STATION #16 º Completed 12 Work Orders. FIRE STATION #17 º Completed 6 Work Orders. FIRE STATION #18 º Completed 14 Work Orders. FIRE STATION #19 º Completed 4 Work Orders. º Upgraded 1 PC to Windows XP. FIRE STATION #2 º Completed 10 Work Orders. FIRE STATION #3 º Completed 55 Work Orders. º Installed one HP Laser Jet 4350n printer. º Installed one DC5750 computer and one L1740 monitor. º Upgraded 7 PC's to Windows XP. Attachment number 1 Page 9 of 28 Item # 2 FIRE STATION #4 º Completed 6 Work Orders. FIRE STATION #5 º Completed 7 Work Orders. FIRE STATION #6 º Completed 16 Work Orders. º Supervised the installation of communication equipment in new station. FIRE STATION #7 º Completed 9 Work Orders. º Upgraded 1 PC to Windows XP. FIRE STATION #8 º Completed 18 Work Orders. º Upgraded 2 PC's to Windows XP. FIRE STATION #9 º Completed 15 Work Orders. FLEET - MANAGEMENT º Completed 21 Work Orders. º Provided service and support for 16 portable radios. º Coordinated multi-department effort to determine consistent method of costing fleet assets in GBA software. º Provided ongoing support for Faster CS software. º Upgraded Faster CS application to version 5.69. º Upgraded 17 PC's to Windows XP. FLEET MAINTENANCE - LUMPKIN ROAD º Completed 7 Work Orders. º Upgraded 1 PC to Windows XP. FLEET MAINTENANCE - TOBACCO ROAD º Completed 32 Work Orders. º Upgraded 6 PC's to Windows XP. FLEET OPERATIONS & MAINTENANCE º Completed 155 Work Orders. Attachment number 1 Page 10 of 28 Item # 2 º Upgraded 1 PC to Windows XP. FORESTRY º Completed 2 Work Orders. HOUSING & COMMUNITY DEVELOPMENT º Trained 2 users for 27 hours in Office Automation. º Completed 202 Work Orders. º Planned, managed, and implemented SpecRight, new Housing Rehabilitation software. º Assisted with the procurement of the following: computer replacements, printers, plotter network card, UPS backup units, emergency technology order due to Federal grant expiration, scanner, and scanner software. º Planned, managed, and implemented the IT components surrounding HND's reorganization office move. º Installed 2 HP Business Inkjet 1200 printers. º Replaced 5 computers and monitors with HP DC5750 computers and HP Flat 1706 monitors. º Replaced one computer with HP NX8440 laptop/base station setup. º Replaced one printer with HP Laser Jet 9050dn. º Created many maps for the revitalization projects in the Laney-Walker Bethlehem area. º Upgraded 7 PC's to Windows XP. HUMAN RELATIONS COMMISSION º Completed 55 Work Orders. º Provided ongoing support for IMS application. º Upgraded 2 PC's to Windows XP. HUMAN RESOURCES º Trained 3 users for 39 hours in Office Automation. º Completed 189 Work Orders. º Provided ongoing support for IFAS application. º Updated health insurance rates. º Generated reports from IFAS data. º Provided assistance with implementation of new pension plan into IFAS system. º Assisted with the procurement of a digital voice recorder and transcription kit. º Researched and introduced the NeoGov web application to HR. º Upgraded 9 PC's to Windows XP. INFORMATION TECHNOLOGY º Designed and developed web based version of ATOMS. º Converted Sharepoint portal to SQL Server 2005. º Designed and began testing of Warranty Tracking of inventory items. º Designed, developed, and tested Trouble Ticket application for ATOMS Web. º Modified ATOMS Order module to account for partially ordered (post billed wiring) items. º Completed 807 work orders for county wide Telecom related issues. º Completed 122 county wide Telecom related orders. º Installed Cisco Automated Attendant - Standardized Voice. º Completed 15 IT internal Telecom projects. Attachment number 1 Page 11 of 28 Item # 2 º Updated BellSouth telephone directory changes in white pages. º Implemented conversion of municipal building to VoIP. º Completed annual telephone directory distribution. º Completed annual city wide telecommunications circuits updates and hardware inventory. º Upgraded BellSouth white pages for the Augusta government listings. º Upgraded city's internet service link to AT&T 10MB Metro Ethernet. º Completed 1365 internal help desk work orders. º Completed biannual testing of 911 Intrado service. º Upgraded Blackberry server software from Small Business Edition 3.x to Enterprise 4.x version for Microsoft Exchange. º Telecommunications services audit by ISI Telemanagement Solutions, Inc. º Setup CrisisLink failover phone service. º After hours support phone number reconfigured with more information to help direct users to appropriate support group. º Blocked 5,917,128 spam emails. º Blocked 8,945 virus emails. º Upgraded Oracle Database server to 10g to support various county databases. º Upgraded 5 of 13 Microsoft SQL 2005 servers. º Installed 5 new Microsoft 2005 servers. º Backup average of 1.8 Terabyte of data daily. º Completed inventory of all of the communication equipment used in the County. º Negotiated a 17% reduction in the annual maintenance costs with Motorola, resulting in a $35,174.00 a year savings to the County. º Printed numerous maps for the Sheriff's Dept, District Attorney, Private Attorneys, Real Estate Co., Private Citizens, Housing and Neighborhood Development, Land Bank, and the Wi-Fi initiative for the City. º Updated and created Slides, Posters, Maps, and Booklets for Commissioner Cheek. º Added 21 new subdivisions to the parcel geodatabase. º Performed layout, design, and printer liaison work related to the Augusta 2006 Annual Report. º Added additional standard GIS maps for public download in PDF and JPEG format (Roads, Augusta Canal, Augusta Facilities, GA County Map) to Augusta GIS web site. º Mapped ARC Facilities - 155 locations. º Mapped Cultural & Historic locations - 67 locations. º Created a dataset for Shopping & Major Retail - 91 locations including Anchor Store 1 and 2, a number of Stores and Vacant Stores. º Created Augusta Chronicle Hospitality Wraps. º Researched and corrected unaddressed parcels as part of a long-term effort in cooperation with Planning & Zoning Staff (originally 6,000+ but only 141 remain). º Added New Maps Online Icon to Augusta Home Page for easier access to map data. º Added new intro page with help document (PDF) to assist users with online map use. º Added 260 road segments to the GIS road database. º Gathered 12,318 address points for apartment addresses. º Determined 496 apartment complex locations for mapping purposes. º Generated reports from IFAS data. º Provided ongoing support for IFAS application. º Provided ongoing support for MuniAgenda application. º Installed Wi-Fi in the Grand Jury court room on the 4th floor of the Municipal building. º Installed Wi-Fi in the 2nd floor court rooms of the Municipal building. º Installed Wi-Fi on the 8th floor of the Municipal building. º Installed Wi-Fi on the 3rd floor of the Municipal building. º Installed 175 data cable drops. º Installed Cisco network switch on the 3rd floor of the Municipal building for the VoIP conversion. Attachment number 1 Page 12 of 28 Item # 2 º Converted IP Addresses and standardized naming for all Cisco equipment. º Upgraded the operating system on AUDIWR. º The network group created 327 network accounts. º The network group created 86 email accounts. º The network group deleted 128 network accounts. º The Exchange server detected and stopped 1203 viruses. º Managed the Microsoft Exchange server system that received 2,742,245 emails and sent 1,011,707 emails. º Completed 1336 internal network work orders. º The network group supported 76 servers. º The network group supported 11 management applications. º Ordered and installed replacement servers for GISDATA, WINGAP, and SQL Test. º Ordered and installed Microsoft System Centers Configuration Manager and Operations Manager servers. º Ordered and installed Cityview servers, AUGAPP004, AUGDB004, AUGWEB004, and AUGTEST004. º Installed VMware test and production environments. º Upgraded the operating system on AUDVIDSRV. º Cleaned, stopped or denied 61,675 virus attempts with Symantec antivirus server and client software. º Presented email policy for review to county attorney. º Implemented plan to begin network diagramming of all city locations using Microsoft Visio. º Installed wireless connectivity between main building and ballparks towers. º Ordered 2gb memory for System Administration computers. JURY CLERK º Performed year-end jury box balancing. º Completed 25 Work Orders. º Provided ongoing coordination of IT purchases and services. JUVENILE COURT º Completed 30 Work Orders. º Provided ongoing coordination of IT purchases and services. º Upgraded 4 PC's to Windows XP. LANDBANK AUTHORITY º Researched financial software options and installed Quickbooks Simple Start software. LAW DEPARTMENT º Completed 102 Work Orders. º Provided ongoing coordination of IT purchases and services. LAW LIBRARY º Upgraded from PBX to VoIP telephone service. º Completed 10 Work Orders. º Upgraded 2 PC's to Windows XP. Attachment number 1 Page 13 of 28 Item # 2 LICENSE & INSPECTION º Trained 1 user for 15 hours in Office Automation. º Completed 268 Work Orders. º Provided service and support for 42 portable radios. º Supplied maps for the cleanup of the Turpin Hill Area. º Created GIS Feature Dataset for License & Inspection (Inspectors). º Created multiple reports for the License & Inspection Department. º Designed and Implemented the new Inspection Tracking Application. º Produced contractor labels for Public Works. º Facilitated training and testing for the new CityView software Application. º Set up the Servers for the new CityView software application. º Set up Security for the new CityView software application. º Performed Oracle 10g client upgrade for iaPermits. º Performed Oracle 10g client upgrade for iaLicense. º Provided support for the Windows XP upgrade. º Conducted monthly status meetings to stay on top of all IT needs. º Provided ongoing support for the Code Enforcement Application. º Provided ongoing support for the iaLicense Application. º Provided ongoing support for the iaPermits Application. º Provided support for the Alcohol License Renewals. º Provided support for the Business License Renewals. º Provided support for the Urgent Reminder process. º Installed one Nikon Coolpix L12 digital camera for Code Enforcement. º Upgraded 29 PC's To Windows XP. MARSHAL SUBSTATION º Completed 22 Work Orders. º Upgraded 4 PC's to Windows XP. MARSHAL`S DEPARTMENT º Trained 2 users for 27 hours in Office Automation. º Trained 1 user for 2 hours in VoIP. º Completed 54 Work Orders. º Relocated the administrative office to 8th floor of municipal building. º Upgraded from PBX to VoIP telephone service. º Provided service and support for 42 portable radios and 6 Mobile Data Terminals. º Assisted office staff with gaining access to criminal history records through new SSL VPN connection mandated by GCIC. º Provided ongoing coordination of IT purchases and services. º Provided ongoing support for the New World Application. º Provided project coordination and technical assistance for the renovation and move of Marshal's Offices to the new suite in the Municipal Building. º Upgraded 3 PC's to Windows XP. MAYOR º Trained 1 user for 12 hours in Office Automation. º Completed 40 Work Orders. º Upgraded 1 PC to Windows XP. Attachment number 1 Page 14 of 28 Item # 2 NATURAL RESOURCE CONSERVATION SERVICES º Replaced 1 PC with HP 5750. NEIGHBORHOOD ENHANCEMENT º Trained 2 users for 27 hours in Office Automation. º Completed 21 Work Orders. OLD GOVERNMENT HOUSE º Completed 11 Work Orders. º Discontinued ISDN circuit and replaced with DSL. º Upgraded 1 PC to Windows XP. PAYROLL º Trained 2 users for 24 hours in Office Automation. º Trained 3 users for 6 hours in VoIP. º Completed 29 Work Orders. PLANNING & ZONING º Trained 8 users for 16 hours in VoIP. º Completed 111 Work Orders. º Added Zoning Cases for 2006 to show up on Maps on line for the Planning Commission. º Worked with the Planning Commission to set up document imaging to scan all Zoning Cases. º Upgraded 12 PC's to Windows XP. PRINT SHOP º Trained 1 user for 2 hours in VoIP. º Completed 12 Work Orders. PROBATE COURT º Completed 37 Work Orders. º Upgraded from PBX to VoIP telephone service. º Replaced one HP 5si printer with HP 4250n. Also added components to HP 4100n printer. º Upgraded 1 PC to Windows XP. PROBATION º Completed 34 Work Orders. PROCUREMENT º Completed 77 Work Orders. º Provided ongoing support for IFAS application. º Generated reports from IFAS data. º Applied year end changes. Attachment number 1 Page 15 of 28 Item # 2 º Upgraded 7 PC's to Windows XP. PUBLIC DEFENDER º Trained 2 users for 27 hours in Office Automation. º Completed 321 Work Orders. º Provided ongoing coordination of IT purchases and services. º Provided ongoing support for the New World application. º Provided support as needed for the JCats application. º Upgraded 1 PC to Windows XP. PUBLIC SERVICES º Upgraded GBA application to version 6.73. º Provided ongoing support for GBA application. º Upgraded 16 PC's to Windows XP. º Upgraded 7 PC's to Windows XP. PUBLIC SERVICES - ELECTRICAL ENGINEERING º Trained 2 users for 27 hours in Office Automation. PUBLIC SERVICES - FACILITIES MANAGEMENT º Completed 14 Work Orders. º Upgraded from PBX to VoIP telephone service. PUBLIC SERVICES - FACILITIES MANAGEMENT-B&G-JLE º Trained 1 user for 4 hours in VoIP. º Completed 10 Work Orders. PUBLIC SERVICES - FACILITIES MANAGEMENT-B&G-MUNICI º Completed 111 Work Orders. PUBLIC SERVICES - FACILITIES MANAGEMENT-CONSTRUCTI º Completed 20 Work Orders. PUBLIC SERVICES - LANDFILL º Completed 159 Work Orders. º Upgraded 9 PC's to Windows XP. PUBLIC SERVICES - MAINTENANCE º Completed 7 Work Orders. º Assisted with the procurement of a network drop for time clock move and a battery for a cordless headset. Attachment number 1 Page 16 of 28 Item # 2 º Provided ongoing support for GBA application. º Upgraded GBA application to version 6.73. º Upgraded 1 PC's to Windows XP. PUBLIC SERVICES - ROADS & BRIDGES º Completed 78 Work Orders. º Upgraded 3 PC's to Windows XP. PUBLIC SERVICES - STREET LIGHTING º Completed 6 Work Orders. º Replaced HP DeskJet 2500 with HP DeskJet 2800DN. º Upgraded 1 PC to Windows XP. PUBLIC SERVICES - TRAFFIC ENGINEERING º Installed infrastructure wiring in new administrative offices. º Relocated department from 320 Riverview Drive to 528 Telfair Street. º Upgraded to VoIP telephone service. º Completed 102 Work Orders. º Set up Public Works Signal datasets for future data collection. º Upgraded 10 PC's to Windows XP. PUBLIC SERVICES - TREES AND LANDSCAPES º Trained 2 users for 27 hours in Office Automation. º Trained 1 user for 2 hours in VoIP. º Completed 44 Work Orders. º Provided service and support for 37 portable radios. º Upgraded GBA application to version 6.73. º Provided ongoing support for GBA application. PUBLIC WORKS - ENGINEERING º Trained 4 users for 51 hours in Office Automation. PUBLIC WORKS - LANDFILL º Installed one HP L1965 flat monitor and one HP NW8440 laptop with docking station. PUBLIC WORKS - PRE-CONSTRUCTION º Upgraded 2 PC's to Windows XP. PUBLIC WORKS - ROADS & WALKWAYS º Trained 6 users for 81 hours in Office Automation. Attachment number 1 Page 17 of 28 Item # 2 RCCI º Completed 87 Work Orders. º Provided service and support for 42 portable radios. º Provided support for the RCCI Commissary program. º Performed preliminary work related to computer network connectivity for a potential visitor center. RECORDS RETENTION º Trained 2 users for 27 hours in Office Automation. º Installed wireless point to point to enable access to network. RECREATION - ADMIN º Installed two Nikon CoolPix L12 cameras. RECREATION - ADMINISTRATION º Trained 14 users for 159 hours in Office Automation. º Completed 211 Work Orders. º Provided service and support for 50 portable radios. º Installed softball scheduling software on Lida's computer. º Provided ongoing support for IT related purchases. º Facilitated necessary data gathering for new CLASS software implementation. º Planned the Implementation of the new CLASS software Application. º Upgraded 9 PC's to Windows XP. RECREATION - AQUATIC CENTER º Installed Cisco PIX on Comcast cable for connectivity and removed ISDN circuit. º Upgraded 2 PC's to Windows XP. RECREATION - AQUATICS º Completed 18 Work Orders. º Discontinued ISDN circuit and replaced with Comcast cable modem. RECREATION - AUGUSTA GOLF COURSE º Discontinued ISDN circuit and replaced with DSL. º Completed 11 Work Orders. º Designed and Implemented Membership and Gift Cards for ActiveGolf. º Installed, Trained and Implemented the new ActiveGolf software Application. º Facilitated necessary data gathering for new ActiveGolf software implementation. º Provided assistance after storm related power outage. º Provided ongoing support for the ChequePointe Application. º Resolved problem with credit card double charges in ChequePointe Application. º Decommissioned the ChequePointe software application. º Installed Cisco PIX and AT&T DSL for connectivity and removed ISDN circuit. Attachment number 1 Page 18 of 28 Item # 2 RECREATION - BERNIE WARD COMMUNITY CENTER º Completed 11 Work Orders. RECREATION - BLYTHE PARK º Installed two HP Pavilion A6010n computers, HP W19 monitors, and two HP Color Laser Jet 2600 printers. RECREATION - CARRIE J. MAYS º Completed 7 Work Orders. RECREATION - DIAMOND LAKES º Trained 2 users for 27 hours in Office Automation. º Discontinued ISDN circuit. º Completed 6 Work Orders. RECREATION - EISENHOWER PARK º Completed 6 Work Orders. º Upgraded 1 PC to Windows XP. RECREATION-DYESS PARK º Rewired building for telephone service. RECREATION-FLEMING ATHLETIC OFFICE º Completed 5 Work Orders. RECREATION-GARRETT COMMUNITY CENTER º Upgraded 1 PC to Windows XP. RECREATION-H.H. BRIGHAM COMMUNITY CENTER º Upgraded 1 PC to Windows XP. º Installed two HP Pavilion A6010n computers, HP W19 monitors, and two HP Color Laser Jet 2600 printers. RECREATION-H.H. BRIGHAM SENIOR º Completed 5 Work Orders. RECREATION-JOHNSON COMMUNITY CENTER º Installed Key Service Unit and phones for telephone system. º Upgraded telephone system to Nortel Key Service Unit. Attachment number 1 Page 19 of 28 Item # 2 RECREATION-MAY PARK COMMUNITY CENTER º Completed 8 Work Orders. RECREATION-MCBEAN PARK º Completed 9 Work Orders. RECREATION-MCDUFFIE WOODS PARK º Completed 8 Work Orders. RECREATION-NEWMAN TENNIS CENTER º Completed 9 Work Orders. º Discontinued ISDN circuit and replaced with DSL. º Installed Comcast cable modem for better connectivity and removed ISDN circuit. º Upgraded 1 PC to Windows XP. RECREATION-SAND HILLS COMMUNITY CENTER º Installed two HP Pavilion A6010n computers, HP W19 monitors, and two HP Color Laser Jet 2600 printers. RECREATION-SENIOR ADULTS º Completed 5 Work Orders. RECREATION-WARREN ROAD COMMUNITY CENTER º Completed 4 Work Orders. RISK MANAGEMENT º Updated RiskNET software to enable scanning/importing of related claims documentation. º EDMS setup, training, support. º Trained 1 user for 2 hours in VoIP. º Completed 35 Work Orders. º Assisted with the procurement of the following: cordless telephone, scanners, computer monitor, and mouse. º Installed 2 Canon DR-2580c scanners. º Upgraded 5 PC's to Windows XP. RIVERWALK SPECIAL EVENTS º Trained 2 users for 27 hours in Office Automation. º Completed 20 Work Orders. Attachment number 1 Page 20 of 28 Item # 2 SHERIFF`S OFFICE - ADMINISTRATION º Trained 5 users for 60 hours in Office Automation. º Trained 1 user for 2 hours in VoIP. º Completed 141 Work Orders. º Upgraded New World Application from version 7 to version 8. º Provided service and support for 275 Mobile Data Terminals. º Provided service and support for 922 portable radios. º Programmed and put into service 344 new portable radios. º Programmed and put into service 30 new tough book computers. º Worked with Sheriff's Office to help implement the COPLINK program in coordination with other local law enforcement agencies. º Provided ongoing support for the New World application. º Upgraded 14 PC's to Windows XP. SHERIFF`S OFFICE - BAILIFFS º Completed 15 Work Orders. º Upgraded 1 PC to Windows XP. SHERIFF`S OFFICE - BOOKING º Designed, developed, and implemented automated export of incarcerated inmates to Bealls to log inmate phone calls. º Completed 213 Work Orders. º Provided ongoing support for the New World application. º Coordinated efforts with New World and Identix to enhance the mug shot / criminal history interface. º Installed one HP Laser Jet 9500 color printer. º Upgraded 3 PC's to Windows XP. SHERIFF`S OFFICE - CID º Trained 18 users for 240 hours in Office Automation. º Completed 478 Work Orders. º Created data layers and buffers to generate a Sex Offender Map for the Sheriff’s Office (for compliance of new laws). º Provided ongoing support for the New World application. º Provided ongoing support for the Data Analysis and Mapping Application. º Coordinated IT purchases and services in response to user requests. º Installed 4 HP NC8430 laptops. º Installed one HP Laser Jet 4700dn in SIS. º Installed 3 computers with DC7700 and monitors with LP1965. º Replaced existing color printer with one HP Color Laser Jet 9500n. º Installed one new HP Laser Jet 2605n printer. º Installed one HP Laser Jet 9500 color printer. º Upgraded 38 PC's to Windows XP. SHERIFF`S OFFICE - CIVIL º Updates and maintenance of the SO Service Tracker Software Package. º Completed 47 Work Orders. º Provided ongoing support for the New World application. Attachment number 1 Page 21 of 28 Item # 2 º Upgraded 4 PC's to Windows XP. SHERIFF`S OFFICE - CRIME SCENE º Completed 34 Work Orders. º Provided ongoing support for the New World application. º Facilitated the movement of Crime Scene Unit technology to larger offices with the Coroner's Building. º Began research process for update or replacement of Cognitech video review software. SHERIFF`S OFFICE - DANIEL VILLAGE º Trained 2 users for 27 hours in Office Automation. º Completed 61 Work Orders. º Provided ongoing support for the New World application. º Installed one HP DC5750 computer and one HP L1740 monitor. º Upgraded 8 PC's to Windows XP. SHERIFF`S OFFICE - DARE º Completed 21 Work Orders. º Upgraded 6 PC's to Windows XP. SHERIFF`S OFFICE - EVIDENCE º Completed 8 Work Orders. º Upgraded 1 PC to Windows XP. SHERIFF`S OFFICE - INTERNAL AFFAIRS º Completed 28 Work Orders. º Provided ongoing support for the New World application. º Replaced broken laptop with HP NW8340 laptop. º Upgraded 2 PC's to Windows XP. SHERIFF`S OFFICE - JAIL ADMIN º Completed 268 Work Orders. º Worked with Jail Admin staff on various New World reports and enhancements related to the 2006 implementation of the New World Corrections module. º Coordinated IT purchases and services in response to user requests. º Began review of forms management in order to help promote office efficiency through automation. º Coordinated implementation of Beall's inmate phone recording system at jail. º Upgraded 5 PC's to Windows XP. SHERIFF`S OFFICE - NARCOTICS º Trained 4 users for 54 hours in Office Automation. º Completed 125 Work Orders. º Provided ongoing support for the New World application. Attachment number 1 Page 22 of 28 Item # 2 º Worked with Narcotics staff to facilitate implementation of special technical equipment for operational support. º Upgraded 4 PC's to Windows XP. SHERIFF`S OFFICE - PHINIZY º Completed 108 Work Orders. º Coordinated IT purchases and services in response to user requests. º Provided ongoing support for the New World application. º Upgraded 9 PC's to Windows XP. SHERIFF`S OFFICE - QUATERMASTER º Completed 9 Work Orders. º Installed wireless point to point to replace T-1 and ISDN at Fleet Walton Way. º Upgraded 1 PC to Windows XP. SHERIFF`S OFFICE - RECORDS º Completed 295 Work Orders. º Facilitated creation and posting of Records Division Web Page on the Augusta, GA Web Site. º Provided ongoing support for the DataMaxx application. º Began process of ensuring GCIC network security compliance for the DataMaxx application. º Provided ongoing support for the New World application. º Coordinated security enhancements for connectivity to GCIC. º Replaced one printer with a HP Laser Jet 9050dn printer. º Upgraded 10 PC's to Windows XP. SHERIFF`S OFFICE - SOUTHGATE º Trained 2 users for 27 hours in Office Automation. º Completed 52 Work Orders. º Installed new network switch. º Installed 2 HP Laser Jet 4350n printers. º Upgraded 6 PC's to Windows XP. SHERIFF`S OFFICE - TNG CENTER º Completed 18 Work Orders. SHERIFF`S OFFICE - TRAINING CENTER º Upgraded 1 PC to Windows XP. SOLICITOR GENERAL º Trained 2 users for 27 hours in Office Automation. º Trained 3 users for 6 hours in VoIP. º Completed 332 Work Orders. º Provided ongoing support for all IT purchases and services. Attachment number 1 Page 23 of 28 Item # 2 º Provided ongoing support for the New World application. º Provided ongoing support for the Prosecutor's Dialog application. º Assisted office staff with gaining access to criminal history records through new SSL VPN connection mandated by GCIC. º Upgraded 26 PC's to Windows XP. SOLICITOR GENERAL VICTIM`S ASSISTANCE º Completed 29 Work Orders. º Installed wireless point to point to replace T-1. º Installed wireless point to point from Narcotics to replace T-1. º Upgraded 4 PC's to Windows XP. SOLID WASTE COLLECTIONS & RECYCLING º Trained 1 user for 15 hours in Office Automation. SOLID WASTE LANDFILL º Assistance with creating billing 2007 solid waste billing file. º Updates, maintenance, and support of the Solid Waste Consolidated System. º Provided service and support for 5 portable radios. º Upgraded GBA application to version 6.73. º Provided ongoing support for GBA application. º Planned, managed, and implemented Phase I of Insight, new Solid Waste application. º Assisted with the procurement of the following: network drop for the Scale House, laptops, additional ram for computers, cash drawer, digital signature pads, SQL Server license, port switch, and replacement computers for XP upgrade. º Installed 9 HP DC5750 computers and monitors HP l1706. STATE COURT JUDGE º Relocated administrative offices from 410 Walton Way to 520 Greene Street. º Completed 46 Work Orders. º Released bids, selected vendor, and began contract negotiation process for the State Court Audio Recording System. º Provided project management and technical support related to the movement of State Court Offices from the Law Enforcement Center to Greene Street. º Coordinated IT purchases and service needs based on user requests. º Upgraded 4 PC's to Windows XP. SUPERIOR COURT JUDGE º Trained 9 users for 18 hours in VoIP. º Completed 153 Work Orders. º Upgraded from PBX to VoIP telephone service. º Enabled wireless access to Grand Jury Room to assist in arbitration work. º Provided coordination of IT purchases and services based on user needs. º Upgraded 2 PC's to Windows XP. Attachment number 1 Page 24 of 28 Item # 2 TAG OFFICE – FARMER’S MARKET º Completed 29 Work Orders. TAG OFFICE – SOUTHSIDE º Completed 6 Work Orders. TAX ASSESSORS º Trained 4 users for 54 hours in Office Automation. º Completed 171 Work Orders. º Conducted monthly status meetings to stay on top of all IT needs. º Performed the Year End procedures for GA Boats. º Performed the Year End procedures for new businesses. º Provided ongoing support for the WinGAP Application. º Provided ongoing support for IT related purchases. º Provided ongoing support for the TACS Application. º Provided support for the WinGAP yearend process. º Documented end of year Processes for WinGAP. º Moved scanner from Mapping to Administration. º Developed better procedures for National Change of Address (NCOA) processing. TAX COMMISSIONER º Trained 7 users for 87 hours in Office Automation. º Completed 123 Work Orders. º Developed better procedures for National Change of Address (NCOA) processing. º Established procedures to upload photos into the VCS Tax 2000 Application. º Participated in periodic status meetings to stay on top of all IT needs. º Provided ongoing support for IT related purchases. º Provided ongoing support for the VCS Tax 2000 Application. º Provided support for the Mobile Home Tax Billing. º Provided support for the Property Tax Billing. º Provided support for the Tax Digest Preparation. º Provided ongoing support for the Peachtree Software Application. TRANSIT DEPARTMENT º Trained 2 users for 27 hours in Office Automation. º Completed 83 Work Orders. º Provided service and support for 12 portable radios and 38 mobile radios. º Created Bus Route Disaster Routes for Transportation Dept. º Created buffer for Para Transit Bus. º Assisted Trapeze with the implementation of Map Maker. º Provided ongoing support for Trapeze application. º Assisted with the procurement of a replacement computer and additional ram for computers for XP upgrade. º Installed one HP DC5750 computer and L1706 monitor. º Upgraded 10 PC's to Windows XP. Attachment number 1 Page 25 of 28 Item # 2 TREES AND LANDSCAPE º Upgraded 1 PC to Windows XP. UTILITIES - BAY STREET º Trained 17 users for 289 hours in Office Automation. º Completed 408 Work Orders. º Provided service and support for 34 portable radios. º Installed 2 Optima projectors. º Installed 1 Canon DR-2580. º Installed one HP Compaq TC4400 tablet pc. º Replaced 9 computer and monitors with HP DC5750 computers and HP L1965 monitors. º Replaced one laptop with HP NW8230 laptop. º Upgraded 8 PC's to Windows XP. UTILITIES - CENTRAL AVE º Trained 1 user for 15 hours in Office Automation. º Completed 94 Work Orders. º Provided service and support for 28 portable radios. º Provided technical assistance and coordination for expansion of office space. º Replaced 7 computers with HP DC5750 computers and HP L1965 monitors. º Replaced one printer with HP Laser Jet 9050DN printer. º Upgraded 5 PC's to Windows XP. UTILITIES - HIGHLAND AVE FILTER º Completed 4 Work Orders. UTILITIES - HIGHLAND AVE FILTER PLANT º Installed and activated new DSL services. º Provided service and support for 14 portable radios. UTILITIES - HIGHWAY 25 º Trained 12 users for 153 hours in Office Automation. º Trained 2 users for 8 hours in GBA. º Completed 153 Work Orders. º Provided service and support for 33 portable radios. º Provided ongoing support for the enQuesta customer service application. º Installed one HP Color Laser Jet 4700DN printer. º Replaced 5 computers with HP DC5750 computers and HP L1965 monitors. º Replaced two printers with HP Laser Jet 9050DN printer. º Installed on Scanjet G4050 Photoscanner. º Installed one Nikon Coolpix l12 camera. º Installed one new Nikon Coolpix L12 camera. º Upgraded 3 PC's to Windows XP. Attachment number 1 Page 26 of 28 Item # 2 UTILITIES - MUNICIPAL BLDG. º Trained 16 users for 213 hours in Office Automation. º Trained 1 user for 27 hours in VoIP. º Completed 275 Work Orders. º Provided ongoing support for the enQuesta customer service application. º Upgraded 1 PC to Windows XP. UTILITIES - N. MAX HICKS WATER TREATMENT PLANT º Trained 2 users for 27 hours in Office Automation. º Completed 123 Work Orders. º Provided service and support for 45 portable radios. º Installed two new HP 1706 monitors and DC5750 computers. º Upgraded 4 PC's to Windows XP. UTILITIES - PLANT 2 º Provided service and support for 9 portable radios. UTILITIES - PLANT 3 º Completed 5 Work Orders. º Replaced one computer with HP DC5750 computer and replaced another with an HP DX5150. º Upgraded 1 PC to Windows XP. UTILITIES - RAW WATER PUMPING º Completed 31 Work Orders. UTILITIES - RAW WATER PUMPING STATION º Provided service and support for 6 portable radios. UTILITIES - WASTE WATER TREATMENT º Trained 4 users for 51 hours in Office Automation. UTILITIES - WASTEWATERTREATMENT º Upgraded 1 PC to Windows XP. UTILITIES -PLANT 2 º Trained 1 user for 15 hours in Office Automation. UTILITIES ADMINISTRATION º Completed 24 Work Orders. º Provided coordination of IT purchases and services based on user needs. º Cooperated with Utilities Administration in planning the implementation of the enQuesta 3e product (scheduled for 2008). Attachment number 1 Page 27 of 28 Item # 2 º Coordinated with Utilities staff regarding the acquisition of equipment for upcoming expansion of AUD operations to Fort Gordon. º Upgraded GBA application to version 6.73. º Provided ongoing support for GBA application. º Implemented notifications in GBA. º Upgraded MVRS to Pervasive database. º Upgraded Gas Detection application. º Upgraded Compliance Suite. WARRANTS º Trained 2 users for 27 hours in Office Automation. º Completed 56 Work Orders. º Provided ongoing support for the New World application. º Provided support for in-house programs developed to complement New World (printing interface, Pre-Warrant Hearing System). º Upgraded 2 PC's to Windows XP. Attachment number 1 Page 28 of 28 Item # 2 PublicSafetyCommitteeMeeting 3/10/20081:20PM PurchaseSecuritygateforCharlesB.WebsterDeten tionCenter Department:Sheriff'sOffice Caption:Approvethepurchaseofasecuritygateintheamou ntof $39,525fromOverheadDoorofAugusta. Background:ThesecuritygatesattheCBWDetentionCenterhave beenin usesince1997.Withinmatesbeingmoveddailybet ween thetwofacilities,themechanicalfeatureshavefa iledmany times.Althoughpreventivemaintenancehasbeenpr ovided, thegateiswornoutandneedstobereplaced.Eac htimeitis repaireditcostsbetween$3000-$5000.Withanave rage populationof1400inmatesbetweenthetwofaciliti es, inmatesaremovedmanytimesdaily365timesayear .Itis imperativethatweprovideadequatesecuritygatest hatare functioningatalltimes.Afterlookingatmytype sofgatesat otherfacilities,itwasdecidedthatthehighperf ormancerigid rollingdoorwouldbestmeetourneeds.Aftergoin gthrough thebidprocess,twocompaniesbidwithOverheadDo orof Augustabeingthelowestbidderat$39,525.00. Analysis:FundsareavailableintheSherif'sbudget.Fund27 8. FinancialImpact:None Alternatives:Approvethepurchaseofasecuritygateintheamou ntof $39,525fromOverheadDoororfAugusta. Recommendation:Fund278 Fundsare Availableinthe Following Accounts: Cover Memo Item # 3 REVIEWEDANDAPPROVEDBY : Finance. Administrator. ClerkofCommission Cover Memo Item # 3