Loading...
HomeMy WebLinkAbout2013-03-25-Meeting Agendawww.augustaga.gov Public Safety Committee Meeting Commission Chamber- 3/25/2013- 12:45 PM PUBLIC SAFETY 1. Discuss the Information Technology 2012 Annual Report. Attachments 2. Motion to approve the minutes of the Public Safety Committee held on March 11, 2013. Attachments 3. Motion to approve Effingham County Extended Care Facility Shelter Agreement. Attachments Public Safety Committee Meeting 3/25/2013 12:45 PM Information Technology 2012 Annual Report Department:Information Technology Department Caption:Discuss the Information Technology 2012 Annual Report. Background:The Information Technology Department provides the Information Technology Annual Report to all department heads and elected officials each year. This report details some of the technical accomplishments and tasks completed by the Information Technology Department during the previous year of 2012. This report also outlines the use of technology and how it affects each respective department, the overall organization and our community. Analysis:The Information Technology Annual Report provides comparative data as a means to measure the overall performance of the Information Technology Department as it strives to provide the technical tools necessary to improve efficiency throughout the organization and meet the needs of our citizens. Financial Impact:N/A Alternatives:N/A Recommendation:Receive the Information Technology 2012 Annual Report as information. Funds are Available in the Following Accounts: REVIEWED AND APPROVED BY: Finance. Law. Cover Memo Item # 1 Administrator. Clerk of Commission Cover Memo Item # 1 Page 1 To: Mr. Fred Russell, Administrator Department Heads and Elected Officials From: Ms. Tameka Allen, Deputy Administrator & Director of Information Technology Date: March 13, 2013 RE: Information Technology 2012 Annual Report The Augusta 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 2012:  IT Customer Satisfaction annual survey demonstrated a 96% approval rating.  Ranked number six (6) in the nation amongst other cities our size in the Digital Cities Survey conducted by the Center for Digital Government. This is the third consecutive year placing in the top seven.  Developed and deployed Augusta’s first internally created Apple App available in the App Store, Augusta Maps iPhone App.  Won a SAVVY Award of Excellence for the Graphic Design of the Public Transit System Map.  Played integral role in meeting the technology needs for the new Sheriff’s Office.  Conducted Camp Data for the City of Augusta’s youth ages 6 – 11 as part of our continuous outreach efforts. The Camp served 108 children.  Improved communications at various sites throughout the county.  Received an estimated 5.2M(million) visitors to www.augustaga.gov  Received an estimated 3.6M visitors to GIS Maps Online.  Processed 10.4M Internet emails, Blocked 6.7M spam emails and 46,527 virus emails.  Installed Cisco equipment throughout the county to include the Charles Webster Detention Center and Methane Plant.  Installed various wireless communications throughout the county to include Utilities- Metering, Fire Administration, Utilities – Fort Gordon, Juvenile Court, Solid Waste Facility Maintenance, Augusta Regional Airport and others.  Installed additional fiber connectivity to produce redundancy in the network.  Added over 1,500 miles of road information to the Augusta Enterprise Geodatabase.  Added over 1,000 new apartment addresses to the Augusta Enterprise Geodatabase to support public safety and emergency response. INFORMATION TECHNOLOGY Tameka Allen Director Michael F. Blanchard Gary Hewett Assistant Director Assistant Director Attachment number 1 \nPage 1 of 45 Item # 1 Page 2  Maintained 80,775 parcels, 222 deleted due to combines and other modifications, 360 new parcels added.  Supported the Economic Development Authority (EDA) of Richmond County with mapping and data requests on numerous projects that are sensitive in nature. Provided over 70 custom maps.  Provided mapping support to outside agencies such as CSRA Regional Commission, Augusta Sports Council and Augusta Tomorrow.  Integrated Crime Mapping and Analysis into GISmap Online Mapping Application for external public viewing and secured analysis.  Configured and installed 40 new computers for the Sheriff’s Office Road Patrol.  Installed 10 new Mobile Data Terminals (MDT’s) for Animal Services.  Upgraded Live Video Streaming Technology provided by EarthChannel to the new h.264 version compatible with iPhones, Androids and iPads.  Implemented a Business Directory on the augustaga.gov website allowing local businesses to submit their business contract information.  Implemented Community Voice Module, which allows citizen and visitors to leave innovative ideas to improve interaction between the community and local government.  Completed the implementation of a Jury module within the Icon Application.  Evaluated and coordinated technology requirements for the new CNG station at Tobacco Road.  Upgraded the telephone system to Key Service Unit (KSU) at Mary Utley Center for HCD.  Installed and implemented MobileIron Smartphone management system.  Provided QA and Project Management for data received by ITOS including processing data, assignment to staff projects, quality control reporting and status reports.  Implemented RedZone Robotics ICOM3 Sewer Inspections application. More detailed IT activities by department are on the following pages: Attachment number 1 \nPage 2 of 45 Item # 1 Page 3 INFORMATION TECHNOLOGY 2012 Annual Report ADMINISTRATORS OFFICE  Completed 70 work orders for Administration.  1 Self Maintainer Work order completed.  Provided ongoing support for NovusAgenda application.  Provided ongoing support for ADP EeTime application. ANIMAL SERVICES  Completed 134 work orders.  Implemented a search for lost and adoptable pets website as a direct request from the vendor in order to remain in compliance with contract obligations.  Configured and installed 8 new computers for animal services to enhance their operation in the field.  Processed multiple security requests.  Provided ongoing support for the Chameleon Application.  Provided ongoing support for IT related purchases.  Performed multiple password resets for the Chameleon application.  Provided support of EeTime Time Clocks.  Phone system restructured.  Upgraded Chameleon to version 4.643.  Implemented scanning into Chameleon.  Installed Google Earth (Map Explorer) for Chameleon.  Provided 311 interface information for Chameleon.  Installed Chameleon on 8 new MDT`s. AUGUSTA CANAL AUTHORITY  Provided support of EeTime Time Clocks. AUGUSTA CARES  Completed 63 work orders. Attachment number 1 \nPage 3 of 45 Item # 1 Page 4  Provided ongoing support for IFAS application.  2 Self Maintainer Work orders completed.  Provided ongoing support for the CityView Application.  Provided updates to CityView Reports.  Provided ongoing support for Lucity.  Provided coordination of IT purchases based on departmental needs.  Upgraded CityView to version 2012.1.  Upgraded CityView to version 2012.3.  Upgraded CityView to version 2012.4 SP2.  Provided ongoing support for ADP EeTime application. AUGUSTA LIBRARY  Completed 17 work orders.  Provided ongoing support for EeTime application. AUGUSTA REGIONAL AIRPORT  Completed 344 work orders.  Worked with various airlines to facilitate the ability to import Excel spreadsheet data directly into the Airport Operations Application database.  Provided ongoing support for the Flight Explorer application.  Provided ongoing support for ManagerPlus application.  Processed multiple security requests.  Provided ongoing support for FBO Manager Application.  Provided ongoing support for IFAS application.  Provided ongoing support for NovusAgenda application.  Managed the relocation of all of the communication equipment to the new FBO at Bush Field.  Provided annual Master`s Week support services.  Programmed and installed new VOIP phone in new FBO.  Upgraded FirePrograms application for the ARA Fire Dept.  1 Self Maintainer Work order completed.  Provided coordination of IT purchases based on departmental needs. Attachment number 1 \nPage 4 of 45 Item # 1 Page 5  Provided support of EeTime Time Clocks.  Began evaluation of business and technical requirements of alternate solutions for FBOPlus application. .  MAC process for construction and relocation of Airport FBO.  Provided ongoing support for ADP EeTime application.  Assessed network requirements and steps needed to implement based on customer`s business needs on their Firestation construction. BOARD OF ELECTIONS  Completed 207 work orders.  Supported the BOE in local redistricting activities, including mapping and printing large format maps for community meetings.  Featured extensive Voter Information in GISmap public community tool enabling citizens to quickly determine their voting precinct location, commissioner, school board official and state representatives. For added convenience hot links to external websites allow citizens to connect with additional contact information.  Processed multiple security requests.  Provided ongoing support for IT related purchases.  Provided ongoing support for ADP EeTime application. CEMETERY - MAGNOLIA  Provided ongoing support for Lucity application.  Provided ongoing support for IFAS application.  Provided support of EeTime Time Clocks.  Provided ongoing support for ADP EeTime application. CEMETERY- WESTVIEW  Provided support of EeTime Time Clocks.  Provided ongoing support for ADP EeTime application. CIVIL AND MAGISTRATE COURT  Completed 150 work orders.  2 Self Maintainer Work orders completed.  Provided ongoing support for the Infax application. Attachment number 1 \nPage 5 of 45 Item # 1 Page 6  Provided ongoing support for the New World application.  Provided ongoing support for the Palatine Electronic Warrant Interchange system.  Provided ongoing support for all IT purchases and services.  Provided ongoing support for the Icon application.  Provided support of EeTime Time Clocks.  Provided ongoing support for ADP EeTime application. CIVIL AND MAGISTRATE COURT - WARRANTS  2 Self Maintainer Work orders completed.  Provided ongoing support for ADP EeTime application. CLERK OF CIVIL AND MAGISTRATE COURT  Managed 2 orders related to IT equipment or software.  Edited, created, revised, and provided ongoing support for several digital forms of legal documents to be used by the Clerk`s staff in Court sessions that allows the staff to digitally complete and print the form in a timely manner.  Provided ongoing support for the Icon application.  Provided ongoing support for the New World application.  Provided ongoing support for all IT purchases and services.  Provided ongoing support for the Infax application. CLERK OF COMMISSION  Completed 110 work orders.  Provided ongoing support for NovusAgenda application.  Provided ongoing support of LaserFiche application.  Provided ongoing support for WebLink.  Replaced 2 Computers.  Coordinated and assisted vendor with analyzing issues caused by Windows Updates to the NovusAgenda servers.  Provided coordination of IT purchases based on departmental needs.  Provided ongoing support for ADP EeTime application.  Provided technical assistance during committee and commission meetings related to the presentation and voting system in the commission chambers. Attachment number 1 \nPage 6 of 45 Item # 1 Page 7 CLERK OF COURT  Completed 573 work orders for Clerk of Superior Court.  1 Self Maintainer Work order completed.  Provided ongoing support for the CDIMS Applications.  Processed multiple security requests.  Provided ongoing support for the FiFa Interface process.  Provide ongoing support for the Print/FAX server.  Managed 5 orders related to IT equipment or software.  Provided ongoing support for the New World application.  Provided ongoing support for the ICON application and Icon Web Case Management.  Assisted with several updates and changes to the Icon application over the course of the year.  Provided ongoing support for all IT purchases and services.  Completed the implementation of a Jury module within the Icon application.  Assisted with making changes to the Icon database server to improve application performance.  Assisted with the implementation of a new process for submitting sentencing forms to the State.  Provided ongoing support for IT related purchases.  Performed multiple password resets for the CDIMS applications.  Replaced the Real Estate Plat Scanner.  Implemented the ability to modify an incorrect FAX number within CDIMS.  Implemented the ability to e-mail from Web Public through the Print/FAX server.  Made changes to accommodate the GSCCCA FTP address change.  Implemented the corrected tab order in CDIMS Indexing and Cashiering.  Implemented the Copy Previous enhancement for Attorney Information in CDIMS.  Ordered and installed a new ScanPro 2000 to read, enhance and print 16mm and 35mm microfilm and microfiche.  Installed dongles, barcode readers, and label writers for the CDIMS application.  Provided ongoing support for the COTT Applications.  Provided ongoing support for ADP EeTime application. CLERK OF STATE COURT Attachment number 1 \nPage 7 of 45 Item # 1 Page 8  Programmed and installed 8 analog lines for Remote Interpretation in courtrooms. CORONER`S OFFICE  Completed 68 work orders.  Created new application for Coroner, including several database upgrades and a more advanced user interface.  Provided ongoing support for all IT purchases and services.  Provided ongoing support for Coroner-specific application systems.  Managed 1 order related to IT equipment or software.  Provided ongoing support for ADP EeTime application. DANIEL FIELD AIRPORT  Completed 1 work order.  Provided annual Master`s Week support services. DISADVANTAGED BUSINESS ENTERPRISE (DBE)  Completed 34 work orders.  Replaced 1 Computer.  Provided ongoing support and modifications for the DBE in-house software application. DISTRICT ATTORNEY  Completed 323 work orders.  Managed 3 orders related to IT equipment or software.  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 and all of its custom interfaces and/or applications that are necessary for DA specific processes.  Continued planning and researching the replacement of Prosecutor Dialog with Tracker.  Provided ongoing support for the Victim`s Assistance application.  Provided ongoing support for ADP EeTime application. E911 DISPATCH  Conducted Telecom audit. Attachment number 1 \nPage 8 of 45 Item # 1 Page 9  Completed 292 work orders.  1 Self Maintainer Work order completed.  Managed 5 orders related to IT equipment or software.  Installed and Updated the New World / ProQA Interface as updates became available.  Upgraded the ProQA/AQUA application as updates became available.  Updated the 3SI Security Systems Tracker as updates became available.  Updated the Cross Search application on a quarterly basis.  Provided ongoing support for the Higher Ground recording software.  Provided assistance in making necessary changes to the Higher Ground recording software.  Provided ongoing support for all IT purchases and services.  Provided ongoing support for the AQUA application.  Provided ongoing support for the New World CAD application.  Provided ongoing support for the Cross Search application.  Provided ongoing support for the InfoRad application.  Provided ongoing support for all the ProQA applications.  Provided ongoing support for the New World CAD Mapping application.  Assisted with the plan to create an offsite Backup 911 Center in case the need was ever to arise for 911 to vacate its current facilities.  Provided the means for an outside QA/QC Vendor to remotely assist 911 in QA/QC work.  Planned and began to lay the groundwork for implementing a new CAD system (New World Enterprise.NET).  Planned and began to lay the groundwork for implementing a new version of ProQA (Paramount).  Provided support of EeTime Time Clocks.  Provided ongoing support for ADP EeTime application. EMERGENCY MANAGEMENT AGENCY  Completed 14 work orders.  Managed 3 orders related to IT equipment or software.  Updated EMA specific software as updates became available.  Provided ongoing support for all IT purchases and services. Attachment number 1 \nPage 9 of 45 Item # 1 Page 10  Assisted in updating the technology used in the EOC.  MAC Process for installation of Smart Board.  MAC Process for relocation of Bizhub. ENGINEERING  Completed 222 work orders.  Completed 9 work orders.  Provided ongoing support for Lucity.  Processed multiple security requests.  Provided ongoing support of NovusAgenda application.  1 Self Maintainer Work order completed.  Provided coordination of IT purchases based on departmental needs.  Provided support of EeTime Time Clocks.  Initiated the process of conducting a business analysis of the how the Road Book is compiled in regards to the PWISE application in the engineering department.  Created/Modified EeTime Group access as requested.  MAC Process for relocation of equipment.  Provided ongoing support for ADP EeTime application. ENGINEERING - STREET LIGHTING  Completed 9 work orders.  Provided coordination of IT purchases based on departmental needs. ENGINEERING - TRAFFIC ENGINEERING  Completed 122 work orders.  Completed 23 work orders.  Processed multiple security requests.  Provided ongoing support for IFAS application.  Provided and coordinated support for equipment needs for Masters Week.  Provided coordination of IT purchases based on departmental needs.  Provided support of EeTime Time Clocks.  MAC Process for relocation of Construction Shop to New Peach Orchard office. Attachment number 1 \nPage 10 of 45 Item # 1 Page 11  MAC Process for Masters Traffic Setup.  Provided ongoing support for ADP EeTime application. ENVIRONMENTAL SERVICES  Completed 335 work orders.  Provided ongoing support of Commonwealth Insight application.  Processed multiple security requests.  Provided ongoing support of Lucity application.  Geocoded spreadsheets maintained by Solid Waste to assist with Vacant Lot maintenance.  Featured solid waste information in GISmap public community tool enabling citizens to quickly determine their days of pickup and solid waste hauler.  Implemented fuel interface between Faster and Fuelmaster applications.  Implemented KeyWatcher application and hardware.  3 Self Maintainer Work orders completed.  Provided coordination of IT purchases based on departmental needs.  Implemented FasterAsset BarCode module.  Provided support of EeTime Time Clocks.  MAC Process for Wireless in the Construction and Maintenance Building.  Provided ongoing support for ADP EeTime application.  Evaluated and coordinated technology requirements for new CNG station at Tobacco Road.  Assessed technology requirements and steps needed to implement new software (ELEMOS) to support requirements in new hauler contract.  Assess network requirements and steps needed to connect scale house and gas plant security system.  Researched and implemented solution for wireless printing based on customer`s business needs.  Researched and implemented solution for mirroring iPads to smart based on customer`s business needs.  Evaluated technical requirements and coordinated server replacement.  Assess wireless network requirements and steps needed to implement. EQUAL EMPLOYMENT OPPORTUNITY (EEO)  Completed 34 work orders. Attachment number 1 \nPage 11 of 45 Item # 1 Page 12  Provided ongoing support of Novus Agenda application.  Provided ongoing support of BalanceAAP application.  Developed/updated existing (IFAS) EEO CDD reports.  Assisted EEO Dept with AAP Reporting.  1 Self Maintainer Work order completed.  Provided coordination of IT purchases based on departmental needs.  Provided ongoing support for ADP EeTime application. EXTENSION SERVICES  Completed 26 work orders.  Provided ongoing support for IT related purchases.  Provided ongoing support for ADP EeTime application. FINANCE - ACCOUNTING  Completed 67 work orders.  Replaced 1 Computer.  Provided coordination of IT purchases based on departmental needs.  Developed report of "I3" CDH assignments for Finance Director.  Provided ongoing support for ADP EeTime application. FINANCE - FLEET MANAGEMENT  Completed 37 work orders.  Completed 69 work orders.  Provided ongoing support for FasterAsset application.  Provided ongoing support for NovusAgenda application.  Programmed and installed new paging system.  Provided coordination of IT purchases based on departmental needs.  Provided support of EeTime Time Clocks.  Provided ongoing support for ADP EeTime application. FINANCE - PAYROLL Attachment number 1 \nPage 12 of 45 Item # 1 Page 13  Implement $500 increase for Full Time employees and $.20 increase for Part Time employees effective February 10 payroll.  Adjust Sick Leave accrual to 5.31 hours per pay period for Fire Suppression employees effective February 24 payroll.  Process 2011 W2`s for Year 2011.  Process 1099 and W2 Magnetic Media for Tax Year 2011.  Completed 74 work orders.  Setup scheduling of Year-end upgrade to Tax Tables.  Made adjustment in sick leave accruals for Fire Suppression employees.  Replaced 2 Computers.  2 Self Maintainer Work orders completed.  Provided troubleshooting regarding discrepancy in Medicare totals for December 14 payroll.  Provided coordination of IT purchases based on departmental needs.  Provided ongoing support for EeTime application. FINANCE - RISK MANAGEMENT  Completed 49 work orders.  Replaced 1 Computer.  1 Self Maintainer Work order completed.  Provided coordination of IT purchases based on departmental needs.  Provided ongoing support for ADP EeTime application.  Researched and recommended technology for remote training based on customer`s business needs. FINANCE DEPARTMENT  Completed 119 work orders for Finance Administration.  Supported Budget Item Detail Processing for 2012.  Assisted in modification of GLIQBA reports.  Developed and modified IFAS CDD reports based on customer specific criteria.  Provided coordination of IT purchases based on departmental needs.  MAC Process for dual monitors.  Provided ongoing support for ADP EeTime application. Attachment number 1 \nPage 13 of 45 Item # 1 Page 14 FIRE DEPARTMENT - ADMINISTRATION  Completed 299 work orders.  Managed 30 Mobile Data Terminals for the Fire Department. Ensured equipment was operational and eliminated viruses present on machines.  Managed 8 orders related to IT equipment or software.  Updated and provided ongoing support for the AED Heartstart application at all the Fire Stations.  Provided ongoing support to the Fire Prevention Bureau in the use of the Firehouse Mobile application.  Provided ongoing support for all IT purchases and services.  Provided ongoing support for the Emergency Reporting Software.  Provided ongoing support for the Firehouse Software.  Provided training on all aspects of the Firehouse applications as requested.  Provided assistance to the internal Firehouse and EMS committees as requested in relation to Technology and Business Process Analysis.  Provided assistance in creating several custom reports inside the Firehouse application.  Provided ongoing support in the areas of NFIRS and NHTSA exports from Firehouse as requested.  Assisted with the construction of FS #10 as it related to IT specific needs.  MAC Process for wireless at the RCFD Admin Building.  Provided ongoing support for ADP EeTime application. FIRE DEPARTMENT - TRAINING  Provided ongoing support for ADP EeTime application. FIRE STATION #1  Completed 53 work orders.  3 Self Maintainer Work orders completed. FIRE STATION #10  Upgraded telephones system to Key Service Unit.  Completed 14 work orders.  MAC Process for relocation of Fires Station #10 to new building. FIRE STATION #11 Attachment number 1 \nPage 14 of 45 Item # 1 Page 15  Completed 15 work orders. FIRE STATION #12  Completed 12 work orders. FIRE STATION #13  Completed 21 work orders. FIRE STATION #14  Completed 3 work orders. FIRE STATION #15  Completed 16 work orders. FIRE STATION #16  Completed 20 work orders. FIRE STATION #17  Completed 2 work orders. FIRE STATION #18  Completed 34 work orders. FIRE STATION #19  Completed 8 work orders. FIRE STATION #2  Completed 3 work orders. FIRE STATION #3  Completed 108 work orders. FIRE STATION #4  Completed 3 work orders. FIRE STATION #5  Completed 23 work orders. Attachment number 1 \nPage 15 of 45 Item # 1 Page 16 FIRE STATION #6  Completed 11 work orders. FIRE STATION #7  Completed 10 work orders. FIRE STATION #8  Completed 70 work orders. FIRE STATION #9  Completed 7 work orders. FORESTRY  Completed 5 work orders. HEERY ENGINEERING  Completed 62 work orders.  1 Self Maintainer Work order completed. HOUSING AND COMMUNITY DEVELOPMENT  Installed 5 new phone lines at Mary Utley Center.  Completed 251 work orders.  Processed multiple security requests.  Upgrade telephone system to Key Service Unit at Mary Utley Center.  3 Self Maintainer Work orders completed.  Provided coordination of IT purchases based on departmental needs.  Developed report of 2011 Vendors for HCD.  MAC Process for Hyde Park Project.  Provided ongoing support for ADP EeTime application.  Assessed network requirements and steps needed to implement additional phone lines at Telfair location.  Assessed network requirements and steps needed to implement additional phone lines at Hyde Park location. Attachment number 1 \nPage 16 of 45 Item # 1 Page 17 HUMAN RESOURCES  Updated Family Y Rates effective for the February 10 payroll.  Updated Basic Life Insurance Rates effective January 1, 2012.  Completed 261 work orders.  Processed weekly ben018 file for ADP.  Processed bi-monthly ben014 file for ADP.  Developed and modified IFAS CDD reports based on customer specific criteria, for the use in reporting and open records requests.  Provided ongoing support for IFAS application.  Processed multiple security requests.  Replaced 6 Computers.  Developed employee demographic file export from IFAS for HealthStat on-site clinic.  Processed bi-monthly FSA file for ADP.  Provided assistance and coordinate procurement of services and equipment for HealthStat Clinic.  Provided coordination of IT purchases based on departmental needs.  Continued implemented ADP EeTime.  Developed Pay Raises report (HR_SALARY_CHANGES) to assist HR.  Developed CDD report to show results of the BEN014 file import into IFAS.  Developed report of SES employees to assist HR.  Provided ongoing support for EeTime application.  MAC Process for installation of Printer. INFORMATION TECHNOLOGY  Completed 7,220 work orders.  Upgraded Live Video Streaming Technology provided by EarthChannel to the new h.264 version compatible with iPhones, Androids and iPads.  Implemented a Business Directory on the augustaga.gov website allowing local businesses to submit their business contract information.  Implemented Community Voice Module, which allows citizens and visitors to leave innovative ideas to improve interaction between the community and local government.  Added additional Order statuses and recoded ATOMS to facilitate their use. Attachment number 1 \nPage 17 of 45 Item # 1 Page 18  Re-wrote AXWrapper as a .NET component and included number of pages in the data that can be returned.  Provided ongoing support for NovusAgenda application.  Provided ongoing support for IFAS application.  Developed and modified IFAS CDD reports based on client specific criteria.  Renegotiated the annual maintenance contract for communications with Motorola. Was able to keep the per unit price the same as it was in previous years saving the County $5,640.00.  Managed approximately 2300 radios for the County. Ensured equipment was operational and maintained properly, and that repairs were made in a timely manner.  Completed ATOMS inventory for Telecom hardware.  Updated AT and T Yellow and White Pages Directories.  Completed yearly Pinpoint911 testing.  Install and configured Cisco Network equipment for the new Sheriff`s Office Administration Building.  Install WI-FI for the Solid Waste Facility Maintenance Building.  Migrated 90 users from Blackberry to Smartphone devices.  Installed Cisco equipment at the Methane Plant for network connectivity.  Installed Cisco equipment in the new PODS and Medical area for the Charles B. Webster Detention Center.  Installed Cisco equipment in the new Video Visitation building at the Charles B. Webster Detention Center.  Installed WI-FI equipment in the new Video Visitation building at the Charles B. Webster Detention Center.  Upgraded two Windows Server 2003 Domain Controllers to Windows 2008 R2 Domain Controller.  Install WI-FI for total coverage of the new Sheriff Administration Building.  Installed WI-FI equipment for total building coverage in the new Judicial Center.  Installed new Cisco network equipment for the new Airport FBO Building.  Upgraded our VMWare environment from VMWare 4.1 to 5.1.  Replaced distribution switch at RCCI with Cisco Nexus 5010.  Installed Cisco network equipment at the Dog House Building at the Max Hicks Plant.  Installed cisco network equipment at the new Utilities Admin Building on Fort Gordon.  Installed WI-FI at the Utilities Administration building.  Installed new Wingap Server. Attachment number 1 \nPage 18 of 45 Item # 1 Page 19  Installed new Cisco equipment at the new Marshal Sub-Station garage.  Installed WI-FI at the Utilities Metering Division Wylds Road.  Installed WI-FI at the Fire Administration Building.  Installed WI-FI at the Utilities Administration Fort Gordon.  Installed new Database server at the Environmental Services Maintenance Building.  Replaced Distribution Switch at the Augusta Regional Airport.  Installed new distribution switch at the E911 Center for 10 Gig connectivity.  Installed network cabling for the Kiosk system at Charles B. Webster Detention Center and JLEC at 401 Building.  Installed two new data drops at the Raw Water Pumping station.  Installed new network equipment for the new Utilities Metering Building.  Installed Network cabling for the Hyde Park project.  Ordered Comcast Internet service for the Hyde Park Project.  Installed new fiber from Sheriff Administration to E911.  Installed 4 Cable drops at the Utilities Alfred Griffin Plant.  Installed WI-FI coverage at Juvenile Court.  Relocated fiber from the Indigent Defense office to the Public Defender’s Office.  Installed WI-FI coverage of the 2nd Floor Augusta Regional Airport Administration.  New fiber connectivity to Environmental Services.  New Fiber connectivity to the Diamond Lakes Recreation Park.  Installed new Cisco network equipment at the Diamond Lakes Recreation Park.  Installed 2 new Mobile Iron servers for mobile device management.  Upgraded the 2 Proxy servers.  Installed surge suppression at the Environmental Services maintenance building.  Completed 2,970 Trackit Work Orders.  Created 295 Active Directory Users accounts.  Processed 10,440,953 Internet emails. Blocked 6,790,348 Spam emails and 46,527 Virus emails.  Installed new GIS Storage SAN.  Replaced 28 Computers. Attachment number 1 \nPage 19 of 45 Item # 1 Page 20  17 Self Maintainer Work orders completed.  Provided coordination of IT purchases based on departmental needs.  Provided support of EeTime Time Clocks.  Developed report of License and Inspection employees for Director.  Developed Crystal report of Outstanding Purchase Orders for Administrative staff.  Developed report of Tenure by Department for Director.  Created/Modified EeTime Group access as requested.  Developed and deployed Augusta’s first internally created Apple App available in the App Store, Augusta Maps iPhone App for parcel, owner, and sales searches via apple devices including iPads, was invited to give a presentation to the South Carolina ArcGIS Users Network at their annual convention.  Added over 1,500 miles of Road information to the Augusta Enterprise Geodatabase.  Added over 1,000 new apartment addresses to the Augusta Enterprise Geodatabase to support public safety and response.  Added 9 new subdivisions including 360 new lots to the Augusta Enterprise Geodatabase.  Maintained 80,775 Parcels, 222 deleted due to combines and other modifications, 360 new parcels added.  Maintained Property Sales and Foreclosure information for 6,708 sales and 620 foreclosures.  Maintained building outlines for a vacant property analysis deleting over 1000 buildings by utilizing tax assessor data, analyzing permit applications and viewing 2011 aerial imagery.  MAC Process for installation of new Smart Board.  MAC Process for setup of warehouse at the Disaster Recovery Site.  Provided ongoing support for ADP EeTime application.  Installed and implemented MobileIron Smartphone management system. JURY CLERK  Provided ongoing support for all IT purchases and services.  Provided ongoing support for the Jury System application.  Assisted with the implementation of a new Jury System application from Icon. JUVENILE COURT  Completed 53 work orders.  Replaced 1 Computer. Attachment number 1 \nPage 20 of 45 Item # 1 Page 21  Provided ongoing support for all IT purchases and services.  Provided ongoing support for the JCATS application.  Provided ongoing support for the New World application.  Assisted with the implementation and planning of new technology to be used by Juvenile Court.  Managed 2 orders related to IT equipment or software.  MAC process for wireless connectivity. LAND BANK AUTHORITY  Completed 22 work orders.  Provided ongoing support for ADP EeTime application. LAW DEPARTMENT  Completed 105 work orders.  Replaced 1 Computer.  2 Self Maintainer Work orders completed.  Provided ongoing support for all IT purchases and services.  Provided ongoing support for the Abacus Law Application.  Provided ongoing support for the SoftPro Application.  Assisted with the implementation/upgrade of new hardware used by the Law Department.  Managed 1 order related to IT equipment or software.  Provided ongoing support for ADP EeTime application.  Provided ongoing support for ADP EeTime application. MARSHAL`S OFFICE  Completed 89 work orders.  Created Win-MIST application, which replaces two existing applications, and provides many additional upgraded technologies.  Created MIST Mobile application, which allows in-field personnel to create and update Enforcement cases via MDT.  1 Self Maintainer Work order completed.  Managed 6 orders related to IT equipment or software.  Provided ongoing support for the Identification International Live Scan Fingerprinting system. Attachment number 1 \nPage 21 of 45 Item # 1 Page 22  Provided ongoing support for the Identix Live Scan Fingerprinting system.  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.  Provided ongoing support for the use of New World Field Reporting.  Provided ongoing support for ADP EeTime application. MARSHAL'S OFFICE - ARA  Completed 93 work orders. MARSHAL'S OFFICE - SUBSTATION  Completed 81 work orders. MAYOR'S OFFICE  Completed 74 work orders.  Recorded videos of weekly mayoral updates and posted them online for public viewing.  Provided ongoing support for ADP EeTime application. NEIGHBORHOOD ENHANCEMENT  Completed 1 work order. NON-COUNTY  Supported the Economic Development Authority (EDA) of Richmond County with mapping and data requests on numerous projects that are sensitive in nature. GIS provided over 70 custom maps in support of marketing commercial and industrial sites to potential industries evaluating relocation to Augusta. All projects were time sensitive requiring quick turnarounds and often required a level of nondisclosure by GIS Staff on the location or companies inquiring about sites.  Provided map of available parking to the Greater Augusta Arts Council for Westobou and Arts in the Heart Festival.  Provided data and support for the CSRA Regional Commission special economic development projects.  Supported Augusta Sports Council with mapping and addresses for community mailings for events including the 2012 Half Marathon and 10K events.  Supported Augusta Tomorrow in mapping and planning efforts for marketing, plans included Medical District Area, Westobou Crossing and other sites targeted in Augusta in their Westobou Master Plan.  Supported Downtown Development Authority mapping for events including parking availability for Attachment number 1 \nPage 22 of 45 Item # 1 Page 23 Arts in the Heart.  Supported Artspace Development activities with mapping and data export.  Provided CAD export of GIS data for the Georgia Health and Science University for Master Plan.  Created maps for the United Postal Service in support of their rural delivery project and route assignment activities.  Provided GIS data for the University of Maryland Study.  Created banners, graphics, flyers in support of the Living Green Committee, including newsletters, event marketing, and event support.  Provided mapping to public though sales of maps and data by written request.  Provided ongoing support for ADP EeTime application. OLD GOVERNMENT HOUSE  Completed 7 work orders. PLANNING AND DEVELOPMENT  Completed 954 work orders.  Provided ongoing support for NovusAgenda application.  Provided ongoing support for Lucity application.  Implemented a secured sign in for all zoning information on GISmap enabling staff to quickly and securely search zoning, special exceptions, stipulations, blanket rezoning internally and externally.  Maintained Zoning, Special Exceptions, and Case Inventory layers in GIS Enterprise Geodatabase on a monthly basis. Updated these layers to an internal site to provide customer care personnel with a quick means of answering a citizen’s request for zoning information.  Provided GIS data exports for consultants on projects involving zoning.  Maintained custom feature classes for LOMA and Flood Buyout Properties online to assist their citizen response time.  Supported Opportunity Zone Annual Report, provided extensive GIS Analysis from data imported from various systems for property information within each zone, building permits, code enforcement actions, crime rate, and new businesses.  Provided ongoing support for ADP EeTime application. PLANNING AND DEVELOPMENT - LICENSE AND INSPECTION  Setup and trained customers on new iPads.  Provided ongoing support for the CityView Application.  Conducted monthly status meetings to stay informed on all License and Inspection technology needs. Attachment number 1 \nPage 23 of 45 Item # 1 Page 24  Created multiple custom reports from CityView.  Updated Case Sizes for Excise Tax in CityView.  Created multiple custom searches in CityView.  Ran the Past Due Business License process.  Provided multiple CityView configuration and rule updates.  Provided support for the annual Alcohol License Renewal process.  Provided support for the annual Business License Renewal process.  Provided support for the annual Request for Gross Revenue process.  Provided ongoing support for IT related purchases.  Performed multiple password resets for the CityView application.  Provided support of EeTime Time Clocks.  Provided ongoing support for the CityView Mobile Application.  Provided ongoing support for the CityView Public Portal Application.  Created/Modified EeTime Group access as requested.  Addressed file size issue with documents and images on the CityView server.  Investigated CityView Mobile technology.  Implemented CityView Mobile on iPhones and iPads for the Building Inspectors.  Upgraded CityView to version 2012.1.  Upgraded CityView to version 2012.3.  Upgraded CityView to version 2012.4 SP2.  Updated the Permit Fees in CityView for 2012.  Implemented face-to-face credit card payments for CityView.  Implemented CityView Portal (on-line) payments for Business Licenses.  Replaced the CityView application server.  Assisted with assigning PIN numbers to all Business License records.  Updated letterhead in CityView letters to accommodate the new department name.  Provided 311 interface information for CityView.  Processed multiple Open Records Requests for Permit information. Attachment number 1 \nPage 24 of 45 Item # 1 Page 25  Tested CityView Mobile on the Motion F5 devices.  Fulfilled multiple requests related to the PReMA project.  Created a new report to reconcile credit card payments with the bank.  Created a new work flow for Records Retention in CityView.  Upgraded CityView Public Portal to version 2012.3.  Identified Documents and Images not uploaded to the CityView repository.  Created a process and workflow to handle eVerify and SAVE form procedures.  Identified multiple areas where CityView data required clean-up.  Updated Permit Sold report to display an asterisk in front of the Address if it is a temporary address.  MAC Process for relocation of equipment.  Provided ongoing support for ADP EeTime application. PROBATE COURT  Completed 60 work orders.  Created Cash Drawer application which allows Probate Clerks to accept fee payments at counter, controls a cash drawer for cash transactions, and prints receipts.  Created Cash Drawer Maintenance application which provides the ability to analyze daily transactions, allocate security codes, print clerk code cards, and various reports.  Facilitated changes to the existing application to accommodate new concealed weapons permit procedures.  Provided ongoing support for all IT purchases and services.  Managed 1 order related to IT equipment or software.  Updated the Probate application as updates became available.  Provided ongoing support for the State-Wide system used for the issuance of Concealed Weapons Permits. PROBATION  Completed 25 work orders. PROCUREMENT  Completed the implementation of E-Verify numbers printing on Purchase Orders. .  Completed 261 work orders.  Provided ongoing support for IFAS application. Attachment number 1 \nPage 25 of 45 Item # 1 Page 26  Provide assistance with IFAS year-end procedure.  Replaced 7 Computers.  1 Self Maintainer Work order completed.  Provided coordination of IT purchases based on departmental needs.  Developed a CDD report to list the updated ship-to-address of vendors within IFAS.  Developed a CDD report to list the E-verify numbers of vendors within IFAS.  Developed attendance report (HR_HOURS_DATE_PROC) to assist Procurement.  Provided Inquiry Only access into the CityView application.  MAC Process for installation of Smart Board.  Provided ongoing support for ADP EeTime application. PROCUREMENT - PRINT SHOP  Completed 32 work orders.  Replaced 1 Computer. PUBLIC DEFENDER  Completed 418 work orders.  1 Self Maintainer Work order completed.  Provided ongoing support for all IT purchases and services.  Provided ongoing support for the New World application.  Provided ongoing support for the JCATS application.  Assisted with the setup of new PCs delivered to Public Defender by the State.  Managed 1 order related to IT equipment or software.  MAC Process for relocation of equipment due to flooding of existing building. RCCI  Completed 91 work orders.  1 Self Maintainer Work order completed.  Provided ongoing support for all IT purchases and services.  Provided ongoing support for the Jail Management application.  Provided support of EeTime Time Clocks. Attachment number 1 \nPage 26 of 45 Item # 1 Page 27  Provided ongoing support for ADP EeTime application. RECREATION - ADMINISTRATION  Completed 469 work orders.  Replaced 5 Computers.  1 Self Maintainer Work order completed.  Processed multiple security requests.  Provided ongoing support for the CLASS Application.  Provided ongoing support for CLASS On-Line Registration.  Provide ongoing support for the CLASS biometrics.  Provided ongoing support for IT related purchases.  Performed multiple password resets for the CLASS application.  Provided support of EeTime Time Clocks.  Provided ongoing support for the Lucity Application.  Created/Modified EeTime Group access as requested.  Implement Lucity for Recreation.  Performed the Senior Nutrition Program roll-over into 2012.  Set up the IT Training Lab for CLASS training.  MAC Process for Time Clock.  Provided ongoing support for ADP EeTime application.  Provided ongoing support for ADP EeTime application. RECREATION - AQUATIC CENTER  Completed 32 work orders.  Programmed and installed 2 new emergency phones.  Provided support of EeTime Time Clocks.  MAC Process for relocation of equipment. RECREATION - AQUATICS  Submit monthly employee wellness files for Payroll. RECREATION - AUGUSTA GOLF COURSE Attachment number 1 \nPage 27 of 45 Item # 1 Page 28  Completed 3 work orders.  Provided ongoing support for the GeN Application.  Transitioned the Golf Course from Augusta to The Patch in Augusta LLC.  Replaced the server at the Golf Course with a County server. RECREATION - BARTON VILLAGE  Completed 8 work orders. RECREATION - BERNIE WARD COMMUNITY CENTER  Completed 3 work orders.  Provided support of EeTime Time Clocks. RECREATION - CARRIE J. MAYS  Completed 1 work order.  Provided support of EeTime Time Clocks. RECREATION - DIAMOND LAKES  Completed 12 work orders.  Provided support of EeTime Time Clocks.  Provided support for the HVAC software application. RECREATION - DOUGHTY PARK  MAC process for new cabling.  MAC process for wireless connectivity. RECREATION - EASTVIEW PARK  Completed 6 work orders. RECREATION - EISENHOWER PARK  Completed 16 work orders. RECREATION - FACILITIES MANAGEMENT  Completed 55 work orders.  Provided support of EeTime Time Clocks. Attachment number 1 \nPage 28 of 45 Item # 1 Page 29  Set up preventive maintenance work orders for the Judicial Center in Lucity.  Provided ongoing support for the Lucity application.  Provided ongoing support for ADP EeTime application. RECREATION - FACILITIES MANAGEMENT - JLEC  Provided support of EeTime Time Clocks. RECREATION - FACILITIES MANAGEMENT - MUNICIPAL BLDG  Provided support of EeTime Time Clocks. RECREATION - FACILITIES MANAGEMENT - WEBSTER  Provided support of EeTime Time Clocks. RECREATION - FLEMING ATHLETIC OFFICE  Completed 4 work orders. RECREATION - FLEMING TENNIS CENTER  Provided support of EeTime Time Clocks. RECREATION - H.H. BRIGHAM COMMUNITY CENTER  Completed 9 work orders.  Provided support of EeTime Time Clocks. RECREATION - H.H. BRIGHAM SENIOR  Provided support of EeTime Time Clocks. RECREATION - H.H. BRIGHAM SWIM COMPLEX  Completed 15 work orders.  Provided support of EeTime Time Clocks. RECREATION - MAY PARK COMMUNITY  Provided support of EeTime Time Clocks. RECREATION - MCBEAN PARK  Completed 8 work orders.  Provided support of EeTime Time Clocks. Attachment number 1 \nPage 29 of 45 Item # 1 Page 30 RECREATION - MCDUFFIE WOODS PARK  Completed 5 work orders.  Provided support of EeTime Time Clocks.  Assessed network requirements, and steps needed to install EeTime clock per customer`s request.  MAC Process for Time Clock. RECREATION - NEWMAN TENNIS CENTER  Completed 17 work orders.  Upgrade telephone system to Key Service Unit.  Provided support of EeTime Time Clocks.  Submit monthly employee wellness files for Payroll.  MAC Process for installation of new phone system. RECREATION - SAND HILLS COMMUNITY CENTER  Completed 17 work orders.  1 Self Maintainer Work order completed.  Provided support of EeTime Time Clocks. RECREATION - WARREN ROAD COMMUNITY CENTER  Completed 2 work orders.  Provided support of EeTime Time Clocks. RECREATION FACILITIES  Completed 126 work orders. RIVERWALK SPECIAL EVENTS  Completed 1 work orders.  Provided support of EeTime Time Clocks. SENTINEL  Completed 9 work orders. SHERIFF`S OFFICE - ADMINISTRATION  Completed 311 work orders. Attachment number 1 \nPage 30 of 45 Item # 1 Page 31  Integrated Crime Mapping and Analysis into GISmap Online Mapping Application for external public viewing and secured investigative analysis by user sign in.  Scripted auto update Python Scripts to provide E911 CAD mapping process and Data Analysis and Mapping to receive updates during IT Scheduled Maintenance Days.  Performed several software upgrades to the Mobile Data Terminals in the Sheriff’s Office fleet over the course of the year to enhance performance.  Configured and installed 40 new computers for the Sheriff`s Office Road Patrol.  Managed the installation of a Bi-Directional amplifier system for the new South Precinct building.  Managed 260 Mobile Data Terminals for the Sheriff’s Office. Ensured that equipment was operational and eliminated any viruses that were found.  Relocated phone services to new building.  Upgraded to Voice Over Internet Protocol (VOIP) telephone service.  Replaced 18 Computers.  1 Self Maintainer Work order completed.  Provided ongoing support for QuickBooks.  Provided ongoing support for all IT purchases and services.  Managed 23 orders related to IT equipment or software.  Provided ongoing support for the New World application.  Continued the Support of the COPLINK application as requested.  Provided continuing GCIC support as necessary.  Provided assistance as necessary during the move to the new Sheriff Administration Building.  Began the implementation of New World MSP to upgrade the Jail Management System, Records Management System, and Mobile applications used by the RCSO.  Provided support of EeTime Time Clocks.  Created/Modified EeTime Group access as requested.  MAC Process for Inmate Kiosk Expansion.  MAC Process for Time Clock Installation.  MAC Process for relocation and installation of existing and new Smart Board for 400 RCSO building.  MAC Process for construction and relocation of the RCSO into the new admin building.  Provided ongoing support for ADP EeTime application. Attachment number 1 \nPage 31 of 45 Item # 1 Page 32  Assessed network requirements, and steps needed to install EeTime clocks at multiple locations per customer`s request. SHERIFF`S OFFICE - BAILIFFS  Completed 2 work orders.  MAC Process for New Equipment for Bailiff`s office. SHERIFF`S OFFICE - BOOKING  Completed 192 work orders.  Upgraded to Voice Over Internet Protocol (VOIP) telephone service.  Replaced 6 Computers.  1 Self Maintainer Work order completed.  Provided ongoing support for the New World application.  Provided support as needed for the Identix Fingerprinting system.  Assisted with the implementation of a new Fingerprint system to identify inmates as they are booked and released.  Provided support of EeTime Time Clocks. SHERIFF`S OFFICE - CID  Completed 566 work orders.  Created Intelligence Portal page to house data specific to that division of the Sheriff`s Office.  Replaced 51 Computers.  4 Self Maintainer Work orders completed.  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.  Provided support as needed for CopLink.  Provided support as needed for Memex.  Provided support as needed for Offender Watch.  Provided ongoing support for the EWI application.  Assisted with the implementation of Case Cracker. SHERIFF`S OFFICE - CIVIL Attachment number 1 \nPage 32 of 45 Item # 1 Page 33  Completed 47 work orders.  2 Self Maintainer Work orders completed.  Provided ongoing support for the New World application.  Provided ongoing support for the Service Tracker application. SHERIFF`S OFFICE - CRIME SCENE  Completed 20 work orders.  Replaced 3 Computers.  Provided ongoing support for the New World application.  Provided ongoing support for applications specific to the Crime Scene Unit.  Provided assistance in the implementation of a new I-AFIS fingerprint identification system. SHERIFF`S OFFICE - DANIEL VILLAGE  Completed 239 work orders.  Provided ongoing support for the New World application.  Provided ongoing support for the EWI application.  Provided ongoing support for the New World Mobile Field Reporting application.  Provided support of EeTime Time Clocks. SHERIFF`S OFFICE - DARE  Completed 39 work orders.  Replaced 4 Computers. SHERIFF`S OFFICE - EVIDENCE  Provided ongoing support for the New World application. SHERIFF`S OFFICE - INTERNAL AFFAIRS  Completed 10 work orders.  Replaced 2 Computers.  2 Self Maintainer Work orders completed.  Provided ongoing support for the New World application. SHERIFF`S OFFICE - JAIL ADMIN Attachment number 1 \nPage 33 of 45 Item # 1 Page 34  Completed 195 work orders.  Upgraded to Voice Over Internet Protocol (VOIP) telephone service.  5 Self Maintainer Work orders completed.  Assisted with the expansion and support of the Inmate Kiosk system to include Inmate Communication with Jail Admin through the Kiosks.  Assisted with the implementation of Wireless access for the Medical vendor in Booking.  Assisted with planning technology needs for the CBWDC expansion project to include the new Booking facility.  MAC Process for VOIP upgrade.  MAC Process for wireless at the Charles B. Webster Detention Center Visitors Building.  MAC Process for connection of network printer. SHERIFF`S OFFICE - NARCOTICS  Completed 125 work orders.  Upgraded and programmed 16 new portable radios for narcotics with the new APX portables from Motorola.  2 Self Maintainer Work orders completed.  Provided ongoing support for the New World application.  Provided ongoing support for the EWI application.  Provided support of EeTime Time Clocks.  MAC Process for setup of Pollock Bizhub. SHERIFF`S OFFICE - QUARTERMASTER  Completed 17 work orders.  Provided ongoing support for the New World application.  Provided ongoing support for the Quartermaster application. SHERIFF`S OFFICE - RECORDS  Completed 353 work orders.  Replaced 9 Computers.  4 Self Maintainer Work orders completed.  Provided ongoing support for the DCI eAgent system. Attachment number 1 \nPage 34 of 45 Item # 1 Page 35  Provided ongoing support for the New World application.  Altered GCIC forms as needed within the New World application. SHERIFF`S OFFICE - SOUTHGATE  Provided ongoing support for the New World application.  Provided ongoing support for the EWI application.  Provided ongoing support for the New World Mobile Field Reporting application.  Provided support of EeTime Time Clocks.  MAC Process for setup of Pollock printers. SHERIFF`S OFFICE - TRAINING CENTER  Completed 64 work orders.  1 Self Maintainer Work order completed.  Assisted in the training of new officers in the areas of the Electronic Warrant Interchange system, Webmail, and New World Mobile as requested.  Provided support of EeTime Time Clocks. SHERIFF`S OFFICE - WEBSTER DETENTION CENTER  Completed 180 work orders.  Managed the replacement of a new repeater system and radio tower at the Webster Detention Center.  Upgraded to Voice Over Internet Protocol (VOIP) telephone service.  Replaced 10 Computers.  2 Self Maintainer Work orders completed.  Provided ongoing support for the EWI application.  Provided ongoing support for the New World application. SOLICITOR GENERAL  Completed 258 work orders.  Provided ongoing support for all IT purchases and services.  Provided ongoing support for the New World application.  Continued the process of planning to replace Prosecutor Dialog with Tracker. Attachment number 1 \nPage 35 of 45 Item # 1 Page 36  Provided support as necessary in the use of the Infax Docketing system. SOLICITOR GENERAL VICTIM`S ASSISTANCE  Completed 49 work orders. STATE COURT JUDGE  Completed 83 work orders.  Created an Accountability Courts webpage as a direct request from State Court Judges in order to make information easily accessible as it pertains to the functions of Accountability Court.  Provided support as necessary in the use of the Infax Docketing system.  Provided ongoing support for the BIS Digital Court Recorder system.  Upgraded the BIS Digital Recording system as updates became available.  Provided ongoing support for all IT purchases and services.  Managed 2 orders related to IT equipment or software.  Assisted with implementing technology solutions to be used by the Accountability Court.  MAC Process for new Pollock Bizhub for DUI Court.  MAC Process for AV problems within Court Room 3G & 3H. SUPERIOR COURT JUDGE  Completed 728 work orders for Superior Court Judge.  2 Self Maintainer Work orders completed.  Provided assistance as needed in the support of the Voc Edit system used by Court Reporters.  Provided support as necessary in the use of the Infax Docketing system.  Provided ongoing support for all IT purchases and services.  Assisted in the implementation of a Remote Interpreter system used in the Courtrooms.  Managed 6 orders related to IT equipment or software.  MAC Process for new equipment for new hire. TAG OFFICE – EAST AUGUSTA  Completed 63 work orders. TAG OFFICE – SOUTHSIDE  Completed 35 work orders. Attachment number 1 \nPage 36 of 45 Item # 1 Page 37  1 Self Maintainer Work order completed.  MAC Process for purchase of ATA for Credit Card Machine.  MAC Process for relocation of color printer. TAX ASSESSOR'S OFFICE  Completed 358 work orders.  Provided QA and Project Management for data received by ITOS included processing data, assignment to staff projects, quality control reporting, and status reports.  Upgraded Pictometry Online (POL) and provided continued technical support for staff. Provided one-on-one training with new users on the POL.  Added multiple subdivisions to the Tax Maps for 2012 assessment purposes.  Determined the workflow for ITOS parcel sketch comparison by utilizing existing software and licensing for Pictometry Changefinder.  Worked with outside vendor to support Tax Assessor`s web presence.  Remove agents from IVR system.  Replaced 2 Computers.  2 Self Maintainer Work orders completed.  Processed multiple security requests.  Provided ongoing support for the WinGAP Application.  Provided ongoing support for the TACS Application.  Assisted with creating 2012 Future Year for 2013.  Imported GA Boats into the TACS Application.  Ran the National Change of Address (NCOA) process and updated the WinGAP database accordingly.  Discontinued the Interactive Voice Response (IVR) application.  Assisted with producing the 2012 Tax Digest.  Performed the Year End procedures for WinGAP.  Provided ongoing support for IT related purchases.  Created multiple custom reports from CityView.  Upgraded CityView to version 2012.1.  Upgraded CityView to version 2012.3.  Upgraded CityView to version 2012.4 SP2. Attachment number 1 \nPage 37 of 45 Item # 1 Page 38  Converted WinGAP to WinGAP SQL.  Set up security for WinGAP SQL.  Ordered and installed a new WinGAP SQL server.  Assisted with producing the 2012 Mobile Home Tax Digest.  Imported new businesses from 2011 into the Personal Property database.  Created a new Business process for the Tax Assessor’s Office in CityView.  Identified all reports that need to be re-written for WinGAP SQL.  Rewrote multiple reports for WinGAP SQL.  Installed Visual Studio 2008 for TAO employees who are re-writing WinGAP reports for SQL.  Added the Neighborhood field to CityView.  Updated Permit Sold report to display an asterisk in front of the Address if it is a temporary address. TAX COMMISSIONER'S OFFICE  Completed 435 work orders.  Used data analysis and mapping tools to calculate the amount of taxes generated and percentage of delinquent taxes per Commission District for a public brochure.  Created and integrated a new GIS Feature Class into GISmap for staff to search and view properties on the "No Bid Property" list maintained by TCO. This is a secured search for inter-office use.  3 Self Maintainer Work orders completed.  Processed multiple security requests.  Provided ongoing support for the VCS Tax Application.  Provided ongoing support for the Peachtree Application.  Performed weekly updates of the Tax Bill Export for Sturgis Web Services and the TCO Web Site.  Provided ongoing support for the FiFa Interface process.  Periodically updated Mail Fee to $175 for specified batch numbers.  Provided ongoing support for IT related purchases.  Upgraded CityView to version 2012.1.  Upgraded CityView to version 2012.3.  Upgraded CityView to version 2012.4 SP2.  Upgraded Sage 50 Accounting (Peachtree) to version 2013. Attachment number 1 \nPage 38 of 45 Item # 1 Page 39  Created multiple custom reports from CityView.  Assist with identifying and replacing missing Associated Files in VCS Tax.  Performed the Peachtree Year End process.  MAC Process for Pollock Bizhub.  Provided ongoing support for ADP EeTime application. TRANSIT DEPARTMENT  Completed 117 work orders.  Provided graphics support and produced updated Transit System Map and Individual Route Maps. IT-GIS won a SAVVY Award of Excellence for the Graphic Design of the Public Transit System Map and was recognized by the City, County Communications & Marketing Association (3CMA).  Managed the installation of 10 new Motorola tablets in the rural vans for transit.  Provided coordination of IT purchases based on departmental needs.  Graphics and photographic support for creating an Augusta Public Transit Slide presentation for the GA FTA.  Supported data creation and export for the implementation of BlirpIT for Mobility Transit. .  Exported GIS data for bus stop locations, shelters, and facilities for ADA Review by Public Transit.  Updated Augusta Public Transit web page graphics and downloadable maps for marketing of their System Map and Route Cards to the public.  Calculated the percentage of each bus route in the old city limits for reporting documents.  Created newspaper ads for public meetings.  MAC Process for installation of new equipment in Municipal Building.  MAC Process for relocation of equipment during renovations.  Implemented RouteMatch application.  Upgraded Trapeze Maps. . UTILITIES - ADMINISTRATION  Completed 519 work orders.  Supported 2012 Annual Water Rate change process.  Implemented meter ERT change out updated process in enQuesta.  Implemented Utilities Obama Scam Alerts in Online and Phone Bill Payment systems.  Generated enQuesta data views for IT GIS. Attachment number 1 \nPage 39 of 45 Item # 1 Page 40  Planned and assisted in enQuesta server OS upgrade.  Added new field in enQuesta to track meter changes done by Vanguard.  Implemented 100W meter erts in enQuesta.  Provided support with enQuesta year-end processes.  Implemented enQuesta Maintenance Releases in Production and Train environments.  Created Dispatch Report into Cognos for After Hours water turn-ons.  Implemented solution to automate daily reports generation on Cognos Server.  Developed erts report in Cognos for defective erts replacement program.  Implemented 3318 Re-Check Work Order in enQuesta for water service disconnection.  Modified enQuesta work order 389 to remove previous read fields.  Implemented modifications to Final Bill Notice in enQuesta as requested.  Managed enQuesta user access as requested by Utilities.  Ensured access for users to Cognos Report Net as requested.  Managed user security in I-Doxs.  Provided Solution to expand enQuesta cash stations for Utilities Peach Orchard Rd relocation.  Developed and implemented two ongoing monthly scheduled Cognos reports for the vendor Zel, and the Water Loss Analysis Team comprised of Utilities and the vendor Cavanaugh.  Developed several Cognos reports for purposes of data verification of other pre-existing Utilities Month End reports by request of the Utilities Assistant Director of Finance and Administration.  Created a Cognos report for Utilities Customer Service to identify accounts with an incorrect account opened date in the future.  Developed a Cognos report to extract Utilities billing adjustment transactions and interrelated data.  Created Cognos reports for the exporting ERT type meter data and the applicable CIS information to a file for use in the replacement of these defective ERT meters.  Aided Utilities in the analysis of 2010 and 2011 billing data for the Utilities Assistant Director of Finance and Administration. This included the development of several Cognos reports for extracting accounts billed in 2010 and 2011 and applicable data and an Excel presentation document summarizing the results broken down by account type and rate code.  Developed and implemented an ongoing daily scheduled Cognos report utilized by Dispatch for the identification of accounts that are turned off for non-payment.  Implemented RedZone Robotics ICOM3 Sewer Inspections application.  Implemented 2012 Holiday Dates for Utilities Call Center.  Completed and provided cost and resources analysis to migrate and upgrade UCCX to Linux Attachment number 1 \nPage 40 of 45 Item # 1 Page 41 Platform.  Modified IVR Payment log report as requested.  Researched Customer and Agent Web Chat solution for AUD Call Center.  Continued implementation of IVR Outdial database log.  Continued implementation of IVR enQuesta screen pops.  Revised Cisco CRS Holiday dates files to remove Furlough Dates for Call Center.  Completed migration and transition of MVRS application and server to new environment.  Implemented 100W erts in MVRS for meter reading.  Implemented data logging in MVRS to monitor water usage.  Upgraded MV-RS to v8.3.  Upgraded Pervasive clients on all workstations running MVRS.  Assisted Utilities with retrieving data logging data from the erts.  Implemented Ft. Gordon client and database in Lucity.  Upgraded Lucity test environment to 7.4 for end-user testing.  Completed Technology needs assessment for Utilities and ESG utilizing Lucity.  Developed and Modified Inventory Warehouse reports in Lucity to aid in Annual inventory process.  Implemented Lucity Dashboard and WebMap in test Environment.  Implemented Lucity WebMap in Test Environment for AUD Dashboard Demo.  Configured Lucity test environment for Utilities GIS 10.1 testing.  Customized Utilities Work Order in Lucity as requested.  Coordinated and assisted Utilities Demo the Lucity Dashboard.  Updated 2012 Key codes for ESG OP 10 Wastewater and Pre-Treatment applications.  Upgraded ETAP to version 11.1.1.  Completed Implementation of Utilities Finance Document archival into EDMS.  Upgraded Tremble Business application.  Evaluated Business and Technical requirements on HachWIMS for water treatment plant data management.  Upgraded GraniteXP to 461.  Upgraded ESS Compliance Suite to 4.42.0. Attachment number 1 \nPage 41 of 45 Item # 1 Page 42  Upgraded Tremble Business application.  Provided chat and desktop sharing solution for inter division communication in Customer Service.  Ensured FTP access for Utilities and vendors for data sharing.  Completed analysis on Ft. Gordon Building and WTP expansion.  Began analysis on Peach Orchard Rd Building relocation.  Ensured Meter Division Relocation to Wylds Rd.  Ensured additional Drops and IT equipment for RWPS.  3 Self Maintainer Work orders completed.  Generated a Cognos report for Utilities listing all penalty transactions and related CIS data in the course of the last calendar week.  Coded and implemented scheduled scripts for the automatic transferring of several Cognos reports to various network locations and FTP sites for users and vendors.  Developed report for identification or inventory transactions of parts detailed by several user- defined variables.  Began Implementation of DicksonWare upgrade.  Purchased and Applied additional License for Dicksonware.  Ensured Red Flag Compliance documents archival into EDMS.  Began planning for Work Order Asset Management System replacement.  Provided coordination of IT purchases based on departmental needs.  Conducted Monthly IT meetings to stay informed on all AUD technology needs.  Processed multiple Network and Application security requests.  Coordinated Technical Resources for AUD contract employees as needed.  Provided ongoing support of enQuesta 3e.  Provided ongoing support of Webconnect and Payconnect.  Provided ongoing support for Cisco CRS and Unified IP IVR 7.0(1)SR5.  Provided ongoing support for Cisco Agent and Supervisor Desktop.  Provided ongoing support of I-Doxs.  Provided ongoing support for Cognos Report Net.  Provided ongoing support for Cisco CRS Historical Reporting.  Provided ongoing support of Lucity. Attachment number 1 \nPage 42 of 45 Item # 1 Page 43  Provided ongoing support of MV-RS.  Provided as needed support of ESS Compliance Suite.  Provided as needed support of Office TimeSheets.  Provided as needed support of Operator 10.  Provided as needed support of GraniteXP.  Provided as needed support of DicksonWare.  Provided as needed support of ICOM3.  Assessed network requirements, and steps needed to install EeTime clocks at Bay Street, Ft. Gordon, Central Ave, and Hwy 25, per customer`s request.  Provided support of EeTime Time Clocks.  Created/Modified EeTime Group access as requested.  Created GIS web services for future Lucity Mobile Upgrade for internal demos and testing.  Served as the primary technical and software support for Utilities GIS Staff, offering assistance with creating geometric networks, department wide ArcReader deployment, Pictometry Project, and online mapping secured service updating.  Deployed ArcReader software upgrades to multiple divisions for viewing GIS data.  Deployed ArcGIS 10 and 10.1 upgrade to multiple divisions for internally modifying data for planning purposes.  MAC Process for Metering Division Relocation to AUD Wylds Road.  MAC Process for Microsoft Lync solution for use with Remote Assistance.  MAC Process for Time Clock Installation.  MAC Process for wireless at the Bay Street Building.  MAC process for wireless at Metering Wylds Road.  Provided ongoing support for ADP EeTime application. UTILITIES - BAY STREET  Worked with Utilities to support their GIS Staff for water and sewer feature classes.  Provided support of EeTime Time Clocks. UTILITIES - CENTRAL AVE  Completed 111 work orders.  3 Self Maintainer Work orders completed. Attachment number 1 \nPage 43 of 45 Item # 1 Page 44  Provided support of EeTime Time Clocks.  MAC Process for relocation of C&M to the Cushman Building. UTILITIES - FORT GORDON  Completed 39 work orders.  Relocated phone services to new building.  Installed 8 new phone lines.  MAC Process for pickup and disposal of antiquated equipment.  MAC Process for installation of New Equipment for Admin Building.  MAC Process for installation of Smart Board. UTILITIES - HIGHLAND AVE FILTER PLANT  Provided support of EeTime Time Clocks. UTILITIES - HIGHWAY 25  Completed 241 work orders.  3 Self Maintainer Work orders completed.  MAC Process for Time Clock Installation. UTILITIES - MUNICIPAL BUILDING  Completed 159 work orders. UTILITIES - N. MAX HICKS WATER TREATMENT PLANT  Completed 99 work orders.  1 Self Maintainer Work order completed.  Provided support of EeTime Time Clocks.  MAC Process for new phone. UTILITIES - PLANT 2  Completed 5 work orders. UTILITIES - PLANT 3  Completed 4 work orders. UTILITIES - RAW WATER PUMPING Attachment number 1 \nPage 44 of 45 Item # 1 Page 45  Completed 17 work orders.  Provided support of EeTime Time Clocks. UTILITIES - WASTE WATER TREATMENT  Completed 26 work orders.  1 Self Maintainer Work order completed.  MAC Process for relocation of computer and Bizhub. UTILITIES C AND M WYLDS RD  Completed 69 work orders.  1 Self Maintainer Work order completed. Attachment number 1 \nPage 45 of 45 Item # 1 Public Safety Committee Meeting 3/25/2013 12:45 PM Minutes Department:Clerk of Commission Caption:Motion to approve the minutes of the Public Safety Committee held on March 11, 2013. Background: Analysis: Financial Impact: Alternatives: Recommendation: Funds are Available in the Following Accounts: REVIEWED AND APPROVED BY: Cover Memo Item # 2 Attachment number 1 \nPage 1 of 2 Item # 2 Attachment number 1 \nPage 2 of 2 Item # 2 Public Safety Committee Meeting 3/25/2013 12:45 PM Motion to Approve Effingham County Extended Care Facility Shelter Agreement Department:Fire Department Caption:Motion to approve Effingham County Extended Care Facility Shelter Agreement. Background:In approximately 1999, ECECF had a mandatory evacuation and did not have a plan/agreement with how to deal with such circumstances. Since that time, there has been an agreement for ECECF to use the Bernie Ward Center as a Shelter in the event of a mandatory evacuation. This is a renewal of that agreement. Analysis: Financial Impact: Alternatives:Deny Recommendation:Approve Funds are Available in the Following Accounts: None necessary REVIEWED AND APPROVED BY: Finance. Law. Administrator. Clerk of Commission Cover Memo Item # 3 March 18, 2013 This agreement is made between Effingham County Extended Care Facility of Springfield, Georgia (“ECECF”) and Augusta, Georgia. Augusta, Georgia agrees to provide a shelter for residents from the facility during a mandatory evacuation. The Shelter will be located at the Bernie Ward Community Center, 1935 Lumpkin Road, Augusta, Georgia. ECECF agrees to defend, indemnify, and hold harmless Augusta, Georgia for any claims arising out of the use of the Shelter. ECECF will provide all materials necessary to operate the Shelter, including but not limited to: Transportation to and from the Shelter for all residents; Professional supportive staff to compensate the number of residents sheltered; Dietary, Housekeeping, Maintenance and Administration Staff; and Any needed medical supplies, oxygen, medicine, bandages, etc. ___________________________ ___________________________ Deke Copenhaver Michael W. Murphy, EMHP Mayor, Augusta, Georgia Environment of Care Manager Date ______________________ Date _______________________ Attest: _____________________ Clerk of Commission Attachment number 1 \nPage 1 of 1 Item # 3