CIO’S PROGRESS FORWARD REPORT – May 2015

Transcription

CIO’S PROGRESS FORWARD REPORT – May 2015Priority #1. IT Staff Retention and Development Recognized the County Service Anniversaries in May 2015 for the following IT Teammembers: Alice Sweet, IT Administrative Coordinator (28th) – 13 years Richard Ballard, IT Applications Chief (19th) – 7 years Kimberly Brown-Cleveland, IT Information Systems Coordinator (23rd) – 7 years Yakov Kuznetsov, IT Senior BizTalk Applications Developer (28th) – 6 years Sarah Stoddard, Acting IT PM Chief (9th) – 4 years Art Brown, IT Senior Systems Analyst (23rd) – 4 years Candace Pierce, IT Senior Systems Analyst (27th) – 1 year (plus her time as acontract Staff member) Michelle Wilson, IT Senior Business Analyst, was recognized by the CommissionersCourt as the County IT Department’s Employee of the Month. Per the IT Phase I Organizational Review with County IT Applications, note BrettTaylor, IT Applications Development and Support Manager, has been reclassified asthe IT Assistant Applications Chief. Kimberly Tran, IT Senior Server Administrator, has been selected for promotion via aninterview process to the IT Enterprise Server and Storage Architect position, whichwas approved as part of the FY14-15 Budget. Per the IT Phase II Organizational Review, the ITEGC unanimously endorsed and theCommissioners Court approved establishing an IT Lead Network Engineer designationand an IT Lead Server Administrator designation in the County IT Operations Teamalong with a corresponding IT Operations organizational structure change. This item isscheduled to be reviewed by the County Civil Service Commission on 5/18/2015. Note with sadness the passing of Ms. Mary McPhaul, the County IT ProjectManagement Chief in April 2015 after an extended illness. She served faithfully anddiligently for over eight years as part of the Dallas County IT Team and will be sorelymissed among our ranks. Have appointed Sarah Stoddard, IT Senior Project Manager,as the Acting IT Project Management Chief. Due to his accepting position with another organization, accepted the resignation of oneof the IT Information Services Coordinators who supported the DCSO Patrol Unit. Willwork with the County HR Office to fill the position. Of the ninety-seven full-time IT positions, currently have eight vacancies without aconfirmed replacement identified. Working diligently with County HR and ourdesignated contract Staffing firm partners to fill the vacancies as quickly as possible,including two IT Senior Server Administrator positions and one IT Senior Security Analystposition, which all have proven somewhat difficult to fill.Priority #2. IT Infrastructure Protection and Stabilization Successfully completed the project to migrate the County’s Active Directory FederatedService (ADFS) from on-premise to the Microsoft “Cloud”. Experienced a significant and unscheduled data network outage due to a equipmentcomponent failure at the contracted network link provider’s facility. Networked withAttachment B – CIO Progress Forward Report – 20150421Page 1

the provider who replaced the failing component to resolve the issue. Met with theprovider to review the “lessons learned” and to identify and subsequently implementoptions to minimize the likelihood of a reoccurrence.Due to a recent and unscheduled utility power outage at the County OHSEM Building onPanoramic Circle, working with the OHSEM Chief to significantly reduce and possiblyeliminate any single points of failure which would impact the operations of the CountyEOC in the event of another utility power outage.The County IT Applications Team is networking with the SWIFS Office to “tune” theapplications environment for the LIMS platform in order to strengthen the platform’sperformance.Priority #3. IT Program ManagementAdministration & Finance Community The Desktop Support RFP was awarded to Winndalco Enterprise. The agreement withthe new provider is being finalized with July 1, 2015 being the target date for thetransition to take place. Met with the County Budget Office for an MTF budget forecasting review with theCounty Budget Office to provide updated revenue and fund “pay-back” projections sothat County IT can update its 10-year MTF budget projections. Completed the upgrade of the thirteen (13) PoS devices at the County Vitals andRecords Office and plan to complete the upgrade of the remaining sixty (60) PoS devicesin the other fourteen (14) County Departments by 9/30/15.Civil Justice Community Per the Commissioners Court’s approval of the AgileJury Jury Management Systemand discussions with the Xerox, the application provider, held the Project KickoffMeeting on Friday, 5/15/15. Per discussions with the Civil DA Head on plans for acquiring a Civil DA DocumentControl System, note the Requirements Document has been updated and have obtainedfinal approval from Civil DA on it on 5/7/2015 and subsequently requested theassignment of County Purchasing agent to start the RFP process. Have scheduled afollow-up meeting for 5/19/2015 with the Civil DA Staff to discuss potential conversionof historical data. Held follow-up discussions with the CUC and with the JP Courts CMS Stakeholders onplans for developing the TechShare.JP CMS application and are preparing the Projectbriefing recommendation for the development and implementation effort for theCommissioners Court’s review and consideration for approval. As part of the Juvenile Courts Case Management System (CMS) Project, two of theCounty SQL DBAs attended custom training on the Intermediate File Layout (IFL) Toolduring the week of 5/11/15 so that the DBAs could begin the data conversion. Also, permeetings with the Project Stakeholders and with Tyler Technologies, the systemprovider, plan on scheduling the formal Juvenile Courts CMS Project Kick-Off for June2015 once the County DBAs complete their preliminary data conversation assessment.Attachment B – CIO Progress Forward Report – 20150421Page 2

Community Services Community The County Administrator, the County Elections Director and the CIO are met with theScytl/SOE Executives and Account Management Team at their Tampa, FloridaHeadquarters on 4/30/15 to review their Elections support operations and note the May9th 2015 Elections went smoothly and were successfully conducted. Resolved a network connectivity issue with the Pitney Bowes postage system for theCounty Elections Office.Criminal Justice Community TechShare.Courtso Two contract Data Analysts and one contract Project Coordinator were on-boardedper the approved Project budget, however, one of the Data Analysts resigned afterstarting.o Conducted & completed TechShare.Court Design Review Session for the Schedulingmodule of the application during the period 4/28/15 – 4/29/15.o Conducted a business process review with the Criminal Courts Managers (PatJohnson & Dana Nixon) 5/4/15 – 5/8/15.o Conducted a TCCP training session with the Dallas County SMEs & Tarrant Countyduring the period 5/5/15 – 5/6/15.o Conducted a Financial “deep dive” session with Dallas County SME’s on 5/7/15 –5/8/15.o The Group 3 COA (Conditions Of Acceptance) is in review with Tarrant County &CUC.o Counties are scheduled to begin FAT (functional acceptance testing) on 5/18/15.o Selected via an interview process a contract BizTalk Applications Developer, with theDeveloper scheduled to start on 5/27/15. TechShare.Prosecutor:oLEA Portal Pilot Carrollton PD continues to file cases with no major issues.oLEA Portal and Defense Portal Rollout Planning to brief Commissioners court with regard to LEA Portal and DefensePortal rollout on 5/26/2015 with court order to occur on 6/2.Held kick-off meeting with LEA’s on 4/28/15. Agencies were providedwith MOU, roll-out plan and prerequisites for participation. DPD did not participate in this meeting. Strategy discussions areunderway to bring DPD into the fold as soon as possible. LEA response has been significant. Grand Prairie is next up on theschedule and will be engaged immediately upon approval of therollout project by the Commissioners Court (Court order expectedon June 2nd). Required implementation resources have been defined. Funding requestfor these resources will be included in the May 26 “TechShare ProgramManagement Group” staffing brief.Resource Sharing Addendum oAttachment B – CIO Progress Forward Report – 20150421Page 3

The TechShare.Prosecutor Resource Sharing Agreement is planned to bebriefed on 5/26/2015.Redaction rules have been expanded due to requirements of the MichaelMorton Act. Change order for one additional field at a cost of 1500 will berequired prior to implementing the redaction component in productionenvironment. oLEA Community Arbitrator Video System:o The Digital Media Evidence (DME) Summit in Austin, TX has been confirmed forJune 10 -11, 2015. Senator Royce West will be in attendance and the Countyplans to send several County Staff members both from the DA's Office and fromthe IT Project Teams. Brazos E-Citation System:oMC-67 Kitting Process: Ten kits have been created and are in the field with DSO under testing. 70% of the Hand-Held’s have been configured with profiles. Testing connectivity tests for DC-Guest and in car Rocket WIFI accesspoints were successful. Printer and DL/Registration Scanning tests will be conducted during weekof 05/10/2015. MC-67 Device configuration and “Kitting” activities will resume duringweek of 05/10/2015. Met with Chief Clerk Zoe Harland to go over offense codes. Project thatthe offense codes will be configured and approved by 05/20/2015.oMainframe integration testing: Testing End to End Process. Fixed logging issues of items not being sent to the correct group. Unit testing for integration components is in the final stages and theteam will be preparing for a final UAT in mid-May 2015.oOffense Code Configuration: The Offense code table has been provided to Brazos and has been loadedinto the test environment. With the exception of the 96 new offenses, the offense code table hasbeen accepted by the business unit, but needs to be approved andreworked in order to finalize all the offense codes.oWork to resolve issues with Utility Rockets has progressed and we are stillworking to resolve some connectivity issues with some of the hand helds.oUAT Testing UAT testing first phase was completed for the week of 05/04/15 UAT confirmed 21 open issues which have been logged and sent back toBrazos for a fix.UAT testing will continue through 5/27/15.Attachment B – CIO Progress Forward Report – 20150421Page 4

DCIM:o New Jail intake computers (6) and driver license readers were installed on4/27/15.o Implemented Solution for eliminating DCIM duplicate arrest records from AgencyJMS and RMS on 4/30/2015.o The IT DBA Team completed the backup and archive of the RMS/DCIM databaseon 5/7/15 and have added the step for purging the transaction files on the RMSand DCIM to the maintenance plan for quarterly processing.o Successfully processed and validated SWRCC (Cedar Hill, Desoto, Duncanville, andLancaster PDs’ OSSI Spoke) arrestee charges including duplicates through DCIM Ebooking.o Sypherlink has signed the SOW for the additional hubs and licenses for the DCIMInfrastructure to improve Agency “spoke” failover and load balancing. They will becoordinating an installation and implementation schedule with the DCIM ProjectTeam by 5/29/15. Expecting production installation and implementation of the twoadditional hubs by 6/22/15.o Had problem with many certs expiring on RMS, DCIM, HUB, URLs last week andsystems being down for a day while we acquire and apply certs. County IT willdevelop a procedure to update the affected certs, without having to engage thevendor, at least three weeks before their expiration.o Irving PD (Tiburon Spoke): Irving PD and Irving Records Management DCIM production validation andapproval of IRPD historical information is being validated by Capt. Hall, KellyRipley, and Anthony McCain. Sign-off on validation and approval has not beenreturned, but obtained verbal approval from Capt. Hall on 5/5/2015. Capt. Hall will be meeting with Anthony McCain of Irving DP IT Support onproduction Spoke environment. Scheduled production replication functional atIRPD with P-to-P communications by 5/29. IRPD Production Tiburon Spoketesting in DCIM Staging is scheduled to begin 06/01/2015.o Dallas PD (Denali Spoke): Met with Dallas CIS, DPD, and Dallas County Project Team on e-booking, DCIMintegration, and Denali’s roll-out status on 4/22/2015. Follow-up meeting to bescheduled. Met with DCIM Project Team on DPD E-booking requirements on 5/5/15.Identified Booking Number as unique AIS ID for automated interface from DCIMto AIS to Denali and from Denali to DCIM. Following up meeting is beingscheduled with DPD and CIS to finalize requirements on 5/28/2015.o Mapping incident and arrest information that is not being automatically transferredfrom DCIM to AIS. Will modify AIS queue processing (web service) to pass allrequired information and eliminate rekeying of that information from systemgenerated e-booking forms. Requirement definition will be completed and ready forbriefing by 5/15/15.Attachment B – CIO Progress Forward Report – 20150421Page 5

DCIM Agency Roll-OutAgencyInformationSharinge-BookingSWRCC (DeSoto, Duncanville, CedarHill, Lancaster PDs)Addison PDBalch Springs PDCarrollton PDCockrell Hill PDCombine PDCoppell PDDecember 2013TBDTBDTBDTBDTBDTBDAugust 2014TBDTBDTBDTBDTBDTBDDallas PDDART PDNovember 2015TBDSeptember2015TBDDC Sherriff OfficeJune 2006March 2014Farmers Branch PDFerris PDTBDJune 2007September2014TBDGarland PDGlenn Heights PDGrand Prairie PDHighland Park PDHutchins PDSeptember 2014TBDTBDTBDTBDAugust 2015TBDTBDTBDTBDIrving PDJune 2015August 2015Mesquite PDOvilla PDRichardson PDRowlett PDSachse PDSeagoville PDSunnyvale PDUniversity Park PDWilmer PDWylie PDJuly 2014TBDTBDTBDTBDTBDJune 2006TBDTBDTBDJuly 2015TBDTBDTBDTBDTBDJune 2007TBDTBDTBDCommentsWeb-BasedDelayed due toDPD RMS Denaliitems encounteredeFiling completed10/2010Date adjusted forduplicate chargemodifications.Web-BasedWeb-BasedPending final IRPDreview.Date adjusted forduplicate dNOTES:1.2.Web-Based agencies represent 6% - 8% of Dallas County incidents, booking, arrests,offences and case filings.DCSO has been e-filing since October 2010. E-filing for remaining LEAs is dependent on theimplementation of the Prosecution Module interface.Attachment B – CIO Progress Forward Report – 20150421Page 6

3.4.All “TBD” items are dependent on the availability of future funding.Note the DCSO DCIM support risk previously identified has been resolved with the DCSOpermanently assigning DCSO Deputy Michael Raley to the DSO DCIM Admin Group.Priority #4. IT Infrastructure Maintenance and Development Note the completion of several IT infrastructure upgrade items by the County ITOperations Team as referenced in Attachment H.Priority #5. IT Cost Containment Reviewing options for appreciably reducing the County’s recurring maintenance costsfor its Oracle EBS platform and will provide an update at the Meeting of the ITEGCMeeting by August 2015.Attachment B – CIO Progress Forward Report – 20150421Page 7

May 19, 2015 · DCIM: o New Jail intake computers (6) and driver license readers were installed on 4/27/15. o Implemented Solution for eliminating DCIM duplicate arrest records from Agency JMS and RMS on 4/30/2015. o The IT DBA Team completed the backup and archive of the RMS/DCIM database on 5/7/15 and have ad