Develop a portal using drupal and third party CRM Package

Description: To connect a web page made in drupal to a CRM package. The CRM package uses Microsoft SQL Database and the schema for this database will be provided. The portal is where clients log in and can view details regarding their information with ourselves. They can edit this information. The PORTAL currently uses drupal as its framework and the form fields have already been built by myself, these are in standard html at present. The website is on a linux server, the CRM package is on an AMAZON cloud windows server. Deliverables: STAGE 1: Security and login: The site must be 100% secure. We wish the login system to be: 100% secure, SSL will be installed by myself, the username will be the customers email address which will need to come from the CRM database. There is also a field for the password to come from the CRM database also. The passwords may be changed by the user and this should use the drupal account pages. Page 1 – Personal details The personal details page is in the attached screenshot. The data from the SQL database needs to show in the form fields. The database must be updated if this information is changed and submitted. The page is attached as a screen shot. This form must update the CRM . Layout and structure of the portal is to be reviewed by myself and the winning developer. End of stage 1 Once this page is completed then we will sign off and start on stage 2/3/4 of the portal. Please only bid for stage 1. This work will be on-going as we build our portal. I wish to develop a relationship so the next stages can be completed over the next 3 months. Stage 2/3/4: If stage 1 is successful then the portal will be extended on over the next months. The portal is to be cutting edge and a mobile app will also be needed in the future. Stage 2/3/4 will include: Another 5 pages of data, Developing a mobile app An admin page for the users to select to receive email alerts, sms etc. An advanced contact email page with all previous correspondents showing Etc, etc.