Environment: Windows 2012 Server, Apache HTTP Server, PHP, JavaScript, jQuery, Java, HTML5, CSS3

Project: Firtiva.com is an entertainment website that streams advertisement-free video. The website is developed using JavaScript, jQuery, HTML5, CSS3, Apache 2.4 HTTP Server, PHP5, and MySQL. User’s viewing habits are reported to the web server and recorded in a MySQL database.Users are sent emails and/or SMS alerts of offers related to content they view.

In addition, the web application uses AJAX requests to interact with the web server backend in order to provide functionality such as requesting a video stream, logging on, and much more.

Responsibilities:

1. Analyzing business requirements and creating technical solutions.
2. Developing all aspects of the website, including front-end and back-end code.
3. Creating engaging user interfaces.
4. Testing the application by preparing appropriate test cases.
5. Managing an offshore team working on an equivalent mobile app that integrates with our service via API calls.
6. Documenting system functionality in specification documents.
7. Setting up Git to control source versions.

In addition to this project, also analyze software prior to producing expert reports for use in software litigation cases.

Environment: IBM iSeries, CL, CLLE, RPG ILE, SQLRPGLE, Free Format RPG, Implementer, DB2/400, Embedded SQL (SQL RPGLE), SQL, IBM MQ Series, Client Access, FTP, NDM

Project: HSBC Internet Banking enables users to access to their account online. The Internet Banking front-end has multiple interfaces to internal and external systems via IBM MQ Series. One such connection is to the Bank’s core module that holds and processes all customer related information, for example, interest on loan products. The focus of this project was to introduce a new two-factor authentication process in order to provide secure access. This lead to changes in the Bank’s core module, which is based on the IBM iSeries, and is the system I was responsible for during the upgrade.

Responsibilities:

1. Attend cross team meetings to co-ordinate testing activity and report on project status.
2. Co-ordinate/conduct regression testing of Internet Banking system across multiple systems, including business and customer interfaces.
3. Work with business users to identify gaps in functionality and help them write clear functional specifications.
4. Develop RPGLE, CL and SQL code to fix defects and fill in functionality gaps. I also developed localized solutions to issues reported to me by the business users.
5. Monitor defects assigned to my team to ensure quick turnaround.
6. Schedule and release new code via Implementer, and provide post-implementation support.
7. Prepare unit-test cases for all development prior to releasing code for business testing.
8. QA code.
9. Query physical files on DB2/400 using SQL in order to troubleshoot issues.

In addition to the main project highlighted above, also developed code in RPG/CL to automate the production of demand letters in Greek/English. This required me to develop:

• New physical files using DDS.
• New menu screens using SDA.
• New printer files for the letters using RLU.

Environment: IBM iSeries, CL, CLLE, RPG ILE, SQLRPGLE, Free Format RPG, Implementer, DB2/400, Embedded SQL (SQLRPGLE), SQL, IBM MQ Series, Client Access, FTP, NDM, Java, IBM WAS

Project: Upgrade HSBC Malta’s legacy mortgage module. The bank had 32,000 high value loan accounts that needed to be converted to the new system. This had to be an accurate conversion with no room for errors, as it was taking place overnight and we had to maintain regular service the following morning.

Responsibilities:

1. Setup the development and production environment.
2. Test and improve conversion routines written in RPG ILE/CLLE/SQLRPGLE and Java to ensure accurate results.
3. Train business users in new functionality.
4. Attend all meetings related to mortgage system, including:
   1. Business department meetings to discuss new functionality/requirements;
   2. IT meetings to discuss defects and co-ordinate testing.
5. Defect management/resolution.
6. Regression test interfaces to legacy systems/third party software.
7. Co-ordinate testing with offshore team members.
8. Develop RPG ILE/CLLE code to automate conversion result checking.
9. Debug issues related to SQL Stored Procedures and Triggers.
10. Provide post-implementation support.
11. Query physical files on DB2/400 using SQL in order to troubleshoot issues.

Environment: IBM iSeries, CL, CLLE, RPG ILE, SQLRPGLE, Free Format RPG, Implementer, DB2/400, Embedded SQL (SQLRPGLE), SQL, IBM MQ Series, Client Access, FTP, NDM, Java, IBM WAS

New Mortgage System Project: Implement a new mortgage system for Poland and Czech Republic.

Responsibilities:

1. Help business users define functional specifications.
2. Defect resolution of RPGLE/CL and Java code.
3. Train business users on the new system.
4. Production support.
5. Document system procedures so production support teams can fire fight issues.
6. Query physical files on DB2/400 using SQL in order to troubleshoot issues.

MI File Upgrade Project: Change iSeries physical files according to changes made on the same file set on a Mainframe. This meant translating a spreadsheet describing Mainframe files and applying the changes on the iSeries.

Responsibilities:

1. I developed VBa code that interpreted Excel Spreadsheet of Mainframe file details to output the equivalent DDS.
2. Used automated DDS to create/amend existing iSeries physical files.
3. Schedule and release new files via Implementer.
4. Prepare and execute test cases to ensure correct file format.

Environment: Windows, MS Office Suite

Data Transfer Migration Project: Migrating the transfer of hard-copies of data to a secure online link between HSBC and Credit Reference Agencies. This was during a major news story involving several organizations that had leaked vital customer data, therefore, there was a lot of pressure on delivering a solution.

Responsibilities:

1.Documented possible solutions.

2.Attended and chair co-ordination meetings with all IT departments.

Project Tracking Database Project: Department had to send senior managers project reports on a regular basis. For this reason, the department had created a project tracking database in MS Access, which was used to create various reports.

Responsibilities:

1. Act as database guardian.

2. Evaluate change requests and maintain the MS Access database.