To address the challenges, the team at Sky Solutions decided to assume the worst-case scenario and began mapping and developing for the migration of all case types. This proactive approach enabled them to be prepared when the business ultimately decided to migrate all case types, excluding closed grants. They maintained constant communication with Subject Matter Experts (SMEs) from GMS and NexGen to understand their systems, while collaborating with the Integrated Grants Management System developers to gain insights into the new system’s development. The team attended sprint review demos to stay updated on new functionalities.
Spreadsheets were created to map processes and data elements between GMS, NexGen, and the Integrated Grants Management System. The team worked closely with the business and SMEs to address missing data issues. They informed the business that they needed to work from a static system, building a data migration application on the last deployed version of Integrated Grants Management. This required halting all development at least one sprint before the system went live to incorporate the latest changes.
To address challenges to their approach, the team patiently explained why their method would work and why alternative approaches would not be effective or would slow down the data migration process. They often had to implement these alternative approaches to demonstrate their ineffectiveness, ensuring the success of the data migration.