The Ohio Housing Finance Agency (OHFA) has a goal of reducing and eventually eliminating homelessness in Ohio. Arisen helped OHFA define and collect anonymous cross-system data related to people receiving homelessness services across the state of Ohio. We designed and implemented the Ohio Housing Services Data Warehouse and the SSIS packages that import, transform and load data into the data warehouse. We are creating cubes, SSRS reports, and interactive Tableau reports to help analyze trends, identify mobility patterns, and assess the impact of investments in housing and human services to inform funding and policy decisions on the state and local levels.
The ReCasa Loan System is a loan processing system used by the ReCasa staff to assess new loan risks, track loans and interest, perform invoicing, apply payments, produce reports and administer short-term rehab loans.
ReCasa asked Arisen to upgrade the system that was origionally built by Arisen in 2004.
Arisen upgraded the database from SQL 2000 to SQL 2012, upgraded from .NET Framework 1.1 to .NET Framework 4.5, helped moved hosting to Amazon AWS cloud.
ReCasa's New Deal Worksheet was converted from an ActiveX VBA Excel workbook embedded in the web application to an Excel document-level application using C#.
Arisen upgraded and enhanced security in .NET application, optimized the invoicing process and enhanced the fee and payment posting processes and added batch fee support.
