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.


  • Defense
    Soldiers from the Old Guard test the second iteration of the Integrated Visual Augmentation System (IVAS) capability set during an exercise at Fort Belvoir, VA in Fall 2019. Photo by Courtney Bacon

    IVAS and the future of defense acquisition

    The Army’s Integrated Visual Augmentation System has been in the works for years, but the potentially multibillion deal could mark a paradigm shift in how the Defense Department buys and leverages technology.

  • Cybersecurity
    Deputy Secretary of Homeland Security Alejandro Mayorkas  (U.S. Coast Guard photo by Petty Officer 3rd Class Lora Ratliff)

    Mayorkas announces cyber 'sprints' on ransomware, ICS, workforce

    The Homeland Security secretary announced a series of focused efforts to address issues around ransomware, critical infrastructure and the agency's workforce that will all be launched in the coming weeks.

Stay Connected