New features / UI of a Python Django Google App Engine application to create email campaign via API

We send thousands of emails a month via SendInBlue to recruit persons, then we developped a small Django / GAE application to interface our old mysql system to SendInBlue (SIB) It works great but as we are migrating the old system on Google Cloud Platform, we need to adapt it and also we want to add new features. As the rest of the application is in Python / Django on Google App Engine, we would like you to continue the development on this stack. After awarded, we will give you the access of the existing code and also the environment of development. We want you to develop/adapt the following features (summary): 1/ create a "new campaign" page > For the moment, the campaign is created in the old system on mysql, and our app extract some data to store them in GAE datastore. > For a new sending, the UI is fed by a query in mysql DB and a query in the Datastore. > Then the user validates the sending, and our application creates the campaign in SIB, passing the list of emails and the email to be sent > After that, the UI is also fed by a query to SIB via its API to give some informations about the sending - We ask you to create a new UI to create the campaign directly in the application - The page will have some inputs, list connected to the mysql DB and a light email editor ([login to view URL]) - The campaign should be stored in the new mysql DB 2/ create a "search persons" page > For the moment, to select the persons for a campaign, we search in the old system, extract a file containing the list to import it in the old mysql DB, to then be queried by our application (so hard!!) - We ask you to create a new UI to search the persons in DB following some filters - The resulting SQL of these filters should be stored in the mysql DB (we don't need to store the result of the search, just the sql) 3/ adapt the existing "campaign" page > For the moment, the campaign page grabs data from differents DB and allows the users to launch a new campaign in SIB - We ask you to re-route the data sources with the new mysql DB 4/ adapt the existing "list of campaigns" page > For the moment, the list contains only links to detail page (the page 3/) - We ask you to present more informations from the DB in a standard grid list - The application is in bootstrap 3.0.3 with no extra styling - Screenshots and mockups could be furnished Skills needed and operational quickly: - Python / Django - Google cloud platform: App Engine / Datastore and MySql - Converting JSON to Relational DB model - HTML / CSS via Bootstrap 3 - Don't be allergic to French terms in code and comments :-)