We require a database to operate our claims management business.
Brief outline of our business so you can understand what we will require from the database:
We have a call centre who are calling clients to see if they have any payment protection insurance (PPI) on any loans they may have had.
If the client expresses an interest we need a screen to capture the clients usual name and address details. There are approximately 14 fields that need capturing to access suitability of the claim.
One client may have a few loans with different people, so the ability to then process a few claims to the same client , so the outgoing pack will need to print 1 to 10 loan claims on 1 application. I will send the successful candidate a (MS word) pack that we are currently using which will make this easier to understand.
Once all the information is captured by the telesales agent.
The manager will then check that the days claims are eligible and then authorize the pack to be printed.
The database will then populate a word document and print the pack, the first page (letterhead) on a different tray than the rest of the pack.
The pack is then posted to the client who is to sign and return to us. We then check the pack is completed correctly and send it to the claims management company who will then start the claim.
The pack is then posted to the client who is to sign and return to us.
After four days it should prompt the telesales rep to chase the pack.
If the pack is still not received then after another four days the system prompts them again.
After another 7 days an auto generated letter is produced to the client.
Each of these stages are noted and updated to the client record.
We then check the pack is completed correctly and send it to the claims management company who will then start the claim.
After a period of time we will then be notified of the value of the claim and it’s validity. We will then enter the value on the database so we can run reports to see how much is in the pip line , by month, agent, data source etc.
Approximately three months later the client will then receive their claimed money and we will receive our commission. Obviously we will inform the database that the pack has been posted, returned and forward to the Claims management company.
We will require the system to be able show the status of each claim, by date range and by agent.
The agent are paid a commission on the pack being sent and when it is returned and the system should be able to calculate the agents commissions.
The initial database should have management information to interrogate the database, by data source, telesales rep, date, amounts, ………………………………..
I wish to work with a developer who will write the initial database and will agree on a fee for additional work to the system after installation.
22 freelancers are bidding on average $694 for this job
Hi Sir, Please allow me to work on this project and give you the best solution available in the market. Please check my PM for details. Thanks Varun
I have over 6 years experience in Database application development. I can develop applications in Oracle, Access or any other database, depending on Software License you already have.
Hi, We had already done somewhat similar work for our own BPO. I can do this work. Please provide me details and lets start the work. Thanks!!
Hi there, I am a London based database develpoer who has got an experience of over 12 years in tihs fied and am happy to deliver you the solution.
Hello, I have 14+ years of software development experience using oracle database and oracle developer. I will complete your task in oracle developer. Hope you will consider me for this project.