Michigan Legacy Application Modernization Planning (MiLAMP)

DTMB created the Michigan Legacy Application Modernization Planning (MiLAMP) which is a toolset that provides a standardized, repeatable process for Legacy Application Modernization Lifecycle management. This process provides a comprehensive framework which gathers and analyzes legacy data to create a legacy modernization replacement roadmap. Legacy is defined as applications, systems, technologies, and solution/security architectures that are using sunset, frozen, unsupported, or deprecated technologies and architectures as defined by DTMB Policies and Standards and the EA Technology Roadmap. Legacy project prioritization, selection and replacement occur through ongoing strategic discussions between DTMB and the client agencies. The overall goal of legacy modernization is to improve technology to better serve State of Michigan departments, citizens, local units of government and all project stakeholders in a cost effective manner.

 

Michigan Legacy Application Modernization Planning Current Fiscal Year Project Sta Michigan Legacy Application Modernization Planning Target Completion per Fiscal Ye Michigan Legacy Application Modernization Planning Current Fiscal Year Project Sta

 

 

Client Status Project Name Planned
Finish Date
Project
Manager
DTMB
Sponsor
Agency
Sponsor
AG - Attorney General
AG - SIGMA
Manage all tasks and changes associated with implementation of SIGMA for the Attorney General.
11/17/2017 Jack Keck Carmen Redwine James Selleck
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.
4/13/2018 Rajeev Ranjan Richard Reasner Rajiv Das
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.
10/29/2021 Laura Birchmeier Dan Sellepack Kathy Shirey
DEQ - Department of Environmental Quality
DEQ - SIGMA (MAIN Replacement) Interface Updates
The State of Michigan is currently implementing project SIGMA, which involves the replacement and technological upgrade of the state’s current financial system called MAIN.   This project involves the update of the existing MAIN interfaces for DEQ applications, so they will function with the new SIGMA system.    As a result, DEQ’s accounting and reporting capabilities should be improved.
12/31/2018 Richard(Rick) Stankiewicz Dan Sellepack Paul McDonald
DEQ - Office of Oil, Gas and Minerals
DEQ - (MiRBDMS) Michigan RBDMS Implementation - Phase I
DEQ annually issues around 200 permits for oil and gas wells.  DEQ is responsible for monitoring the environmental impact of well drilling operations, brine disposal wells, oil and gas production facilities, and gas storage wells. Michigan’s Risk Based Data Management System (MiRBDMS) will enhance DEQ’s monitoring capabilities, expedite the issuing of permits and comply with current technological standards. 

  

Note:  The Total Planned Hours relate to the DTMB activities.  The vendor effort is covered in a fixed price contract.
12/29/2017 Richard(Rick) Stankiewicz Dan Sellepack Hal Fitch
DNR - Department of Natural Resources
DNR - Land Ownership Tracking System (LOTS) Rewrite
The Department of Natural Resources (DNR) has a Land Ownership Tracking System (LOTS), which tracks the ownership of state land, minerals and state land subject to mineral leasing. LOTS also tracks DNR deed registry, abstract of title for state-owned land and revenue generated from the sales of land and mineral leasing. The current LOTS application framework is outdated and is no longer supported by the Department on Technology, Management and Budget (DTMB). To remedy this situation, MDNR is seeking to consolidate LOTS, Payment in Lieu of Taxes (PILT), and Swamp Tax into one elegantly-designed solution, architected in the Microsoft .NET framework, and conforms to the State's Next Generation Digital Infrastructure (NGDI).
12/7/2018 Robin Krzciok Mike Cooley Pat Harlow
DNR - Department of Natural Resources
DNR - SIGMA (MAIN Replacement) Interface Updates
The State of Michigan is currently implementing project SIGMA, which involves the replacement and technological upgrade of the state’s current financial system called MAIN.   This project involves the update of the existing MAIN interfaces for DNR applications, so they will function with the new SIGMA system.    As a result, DNR’s accounting and reporting capabilities should be improved.
12/31/2018 Richard(Rick) Stankiewicz Michael Cooley Ross Feldpausch
DNR - Forest Resources Division
DNR - Fire-PC Rewrite
Forest Resources Division (FRD) uses this application to track data about wildfires in Michigan. This enhancement will allow FRD to move to a eb-based system that automates prescribed burn planning and integrates with the MiCaRS/Sigma accounting system via web services.

NOTE: The Planned Finish Date reflects the target date for completing project initiation. Future project milestones will be planned once the planning phase has been completed.
12/31/2018 Richard(Rick) Stankiewicz Lisa Hartstuff Lou Ann Fedewa
DNR - Forest Resources Division
DNR - VMS 5, 6, 7 and OLB 3.0
Completes the implementation of the Vegetative Management System by completing VMS 5, 6, 7 and Online Bidding (OLB 3.0). This will bring the DNR Forest Resources Division's Timber Sale processes up to latest business functionalities and integrating various accounting functionalities. The VMS system has been implemented in a series of phases to address changing needs in functionality, as well as enhancements supported by more modern technology.  “VMS 4” is the current phase in production and continues to be used in parallel to functionality still only supported in T-Sale.  In preparation for continuing VMS phases, and the decommissioning of T-Sale, the DNR completed requirements and functional design activities for “VMS 5” in 2015, followed by requirements and functional design activities for “VMS 6” in 2016.  “VMS 7” is included in this scope, however, full requirements or functional specifications have not yet been done for the VMS 7 functionality.



Note: The Planned Finish Date reflects the target date for completing project initiation. Future project milestones will be planned once the planning phase has been completed.
5/26/2021 Robin Krzciok Lisa Hartstuff Doug Heym
DOS - Department of State
MDOS - CARS - Customer and Automotive Records System - Legacy Modernization
The Legacy Modernization Program will modernize and integrate all of Driver and Vehicle systems into newer platforms along with new hardware infrastructure.
10/18/2019 Linda Clarke James McFarlane Mike Senyko
DOS - Department of State
MDOS - Inventory Hardware Migration (Oracle APEX)
This modernization project will rewrite the end-of-life Oracle Financials application using Oracle APEX as well as refresh servers.
1/12/2018 Luc Kamdem Nathan Buckwalter Bill Badgero
DOS - Department of State
MDOS - Migrate Off the Informix Platform
Selection and installation of COTS Case Management software for the Administrative Hearings Division (AHD) to replace the 25 yr. old DAAD Informix system.
5/9/2018 Jagdeep Singh Nathan Buckwalter Bill Kordenbrock
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.
4/30/2019 Swaminathan Ganesan Nathan Buckwalter Sally Williams
DTMB-M-ORS - Office of Retirement Services
ORS - Insurance Process Redesign 79942
The purpose of this project is to redesign the Clarety insurance module to meet the demands of a changing insurance market and to create flexibility that will allow for greater latitude in administrative decision making.
4/30/2018 Brittney Dennison Mike Bilek Laurie Mitchell
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.
1/15/2018 Jill Redinger Rodney Davenport Michael Moody
e-MI - e-Michigan
Cooperative Digital Services Contract
The Citizen Portal project will modify the Michigan.gov portal to improve citizen access to information across the government enterprise so that relevant information is easily presented.
12/29/2017 Kristen Furseth Eric Swanson James McFarlane
e-MI - e-Michigan
Unified Portal - MiPage
Michigan.gov portal content management system software needs to be replaced.  An RFP will be issued to help State of Michigan assess different solutions available.



MichiganThe goal of the MiPage project is to provide an IT solution that will allow individuals to efficiently find information and interact with State of Michigan systems in a manner that is citizen centric and can be personalized.  The implemented solution will allow the citizen the ability to find and save the information and services that are of interest and provide a user friendly way to manage their information. 

An additional goal of the project is to establish the standards and technologies for mobile development for the enterprise.  As part of this project, the MiPage team will engage client agencies and their DTMB teams in converting key applications to be mobile friendly.
1/26/2018 Scott Reynolds Eric Swanson Suzanne Pauley
IS - Data Center Operations
IS-DCO-TBHC Migration
Development of the plan and costs for the closure, movement and/or migration of devices in the existing State of Michigan Traverse Bay Hosting Center (TBHC) in Lansing, Michigan.



Enterprise Data Warehouse move scheduled for 11/8, 11/9, and 11/10.  Customer development work can be accomplished on prod or test boxes during this time.
3/31/2018 Daniel Szakal David Roach David Roach
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
10/5/2018 Louai Blan Rod Davenport David Bates
LOTT - Lottery
LOTT - Charitable Gaming Information System (CGIS) Replacement
Replace current Charitable Gaming Legacy XGEN system. Considerations will include Audit functions currently managed in Capstone and integration to HP TRIM document management system.
9/30/2018 Jack Keck laura brancheau Kathie Oviedo
LOTT - Lottery
LOTT - SIGMA
Manage all tasks and changes associated with implementation of SIGMA for Lottery
12/29/2017 Jack Keck laura brancheau Holly Hohman
MDARD - Michigan Dept of Agriculture Rural Development
MDARD - Agencywide Licensing and Inspection System
 The objective of the project 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.
1/1/2022 Richard(Rick) Stankiewicz Manny Rosales George Noonan
MDARD - Michigan Dept of Agriculture Rural Development
MDARD - SIGMA (MAIN Replacement) Interface Updates
The State of Michigan is currently implementing project SIGMA, which involves the replacement and technological upgrade of the state’s current financial system called MAIN.   This project involves the update of the existing MAIN interfaces for MDARD applications, so they will function with the new SIGMA system.    As a result, MDARD’s accounting and reporting capabilities should be improved.
12/31/2017 Richard(Rick) Stankiewicz Michael Cooley George Noonan
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.
7/6/2018 Trevor Sweet Kimberly Koppsch-Woods Cynthia Kelly
MDHHS - Central Office
MDHHS - SIGMA - MAIN Replacement
The State of Michigan is currently implementing project SIGMA, which involves the replacement and technological upgrade of the state’s current financial system called the Michigan Administrative Information Network (MAIN).   The purpose of this project is to integrate SIGMA with MDHHS systems and interfaces currently connecting to MAIN.
4/30/2018 Mary Brennan Susan Nordyke Steve Bendele
MDHHS - Department of Community Health
MDHHS - Enterprise PMO Data Hub Infrastructure Program
This project represents the Michigan Department of Health and Human Services (MDHHS) Data Hub Program for FY 17.  The MDHHS Enterprise PMO Data Hub Infrastructure Program consists of multiple projects to support the Health Information Exchange.  This includes the Master Person index (MPI), Provider Index (PI) and multiple health data messaging projects.
 
11/9/2018 Sherry Snow David Fox Cynthia Green-Edwards
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.
3/23/2018 Darren Elliott James Rice Heidi Washington
MDOT - Department of Transportation
MDOT - AASHTOWare Project - CMI
This project will implement the web based AASHTOWare Project - Construction/Materials (AP-CM) system into production and lay the groundwork to eventually retire the legacy, client/server based applications, i.e. FieldManager (FM), Contract Administration System (CAS), FieldNet (FN) and FieldBook (FB).  The project includes user acceptance testing, development and testing of 26 interfaces, developing, testing, and implementing a materials acceptance process, execution of MDOT's Business Change Management Plan developed in the AP-CM analyses and preparation project, and a phased implementation.  It also includes the addition of MDOT's local and private sector business partners to the State network as they will use the single instance of AP-CM.
10/31/2019 Deb Mosher John Kalanquin Kim Avery, Myron Frierson, Jason Gutting, Brad Wieferich
MDOT - Department of Transportation
MDOT - Phase Funding Initiation
The MDOT legacy MAP Financial Obligation System (MFOS) is being replaced as part of the state-wide implementation of the SIGMA project.  MFOS provides two major functions for MDOT:  Initiation and Obligation of MDOT job phases.  SIGMA will replace the Obligation portion of MFOS' functionality, and the new Phase Funding Initiation (PI) system will replace the Initiation portion.  The new Phase Funding Initiation system will provide an enhanced user experience, and will integrate with both JobNet and SIGMA to request and receive Federal approval and reimbursement of MDOT road projects.
12/5/2017 Steve Williams John Kalanquin Myron Frierson, Brad Wieferich
MDOT - Department of Transportation
MDOT - SIGMA
The SIGMA project will replace the state-wide accounting system and several other financial systems.  MDOT’s portion of this project will include the enhancement/replacement/interfacing of various MDOT financial systems and share data with SIGMA.
12/31/2017 Mary Fox John Kalanquin Myron Frierson
MDOT - Department of Transportation
MDOT - Traffic Data Management System (TDMS)
Modernize the department's traffic collection, monitoring, estimation and reporting software from the TDMS suite of 20+ legacy applications.  This is a candidate for a commercial off-the-shelf (COTS) solution.
4/20/2018 Jeff Beasley John Kalanquin Dave Wresinski
MLB - Michigan Land Bank
TED - MLB - SIGMA
Manage all tasks and changes associated with implementation of SIGMA for the Michigan Land Bank.
11/30/2017 Andrew Huhn Nancy Palmateer  
MSHDA - Michigan State Housing Development Authority
TED - MSHDA - MiSHPO
The State Historic Preservation Office (SHPO) is planning to migrate out of ARGUS. SHPO intends to automate four program processes including the National Register of Historic Places, archaeology, Section 106 environmental review, and historic rehabilitation tax credits. 
4/30/2018 Jack Keck Carmen Redwine Linda Beachnau
MSHDA - Michigan State Housing Development Authority
TED - MSHDA - SIGMA
Manage all tasks and changes associated with implementation of SIGMA for MSHDA.
11/30/2017 Jack Keck Carmen Redwine Janell Thelen
Procurement
PROC - RED - RFP
RFP for the real estate division to obtain a COTS solution and legacy modernization initiative.  Lease Administration and Project Portfolio Management of lease licenses, easements, land and state-as-lessor data and related projects.  iTRAC # C20141212-153842.
 
8/4/2017 Jarrod Barron Buyer: Jarrod Barron Troy Bos
TREA - Bureau of Bond Finance
TREA - (SAF-092) New Scholarships and Grants payment system
Replace current failing legacy Student Financial Aid System administering Scholarships and Grants to students and colleges across the state with a configurable off-the-shelf solution.  The solution will also provide data comparisons for legislative decision-makers on the impact of these awards and fund utilization.
8/10/2018 Raja Ramaswamy Lucy Pline Cindy Peruchietti
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.
5/18/2018 Covin Nguyen Lucy Pline Melissa Hatfield
TREA - EP Economic Policy (Tax Policy and ORTA)
TREA - E (EP-101) Hearings Tracking System (HTS) Salesforce Replacement
To enter into a contract for license to install and use Salesforce as a hearings file management and document management replacement for the Hearings Tracking System (HTS) currently being used by Treasury’s Hearings Division.
12/19/2017 Jamie Carnell Lucy Pline Debbie Lange
TREA - FS Financial Services Bureau (also includes Accounting Services)
TREA - (FS-093) Agency Support for SIGMA Project
Agency support during MAIN replacement for requirements gathering and assistance with replacing:  Warrant Writing, Cash Reconciliation, Warrant Reconciliation, and TC88 Interfaces (including the Offset Process)
1/12/2018 Jim Schachermeyer Lucy Pline Suzie Nichols
TREA - TP Tax Processing Bureau
TREA - (TP-307) City Income Tax
To develop a system to process income tax returns (Individual, Corporate, Fiduciary and Partnerships) for cities located in Michigan starting with the 2015 tax year for City of Detroit Individual and 2016 for other City of Detroit income taxes.  System could be used by other cities with minor modifications.
10/18/2017 Bill Howland Lucy Pline Glenn White
TREA - TP Tax Processing Bureau
TREA - (TP-307) City Income Tax - Corporate and Withholding
To develop a system to process income tax returns (Corporate, Fiduciary, Partnerships, and Withholding) for cities located in Michigan starting with the 2016 tax year for the City of Detroit. System could be used by other Michigan cities with minor modifications.
11/30/2017 Bill Howland Lucy Pline Glenn White
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
4/30/2018 Tonya Kahley Lucy Pline Amy Garcia
TREA - TP Tax Processing Bureau
TREA M - (TP-322) IIT- Move Composite Microsoft Access databases to a supported technology
Composite returns and Renissance Zone accounts are currently stored in Microsoft Access database. With this candidate we would like to move these to a dot net, Oracle database or some otherDTMB supported technology.

Currently we have approximately 30,000 Composite returns and 14,000 Ren Zone accounts store in separate MS Access Databases. These databases are the only electronic storage of this data. The returns are paper filed, once the files are keyed, the composite returns are stored off site. Each year we receive approximately 5,000 additional returns that are keyed by IIT staff. In 2012, we tracked more than $48,000,000 in tax liability for Composites. As the number of returns continue to increase each year, the need to move the current database into an environment supported by DTMB. The informtion should be stored in a more secure environment that will all input by multiple users but also minimize the possibilites error. Because we only accept paper filers, and once the information is keyed, the paper documents are stored off site, it is imperative that the information is accurate and easily accessable to staff to allow staff to provide accurate information to the taxpayer or CPAs.
9/29/2017 Jamie Carnell Lucy Pline Josh Horn