Uploaded File
add photo
Arwinder
arwinder03@msn.com
415-812-0013
3110 Rubino Drive, Apt #309
San Jose, CA 95125
Web Developer
14 years experience W2
0
Recommendations
Average rating
237
Profile views
Summary

Over five years’ experience as an Analyst/Developer for a major financial institution and a years’ experience of developing an entertainment website called Firtiva.com. Worked at all levels of software development including requirements gathering, design, development, testing, and post-implementation support:

  1. Complete Software Development life-cycle work experience in the finance industry (specifically Internet Banking and Mortgages.)
  2. Great problem-solving abilities with excellent communication skills, specification documentation and people skills to work with end users to co-ordinate testing and deliver training.
  3. Excellent experience in troubleshooting/debugging/testing/version control methodologies.
  4. Ability to perform well under pressure, such as production support.
  5. Highly motivated, enthusiastic, creative, independent and team-oriented resource.

Experience
Developer
Information Technology
Jan 2014 - present

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.

Java JavaScript jQuery HTML Apache AJAX Business Requirements MySQL PHP SMS Windows CSS Git
Remove Skill
Developer / Analyst
Banking/Financial
Nov 2011 - Jan 2014

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.
ILE RPG SQL CL DB2/400 IBM iSeries SQLRPGLE Implementer IBM MQ Series Client Access Analysis IBM Websphere MQ DB2 FTP
Remove Skill
Programmer/Analyst
Banking/Financial
Dec 2009 - Nov 2011

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.
RPGLE CL SQL IBM iSeries Implementer Java Stored Procedure Triggers IBM Websphere MQ DB2 FTP IBM MQ
Remove Skill
Associate Developer
Banking/Financial
Mar 2008 - Dec 2009

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.
Analysis IBM iSeries IBM MQ Series VBA SQL FTP NDM DB2/400 SQLRPGLE Client Access Java IBM WAS IBM Websphere MQ DB2
Remove Skill
Business Analyst
Banking/Financial
Sep 2007 - Mar 2008

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.

MS Access Analysis Business Analysis
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Bachelor's in Computer Science
University of Birmingham, 2003 - 2006
Skills
Analysis
2014
1
Client Access
2014
1
HTML
2021
1
IBM iSeries
2014
1
MySQL
2021
1
PHP
2021
1
RPGLE
2011
1
SQL
2014
1
Windows
2021
20
Business Requirements
2021
7
AJAX
2021
1
Apache
2021
1
CL
2014
1
CSS
2021
1
DB2/400
2014
1
IBM WAS
2009
1
JavaScript
2021
1
jQuery
2021
1
SMS
2021
1
SQLRPGLE
2014
1
VBA
2009
1
DB2
2014
6
IBM Websphere MQ
2014
6
Java
2021
6
FTP
2014
5
ILE RPG
2014
5
Git
2021
1
IBM MQ Series
2014
1
Implementer
2014
1
MS Access
2008
1
NDM
2009
1
IBM MQ
2011
2
Stored Procedure
2011
2
Triggers
2011
2
Business Analysis
2008
1
Web Developer
0
1
Languages
Punjabi, Fluent/Bilingual
Hindi, Basic
English, Fluent/Bilingual