Davel Corporation (formerly People’s Telephone Corporation – PTC) is a company that owns payphones in many locations. They receive profit from telephone companies with whom they partner, and pay out percentages of call-generated revenue to the locations where their phones are housed. At the time of Artech’s solution, PTC had 23 different data sources from 23 different carriers with whom PTC had ongoing partnership arrangements. These included companies such as AT&T, MCI and Bellsouth. All 23 of them had to be put into a singular data warehouse.

Artech’s solution was to utilize Sybase tools to construct a data warehousing “pipe” to convert files from the “received state”, that is – the state in which they were received from the various carriers, and convert them into a common, categorized, formatted and mapped data exchange, which was fully automated. Having created this one data warehouse, Artech then processed the data, and grouped it into reporting tables, thus creating a staging area for the data to be sliced and diced for further functionality. These tables were then accessed for reporting.

The reports that were generated by the Artech reporting system allowed PTC to see how much it was owed by all of its various partner carriers, as well as how much was owed by PTC to the various locations that housed their payphones. Thus, Artech’s solution allowed PTC to achieve an immediate Return on Investment.

Shortly after Artech implemented this data warehousing solution for PTC, the company was acquired by Davel Corporation. In assessing the value of the various information systems under which PTC operated, Artech’s solutions were the only systems retained by Davel, praising them for their efficiency and money-saving capabilities. Thus, Artech once again showed that Return on Investment is the driving force behind all of the projects we build.