This client specializes in managing executive relocation for major businesses around the world. Unfortunately, it lacked a wide-ranging tool necessary to track and monitor every stage of the relocation process.

What was needed?

The system that this client was looking for would keep track more than 1,000 data elements–one that could be accessed by their local and remote sites with the least amount of change to their client’s PC environment.

The Solution

Specifically, they needed a system that would:

Permit an unlimited number of client companies.Track divisions within each company.Allow unlimited tiers in each division that employees could belong to.Allow unlimited items authorized by the company on each tier Track as many transferees, and as many individual moves by each transferee, as needed . Handle an unlimited number of services that may be offered to the transferees, such as selling and buying houses, language training, permanent storage, claims, moving of cars, boats, pets and more. Keep a date template to be used to track pack, load and deliver dates for any relocation. Provide an activity/to-do/notes system that would be an integral part in organizing and scheduling individual tasks. Handle international relocations with minimal changes to security. Contain lookup tables and data validations sourced by system tables and templates.

Major Challenges

Upon the initiation of the project, DHTML was in its infancy. We decided to develop the tools and business logic to put all the pieces of this n-tier based application together. We did a major portion of the development on initial beta versions of IE 4.0 and MS SQL server 7.0. We encountered some unpredictable results due to the beta versions. Nevertheless, we overcame those challenges by writing the tools ourselves.