Royal Bank of Scotland FacFlow online sales ledger administration. Implemented a utility to import French FRIF invoice/customer files. Worked involved creating/updating JSP’s, Struts actions, Spring business/DAO beans, Hibernate beans/mapping, and DB2 tables/queries.

Struts actions were registered as Spring beans by replacing the Struts RequestProcessor with Springs DelegatingRequestProcessor to allow the Action’s dependency on Spring beans to be injected. In a similar manner Spring DAO beans injected with the HibernateTemplate allowed Hibernate to be used with Spring’s IOC.
Spring 2.0.8, Hibernate 3.2, Struts 1.2, JSP, DB2 on AS400.

Improving/developing intranet applications used for password management. Web applications developed with JSP/servlets, built into WAR archives with Ant scripts and deployed onto Websphere 5.0. DAO’s accessed Oracle9i using JDBC. Web pages utilized Ajax for dynamic population of drop-down fields.

Initial project was to develop xhtml screens for the Monitise Text Message Banking service. OpenCMS utilized to allow different banks to tailor their own static content. Xhtml screens tested on a wide range of mobile phones (in-house handsets and Device Anywhere) to ensure maximum coverage.

Final project was to develop a browser-solution to make the statement/balance/transfer/topup services available over the web. Initially these services were only available via a downloadable Java client which displayed customised wml pages hosted on a web server. The wml pages were converted to use custom tags which in turn called wml/xhtml renderers depending on the client type.
Java 5, Struts 1.1, Oracle 10g, JSP, Spring 1.0, OpenCMS.

Working as part of the development team on Visa’s new Regional Clearing and Settlement system to replace Base2. Design and development on Rational Software Architect using Rational ClearCase source control and Rational ClearQuest defect and change tracking. Code tested with JUnit, component testing with Cactus/DBunit, and code formatting/coverage testing with Clover and Checkstyle. All Java developed on Windows XP VM’s and deployed to AIX.

My initial work was on middle tier Java components to process events passed from the work management service to lower level components using POJO’s and standard GOF patterns. Component modeling and interaction was recorded in sequence/class diagrams written on RSA.

I am currently working on a web based analysis/maintenance n-tier UI tool that uses JSP’s, Javascript, JSTL, Tiles and Struts. Business delegates separated the Struts actions from the business-logic and DB layer which used OJB to create/retrieve/update/delete from the DB2 database. Data stored as type 2 SCD’s to keep a historical record of updates. Complex retrieve operations spanning several tables written as OJB report queries.

Sainsbury’s - Working as part of the Interface Development Center on the Sales Audit EAI project I was solely responsible for the technical design, build and testing of the Real Time Sales interface. This is the most complex interface for SA EAI, mapping over 200 fields from inbound XML messages to a set of over ten Oracle 10g database tables. Real-time basket data arrives via SeeBeyond eGate JMS server as compressed XML which is then decompressed, unmarshalled and validated against cached Java hash-maps of product bar-codes. All basket items are then batched and sent to the database using JDBC. The entire process takes place in one transaction. I was also responsible pioneering the use of a PL/SQL Stored Procedure I designed for quickly storing rejected XML messages as BLOB’s.

Sainsbury’s - The Exception Week Modeling Tool feeds historical sales data for all Sainsbury’s 500 stores into an Oracle database, and then shift the sales data according to the previous years trade profile. I was solely responsible for re-designing and regression testing the client-side Java Swing GUI component and the server-side modeling component working from existing functional designs. Both components were rewritten to use JDBC transactions. The server side component was redesigned to extract and map entire tables into ArrayLists/HashMaps of value objects, adjust the data, and then batch-update the adjusted data back into the database. This increased the speed and reliability of the tool and reduced the man-hours associated with its runtime and reduced support overheads.