Modernized FEMA system still has legacy data issues

Shutterstock image ID: 738923143 Editorial credit: bakdc 

Even though the Federal Emergency Management Agency's modernized flood insurance system works very well, it is still fueled by flawed legacy data, according to a Department of Homeland Security Office of Inspector General report.

A legacy system that takes in flood insurance data from insurers and tracks claims and policies has dramatically reduced claims processing times from two months to almost real-time, said the report. Despite the new system's speed, the data the system manages didn't get the modernization treatment, according to the report.

FEMA's Federal Insurance and Mitigation Administration began modernizing the National Flood Insurance Program (NFIP) system in 2018, moving to a new web-based processing system called "PIVOT," over the last couple of years.

That modernization work continues. In mid-October, DHS signed a $135 million task order under the General Services Administration's Alliant 2 governmentwide acquisition contract with ACE Info Solutions for product development and enhancement, data analytics, end user support, program management, and security.

The NFIP was retired in 2019 and was showing its age, according to the report. It had included almost 20 mainframe batch systems, subsystems and dozens of other local area network systems, it said. The systems were not fully integrated, but were interoperable, chugging along for all those years, according to the report.

The NFIP took in claims data from insurance companies and "write your own" policies that allowed them to interpret rules to create their own flood insurance policies.

That's where the system ran into data quality issues over time, according to the report. Insurance companies interpreted the rules in different ways. Those differences resulted in NFIP data that was historically flawed because of the system's slow reconciliation processing that approved or rejected policies.

The DHS OIG report lauded the PIVOT modernization effort, but in prioritizing the system modernization, FEMA neglected to solve the "longstanding data reliability issues" that transferred from the old system.

It said Federal Insurance and Mitigation Administration moved the "vast majority of its historical legacy data, including errors, into the PIVOT system." Additionally, the report PIVOT was deployed without controls to prevent erroneous transactions from being taken up by the system.

"These issues remained unresolved because [the Federal Insurance and Mitigation Administration] prioritized system modernization over time-consuming efforts to fix historical data errors," it said.

The report recommended a strategy to hold PIVOT vendors accountable for correcting transaction errors and improving data quality on the system. It also recommended making data quality assessment part of PIVOT's modernization reviews and reports, as well as make users aware of the data issues in NFIP-derived data on the system.

FEMA concurred with the recommendations, but explained it has taken steps to hone PIVOT's data and notify users of the issues. The system, it said, has built-in capabilities that allow it to review individual transactions and track remediation, if needed.

The agency said it will include PIVOT submission quality metrics in its operations reviews beginning in FY 2020. It also told the DHS OIG that PIVOT reports contain cover sheets, data dictionaries, and data disclaimers qualifying the use and source of the data in the system.

About the Author

Mark Rockwell is a senior staff writer at FCW, whose beat focuses on acquisition, the Department of Homeland Security and the Department of Energy.

Before joining FCW, Rockwell was Washington correspondent for Government Security News, where he covered all aspects of homeland security from IT to detection dogs and border security. Over the last 25 years in Washington as a reporter, editor and correspondent, he has covered an increasingly wide array of high-tech issues for publications like Communications Week, Internet Week, Fiber Optics News, tele.com magazine and Wireless Week.

Rockwell received a Jesse H. Neal Award for his work covering telecommunications issues, and is a graduate of James Madison University.

Click here for previous articles by Rockwell. Contact him at [email protected] or follow him on Twitter at @MRockwell4.


  • Workforce
    Shutterstock image 1658927440 By Deliris masks in office coronavirus covid19

    White House orders federal contractors vaccinated by Dec. 8

    New COVID-19 guidance directs federal contractors and subcontractors to make sure their employees are vaccinated — the latest in a series of new vaccine requirements the White House has been rolling out in recent weeks.

  • FCW Perspectives
    remote workers (elenabsl/Shutterstock.com)

    Post-pandemic IT leadership

    The rush to maximum telework did more than showcase the importance of IT -- it also forced them to rethink their own operations.

Stay Connected