Building an intranet insurance software IT system
Hi, looking for a bit of advice/guidance..
The small insurance company i work for has recently implemented a new IT system, which basically has fallen flat on its ar5e! It's intended function is to quote for and incept policies, do mid-term changes, process renewals etc, as well as include an accounting module. Part of the system is web based so that customers can get quotes online.
Since it has failed, i am struggling to see why i couldn't just build such a system from scratch and make it exclusively online/web based. It's not a particularly complicated system, and doesn't even need to include an online payment feature (customers are agents and they pay on account). Additional features/functions will be available to in-house staff (decided by their login credentials) and reports/statements can be easily created with database queries. The only thing i would have problem with (i think) is the accounting package - which i was hoping i could just use a third party package and 'plug' it into the system via API.
Am i being naive? Are there other legal matters to consider such as strength of the security (data protection of client information) or how often the databases are backed up etc? Would this be far too great a project for one person to develop on their own?
Any comments appreciated.
Are there other legal matters to consider such as strength of the security (data protection of client information) or how often the databases are backed up etc?
No. But unless you can dedicate a fulltime job to it (e.g. 8 hours a day) then chances are it's going to take you quite a long time, notwithstanding the fact that this project will take you quite a long time anyway doing it on your own (I estimate a couple of months).
Would this be far too great a project for one person to develop on their own?
I think the biggest thing missing that you might not be thinking about is how to make the system dynamic. I recently built a fairly large database system for storing, accessing, and manipulating contact information, among many other things and I would hate to have to go back and delve deep into the code just because the company I built this for would like to be able to gather additional information about their contacts other than the fields that were put in the database initially (e.g. first name, last name, phone number, etc). So I came up with a method to make the system as dynamic as possible so I, hopefully, would never need to touch that code again aside from fixing bugs and adding additional features.
As a minor example, what if the formula you use to quote customers changes? Do you want to go back to the code and rewrite the formula, or do you want an administrator module where you can log in and specify how to weight certain information in order to come up with a correct quote? Might not be too difficult to build such a module, but it's definitely trivial.
It's not impossible to build it yourself, but extensive extensive planning is needed before you type a single semicolon.
Thanks aj_nsc, appreciate ur honesty.
Was actually planning on spreading this over 12 months so time is not so much an issue.
With regards to making it dynamic, yes i see how that would be the greatest challenge. I expect that things would change and new products be released and so would have to plan accordingly. Also rates change all the time so a separate 'rating' or 'rules' file would probably be in order which can easily be updated. OOP would be an absolute necessity which would facilitate future amendments or additions to the system.
Might give it a go in my spare time anyway, even if it doesn't work out, i'm sure the learning experience would make it more than worthwhile.
That's what I say about every project I do and underquote on. I'm still poor, but quite knowledgeable.
Originally Posted by pavsid
You didn't specify what type of insurance you were talking about, but I'm sure each industry has it's own security and confidentiality standards. Health insurance would likely be the most complex, but any time you're dealing with personal information you have to ensure data security.
Another thing to consider is that when you're developing this type of software, you need consider what the company will do if you leave. At minimum, you'll need strong developer notes so someone with the right skill set can come in and take over if necessary. That's one of the benefits of commercial packages.
Actually the insurance software should have the flexibility of customizations to match the specific needs of clients for achieving their business goal of good service and revenue generation. It is impossible to do on your own.
That's what they told the Wright Brothers...well they probably didn't tell them that exactly.
I would say go for it. The worst that can happen is it doesn't work and you learn a few things.
I would advise seeking information in relation to the DPA for your country.
use of normalized databases in this instance is an essential MUST have. This helps obfuscate the stored data, the program you write should be able to reconstruct the dataset from the available tables.
Some of the data I deal with is or rather falls in to what is referred to as 'sensitive material' and this type of data can be anything from medial records, personnel data, phone calls (recorded), internal faxes, emails and other elements. So you should be aware that the DPA also encompasses elements within the real world like documents.
Some types of documents have to be stored (on average) for Seven Years, in the other department I work in, most of the documentation I handle has to be stored for 15 years for legal reasons.
So you SHOULD get acquainted with (at the very least) the basics of what your legal requirements are in relation to data, storage, reproduction and use within the real and virtual realms.
DPA is not just about storage of data in databases on computers / servers.
I forgot to add that the data backups we do on electronic documents and databases have to be stored in a safe...
Last edited by \\.\; 08-29-2010 at 04:21 PM.
Yes, I know I'm about as subtle as being hit by a bus..(\\.\ Aug08)
Yep... I say it like I see it, even if it is like a baseball bat in the nutz... (\\.\ Aug08)
I want to leave this world the same way I came into it, Screaming, Incontinent & No memory!
I laughed that hard I burst my colostomy bag... (\\.\ May03)
Life for some is like a car accident... Mine is like a motorway pile up...
Problems with Vista? :: Getting Cryptic wid it. :: The 'C' word! :: Whois?
Some fair points guys, thanks, i havent as yet gone ahead with the project, as to do so would mean putting everything else aside for at least 6 months, but that's not to say I won't revisit it at a later date.
On a side note, can a system like this be developed using the Zend Framework, or should it really be built from scratch? I'm just learning Zend at the moment and am still unsure of it's benefits/restrictions...
Yep. That is what a framework does.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)