Missouri Discovery Session Materials Provided MoGEM Conceptual Solution Architecture, Technology Roadmap and Architecture Plan MoGEM Current Status November 2015 – MoGEM Governance Board Charter MoGEM Governance Operation Plan 1.3 FINAL – MoGEM Future Vision v1.2 FINAL – MoGEM Logical Data Model v1.1 FINAL MoGEM Technology Roadmap and Architecture Plan v1.2 FINAL APPROVED – Roadmap for printing Final approved – Participants Missouri Discovery Session Participants Kimberly Hoke, MO DNR Lee Kyle, EPA OEI Mark Finnell, MO OA ITSD Lucas Gentry, CGI Federal Level of Experience/History Missouri is in the planning stages of establishing master regulated entity data. Today, Missouri Department of regulated entity data is stored in numerous information Natural Resources’ (DNR) document describes their current situation as: Future Vision silos. DNR’s DNR currently uses separate applications across different program areas to capture master data for a regulated entity. These program applications are built on platforms such as DB2, SQL Server, Access, and Excel. Most of these applications do not have the capability to transfer master data electronically from one program application to another program application. For example, if there is a name change for a regulated entity in one program application, this update does not automatically occur for the same regulated entity captured in another program application. Since the master data for the same regulated entity is being captured in different applications across different program areas, it has become difficult for DNR to accurately report on the number of regulated entities and specific activities occurring at a single regulated entity. In addition, the master data for these regulated entities captured in the applications are not always accurate. The need has been identified to improve the data management of the regulated entity subject area to provide clean, consistent master data to the enterprise. Missouri discovery session participants indicated that tackling the is ‘facility problem’ foundational to addressing DNR reporting requirements as well as to the need to maintain and modernize legacy applications. Missouri was aware that master data management approaches were in place and proven effective in other domain areas (such as finance), investigated approach options, and is now pursuing a master data management approach for their environmental regulated entity data. The effort is known as the Missouri Gateway for Environmental Management (MoGEM). Technical Approaches Missouri is currently in the process of a comprehensive effort to define and implement their master data management approach for MoGEM. A detailed architecture and roadmap are
Missouri Discovery Session Materials Provided MoGEM Conceptual Solution Architecture, Technology Roadmap and Architecture Plan MoGEM Current Status – November 2015 MoGEM Governance Board Charter MoGEM Governance Operation Plan 1.3 – FINAL MoGEM Future Vision v1.2 – FINAL MoGEM Logical Data Model v1.1 FINAL MoGEM Technology Roadmap and Architecture Plan v1.2 – FINAL APPROVED Roadmap for printing – Final approved Participants Missouri Discovery Session Participants Kimberly Hoke, MO DNR Mark Finnell, MO OA ITSD Lee Kyle, EPA OEI Lucas Gentry, CGI Federal Level of Experience/History Missouri is in the planning stages of establishing master regulated entity data. Today, Missouri Department of Natural Resources’ (DNR) regulated entity data is stored in numerous information silos. DNR’s Future Vision document describes their current situation as: DNR currently uses separate applications across different program areas to capture master data for a regulated entity. These program applications are built on platforms such as DB2, SQL Server, Access, and Excel. Most of these applications do not have the capability to transfer master data electronically from one program application to another program application. For example, if there is a name change for a regulated entity in one program application, this update does not automatically occur for the same regulated entity captured in another program application. Since the master data for the same regulated entity is being captured in different applications across different program areas, it has become difficult for DNR to accurately report on the number of regulated entities and specific activities occurring at a single regulated entity. In addition, the master data for these regulated entities captured in the applications are not always accurate. The need has been identified to improve the data management of the regulated entity subject area to provide clean, consistent master data to the enterprise. Missouri discovery session participants indicated that tackling the ‘facility problem’ is foundational to addressing DNR reporting requirements as well as to the need to maintain and modernize legacy applications. Missouri was aware that master data management approaches were in place and proven effective in other domain areas (such as finance), investigated approach options, and is now pursuing a master data management approach for their environmental regulated entity data. The effort is known as the Missouri Gateway for Environmental Management (MoGEM). Technical Approaches Missouri is currently in the process of a comprehensive effort to define and implement their master data management approach for MoGEM. A detailed architecture and roadmap are
Facility_Data_Integration_Discovery_and_Analysis_Phase_1_Final_Report.docx