Ren é e Mart í nez (Chief Information Officer) Greg Ridgley (Deputy General Counsel)

1. Office of the State Engineer-Interstate Stream CommissionWATER RIGHTS DATA QUERY, ANALYSIS & EXCHANGE SYSTEM- Implementation Phase --Project Certification Committee Presentation - Renée Martínez (Chief Information Officer) Greg Ridgley (Deputy General Counsel) Rick DeSimone (Water Rights Abstracting Bureau Chief)

2. Appropriations Background • Fiscal Year • FY2009 • Amount • $200,000 GF • Funding Source(s) • 48th Legislature - State Of New Mexico - Second Session, 2008 • HAFC Substitute for House Bills 2, 3, 4, 5, 6 and 10 • (24) STATE ENGINEER - To complete development and implementation of the data extract, transform and load tools and processes to allow data exchange between the water rights adjudication tracking system and the waters administration technical engineering resource system • The appropriation may be expended in fiscal years 2008, 2009 and 2010. Any unexpended balances remaining at the end of fiscal year 2010 shall revert to the general fund OSE/ISC Water Rights Query, Analysis & Exchange System

3. Agency Background • The adjudication of water rights by the Litigation and Adjudication Program (LAP) and the administration of water rights by the Water Resources Allocation Program (WRAP) are two distinct yet complementary activities performed by the Office of the State Engineer • WRATS - The Water Rights Adjudication Tracking System is used to generate legal pleadings and manage its data and attorney work product as water rights are adjudicated by the court system • WATERS – The Water Administration Technical Engineering System is used to manage a variety of historical and current data and work products to facilitate the processing of water rights applications and to administer water rights OSE/ISC Water Rights Query, Analysis & Exchange System

4. Project Purpose • The purpose of this project is to design, build and implement a data query, analysis and exchange system that allows users to: • Query, extract and associate data within the primary adjudication (WRATS) and water rights administration (WATERS) databases and other data stores • Notify appropriate parties when certain events occur in one system or the other • Automate the process of exchanging data between databases • The new system is needed to support the current and future business activities of the Agency OSE/ISC Water Rights Query, Analysis & Exchange System

5. Program Alignment • The program activities to be supported by the new system are: • Start of Adjudication – Users need a snapshot of the water rights history of a geographic area at the outset of an adjudication • Ongoing Adjudication – Users need periodic updates of water rights transactions (declarations, permits, licenses, ownership changes) that take place during the course of the adjudication • Ongoing Water Rights Administration – Users need to research the current water uses that are identified by hydrographic surveys and to be able to determine when water rights transactions may interact with an ongoing legal action • Completion of Adjudication - Users need to pull offers of judgment resulting from the adjudication into WATERS OSE/ISC Water Rights Query, Analysis & Exchange System

6. System Diagram Water Administration Technical Engineering System Water Rights Adjudication Tracking System WATERS WRATS Informix Microsoft SQL Query, Analysis & Exchange System • Owners • Applications • Permits • Transfers • Wells • Documents • Owners • Claimants • Legal Pleadings • Judicial Determinations • Consent Orders Map View Table View Users Users OSE/ISC Water Rights Query, Analysis & Exchange System

7. Project Planning & Status • Planning & Initiation Phase – Project Deliverables • Project Business Case • Project Charter • Project Management Plan • Requirements-Analysis Phase – Project Deliverables • “As-Is” Environment Discovery Report • “To-Be” Environment Discovery Report • System Design Alternatives Assessment Report • System Prototype Scope of Work • Design Phase – Project Deliverables • WE ARE HERE OSE/ISC Water Rights Query, Analysis & Exchange System

8. Project Schedule & Key Deliverables OSE/ISC Water Rights Query, Analysis & Exchange System

9. Project Governance • Agency-IT Strategy Integration • Agency IT Investment Decisions • Agency IT Project Portfolio Management • Program-IT Strategy Integration • Project Investment Decisions • Project Scope Management • Project Task Execution • Project Issue & Risk Management OSE/ISC Water Rights Query, Analysis & Exchange System

10. DoIT Infrastructure Impact • Data Center • Will use Agency VMWare platform housed at SIMMS or Bataan depending on capacity and cost-benefit • Telecommunications (Network Bandwidth) • Low transaction volume (less than 50 per day). Internal users only. • Enterprise Applications • Potential use of State Email System for event notifications • Business Continuity & Disaster Recovery • Data will have a back-up schedule • Security • User and data access privileges will be specific to user and role OSE/ISC Water Rights Query, Analysis & Exchange System

11. Questions OSE/ISC Water Rights Query, Analysis & Exchange System