Information Technology (IT) Investment Fund Portfolio

Recognizing the increasingly critical role that Information Technology (IT) plays in the delivery of services to citizens, public and private organizations, and State employees, the Legislature has appropriated $40 million in fiscal year 2019 targeted for IT investment. The following provides a summary report of the projects in the IT Investment Fund portfolio. These projects include participation of not only DTMB-IT but also other State agencies. Some projects will be completed this fiscal year; others span several years. Some projects are funded solely by the IT Investment Fund; others involve funding from other sources. In our continuing effort to provide transparency to government activity and spending, the summary report allows viewers to "drill down" to more detailed project information by clicking on the project name. This information is updated on a bi-monthly basis.


Client Status Project Name Planned
CIP - Cybersecurity & Infrastructure Protection
CIP - Cybersecurity Framework Phase 3
Enhancement of SOM IT Governance, Risk Assessment & Compliance (GRC) standards and to improve the System Security Plan (SSP) and Risk Assessment (RA) processes within the SOM Cyber Security Framework. Further enhancements of the LockPath (Keylight) tool to provide an improved user experience. Expand overall GRC capabilities through integration with other processes and forms such as Data Classification and others.
10/15/2018 Jose Semidei Kemal Tekinel Smruti Shah
CIP - Cybersecurity & Infrastructure Protection
CIP - Cybersecurity Framework Phase 4
Continue Enhancement of SOM IT Governance, Risk Assessment & Compliance (GRC) standards and to improve the System Security Plan (SSP) and Security Accreditation processes within the SOM Cyber Security Framework. SOM security policies need to be updated to match the updated Framework. Further enhancements of the LockPath (Keylight) tool to provide an improved user experience. Expand overall GRC capabilities through integration with other processes, vendor management and forms.
7/30/2019 Jose Semidei Kemal Tekinel Smruti Shah
CIP - Cybersecurity & Infrastructure Protection
CIP - Data Loss Prevention
The Data Loss Prevention project will refine and improve existing data protection processes in several areas including policy, process and technology by implementing a Data Loss Prevention (DLP) product from Symantec. Objectives include: Improving risk management by identifying the sensitive State of Michigan data in the computing environment; mitigating risk by assessing, and as appropriate preventing, sensitive data from improperly leaving the State of Michigan computing environment; increasing data usage compliance by implementing the appropriate data usage Policies and Standards across the enterprise; mitigating risk by altering user behavior when accessing, transmitting and storing sensitive data through policy as well as technology; implementing Data Usage Governance by using efficient and effective processes; enabled by policy, technology and reporting.
12/21/2018 Rajeev Ranjan Richard Reasner Chris DeRusha
DEQ - Department of Environmental Quality
DEQ - Remediation Information Data Exchange (RIDE) In House Development
The Department of Environmental Quality (DEQ) is responsible for protecting the environment from contamination. The purpose of this project is to develop a solution to replace functionality currently available in two legacy systems which assists DEQ in the monitoring and cleanup of environmental contamination sites.
5/6/2022 Laura Birchmeier Dan Sellepack Kathy Shirey
DEQ - Office of Drinking Water and Municipal Assistance
DEQ - DWMAD IT Modernization Project
Phase 1 of the DWMAD IT Modernization Project will be the RFP phase. Phase 1 will determine the best solution for the modernization efforts.
6/30/2019 Kyle Field Manny Rosales Jennifer Merricle
DOS - Department of State
MDOS - QVF Refresh
The Qualified Voter File (QVF) system is a critical and public facing service that the MDOS Bureau of Elections provides to 83 County clerks and close to 1,000 local officials to continually track and update voter registration files for over 7 million voters and to support/administer all elections within the State of Michigan. The original QVF system was first developed and deployed in the late 1990s.  The objective of this project is to refresh the current architecture and software platform (Delphi) to a supported DTMB application standard and update the user interface. It is also to make sure that the current vendor support is a sustainable model for QVF system with its suite of applications such as QVF, QVF-GUI, QVF-Lite, E-Wizard, Street Index and Electronic Poll Book along with hardware and database components.
12/31/2019 Mike Kelley Nathan Buckwalter Sally Williams
DTMB-M-OFS - Office of Financial Services
Michigan Security Accreditation Process (formerly MiCWRAP) - Parent Program
The purpose of the Security Accreditation Process (SAP) Program is to give organized governance, accountability, coordination and oversight of SAP-related initiatives and projects across the Enterprise and be a single point of reference for all SAP-related work. The SAP program seeks to implement a Security Accreditation Process (SAP), a product of which is the System Security Plans (SSPs) captured and documented in the State of Michigan (SOM) Governance, Risk Management and Compliance (GRC) tool and to close legacy SAP related material weaknesses throughout the SOM information technology environment. 
9/30/2020 Shannon Priest Cindy Peruchietti Chris DeRusha
DTMB-M-SFA - State Facilities Administration
DTMB - SFA - Facilities Real Estate Management (FREM)
The State of Michigan (SOM), through the State Facilities Administration (SFA) on behalf of the Michigan Department of Technology Management & Budget (DTMB) purchased the Global Design Infor Enterprise Asset Management (EAM) solution.  This project partners with the vendor Infor to implement the facilities EAM solution at DTMB.  This project is being done incrementally by two phases.  The first phase is intended to focus on the needs analysis which entails a global design for   three agencies, Michigan Department of Transportation (MDOT), Department of Natural Resources (DNR) and SFA.   The second phase is implementation of the EAM solution at SFA based on the results of the first phase.
8/15/2019 Sohaib Rashad Andrew Mason Mike Turnquist
DTMB-SBO - State Budget Office
SBO - Project SIGMA
This project is the State of Michigan's Enterprise Resource Planning (ERP) business process and software implementation, a major initiative focused on replacing Michigan's enterprise-wide financial systems. It involves the replacement of the Michigan Administrative Information Network Financial Administration and Control System (MAIN FACS), Data Collection Distribution System (DCDS), Mi Time and Expense (MiTES), Buy4Michigan, iTRAC and other Agency specific systems, improvements to the Business Objects system and the implementation of a technology enabled budget development solution. MAIN was implemented in 1994 and is considered an outdated system overdue for replacement. SIGMA will replace it with a modern, highly efficient, user friendly, and more effective system. SIGMA will bring significant improvements to a vast number of processes currently in use in virtually every aspect and segment of Michigan government.  These improvements will greatly enhance:

• Budget Preparation at all levels of State government

• The manner in which many State of Michigan employees perform specific job duties

• Financial reporting resources and capabilities

• The transparency of Michigan government financial operations due to improved reporting

• The process of interfacing with other systems that cannot be incorporated into SIGMA

The benefits realized with SIGMA will be many.  The State's budgeting, accounting and reporting processes will be based on current technology and capabilities, with upgrades available as needed for the foreseeable future.
4/30/2019 Jill Redinger Jack Harris Michael Moody
e-MI - e-Michigan
Michigan.GOV Web Content Management System (WCMS) Requirements
Develop requirements for the replacement for Vignette,  the web content management system (WCMS) that supports the portal.  The current CMS support has been sunset. 
12/21/2018 Scott Reynolds Eric Swanson Suzanne Pauley
EPMO - Enterprise Portfolio Management Office
EPMO - Enterprise CA PPM Implementation
The EPMO Clarity Implementation project will replace Changepoint as the State of Michigan's (SOM) project and portfolio management tool.  The project includes configuration of Clarity to meet SOM enterprise requirements, migration of required data from Changepoint to Clarity, replacement of reports and reporting dashboards, integrations to key external systems, and role-based training for licensed Clarity users. 
6/21/2019 Mary Fox Nathan Buckwalter Rob Surber
IS - Infrastructure Services
IS-Enterprise Cloud Strategy Implementation
The State of Michigan has been pursuing a public-private partnership initiative—Through its office of the State of Michigan Chief Information Officer has set the goal of having 85% of all state systems in a cloud based environment. This goal will enable the State of Michigan’s IT groups to meet agency needs and requirements quickly with more flexible and reliable solutions which will enhance the citizen’s interactions. With our new hybrid Cloud (Public and Private) and our Next Generation Digital Infrastructure (NGDI), our cloud transformation through provisioning and automation will allow agency services to become more resilient, manageable, scalable and nimble with faster turnaround and demonstrated cost effectiveness
1/31/2020 Chris Zurowick Jack Harris Paul Groll
LARA - Michigan Occupational Safety & Health Administration (MIOSHA)
LARA - MIOSHA - Radiation Safety Data Tracking System
The MIOSHA – Radiation Safety Data System (RSDS) will be combining 4 separate functioning but outdated processes into one web based system using the newest technologies.  The new system will provide following functionality: Workflow, Facility Registration, Facility and Machine Maintenance, Plan Review, Inspections, Online/Offline Payment, Interfaces with C3 Cepas and Sigma, and Legacy Data Conversion and migration.
2/28/2019 Jana Rolston Stu Willard Barton Pickelman
MDARD - Michigan Dept of Agriculture Rural Development
MDARD - Agencywide Licensing and Inspection System Program
 The objective of the program is to build a state of the art consolidated licensing & inspection system to handle 40 different types of licensing and 80,000 inspections annually conducted by the Michigan Department of Agriculture and Rural Development (MDARD). A key feature of this effort is also to provide online self-service capabilities to the citizens of Michigan for their Licensing needs.
6/30/2021 Richard(Rick) Stankiewicz Manny Rosales George Noonan
MDARD - Michigan Dept of Agriculture Rural Development
MDARD - Flint Food Market Card Reader Technology
As a critical part (and initial step) of expanding Double Up Food Bucks in Flint, Epic Technology Solutions (Contractor) will work with Fair Food Network to enhance and expand transaction technology to benefit consumers who are using the Double Up Food Bucks program in Flint. The technology will maximize the potential to increase program participation by allowing the incentive program to operate among locations within the consumers’ community. For the SNAP consumer, this means that Double Up credits can be easily earned and spent at any participating site in the same manner by using a recognizable, program-branded loyalty card. In addition to the increased benefit to consumers, this technology enhancement will provide real-time reporting functionality, which supports program integrity, monitoring, and impact evaluation.
1/31/2019 Gideon Francis Manny Rosales Thomas Benner
MDCR - Civil Rights
MDCR - Civil Rights Information System (CRIS)
This modernization project will replace Michigan Department of Civil Rights' circa-1998 legacy system as well as outdated databases and spread-sheet applications. The new agency-wide system will include case tracking and management and document management supporting the Department’s goal of moving toward a paperless office.
5/31/2019 Timothy Palmer Tiziana Galeazzi Mary Engelman
MDHHS - Behavioral Health and Developmental Disabilities Administration
MDHHS - Electronic Medical Business Record System (EMBRS) Billing and Patient Accounts Modules
The Michigan Department of Community Health operates five state hospitals with the capacity to care for almost 1,000 patients. The EMBRS project was initiated to upgrade the technology at these five hospitals and automate the medical records of patients. Using EMBRS, patient information can be accessed electronically, and it includes demographics, legal status, hospital center, health history, health care provided, court information and billing activities.  The purpose of this project is to implement the patient billings and accounts modules of EMBRS.
3/8/2019 Trevor Sweet Kimberly Koppsch-Woods Cynthia Kelly
MDOC - Department of Corrections
MDOC - Corrections Offender Management System (COMS) Project
The Michigan Department of Corrections (MDOC) seeks to replace and/or modernize multiple aging legacy information automation systems. The desired result would be one modern commercial off the shelf/SaaS system that is modular in design and includes at least all current case management functionality in MDOC’s current legacy systems. This migration and modernization project would include standardization and automation of its statewide correctional business processes related to all MDOC institutions and community supervision.
11/30/2022 Darren Elliott James Rice Heidi Washington
TREA - DWT Department Wide Technology
TREA - E (DWT-169) SAP Fix and Finish
The SAP Fix & Finish Program is comprised of 7 different candidates/projects.  They are:

DWT-142 SAP Maintenance Upgrade $486,780

DWT-144 SAP Annual DR $59,800

TP-414 Shutdown Business Taxes $300,000

TP 426 CIT/MBT/SUW/MTO/MMF FY19 $892,208

DWT-154 Automate W2 data to warehouse $407,645

DWT-151 Reconcile IRS Audit Loads $326,237

Oracle Servers $500,000
3/31/2021 Dan Zemaitis Cassandra Huguelet Matt Clark
TREA - DWT Department Wide Technology
TREA M - E (DWT-080) SAP Automated Test Tools
The Treasury Automation project is a groundbreaking project for SAP Test Automation in the State of Michigan.  The capability and technology will enable the Treasury agency and DTMB to perform more and faster software testing in addition to removing thousands of hours of manual execution.
1/15/2019 Heather Amos Lucy Pline Melissa Hatfield
TREA - TP Tax Processing Bureau
TREA - E (TP-383) Business Tax Medical Marihuana
The TP-383 Business Tax Medical Marihuana project is to implement an automated process for collecting the Medical Marihuana Facilities (MMF) Excise Tax (3% excise tax on gross sales receipts) from provisioning centers in the State of MI using the existing Michigan Treasury Online (MTO) portal as the front end and SAP as the backend system.

The new MMF functionality will allow medical Marihuana facilities tax payers the ability to log in to MTO and submit their return and payment for the 3% excise tax.  This functionality will allow Treasury the ability to provide information to other state agencies monitoring the payment of the excise tax for delinquency.

Additionally, this project will contribute to the following Treasury objectives:

1. Mandate MTO for MMFs to file and pay their quarterly 3% excise tax

2. Increase the number of businesses registered for MTO

3. Increase the percentage of online filers

4. Increase positive responses to the MTO user surveys

5. Increase Treasury processing efficiencies
9/28/2018 Raja Ramaswamy Lucy Pline Amy Garcia
WDA - Workforce Development Agency
TED - TIA - WD - State Approving Agency
The existing Michigan State Approving Agency’s (MSAA) Database is at risk of a serious data breach of Personally Identifiable Information (PII) of veterans and educational institutions, becoming defunct if the State of Michigan updates to incompatible version of Microsoft Access, or the Colorado SAA ceases to support or provide updates to the current database.  Therefore, this project is to design a new secure web-based system to duplicate the current functionality of the ‘at risk’ MS Access database. A redesign will also comply with PII security requirements, meet DTMB standards, and share relative information to other government agencies.
10/15/2019 Jean Gordon Nancy Palmateer Allen Nash
WDA - Workforce Development Agency
TED - TIA - WDA - WARN Database Replacement
Migrate the current database from Access to SQL, Create an HTML front end and Connect to OSMIS to use employer codes for WARN (Worker Adjustment and Retraining Notifications).  The scope is to include TAA (Trade Adjustment Act) petitions and rapid response from the Dept of Labor to automate and integrate Unemployment and Michigan Works agency in effort to better assist dislocated Michigan workers.
12/31/2019 Jeff Powell Nancy Palmateer Brian Marcotte