Canada Post Integration

The Canada Post integration project required us to integrate postal services offered by Canada Post into an existing application that calculates rates for packages based on different carriers and destinations.  The challenges were to implement logic to create relational db tables from flat excel files that were then used to calculate rates for domestic (within Canada), US and International shipping based on number of packages and dimensions. We then implemented generation of over 100 different formats of labels using iText based on tight specs from Canada Post.