The customer’s goal was the modernization of an old legacy on premise ERP system. The system’s client needed to be installed on every single PC and kept up to date. The system relied on an on premise data base server that needed to be monitored and maintained. The system was slow and needed a high budget for maintenance. We acted as technical lead for the data migration project from legacy to cloud and made migrated the data completely into the new cloud system.
Challenge
In the finance industry accuracy is of utmost importance. It depends heavily on the implemented software how fast customer demands are met and how effective employees can work. It is a big challenge to replace the core ERP system because it is mission critical. The proposed new cloud based system offered many advantages. So the customer made the decision to move the legacy data and apps into the cloud.
Solution
With daily scrum meetings we made sure that the planned tasks stayed on time and the product owner was up to date and involved at all times. It was crucial to have access to the domain knowledge of the customer’s key team members on a daily basis. On the technical side we implemented ETL processes to extract data from the old systems. Then we transformed it into a format that new system could process easily. After the migration we run many tests together with the business users to ensure that all loan calculation and key KPIs are still correct. Finally we built reports and dashboards based on the data of the new system.
Result
The new system has many advantages. For instance after the data migration from legacy to cloud all the clients have zero footprint installation, which means the system is accessible via a simple webbrowser. No more client installations are needed. In addition the license costs and support fees of the new system are less. The new system is easier to learn and faster to access. Alphaquant helped to realize this extensive and important project.
Technologies
ERP, ETL, SQL, Batch-Jobs, Azure