 |
Project Sample:
Logistics Outsourcing |
A medium-sized logistics outsourcing firm needed a new way to track
their operations at 80+ customer locations. Each operation at each
location was considered a "transaction" that needed to be tracked from
beginning to end for billing. Across all customer sites, more than 1,000,000
transactions happen each year. Tracking and paying workers at each site
also had to be handled, because not only were the hours worked by each worker,
but also the transactions at the location figured into each worker's pay.
The customer started with a Visual RPG-based application that was impossible
to modify and used a very slow flat-file database. We started over and designed
a system based on SQL Server 2000 and VB.Net to track all transactions, produce
reports based on Crystal Reports, and record payroll information each week. Operation
speed significantly improved with the faster database, the resulting program was flexible
enough to allow each site to have its own set of payroll calculations (easily created
through Visual Basic by the customer), and the customer was able to save money
by eliminating their current payroll recording package.
And our cost at completion was half our nearest competitor's price without subcontracting
or using off-shore labor.
| Click on a picture to
see a larger view. |

The data entry forms used at each customer site to record transaction and payroll information. |
Click Here to Return to Main
Samples Page
|