I was asked to build a program that could use an API that was built into a VOIP phone system that contained a server. The phone allowed its call records to be polled. This allowed managers to observe the call logs of their call center employees.
The program was available on mobile devices but was designed specifically to be viewed on large televisions located in the call center. The idea was that the employees were working towards a daily goal. As the goal approached their name would switch colors until it finally became green. Each call was a point and closed sales would increment the value by a variable set by the owner.
Later I was asked to modify the program allowing it to use another phone system. This phone did have a server, but was not designed for polling the way the previous phone was. I had to improvise. I was able to poll the phone and populate the database as before. The phone system now rotated between multiple pages of call center employees.
The new company had 3-times as many employees and the phones exported a large amount of data with each request. The data needed to be searchable, but luckily not the same day the data was pulled in. So, I wrote a CRON job that ran in the evening that optimized the data and placed it into a separate set of tables specific for sorting and searching.