Presentation to the Information Technology Commission March 03, 2010

1. Presentation to theInformation Technology CommissionMarch 03, 2010 Department of Information Technology PCC January & February 2010 Certifications • Presented by: • Mike Baca – Project Oversight Compliance Acting Division Director

2. IT Project Certification Timeline and Gates

3. 2010 CertificationsSummary Sheet 8 - Agencies 10 - Projects Total Amount Certified: $13,628,099

4. 2010 – January Certifications PED – NM Achieves • PHASE: Initiation • Amount certified: $0 • Previous amounts certified: $0 • Total Project Budget: $19,997,450 (tentatively) • Abstract: The NM ACHIEVES project will collect essential data elements from the state’s PreK, K-12, postsecondary and workforce databases to create a complete Statewide Longitudinal Data System. The project will entail updating and/or replacing various agency systems as necessary to accommodate a common data exchange method. Stakeholders include: Public Education Department, Higher Education Department, Children Youth and Families Department, and the Department of Workforce Solutions. • Project Start & End Date: January 2010 - June 2013 • Funding Sources: FY10 – FY12 Department of Education – Institute of Educational Sciences; Statewide Longitudinal Data System Grant.

5. 2010 – January Certifications HSD – Behavioral Health Data Warehouse – Phase I • PHASE: Close • Amount certified: $0 • Previous amounts certified: $97,000 (Planning), $56,148 (Implementation) • Initiated Project, Developed Project Charter, Developed Project Management Plan • Built the infrastructure to support the Data Warehouse and the project objectives for Phase I • Total Project Budget: $156,990 (Planned) $153,148 (Actual) • Abstract: The Behavioral Health Data Warehouse – Phase I project encompassed receipt of four(4) years of behavioral health data from ValueOptions New Mexico. ValueOptions was the contracted Statewide Entity (SE) and collected all the Collaborative data from 7/01/05 through 6/30/09. • Project Start & End Date: September 2008 - January 2010 • Funding Sources: FY08 $97,000 Health Resources Services Administration (HRSA) Federal Grant Grant Number HRSA-05-146; CFDA 93-888 FY09 $42,000 Drug and Alcohol Services Information System (DASIS) Federal funding associated with substance abuse reporting FY09 $17,990 Data Infrastructure Grant; Federal Grant FY09 Grant Number 5HR1SM058118-02 CFDA 93.243

6. 2010 – January Certifications HSD – Deficit Reduction Act • PHASE: Change in Scope¹ • Amount certified: $137,696 • Previous amounts certified: $993,704 (Implementation) • Initiated Project, Developed Project Charter, Developed Project Management Plan • Collaborative upgrade to the DoIT Mainframe system • Total Project Budget: $1,131,400 • Abstract: The Deficit Reduction Act of 2005 contains requirements for implementation of a Pass-Through amount from the Child Support Enforcement System (CSES) to the Income Support Division 2 System (ISD2). To implement the Pass-Through amount, changes to the CSES and ISD2 systems are necessary. HSD received certification of additional funds to complete the final stage of the project. • Project Start & End Date: December 2008 - June 2011 • Funding Sources: FY08 $993,704 Laws of 2007, Chapter 28, Section 5(59) FY10 $137,696 Laws of 2009, Chapter 124, Section 5(44) ¹Certfication contingent on IV&V status resolution. Waiver approved.

7. 2010 – January Certifications DOT – Ignition Interlock Data Analysis • PHASE: Close¹ • Amount certified: $0 • Previous amounts certified: $300,000 (Implementation) • Initiated Project, Developed Project Charter, Developed Project Management Plan • Contracts for Project Manager and IV&V services. • Professional services for database development; hardware purchases. • Total Project Budget: $300,000 • Abstract: The Ignition Interlock Data Analysis project has created a statewide Ignition Interlock system that will: Allow automated data submissions from manufacturers; Allow stakeholders and customers the ability to monitor Ignition Interlock offender compliance; And make data available for analysis. • Project Start & End Date: December 2007 - September 2009 • Funding Sources: FY08 $300,000 National Highway Traffic Safety Administration Section 164, Alcohol Countermeasures ¹Certification contingent on follow-up budget items on certification form. Closeout approved.

8. 2010 – January Certifications SOS – Campaign Finance Information System • PHASE: Implementation • Amount certified: $136,500 • Previous amounts certified: $40,000 (Planning) • Initiated Project, Developed Project Charter, Developed Project Management Plan • Completed gap analysis from Washington state system, engaged in IV&V throughout the project requirements phase. Generated detailed and specific system requirements for business scenarios. • Total Project Budget: $176,500 • Abstract: The project will replace the current Political Finance Reporting System with a user-friendly and cost effective Campaign Finance Information System. • Project Start & End Date: December 2009 - March 2010 • Funding Sources: FY09 $176,500 Laws of 2009, Chapter 124, Section 7(6)

9. 2010 – February Certifications TRD – Driver Re-engineering • PHASE: Implementation • Amount certified: $13,169,117 • Previous amounts certified: $400,000 (Initiation), $300,000 (Planning) • Initiated Project, Developed Project Charter, Developed Project Management Plan • Develop RFP requirements for Driver/Vehicle MVD System; Develop and Award RFP; Data clean-up and preparation. • Hire Project Manager; engage IV&V contract; contract professional IT developers. • Total Project Budget: $13,869,117 (Appropriated) $22,169,117 (Anticipated) • Abstract: The TRD Driver Reengineering project will replace the legacy MVD systems with a modern Commercial-Off-The-Shelf (COTS) product. The COTS product selected has been used in other states. The new system will be designed to meet current and future needs while increasing reliability, security, and maintainability. • Project Start & End Date: December 2008 - July 2012 • Funding Sources: FY09 $4,120,000 Laws of 2008; Chapter 3, Section 7, Item 5 FY10 $8,042,500 Laws of 2009; Chapter 124, Section 7, Item 3 FY09 $372,900 Federal Motor Carrier Safety Administration CDL Program, CD-09-35-1 FY08-11 $500,000 Department of Homeland Security 2008-ID-MX-0001 FY09-12 $833,717 Department of Homeland Security 2009-ID-MX-0006

10. 2010 – February Certifications DPS – New Mexico Law Enforcement Telecom System • PHASE: Implementation • Amount certified: $0 • Previous amounts certified: $215,000 (Initiation) $2,785,000 (Planning) • Defined requirements; Developed issued, and awarded RFP; Established IV&V contract; Developed draft Project Management Plan, Timeline and System Architecture. • Total Project Budget: $3,000,000 • Abstract: The project objective is to replace the current Law Enforcement Telecom System with a new system that provides advanced technologies, improves system response time, and can be supported by DPS and vender staff. The NMLETS system is the primary system for providing the critical data law enforcement agencies need to identify wanted or missing persons, stolen vehicles, criminal histories, and parolee information among other such information. • Project Start & End Date: October 2007 – March 2011 • Funding Sources: FY07 $3,000,000 Laws of 2007, Chapter 28, Section 7 Item 030

11. 2010 – February Certifications PED – Career Technical Education Online Resource Environment (SCORE) • PHASE: Planning • Amount certified: $74,786 • Previous amounts certified: $0 • Developed Project Charter, Developed Project Management Plan • Total Project Budget: $441,756 • Abstract: The PED SCORE project will develop an electronic environment that integrates all elements of technical assistance for its New Mexico grantees who receive the Federal Carl D. Perkins grant. Information to be integrated into the electronic environment to support technical assistance includes but is not limited to: grant applications, evaluation rubrics, monitoring documents, action plans, performance measures, and reporting. The SCORE web portal will include technical assistance via live and recorded video streaming. • Project Start & End Date: December 2009 - December 2010 • Funding Sources: FY10 $441,756 Carl D. Perkins Act 2006 (Federal Grant)

12. 2010 – February Certifications OSE – Middle Rio Grande GIS Application • PHASE: Close • Amount certified: $0 • Previous amounts certified: $25,962 (Planning), $116,819 (Implementation) • Initiated Project, Developed Project Charter, Developed Project Management Plan • Developed System Requirements; Acquired hardware; designed and implemented system. • Total Project Budget: $138,836 (Planned) $150,843 (Actual) • Abstract: The Middle Rio Grande Geospatial Information System compiles digital historic land and water use statistics for a selected area. The application provides analytical tools to calculate consumptive water use totals, validate water rights claims, and verify water use compliance. The application has the potential to expand utilization beyond the Middle Rio Grande corridor. • Project Start & End Date: March 2008 - January 2010 • Funding Sources: FY08 $138,835 Laws of 2003, Chapter 429, Section 33(4) FY09 $37,406 Laws of 2008, Chapter 3, Section 4 FY10 $8,062 Laws of 2009, Chapter 124, Section 4

13. 2010 – February Certifications DOH – Health Assessment Tool • PHASE: Implementation • Amount certified: $110,000 • Previous amounts certified: $15,000(Initiation) $75,000(Planning) • Created Project Charter; Developed Project Management Plan; Established procurement method; Developed RFP • Engaged IV&V; Release of RFP and evaluation of respondents; Contracted project manager. • Total Project Budget: $200,000 • Abstract: The Health Assessment Tool will replace the current paper-based system with an electronic web-based system for conducting health risk screenings. A request for proposals will be used to solicit proposals from vendors whom can provide a web-based software solution. Benefits of a modern system include: Real-time data analyses; On demand reporting on health risks, care levels, and trend analysis; and an ability to track health related data by client and location. • Project Start & End Date: March 2009 – September 2010 • Funding Sources: FY09 $75,000 Laws of 2009, Chapter 124, Section 4, Subsection F, Item 5 FY10 $125,000 Laws of 2009, Chapter 124, Section 4, Subsection F, Item 5