Florida Node 1 Implementation

1
Florida Node 1Implementation

• By Bernardo Telles
• Florida Department of Environmental Protection

2
Project Overview

• Implemented FRS and SDWIS Dataflows
• Fully funded by EPA grant
• Resources (part time)
• 1 contractor
• 3 in-house developers
• Forecasted project completion date 6/6/2008

3
Maines Partnership

• Provided Java/Oracle Node implementation
• Subtracted 85 of code time
• Required migration from Oracle 9.0.4 to 10.1.x
• Very well documented code
• Time to setup exchange network node
• 38.5 hours

4
SDWIS and FRS

• FRS
• Forecasted completion6/6/2008
• Total developer hours1364 hours
• Main differences
• number of databases to integrate
• Loss of expertise required more data cleanup
  efforts

• SDWIS
• Completed on 2/18/2007
• Total developer hours253 hours

5
Data Quality or TPA

• Within last 9 months we realized we could not
  address all data quality issues AND enter TPA
  with EPA.
• Mainly due to employee turnover and lack of
  expertise
• Management took Data Quality route
• No use in sharing data bad data
• Cleanup/integration tools
• Dataflux
• Oracle Data Integrator

6
Lessons Learned

• Data quality was below our standards, and could
  have been assessed as higher risk.
• In the future program heads will lead Node data
  integration effort, not corporate IT.
• Underestimated amount of intimate data knowledge
  required to complete project
• Data stewards and owners may need to work with
  Dataflux of Oracle Data Integrator in the future