Core Recoveries outgrew their custom built Access Database that was used internally for various business processes. The reliability and scalability of Access became too much of a limiter that they decided to convert over to a Sql Server database.
McRae Technologies, LLC was able to take the opportunity to refactor and normalize the data structure to ensure data accuracy moving forward as well as performance. Once the new data structure was established, we wrote an Extract, Transform, Load (ETL) process to get old data from Access into the new database. Once the new database was populated, we were able to create a new web-based user interface so the Core Recoveries team could manually enter data as well as write their own custom reports on against the back-end.