1

NEW MEXICO INTERAGENCY BEHAVIORAL HEALTH

PURCHASING COLLABORATIVE DATA WAREHOUSE PROJECT

Phase IIPresented to the Project Certification Committee (PCC) on

October 26, 2010Presenters:

Brian Pietrewicz, Acting CIO, HSD Information Technology DivisionHarrison Kinney, Executive Manager, Behavioral Health Services Division

Carol A. (Cat) Thomas-Gravel, HSD Application Support Bureau ChiefTeresa Henke, Project Manager

Behavioral Health Collaborative History

The Interagency Behavioral Health Purchasing Collaborative (Collaborative) was created during the 2004 Legislature.

It is a Cabinet-level group representing 15 agencies and the New Mexico State Governor’s Office.

The creation of the Collaborative allowed most state agencies and entities involved in behavioral health treatment and recovery to work as one in an effort to improve mental health and substance abuse services in New Mexico.

The Collaborative is responsible for contracting with the Single Statewide Entity (SE).

2

The Data Warehouse

The Collaborative has built a data warehouse which currently contains data from the previous Statewide Entity (SE), ValueOptions New Mexico (VONM) and also data from the current SE, OptumHealth New Mexico. 

This data will ultimately be used for decision support, federal reporting, legislative inquiries and the Governor’s Performance and Accountability Contract, as well as ad hoc reports and other as yet undefined requests.  

The Behavioral Health Data Warehouse project has been designed to be completed in three phases, all treated as separate projects.

3

4

Behavioral Health Data Warehouse Phase II Project

Update There was a delay of seven months in the

original timeline due to OptumHealth New Mexico not sending the required data.

Due to the delay, the contract with POD, Inc., for Project Management, Business Analysis, and ETL Development was cancelled.

Phase II timeline revised from FY11 to FY12.

Completed Phase II Tasks/Accomplishments

The initial data feed was received June 15, 2011, from OptumHealth New Mexico, and weekly incremental data feeds are now being received.

A Proof of Concept for data quality and sample reporting has been developed by in-house technical staff.

Project staff are meeting currently with the Behavioral Health Services Division to define the priority data to be put into the Data Warehouse.

5

Phase II Revised Project Timeline

6

7

IV&V Vendor

The IV&V Vendor, Cognosante (previously Fox Systems, Inc.) will continue the IV&V activities with a new contract. The contract is currently in the signature process.

8

FinancialsCertified Expenditures to

DateEstimated Future Costs

Original Amount Certified $56,000 on December 10, 2010 $144,000 on May 4, 2010

$200,000.00

Expenditures * IV&V Contract with Fox Systems, Inc. * POD, Inc. Contract for Project Management, Business Analysis, and ETL *Software purchases

($70,216.00)($15,172.00)

( $484.00)

Total expenditures to date ($85,872.00)

Proposed expenditures for remainder of project Contractors

*IV&V *ETL Developer

( $13,614.00) ($99,534.00)

Estimated Future Cost Total ($113,148.00)

Total expenditures ($199,020.00)

Amount remaining $980.00

RISKS Shortage of IT and Program Staffing

Resources. Potential Changes to BH Collaborative and

the Statewide Entity Contract: Proposed Carve-in of Medicaid Behavioral Health

Services to the MCO’s; MAD is seeking approval for the 1115 Waiver; Health Homes Initiative – Federal Reporting

Requirements (IT support and system needs).

9

10

Questions&

Thank you!