SoftBase Systems, Inc (1994 - 2013)
In-house Phone Report Tool
Report for management which aggregated data from a long-distance phone company report file with our PBX's logs. Imported data from the PBX and phone company which was in flat files, using Perl, into MySQL for easier processing, and used the Java
poi classes to generate a spreadsheet. The most interesting aspect of this program was the fact that both phone logs had no common key, and the two files had to be matched by the timestamp of the calls. The implementation was surprisingly good at guessing the matches.