I’m developing an automated feedback system to integrate with Salon Iris salon management software. Salon Iris is built on an Microsoft SQL server database that runs locally. The database stores information about clients and services performed. It is continuously updated as the salon runs.
The feedback system is designed to collect information from clients about the quality of the service with the salon. It will store information in an independent instance of MySQL running on a web server – NOT on the MS SQL server storing information for Salon Iris. In broad strokes, the feedback system will do the following:
1) When a new service ticket is closed in the MS SQL (Salon Iris) database, a script will be activated that sends the client a client experience email. The client experience email asks the question ‘Based on your last experience at the salon, on a scale of 1-10, how likely are you to recommend us to a friend, colleague, or family member?’
2) The previous email provides numbers from 1-10 that are links. When the client clicks a link corresponding to the number they selected (from 1-10), their response is logged in the MySQL feedback database.
3) Once a client clicks a link, they are taken to an external form that asks them to provide more feedback. The form they are taken to depends on their answer to the client experience question. If they answer between 1 and 6, they are taken to a form asking them to elaborate on why the service did not meet their expectations. If they answer between 7 and 8, they are taken to a form asking them how we might change things in the future to better meet their expectations. If they answer a 9 or 10, they are brought to a page inviting them to either submit private feedback or write a review in exchange for a reward towards their next service.
4) Their response to form questionnaire is also logged in the MySQL database. Once a client logs a response in the MySQL database, an email is sent to salon staff notifying them of the feedback with different subject lines depending on the client response: 1-6: ‘Warning! First name last initial is unsatisfied with their service’. 7-8: ‘First name last initial is neutral about their service’. 9-10: ‘Congratulations! First name last initial is very satisfied with their service’. The feedback email that is sent to salon staff will also contain a link to view the full details of the service that was performed as well as any additional feedback that was provided in the submitted form.
What is described in the four steps above will be the initial features of the minimally viable product. There will be more development in the future to flesh out the product and add more features.
I am looking for a back-end developer to lead the development of this customer experience platform. You will need experience working with PHP, MySQL, MS SQL, and HTML, etc... as well as experience designing databases.
Beyond your technical expertise, you should also be a self-starter with the ability to lead projects and work independently.
Please include relevant experience with your application and a short description of why you should be selected to lead development.