O'Rourke Bros Distributing
San Juan, Puerto Rico
Ships refrigerated goods to Puerto Rico
Challenges:
- Used a customer built FileMaker® application for job cards -- no longer supported.
- No way to track units received from DirecTV -- units were lost.
- DirecTV beginning to demand electronic relationship.
- No accounting system to pay technicians or vendors.
Mission:
- Replace FileMaker® application.
- Develop an inventory control system.
- Develop a technician dispatch system.
- Set up electronic file transfers between DirecTV and O'Rourke.
Our Solutions:
- Developed a Job Card tracking system using Microsoft Access®.
- Developed a Receiving and Delivery system to track units from DirecTV.
- Developed a dispatch system to assign technicians to jobs.
- Set up electronic file transfers between DirecTV and O'Rourke.
- Developed a technician and vendor payment application.
