Monthly Archives: February 2006
Insurance Request and Software
Taking a new request for a life insurance is a very complicated process. One
of the most interesting things I find is how they ask these strange questions to
determine the probability of you killing yourself. But, even if it matters or
not, the whole insurance industry is built in probabilities. Nobody though
possible the catastrophe that happened in 2005 with the hurricanes for example.
An interesting thing I also find is the length of these forms. They always
have multiple pages and have a huge amount of fields. The majority of the time
the forms have to be filled in an office or desk or a table. Is almost
impossible to do it standing. But with the technology like Tablet PCs these
forms can be made electronic and be filled remotely (in the field). This is an
area, the insurance industry, that greatly
benefit from
BPM solutions. That’s why we have made a movie that represents a life
insurance form been automated with Procx.
A simple process was put in place for approving the form in which if the initial
insurance amount is greater than 50,000 then needs to be routed to a credit
analyst. Hope you like it.
See the movie
here.
A visit to Kinko’s
An interesting story and how an idea surged. A couple of days ago I had to go to
Kinko’s for
printing some pricing and marketing material for a customer I was going to visit
the next day. I asked for normal color printing with a special paper, something
that made it look good. This was in kind of a rush mode. I was on the trip and
visiting the client was a pure coincidence.
When the person in the front desk took my order, he took out the huge form (it
looks something like a poster for some movie or concert) and he fills it out
with my order request. I couldn’t understand anything he was writing but I know
there are a bunch of fields in the form. He entered the color preference, the
paper type, the number of copies, my name, address and phone number. After
finishing, he marks every field in the form with a green highlighter (I still
don’t know why is this). Then he takes the form and puts it in sealed bag (like
a huge Ziploc) and then calls somebody in the background to handle the new
request.
First, nobody answered. He didn’t know who was free to work and who was working
with something (and nobody was paying attention to him either). Then he needed
to copy my PDF files to the machine where the printing was going to be done. He
didn’t remember the files I just told him to print so I had to go back and point
him the files I wanted. I noticed that with every printing work they have, they
create a folder with the customer name. Inside the folder they create three more
folders: Original, Process, and Final. Then he placed my files in the original
folder. I think the folders mark the workflow that needs to be followed for
printing. I suppose it goes something like this: they first open the files in
the original folder, then edit them with some program for best printing (still
haven’t figured out what they edit; documents always have this blank border and
they say it’s impossible to take it out). Then they put the edited files in the
final folder.
After copying and filling the request and everything was done, he told me the
estimated time that everything will be ready and that’s it, ready.
When I got out I started thinking (in critique mode) the whole process. I said
why they haven’t done something more automatic for handling these request and
assignment. Maybe they would only need one person in the front taking the
requests and something behind prepares the environment of work and assigns the
right person in the back.
Using a workflow application would help them great automating the manual
process. And how they can do that? I came with something simple for the problem.
First I though the best way to port the paper forms to an electronic form was
InfoPath. In InfoPath you have the ability to create sections inside the form
and digitally signed them preventing these sections to be tampered (we don’t
need anymore the plastic Ziploc bag for protecting the form). One issue
resolved.
In InfoPath you can define an attachment field that allows you to attach a file
to the form. You can attach as many files as needed and they traveled inside the
form always. Now you can take the files needed for the work and attach them to
request. They are never loss and you just have to ask for them one time. Another
issue solved.
The form is going to be electronic in first place. You can publish it to a
SharePoint site for
example and have a central repository form them, allowing searching and
indexing. This is not an issue, but maybe would be a great add on.
And now for the workflow part. A simple process can be made for handling the
request form. You would have the start activity with permissions for only the
front desk person to start the process. Security. Then a second activity for
handling the input request form.
As an improvement, we could create a web service that generates a unique number
for the request. This can be the second activity in the process. The third
activity would be to assign this number to a field in the form. Next?
The next thing we can do is actually create another web service that creates the
folders they need for processing the files. We don’t need the first folder, the
Original folder, because the original files are already attached to the form.
The web service would only need to create the other two: Process and Final. A
good improvement would be to create them directly in SharePoint and have a
central repository for them.
The most important step would be the assignment of the request to one of the
back office personnel that actually executes the job. I though the best way to
do this was to use the workload feature. I could specify the personnel available
for this and assign requests on a one by one basis or a least busy basis. Then
let the software manage the work queue. Maybe every personnel in the back office
can have like a Pocket PC and they can receive their tasks and immediately know
their new assignments.
The final step would be to send an email to the front desk person notifying that
the job was finished. An improvement here we could consider is asking the
customer for his email and place it in the form. Then we can put another
activity in the process for sending an email to the client saying that his job
is finished (customer service improvement!!).
Now the whole process is automated. Errors in the process will be far less.
Security in the form cannot
be compromised. And we guarantee that every back office personnel are receiving
their tasks in a balanced way. The next phase for this would be to make another
web service for saving the information in the form to a database table for
future statistics and analysis.
A major thing? To simply enabled Procx
to receive the form requests via email and have the form publish to the
Internet. I can fill the form myself from my house and I only have to leave to
actually pickup the final work after I have received the notification. A simple
step towards the
electronic
enterprise. An example of how the process will look like is on the right.
SharePoint Workflow
I think SharePoint is one of the must have components everybody using Windows Server 2003 should have installed. As a free piece, the WSS version allows you to share files and collaborate with peers in the organization. It has document versioning capabilities in the web site and acts as central repository for document storage.
One of the coolest thing I find about it, is the integration with Microsoft Office InfoPath. InfoPath allows you to create forms that are routinely use in the business like purchase orders, expense reimbursement and management, vacation requests, etc. in an easy to use interface. Then you can publish these forms in SharePoint and every employee will be able to see them and fill them. Then you also have a central repository of forms.
The next step in this document and form collaboration environment is to add workflow or approval processes to these documents. That’s why we have made it easy to combine Procx and SharePoint workflow. Procx has features and activities for integration with SharePoint and InfoPath giving already established users of these platforms a huge return on their investments.
See more information about Procx and SharePoint here and see the movie here.
Procx 2.1 is out!
Today we have gone live with the new version of
Procx. There are some exciting
new features in the
product including:
- The ability to start a process from an email.
- Create Microsoft Word and Excel documents in the process.
- Start a process from a database table.
- Support for global variables.
Also an important offering we now have is the
services offering.
Now you can buy from our online store, besides the licenses you need for Procx,
also services like the creation of InfoPath and other type of forms, Web
Services for database integration and other related services, allowing you to
buy the whole solution and starting to benefit from Procx right away.
There are many other details in the product that will make the creation of
processes and flow definition event more creative.
We have also made available a series of movies where you can see Procx in
action and how the integration with SharePoint and InfoPath works. You can see
them here.