Small Business CRM Project/Automation Project
4771
$$
- Posted:
- Proposals: 14
- Remote
- #64673
- Archived
Front End / Web & Mobile android ios App Developer / Responsive Web Design / WordPress Specialist / Open Source / ASP.NET using C#, VB.NET / single page apps using angular, vue.js, react, node.js etc
Mumbai
java j2ee ejb struts spring SAP hibernate mysql oracle javascript jquery j2me expert c# sql server javascript html5 jquery vb.net vb6 asp.net Php based CMS , Paypal , Squarespace
Chandigarh
53639672157512985043859868782212964314194015464311119111062120468
Description
Experience Level: Intermediate
ESI Electrical are a small electrical contractors based in the South East of England. We have noticed a lot of our business processes involve data entry of the same information upto 7 times. We would like to develop a crm system with a few key enhancements designed for our industry. Automating as much of our information as possible, with a single point of reference will give us the competitive edge.
The service side of our industry is based on engineer visits every 1,3,6,12,24 months, so we need to be able to query reports as to clients due engineer visits for different services, and run reminder letters merged from crm data at the tough of a button.
Key areas to our crm system will be as follows:
1) CRM system
- Client Info Screen, Notes Screen, Survey Screen,
2) Correspondence Screen
providing merge out of data from contact to templated documents into microsoft word or google docs. Also provides a single point of reference for all documents for the client, both produced from the system and attached/linked to from existing files
3) PAT Testing Report Production module
We have an existing access database that uses information from our engineers palmtop computers, to populate templated excel and word documents, we want to improve this and build it into the new database
4) Work Reporting
Using data in the survey field of the CRM, we require a feature to provide a master report of \'service visits due\' for each of our service areas. We also require the ability to produce a reminder letter run, at the touch of a button, merging out the letters for \'services due\' to word documents or PDF documents.
For more information please see the attached PDF\'s, i\'ve tried to put as much information as I can into the specification. Attached is also a copy of our existing access database. You will need to email me for another raw data file, to see how the access database runs. There is also a copy of the Access Database output file, so you can see the end result.
We run a windows 2003 sbs server, with SQL server and IIS6 in house. Solution can be web-based, access based or a mix of the two.
Any questions please feel free to ask. We are a small business so we dont have a blue-chip budget.
The service side of our industry is based on engineer visits every 1,3,6,12,24 months, so we need to be able to query reports as to clients due engineer visits for different services, and run reminder letters merged from crm data at the tough of a button.
Key areas to our crm system will be as follows:
1) CRM system
- Client Info Screen, Notes Screen, Survey Screen,
2) Correspondence Screen
providing merge out of data from contact to templated documents into microsoft word or google docs. Also provides a single point of reference for all documents for the client, both produced from the system and attached/linked to from existing files
3) PAT Testing Report Production module
We have an existing access database that uses information from our engineers palmtop computers, to populate templated excel and word documents, we want to improve this and build it into the new database
4) Work Reporting
Using data in the survey field of the CRM, we require a feature to provide a master report of \'service visits due\' for each of our service areas. We also require the ability to produce a reminder letter run, at the touch of a button, merging out the letters for \'services due\' to word documents or PDF documents.
For more information please see the attached PDF\'s, i\'ve tried to put as much information as I can into the specification. Attached is also a copy of our existing access database. You will need to email me for another raw data file, to see how the access database runs. There is also a copy of the Access Database output file, so you can see the end result.
We run a windows 2003 sbs server, with SQL server and IIS6 in house. Solution can be web-based, access based or a mix of the two.
Any questions please feel free to ask. We are a small business so we dont have a blue-chip budget.
Jamie M.
99% (18)Projects Completed
34
Freelancers worked with
29
Projects awarded
17%
Last project
4 Nov 2021
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies