Legacy CMS (Newscoop/Campsite) to Drupal 9 content Import

I am looking for someone who has experience of migrating content into Drupal8/9 from legacy CMSs and knows how to import data as 'paragraphs' which is a new feature in D8/9.

You will need to work with a legacy mySQL database (a sample is attached - some of the mySQL tables will need to be left or right 'joined' before they can be converted to CSS - for example, there for article authors there is the name, photo and description). You will also need to know how to import images into the images paragraph type, article galleries into the article galleries paragraph type, import or convert created and published dates so they are compatible with D8/D9. The other requirement is for article URLs to be preserved OR redirected using the Drupal redirect module.

A sample database (please note this has been uploaded as a .txt file so you will need to change the extension to .sql) from the existing CMS (Newscoop/Campsite) is attached, although it may also be possible to (a) use PHP Smarty to create a table that lists all of the fields that need to be imported into Drupal 8/9 and is then saved as a XML and converted to CSS (it is possible, for example, to use 'gimme' in Smarty to get most of the information - see http://sourcefabric.booktype.pro/newscoop-42-cookbook/gimme-all-your-lovin/, and it is also possible to print out the article URL/uri also by getting it with gimme - see http://sourcefabric.booktype.pro/newscoop-42-cookbook/gimme-all-your-lovin/

The project is not huge as there are approx. 5,500 articles that need migrating.

Some of the articles have html/font/paragraph formatting so if it is possible to use something like preg to match and remove formatting and simply replace it with tags that will show up in the html/back end but not the front end, that will also be perfect.

If you have no experience of doing Drupal 8/9 imports please do not apply as I need the work done quickly by someone who knows what s/he is doing!

I will provide you with the actual source mySQL database which has identical columns to the sample below, and access to the destination Drupal website.