What was the scope of their involvement?
We needed to transfer all of the information we had from a different program into the database. It took a long time to do that because we needed the history of all of our invoicing.
With the new system, our lease specialists check on the leases that we pay monthly, quarterly, semi-annually, and yearly. The system needed to indicate when they were paid and move the date forward. For a yearly lease, it would move the date to pay the next time ahead so that it would always be up to date. It was fantastic because our lease specialists could create a lease change request. They would send it to our general manager for approval. Once it was approved, all the changes were automatically put in the database, and nobody had to do anything.
In addition, if something needed to be paid or addressed, a change request would be emailed to the person that would either make a payment or complete a task manually.
We have leases that have special deals in the system. For instance, we can’t have a competitor on the billboard that’s on their property. Messages like these had to be communicated to the other departments. When we created a contract, these details needed to show on the right-hand side. We have some billboards that have top mounted lights. Extensions cannot be put on top mounts because they might run into the light. There are many tiny details that we need to keep track of about each of our locations. Also, if we need to schedule work to be done the next time that a seller is in the area, then we put that information in, and the system sets up a reminder. We can create work orders in the database, and the database pulls all the information from the location and also the customer on the location. It will pull the picture of the location and what it looks like. For instance, with the work orders we have for installs, we show the last install picture and then the picture for the install that is pending. When we input the customer, if they need both an approach shot and a close-up shot, we can toggle back and forth. It’s amazing.
A report is sent to our salespeople every morning that says what was sent to print, what was shipped back to us, the approximate install date, and when it was installed.
What is the team composition?
I work with David (Principal & Senior Developer, Daylight Studio).
How did you come to work with Daylight Studio?
After contacting a few other agencies, we asked Daylight Studio. They did such a great job for us on our website, and they were up for the challenge. David had not done anything this extensive before, but he was able to give us great advice.
What is the status of this engagement?
We started working together in December 2014 and the work is ongoing.