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 Ohio State University Alumni Association - IMPACT to AIM Database Synchronization
The Ohio State University Alumni Association was getting a new customer relationship management system name AIM. Data needed to be synchronized daily from an older non-relational database store (named IMPACT) to the relational SQL Server data store for AIM. Arisen served as the technical lead and managed the technical tasks and activities of the team that completed the IMPACT to AIM Database Synchronization project.
