Boston Pull

Description

This project was a data pull for a team I was supporting in Boston. They requird data to be pulled form server sources including excel spread sheets and the MarketQA database. In order to give the traders more flexibility in how their data was presented, I created a template language that allowed data to be imported from excel spread sheets, delimited text files, and the MarketQA database. The data could then be organized an exported to a delimited text file or an excel spread sheet.

Challenges

This was my first attempt at a production parser and compiler. Luckily I had a guy who studied compilers in by group who was able to help me quit a bit. It was also a challenge to inport data from excel files using Java. At this time, the firm was using excel 2003 which used a binary format to store spread sheet data. This meant that I had to use the Poi libraries to load the data. Sometimes it didn't work.

Results

This was a successful project an was used from the time I created it to the time the Boston team was disbanded.