team lead item # description update as of march 8, 2018 ......attachment b - county it progress...

12
Attachment B - County IT Progress Forward Report - 20180313 - ver002 Page 1 Team Lead Item # Description Projected Completion Date Update as of March 8, 2018 3-PMO Craig 1-Project-B TechShare.LEA Portal 2018-04 Evidence.Com Garland PD continues to use the newly developed API in production. To date, 157 cases processed with a 95% success rate. Working with Garland PD to identify root cause of the 5% issue rate. Grand Prairie PD was taken live with the Evidence.com solution on Monday, 3/5/18 and is currently using the system with considerable success. Both agencies are reporting that the new interface has tremendously reduced the impact on the Staff who are now able to focus their attention on case filing as opposed to DME uploads. Deployed several integration patches to the production environment for TechShare.Prosecutor and FORVUS. Patches are working as expected with no issues being reported. Discussions continue with the IT Applications Team on transitioning the TechShare.Prosecutor & Portals applications over to IT production support with a goal to do so by 3/31/18. The CUC has “closed” the LEA Portal project and is no longer permitting invoice activity against this project. TPMG is in the process of requesting a formal “project closeout” to review CUC funding balances and to validate that all deliverables have been completed. (Pending) 3-PMO Peju 1-Project-C TechShare.Courts 2018-07 Development: Two (2) new TechShare releases were delivered to Dallas County on 3/1/18 and 3/2/18. The two (2) releases were deployed to the Dallas County environment on 3/1/18 and 3/2/18 respectively. (Release 2.0.4179.1, Release 2.0.4177.1) The Project Team experienced a few issues with the TechShare Courts Application on 2/28/18 with those issues being addressed and resolved by the Dallas County Technical Team (Server/DBA/Network) as of 3/1/18. Other Items: Per Dallas County executive direction and guidance, the Microsoft Code Review report will be presented to the Commissioners Court along with the performance test review in April 2018, pending the delivery of the Performance Test report. Per the ongoing Microsoft performance assessment, below are some performance improvements noted and how the System Under Testresponded thus far: o Custody Status message, Grand Jury Decision message, Save and Finalize Documents call and the Mass Docketing flow: Custody Status Transaction went from 13.7 seconds to 7.47 seconds; Grand Jury Decision Transaction went from 1.26 seconds to 1.04 seconds; Save and Finalize Doc Transaction went from 95.1 seconds to 32.1 seconds; & Mass Docketing Test went from 508 seconds to 20.4 seconds. o Performance improvements for the “System Under Test”: D16SC2TSCINT03 CPU% went from 59% to 16%;

Upload: others

Post on 12-Mar-2020

2 views

Category:

Documents


0 download

TRANSCRIPT

Attachment B - County IT Progress Forward Report - 20180313 - ver002 Page 1

Team Lead Item # Description Projected

Completion Date Update as of March 8, 2018

3-PMO Craig 1-Project-B TechShare.LEA

Portal

2018-04 Evidence.Com – Garland PD continues to use the newly developed API in production. To date, 157 cases

processed with a 95% success rate. Working with Garland PD to identify root cause of the 5% issue rate.

Grand Prairie PD was taken live with the Evidence.com solution on Monday, 3/5/18 and is currently using

the system with considerable success. Both agencies are reporting that the new interface has

tremendously reduced the impact on the Staff who are now able to focus their attention on case filing as

opposed to DME uploads.

Deployed several integration patches to the production environment for TechShare.Prosecutor and

FORVUS. Patches are working as expected with no issues being reported.

Discussions continue with the IT Applications Team on transitioning the TechShare.Prosecutor & Portals

applications over to IT production support with a goal to do so by 3/31/18.

The CUC has “closed” the LEA Portal project and is no longer permitting invoice activity against this

project. TPMG is in the process of requesting a formal “project closeout” to review CUC funding

balances and to validate that all deliverables have been completed. (Pending)

3-PMO Peju 1-Project-C TechShare.Courts 2018-07 Development:

Two (2) new TechShare releases were delivered to Dallas County on 3/1/18 and 3/2/18. The two (2)

releases were deployed to the Dallas County environment on 3/1/18 and 3/2/18 respectively. (Release

2.0.4179.1, Release 2.0.4177.1)

The Project Team experienced a few issues with the TechShare Courts Application on 2/28/18 with

those issues being addressed and resolved by the Dallas County Technical Team

(Server/DBA/Network) as of 3/1/18.

Other Items:

Per Dallas County executive direction and guidance, the Microsoft Code Review report will be presented

to the Commissioners Court along with the performance test review in April 2018, pending the delivery of

the Performance Test report.

Per the ongoing Microsoft performance assessment, below are some performance improvements noted

and how the “System Under Test” responded thus far:

o Custody Status message, Grand Jury Decision message, Save and Finalize Documents call and the

Mass Docketing flow:

Custody Status Transaction went from 13.7 seconds to 7.47 seconds;

Grand Jury Decision Transaction went from 1.26 seconds to 1.04 seconds;

Save and Finalize Doc Transaction went from 95.1 seconds to 32.1 seconds; &

Mass Docketing Test went from 508 seconds to 20.4 seconds.

o Performance improvements for the “System Under Test”:

D16SC2TSCINT03 CPU% went from 59% to 16%;

Attachment B - County IT Progress Forward Report - 20180313 - ver002 Page 2

D16SC2TSCAPP01 CPU% went from 38% to 15% (similar gains were seen across all app

servers.);

CRIMTESTSQL03 CPU% went from 32% to 88% (the bottlenecks were shifted from App to

SQL, and the team is currently looking into optimizations for SQL for TOR #2);

Passed tests per second went from 2.07 to 5.38; &

Avg Transaction Response times went from 24.8 seconds to 3.3 seconds.

Below is the schedule for Performance engagement:

Phase Length Date Status

Execution 2 weeks 2/26 - 3/9 In Progress

Reporting 1 week 3/12 -

3/16

Smoke Testing:

Smoke Test took a back seat last week and the early part of this week due to Microsoft performance

testing. We have gradually began to reinstate our smoke test efforts this week.

o About thirteen (13) smoke test scenarios were executed between 2/21/18-2/28/18.

Configuration:

Due to the Microsoft engagement, this work stream was impacted, however, about ten (10) configuration

tasks were completed in the week ending 2/23/18.

Data Conversion:

Per feedback from WhiteBox, the ETA for delivery of the converted data to Dallas County is 3/23/18. We

are working on possibly expediting the delivery date to 3/19/18.

The Project Team is scheduled to meet on 3/12/18 to discuss and review the impact the File Date

recommendation approval might have on Data Conversion.

Judicial Portal:

A demo of the Judicial Portal was held on 3/1/18 for the TechShare Project’s Technical Team.

A demo session was conducted on 3/7/18 with the Judiciary and Staff.

OnBase:

Guidance was received from Mr. Fitzsimmons for the District Clerk on the direction for reducing the number

of OnBase document types. The system assessment in light of that guidance is currently underway by the IT

Applications Team and the District Clerk’s Office SMEs on the Project.

3-PMO Mark

Kenneth

1-Project-D TechShare.Jail TBD Governance Planning

Met with Executive leadership team to communicate project-related concerns (i.e, financial controls,

developed software acceptance, backlog approval and prioritization, review of user stories, confirmation

of end-user requirements, etc.). Briefed the Dallas and Tarrant County Oversight Group to address these

concerns on 3/7/18.

Attachment B - County IT Progress Forward Report - 20180313 - ver002 Page 3

Awaiting assignment of Tarrant Financial resource to plan out how to implement the fiscal monitoring and

control over the project.

Project Execution

Worked with TechShare on the cadence and meeting structure.

Worked to develop the Vision Statement with SMEs.

Conducted additional Jail process reviews with Sogeti and the TechShare Development Team.

Led SME SO team meeting on 3/5/18 to start the process documentation and “pain point / wish list”

gathering.

Project Control

Worked with TechShare on Confluence / JIRA structure and processes.

Conducted meeting with Sogeti to cover the development cycle, tools and reporting.

Escalated growing risk and issues to Dallas County Executives.

3-PMO Todd 1-Project-E TechShare.JP 2018-11 Project Management:

Delayed completion of the 63 Software Development Items has negatively impacted the

project schedule.

Re-planning efforts are underway to determine the new completion date for the software

development items to include Software Shaping sessions.

The new sprint schedule for the software development is required to determine go live dates.

JP Technical Support Resource, Mehrshad Ashja, started on 3/5/18. This position will ultimately support

the JP product post go-live.

The Data Governance Working Committee Meeting is scheduled for 3/8/18 and the Data Governance

Committee and Product Owner meetings are scheduled for 3/9/18.

Business Process Review:

Identification of all JP related reports has been completed. These reports will be added to Jira for traceability to the new system.

Environment:

Several issues have been reported and escalated as they relate to JP configuration setup.

Configuration Training has not been scheduled. Escalated to Les Anderson of the CUC for resolution.

Testing in the JPI-BA environment continues as configuration work items are completed. This effort will

facilitate a production ready environment for go live.

Software Development:

Submitted feedback in Jira on the review of the Citation Entry Screen functionality.

JP team has reviewed the initial design of the Criminal Dispositions screen and provided feedback.

List of 63 JP software development items have been identified as ‘GO-LIVE’ requirements in Jira. Integration:

Meetings with Tyler continue on a bi-weekly basis to determine the scope for the Brazos interface.

Attachment B - County IT Progress Forward Report - 20180313 - ver002 Page 4

The JP Project Team has documented the business requirements for the Chase PoS, E-Commerce,

Linebarger & Omni interfaces. Next step is to obtain sign-off and determine the scope of work. Data Conversion:

The JP data conversion scope requirements have been finalized.

This effort has been delayed pending feedback on the software development schedule.

Submitted statutory data retention requirements to WhiteBox for review in efforts to identify the Data Conversion scope. This effort has been completed and a work order submitted by Whitebox for review.

Currently working with Whitebox providing feedback on data conversion questions as they relate to mapping database fields.

3-PMO Craig 1-Project-E1 TechShare.Indigen

t Defense

2018-09 Per the ITEGC Meeting in February 2018 and the CIO’s follow-up discussion with the County Auditor Mr.

Thomas, note that the County Auditor is still in the process of confirming a Product Ownership & Directions

Meeting with Judge Molberg. Per the CIO’s discussions with the IT Justice Systems Architect, County IT

will proceed to the degree possible with moving this forward technically in order to meet to the degree

possible the grant timeline requirements for September 2018. (Pending)

Implementation of this module is critical to the overall success of the County Justice Systems architecture

overhaul and is the planned solution for the management of the attorney wheels, voucher management,

financial assessments, IDR Report Generation and the management of attorney qualifications. If not

implemented, we will not have solutions for these critical business operations once AIS is “retired”.

3-PMO Tamica 1-Project-F HHS EHR 2018-04 The teams are continuing to configure the interface for CareEverywhere. We have provided the requested

information from Parkland on HHS resources list that is needed for the EpiCare Link interface. We will meet

on 3/8/18 with the teams to finalize the workflow process for the EpicCare Link interface. All parties have

been reminded that interface agreement has been renewed a couple of times and we need to adhere to getting

the interfaces completed before the 4/30/18 expiration deadline. The County CIO is following up with Mr.

Kull, the PHHS CIO, during the week of 3/19/18 on the scheduling of resources to complete this work.

3-PMO Bill 1-Project-G DCIM Direction 2018-04

County IT is in the process of the transitioning of the Project lead to Nathan Dillinger of the IT PMO due to

the projected July 2018 retirement of Bill Brown, the current Project Manager.

The following are specific updates:

1. Enabling Agencies to Utilize DCIM

o DPD Phase 2 Implementation

Completed - Validation of integrated connection of DCIM to Denali. Required re-enabling

Sypherlink’s VPN access.

Met with CIS/DPD on 2/22/18 to review the outstanding tasks with a follow-up scheduled for

3/8/18.

WIP - DPD Staffing Table has been loaded into DCIM production. Waiting on CIS/DPD to

Attachment B - County IT Progress Forward Report - 20180313 - ver002 Page 5

establish processing schedule for updating staffing table.

Pending - Requires DPD Plan for E-Booking Training & Roll-out during the period 3/14 -

6/30/18.

Received the approved DCIM v4 MOU with many requested changes from Dallas Legal. Will be

sent to Civil DA for review and comment.

o Phase 3 Web Based Agency Roll-outs

Completed - Indico established standard tables for each web based agencies as of 2/23/18.

Completed – Identification of agency DCIM Admins for ten web-based agencies as of

2/27/18.

Completed – DCIM Admin, E-Booking and DCIM inquiry training for eight agencies as of

2/27/18.

WIP – Receiving approved agency MOUs that were pending agency Legal & City Manager

review. Next step is to schedule on-site training and roll-out starting week ending of 3/23/18.

WIP - Phase 3 agencies need the same e-booking interface for automated updating of booking

information into their RM Systems. This is a new requirement for web based agencies. This will

eliminate redundant manual entry of booking information. This would be exactly like DCIM DPD

Denali booking interface (Pending assessment).

2. Preparation for N-DEx Justice Information Sharing (JIS)

o WIP - CJIS Addendums are still being collected in lieu of FBI N-DEx training starting on 3/27/18.

o WIP – Establishment of agency personnel credentials for N-DEx access before the March 2018

classes.

3. E-Booking

o Completed - DSO DMU is parallel testing e-booking modifications in production and staging as

of 2/23/18.

o WIP – One identified issue from testing was lack of DMU AIS Queue procedures. Will be working

with DSO and DMU to establish new procedures. Timeframe for completion is 3/20/18.

4. Upgrades

o WIP - TXDOT CRIS Accident Reporting testing continues. TXDOT has added new CRB2018

requirement that impacts RMS TXDOT CRIS, Accident Reporting, and E-Commerce.

o Pending - DCIM RMS UCR/NIBRS updating is on-hold because of higher priorities.

5. N-DEx Interface and Training

o WIP – Will have to establish agency’s credentials for N-DEx access before the March 2018 classes.

o WIP – Working with Jay Summers of FBI to finalize details of 3/27 -29/18 N-DEx Access Training.

2-Apps Jason 1-Project-J Clerks’ Redaction

Initiative

TBD The District Clerk has deferred her decision on moving forward with the redaction initiative until after the

Tyler partnering meeting, rescheduled from 1/10/18 to 5/3/18 due to availability of the principles to meet.

Shortly after this meeting, we anticipate securing a decision as to the next steps for this initiative.

Attachment B - County IT Progress Forward Report - 20180313 - ver002 Page 6

2-Apps Richard 1-Project-K LIMS

repair/replacement

2019-03 Sprint # 3 development activities are still underway with the expectation to be completed by 4/23/18 in light

of Product Owner feedback on the User Interface. (In progress)

4-

Security

Rajin 1-Project-L IT Security audit

remediation

2018-06 Have opted to move forward with the EoS/EoL network equipment upgrades as a priority for preparations for

the planned CJIS Audit in April 2018 and will revisit the redesign of the County Data Network after the CJIS

Audit is completed. Per discussions with the County Administrator’s Office, expect to brief the network

upgrade recommendation to the Commissioners Court on 3/20/18. Also note the following companion

activities:

Per networking with Mr. Petty of the State DPS CJIS Office, have tentatively scheduled a State CJIS pre-

audit for 3/29/18.

Efforts to complete the total network segmentation are expected to be completed by the end of March

2018. Once segmentation activities are completed, the Team will start on implementing the additional

Security Controls using software previously approved by the Commissioners Court (Still in progress).

The Avecto application (control of local administrative rights) rollout is in progress.

The rollout of the ClearPass OnGuard application to the desktop “fleet” is currently underway. The

application will aid in ensuring that PCs connecting to the County Data Network have the appropriate

County security components loaded on them.

Note the SAN “at-rest” data encryption has been completed and the file folder list is under review to

ensure that all of the applicable CJIS data has been included.

3-PMO Nathan 1-Project-N1 Body Cameras for

the DCSO

2018-04 Data query is complete and all software is installed onto the CAD Server. We are running in Read Only to

review the report data until we GO LIVE. We anticipate an April 2018 Go Live. The AXON Trigger Box is

still under evaluation.

3-PMO Shirley 1-Project-N2 Jail Camera

Expansion Project

2018-04 Desktop Support has completed installation of all of the camera surveillance desktops. Cabling

vendor must address an issue with completion of cabling/wall jack to allow connection of the Property

desktop to the camera network. Network connection for the Sterrett Kitchen desktops is dependent on

County Facilities providing electrical power for this area.

Switch equipment installations by County IT for the West Tower second floor and the Sterrett Kitchen,

are still on hold. Awaiting repair of the ceiling in the West Tower second floor closet and electrical

power for Sterrett Kitchen by County Facilities.

Ken Stephens, IT Network Services, is sending a daily network traffic report to Sology’s technical

contact, Levi Iiams.

The Court briefing for Phase 2 of the project for an additional 224 North Tower cameras and the

outstanding electrical power requirements for three areas in Phase 1 (Sterrett Kitchen, Release second

floor B Building and West Tower first floor) is projected for the Court Agenda on 3/20/18.

Projected goal is to rollout a total of 521 cameras as part of the new Jail Camera System.

Attachment B - County IT Progress Forward Report - 20180313 - ver002 Page 7

2-Apps Phani 1-Project-P Oracle 12c

Modernization

2018-04 Activation of the platinum services on the Test platform has been completed.

Oracle purchasing/Financial module patch updates - User Accepting Testing is in progress.

Testing of migrated Exadata database for KRONOS, County wide receipting (CWR), ONBASE and Web

applications databases is in progress. County IT DBAs continue to configure the remaining applications

to point to these new databases.

Initiated platinum support activation for the Production Exadata platform.

Active data-guard disaster recovery setups are in progress. Expect to start during the 1st week of April

2018 migrating the tested databases into production and complete all the databases by 4/30/18.

3-PMO Sabrina 1-Project-Q HEAT System

Rollout

TBD Currently reviewing the reporting from the new iHEAT Portal to compare the old reporting configuration to

the new to address a nuances in the reporting. CIO is planning a more detailed review with the applicable IT

Team members during the week of 3/12/18 to resolve the items noted. Still expect to have the reporting

stabilized by the end of March 2018 so that we can “retire” the use of the old system. At that point, will

begin the planning activities to rollout of the Self Service module for the County end-users and with the

rollout of the Change Management Module after that. (In progress)

2-Apps Gary 1-Project-T Web Content

Management

System (CMS)

2018-06 Veteran Services Office went live on 3/2/2018.

SWIFS - Phase 1 (initial 3 pages) submitted for approval on 2/22/18. DCIT submitted new photos for

approval on 3/5/18.

Marshals/Security - pending updated content. Currently awaiting additional information from Chief

Wilson as of 2/23/18.

District Clerk – Per a “face to face” follow-up with Mr. Fitzsimmons, currently pending site approval from

2/23/18.

Facilities – Will be submitted for review and approval on 3/7/18.

Records Building - Micro-site focused on the Records Bldg. renovation for County Administration.

Requirements are being gathered as of 2/23/18.

Sites for the County HHS and County Clerk’s Offices are currently in progress.

2-Apps Janice 1-Project-U Mainframe

Application

Offload

TBD Continue with the replacement for the functional migration of the those applications still in operations with

the following:

Warrants (District Clerk) – Still focusing on Phase II which is to move active warrants from FORVUS.-

Pending. WRWI will have to remain available until the rollout of the TechShare.Courts application;

“Unapprehend” warrants are to be covered by TechShare.

Civil Papers (Constables) – Work continues with migrating the Constables on to a temporary system while

they evaluate the option of moving to a commercial-off-the-shelf (COTS) application to meet their long-

term needs.

Rap Sheets- The data has been migrated into AIS and is being tested internally by the IT Staff. There was

some data not able to be loaded into AIS. Need to determine the handling of this information. (In

Attachment B - County IT Progress Forward Report - 20180313 - ver002 Page 8

progress).

Stale Data - The data is being loaded into and tested from SQL databases so that it can be accessible to the

end-users after the mainframe offload is completed. (In progress.)

Supply Inventory- WASP seems like a good solution to implement and we already have licenses. We are

tentatively scheduling a meeting with the vendor for the week of 3/12/16.

Companion work continues on the research for and the production of the Bond Discharge Report (Felony

and Misdemeanor). The reports have been provided to both Misdemeanor & Felony Clerks and the Team

is currently waiting for end-user feedback to determine if updates are required.

1-Ops Paulette 1-Project-X Cisco Phone

System upgrades

2018-03 Per the plan to re-IP the gateways at the fifty-six (56) sites to point to the CyrusTwo host and per the

discovery meeting/session with CDW-G, plan to complete the re-IP process by 3/31/18 (Still in progress).

Met with CDW-G on 3/7/18 to go over the schedule for migration.

2-Apps Richard 1-Project-Y 911 CAD (et. al)

Systems upgrades

TBD Per meetings with the DCSO Sheriff and her Command Staff, the IT Applications Chief is drafting a joint

presentation with City of Dallas for the County Sheriff’s consideration to brief the Commissioners Court and

for the DPD Chief’s consideration to brief the Dallas City Council in order to receive official buy-in and

approval to proceed with this collaborative initiative. Action plan to be drafted by the week of 3/12/18. (In

progress)

2-Apps Phani 1-Project-Z SQL Upgrade to

v2016

TBD Discovery and pre-planning are still in progress. Projected completion date to be determined based on

discovery and project plan. Shirley Gardner has been assigned as the IT Project Manager. Completion

surrounding the due-diligence phase, including the associated documentation, is projected for 5/1/18.

2-Apps Richard 1-Project-Z1 Commissioners

Court Agenda

Management

System Transition

2018-06 Attended the BoardDocs and PrimeGov product demonstrations during the week of 3/5/18. Will networks

with the County Clerk’s Office as needed for next steps in the selection process.

3-PMO Stephanie 1-Project-Z3 CSS Application

implementation for

CSCD

2018-07 A Pre-trial application requirements meeting was held on 3/5/18 with IT and CSCD with Pre-trial and

Probation representatives attending. Per detailed discussions on the Pre-trial end-user requirements for the

application and per a teleconference call from the meeting to Ms. Comeaux of CSS, intend to break up the

roll-out into phases so as to deploy the application for Pre-trial as soon as possible.

The County will network with CSCD Pre-trial and with CSS to confirm the phases of the rollout and to

confirm what functionality will be included in each phase (i.e., base system with data conversion, web

services interfaces, etc.) along with the timeline for each phase.

The Commissioners Court approved the amendment to the original agreement on 3/6/18.

Photos in AIS are currently stored in a bit-stream format which the vendor will need to determine a

solution to convert the images.

3-PMO Brett 1-Project-Z4 AP Automation

Project

TBD In light of the projected costs to have a consultant assist with this effort, this is been set to a “Pending” Status.

One item being explored for moving this forward is leveraging the applicable module TechShare.Indigent

Attachment B - County IT Progress Forward Report - 20180313 - ver002 Page 9

Defense Project to meet part of this need and to thus reduce, but not necessarily obviate all of the

requirements. (Pending)

3-PMO Tamica 1-Project-Z5 FMLA Module

Deployment

2018-05 IT continues to build on the Test Eligibility File. Data validation updates continue to be sent weekly to the

vendor. IT is also working on the Electronic Tail Claim File which encompasses past information on the

staff. The current anticipated go-live for the project is 5/1/18, pending all the required data sets being sent

and validated by 4/23/18. We will continue to meet weekly to work on the implementation timeline.

3-PMO Sabrina 1-Project-Z6 Queuing System

RFP rollout

TBD The Purchasing Office has confirmed the County will be able to use a pass-through contract to acquire a

Queuing System from Nemo-Q. Sistema Technologies and Nemo-Q have partnered to provide this solution

via State of Texas DIR Agreement # DIR-TSO-3912. Having a follow-up meeting with the County Tax

Office, County District Clerk Office and the County Clerk Office during the week of 3/19/18.

3-PMO Sabrina 1-Project-Z7 ePoll Book RFP

rollout

2019-03 Sent the Voting System specifications to the County Elections Department for their review and approval on

02/14/18 and are currently awaiting their approval after the March 2018 Primary Elections activities are

concluded. Per Mr. Martin’s direction, in the process of scheduling a joint meeting in Austin, TX with other

Texas Counties to review the specifications in efforts to prepare a joint Voting System RFP.

1-Ops Rodney 2-Platform-A DCSO network

rooms on

emergency power

2018-03 Per an update from ACA Mr. Bazan, the new generator has been delivered and installation of the new

generator is in progress with the expectation that the generator will be implemented by the end of March

2018.

1-Ops Paulette 2-Platform-F ASE-OnDemand

Rollout

TBD Continue with the migration schedule for the rest of the applicable circuits with AT&T and making site visits

for the next locations to be migrated (Still in progress with 21 new circuits now in service, 8 in the process

of being connected, two sites which need to have the reorder done to show the correct address and one

which needs to be surveyed for an aerial connection (3/15/18)!).

1-Ops Sean 2-Platform-

G1

Windows OS

Upgrades for

Desktops and

Servers

2019-07 Have initiated activities to conduct an asset inventory across the County to identify the exact locations of

older assets for refresh. Anticipate project to be in full swing by April 2018. Also networked with business

partner GTS to upgrade the OS platform on the County Elections laptops in preparation to conduct the March

2018 Elections.

1-Ops Sean 2-Platform-

G2

Security upgrades

for Windows OS

2018-03 Four [HVAC, password, video conferencing (2)] servers still remain and which need to be upgraded to

address the application-OS incompatibility items with those platforms. Continue working with County

Facilities and the HVAC vendor to schedule the upgrade of their system. Current target to have video

conference system replaced is the end of March 2018. The final system related to password resets is tied to

the Microsoft EMS deployment, referenced at “2-Platform-M” in this document. (In progress)

1-Ops Paulette 2-Platform-H eFax Rollout TBD Have orders in que for County Purchasing. Note that SWIFS wants to roll out eFax to more of their Sections.

CSCD has requested service along with the Veteran Services Office. (In progress. Per the IT Leadership

Team Meeting discussions on 3/8/18, need to address a concern with receiving confidential information on

eFax and having the eFax routed via email.)

Attachment B - County IT Progress Forward Report - 20180313 - ver002 Page 10

1-Ops Sean 2-Platform-I Desktop

Modernization

Initiative

TBD Have started receiving and deploying the most recent round of desktop purchases, approved by the

Commissioners Court. County and District Clerks’ Offices’ purchases of several hundred PCs have also

been approved and we are mobilizing the Teams to deploy these assets in Q1CY2018. (In progress)

Deploying the ordered assets for the technology refresh project for the County Road & Bridge District #3.

(In progress and expect to be completed by mid-March 2018).

Also, currently delivering the FY17-18 PIR PCs. (In progress)

Briefing to the Commissioners Court for 3/6/18 was approved to order the next set of PC replacements as

part of a planned $760K refresh project for FY17-18.

2-Apps Gary 2-Platform-J KRONOS upgrade TBD Kronos, the provider, was onsite from February 28 – March 2, 2018 to assist with assessing the system for

upgrading. Had productive assessment meetings with Kronos and several major County Departments.

Kronos also demonstrated the new version, v8, to the Dallas County Community. Below are the major

takeaways from these meetings:

o Kronos v8 is independent of Java, which will eliminate several challenges for the County.

o New touchscreen units – although our clocks are still supported with the new version, they will reach

end of support very soon. New clocks are bigger and have touch screen feature. Other than using a

badge, employees can key-in badge id and/or use a biometric feature.

o Using new clocks, employees can check their time entry and submit time-off request.

o Mobile option – County already owns around 1,800 mobile licenses, however, there are a few

concerns which need to be addressed in terms of accessibility, accountability and open record policy.

o Leave management / Time off feature.

o New modules like Telestaff and Workforce activities (Grant and Project tracking) were also

demonstrated.

o Kronos Mobile.

We are currently planning to schedule a web demo/assessment for the few County Departments who were

note able to attend (HHS, SWIFS, Elections & Public Works). As soon as this demo is completed, Kronos

will document the assessment results and will provide us a detailed report.

2-Apps Gary 2-Platform-K CrossMatch

Upgrade

2018-05 Have initiated implementation plans for the Juvenile CrossMatch replacement platforms. The tentative “go-

live” date is 5/23/2018.

1-Ops Rodney 2-Platform-L Platform

Stabilization

2014-04 Continuing with QA reviews of several recent IT system outages in order to assess and strengthen County

IT’s processes for rolling out system changes. Also, met with AT&T to review the root cause analysis (RCA)

with the calling outage which manifested on 2/16/18 and obtained their commitment to address several other

system stability items with their provided infrastructure (i.e., MetroCells, SIP Trunking, data circuits, etc.) (In

progress).

Attachment B - County IT Progress Forward Report - 20180313 - ver002 Page 11

2-Apps Richard 2-Platform-M Microsoft

Enterprise

Mobility Suite

Deployment

TBD The planning for the rollout of the products in the suite is currently in progress with the AD Password Reset

functionality being the first module in the “queue” set for rollout (In progress with this phase tentatively set

for March 30, 2018).

2-Apps Richard 2-Platform-N AIS Jail Visitation

Modification

2018-02 COMPLETED Go Live on 02/09/18 (ahead of schedule).

2-Apps Richard 3-Plans-B Enterprise GIS

setup

2018-07 Per follow-up with the City CIO, note the City Council approved on 2/14/18 the CIS Office’s

recommendation for establishing an enterprise GIS Portal with the intent of consolidating the GIS needs of

the City Departments on to the new Portal once it is deployed. The County and City continue to develop a

collaborative proposal for Executive review by late March 2018 in order to receive official approval for

potentially using the City’s soon-to-be deployed enterprise GIS portal to meet the County’s needs.

5-

Admin

Vic 3-Plans-C MTF budget audit

and structuring

2018-06 Per approval of the Court Agenda for 3/6/18, QNet has been selected as the best bidder for the IT Desktop

Support RFP. Currently developing an option for the County Executives’ consideration to maintain a

small complement of four (4) full-time Desktop Staff with the contract Desktop Support Technicians.

Per follow-up discussions with the County Purchasing Office on the development of a contract Staffing

RFP for our future Staff augmentation needs, with thirteen (13) of the County IT positions being proposed

for the preliminary RFP solicitation, have provided additional information to County Purchasing in order

to draft the solicitation for release in March 2018. (In progress).

4-

Security

Rajin 3-Plans-D Cybersecurity

Training &

Awareness

2018-03 Per discussions with Chief Bass of the OHSEM, have scheduled another cybersecurity presentation

by the Texas A&M University Cybersecurity Division for April 26, 2018 at the County EOC at

Panoramic Circle. The County CISO sent out email notice on 3/2/18 to the County Department to

start registering for the training.

Per a preliminary internal phishing email campaign for end-user awareness, making plans to conduct

subsequent campaigns to raise end-user awareness (Pending).

Still plan to meet with Chief Bass of OHSEM to plan the next EM table-top exercise for the County Staff

with a cybersecurity component (Pending).

Training on the current IT Security Policy is also being planned for rollout in Q1CY2018 (Pending).

The County CISO has created and the CIO has reviewed a preliminary draft of the IT Security Training

and Awareness Policy. Expect to provide the draft to the IT Leadership Team for the subsequent review

prior to presenting it to the County Executives for their review and adoption (Pending).

5-

Admin

Vic 3-Plans-E Data Driven

Justice Initiative

TBD The CIO attended the last meeting of the Data Driven Justice Group on 2/21/18 and is scheduled to attend the

next meeting on 3/19/18. Also, note the MOU for data sharing from the AIS platform as part of the

LoopBack Analytics initiative is currently under review by the Civil DA’s Office.

5-

Admin

Vic 4-People-A Vacancies 2018-09 On 3/5/18, welcomed Mehrshad Ashja from the contract IT Desktop Support Team as a full-time IT

Senior Systems Analyst with an initial assignment to support the TechShare.JP Project.

Attachment B - County IT Progress Forward Report - 20180313 - ver002 Page 12

With Sam Tao’s retirement as of 3/1/18, currently have four vacant IT positions. Have a lead candidate

identified for the SSRS Developer vacancy and will continue with the interview process to confirm lead

candidates for the other open positions as quickly as possible.

Project another two IT Staff retirements with one in May 2018 and another one in July 2018.

5-

Admin

Vic 4-People-B Certifications-

Stipends Review

TBD The CIO attended the Comment Review Session hosted by County HR on 1/30/18. County HR is currently

reviewing the feedback received for “next steps”. (Pending)

5-

Admin

Vic 4-People-C Staff Recognition

and Development

NA Note that Carlos Blanco, IT Senior Oracle DBA, was recognized by the Commissioners Court as the

Department Employee of the Month for February 2018 at the Commissioners Court Session on

3/6/18.

Recognized the County Service Anniversaries of the following IT Team members during the month of

March 2018:

Terry Clark, IT Senior Business Analyst (14th

) - 7 years

Dang Dinh, IT Senior Systems Analyst (28th

) - 7 years

Sabrina Roberts, IT Senior Project Manager (26th

) - 6 years

Traci Newbill, IT Senior Oracle Systems Administrator (28th

) - 5 years

Alex Garcia, IT Server Administrator (20th

) – 1 year

5-

Admin

Vic 4-People-D IT Organizational

Review

2018-03 This review is being conducted as part of the FY18-19 Budget preparation process, per discussions with

the IT Assistant Chiefs. The CIO noted that any Staff and resource restructuring would need to generally

be aligned to the following principles:

o Planning Strategically

o Building Intentionally

o Monitoring Effectively

o Responding Proactively

o Resolving Expeditiously

o Growing Professionally and Technically

o Celebrating Regularly.

Completed the review of the September 2017 IT Staff Survey results and are confirming the appropriate

next steps.

The next IT All Hands Meeting is scheduled for Tuesday, 3/20/18.