A client needed a new employee benefits management system to
centralize human resource operations, minimize costs, and
improve the integrity of data being passed to its insurance
providers and partners.
Integrated Services was asked to design and develop a custom
application in less than 90 days. The new system had to be ready
for the next benefits open enrollment period.
ISI was engaged to manage and develop all phases of the project
from design to implementation. ISI provided a team of five
developers and a project manager to quickly begin design and
development.
The first key deliverable of the project was to create a
centralized relational database, a first of its kind for this
client – a company with independent operational business units,
containing more than 10,000 employees. For the first time, the
client could produce employee mailing lists, a company-wide
phonebook, and automated employee eligibility analysis from the
new database. The new system populated the database in two
different ways. The first is through an automated payroll system
interface and the second through manual entry from the multiple
departments and divisions within the company with “closed”
payroll systems
The client’s corporate benefits department also used the system
to enter and maintain the insurance provider and partner
information. The system was designed to be very flexible because
this particular client has contracts with approximately ten
insurance providers, all of which have their own interface
standards and eligibility requirements. The system produces
Insurance carrier exports that are emailed, faxed, or
automatically transferred to the carriers electronically via
FTP. In some cases, these files are very large, so ISI developed
an automatic process to compress, encrypt, and transfer the
files as part of the weekly process. Each insurance provider, in
return, provides a monthly claim extract file. The system has
the capability to import these files and process them in order
to allocate claim dollars across divisions at multiple levels of
the company.
