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 - CyberSecurity Framework
The Cyber Security Framework project will align to the National Institute of Standards and Technology , Cyber Security Framework as its foundation to drive various improvements and address security program gaps.  The newly enhanced Security Program will serve as the platform for other projects included in the Cyber Security Continuous Improvements Program.

Key scope areas of the Cyber Security Framework include:

• Establish an industry standard framework as the program foundation National Institute of Standards and Technology

• Increase the support for Agencies by maturing the Security Program

• Assess and improve the existing Security Operating Model and align that model to the National Institute of Standards and Technology  Framework

• Assess and improve the existing Security Controls and align those controls to the National Institute of Standards and Technology  Framework

• Assess and improve the existing Policies, Standards and Procedures and align the Policy Standards and Procedures to the National Institute of Standards and Technology   Framework

• Assess current organization design and staffing levels and adjust accordingly

• Pilot the State of Michigan Governance, Risk & Compliance (GRC)platform to manage Policy Standards and Procedures.

• Implement a Governance, Risk & Compliance (GRC) tool to manage the System Security Plan and Risk Assessment.

• Pilot the System Security Plan and Risk Assessment tool (LockPath - Keylight)

• Rollout the Governance Risk Compliance tool (LockPath) to all SOM Agencies.
9/29/2017 Jose Semidei Richard Reasner Rajiv Das
CIP - Cybersecurity & Infrastructure Protection
CIP - Data Loss Prevention
The Data Loss Protection project will refine and improve existing data protection processes in several areas including policy, process and technology.  The project’s key deliverable is the implementation of a Data Loss Protection technology.  DLP is an off the shelf commercial software product offered by various providers in the marketplace.  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
CSS - Center for Shared Solutions
CSS - MILogin Migrations from Legacy SSO
MILogin is an enterprise single sign-on and identity and access management solution which enables the State of Michigan (SOM) to establish, manage, and authenticate user identities for Web and Mobile SOM Information Technology (IT) systems. This solution is providing identity management and identity federation  (IDFED) capabilities in compliance with various Federal and State laws and regulations. MILogin utilizes robust Identity Proofing and Multi-Factor Authentication (MFA) capabilities to ensure secure access to sensitive and protected citizen’s information.



The SOM Legacy Single Sign-On (SSO) system will sunset on 9/30/2016.  Therefore, all SOM agencies will be required to migrate applications off current implementations of the Legacy SSO to the new MILogin solution in FY16. 
7/1/2017 David Skidmore Eric Swanson Andrey Verevko
CSS - Center for Shared Solutions
CSS - MILogin SIGMA Integration
MILogin is an enterprise single sign-on and identity and access management solution which enables the State of Michigan (SOM) to establish, manage, and authenticate user identities for Web and Mobile SOM Information Technology (IT) systems.  SIGMA will be integrating with the MILogin solution for single sign-on and provisioning.
5/12/2017 David Skidmore Eric Swanson Andrey Verevko
CSS - Center for Shared Solutions
Unified Portal-Enterprise Information Management (EIM)
EIM is an improved way of managing vast and valuable state information assets. In 2014 the initial EIM project established organizational processes and the framework necessary to implement a successful EIM program. In 2015 the project identified enterprise solutions, developed proofs of concept, and created actionable department-specific roadmaps. Current efforts focus on pilots, establishing single internet sign-on for citizens and businesses to access all state account information, and statewide implementation. All State departments are engaged and have identified a Chief Data Steward. A Steering Committee of 11 departments is leading the effort.
9/30/2018 Virginia Hambric David Behen Brom Stibitz
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
6/26/2020 Laura Birchmeier Dan Sellepack Susan Leeming
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 Amy Epkey
DEQ - Department of Environmental Quality
DEQ - State Revolving Fund (SRF) Rewrite
The State Revolving Fund (SRF) and  Grants Databases are critical to the annual processing of 788 loans totaling $4.9 billion and 388 Grants totaling $157 million. These databases are used to monitor dates, coordinate contracts, provide cost estimates, tabulate costs and issue loan and grant payments. The current system is being discontinued, and a new system needs to be re-written and the technology upgraded. This will improve the user-interface, allow quicker data processing, improve response times and help assure compliance with federal requirements.
6/16/2017 Jeremy Jehnsen Dan Sellepack Sonya Butler
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.
7/31/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, 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).
11/9/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 Steven Tkaczyk
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 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 Manny Rosales
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.
6/30/2017 Luc Kamdem Nathan Buckwalter Jack Lee
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 Chris Thomas
DOS - Department of State
MDOS - Uniform Commercial Code Modernization
Modernization of the MDOS Uniform Commercial Code (UCC) application used to process documents related to Public Notice of Financial Filings.
8/31/2017 Greg Hopkins Nathan Buckwalter Michael Butcher
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.
12/31/2017 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/2/2018 Jill Redinger Rodney Davenport Michael Moody
e-MI - e-Michigan
EMI Citizen Portal and Cooperative Digital Services
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.
2/13/2018 Kristen Furseth Eric Swanson James McFarlane
e-MI - e-Michigan
Unified Portal-MiPage
The 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
Enterprise
EIT - Cybersecurity Continuous Improvement Program
The Cybersecurity Continuous Improvement Program will further improve the existing Cyber Security Program, with realignment to an industry standard Framework.  In doing so, data protection will be enhanced by having a business focused enterprise security risk management function, focusing on continuous monitoring of all devices, implementing further data analytics, and advancing threat detection and response.
4/13/2018 Jose Semidei Rajiv Das James McFarlane
EPMO - Enterprise Portfolio Management Office
CSS - EPMO Mobile Dashboard
The Department of Technology, Management, and Budget (DTMB) is seeking a solution that allows the Governor’s executive team and any authorized State employees, to monitor State of Michigan project status information from a mobile device.

The solution allows State of Michigan employees to view aggregated status data in an interactive fashion and to view specific project status details.
 
8/30/2017 Sharmila Patke Rob Surber Ward Beauchamp
IS - Data Center Operations
IS-DCO-LSHC 208v to 480v Upgrade
The Lake Superior Hosting Center (LSHC) needs to complete the electrical upgrade effort begun in 2008. The Uninterruptible Power Supplies (UPSs) within Lake Superior Hosting Center (LSHC) are at their end of life. The vendor (Liebert) has sent end of life letters for the  (1,000 volt amperage) Uninterruptable Power Supplies (UPSs). Replacing the 7 old UPSs in the hosting center is the last phase of the electrical upgrade needed at LSHC.

It is estimated that $7.1M is necessary to complete the electrical revisions. Once completed, Lake Superior Hosting Center (LSHC) will have a statistically higher electrical reliability than an Uptime Institute Tier 4 Data Center.
 
6/30/2017 Daniel Szakal Richard Novello Richard Novello
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.
12/21/2017 Donald Hertzske Richard Novello Richard Novello
IS - Infrastructure Services
IS-Enterprise Cloud Strategy Implementation
The office of the State of Michigan Chief Information Officer has set the goal of having 85% of all state systems cloud based or based in a cloud like 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 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.
12/20/2019 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.
11/17/2017 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 Carmen Redwine 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.
2/1/2018 Richard(Rick) Stankiewicz Manny Rosales Thomas Benner
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/2018 Richard(Rick) Stankiewicz Michael Cooley Thomas Benner
MDHHS - Behavioral Health and Developmental Disabilities Administration
MDHHS - MDCH Data Hub Program - 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.
9/30/2017 Kristin Baker David Fox 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.
11/3/2017 Shashi Mohan Susan Nordyke Steve Bendele
MDHHS - Department of Community Health
MDHHS - Data Hub Program - MILogin Phase 2 - Medicaid
Many of the State’s web-based systems require users to enter a unique password to obtain secure access. The Michigan Identity, Credential, and Access Management (MICAM) project was developed to provide a single authentication process that will encompass both state workers and Michigan citizens. The solution has been branded as MILogin.



This is the MILogin Phase 2 FY16 - Medicaid project which will migrate the remaining DCH Medicaid applications and integrate additional systems with the MILogin solution based on agreed upon agency priorities.
9/30/2016 Jenny Miller Andrew Mason Cynthia Green-Edwards
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 FY17.  The MDHHS Enterprise PMO Data Hub Infrastructure Program consists of multiple projects including, but not limited to: Master Person Index (MPI), Provider Index (PI) and multiple messaging projects that are related to improving the IT Infrastructure within the SOM.



The milestones in this project are a reflection of Program Level Milestones (PLMs) that are being tracked at a detailed level in the individual projects that make up this program.  Resources allocated to this program are working at a program-level.
 
9/30/2017 Sherry Snow David Fox Cynthia Green-Edwards
MDHHS - Department of Community Health
MDHHS - Michigan Women, Infants, and Children (MIWIC) End of Life Server Replacement
Replacing Michigan Women, Infants and Children (MiWIC) production, staging and disaster recovery servers that have reached their end of life. The replacement of these servers will be performed under this project.
 
9/29/2017 Charles(Chuck) Spring Kimberly Koppsch-Woods Kobra Eghtedary
MDHHS - Eligibility PMO
MDHHS - Eligibility - Program
This project is to develop real-time eligibility determination and enrollment systems for the Michigan Department of Health and Human Services (MDHHS) Eligibility programs. The systems will be interoperable with existing core systems within the State of Michigan, and with other systems that may be needed in the future. This system will provide a simplified and coordinated eligibility determination solution. This includes the provider screening solution for Medicaid.
6/8/2018 Timothy Squire Kemal Tekinel Karen Parker
MDHHS - Eligibility PMO
MDHHS - Medicaid Compliance Program (MCP)
This project is to develop real-time eligibility determination and enrollment systems for the Michigan Department of Health and Human Services (MDHHS) Eligibility programs. The systems will be interoperable with existing core systems within the State of Michigan, and with other systems that may be needed in the future. This system will provide a simplified and coordinated eligibility determination solution. This includes the provider screening solution for Medicaid.
12/31/2017 Robert Linnan Kemal Tekinel Karen Parker
MDHHS - Medical Services Administration
MDHHS-ICD-10-Optimization-Stabilization
The State of Michigan and the federal government have already invested substantial funding in building the ICD-10 infrastructure. $18.3 million gross (2.3 M GF/GP) was invested in FY14 along with $30.0 million gross ($3.0 million GF/GP) from FY13. Not providing the funding to optimize the system will put the significant original investment at risk.

Due to the federal delay of implementation until October, 2015, this proposal is to request funding to provide optimization services for ICD-10. This includes evaluating operational performance and provider code trends, providing outreach, transitioning activities, processing and implementing system change requests for post-Go-Live enhancements, and providing external end-to-end testing services for late adopters.

Some of the benefits of the ICD 10th revision codes are greater health care specificity, more detailed data for analysis and improved care management. In addition, Medicaid can more accurately pay for procedures based on specific diagnoses and the severity of the diagnosis. Electronic health records can also be used to better provide quality and performance measures.
 
10/10/2016 Brian Gallup Andrew Mason John Spitzley
MDOC - Department of Corrections
MDOC - ITIF - Offender Management Legacy Modernization - Phase 2
Integrate current MDOC systems into an updated web-based ecosystem to be known as the Offender Management System (OMS). OMNI (client-server), CMIS (mainframe) and other MDOC applications will be migrated into the new ecosystem.  Phase 2 focuses on Time Computation, Crime Victims, Mental Health, Misconducts, Parole Board, ADSS Maintenance and Security business processes.
12/30/2016 Gordon Gamester Kirt Berwald Jeri Ann Sherry
MDOC - Department of Corrections
MDOC - Legacy Technology and Business Process Modernization Project
The Michigan Department of Corrections (MDOC) is responsible for creating a safer Michigan by holding offenders accountable while promoting their success. Phase I of this project will deliver an RFP which will provide MDOC with the necessary market feedback to determine which commercial off-the-shelf or SaaS software system can best address the Department’s needs as it consolidates multiple aging or underperforming technology systems. Phase II of this project will entail working with DTMB-Procurement to post the RFP, complete an evaluation of proposals, and award a contract.
11/9/2017 Darren Elliott Kirt Berwald 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 Tanis Lerash Kim Avery, Myron Frierson, Jason Gutting, Brad Wieferich
MDOT - Department of Transportation
MDOT - JobNet - MPINS Modernization Project
This project is to modernize the current MPINS PowerBuilder application to a web based application with updated functionality to manage projects (job) scope, schedule and budget.  This modernization will maintain essential project information for MDOT and will be used by personnel across all of MDOTs bureaus and regions to collect data about transportation projects.
3/31/2017 Jim Normandin Tanis Lerash Brad Wieferich, David Wresinski
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.
11/30/2017 Steve Williams Tanis Lerash Myron Frierson, Brad Wieferich
MDOT - Department of Transportation
MDOT - Planisware
The Program/Project Management System (P/PMS) is a legacy UNIX host-based application in need of modernization.  New COTS Planisware Solution will replace legacy P/PMS system. Planisware will be used by MDOT users for scheduling, reporting progress, tracking the status of jobs and tasks, and managing resources. Its primary use will be for jobs to be let as trunkline road and bridge projects/jobs in the Early Preliminary Engineering (Scoping) and Preliminary Engineering (Design) stages.
2/28/2017 Elena Bantilan Chuck Baird 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 Tanis Lerash 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.
11/30/2017 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. 
12/1/2017 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 - MGCB Enterprise Solution – RFP
MGCB looking for a enterprise solution for Legacy Replacement and consolidation of 30 IT systems.  High priority project enterprise IT project. itrac#C20141211-073147.
3/31/2017 Jarrod Barron Buyer: Jarrod Barron Holli Doyle
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.
1/26/2018 Jamie Carnell Lucy Pline Cindy Peruchietti
TREA - DWT Department Wide Technology
TREA - E (DWT-045) MTO User Experience Optimization
The goal of this initiative is to rapidly deploy quantifiable user experience enhancements across the Michigan Treasury Online (MTO) application; the public facing portal for return filing and paying of Sales, Use, and Withholding (SUW) taxes.  Launched in January 2015, user satisfaction surveys have demonstrated a greater than 80% dissatisfaction with the online experience.



DTMB and Treasury have partnered to identify quick win opportunities to address the following most common concerns;

- requirement to maintain multiple sets of user credentials to register, file returns, and pay

- cumbersome nature of tax payer authenticating

- overall user friendliness of the application


 
6/30/2017 Tonya Kahley 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.
1/26/2018 Cassandra Huguelet 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.
9/29/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)
12/28/2017 Jim Schachermeyer Lucy Pline Brenda Lindsay
TREA - LG Bureau of Local Government Services
TREA - E (LG-043) Essential Service Assessment (ESA)
The purpose is to collect a specific tax on the acquisition cost of eligible manufacturing personal property (EMPP) that is exempt from ad valorem personal property tax collected at the local level beginning in 2016, under 2014 PA 92.  This state tax will be known as the State Essential Services Assessment (SESA).
5/9/2017 Linda Clarke Lucy Pline Carol Goslin
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.
7/31/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.
9/29/2017 Bill Howland Lucy Pline Glenn White
TREA - TP Tax Processing Bureau
TREA - (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.
8/18/2017 Jamie Carnell Lucy Pline Josh Horn
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
2/21/2018 Tonya Kahley Lucy Pline Amy Garcia