HomeMy WebLinkAbout04. (Handout) Information Technology Master Plan Presentationbad
l�
Y.
maawf)
w
Central Contra Costa
Sanitary District
Information Technology
Master Plan
Prepared by
Revised November 25, 2014
CLIENT WORKING DRAFT
Agenda
• Objectives and Methodology
• Progress Status
• Assessment Findings Summary
• Assessment Recommendations
• Actions to Date
• IT Staffing Recommendations
• IT Projects Roadmap
IT Master Plan (ITMP) Objectives
The ITMP provides the bridge to close the gap between the
capabilities of the District's present technology environment and
business requirements.
IT Mgmt &
Staff
Interviews Departmental
Tasks / Activities
User Planning & Strategic
Stakeholder Best Practices Enterprise Tasks /
Prioritization Plan Govern
Interviews Assessment Activities Workshop Development
IT Organization
Voice of the Tasks / Activities
User Survey
Survey IT Assessment IT Strategic Governance
Report Report Plan M Tools
ITMP Development Progress
• Voice of User Survey ....... ...........................Done
• IT Services Assessment ............................ Done
• Business Technology Assessment ..........Done
• Task and Initiative Identification .............Done
• Strategic Plan Development ...................Done — Final Draft Pending
ITMP Timeline — On Schedule
December -May
'e
Best Practices Assessment
c
U
X
N
G
0
v
M
v
N
C
0
CL
C� h
A
ayy \`tea
Q
m
n`
1
C)
k--- -, -
0 Original Assessment
Service Delivery
o
00
O
' o
�o
I
tic
Infrastructure
Best Practices Compliance
Current State no
Pct. Best Practice
Compliance
Maturity level
100
Valu 7771�1 e
Proactive
90
80
70
60
SO
Reactive
40
30
20
10
30
Return on
Investment
(ROI)
Maturity level
% of Best Practices
Conformance:
(B)
Target
Maturity
State
I
IT
Proactive
40 50 60 70
Gap Between Current and Target States: -0 Illp
�' � M--- I --- � -- - =-�' - -, - --
80 90 100
(A)
Best
Practices
Assessment
If
0 10 20
30
(B)
Target
Maturity
State
I
IT
Proactive
40 50 60 70
Gap Between Current and Target States: -0 Illp
�' � M--- I --- � -- - =-�' - -, - --
80 90 100
SWOT Analysis
F Enablers 11 Inhibitors
Senior management is committed to
the use of technology as an enabler in
the attainment of strategic business
objectives
The District has the financial resources
to support expanded use of IT
Staff members are not fully trained to
handle current responsibilities
Functional responsibilities within ITD
are not well defined
IT Infrastructure is not reliable and
must be renovated
Organization structure inhibits focus
on customer support
Inconsistent application of best
practices
r Ad -hoc approach to IT governance
r Incomplete strategic vision regarding
the use of IT
Dated application portfolio (esp. HTE)
Inconsistent adoption of enterprise
applications
Components of IT infrastructure under
the control of user departments
Cybersecurity
Application Effectiveness
M
x
A
C
0
7
u.
W
7
le
e!
ai
c
eM
U
O
T
People / Process Constrained ; Effective Application
Ineffective Application ; Application Constrained
User Effectiveness (i.e., People / Process / Training) High
l.0
I
I
GIS Recruiting SCADA
(ESRI) (NeoG01n (Transdyn)
I
- - -�
I
I SCADA
OTIS
(Wonder
(Common
Were)
Spot)
_
I
_— Document I
Mgmt
(taserFiche) 1
1
CMMS 1
(MalnSaver)
------------ - - -- -^
J� CMMS Public
(AcceIa) WebPage J
I
_
GIs • RepoDI Ad-Nx
(GDI / (CognDatabases
Geornecis) InfoM(MS Access)
Flnance/
I
I
I I
ERP
I I ESRI GK sohw"
1 I Okasesee
(HTE)
1 i abowl i
Ineffective Application ; Application Constrained
User Effectiveness (i.e., People / Process / Training) High
l.0
Assessment Recommendations
1. IT Organizational Structure and Process Realignment
2. Implement Technology Planning and Governance
3. Implement Business Application Improvements
4. Adopt IT Service Delivery Best Practices
5. Adopt IT Vendor Management and Project Management Best Practices
6. Address Business Continuity and Disaster Recovery
District Project Intersections
• Asset Management
• Recommendations will inform requirements for CMMS and ERP
• Cost of Service Study
• IT Organizational and Staffing recommendations aligned
• Records Management
• Recommendations will inform requirements for ECM and ERP
Actions and Progress to Date
• Security Assessment and Remediation
• Network vulnerability assessment completed
• Findings remediation project underway with solid progress
• Backup technology and process assessment and remediation underway
• IT Operations Governance, Leadership and Process Improvement
• IT Steering Committee Established
• Interim IT Operations Manager in place
• Staff assessments completed and operational realignment in progress
• Process and cultural improvements underway
• Targeted critical application and infrastructure updates underway
• CMMS updates
• Backup appliance stabilization
• Network redundancy
IT Staffing — Existing Structure
CCCSD
Current IT Organization Chart
DYKt01 d AdrriNmatbn' t
Daid HNth
ITAdm (Vt Wf
Roy U
IF
Proyrmnu Mahm
Tad Bvry
-
Sy3um adnY1 "rbabf
lnfa Vqa
♦
SYRem ANnl+dbaWr� -� -�
vxm
♦
SYAam atmtinn,W r
VK art
Inafp
IT Malpt
Imtan tn.,dnary
TKhrvol Supprrt
Ma/yA
Sp -Chun
♦
TKhniol $upppt
nnahA
Gao�a Sol'vsr
Ida mxbn 5ymmfSgfiNu
VKar<
IT Staffing Recommended Approach
• Phase 1— Remediation
• Realignment of existing staff with net increase of 2 FTE
• Underway now under guidance of Interim IT Operations Manager
• Phase 2 - Restructuring
• Add IT Staff
• Transition to 7x24 IT Operations Model to meet District needs
• Properly align staff skills and bandwidth
• Prepare to address significant IT project roadmap requirements
IT Staffing— Phase 1 Recommended Structure
1111.0ftw SON.Ce
yrt
Htlp D&*
Twhww Support
Mgnt
�Sef
Menapmeat,
Doc —w wcn,
Trehh�
tT Manger iAraurucare '.
Savkes
Stgervaor
&ands MNy Ttlecom 8
$N[ V Ry
TBD
Enterprise
Appikaaons
SY3Ymt
AQrI'%rtiWKa
DBk
16
IT Roadmap —
• Technology Trends
Informing the Plan
• Organizational Needs
• Organizational Constraints
• The Plan Belongs to the District— Collaboratively Developed
IT Roadmap — Summary
Y��tu LabNNY lwwap SetwMy MoErYry SoutMj SotW Mega
Legend: Eneerpr;sr !L -_ E+'6N+8 OvKaNm��
ilnYnte /NR
F1KIr0Yk
Conh��ptM
E Mal, ONw
09t.
Attest 08
ManKt+nent
Roadmp
Trat �iCM„
i '�
iNrfrNi
R�
f- SlfnaNin/
Wa111ow
Wmediatbn
U�KIfL��
❑
Y��tu LabNNY lwwap SetwMy MoErYry SoutMj SotW Mega
Legend: Eneerpr;sr !L -_ E+'6N+8 OvKaNm��
ilnYnte /NR
F1KIr0Yk
Conh��ptM
i�pW
Attest 08
Trat �iCM„
SyYSm
iNrfrNi
❑
�
Wmediatbn
U�KIfL��
❑
irYdL�
Y��tu LabNNY lwwap SetwMy MoErYry SoutMj SotW Mega
Legend: Eneerpr;sr !L -_ E+'6N+8 OvKaNm��
IT Roadmap —User Project Detail
"t of Cosl
EY 7014/15
1 FY 7015/16
IF 2116/17
FY 2017/13
402014
102015
2011115
30!015
402015
102016
Ilan
202016
302016
401016
102017
202017
302017
$000's
Resource
Business
Fumy
Project Groups / Projer is
Status
low Nigh
Use
Value
IhiaiN
Ott Noy Dec
loco {eD Mar
Apr May tun
WI Aug Sep
Ott NW Oa
FeD Mar
AIM May tun
lul Aug Sep
Olt Noy Dec
tin fe0 Mar
API May tun
luty Artg Sep
Nolen
Um Project
GIS lmplemenlatlon
In Process
25
50 High
High
High
■ ■ ■
■ ■ ■
IT Governance(Recurfingl
In Process
0
5Low
Hyh
High
■
■
■
■ ■ ■ ■
■ ■ ■
■
■
■
Enterprise Technology Policies
DenOino
10
25 1.4 d.
High
Hith
■ ■
NISI ihreal Protection
Pending
50
75 Medium
High
High
■ ■
■ ■ ■
■
Business Continuity Plan
Pending
10
2S High
High
Hlgh
■ ■
Desktop Technology Refreshen !.(Retuning!
Pending
50
100 Low
High
Medium
■
■
■
■
Plem mformeuon integration Roadmap
Pending
30
50 wen
sign
tow
■ ■ ■ ■
Field Mob, litv
Pending
10
25 Filed um
High
High
■ ■
Enterprise Document /Content Management
Document Management Roadmap
Pending
100
150 High
High
High
■ ■
,
Agenda Management
Pending
50
75 Medium
Metlium
Medwm
■ ■ ■
■ ■ ■
E•Mail, Online Document Retention DOhN
Pending
0
Slow
Medium
Medium
■
E- Signatures /Workflow
Pending
S
101ow
low
low,
■
Web Re •design /Enhanced Public Access
PeMin2
100
125 Medium
Medium
Medium
■ ■ ■ ■ ■ ■
ERP- Related Protects
CMMS Replacement
In Process
574
776 High
High
High
■ ■ ■
■ ■ ■
■ ■
,
Permit System Replacement
Pending
150
110 "" "'
High
Hyh
■ ■ ■ ■ ■ ■ ■
fleet Management
Pending
SO
75 Metlium
Medium
Medium
■ ■ ■ ■
■ ■
Warehouse Inventory
Pending
15
50 Medium
Medium
Medwm
■ ■ ■ ■
ERP
finance / HR Alternatives Analyses
In Process
0
Olow
High
High
■ ■
,
finable / HR Acquisition Roadmap
Pending
IS
30 High
High
Hlgh
■ ■
■
Access Database inventory
Pending
0
0 High
High
High
■
Interim Time Entry System
Pending
25
50 Medium
Hlth
High
■
■ ■ ■
Finance /HR System
Denoing
400
700 High
High
High
■ ■ ■ ■ ■ ■
■ ■ ■
■ ■ ■
Electronic Time Entry
Penoing
75
100 Medwm
High
High
■ ■ ■
■ ■
Contract / Risk Management
Pending
25
50 N: etlium
Medium
Medium
■
Financial System Reporting
Pending
25
50 Medium
High
High
■
■ ■ ■
Utllilyeil ling
Pending
2S
50 to
Metlium
Medium
■
Trainin[. Cetti /lcatlon 35afety Tracking
Denomg
15
SO low
hfeoium
Low
■
Access Database Remediation
Pend mg
5
10 Medium
High
High
■
■
■
■
ERP'SORcost*
Pending
425
S75 Medium
High
Hyh
5
Capital Protect Management system
Pending
15
SO low
Medium
Medium
■
Perfofmance Evaluation Mgm15ystem
Penom`
S
25 low
hledmm
Low
■
Application Training (Recurring)
Pending
50
75 Medwm
High
low
I
NJ
NJ
■
IT Roadmap — IT Division Project Detail
ReneeM Cost
{Y 2011/15
{Y 1015116
{Y 2016/17
FY2017 /IB
SM,
a
Buslfsett
I
I
aQ201a
IQi015
ig20t5
SQi015
4Q2014
102016
202016
3Q2016
a01016
Ig1017
2Q1017
3Qi01)
{uture
_ P10(e[I Groups / ProiNts
Status
Low I High
Ute
Us,
Value
Pf(phy
/kl Nov Ot[
IM itD Mar
Apr May laic
lYl Aut Se0
Ott Nov Get
IM {eD M
11Or M 1
All 6i.e See
Notes
ITO Prcocts
ITp office Space lmprowment
In Process
0 SMedium
LOw
High
■ ■ ■
ImplementcIlec, Precdces
Pending
1S 20
Medium
Hleh
Hleh
■ ■ ■
■ ■ ■ ■
ITO Staff Analysis
Pend
15 20
High
Htgh
Hlgh
■ ■ ■
ITO Succession Plan
Pending
0 Slow
Hlgh
High
■
Customer Support Organization
In Process
0 SMedium
HieD
Hiyh
■ ■ ■
Technical Oo[umentation
Pending
0 S
High
Hlgh
Hieh
■ ■
■ ■ IN ■
Vendor / Product Management
Pentling
0 5
Medium
Medium
Medium
■
Technical O/R Iniphl"merrta
In Places S
25 50
High
Hleh
Mieh
■ ■ ■ ■
Network VNMrabllityJF en'n lest (Recurring)
Plntling
10 1S
LOW
Hlgh
Hlgh
■
■
Misc. Technical Improvements
Pending
1S 20
Medium
Medium
Medium
■ 111
■
■
Infrastructure Refreshment Plan (Recurring)
Pend..$
100 1501"
High
High
■
■
■
■
IT Roadmap — CCCSD Requested Project Detail
Range of Cost
Rtsourw I Business
FY 2014/15 1 FY 2015/16 I FY 2016/17 1 FY 2017/16
60201 102015 242015 3Q20 1S 4Q2015 1(120 36 242016 342016 aQ2016 IQZ017 2(12011 3(12017 Future
Mar, rlec It Feb Mar Aor Mav lun lul Am Sey Ott Nor Dec Ian Feb Mar An Mav Jon lul puff Sea Ocl Nav DH Nn Feb Mar Ayr May )on )uN Au! 5ey Notes
CCCSD hopoW Pro(ects, Timeline Not Yet Defined 6
Ada I IT Infrastructure Up grades /Replacements Pending 550 600 Medwm low High
Asset Management SYStem Pending 510 690 Medium High Hlgh
Long-Term ELM SOIUhon Pendlnff 60 510 H,th Hlgh Hleh
2 ';
IT Roadmap — Project Cost summary
Total Costs
Low
$000's
High
$000's
a) User Projects:
b) ITD Projects:
$2,364
$180
$3,686
$300
* ** Subtotal:
c) CCCSD- Requested Projects:
$2,544
$1,140
$3,986
$1,800
Total Project Cost:
$3,684
$5,786
Budgeted IT Funds:
($1,000)
($1,000)
Net Unfunded Balance:
$2,684
$4,786