THE DATA CENTER 2014 IT PLAN - PART I

Data Center 2014 IT Plan
THE DATA CENTER 2014 IT PLAN - PART I
The Data Center’s 2014 Baseline Budget totals $7,623,070, which represents a neutral budget when
compared to revised 2013 operating budget. The nineteen 2014 IT-Plan requests total $1,808,085, and when
combined with the 2014 Baseline Budget totals $9,431,155.
IT PLAN GOALS
We have identified the following IT Planning Goals for the year 2014:
1. To partner with our customers to identify their business needs. Recommend and provide IT solutions
that fully support their business goals in an efficient and environmentally appropriate manner.
2. Provide centralized data processing services with appropriate chargeback methodology and rates to
ensure customers receive detailed and accurate invoices or reports of Data Center Services, as
requested by the Commissioners.
3. Leverage new technologies to develop E-Government solutions and provide other Centralized IT
Services as required by all Franklin County agencies.
4. Continue to improve our Customer Relationship Management (CRM) methodologies to establish,
develop, and maintain long-term business relationships - providing a level and quality of service that
exceeds our customers’ expectations.
5. Continue to maintain and improve the Franklin County Data Network (FCDN) to provide our customers
with consistently high levels of computing services at competitive prices. The FCDN includes both the
physical infrastructure and the computing platforms that reside on the Network.
6. Continue to develop our Business Continuity and Disaster Recovery capabilities to ensure that Franklin
County agencies have the capability to continue providing critical County services under any conditions.
This vital capability will require additional funding to ensure critical services as needed.
7. Continue to host and support the Franklin County Justice System (FCJS). This mission-critical
application requires substantial application programming enhancements as requested by the Clerk of
Courts and the Court of Common Pleas Division.
8. Upgrade the Franklin County Storage Area Network (SAN), internet service provider (ISP) service for
redundancy, the Exchange email system and SharePoint platform. Refresh outdated network
equipment, domain controller, wireless access point controller and programming development servers.
9. Acquire and utilize new call center ticketing and project delivery software for facilitate better customer
service, organization and project delivery.
FCDC 2014 Information Technology Plan – Part 1
8/13/2013
Page 1 of 11
Data Center 2014 IT Plan
ORGANIZATIONAL STRUCTURE
The following section depicts and describes the current organizational structure of the Data Center. We
currently are authorized 67 positions, with 64 filled.
DATA CENTER CIO
The Franklin County Auditor, as Administrator of the Franklin County Automatic Data Processing Board, has
appointed the CIO as a Deputy Auditor. The CIO plans, organizes, coordinates, and directs the resources of
the Franklin County Data Center within the policies and regulations adopted by the Data Board.
The CIO is also responsible for overall communication and coordination of information technology issues with
Data Center customers. The CIO works closely with elected and appointed officials to ensure optimal technical
integration of county information systems.
FCDC 2014 Information Technology Plan – Part 1
8/13/2013
Page 2 of 11
Data Center 2014 IT Plan
ADMINISTRATIVE DIVISION
The Administrative Division manages the daily administrative functions of the Data Center and provides
administrative support to the Data Center management and staff. The Administration section is crucial in
maintaining structure within the Data Center’s daily processes. Responsibilities include scheduling of facilities,
preparing and distributing Data Board agendas, preparing staff briefings, scheduling staff and facility
resources, reception and management of public information requests for Data Center, mail distribution,
document filing, visitor management, coordinating facility needs with PFM, and other administrative functions.
Human Resources is responsible for the overall management of personnel related matters as well as helping
to ensure that the vision and mission remain at the forefront of the Data Center. Responsibilities include
compliance guidance and leadership, performance management and the administration of related
documentation such as performance evaluations, individual development plans, and progressive discipline
forms, recognition initiatives, and payroll processing. Training administration and travel coordination, benefit
administration, records retention and leave management are other functions managed by Human Resources.
The division also provides policy guidance including policy procedure development, contracting and acquisition
management, conducting internal reviews to ensure compliance with applicable laws, regulations, policies and
procedures, and organization of the state audit.
FINANCIAL SERVICES DIVISION
The Financial Services Division provides of a wide range of financial and planning services to the Data Center
and its customers. These services include financial and cost accounting services, planning and budgeting
services, and custody and control of IT assets. Management responsibilities include cost allocation and
service rate development; customer charge-backs, accounts receivable/payable, purchasing, and office
supplies management. This division is also responsible for productivity measurement and financial analysis
and reporting.
BUSINESS SERVICES DIVISION
The Business Services Division provides business analysis, and project management services from initial
assessment through final acceptance, assuring their customers receive quality products and services delivered
on time and within budget. They implement best solutions without bias to any particular technology and based
on best practices and provides quality assurance test procedures and documentation.
COMPUTING SERVICES DIVISION
The Computing Services Division is responsible for the administration, operation, management and
performance of the Franklin County Data Network (FCDN). This includes both the physical infrastructure and
the computing platforms that reside on the network. The Computing Services Division is organized into the
following sections:
Network Administration Section – The Network Administration Section staff are responsible for planning,
designing, maintaining, operating, documenting, and administering the routers, switches, and firewalls that
make up the Franklin County Data Network (FCDN). Technologies used within the network include fiber optic,
Ethernet, wireless, VPN, VOIP, and data/telecommunications load management.
Server Administration Section – This section is responsible for the operation, maintenance, and systems
administration of the IBM iSeries Enterprise servers, Windows client/server, and virtual server computing
platforms. This section is also responsible for administration of file, print, email, and Internet/Intranet
FCDC 2014 Information Technology Plan – Part 1
8/13/2013
Page 3 of 11
Data Center 2014 IT Plan
resources. In addition, the section is responsible for backups, Exchange, eFiling, WebFocus, SharePoint, and
MUNIS.
Security Section - The Security Section is responsible for managing the Data Center Information Security
Program and coordinating the Franklin County Data Network (FCDN) Security Policies. This includes user
account management, access control, vulnerability and application management, monitoring of security logs,
managing Windows security updates, anti-virus administration, managing the web content filter, and consulting
on security issues. The Security Section also performs security analyses on agency projects and electronic
signature (E-Sign) applications.
DEVELOPMENT SERVICES DIVISION
The Development Division is primarily responsible for the design, development, testing, implementation, and
maintenance of computerized business applications - including the conversion of applications between
computing platforms. This includes maintenance of commercial off-the-shelf (COTS) applications. Application
programming services include maintenance and modification of existing applications and development of new
applications that are custom-tailored to customers' business needs. All applications are developed using
industry-standard design, documentation and quality assurance methodologies. Development services include
E-government, custom database management applications, Internet and Intranet informational pages, and
web-based application portals.
CUSTOMER SERVICE AND SYSTEMS OPERATIONS DIVISION
Customer Service Section - The Customer Service section provides Help Desk and first-level support services
to Data Center customers on all problem issues. These include all computer applications and computing
platforms supported by the Data Center plus second-level support on a back-up basis as defined in customer
Service Level Agreements (SLAs). The Customer Support Center is responsible for tracking all incoming calls,
dispatching technical personnel, and providing customers with the current status on all problems reported to
them. The Desktop Services Team is responsible for the installation, configuration, relocation, and
replacement of desktop workstations, terminals, printers, scanners, and other PC peripherals for the over 3500
County workers who use these information systems. The technicians assigned to Desktop Services Team also
perform minor repairs and service to this equipment.
Systems Operations Section – this section is responsible for the day-to-day operations of the iSeries and
Windows server platforms. This responsibility entails nightly execution of all computer runs for the customers
along with ensuring that all consumable supplies are available for producing the required output. This is
accomplished by adhering to established procedures, processes, and utilization of various software packages.
Desktop System Management
The Franklin County Data Center serves as the primary support organization for over 2,000 workstations and
200 networked printers countywide. We also have a backup support role for approximately 3,000 workstations
supported by agency IT staffs. We also provide augmentation for large installation projects for these
organizations. Besides our responsibility for workstation support, the Data Center maintains and services all
midrange direct-attached devices.
Windows Server Administration
The architecture of the Data Center is a Microsoft Multiple Master Domain Model. That means two or more
domains are sharing each other’s resources using a two-way trust. The Data Center Server Administration
FCDC 2014 Information Technology Plan – Part 1
8/13/2013
Page 4 of 11
Data Center 2014 IT Plan
Section supports both UNIX and Windows operating systems. Our current UNIX operations consist of the our
Internet firewall, which protects our network from the outside world. All user accounts on the Franklin County
Data Network are administrated by the Data Center from a centralized location. This also includes files,
applications and e-mail accounts. The Data Center provides access to the Internet through a single Internet
Service Provider (ISP) and hosts several county Web sites. Internet bandwidth use is monitored and
periodically adjusted to meet countywide demand.
Franklin County Data Core Network
Data Communications/Physical Network
FCDC 2014 Information Technology Plan – Part 1
8/13/2013
Page 5 of 11
Data Center 2014 IT Plan
The Franklin County Data Network consists of two layers: the core and access layers. The core layer consists
of two Cisco Catalyst 6500E series switches with integrated MFSCs (Multilayer Feature Switch Card) which
connect to remote site via switched virtual circuits. Our core switches are connected via redundant 10Gbs
fiber links. The access layer consists of Cisco 3750E series Gigabit Ethernet switches, Cisco 3750, and Cisco
3560 Fast Ethernet switches that connect back to the core layer through 1Gbs fiber.
We have connections to twenty remote sites via AT&T OPT-E_MAN/GIG-E-MAN switch virtual circuits. The
Data Center also has a 1 Gigabit remote connection to the off-site Disaster recovery.
iSeries Diagram
The Data Center currently operates an IBM Power 750 16-processor (6-licensed) system with 256 GB main
memory, 15 TB disk storage, and six 1 GB Ethernet network connections.
The iSeries configuration is comprised of five LPARs (logical partitions) FCDC1, FCDC2, FCDC0, FCJS and
TESTING and various components as depicted in the diagram above.
LPAR FCDC1 supports the Department of Jobs and Family Services, Probate Court applications including the
Probate Court web-accessed online Marriage application, and Adult Probation applications. Connection to the
Franklin County Data Network is accomplished via a 1 GB Ethernet card. This machine currently supports
over 2264 devices attached via the network. The Department of Jobs and Family Services uses over 1470
devices connected via the network, along with several network-attached printers. Adult Probation uses
FCDC 2014 Information Technology Plan – Part 1
8/13/2013
Page 6 of 11
Data Center 2014 IT Plan
network-attached devices for accessing their application as well. Nightly batch processing is completed for all
applications executing on this iSeries along with nightly backup of data files. This System has the ability to run
Structured Query Language (SQL), providing the capability to query data located within this configuration. This
partition includes Network attached printers in the 8th floor Computer Room.
LPAR FCDC2 system supports approximately 14 applications running under CICS including the Franklin
County Sheriff’s Office applications, the Board of Elections Booth Worker application, the Auditors Dog license
applications, the Estate Tax application, Fiscals Direct Deposit, Redeemed Warrants, and Management
System applications, the Board of Health’s Immunization application, Animal Control’s Kennel application, the
Personal Property Tax applications, the Recorder’s application and the Auditor’s Dog-eNet web-accessed dog
license application. Connection to the Franklin County Data Network is accomplished via a 1 GB Ethernet card.
There are currently over 300 devices connected via network attachment. Of the devices connected there are
approximately 20 printers attached throughout the application Network connected both locally and remotely.
Nightly batch processing is completed on all applications along with backup of all data files. By utilizing the
network connection, data is shared and loaded to the VINE (Victim Information Notification Everyday)
application on a daily basis. In the case of the MUGSHOT server, data sharing is performed on an hourly
basis. This partition includes Network attached printers in the 8th floor Computer Room.
LPAR FCDC0 is the development platform. Connection to the Franklin County Data Network is accomplished
via a 1 GB Ethernet card and supports the Data Center’s application development staff.
LPAR FCJS houses the Clerk of Courts FCJS application and the Civil Online application. This partition is
connected to the Franklin County Data Network via a 1 GB Ethernet attachment.
LPAR TEST is a test environment for Server Administrators to test configurations before placing them into
production. This partition is connected to the Franklin County Data Network via a 1 GB Ethernet attachment.
Printing capability is provided by two 6400 dot matrix printers and the Xerox Laser printers connected via the
network. The 6400 dot matrix printers are for miscellaneous continuous forms. The laser printers are used to
produce standard 8 ½ x 11 reports as used by the Sheriff’s Office and Probate Court.
The tape library and two tape drive are attached to the iSeries machines (one IBM Ultrium tape library
consisting of two LTO-4 tape drives 1.6 TB per tape capacity each) via fiber attachment and provide for the
sharing of tape media. LTO-4 technology was chosen to support the increased size of backups; LTO-4 offers
storage of 1.6TB on each cartridge, while also supporting backup encryption. The tape library supporting
these devices contains over 200 cartridges. All iSeries machines use a tape management system which tracks
all tapes with retention and rotation information.
The iSeries machine supports a relational Database (DB2) and provides the capability to run queries on all
data. All iSeries Databases are connected to the Franklin County Data Network and are capable of sharing
data among each other, and all other platforms. This machine also has the capability of supporting web pages
and web servers by utilizing the IBM WebSphere software product. The IBM supplied QUERY utility permits
basic queries to be performed on any database file associated with an individual machine. LINUX also can be
supported via an LPAR.
In 2011, the iSeries server was upgraded to the latest IBM “Power 7” CPU in the model 750 server.
End of Part I
____________________________________________________________
Data Center 2014 IT Plan – Part II
FCDC 2014 Information Technology Plan – Part 1
8/13/2013
Page 7 of 11
Data Center 2014 IT Plan
Technology Initiatives:
The Data Center provides centralized Information Technology services to all Franklin County agencies.
Services include: application development and maintenance; shared file and print services; server hosting;
Internet access services; email and spam filtering; desktop support; project management; and business
analysis.
To better serve our customers in today’s rapidly changing business environment, the Data Center is
developing and applying competencies in Business Intelligence, E-Government application development,
database integration and management services, document imaging and collaboration tools, increased
deployment of wireless and VOIP technologies, and Business Continuity/Disaster Recovery planning and
preparedness.
Below are the key Information Technology service initiatives for 2014 and beyond:
Network & Computing Systems
The Data Center will continue to replace outdated and out-of-maintenance equipment to ensure we continue to
provide uninterrupted service to our customers and prepare for future technology initiatives. We are
coordinating with PFM to verify that new cabling projects meet established standards. Increasing stability and
bandwidth to our remote sites is another important goal we are working with PFM to achieve. Wireless access
to both the internal network and the internet has seen an increase in demand, and we are working to establish
standards for hardware and security to offer this service safely in County facilities.
Business Continuity & Disaster Recovery
During 2013 the Data Center with the assistance of a third party consultant, conducted a disaster recovery
assessment. Both a basic and customized model was presented and agencies felt that the basic DR model
was sufficient. The Data Center is currently working on a comprehensive plan which when implemented will
provide a sufficient level of service in the event of a disaster. Included in the plan will be an updated Storage
Area Network (SAN), an updated Windows back-up system. DR iSeries model and updating the Franklin
County email to Exchange 2013 and other items that are currently being reviewed.

Responsive Information Technology Services
The County Web Portal and other web-based services have dramatically improved information sharing and
reduced the costs of managing information. The Microsoft Enterprise License Agreement (MSELA) provides
integrated document imaging, web portal, and communications technologies. We are continuing to support
SharePoint technology using simplified application development capability. We are implementing a new Real
Estate Tax Assessment system and providing continued support for the Franklin County Justice System
(FCJS). We are working with the Clerk of Court’s to provide records through the Ohio Courts Network (OCN)
to the Ohio Supreme Court and other authorized entities. The Data Center is also supporting the new Courts’
e-Filing system by providing project management, development, data migration, implementation, and
maintenance support.
Technical Competency
The Data Center continues to build staff competency in developing and maintaining new technology business
applications as well as maintaining proficiency with legacy systems. Examples of critical training needs include
application design and architecture, .NET and Java programming, network design and administration, wireless
FCDC 2014 Information Technology Plan – Part 1
8/13/2013
Page 8 of 11
Data Center 2014 IT Plan
and VOIP technologies, business systems analysis, project management, cost accounting, relational database
administration, and SharePoint technology implementation. Data Center team members will work diligently
during 2014 to sharpen technical skills to ensure that innovative and efficient services are provided.
Service Delivery
The Data Center continues to build staff competency in developing and maintaining new technology business
applications as well as maintaining proficiency with legacy systems. Examples of critical training needs include
application design and architecture, .NET and Java programming, network design and administration, wireless
and VOIP technologies, business systems analysis, project management, cost accounting, relational database
administration, and SharePoint technology implementation. Data Center team members will work diligently
during 2014 to sharpen technical skills to ensure that innovative and efficient services are provided.
E-Government
The demand for E-Government services is growing exponentially as high-speed access to the Internet
becomes increasingly available. We are improving the Commissioners’ Resolution Management System
(CRMS). The Board of Elections provides Online Voter Registration, Absentee Ballot Requests, Online PollWorker Information, tracking of ballot requests, on-line training for election workers, and incident reporting at
voting locations, and On-line Election Results. We are rewriting the Treasurer’s Online Payment System to
create a more reliable online experience for the taxpayer who uses this service, and are refining the new Bulk
Payer System for the Treasurer’s customers. We are responsible for all hardware and software in support of
the Courts’ e-Filing system.
Integrated Information Management
The County is reducing its environmental footprint by standardizing the use of energy-efficient computing
systems and network components. The use of standardized information exchange formats enable the County
to quickly share information through the Internet, County Web Portal, and secure data lines. This capability is
essential in meeting homeland security and law enforcement intelligence requirements. The Data Center’s
Server Consolidation program is increasing efficiency and reducing costs by replacing aging servers with a
smaller number of more powerful, flexible, and energy-efficient systems. In addition, the Data Center’s project
to reorganize the County’s public web servers and to incorporate server virtualization technology will improve
efficiency and website reliability for County websites.
Records Management
The Data Center has established a standardized and centralized document imaging system to facilitate
collaborative, cross-agency sharing of indexed records. County agencies such as the Prosecuting Attorney,
Court of Common Pleas, Domestic and Juvenile, Coroner, Board of Elections, Auditor-Real Estate, Treasurer,
Commissioner’s Clerk, Coroner, PFM, and the Clerk of Courts are implementing document imaging systems
with assistance from the Data Center.
The Data Center is now offering document management and workflow services through OnBase. Expansion of
this efficient system will take place in 2014.
Mobile Information Technology
Wireless services will continue to provide agencies with network access at virtually any location. Mobile
technologies, such as laptop computer wireless “air” cards and tablets are currently being introduced into
FCDC 2014 Information Technology Plan – Part 1
8/13/2013
Page 9 of 11
Data Center 2014 IT Plan
County information systems and applications. These technologies will require specialized equipment and
training of Data Center staff to meet security and administration requirements. The Data Center has provided
data encryption software for all county laptops and selected types of mobile data storage devices. Commercial
mobile wireless cards work in concert with Data Center managed wireless points to provide flexible
connectivity as required to meet our customers’ business needs.
Support of Green IT
Virtualization: The Data Center is actively supporting server virtualization through our Server Consolidation and
SAN data storage initiatives - reducing the number of physical systems and their power requirements. It also
reduces the amount of waste to be recycled at the end of the equipment lifecycle.
Power Management: Data Center standards call for equipment that is both Energy Star and ACPI compliant –
allowing users to actively manage the power consumption of their systems by setting the disk drives and
monitor to shut off if not used within a set period of time.
Materials Recycling: Outdated computer systems are recycled to keep harmful materials such as lead,
mercury, and chromium out of landfills. Computing supplies, such as printer cartridges, paper, and batteries
are recycled as well. These efforts are coordinated with PFM and Purchasing through countywide contracts.
Telecommuting and Teleworking: Agencies have the ability to provide their employees with encrypted laptop
computers or software that can access their work applications through VPN or Remote Access. Video
Conferencing software allows meetings and training to be held remotely. Advantages include increased
worker satisfaction, reduction of greenhouse gas emissions related to travel, and lower overhead costs for
office space, heat, lighting, etc.
Virtual (Web) Conferencing: This initiative allows customers to host, participate, and record meetings and
conduct training over the Internet. This reduces travel costs and the need for paper documents as supporting
materials are provided and stored in electronic format.
Voice Over IP (VOIP): Reduces the telephony wiring infrastructure by sharing the existing Ethernet copper (a
toxic metal). Data Center VOIP initiatives are being coordinated with PFM and other agencies on a per project
basis.
Reduction of Paper Usage: The Data Center promotes initiatives to reduce the amount of paper used and to
increase the use of recycled paper products. Electronic reports are used whenever possible and duplex
printers are purchased as a standard to allow printing on both sides of the paper. Data archiving and storage
is used to both increase the ability to retrieve and produce records and also to reduce the need to maintain and
store records in paper format.
FCDC 2014 Information Technology Plan – Part 1
8/13/2013
Page 10 of 11
Data Center 2014 IT Plan
Data Center 2014 IT Plan – Part II (Continued)
Information Technology Project Plans
(Requests for Results)
Please see Attachments
FCDC 2014 Information Technology Plan – Part 1
8/13/2013
Page 11 of 11
2014 Microsoft Enterprise License Agreement
Agency: Data Center
Project Plan Priority: 1
Project Name: 2014 MSELA
Fund: 1000
Project Number: 1
Org Number: 10220100
NOTE: You should have a completed form for each org within your 2014 budget.
Business Need: Microsoft Enterprise Licensing Agreement annual reporting
Microsoft Enterprise Licensing Agreement:
Line
Seat Classification
Seat
Count
To be
Completed by:
1
Estimated Total Seats as
of Nov. 30, 2013
21
Agency
2
Minus Total Base Seats
previously reported
21
Data Center
3
Minus Total True-up Seats
previously reported
4
2013 True-ups (SecondYear True-Up Seats
0
Instructions / Comments
Number derived from agency inventory or
count of total desktops meeting definition
of seat.
This figure (provided) will be the total
number of seats your Agency/Org has
reported
Data Center
This figure (provided) will be the total
number of True-up seats your agency or
Org has reported
Agency
Difference of line 2 from line 1. Enter this
figure in BRASS as True-up seats.
(Line 3 = Line 1 – Line 2)
Line #1: Should the agency expect a total seat count of 130 at November 30, 2013 (all qualifying
units), that number should be entered as an estimated number of total seats.
Line #2: This figure has been provided by the Data Center and has been determined by adding the
original number of base seats from the previous contract.
Line #3: This figure has been provided by the Data Center and has been determined as the total
True-up seats since the previous contract.
Line #4: Subtract lines 2 and 3 from line 1 to equal the 2013 - Second Year true-up seats.
2014 Microsoft Enterprise License Agreement
Agency: Data Center
Project Plan Priority: 1
Project Name: 2014 MSELA
Fund: 1000
Project Number: 2
Org Number: 10220200
NOTE: You should have a completed form for each org within your 2014 budget.
Business Need: Microsoft Enterprise Licensing Agreement annual reporting
Microsoft Enterprise Licensing Agreement:
Line
Seat Classification
Seat
Count
To be
Completed by:
1
Estimated Total Seats as
of Nov. 30, 2013
15
Agency
2
Minus Total Base Seats
previously reported
47
Data Center
3
Minus Total True-up Seats
previously reported
4
2013 True-ups (SecondYear True-Up Seats
-32*
Instructions / Comments
Number derived from agency inventory or
count of total desktops meeting definition
of seat.
This figure (provided) will be the total
number of seats your Agency/Org has
reported
Data Center
This figure (provided) will be the total
number of True-up seats your agency or
Org has reported
Agency
Difference of line 2 from line 1. Enter this
figure in BRASS as True-up seats.
(Line 3 = Line 1 – Line 2)
*The Data Center is giving up 20 seats that were held for the loaner pool because the pool is used for
temporary replacement of defective machines and serve only as a secondary machine to a primary
users. Four seats were given up for a reduction in staff and nine were transferred to 10220300 within
the Data Center.
Line #1: Should the agency expect a total seat count of 130 at November 30, 2013 (all qualifying
units), that number should be entered as an estimated number of total seats.
Line #2: This figure has been provided by the Data Center and has been determined by adding the
original number of base seats from the previous contract.
Line #3: This figure has been provided by the Data Center and has been determined as the total
True-up seats since the previous contract.
Line #4: Subtract lines 2 and 3 from line 1 to equal the 2013 - Second Year true-up seats.
2014 Microsoft Enterprise License Agreement
Agency: Data Center
Project Plan Priority: 1
Project Name: 2014 MSELA
Fund: 1000
Project Number: 3
Org Number: 10220300
NOTE: You should have a completed form for each org within your 2014 budget.
Business Need: Microsoft Enterprise Licensing Agreement annual reporting
Microsoft Enterprise Licensing Agreement:
Line
Seat Classification
Seat
Count
To be
Completed by:
Instructions / Comments
Number derived from agency inventory or
count of total desktops meeting definition
of seat.
This figure (provided) will be the total
number of seats your Agency/Org has
reported
1
Estimated Total Seats as
of Nov. 30, 2013
20
Agency
2
Minus Total Base Seats
previously reported
8
Data Center
3
Minus Total True-up Seats
previously reported
0
Data Center
This figure (provided) will be the total
number of True-up seats your agency or
Org has reported
4
2013 True-ups (SecondYear True-Up Seats
Agency
Difference of line 2 from line 1. Enter this
figure in BRASS as True-up seats.
(Line 3 = Line 1 – Line 2)
12*
Transferred from 10220200 & 10220300
Line #1: Should the agency expect a total seat count of 130 at November 30, 2013 (all qualifying
units), that number should be entered as an estimated number of total seats.
Line #2: This figure has been provided by the Data Center and has been determined by adding the
original number of base seats from the previous contract.
Line #3: This figure has been provided by the Data Center and has been determined as the total
True-up seats since the previous contract.
Line #4: Subtract lines 2 and 3 from line 1 to equal the 2013 - Second Year true-up seats.
1
2014 Microsoft Enterprise License Agreement
Agency: Data Center
Project Plan Priority: 1
Project Name: 2014 MSELA
Fund: 1000
Project Number: 4
Org Number: 10220400
NOTE: You should have a completed form for each org within your 2014 budget.
Business Need: Microsoft Enterprise Licensing Agreement annual reporting
Microsoft Enterprise Licensing Agreement:
Line
Seat Classification
Seat
Count
To be
Completed by:
1
Estimated Total Seats as
of Nov. 30, 2013
8
Agency
2
Minus Total Base Seats
previously reported
12
Data Center
3
Minus Total True-up Seats
previously reported
4
2013 True-ups (SecondYear True-Up Seats
-4*
Instructions / Comments
Number derived from agency inventory or
count of total desktops meeting definition
of seat.
This figure (provided) will be the total
number of seats your Agency/Org has
reported
Data Center
This figure (provided) will be the total
number of True-up seats your agency or
Org has reported
Agency
Difference of line 2 from line 1. Enter this
figure in BRASS as True-up seats.
(Line 3 = Line 1 – Line 2)
The Data Center has transferred four seats to 10220300 for a transfer to FTEs.
Line #1: Should the agency expect a total seat count of 130 at November 30, 2013 (all qualifying
units), that number should be entered as an estimated number of total seats.
Line #2: This figure has been provided by the Data Center and has been determined by adding the
original number of base seats from the previous contract.
Line #3: This figure has been provided by the Data Center and has been determined as the total
True-up seats since the previous contract.
Line #4: Subtract lines 2 and 3 from line 1 to equal the 2013 - Second Year true-up seats.
2014 IT Project Plan
Agency: Data Center
Project Plan Priority: RFR #1
Project Name: Storage Upgrade
Est. Start Date: Q1 2014
Project Number:
Est. Completion Date: Q3 2014
5
Project Type: New Initiative
Fund: 1000
Program: 10220200
Business Need: Countywide additional storage is needed for increased use of the imaging, web hosting, file
storage, efiling, and various other applications. Currently the available storage on the current Storage Area
Network (SAN) has reached capacity and will not meet the needs of the county in 2014. The Data Center had
an assessment of the current storage environment for both efficiency and security and the consultant
recommended this new technology to replace the current Storage Area Network (SAN). The new technology will
provide a more efficient use of resources, greater security and will better suit the County’s storage needs.
Project Scope of Work: Replace the out of warranty and capacity maxed SAN with a new system that
utilized new system that offers greater efficiency and security.
Project Costs:
Fund
Org
Object
1000
10220200
5432-00
Description
Hardware for SAN replacement
2014
Costs
2015
Costs
2016
Costs
2017
Costs
$75,000
$15,000
$15,000
$15,000
$75,000
$15,000
$15,000
$15,000
TOTAL
General Fund Subtotal
Non-General Fund Subtotal
Project Justification: Countywide agencies need to store documents, images and other items to
complete daily business needs and to comply with public record requests. The current storage
network has reached capacity and replacement is needed. The new system will make better use of
resources and provide greater security.
Project Impact: Without this request storage on the county SAN will not be able to take place.
Project Expected Timelines: The project will begin Q1 2014 and will be complete no later than
Q3 2014
Performance Management/Metrics: The ability for agencies to be able to store and recover
needed documents, images and other essential items.
2014 IT Project Plan
Agency: Data Center
Project Plan Priority: RFR #8
Project Name: iSeries License Activation
Est. Start Date: Q1 2014
Project Number:
Est. Completion Date: Q1 2014
6
Project Type: New Initiative
Fund: 1000
Program: 10220200
Business Need: The iSeries houses vital and expanding applications that county agencies and courts rely
on. Growth of applications like FCJS, Efiling and CIO have made it necessary to expand the iSeries processors.
Project Scope of Work: Activate additional operating system licensing. When purchasing the current
iSeries unit, the Data Center planned for expansion as is now taking place. The unit allows expansion simply by
purchasing additional operating system licensing of which one is now needed.
Project Costs:
Fund
1000
Org
Object
10220200
5221-01
Description
Purchase one additional operating
license for the iSeries production unit
2014
Costs
2015
Costs
2016
Costs
2017
Costs
$44,569
0
0
0
$44,569
0
0
0
TOTAL
General Fund Subtotal
Non-General Fund Subtotal
Project Justification: The Data Center has licensed for use 6 of the 16 processors included in the
IBM server model 750. Considering application growth of Efiling, Case Information Online, and FCJS
usage growth, we experienced performance degradation due to CPU constraints. During 2013, the
Data Center was required to obtain a temporary emergency processor activation to handle workload
on the FCJS partition. During late 2013 or 2014 there will be two additional Efiling application
interfaces for the Franklin County Sheriff and Prosecuting Attorney that will demand further
processing resources to meet demands. Currently, the server has no extra processor resources
licensed in reserve, and we request activation of this additional processor to meet customer demands
in 2014.
Project Impact: Availability of essential applications.
Project Expected Timelines: The project will begin Q1 2014 and will be complete during that
quarter.
Performance Management/Metrics: Successful implementation and response to iSeries
applications such as FCJS, CIO and Efiling.
2014 IT Project Plan
Agency: Data Center
Project Plan Priority: RFR #3
Project Name: Network upgrade
Est. Start Date: Q1 2014
Project Number:
Est. Completion Date: Q4 2014
7
Project Type: New Initiative
Fund: 1000
Program: 10220200
Business Need: The switches and modules will replace outdated, out of warranty and aging switches and
modules that are essential to the countywide network to ensure connection to the county network and servers
which the county relies on for daily business needs.
The Fluke analyzer that was purchased in 2009 and is no longer covered for updates and warranty with a new
unit that supports 10GB/s connections between switches and 10GB/s server and SAN connections.
Project Scope of Work: Replacement and installation of outdated modules and switches beginning in Q1 of
2014 and completed by Q4 2014. The units will be dropped from maintenance this year due to their age, thus
the future cost of maintenance will be offset by the maintenance on the existing units.
Project Costs:
Fund
Org
Object
1000
10220200
5432-00
1000
10220200
5432-00
1000
10220200
1000
1000
Description
5432-00
Two 6748 copper modules to replace
6148 modules
Two Nexus 10GB/s fiber/cooper coax
switches and modules
Ten 48 port switch replacements
10220200
5432-00
10220200
5432-00
2014
Costs
2015
Costs
2016
Costs
2017
Costs
$17,000
0
0
0
$70,000
0
0
0
$83,000
0
0
0
Ten 24 port switch replacements
$50,000
0
0
0
Hardware for new Fluke analyzer
$20,000
$5,040
$5,040
$5,040
TOTAL
General Fund Subtotal
$240,000
$5,040
$5,040
Non-General Fund Subtotal
Project Justification: Two 6748 Copper modules (vital): These modules are to replace/upgrade the
last 2 older 6148 gigabit modules in our core switches, which provide gigabit Ethernet connections to
all of our servers. Without these modules, we cannot provide efficient network connections to county
servers. These also provide expansion for additional servers/SAN units, etc.
Two Nexus switches and modules: This is the equipment that MCPC recommended for support of
10Gb/s connections for high volume ESX servers/SAN units. Currently we have NO available 10Gb/s
connections, and therefore cannot support the equipment the server team would like to purchase.
Increased bandwidth usage has required several gigabit connections for each of the ESX servers and
SAN units. With the shift to virtualization, it is very important that we have the infrastructure in place
to support higher speed server connections.
$5,040
Ten 48 port switches: Ongoing replacement of outdated switches throughout the FCDN network. In
addition, these switches support power over Ethernet, which allow us to power voice over ip phones
for PFM and wireless access points for various agencies. An added bonus is 1Gb/s support for those
users that require it. These replacements are necessary because the older switches being replaced
are no longer covered by maintenance and if a switch fails, will cause an extended outage until a
spare can be configured and installed, or purchased.
Ten 24 port switches: Ongoing replacement of outdated switches throughout the FCDN network. In
addition, these switches support power over Ethernet, which allow us to power voice over ip phones
for PFM and wireless access points for various agencies. An added bonus is 1Gb/s support for those
users that require it. These replacements are necessary because the older switches being replaced
are no longer covered by maintenance and if a switch fails, will cause an extended outage until a
spare can be configured and installed, or purchased.
The current Fluke network analyzer that we use was purchased in 2009, and was not designed to
support 10Gb/s fiber/copper connections. The newest model is a tablet style analyzer which supports
10Gb/s fiber/copper as well as more advanced wireless analysis, and includes some of the Air
Magnet tools that have been requested previously. This tool is needed both to replace the aging
device we have, as well as to support our current and planned 10Gb/s connections between switches
and 10Gb/s server/SAN connections.
Project Impact: Without this request network upgrade performance and availability of the
countywide network and servers would be impacted.
Project Expected Timelines: The project will begin Q1 2014 and will be complete no later than
Q4 2014
Performance Management/Metrics: The ability for agencies to be able to access the county
network and servers with 99% availability.
2014 IT Project Plan
Agency: Data Center
Project Plan Priority: RFR #4
Project Name: Security Assessment
Est. Start Date: Q1 2014
Project Number:
Est. Completion Date: Q4 2014
8
Project Type: New Initiative
Fund: 1000
Program: 10220200
Business Need: In 2013 the Data Center had a security assessment completed. Based on the
recommendations network, server and security support will be needed to complete the recommendations.
Project Scope of Work: Consulting services to assist with changes to the Data Center’s network, servers
and security based on the 2013 security assessment.
Project Costs:
Fund
1000
Org
Object
10220200
5201-00
Description
Consulting services for network, server
and security.
2014
Costs
2015
Costs
2016
Costs
2017
Costs
$100,000
0
0
0
$100,000
0
0
0
TOTAL
General Fund Subtotal
Non-General Fund Subtotal
Project Justification: The Data Center will utilize consulting services to make the recommended
changes to the county’s network, security and servers per the recommendation of the 2013 security
audit. These changes will allow the Data Center to better provide efficient and secure IT services to
meet the business need of county agencies.
Project Impact: Without this requested consulting services the recommendations of the 2013
security and network audit will not be complete.
Project Expected Timelines: The project will begin Q1 2014 and will be complete no later than
Q4 2014
Performance Management/Metrics: Recommendation of the 2013 security audit are complete
as needed.
2014 IT Project Plan
Agency: Data Center
Project Plan Priority: RFR #5
Project Name: Exchange & Domain Upgrade
Est. Start Date: Q1 2014
Project Number:
Est. Completion Date: Q4 2014
9
Project Type: New Initiative
Fund: 1000
Program: 10220200
Business Need: Exchange is the email delivery system to 3,000 Franklin County user while the domain is
used by almost 4,000 users. An upgrade to the domain and Exchange to 2013 will provide greater efficiency and
security and it vital to the county’s ability to utilize the email system securely.
Project Scope of Work: Purchase of required servers and software, install, test and convert both exchange
and domain.
Project Costs:
Fund
Description
2014
Costs
2015
Costs
2016
Costs
2017
Costs
Org
Object
1000
10220200
5432-00
Two Dell servers (Exchange)
$18,000
0
0
0
1000
10220200
5221-01
Exchange 2013 software upgrade
$7,000
0
0
0
1000
10220200
5303-04
Two Dell servers (Domain)
$6,000
0
0
0
$31,000
0
0
0
TOTAL
General Fund Subtotal
Non-General Fund Subtotal
Project Justification: the current domain controller is outdated and must be replaced. Exchange
should also be upgraded to 2013 for increased security and efficiencies. During the Data Center’s
2013 disaster recovery assessment, many agencies responded that access to countywide email was
one of the essential items required to meet the business needs of the county. The upgrade will
provide the upgrade to this vital system and will also provide the ability to deploy security and other
policies to groups.
Project Impact: The upgrade will provide additional efficiency and security to this vital
countywide application.
Project Expected Timelines: The project will begin Q1 2014 and will be complete no later than
Q4 2014
Performance Management/Metrics: Successful implementation of the upgrade.
2014 IT Project Plan
Agency: Data Center
Project Plan Priority: RFR #6
Project Name: Internet Redundancy
Est. Start Date: Q1 2014
Project Number:
Est. Completion Date: Q3 2014
10
Project Type: New Initiative
Fund: 1000
Program: 10220200
Business Need: Based on customer expectations and the number of applications that are dependent on the
internet such as E-Flex and CIO a full back-up system for the internet is necessary.
Project Scope of Work: Purchase and installation of a new iPrism device keeping the older unit to complete
a bridge mode and for Memorial Hall. Research and contract with a second ISP provider to ensure redundancy
and complete the bridge project.
Project Costs:
Fund
Description
2014
Costs
2015
Costs
2016
Costs
2017
Costs
Org
Object
1000
10220200
5432-00
Replacement of iPrism device
$32,692
0
0
0
1000
10220200
5202-00
Duplicate ISP
$41,400
$38,000
$36,000
$34,000
$74,092
$38,000
$36,000
$34,000
TOTAL
General Fund Subtotal
Non-General Fund Subtotal
Project Justification: We have one old iPrism device that requires replacement in 2014. We will
upgrade the primary unit and keep the older unit as a secondary unit to complete the bridge mode and
for Memorial Hall. We will also contract and bring in a second ISP feed from a vendor to be
determined to provide redundancy to the ISP in case there is an issue with the Oarnet line. This is
necessary based on customer expectations and the number of applications that are dependent on the
internet such as E-Flex and CIO.
Project Impact: Will provide redundancy of the ISP thus increasing availability of the internet
for vital applications. Without the project downtime to vital applications would be higher.
Project Expected Timelines: The project will begin Q1 2014 and will be complete no later than
Q3 2014
Performance Management/Metrics: Successful implementation of the upgrade and
redundancy.
2014 IT Project Plan
Agency: Data Center
Project Plan Priority: RFR #7
Project Name: Disaster Recovery
Est. Start Date: Q1 2014
Project Number:
Est. Completion Date: Q2 2014
11
Project Type: New Initiative
Fund: 1000
Program: 10220200
Business Need: The County’s day-to day operations rely heavily on the IT resources provided by the Data
Center. In the case of a disaster these same systems would not only be needed, but might be even more
urgent. Having a disaster recovery plan and availability to all critical applications and information is vital.
Project Scope of Work: Lease facility to house required DR equipment, provide a data line to the Facility
from Franklin County sites, purchase, and install and maintain hardware and software for redundancy of
information.
Project Costs:
Fund
Org
Object
Description
1000
10220200
5202-00
1000
10220200
5220-00
1000
10220200
5221-01
1000
10220200
5432-00
1000
10220200
5221-01
Two data lines to the DR site from two
separate vendors for redundancy
Lease facility to be determined to house
site
iSeries DR Model 720 software and 3
year maintenance
iSeries DR model 720 with 3 years
maintenance
Annual renewal of iSeries software for
the current outdated iSeries unit. If we
do not proceed with the new unit this is
required to operate the existing unit
TOTAL
General Fund Subtotal
2014
Costs
2015
Costs
2016
Costs
2017
Costs
$70,000
$65,000
$60,000
$55,000
$25,000
$25,000
$25,000
$25,000
$30,650
0
0
$10,000
$155,760
0
0
$20,000
$9,100
$9,100
$9,100
$9,100
$250,510
$99,100
$94,100
$119,100
Non-General Fund Subtotal
Project Justification: The High Availability / Disaster Recovery server located at EMA / Strawberry
Farms DR site was purchased in 2005. This model 520 power 5 server offers 25% of the storage and
processing requirements of the production server and therefore unable to meet the DR / HA need of
our customers. The replacement server quoted will provide sufficient processor and storage to meet
production demands. We request purchase or lease of the replacement IBM DR server.
A DR site, data lines to the site, hardware, software and up-keep of the systems is essential to the
county’s ability to conduct business in the event of a disaster.
Project Impact: Availability of essential applications in the case of an emergency.
Project Expected Timelines: The project will begin Q1 2014 and will be complete no later than
Q2 2014
Performance Management/Metrics: Successful implementation.
2014 IT Project Plan
Agency: Data Center
Project Plan Priority: RFR #10
Project Name: Update the Windows Back-up System
Est. Start Date: Q1 2014
Project Number:
Est. Completion Date: Q3 2014
12
Project Type: New Initiative
Fund: 1000
Program: 10220200
Business Need: The Data Center backs-up Windows servers to ensure data availability during a disaster or
when an item is inadvertently deleted. As a result of the amount now being stored due to the expansion of use
by imaging, E-Flex and other applications, the current system is no longer able to keep up with the workload and
is affecting production.
Project Scope of Work: Purchase and deploy a new Windows back-up system
Project Costs:
Fund
1000
Org
Object
10220200
5432-00
2014
Costs
Description
Purchase disk back-up hardware
2015
Costs
2016
Costs
2017
Costs
$50,000
0
0
0
$50,000
0
0
0
TOTAL
General Fund Subtotal
Non-General Fund Subtotal
Project Justification: The current tape back-up system no longer can back-up the high volume of
data and it is affecting production. The new disk back-up system will increase capacity and
efficiencies.
Project Impact: Without it all data may not be able to be backed up and server response
during production will be affected.
Project Expected Timelines: The project will begin Q1 2014 and be complete no later than Q3
2014.
Performance Management/Metrics: Successful implementation of the disk back-up system,
faster back-ups and better response of servers during production.
2014 IT Project Plan
Agency: Data Center
Project Plan Priority: RFR #11
Project Name: CIO, E-Filing & FCJS Enhancements
Est. Start Date: Q1 2014
Project Number:
Est. Completion Date: Q4 2014
13
Project Type: New Initiative
Fund: 1000
Program: 10220100
Business Need: The CIO, E-Filing and FCJS applications are vital and often updates and enhancements are
requested that the Data Center is not staffed to provide in a timely manner.
Project Scope of Work: Personal services as needed for updates and enhancements to the CIO, E-Filing
and FCJS application.
Project Costs:
Fund
Org
Object
1000
10220100
5201-00
1000
10220100
5201-00
1000
10220100
5201-00
Description
Personal services for CIO updates and
enhancements
Personal services for E-Filing updates
and enhancements
Personal services for FCJS updates
and enhancements
2014
Costs
$100,000
2015
Costs
2016
Costs
2017
Costs
0
0
0
0
0
0
$100,000
$100,000
TOTAL
General Fund Subtotal
$300,000
Non-General Fund Subtotal
Project Justification: The CIO, E-Filing and FCJS applications are vital and often requires updates
and enhancements.
Project Impact: To ensure CIO, E-Filing and FCJS are operating as expected and needed
updates and enhancements can be made.
Project Expected Timelines: The project will begin Q1 2014 and will run through Q4 2014 as
needed.
Performance Management/Metrics: Operational per agency and court request.
2014 IT Project Plan
Agency: Data Center
Project Plan Priority: RFR #12
Project Name: Service Ticketing System
Est. Start Date: Q1 2014
Project Number:
Est. Completion Date: Q2 2014
14
Project Type: New Initiative
Fund: 1000
Program: 10220300
Business Need: The Data Center strives to deliver cost efficient business solutions and superior customer
service. As such, it has developed and trained a customer service team to provide one-stop customer service
as a single point of contact. To provide a superior level of customer service an improved ticketing system is
required.
Project Scope of Work: Research, purchase, train staff and implement new ticketing software.
Project Costs:
Fund
Org
Object
Description
1000
10220300
5440-00
Ticketing software
1000
10220300
5221-01
Estimated yearly software maintenance
2014
Costs
$95,000
2015
Costs
2016
Costs
2017
Costs
0
0
0
$15,000
$15,000
$15,000
$15,000
$15,000
$15,000
TOTAL
General Fund Subtotal
$95,000
Non-General Fund Subtotal
Project Justification: The Data Center is finding that providing the level of service it strives to
provide in a one-stop call center cannot be achieved with the outdated and inefficient Heat ticketing
system. An improved ticketing system will provide greater transparency, efficiency and faster
customer service. It will generate improved reporting to enable proper business decisions and
analysis. It will have multiple connecting modules, such as project management, change
management, procurement, among others.
Project Impact: Faster, more efficient customer service. User-friendly environment to keep all
customers better informed of their request for service.
Project Expected Timelines: The project will begin Q1 2014 and will be complete and
operational by Q2, 2014.
Performance Management/Metrics: Improved customer service, reporting, documentation and
notifications.
2014 IT Project Plan
Agency: Data Center
Project Plan Priority: RFR #15
Project Name: Project Delivery Software
Est. Start Date: Q1 2014
Project Number:
Est. Completion Date: Q3 2014
15
Project Type: New Initiative
Fund: 1000
Program: 10220400
Business Need: Project delivery software would be essential in ensuring successful (on time and within
budget) delivery of projects throughout Franklin County agencies. The software would support resource
capacity planning which can be leveraged by Agencies to maximize resource usage and minimize project waste.
Most importantly software would have the functionality to assist in monitoring and controlling risk. Currently
there are no mechanisms to accurately track project delivery, budget, and resource utilization. This system will
provide transparency and the necessary tools required to successfully deliver projects while tracking key
success factors (budget, schedule, scope, etc.). This technology will be utilized to accurately track resources
and project delivery for both Agile and other delivery methodologies. Finally the system will allow for push
communications including alerts to stakeholders, PMs, and providing necessary escalations to manage risk and
success factors earlier in the project lifecycle.
Project Scope of Work: Research, evaluate, purchase, train and implement project delivery software
Project Costs:
Fund
2014
Costs
Description
2015
Costs
2016
Costs
2017
Costs
Org
Object
1000
10220400
5440-00
Project Delivery software
$89,000
0
0
0
1000
10220400
5221-01
Estimated yearly software maintenance
0
$15,000
$15,000
$15,000
$89,000
$15,000
$15,000
$15,000
TOTAL
General Fund Subtotal
Non-General Fund Subtotal
Project Justification: ROI currently is undocumented. However, there are a number of examples where
projects have not produced expected results and have exhausted budgets. A project delivery system is an
organizational process asset that can be leveraged repeatedly to increase the chances of successful project
delivery. If we think of this request in terms of utilization versus the county’s portfolio of projects, the cost of
software comprises a small fraction of the overall budget but it would be leveraged for delivering the majority of
projects. All organizations strive for consistency of delivering projects on time and within budget. A successful
organization ensures project delivery is equipped with the necessary tools and infrastructure to increase the
consistency around delivery. The deployment will be countywide to allow agencies the ability to leverage these
tools as well.
Project Impact: Better project delivery thus increased business value for all associated with projects.
Project Expected Timelines: The project will begin Q1 2014 and be complete Q3 2014.
Performance Management/Metrics: Better able to meet the expectations of the customer and provide
better business value.
2014 IT Project Plan
Agency: Data Center
Project Plan Priority: RFR #13
Project Name: Evaluation of Replacement Technology
Est. Start Date: Q1 2014
Project Number:
Est. Completion Date: Q4 2014
16
Project Type: New Initiative
Fund: 1000
Program: 10220200
Business Need: As new technology comes on the market, agencies utilize new hardware and software or
request new technology, the Data Center must test the items to ensure compatibility and security within the
County’s current network and applications. This project plan will provide the Data Center with funding to
purchase replacement items to ensure compatibility and reduce risk.
Project Scope of Work: Research, test and provide a risk analysis of replacement parts
Project Costs:
Fund
Description
2014
Costs
2015
Costs
2016
Costs
2017
Costs
Org
Object
1000
10220200
5221-01
Software as needed
$10,000
0
0
0
1000
10220200
5303-04
Computer Hardware as needed
$10,000
0
0
0
$20,000
0
0
0
TOTAL
General Fund Subtotal
Non-General Fund Subtotal
Project Justification: For the county to meet the needs of its constituents utilization of new
technology is essential. The new and replacement items must be tested and studied to ensure
compatibility with the current system and security of the county network. This funding will enable
testing to take place and recommendations give to greatly reduce risk.
Project Impact: Reduction of risk
Project Expected Timelines: The project will begin Q1 2014 and will run through the end of
the year.
Performance Management/Metrics: Improved ability to make recommendations.
2014 IT Project Plan
Agency: Data Center
Project Plan Priority: RFR #14
Project Name: SharePoint 2013
Est. Start Date: Q1 2014
Project Number:
Est. Completion Date: Q4 2014
17
Project Type: New Initiative
Fund: 1000
Program: 10220200
Business Need: SharePoint is currently used by the Prosecuting Attorney, Court of Common Pleas, Clerk of
Court, Sheriff, Treasurer, Auditor and Commissioners. Several of these agencies have requested the
countywide application be upgraded to SharePoint 2013 for increased functionality and security. By upgrading
the countywide application that all agencies can access agencies will not leave the countywide application to set
up their own 2013 sites.
Project Scope of Work: Purchase necessary hardware, and licenses, install, test, convert and implement
SharePoint 2013.
Project Costs:
Fund
Org
Object
1000
10220200
5221-01
1000
10220200
1000
1000
Description
2014
Costs
2015
Costs
2016
Costs
2017
Costs
$21,000
0
0
0
5221-01
Software tool to upgrade/convert to
SharePoint 2013
SharePoint 2013 software licensure
$22,000
$6,000
$6,000
$6,000
10220200
5432-00
Two high-end Dell Servers
$12,000
0
0
0
10220200
5201-00
Consulting to assist with the conversion
$10,000
0
0
0
$65,000
$6,000
$6,000
$6,000
TOTAL
General Fund Subtotal
Non-General Fund Subtotal
Project Justification: Centralization of services. Several agencies utilizing the current countywide
SharePoint site have requested an upgrade to SharePoint 2013 or they will purchase the necessary
hardware, licensing and more consulting than would require the Data Center to achieve the same
thing. For each agency that develops their own site the total cost to the county would increase.
Project Impact: Consolidation
Project Expected Timelines: The project will begin Q1 2014 and be complete Q4 2014.
Performance Management/Metrics: Improved function and security.
2014 IT Project Plan
Agency: Data Center
Project Plan Priority: RFR #18
Project Name: Wireless Access Point Controller
Est. Start Date: Q1 2014
Project Number:
Est. Completion Date: Q2 2014
18
Project Type: New Initiative
Fund: 1000
Program: 10220200
Business Need: With the growing number of wireless access points that the Data Center supports and
manages, an access point controller has become necessary and will provide much more flexibility in configuring
the access points that we have. It also allows the purchase of cheaper, non-standalone access points and the
ability to configure them faster.
Project Scope of Work: Purchase 100 count license wireless access point controller and configure
Project Costs:
Fund
1000
Org
Object
10220200
5221-01
Description
100 License wireless access point
controller
2014
Costs
2015
Costs
2016
Costs
2017
Costs
$24,914
0
0
0
$24,914
0
0
0
TOTAL
General Fund Subtotal
Non-General Fund Subtotal
Allows the county to purchase cheaper non-standalone access points
and have them configured faster.
Project Justification:
Project Impact: Better management
Project Expected Timelines: The project will begin Q1 2014 and be complete Q2 2014.
Performance Management/Metrics: Improved function and security.
2014 IT Project Plan
Agency: Data Center
Project Plan Priority: RFR #19
Project Name: OnBase Consulting
Est. Start Date: Q1 2014
Project Number:
Est. Completion Date: Q4 2014
19
Project Type: New Initiative
Fund: 1000
Program: 10220100
Business Need: With OnBase being a significant system in the county in 2013, more and more demand is
being put on the newly developed support team. With complex requirements in upcoming projects, it is known
that professional services will be needed for best practices and to assist with areas outside of the current
knowledge level. By 2015 the team should be able to fully support the system without additional consulting
services.
Project Scope of Work: Utilize consulting services as needed. STS contract
Project Costs:
Fund
1000
Org
Object
10220100
5201-00
Description
Consulting services as needed
2014
Costs
2015
Costs
2016
Costs
2017
Costs
$30,000
0
0
0
$30,000
0
0
0
TOTAL
General Fund Subtotal
Non-General Fund Subtotal
Project Justification:
Allow more complex requirements to be developed to better meet business needs
Project Impact: Meet Agency business needs
Project Expected Timelines: The project will begin Q1 2014 and be complete Q4 2014.
Performance Management/Metrics: Improved work flow and complex requirements
2014 IT Project Plan
Agency: Data Center
Project Plan Priority: RFR #18
Project Name: Java Consulting
Est. Start Date: Q1 2014
Project Number:
Est. Completion Date: Q4 2014
20
Project Type: New Initiative
Fund: 1000
Program: 10220100
Business Need: Current applications written in Java are in need of upgrading to a newer version. Both the
Java version and the framework need to be upgraded since the Struts 1.x framework has reached End-OfLife. With limited staff knowledge, personal services will be needed to assist with upgrading these applications
in a timely fashion. Also, assistance will be needed for maintenance or emergency fixes of the Probate eFiling
API, FCJS eFiling interface, FCJS, and other iSeries developed applications until staff becomes more familiar
with them.
Project Scope of Work: Utilize consulting services as needed. STS contract
Project Costs:
Fund
1000
Org
Object
10220100
5201-00
Description
Consulting services as needed
2014
Costs
2015
Costs
2016
Costs
2017
Costs
$70,000
0
0
0
$70,000
0
0
0
TOTAL
General Fund Subtotal
Non-General Fund Subtotal
Project Justification: Supplement Data Center staff to upgrade vital applications to new versions
for increased security and functionality
Project Impact: Security concerns.
Project Expected Timelines: The project will begin Q1 2014 and be complete Q4 2014.
Performance Management/Metrics: Improved security and functionality. Complete upgrade by
12/31/2014.
2014 IT Project Plan
Agency: Data Center
Project Plan Priority: RFR #21
Project Name: Railo Consulting
Est. Start Date: Q1 2014
Project Number:
Est. Completion Date: Q4 2014
21
Project Type: New Initiative
Fund: 1000
Program: 10220100
Business Need: The Web Team is investigating moving to the Railo platform in 2014 from Adobe’s Cold
Fusion. This move will involve a development, stage, and production environment with a migration with best
practices. Professional Services will be needed as the team will be trained on the job. Security best practices
will need to be adhered to and implemented.
Project Scope of Work: Utilize consulting services as needed.
Project Costs:
Fund
1000
Org
Object
10220100
5201-00
Description
Consulting services as needed
2014
Costs
2015
Costs
2016
Costs
2017
Costs
$50,000
0
0
0
$50,000
0
0
0
TOTAL
General Fund Subtotal
Non-General Fund Subtotal
Project Justification: Ensure compatibility and most importantly network and application security
with this new platform.
Project Impact: Security concerns.
Project Expected Timelines: The project will begin Q1 2014 and be complete Q4 2014.
Performance Management/Metrics: Improved security and functionality. Complete upgrade by
12/31/2014.
2014 IT Project Plan
Agency: Data Center
Project Plan Priority: RFR #20
Project Name: Intellivue Upgrade
Est. Start Date: Q1 2014
Project Number:
Est. Completion Date: Q3 2014
22
Project Type: New Initiative
Fund: 1000
Program: 10220200
Business Need: Franklin County agencies, particularly Child Support Enforcement utilize and greatly depend
on the countywide imaging application for business processes. Upgrading to the latest GX version would
increase efficiency and production.
Project Scope of Work: This is a high level estimate provided by Intellinetics and will include licensing and
professional services.
Project Costs:
Fund
Org
Object
Description
1000
10220200
5221-01
Intellivue latest GX version
1000
10220200
5201-00
Intellivue personal services
2014
Costs
2015
Costs
2016
Costs
2017
Costs
$150,000
$30,000
$30,000
$30,000
$50,000
0
0
0
$200,000
$30,000
$30,000
$30,000
TOTAL
General Fund Subtotal
Non-General Fund Subtotal
Project Justification: The latest GX version of Intellivue would increase efficiency and production of
this highly utilized imaging application.
Project Impact: increased efficiency and production.
Project Expected Timelines: The project will begin Q1 2014 and be complete Q3 2014.
Performance Management/Metrics: Customer satisfaction
2014 IT Project Plan
Agency: Data Center
Project Plan Priority: RFR #21
Project Name: Management Consulting
Project Number:
Est. Start Date: Q1 2014
23
Est. Completion Date: Q4 2014
Project Type: New Initiative
Fund: 1000
Program: Allocated
Business Need: The Franklin County Data Center strives to achieve the vision, mission and goals set out in
the 2014 Strategic Business Plan. To succeed we must overcome our weaknesses and the threats to our
success while leveraging our strengths. One weakness that has been identified is the Data Center’s culture.
During 2013 we worked very hard with a management consultant to define our preferred culture and begin steps
to improve the culture within the Data Center so better service can be provided. This IT plan would provide
management consulting services to complete this very important task.
Project Scope of Work: Continue work with management consultant and the Data Center team to achieve
set goals to improve the culture of the Data Center.
Project Costs:
Fund
1000
Org
Object
Allocated
5201-00
Description
Consulting services
2014
Costs
2015
Costs
2016
Costs
2017
Costs
$49,000
0
0
0
$49,000
0
0
0
TOTAL
General Fund Subtotal
Non-General Fund Subtotal
Project Justification: The Data Center cannot expect new and better results while doing the same
old thing
Project Impact: Better culture and services.
Project Expected Timelines: The project will begin Q1 2014 and be complete Q4 2014.
Performance Management/Metrics: Customer satisfaction, service results
2014 IT Project Plan
Agency: Data Center
Project Plan Priority: RFR #2
Project Name: Training and Certification
Est. Start Date: Q1 2014
Project Number:
Est. Completion Date: Q4 2014
20
Project Type: New Initiative
Fund: 1000
Program: All
Business Need: Training for the Data Center is vital to ensure best practices, security and availability.
Training and certifications have been a focus in 2013 and will continue into 2014 so that an investment is made
in Data Center staff instead of hiring outside consultants for services we are not able to provide.
Project Scope of Work: Following is a list of training being requested in 2014 in addition to the normal
training schedule. Please see request below.
Project Costs:
Fund
Description
2014
Costs
2015
Costs
2016
Costs
2017
Costs
Org
Object
1000
10220100
520408
Training for programming
37,484
0
0
0
1000
10220200
520408
Training for Computer Administration
35,129
0
0
0
1000
10220300
520408
Training for Customer Service
14,367
0
0
0
1000
10220400
520408
Training for Project Service
10,233
0
0
0
$97,2013
0
0
0
TOTAL
General Fund Subtotal
Non-General Fund Subtotal
Project Justification: IT technology does not stand still. Security threats do not remain the same.
Versions of programming languages are always being updated. It is vital that the Franklin County
Data Center remain current on technology and increase knowledge and become certified in certain
key areas. The below list of training is needed in addition to the normal yearly training to ensure the
needed knowledge is available in-house and that continued funding is not needed each time a new
threat, outage or application is present.
Project Impact: No doing so will impact the Data Center’s ability to service the county
network, servers, programs and new initiatives.
Project Expected Timelines: The project will begin Q1 2014 and will be complete Q4 2013.
Performance Management/Metrics: Successful ability to service existing and implementation
of new processes, software/applications, and hardware.
Budget Amount
Vendor
3,500.00
Multi‐Vendor
2,500.00
Multi‐Vendor
3,500.00
Multi‐Vendor
6,000.00
Multi‐Vendor
2,000.00
Multi‐Vendor
2,500.00
Multi‐Vendor
3,500.00
Multi‐Vendor
6,000.00
Multi‐Vendor
2,200.00
Multi‐Vendor
1,700.00
Multi‐Vendor
1,000.00
Multi‐Vendor
4,763.00
Gov Port
Short Description
Business Need
Travel for IBM training
Training not held locally
Justification
To remain effective and support the needs of countywide IT
To remain effective and support Travel cost for Common fall Expo
Not offered locally, IBM iSeries training
the needs of countywide IT
To remain effective and support Travel for VM World
Not offered locally, Virtual server training
the needs of countywide IT
two ‐ Travel for Consumer Electronic Show in Las Not offered locally, obtain knowledge of To remain effective and support Vegas
new technology
the needs of countywide IT
Not offered locally, Information regarding To remain effective and support Travel for the Storage Network World
the needs of countywide IT
SAN solutions
To remain effective and support Travel for cf. objective
Not offered locally, Web program language
the needs of countywide IT
To remain effective and support Travel for SharePoint 2013
Not offered locally
the needs of countywide IT
Not offered locally, a portion of which will be To remain effective and support Travel for OnBase TechQuest. 5 days / 4 staff
recovered by JFS anf FCCS billing
the needs of countywide IT
To remain effective and support Travel for SHRM
Not offered locally, Human resources
the needs of countywide IT
The IT roundtable of experts is at no cost to To remain effective and support Travel to the Norex international Roundtable. members, however it is not offered locally Location unknonw, attendee Ludwig
the needs of countywide IT
and requires travel
Not offered locally, Project Management and To remain effective and support Travel for PMO Symposium
delivery information
the needs of countywide IT
SkillPort provides online learning currently To remain effective and support SkillPort E‐Learning enterprise
being utilized by 17 FCDC staff members ‐ the needs of countywide IT
expanded use in late 2013 and 2014
CFGM testing fees
CFGM certification testing fees for j Lust
to obtain financial certification
Additional training on Windows storage and Vital for bringing knowledge in‐
SAN and security training
network security is vitial
house
OnBase is a countwide storage and workflow To remain effective and support OnBase API training for two one staff members: application. Training comes with a Online
the needs of countywide IT
certification
OnBase is a countwide storage and workflow OnBase Workflow training for two one staff To remain effective and support application. Training comes with a members: Online
the needs of countywide IT
certification
OnBase is a countwide storage and workflow To remain effective and support OnBase Workflow Design training for two one application. Training comes with a staff members: Online
the needs of countywide IT
certification
In Support of management of the desktop To remain effective and support Effective management training for Greg Thrush
team
the needs of countywide IT
Testing and certification is an important part To remain effective and support Testing fees for certifications for Computer Services team
of training
the needs of countywide IT
Testing and certification is an important part To remain effective and support Testing fees for certifications for desktop team
of training
the needs of countywide IT
Agile training in support of project To remain effective and support Agile training
management and delivery countywide. the needs of countywide IT
Unknown location or attendee
Agile certification in support of countywide To remain effective and support PMI Agile Certified
project management and delivery. Unknown the needs of countywide IT
staff
iSeries training in support of applications for To remain effective and support CLCT, AUDR, SHRF & TREA / FCJS eFiling, CIO the needs of countywide IT
500.00
Unknown
10,000.00
Unknown
2,800.00
Hyland Software
2,800.00
Hyland Software
2,800.00
Hyland Software
1,000.00
Unknown
500.00
Multi‐Vendor
500.00
Multi‐Vendor
4,000.00
ASPE
1,800.00
ASPE
2,000.00
IBM
iSeries training
2,600.00
Common A User Group
Common Fall Conference & Expo for Knaul & Huncherick
2,500.00
Vmware
WM World training in support of the virtual environment
2,000.00
SNW
Storage Network World in support of storage projects. Location and attendee unknown
4,000.00
CES
Two people ‐Consumer Electronic show in Las Vegas to be attended by Desktop/Mobile
1,500.00
Unknown
cf. Objective: Cold Fusion training
2,000.00
Microsoft
SharePoint 2013 training
10,000.00
Hyland Software
OnBase TechQuest (5 days) for 4 staff members
2,750.00
SHRM
SHRM Annual Confernece & Expo. Location unknown, Attendee Barrett & Wilkins‐Bibbs
2,000.00
PMI
PMO Symposium in support of project services countywide. Unknown location or attendee
Fall expo in support of iSeries applications To remain effective and support the needs of countywide IT
FCJS, eFiling & CIO
the virtual environment supports agencies To remain effective and support countywide. Server team/unknown specific the needs of countywide IT
attendee
Storage Network World to be utilized in To remain effective and support storage projects needed as county storage the needs of countywide IT
continues to grow
In support of countywide desktop services / To remain effective and support Mobile
the needs of countywide IT
Cold Fusion is used in many countywide To remain effective and support websites and applications. Training two staff the needs of countywide IT
members to update their skills
SharePoint is used countywide and training To remain effective and support in the latest version is essential. Unknown the needs of countywide IT
location or attendee
OnBase is a storage and workflow application that is used by multiple agencies To remain effective and support countywide. To be attended by four the needs of countywide IT
members of the development staff
SHRM is an annual confernece for Human To remain effective and support Resources that will benefit the FCDC and the needs of countywide IT
their goals
To remain effective and support In support of project management countywide
the needs of countywide IT
2014 IT Project Plan
Agency: Data Center
Project Plan Priority: RFR #9
Project Name Servers and printers <$5,000
Est. Start Date: Q1 2014
Project Number:
Est. Completion Date: Q4 2014
21
Project Type: New Initiative
Fund: 1000
Program: 10220200
10220100
Business Need: An upgrade of four network printers will allow demanded use of network printers instead of
the large number of personal computers used which increases ink cost. There is also a need for two new
firewall servers that are less than $5,000 each and a new server purchase for SQL reporting testing and
development with the goal of eliminating WebFocus at a cost of almost $50,000 per year by 2015.
Project Scope of Work: Purchase and install the above
Project Costs:
Fund
Description
2014
Costs
2015
Costs
2016
Costs
2017
Costs
Org
Object
1000
10220200
530304
Two new servers for Firewall
8,000
0
0
0
1000
10220200
530304
Four high-speed network printers
16,000
0
0
0
1000
10220100
530304
Server for SQL reporting
4,000
0
0
0
TOTAL
General Fund Subtotal
$28,000
Non-General Fund Subtotal
Project Justification: the two new servers for the firewall are needed for network security and
speed, the four printers and the SQL reporter server should save the resources in the future.
Project Impact: security and cost savings
Project Expected Timelines: The project will begin Q1 2014 and will be complete Q4 2013.
Performance Management/Metrics: to follow.