New Mexico Environment Department
FY15 Environmental Information Exchange Network Grant Proposal
Project Narrative
New Mexico Environment Department ICIS-Air Dataflow Project
Please Note that this document which was submitted to EPA as a proposal to the FY15 Exchange Network Grant Solicitation (http://www.exchangenetwork.net/news/epa-releases-final-fy-2015-exchange-network-grant-solicitation-notice/ ) and awarded to the New Mexico Environment Department via assistance award #83584201 will serve as the Project Charter and Project Management Plan. This document includes project scope, deliverables, schedule, key personnel and budget.
Project Summary
The New Mexico Environment Department (NMED), Air Quality Bureau received grant funding from the U.S. Environmental Protection Agency (EPA) to assist NMED’s endeavors to electronically transfer air compliance data from state databases to EPA’s newly implemented Integrated Compliance Information System Air (ICIS-Air), assistance award #83584201. To accomplish this, NMED will work with contractors to develop an ICIS-Air dataflow that provides for the extraction and conversion of compliance and enforcement data from NMED’s environmental databases into the Extensible Markup Language (XML) format needed for electronic transfer, and the deployment of this data into the ICIS-Air system. The XML formatted instance files will be contained in a zipped archive file, to allow these files to be manually uploaded through EPA’s Central Data Exchange (CDX) or submitted automatically to CDX through a Node on EPA’s Environmental Information Exchange Network (EN). The dataflow will then provide for monitoring of CDX processing and the receipt of update and error reports to allow rejected data files to be corrected and resubmitted. The implementation of this project will improve efficiency in the data exchange between NMED and EPA and modernize the state’s current data system to allow NMED’s compliance and enforcement data to reach a broader spectrum of individuals and entities.
Business Need
The NMED ICIS-Air dataflow project will provide essential resources needed to address important business needs for NMED. First, it will ensure that NMED fulfills its responsibility as a delegated agency to reliably report compliance and enforcement data to ICIS-Air. Second, the ICIS-Air dataflow project will improve the exchange of reliable high-quality environmental data submitted to the EPA national data system. Third, the project will provide for maximum flexibility in data submission by accommodating fully automated node-to-node exchanges, manual submission using a node or node client, and direct use for manual updates. Fourth, the project will provide for automated processes that minimize manual steps in the workflow to increase the efficiency of the data submittal process and reduce the burden of managing and reporting data. Currently, NMED staff enters data into ICIS-Air manually. The NMED ICIS-Air dataflow project will increase the timeliness and accuracy of the data submitted into the ICIS-Air through automating the data entry process. The project will also provide increased resources for staff to work on other high priority projects to further assist the state in its mission to protect public health and the environment.
Project Goal
The NMED ICIS-Air dataflow project goal is to develop the needed resources to implement an ICIS-Air dataflow system in New Mexico. The development of this system will allow for the electronic data transfer of compliance data through the Central Data Exchange to ICIS-Air. This goal will enable NMED to improve the timeliness, completeness and accuracy of air quality data being transferred to ICIS-Air. NMED intends to achieve this goal through the following steps:
A) Identify data requirements for ICIS-Air dataflow
A1) Analyze Air Flow Configuration, Technical Specifications & Design Documents to identify data requirements for ICIS-Air dataflow
B) Design ICIS-Air dataflow
B1) Identify Oracle database procedures required to extract data from NMED databases
B2) Map data from NMED databases to ICIS-Air Data Exchange Template & XML Schema
B3) Develop dataflow design document
C) Develop ICIS-Air dataflow
C1) Develop database procedures to extract, transform and load data from NMED databases to ICIS-Air dataflow staging tables
C2) Develop data cleaning strategies to ensure data meets ICIS-Air business rules
D) Test ICIS-Air dataflow
D1) Install and configure ICIS-Air dataflow in test environment
D2) Install and configure OpenNode2 ICIS-Air plug-in and corresponding staging tables
D3) Test data locally using NMED node and data extracts from NMED databases
D4) Test ICIS-Air submissions using EPA’s Central Data Exchange
D5) Confirm data submission types meet ICIS-Air business rules
E) Implement ICIS-Air dataflow
E1) Deploy and enable ICIS-Air dataflow in production environment
E2) Prepare documentation for ICIS-Air dataflow
Project Outputs and Outcomes for Environmental Results
The following table summarizes NMED’s plan to implement the ICIS-Air dataflow project to enable NMED to track progress on the project and report to EPA and other project stakeholders.
GOALS / OUTPUTS / Target Completion Date / OUTCOMES1. To Implement Tier 1 ICIS-Air dataflow for electronic data transfer of compliance data from delegated state agency databases through Central Data Exchange to ICIS-Air / A. Identify data requirements for ICIS-Air dataflow project / 11/18/15 / 1. Improving the timeliness, completeness, and accuracy of environmental data;
2. Reducing the burden and costs associated with data management and reporting; and
3. Increasing available resources to assist in protecting public health and the environment
B. Design ICIS-Air dataflow / 12/9/15
C. Develop ICIS-Air dataflow / 12/30/15
D. Test ICIS-Air dataflow / 2/11/16
E. Implement ICIS-Air dataflow / 6/30/16
Project Feasibility and Approach
NMED plans to utilize its existing Exchange Network node architecture and experience to support the successful completion of the ICIS-Air dataflow project. NMED has an OpenNode2 node environment in place, and as such will utilize the Exchange Network OpenNode2 Java based plug-in recently designed for the state of Ohio.
NMED has extensive experience with Java-based technologies and other needed technological resources required to implement the ICIS-Air dataflow at the delegated state agency level. NMED also has significant institutional knowledge regarding Oracle databases. To assist NMED in the development and completion of the ICIS-Air dataflow project, contract resources that are familiar with node and Exchange Network technologies are also available to NMED.. Through the use of existing experience within NMED and available contract resources, NMED is well positioned for the successful completion of the ICIS-Air dataflow project.
Programmatic expertise in air quality will be provided by Tom Fitzgerald and Sondra Sage. Both have detailed knowledge of the ICIS-Air data requirements and TEMPO, the state database from which the majority of the compliance and enforcement data will be pulled. Mr. Fitzgerald will serve as the Air Quality Bureau project lead and will work closely with Tom McMichael, the project lead from NMED’s Information Technology Bureau. Mr. McMichael has been involved with numerous node and Exchange Network projects dating back to 2001. See “Key Personnel” below for more details of staff involved in this project.
Programmatic Resources and Key Personnel
NMED’s Information Technology Office will provide the following staff resources:
Mary Montoya, NMED Chief Information Officer; Ms. Montoya provides oversight of the NMED IT Division.
Bogi Malecki, NMED Information Systems Solutions Manager; Mr. Malecki will provide general project oversight to ensure the project is on budget, on schedule and that all grant objectives are met.
Tom McMichael, NMED Technical Node Lead; Mr. McMichael has been involved with numerous node and Exchange Network projects dating back to 2001.
John Crain, Database Administrator; Mr. Crain has significant database management experience. Mr. Crain will provide technical expertise on file structure development, transactions, and analyzing data sources and required data management objects.
Lynn Ray, Oracle DBA; Ms. Ray currently supports the Oracle databases that house exchange data for the NMED node and EPA’s Exchange Network partners. Ms. Ray will provide Oracle expertise and database planning and administration. Standard application database calls developed by the DBAs will be used by application developers.
Mark Morell, Oracle DBA; Mr. Morell currently supports the Oracle databases that house exchange data for the NMED node and EPA’s Exchange Network partners. Mr. Morell will provide Oracle expertise in PL/SQL and data extraction from TEMPO.
The Air Quality Bureau will provide the following staff resources:
Sondra Sage, Air Quality Compliance Specialist; Ms. Sage currently serves as a TEMPO point of contact for NMED’s Air Quality Bureau Compliance Section and supports electronic data transfer of Air compliance and enforcement data. Ms. Sage will provide subject matter expertise for data mapping and will participate in the testing of manual and automated data submittals to ICIS-Air.
Tom Fitzgerald, Air Quality Compliance Specialist; Mr. Fitzgerald currently serves as a TEMPO point of contact for NMED’s Air Quality Bureau Compliance Section and supports electronic data transfer of Air compliance and enforcement data. Mr. Fitzgerald will provide subject matter expertise for data mapping and will participate in the testing of manual and automated data submittals to ICIS-Air. Mr. Fitzgerald has experience managing the development of on line applications for the electronic submittal of compliance reports.
Contract services will be provided by:
TEK Systems: Daniel Gandhi, Java Applications Developer, Mr. Gandhi has been instrumental in developing components for NMED’s OpenNode2 Exchange Network Node. Mr. Gandhi currently works for TEKsystems.
Windsor Solutions: NMED intends to contract with Windsor Solutions to provide the bulk of the work. Windsor Solutions is well versed in ICIS-Air and developed the OpenNode2 Java based plug-in for the state of Ohio. NMED has successfully worked with Windsor Solutions on several IT projects in the recent past.
Budget Proposed:
BUDGET CATEGORY INFORMATION:Hourly Rate / % of Time / Total Personnel Costs
PERSONNEL
Tom Fitzgerald (AQB) / $ 30.14 / 17% / $10,850
Sondra Sage (AQB) / $ 30.829 / 9% / $5,549
PERSONNEL CATEGORY TOTAL / $16,399
FRINGE BENEFITS (Avg. 36%) / $5,904
A. TOTAL PERSONNEL SALARIES & BENEFITS (S&B) / $22,303
B. SUPPLIES / $00
C. EQUIPMENT / $00
Personnel Costs
These costs are necessary to pay the salary and benefits for Air Quality Bureau staff that will allocate time to the project. This includes providing subject matter expertise for the identification of ICIS-Air data elements, the mapping of these data elements in the Department’s TEMPO database, and testing of the data flow for manual and automated submissions to CDX.
BUDGET CATEGORY INFORMATION (Continued):CONTRACTS / Deliverables / Deliverable Date / Hours / Hourly Rate / Hours x Hourly Rate
1. Windsor Solutions / 1.Identify/Analyze Data Requirements / 11/18/15 / 12 / $140 / $1,680
2.Design ICIS-Air dataflow / 12/9/15 / 140 / $140 / $19,600
3.Develop ICIS-Air dataflow / 12/30/15 / 182 / $140 / $25,480
4. Test ICIS-Air dataflow / 2/11/16 / 144 / $140 / $20,160
5. Implement ICIS-Air dataflow / 6/30/16 / 54 / $140 / $7,560
2. TEK Systems / Provide detailed NMED database schema to Windsor / 12/30/15 / 144 / $100 / $14,400
Contractor Travel / $2,000
TOTAL CONTRACTS / $88,880
NM GRT (7%) / $6362
D. TOTAL CONTRACTS w/GRT / $97242
E. TOTAL DIRECT COSTS (Sum of A-D) / $119,545
F.INDIRECT COST (23.25% of S&B) / $5185
TOTAL PROPOSED COSTS (Sum of E-F)
TOTAL PROPOSED COSTS (Sum of E-F) / $124,730
Contract Cost Estimates
The cost estimates are based on the number of hours of work that are estimated for consultant assistance with the following project activities:
IT Contracted Development - Provide Oracle database expertise and services to implement the ICIS-Air data flow.
Contractor travel cost estimates are included in the table above.
Indirect charges are included in the table above and at the current state fiscal year rate negotiated with EPA: 23.25%.
Exchange Network Priorities
NMED is committed to completing and implementing the ICIS-Air dataflow project by 2016. This Tier 1 priority project will improve the exchange of reliable high-quality environmental data from air quality databases in New Mexico to the EPA ICIS-Air data system, while also advancing Exchange Network objectives and priorities. NMED’s goal is to implement the ICIS-Air dataflow at the delegated state agency level. This goal will provide flexibility in accommodating a variety of data exchange scenarios and ensure stateless standards based dataflow with automated processes that minimize the need for manual steps in the workflow. NMED feels that it is essential to improve the exchange of reliable, accurate, high-quality data to the EPA national data system and to make critical data more readily available to support environmental decision-making. The ICIS Air-dataflow project is vital to NMED’s current data exchange goals. Due to the need for this project, NMED is committed and highly motivated to provide the deliverables outlined in this proposal and sustain the ICIS-Air dataflow system in the future. In addition to these important priorities, the NMED ICIS-Air dataflow project will also support all four of the Exchange Network’s Phase 2 Implementation Goals as this project demonstrates:
· The Exchange Network becoming increasing usable, efficient and sustainable;
· The Exchange Network becoming increasingly relevant and valuable to a broadening community of partners and consumers;
· The Exchange Network enabling better decisions through timely, accessible, and useful environmental information; and
· The Exchange Network and its partners having adequate resources for implementation, operations, and maintenance.
Total Project Budget and Goal-specified Costs
Goal / Estimated CostsTo Implement Tier 1 ICIS-Air dataflow for electronic data transfer of compliance data from delegated state agency database through Central Data Exchange to ICIS-Air / $124,730
Total Estimated Costs / $124,730
Updated for submission to the PCC: 9/16/15
Page 3