build a excel platform -- 2
£18-36 GBP / hour
We need an excel fully automated program for the insurance industry that can carry out the following system functions:
1) Excel to receive an adobe presentation from admin staff for 2 products Rural Combined and Rural Motor. Both products will contains a lot of data e.g. policyholder details, risk information e.g. names, dates of birth, property information, (risk addresses, sums insured) motor vehicle details, claims and convictionss.
2) the risk information is extrapolated from the adobe document (presumably into a CSV file and automatically driven into an excel rating calculator where it will undergo a number of functions to calculate a premium based on a set underwriting criteria where there will be rates built into the system The document will then produce a premium.
3) The information is then merged back into an adobe template (Quote Schedule) e.g. the original information from item 1 which will include the premiums quoted which will then be emailed back to the original sender with a contract certain quotation
4) all completed quotes to be automatically stored into a database (within excel) with a dashboard created where underwriting staff can view every quote and if needed can amend individual quotes or click a button to proceed on cover. Any quotes that have been accepted and proceed on cover all premium data to be transferred into a monthly sale 'insurer bordereau' which will be closed off at the beginning of each month and sent to the insurer summarising all live transactions posted on the account.
5) The ability to process Mid term changes to existing live policies using the same rating methods
6) The platform should include functionality for creating interactive dashboards. The platform should include advanced data collaboration features such as real-time editing and version [login to view URL] of the above driven by a sales dashboard (at the front end) that can process many functions and calculations whilst ensuring all data is stored safely and can run reports or complete audits which will be available to the insurer to ensure that our rationale is fully explained as to the suitability of the risk and we have stayed within the existing controls granted by our delegated underwriting authority agreement.
The platform may need to support importing data through APIs.
The platform should differentiate between admin and user roles to control access to various functionalities.
The dashboard should include detailed analytics, comprehensive reporting, and advanced audit capabilities. The premium rate updates should be fully automated within the system. The platform must adhere to high-level compliance standards, ensuring data security for sensitive information. The platform should allow customizable formulas for premium calculations. Comprehensive training sessions and ongoing support will be provided to ensure users can fully utilize all platform features.
The platform should include basic charts for data visualization. The system will automatically extract data from the Adobe document without manual intervention.
Project ID: #38796641
About the project
50 freelancers are bidding on average £28/hour for this job
I understand the complexity and importance of building an automated Excel program for the insurance industry, as outlined in your project description. Your need for a system that can seamlessly handle data extraction, More
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are look More
Are you looking for an Excel expert who can simplify complex data management and automate your workflow? Look no further! I am Akriti, a versatile professional with an impressive command over Google Sheets, Excel, and More
Greetings! I'm Adel, an experienced data visualization expert with a passion for creating intuitive and visually compelling solutions. With my extensive background in Excel automation and dashboard development, I'm con More
Since 2000 I have been working on Visual Basic (VB6 and VB.NET) and MSSQL, and MS Access MDB. Also Excel spread sheet. So more than 20 years of experience in Visual Basic to build any kind of Windows application. I hav More
Dear Steve ., I am excited about the opportunity to collaborate on this project and am committed to ensuring your complete satisfaction with the final outcome. Our team consists of experienced professionals who More
With over a decade of experience in backend and frontend web development, I've acquired the necessary skills to build the robust and highly automated Excel platform your insurance company needs. My expertise with Yii2 More
As an experienced and versatile software engineer, I've advanced expertise in Data Processing and PHP, making me an ideal candidate for delivering a robust, fully automated Excel program tailored to the insurance indus More
As a seasoned Software Engineer with a proven history of developing innovative solutions to boost business productivity, I am confident in my ability to deliver the expertise and creativity your project requires. I spe More
Hello Greetings Of The Day We are a Great fit because we have been working in the IT industry for 8 Years we have Experienced and quality developers in our Team and We have been serving and making our clients happy and More
Hi, We went through your project description and it seems like our team is a great fit for this job. We are an expert team which have many years of experience on PHP, Visual Basic, Data Processing, Data Entry, Excel More
