As part of my work at CGI, I participated in a project at Aimia (Aeroplan) to help create a service that evaluates the value of an Aeroplan reward versus the requested item (airplane flights). This is right after phase 1. Phase 2 is to have a job that checks all new bookings of flights and adds those that have not worked or were not found. It adds all the entries in the queue.
Responsibilities:
- Analyze business needs versus data that can be obtained and used.
- Develop business rules based on available data.
- Design and develop a part of the solution.
Specifics:
- Application using Java and Spring Source.
- Create jUnits tests for everything that is developed.
- Create the database DAO for DB2:
- Create the domain objects classes.
- Use JDBC Template with RowMappers to read data.
- Use JDBC Template to write, update and delete the data.
- Create REST web service and client to:
- list all bookings to be added to the queue.
- change a reservation state to tell if it was audited or not.
- Change some business rules from the analysis of data by the auditors.
- Add functionality to the web application to help test manually:
- Possible to obtain the data production in batch and zip them for use with a Mock.
- Display the content of the new table that lists unaudited bookings.
On the side:
- Create a Perl script to generate a file containing the airports and their cities to fix an issue in another system that impacts on the audit.
Technologies:
Bootstrap-css,
DB2,
H2,
Java,
JavaScript,
JBoss,
jQuery,
jUnit,
Perl,
Spring Source