A Rapid Finance Transformation for a HUD-Funded Housing Authority: From Data Migration to Knowledge Transfer.

About the Client

Wilmington Housing Authority is the principal public housing authority serving the City of Wilmington and New Castle County, Delaware, and the state’s largest direct provider of affordable housing, serving thousands of low-income households through public housing units and Housing Choice Vouchers funded by HUD. WHA has been recognized nationally for its affordable housing work, including a HUD Choice Neighborhoods Implementation Award of up to $50 million, granted alongside major housing authorities in Birmingham, Atlanta, and Pittsburgh to help transform low-income neighborhoods. WHA works closely with an affiliated nonprofit developer that develops and manages additional affordable housing properties under shared agreements with WHA, including cost-sharing, loans, and fund transfers between the two organizations.

Industry Context

Public housing authorities operate under strict HUD financial reporting, budgeting, and audit requirements, often while running on aging financial systems and lean finance teams. Like much of the public sector, housing authorities are also contending with the retirement of long-tenured staff who carry deep, undocumented knowledge of agency-specific financial processes, making proactive knowledge transfer as important to operational continuity as modernizing legacy financial systems and workflows.

Current Situation

Iknow was already engaged with WHA on a broader strategic plan implementation initiative when WHA’s Chief Operating Officer asked Iknow to define a focused Finance Strategic Alignment Project addressing urgent needs in the finance department. The project kicked off in late January 2026, with eight short-term goals defined for an initial 60-day window running through March 31, 2026.

• A hard system deadline with no room for error. WHA’s legacy Elite financial platform needed to be fully decommissioned by the end of February 2026 to avoid an expensive contract extension, requiring complete data migration and validation into WHA’s newer PHA-Web system.
• Inconsistent, undocumented allocation methods. WHA’s cost and salary allocation methodologies contained significant gaps, including incorrect labor classifications and inconsistent management fee structures across WHA and its affiliates.
• A compressed, high-stakes budget deadline. The FY2027 budget needed Board approval and submission to HUD by March 31, 2026, but was still built on an error-prone legacy spreadsheet with broken links and calculation errors.
• A growing invoice backlog. Broken procurement, contracting, and invoice-approval workflows had allowed a backlog of unpaid vendor invoices to accumulate.
• Irreplaceable knowledge walking out the door. The Controller who held most of WHA’s institutional knowledge of its financial business processes was set to leave on March 31, 2026, the same day as the budget deadline.

• Complete the data migration from Elite to PHA-Web and decommission Elite before its contract renewal deadline.
• Establish an agreed methodology for cost and salary allocations.
• Rebuild the FY2027 budget and secure Board approval and HUD submission by March 31, 2026.
• Eliminate the backlog of unpaid vendor invoices by fixing the underlying procurement workflows.
• Reconcile WHA and its affiliate’s shared agreements, payments, and loans.
• Capture and document the outgoing Controller’s institutional knowledge before her departure.

How Iknow Structured the Work

Iknow translated WHA’s priorities into eight short-term goals for the initial 60-day phase, then broke each goal into a weekly sprint task list with clear RACI ownership across the Iknow team, WHA’s finance and procurement staff, and outside advisors, tracked through biweekly status reporting to WHA leadership.

Key Activities & Decisions

• Legacy data migration. Iknow coordinated with WHA’s systems team to complete the outstanding Elite-to-PHA-Web migration and validation, finishing in time to decommission Elite and avoid an unnecessary license extension.
• Allocation methodology review. Iknow reviewed WHA’s cost and salary allocation methods, identified gaps such as incorrect labor classifications and inconsistent management fee structures, and worked with WHA’s outside accounting firm to adopt a sound interim methodology for the FY2027 budget.
• Budget tool rebuild and approval. Iknow built a simplified Excel-based budgeting tool and salary allocation dashboard, corrected the underlying data, documented budget assumptions, and guided the FY2027 budget through Finance Committee review and full Board approval ahead of the HUD deadline.
• Invoice backlog resolution. Iknow helped diagnose and fix broken procurement, contracting, and purchase-order workflows in PHA-Web, enabling WHA’s finance and procurement staff to clear the backlog of unpaid invoices.
• Affiliate reconciliation. Iknow reviewed WHA’s management agreements with its affiliate, compiled the loans, transfers, and shared payments between the two organizations, and reconciled them into the budgets and financial statements.
• Structured knowledge capture. Iknow developed an interview guide and a RACI matrix template, then conducted structured knowledge-debriefing sessions with the outgoing Controller to document WHA’s core financial business processes.

Stakeholders & Collaboration

Iknow served as prime contractor, working directly with WHA’s Chief Operating Officer, Executive Director, Finance and Procurement departments, and PHA-Web systems team, and coordinating with WHA’s outside accounting firm throughout the engagement.

Converging Deadlines With Zero Margin for Error

The Elite contract deadline and the HUD budget submission deadline landed within weeks of each other, leaving no room for schedule slippage on either. Iknow addressed this by organizing the engagement into tightly managed weekly sprints explicitly prioritized around these two hard deadlines.

A Small Finance Team Pulled in Too Many Directions

WHA’s finance staff were simultaneously supporting property audits, budget preparation, invoice backlog reduction, and the Controller’s transition, on top of regular operations. Iknow addressed this with a RACI-based work plan that clarified ownership across every workstream and ran knowledge capture as a dedicated parallel track, so it did not compete with deadline-driven work.

Quantitative Outcomes

• System migration completed: Elite fully decommissioned on schedule, avoiding an unnecessary contract extension.
• Budget approved and submitted on time: FY2027 budget approved by the Finance Committee and full Board, and submitted to HUD by the March 31, 2026 deadline.
• Invoice backlog eliminated: Broken procurement workflows in PHA-Web repaired and the backlog of unpaid vendor invoices cleared.
• New tools delivered: A simplified Excel-based budgeting tool and salary allocation dashboard built and transferred to WHA’s finance team.
• Affiliate accounts reconciled: Shared agreements, payments, and loans between WHA and its affiliate reconciled into the budget and financial statements.
• Knowledge captured: Structured interviews and RACI documentation completed with the outgoing Controller ahead of her departure.

Qualitative Outcomes

WHA came away with accurate, validated financial data consolidated in a single modern system, a documented and repeatable budget process, cleaner vendor payment workflows, and a smoother leadership transition with substantially reduced institutional risk. The knowledge captured from the outgoing Controller gives WHA’s finance team a documented reference for core financial processes that previously existed only in one person’s experience.

Timeline to Impact

Within a seven-week engagement, Iknow helped WHA hit two hard compliance deadlines at once, modernize its financial data platform, and transfer critical institutional knowledge before it could be lost, leaving WHA’s finance department on stronger footing heading into the new fiscal year.

Core Skills

• Public-sector financial process transformation
• Legacy financial system data migration
• HUD budget development and compliance reporting
• Knowledge retention and succession planning

Methods & Frameworks

• RACI-based sprint planning and weekly work management
• Structured knowledge-capture interviews
• Biweekly status reporting and milestone tracking

Technologies & Tools

• PHA-Web public housing ERP platform
• Microsoft Excel-based budgeting and allocation tools
• Legacy financial system (Elite) migration and decommissioning