it project listing alignment - california
TRANSCRIPT
Grouped By: Status,Functional Group,
Customer: All
Contact Person: All
State: Active
Public Commentes Entered Date: Any
Days Since Last Public Comment Entered: Any
Status Changed Date: Any
Functional Group: AllPriorities: All
Architecture: All
Title Contact Person
State
Scope
Time
Money Priority
Comm
unity
Econ/Envir
Future
Services Budget ActualOne Time Cost
Annual Ongoing Cost
Target Start
Target Finish
Hours Estimate
Active (Total Projects: 50) 5 3 16 15 $1,388,488 $518,954 $127,884 $26,458
Enterprise Applications (Total Projects: 6) 0 0 4 1 $126,800 $11,600
Update County Enterprise GIS Strategic Plan[Enterprise Application]
Tim Pudoff
Active
x-x-x
Routine
X $115,200 Q3 2013 Q2 2016 800
Description: Update the Enterprise GIS Strategic Plan to provide a blue print for providing GIS services for the next 5 years (County GIS Strategic Plan 2020)
Latest Comment: ESRI PSA was created by ISD Admin for health check; ESRI negotiated and approved the language; contract under review by SCWA's counsel. Expect review to be completed this week.
Comment Entered:
4-21-2016 1436
Upgrade or Replace Report2Web with another solution[Enterprise Application]
Mary Bucher
Active
x-x-x
Routine
X Q1 2015 Q2 2016
Description: Report2Web v3x is on Windows Server 2003 and needs to be upgraded or replaced by July 2015. Analyze possibility of upgrading to the latest version of R2W vs converting to OnBase.
Latest Comment: Training has been completed. Three end user training sessions were held to teach County employees how to navigate the new tool. The onsite trainer spent some training configuring our R2W production deployment and set up our development server environment. In process of setting up "watch" folders for file drops.
Comment Entered:
4-29-2016 1012
Upgrade SoCoMap Basic GIS Intranet Application[Enterprise Application]
Tim Pudoff
Active
x-x-x
Routine
X $11,600 $11,600 Q1 2015 Q2 2016 80
Description: Replace existing SoCoMap Basic intranet application with new ESRI JavaScript MapViewer that references data in the newly migrated Enterprise GIS database
Report Generated: 4/29/2016 12:52:55 PM Page 1 of 18
IT Project Listing: AlignmentCounty of SonomaInformation Systems Department
Dollar amounts are italicized for unfunded projects.
Title Contact Person
State
Scope
Time
Money Priority
Comm
unity
Econ/Envir
Future
Services Budget ActualOne Time Cost
Annual Ongoing Cost
Target Start
Target Finish
Hours Estimate
Active (Total Projects: 50) 5 3 16 15 $1,388,488 $518,954 $127,884 $26,458
Enterprise Applications (Total Projects: 6) 0 0 4 1 $126,800 $11,600
Latest Comment: Contractor working on application design; ISD-GIS working with contractor to establish a stage environment on County infrastructure.
Comment Entered:
4-21-2016 1438
Deploy Webex enterprise wide[Enterprise Application]
Jonathan Kajeckas
Active
x-x-x
Strategic
X Q3 2015 Q2 2016
Description: This project is deploy webex enterprise wide.
Latest Comment: Expanded deployment within ISD, desktop productivity tools being installed department wide and user documentation prepared.
Comment Entered:
10-30-2015 0824
Upgrade Peoplesoft Financials to 9.2[Enterprise Application]
Sherry Bevens
Active
x-x-x
Routine
X Q1 2016 Q3 2017
Description: Upgrade PeopleSoft application from version 9.1 to 9.2
Latest Comment: RFP responses are being evaluated Comment Entered:
4-29-2016 1154
SB272: add Section 6270.5 to Government Code relating to Public Records[Enterprise Application]
Sabrina Doss
Active
x-x-x
Routine
Q1 2016 Q2 2016
Description: California mandate to list certain enterprise-wide systems and make available to the public by July 1, 2016
Latest Comment: The database schema changes to accomodate a few changes to the fields has been completed. The majority of the LightSwitch work has been completed. Work has begun on the SSIS package to handle the imports into the new SB 272 database table. Work has not yet begun on the export SSIS package to create a file for importing into Socrata.
Comment Entered:
4-29-2016 1028
Report Generated: 4/29/2016 12:52:55 PM Page 2 of 18
IT Project Listing: AlignmentCounty of SonomaInformation Systems Department
Dollar amounts are italicized for unfunded projects.
Title Contact Person
State
Scope
Time
Money Priority
Comm
unity
Econ/Envir
Future
Services Budget ActualOne Time Cost
Annual Ongoing Cost
Target Start
Target Finish
Hours Estimate
Active (Total Projects: 50) 5 3 16 15 $1,388,488 $518,954 $127,884 $26,458
Enterprise Infrastructure (Total Projects: 13) 0 0 9 0 $20,000
Governance Risk and Compliance:Security Awareness Training & Education[Enterprise Infrastructure]
Rob Lee
Active
x-x-x
Routine
Q3 2015 Q1 2017
Description: Develop security awareness training materials and communication process.
Latest Comment: Health-IT,Sheriff-IT ,ISD,HR,TVMC and ISSC will all participate in the Pilot Comment Entered:
4-18-2016 0832
Governance Risk and Compliance: IT Use and Security Policy manual and IT Professional Policy Manual - Vetting[Enterprise Infrastructure]
Rob Lee
Active
x-x-x
Strategic
X Q1 2013 Q2 2016
Description: Vetting of Policy manual by Unions
Latest Comment: meeting with other unions the 1st week of March Comment Entered:
2-25-2016 1424
Assess SQL 2005 databases and migrate them to SQL 2008 /SQL 2012 Cluster [Enterprise Infrastructure]
Dean Longhurst
Active
x-x-x
Routine
Q3 2014 Q2 2016
Description: Assess SQL 2005 databases and migrate them to SQL 2008 /SQL 2012 Cluster
Latest Comment: Waiting for resources to free up at Systems and Programing. DBA's are ready to move databases but it will require coordination with Systems and Programing staff to point applications to new database locations.
Comment Entered:
4-15-2016 1132
Report Generated: 4/29/2016 12:52:55 PM Page 3 of 18
IT Project Listing: AlignmentCounty of SonomaInformation Systems Department
Dollar amounts are italicized for unfunded projects.
Title Contact Person
State
Scope
Time
Money Priority
Comm
unity
Econ/Envir
Future
Services Budget ActualOne Time Cost
Annual Ongoing Cost
Target Start
Target Finish
Hours Estimate
Active (Total Projects: 50) 5 3 16 15 $1,388,488 $518,954 $127,884 $26,458
Enterprise Infrastructure (Total Projects: 13) 0 0 9 0 $20,000
Governance Risk and Compliance: PeopleSoft Security Assessment [Enterprise Infrastructure]
Rob Lee
Active
x-x-x
Routine
X Q1 2015 Q3 2016
Description: This proejct to provide a security assessment for the current peoplesoft(EFS) system. This project will focus on assessing file/folder management, peoplesoft roles assignments and SQL 2012 r2 security
Latest Comment: moved to active, updating project plan and starting to put in SR's for audit requests Comment Entered:
2-25-2016 1253
Governance Risk and Compliance: Deploy Active Directory Rights Management Services[Enterprise Infrastructure]
Rob Lee
Active
x-x-x
Routine
X Q3 2015 Q2 2016
Description: This project will deliver additional information security services such as secured voicemail, secured and certified electronic documents, etc. It is a stated but not funded requirement of the VOIP project.
Latest Comment: waiting for infrastucture to complete their portion Comment Entered:
4-18-2016 0835
Design and deploy Microsoft SQL Enterprise Server clustering and DR for EFS, SQL 2005, 2008 and 2012 clusters[Enterprise Infrastructure]
Dean Longhurst
Active
x-x-x
Strategic
Q3 2012 Q3 2016 160
Description: Although most of our billed databases are protected by clustering, they are in an active/passive configuration. This will extend the SQL environment to support remote location DR, business continuity, as well as active/active load balancing the local DB engines.
Latest Comment: No updates until 2/28/2016. Comment Entered:
1-27-2016 1022
Report Generated: 4/29/2016 12:52:55 PM Page 4 of 18
IT Project Listing: AlignmentCounty of SonomaInformation Systems Department
Dollar amounts are italicized for unfunded projects.
Title Contact Person
State
Scope
Time
Money Priority
Comm
unity
Econ/Envir
Future
Services Budget ActualOne Time Cost
Annual Ongoing Cost
Target Start
Target Finish
Hours Estimate
Active (Total Projects: 50) 5 3 16 15 $1,388,488 $518,954 $127,884 $26,458
Enterprise Infrastructure (Total Projects: 13) 0 0 9 0 $20,000
Replace Infoblox appliances [Enterprise Infrastructure] Ben Toyoda
Active
x-x-x
RoutineX Q3 2015 Q3 2016
Description: Infoblox is the current Dynamic IP and DNS address system for the county. The current infoblox appliances are set to expire 12/2015. This project is the replace the current infoblox appliances with new models
Latest Comment: Professional services will be on-site for implementation on 5/17-19 Comment Entered:
3-25-2016 0718
Design and Deploy Distributed Files Services [Enterprise Infrastructure]
Toby Carpenter
Active
x-x-x
Routine
X Q4 2014 Q2 2016
Description: This project is to deploy new Distributed File Services that will be hosted on a highly available system( 3PAR/Windows Server 2012 )
Latest Comment: Stability issues have returned. DCO staff have a meeting scheduled for Monday to discuss options. Comment Entered:
4-15-2016 1149
Cisco Nexus 9k Data Center Upgrade[Enterprise Infrastructure]
Ben Toyoda
Active
x-x-x
Routine
Q1 2016 Q2 2016 320
Description: Replace existing Cisco Nexus 7k, 5k and 2k servers with Cisco 9k switches. This will provide 10/40 Gig capability with an upgrade path to 100 Gig and ACI infrastructure.
Latest Comment: We now have a data center infrastructure based on 40 Gig links with the ability to upgrade to 100Gb when needed. Each pair of server switches have a total of four 40 Gig links to the Nexus 9k core providing an aggregate of 160 Gig for servers and storage. We currently have 10 pair of these switches that provide connectivity specifically for all of the data center servers and storage environment. We also provide dual 10 Gig links for all campus buildings and other services within the data center.
Comment Entered:
4-15-2016 1328
Report Generated: 4/29/2016 12:52:55 PM Page 5 of 18
IT Project Listing: AlignmentCounty of SonomaInformation Systems Department
Dollar amounts are italicized for unfunded projects.
Title Contact Person
State
Scope
Time
Money Priority
Comm
unity
Econ/Envir
Future
Services Budget ActualOne Time Cost
Annual Ongoing Cost
Target Start
Target Finish
Hours Estimate
Active (Total Projects: 50) 5 3 16 15 $1,388,488 $518,954 $127,884 $26,458
Enterprise Infrastructure (Total Projects: 13) 0 0 9 0 $20,000
Migrate secure ftp sites currently on s-wsonftp1.sonoma-county.org to SoCoCloud [Enterprise Infrastructure]
Toby Carpenter
Active
x-x-x
Routine
X Q3 2015 Q2 2016
Description: TechServices currently provides SFTP legacy services using a IPSwitch WSFTP server that’s hosted on s-wsonftp1.sonoma-county.org . Technical Services provides a new SFTP service called SocoCloud.
Latest Comment: PRMD was successfully migrated to SoCoCloud. SCERA is completing testing. Comment Entered:
4-15-2016 1154
Coordinate ESRI GIS System Health Check[Enterprise Infrastructure]
Tim Pudoff
Active
x-x-x
Routine
X $20,000 Q1 2016 Q2 2016 100
Description: Schedule and coordinate a site visit by ESRI engineer to perform a system health check of our Enterprise GIS infrastructure
Latest Comment: Water Agency counsel working on contract language modification; expect their review to be completed by end of this week.
Comment Entered:
4-21-2016 1453
Expunge Windows Server 2003 Servers from the Enterprise [Enterprise Infrastructure]
Sabrina Doss
Active
x-x-x
Routine
X Q3 2014 Q2 2017
Description: This project is to remove all windows server 2003 servers from the enteprise. Servers that can not be removed will listed in a Risk report for escalation to Management
Latest Comment: CampaignDocs migration occured on 4/26 to a 2012 server. Comment Entered:
4-29-2016 1031
BizTalk Upgrade[Enterprise Infrastructure] Susan Sloan
Active
x-x-x
RoutineX Q2 2016 Q4 2016
Report Generated: 4/29/2016 12:52:55 PM Page 6 of 18
IT Project Listing: AlignmentCounty of SonomaInformation Systems Department
Dollar amounts are italicized for unfunded projects.
Title Contact Person
State
Scope
Time
Money Priority
Comm
unity
Econ/Envir
Future
Services Budget ActualOne Time Cost
Annual Ongoing Cost
Target Start
Target Finish
Hours Estimate
Active (Total Projects: 50) 5 3 16 15 $1,388,488 $518,954 $127,884 $26,458
Enterprise Infrastructure (Total Projects: 13) 0 0 9 0 $20,000
Description: In response to the BizTalk Health Check we have upgraded the environment and will begin migration.
Latest Comment: New BizTalk environment has been created. Rik to work with staff at Systems and Programing on migration from old BizTalk environment.
Comment Entered:
4-15-2016 1759
Administrative (Total Projects: 12) 0 1 2 7 $46,874 $65,000 $75,494 $3,735
Develop Talent Management Program[Information Systems]
Dan Fruchey
Active
x-x-x
Routine
Q4 2013 Q3 2016
Description: Periodic inventory of staff skills to determine institutional knowledge, identify training and career development opportunities, and prepare for future retirement wave. Increase cross-training across divisions and teams to avoid single point of failure and expand employee skill set. Re-evaluate staffing model for alignment with County goals;
Latest Comment: Need to await results of HR classification study before proceeding. ISD administration has asked that completion be pushed back to fall in order to await results of the study.
Comment Entered:
4-21-2016 0914
Deploy e-Billing Solution for Delivering Property Tax Statement[Auditor-Controller-Treasurer-Tax Collector]
Tim Pudoff
Active
x-x-x
Routine
X $45,000 Q1 2012 Q2 2016 300
Description: Coordinate with ISD Systems and Programming and ISD Web Team to implement an e-Billing system for Tax Collector
Latest Comment: Staff are busily working on the punch list developed from our 3/23 meeting; items pending: SSRS reporting (to replace PDF output) in progress; new user admin portal (built on ASP.net/MVC) completed, but need to meet with customer to review; finalizing customer language for public-facing page. Will be scheduling project status meeting for next week to identify any remaining issues before scheduling meeting to present to customer.
Comment Entered:
4-21-2016 1509
Report Generated: 4/29/2016 12:52:55 PM Page 7 of 18
IT Project Listing: AlignmentCounty of SonomaInformation Systems Department
Dollar amounts are italicized for unfunded projects.
Title Contact Person
State
Scope
Time
Money Priority
Comm
unity
Econ/Envir
Future
Services Budget ActualOne Time Cost
Annual Ongoing Cost
Target Start
Target Finish
Hours Estimate
Active (Total Projects: 50) 5 3 16 15 $1,388,488 $518,954 $127,884 $26,458
Administrative (Total Projects: 12) 0 1 2 7 $46,874 $65,000 $75,494 $3,735
Implement electronic document management for the Board of Supervisors.[Board of Supervisors]
Jim McKenney
Active
x-x-x
Routine
X $23,094 $23,094 $3,735 Q2 2013 Q2 2016
Description: Implement electronic document mangement within the Board of Supervisors. Reduce paper file storage through automated document scanning. Improve document access of converted microfilmed records using OnBase client tools.
Latest Comment: Clearn up of the 1200+ documents with multiple minutes is complete. Will be updating documentation and discuss some minor adjustments with Roxanne.
Comment Entered:
4-29-2016 0652
Implement Electronic Document Management System for Local Agency Formation Commission (LAFCO)[LAFCO]
Jim McKenney
Active
x-x-x
Routine
X Q3 2014 Q2 2016
Description: Improve access to Commission documents for both public and county departments.
Latest Comment: Moving completion date out due to Cindy's departure for 3 weeks. Comment Entered:
4-25-2016 0736
CMS - EDB/Primary[Economic Development Board]
Dan Fruchey
Active
x-x-x
Routine
X $23,780 Q1 2015 Q2 2016
Description: Transition EDB from legacy web site to CMS
Latest Comment: Work proceeding with client, approximately 20% completed. Met with client Tuesday to refine design specs. Travis Balzarini assigned as lead for the project.
Comment Entered:
4-21-2016 0919
EFS Project Accounting, AR, Billing[Information Systems]
Alicia Cenceroz
Active
x-x-x
Routine
X Q3 2014 Q3 2016
Report Generated: 4/29/2016 12:52:55 PM Page 8 of 18
IT Project Listing: AlignmentCounty of SonomaInformation Systems Department
Dollar amounts are italicized for unfunded projects.
Title Contact Person
State
Scope
Time
Money Priority
Comm
unity
Econ/Envir
Future
Services Budget ActualOne Time Cost
Annual Ongoing Cost
Target Start
Target Finish
Hours Estimate
Active (Total Projects: 50) 5 3 16 15 $1,388,488 $518,954 $127,884 $26,458
Administrative (Total Projects: 12) 0 1 2 7 $46,874 $65,000 $75,494 $3,735
Description: Phase II of PeopleSoft to move project accounting to PeopleSoft from MS Dynamics
Latest Comment: Procedure documents updated during Sept billing. No new reconciliation updates. On Oct. 3, report specifications finalized with EFS staff. Reports have been assigned to programming staff to be written for the EFS Reporting Services including prompts to filter. Reports include 1. Project List 2. Project Detail 3. Project Budget by Actual by Activity 4. Capital Project (#4 on hold). Will continue to run in parallel until reports are in production.
Comment Entered:
11-18-2015 0918
Litigation Hold Exchange 2010[County Counsel] Susan Sloan
Active
x-x-x
RoutineX $65,000 Q1 2015 Q2 2016
Description: Establish Commvault facilities necessary to support Litigation Hold services. Design supporting business process and work flow. Design, configure, and deploy Commvault supporting process and work design.
Latest Comment: Installation of Dell Storage is a contingency of this project. Dell Storage chassis is racked in the Data Center and Dell professional services will be onsite April 20th to cable up device and install drives. Dell professional services is scheduled for April 26th for the configuration.
Comment Entered:
4-15-2016 1110
Create Community Engagement Software Application RFP[County Administrator's Office]
Sabrina Doss
Active
x-x-x
Routine
X Q1 2016 Q4 2016
Description: Create an RFP for a Community Engagement tool that will support the objectives of the Community Engagement Plan developed by the County Administrator's Office
Report Generated: 4/29/2016 12:52:55 PM Page 9 of 18
IT Project Listing: AlignmentCounty of SonomaInformation Systems Department
Dollar amounts are italicized for unfunded projects.
Title Contact Person
State
Scope
Time
Money Priority
Comm
unity
Econ/Envir
Future
Services Budget ActualOne Time Cost
Annual Ongoing Cost
Target Start
Target Finish
Hours Estimate
Active (Total Projects: 50) 5 3 16 15 $1,388,488 $518,954 $127,884 $26,458
Administrative (Total Projects: 12) 0 1 2 7 $46,874 $65,000 $75,494 $3,735
Latest Comment: A draft RFP is in progress to locate potentially 6 or more tools to fulfill needs in the following areas: 1) Streaming Media and Archival Solution, 2) Closed Captioning, 3) Agenda Management System, 4) Boards and Commissions System, 5) Civic Engagement System, and 6) Constituent Relationship Management system. In process of incorporating all comments received to date on requirements/features for first five systems. Developing specifications for the CRM system to add to the RFP. Current contract with vendor for streaming media/closed captioning services expires in mid-Oct. It may be necessary to extend for one additional year while we evaluate responses to the RFP and prepare the contract(s) for services.
Comment Entered:
4-29-2016 1003
Migrate Dynamics Cost accounting database to SQL Server 2012 R2 [Information Systems]
Sabrina Doss
Active
x-x-x
Routine
Q3 2015 Q2 2016
Description: Records Retention suggest the cost data be kept for 5 years. Since it is currently on SQL Server 2005 it should be moved to a current server. Several Excel worksheets then need the data source changed to point to his new server.
Latest Comment: S&P has delivered reports to ISD. Alicia and team are currently validating. Comment Entered:
4-29-2016 1017
Transition Property Team Portfolio from Information Management to Systems and Programming Division[Information Systems]
Tim Pudoff
Active
x-x-x
Routine
X $7,400 Q1 2016 Q2 2016 50
Description: Develop plan and documentation to help S&P assume responsibility for managing property system-related tasks and services.
Latest Comment: Continuing to support ISD S&P with transition. Comment Entered:
4-21-2016 1453
Upgrade Team Foundation Server to 2015 Version [Information Systems]
Brian Tietzealy
Active
x-x-x
Routine
X Q1 2016 Q2 2016
Report Generated: 4/29/2016 12:52:55 PM Page 10 of 18
IT Project Listing: AlignmentCounty of SonomaInformation Systems Department
Dollar amounts are italicized for unfunded projects.
Title Contact Person
State
Scope
Time
Money Priority
Comm
unity
Econ/Envir
Future
Services Budget ActualOne Time Cost
Annual Ongoing Cost
Target Start
Target Finish
Hours Estimate
Active (Total Projects: 50) 5 3 16 15 $1,388,488 $518,954 $127,884 $26,458
Administrative (Total Projects: 12) 0 1 2 7 $46,874 $65,000 $75,494 $3,735
Description: Upgrade Team Foundation Server (TFS) from 2013 to new 2015 version
Latest Comment: There are several other high priority projects that have due dates coming up very soon. (ie: eTax Billing, EFS billing recovery fix, SB272) so work on this migration has taken a back seat.
Comment Entered:
4-22-2016 1130
Deploy SoCo Budget to Open Data Portal[County Administrator's Office]
Sabrina Doss
Active
x-x-x
Routine
X Q4 2014 Q2 2016
Description: Release the SoCo Budget app to SoCo Data. SoCo Budget will contain FY 15/16 Adopted and FY 16/17 Recommended Budget.
Latest Comment: CAO would like to show SoCo Budget tool on5/10/16 Quarter 3 Budget Update. Public launch is expected to occur by June 2, 2016, when the 10-day public review period begins of the 2016-2017 budget book prior to its adoption by the Board.
Comment Entered:
4-29-2016 1025
Public Safety, Law & Justice (Total Projects: 7) 3 0 0 1 $925,840 $453,954 $11,850
Integrate new Court system (Tyler) with IJS [Superior Court]
Cassandra Bridges
Active
x-x-x
Routine
X $900,000 $453,954 Q2 2015 Q1 2017
Description: The Court is moving to Tyler system and IJS must integrate with Tyler to continue to provide data as it does today.
Latest Comment: Initial developer testing between IJS and the Courts is in progress. As expected, bugs and mapping changes are being identified.
Comment Entered:
10-27-2015 1419
Modify Sheriff Labor Accounting System with PeopleSoft financial codes[Sheriff's Office]
Sherry Bevens
Active
x-x-x
Routine
Q3 2014 Q2 2016
Description: Modify Sheriff Labor Accounting System to utilize the new DeptID and Account codes from the new fininancial system. Additionally, users no longer utilize all the reports in the Access tool and we will recreate the four reports used utilizing SSRS.
Report Generated: 4/29/2016 12:52:55 PM Page 11 of 18
IT Project Listing: AlignmentCounty of SonomaInformation Systems Department
Dollar amounts are italicized for unfunded projects.
Title Contact Person
State
Scope
Time
Money Priority
Comm
unity
Econ/Envir
Future
Services Budget ActualOne Time Cost
Annual Ongoing Cost
Target Start
Target Finish
Hours Estimate
Active (Total Projects: 50) 5 3 16 15 $1,388,488 $518,954 $127,884 $26,458
Public Safety, Law & Justice (Total Projects: 7) 3 0 0 1 $925,840 $453,954 $11,850
Latest Comment: 4 of 5 reports have been successfully developed and finalized. One report is 95% complete. There are data discrepancies within the data which we are working with Payroll to sort out. Open Enrollment, however, is taking priority with Payroll team.
Comment Entered:
4-15-2016 1107
Implement Electronic Document Management for Fire & Emergency Services[Fire and Emergency Services]
Jim McKenney
Active
x-x-x
Routine
X $11,850 Q2 2015 Q2 2016
Description: Scanning of the Certified Unified Program Agency (CUPA) files - Hazardous materials.
Latest Comment: UST files will be input by Ed Reed (ISD) who scanned the paper files. Comment Entered:
4-26-2016 0658
Implement Sheriff CFMG Electronic Medical Records network connectivity [Sheriff's Office]
Susan Sloan
Active
x-x-x
Mandated
X Q3 2015 Q3 2016
Description: As part of the BOS approved Inmate Medical Contract with CFMG there is a requirement to deploy an Electronic Medical Records (EMR) system. This project is to provide wireless connectivity for key areas.
Latest Comment: Data Dimension has completed the wiring for phase one of this project. Infrastructure working with customer finalizing phase one and looking into next steps.
Comment Entered:
3-25-2016 0719
Create GIS Web Editing Application for Fire and Emergency Services to track facilities and logistical needs during a natural disaster[Fire and Emergency Services]
Tim Pudoff
Active
x-x-x
Routine
X $11,840 Q3 2015 Q2 2016 80
Description: Create web-based GIS application for emergency coordinator to edit volunteer assitance centers, pick up points, debris sites, commodity points of distribution, commodity logistic staging area and medical facilities in preparation for natural disaster.
Report Generated: 4/29/2016 12:52:55 PM Page 12 of 18
IT Project Listing: AlignmentCounty of SonomaInformation Systems Department
Dollar amounts are italicized for unfunded projects.
Title Contact Person
State
Scope
Time
Money Priority
Comm
unity
Econ/Envir
Future
Services Budget ActualOne Time Cost
Annual Ongoing Cost
Target Start
Target Finish
Hours Estimate
Active (Total Projects: 50) 5 3 16 15 $1,388,488 $518,954 $127,884 $26,458
Public Safety, Law & Justice (Total Projects: 7) 3 0 0 1 $925,840 $453,954 $11,850
Latest Comment: GIS functionality completed. working with web team to launch a beta site within Fire/EM CMS site; short term solution - embedded small format map, with link to full screen window application; long-term solution - web team to create new CMS template for map with attribute table beneath the embedded map; this will require additional work after initial release of the public viewer. Web team to provide estimate for second phase after June 1. Will update status again when beta public viewer is released.
Comment Entered:
4-21-2016 1441
IJS support for Community Correction Partnership (AB109-Realignment)[Probation]
Steve Stoural
Active
x-x-x
Routine
$14,000 Q3 2015 Q2 2016
Description: Provide mechanism for tracking and reporting on AB109 population.
Latest Comment: Beginning work on creating metrics to define recidivism for realignment population. Comment Entered:
3-03-2016 1200
IJS Development of Reasonable Candidate Tracking[Probation]
Steve Stoural
Active
x-x-x
Routine
Q1 2015 Q2 2016 120
Description: Provide a time tracking system for probation officers to meet compliance for reimbursement of providing juvenile services.
Latest Comment: Project has been transferred from contractor to Justice Team staff and actively worked on. Comment Entered:
4-22-2016 1134
Report Generated: 4/29/2016 12:52:55 PM Page 13 of 18
IT Project Listing: AlignmentCounty of SonomaInformation Systems Department
Dollar amounts are italicized for unfunded projects.
Title Contact Person
State
Scope
Time
Money Priority
Comm
unity
Econ/Envir
Future
Services Budget ActualOne Time Cost
Annual Ongoing Cost
Target Start
Target Finish
Hours Estimate
Active (Total Projects: 50) 5 3 16 15 $1,388,488 $518,954 $127,884 $26,458
Health & Human (Total Projects: 5) 2 0 0 3 $14,935
Implement Electronic Document Managment Workflow for eight programs within the Department of Health Services Environemental Health Section.[Health Services]
Jim McKenney
Active
x-x-x
Routine
X Q1 2014 Q2 2016
Description: Improve customer service delivery by automating the intake and capture of field inspections related to Environmental Health Services.
Latest Comment: Project meeting with Christine Sosko and Lesyle Choate regarding the specific requirements for the External Access Client. Ron Hofhenke from Neko was able to articulate the data flow, which matched their expectations. Next meeting to see what it will look like in test.
Comment Entered:
4-25-2016 0654
CMS - DHS/First 5 CMS Site[Health Services] Linda Franzman
Active
x-x-x
RoutineX $14,935 Q4 2014 Q2 2016
Description: Migrate DHS/First 5 program web site to CMS. Create additional features and enable suers to support it.
Latest Comment: Site scheduled to go live on Monday, May 2nd. Comment Entered:
4-28-2016 0935
Provide Wireless Infrastructure for Community Development Roseland Village[Community Development Commission]
Susan Sloan
Active
x-x-x
Routine
X Q4 2015 Q2 2016 60
Description: To provide wireless internet access for Community Development Roseland Village Location
Report Generated: 4/29/2016 12:52:55 PM Page 14 of 18
IT Project Listing: AlignmentCounty of SonomaInformation Systems Department
Dollar amounts are italicized for unfunded projects.
Title Contact Person
State
Scope
Time
Money Priority
Comm
unity
Econ/Envir
Future
Services Budget ActualOne Time Cost
Annual Ongoing Cost
Target Start
Target Finish
Hours Estimate
Active (Total Projects: 50) 5 3 16 15 $1,388,488 $518,954 $127,884 $26,458
Health & Human (Total Projects: 5) 2 0 0 3 $14,935
Latest Comment: Team will address this once the DataCenter upgrade to the Nexus 9K's is complete. Comment Entered:
3-25-2016 0736
Governance Risk and Compliance: Implement Health Services encryption for TeleHealth [Health Services]
Toby Carpenter
Active
x-x-x
Routine
X Q1 2016 Q2 2016 10
Description: This project to provide a encrypted drive partition for the Department of Health Services(DHS). The secure drive partition would host data to be scanned
Latest Comment: requesting updated from DCO Comment Entered:
2-25-2016 1614
Implement Electronic Document Management System for Department of Health Services - Vital Statistics[Health Services]
Jim McKenney
Active
x-x-x
Routine
X Q1 2016 Q2 2016
Description:
Latest Comment: Project meeting with the entire vital stats staff. Had to bring new folks up to speed, and articulated the project steps. Next meeting will be to develop use cases for their testing. OnBase Test v14 has been placed on their PCs.
Comment Entered:
4-27-2016 0659
Land (Total Projects: 7) 0 2 1 3 $274,039 $8,940 $22,723
Coordinate Enterprise GIS Participation in Sonoma County Vegetation Mapping and LiDAR Program[Open Space District]
Tim Pudoff
Active
x-x-x
Routine
X $23,040 Q3 2013 Q2 2017 160
Report Generated: 4/29/2016 12:52:55 PM Page 15 of 18
IT Project Listing: AlignmentCounty of SonomaInformation Systems Department
Dollar amounts are italicized for unfunded projects.
Title Contact Person
State
Scope
Time
Money Priority
Comm
unity
Econ/Envir
Future
Services Budget ActualOne Time Cost
Annual Ongoing Cost
Target Start
Target Finish
Hours Estimate
Active (Total Projects: 50) 5 3 16 15 $1,388,488 $518,954 $127,884 $26,458
Land (Total Projects: 7) 0 2 1 3 $274,039 $8,940 $22,723
Description: Coordinate with data partners to specify requirements, form a consortium to fund and acquire high resolution LiDAR data for topographic and vegetation mapping, to support Enterprise use of high quality environmental data for this and other County programs and initiatives.
Latest Comment: Planning follow-up GIS strategic planning meeting with SCAPOSD management next weeik. Comment Entered:
4-21-2016 1454
Implement Electronic Document Management System for Transportation and Public Works[Transportation & Public Works]
Jim McKenney
Active
x-x-x
Routine
X $107,319 Q1 2014 Q2 2016
Description: Reduce paper file storage, improve document access and integrate with line-of-business applications.
Latest Comment: Project meeting to discuss adjusting the file plan to accomodate remaining document sets within the Y-Drive document type, which is about 13,000.
Comment Entered:
4-26-2016 0653
Implement Electronic Document Management for Permit and Resource Management Department.[Permit & Resource Management]
Jim McKenney
Active
x-x-x
Routine
X Q1 2016 Q4 2016
Description: Integration with Accela Automation and enable public access to historic documents stored on micrfiche.
Latest Comment: Project meeting with Tom (Cirimele), Connie Brown and Ron Hofhenke. Review of the draft file plan. Focus on backing the plan into Accela. Tom would like some guidence on setting up the document groupings in Accela. Ron to provide input.
Comment Entered:
4-19-2016 0739
Report Generated: 4/29/2016 12:52:55 PM Page 16 of 18
IT Project Listing: AlignmentCounty of SonomaInformation Systems Department
Dollar amounts are italicized for unfunded projects.
Title Contact Person
State
Scope
Time
Money Priority
Comm
unity
Econ/Envir
Future
Services Budget ActualOne Time Cost
Annual Ongoing Cost
Target Start
Target Finish
Hours Estimate
Active (Total Projects: 50) 5 3 16 15 $1,388,488 $518,954 $127,884 $26,458
Land (Total Projects: 7) 0 2 1 3 $274,039 $8,940 $22,723
Migrate University of California Cooperative Extension Stream Property Access Database to SQL Cluster[UC Cooperative Extension]
Tim Pudoff
Active
x-x-x
Routine
X $3,271 Q3 2015 Q2 2016
Description: Develop requirements for migrating UCCE Access tables to SQL cluster to enable multi-user editing and integration with GIS
Latest Comment: ISD working out the billing mechanism with customer; ISD DOC will begin working with customer as soon as this is completed.
Comment Entered:
4-21-2016 1451
Create Regional Parks boundary data and trail data for use in OpenTrail GIS data program[Regional Parks]
Tim Pudoff
Active
x-x-x
Routine
X $0 $8,940 $0 Q2 2015 Q2 2016 60
Description: Create GIS data layers for Regional Parks that can be made available to the public through OpenData venue. Data maintained in the Enterprise GIS and a process has been set up to publish the trail data in JSON format for access by the public.
Latest Comment: Customer provided data back to ISD-GIS staff; reviewing data to identify changes to trail system that may be incorporated into County streets layer; will set up a field in attribute table to flag trail data to enable it to be selected out quickly for export to JSON.
Comment Entered:
4-21-2016 1440
PRMD Permitting System(Accela Automation) Server hosting infrastucture [Permit & Resource Management]
Susan Sloan
Active
x-x-x
Routine
$140,409 $22,723 Q3 2014 Q2 2016 272
Description: This project is to host the new version of the PRMD permitting system(Accela) on virtual infrastucture and a sql 2008 r2 cluster
Report Generated: 4/29/2016 12:52:55 PM Page 17 of 18
IT Project Listing: AlignmentCounty of SonomaInformation Systems Department
Dollar amounts are italicized for unfunded projects.
Title Contact Person
State
Scope
Time
Money Priority
Comm
unity
Econ/Envir
Future
Services Budget ActualOne Time Cost
Annual Ongoing Cost
Target Start
Target Finish
Hours Estimate
Active (Total Projects: 50) 5 3 16 15 $1,388,488 $518,954 $127,884 $26,458
Land (Total Projects: 7) 0 2 1 3 $274,039 $8,940 $22,723
Latest Comment: Technical Services met with the customer to discuss action plans moving forward. Customer will be setting up a meeting with vendor and Technical Services so we can compare notes. The latest discovery was a runaway Java process that was pegging the CPU. Vendor is looking into this issue.
Comment Entered:
3-25-2016 0714
AirQuality server modernization[Transportation & Public Works]
Susan Sloan
Active
x-x-x
Routine
X Q2 2015 Q2 2016
Description: This project is to provision three virtual Windows Server 2012r2 servers that will host the following services:1. Air Vision application.2. S: drive and U: drive.3. Burn Permit Database.
Latest Comment: Customer would like some modifications to the Project Charter. I will review with him as soon as possible.
Comment Entered:
2-18-2016 1355
Report Generated: 4/29/2016 12:52:55 PM Page 18 of 18
IT Project Listing: AlignmentCounty of SonomaInformation Systems Department
Dollar amounts are italicized for unfunded projects.