JOHN ROY R. RIVERA
**** ***** **** ** *** **, Albuquerque, New Mexico
****.******@*****.***
Profile
Almost 12 years programming experience on software development and maintenance in an AS/400 environment using RPG/400 and RPG/ILE CL/400.
High energy, self-motivated and team player.
Accurate, professional nature and requires minimal supervision.
Able to work under pressure. Handles multiple demands, and set priorities.
Proven record for maintaining schedules; multi-task oriented.
Exceptional communication and interpersonal skills.
IT Work Experience
AS400/RPG Programmer Analyst, RCG IT Philippines – June 17, 2014 – July 11, 2016
Makati, Philippines
Client
Application Systems
Involvement
Pharmerica
Florida, USA
Duration :
June 17, 2014- July 11, 2016
Environment :
AS/400,OS/400,CLLE,SQL, RPGLE
Pharmerica Systems
Aldon Systems
Involve as a Production Support
The following are the roles and responsibility in Production Support:
1. Support Pharmacy Order Entry, Adjudication and Interface (e.g EPCP, RXNow, XML)
2. Doing and reviewing any impact and technical analysis on incident raised by Pharmerica Users.
3. Coordinate with Pharmerica Users based on the incident raised.
4. Performs program development and unit testing for break fixes if required during the impact and technical analysis.
AS400/RPG Analyst Programmer, D L Resources Pte Ltd. – January 1, 2012 – March 31, 2014
Tanjong Pagar, Singapore
Client
Application Systems
Involvement
OCBC Bank,
North Bridge, Singapore
Duration :
January 1, 2012- March 31, 2014
Environment :
AS/400,OS/400,CLLE,SQL, RPGLE
Silverlake Intergated Banking Systems
Aldon Systems
Involve in Core Banking Systems under Loans and NPL application for OCBC - ONESIBS project (migration of two countries to become a one code source).
The following are the roles and responsibility in Core Banking Systems under Loans and NPL applications:
1. Coordinate with vendor, SIT users and UAT users for testing and solving defects issues that may occur in Loans and NPL applications
2. Monitors End of Day Batch processing and investigates if any MSGW or error that may occur in the core banking systems EOD batch run during SIT and UAT stage.
3. Doing and reviewing any impact analysis, program specification, technical analysis and functional specification.
4. Performs Loans and NPL application technical regression testing and performance testing, to make sure that the new changes done in the core banking systems does not affect the existing process and it’s timing to meet the SLA’s cut-off time.
5. Act as an As400 admin, doing system backup and restoration, environment set-up, monitors performance of core banking (SIBS) system both batch and online, participates in disaster recovery testing, perform file transfer protocol via As400 to PC.
Software Engineer, Silverlake – March 21, 2011 –Dec 31, 2011
Raffles Singapore
Client
Application Systems
Involvement
CIMB Singapore,
Singapore Land Tower, Raffles Place
Duration :
March 21, 2011- Present
Environment :
AS/400,OS/400,CLLE,SQL, RPGLE
Silverlake Intergated Banking Systems
Aldon Systems
-Involve in Core Banking Systems under Loans application for CIMB Singapore
The following are the roles and responsibility in Core Banking Systems under Loans
1. Enhance and develop the Auto Fund Transfer of Loans application processing.
2. Monitors End of Day Batch processing and investigates if any MSGW or error that may occur in the core banking systems EOD batch run during SIT and UAT stage.
3. Enhance and develop the interfacing method of Loans application processing.
4. Act as an As400 admin, doing system backup and restoration, environment set-up, monitors performance of core banking (SIBS) system both batch and online.
5. Coordinate with SIT users and UAT users for testing and solving defects issues that may occur in Loans.
AS400/RPG Analyst Programmer, D L Resources Pte Ltd. – May 21, 2007 –March 17, 2011
Tanjong Pagar, Singapore
Client
Application Systems
Involvement
United Overseas Bank Singapore
Alexandra Road, Singapore
Duration :
May 21, 2008- March 17, 2011 Environment :
AS/400,OS/400,RPG/400, CL/400, SQL, RPG ILE
Silverlake Intergated Banking Systems
Aldon Systems
Involve in Core Banking Systems under Loans application for UOB Singapore
The following are the roles and responsibility in Core Banking Systems under Loans
1. Enhance and develop the LOANS and NPL application.
2. Production bug fixing and user support
3. Monitors End of Day Batch processing and investigates if any MSGW or error that may occur in the core banking systems EOD batch run during SIT and UAT stage.
5. Act as an As400 admin, doing system backup and restoration, environment setup, perform file transfer protocol via As400 to PC.
MayBank Singapore
Yiu Chu Kang, Singapore
Duration :
May 21, 2007- May 20, 2008
Environment :
AS/400,OS/400,RPG/400, CL/400, SQL, RPG ILE
Silverlake Intergated Banking Systems
Thenon Systems
Involve in Core Banking Systems under Consumer payment systems, Remittance, Deposit and Bankwide CIF application for Maybank Singapore
The following are the roles and responsibility in Core Banking Systems
1. Enhance and develop the CPS, Remittance, Deposit and Bankwide CIF application processing.
2. Monitors End of Day Batch processing and investigates if any MSGW or error that may occur in the core banking systems EOD batch run during SIT and UAT stage.
3. Enhance and develop the AS400 to XML codes vice versa under Loans application processing.
4. Act as an As400 admin, doing system backup and restoration, environment set-up, monitors performance of core banking (SIBS) system both batch and online.
5. Coordinate with SIT users and UAT users for testing and solving defects issues that may occur in core banking systems.
AS400/RPG Programmer, Radix Systems Services Corp. - Oct 18, 2004 –April 17, 2007
Boni, Mandaluyong City, Philippines
Responsibilities:
1.Designs, analyzes, codes and tests new programs and modifies existing ones in accordance with the company standards and user requirements.
2.Prepares test data to debug new programs and maintain existing programs.
3.Develops functional specifications, system flow charts, tables, record layouts and system documentation.
4.Support system testing, system implementation, and post system implementation.
Client
Application Systems
Involvement
(PLDT) Philippine Long Distance Telephone Company
Makati City, Philippines
Telecommunications
Duration Apr 2006 – Apr 2007
Environment
AS/400,OS/400,RPG/400, CL/400, SQL, RPG ILE
ICMS – Provisioning Department (Integrated Customer Management System)
-Extraction of files for migration of data using automated file transfer protocol.
-Systems modification of existing and new programs.
-Query formulation of Account and Customer Status.
-Integration of systems.
Futaba Corp. of the Philippines
Sta. Rosa, Laguna, Philippines
Manufacturing
Duration Jun 2005 – Mar 2006
Environment
AS/400,OS/400,RPG/400,ILE RPG, CL/400, Free-Form
HR Systems Project
Production System
Purchasing System
Hunstville QA System Project
-Generates report that suits the needs of the AS400 user.
-Systems modification of existing and new programs.
-Involve in Human Resources systems project. From timekeeping to Salary computations
-Involve in Hunstville QA systems, for VFD monitoring in QA process.
Query formulation of Account and Customer Status.
-Maintained Purchasing systems.
Tupperware Philippines
Makati City, Philippines
Manufacturing
Duration Jan 2005 – May 2005
Environment
AS/400,OS/400,ILE RPG,CL/400
James D. Edwards Financial Systems
Programming support for systems program modification, Reports.
Other Work Experience
Technical Support Engineer(trainee), IBM Phils Inc. May 2003 – Dec. 2003
Reservation Officer(trainee), Chrislink International Inc – April 2000 – June 2000
Field Collection Officer, Canon Marketing – Nov 1999 – Jan 2000
Collection Associate, Macondray Finance Corp. – July 1997 – Sep. 1999
Encoder, The Professional Group – April 1997 – Jun 1997
Computer Skills
Programming Languages - RPG/400, RPGILE, Free-Form, Embedded SQL, CL, PDM, SEU, SDA, DFU, RLU, QUERY, VISUAL BASIC 6, HTML, Active Server Pages, Perl, C Language, Assembly Language and Turbo Pascal.
Platforms and Utilities – AS400, OS/400, Windows Operating Systems, MSOFFICE Applications, Operating Systems and Software installation and Utility Software.
Computer Networking (Installation, Setup Local Area Network), PC Assembly and Disassembly, Repairs and Preventive Maintenance.
Education
Bachelor of Science in Computer Engineering: March 2004
Rizal Technological University
Boni, Mandaluyong City, Philippines
Diploma in Computer Technology: March 1997
Rizal Technological University
Boni, Mandaluyong City, Philippines
Short Courses:
Certificate of Achievement in Dynamic Web Page Development: Nov. 2000
Certificate of Achievement in Web Programming Using Perl: Oct. 2000
Certificate of Achievement in Web Page Design & Development: Aug. 2000
Certificate of Achievement in Internet Essential: Jul. 2000
Certificate of Accomplishment in Abacus Computer Reservations & Travel Agency Operation Course: March 20-29 2000 - ABACUS
Certificate of Achievement in MS Visual Basic ver 5.0 mod 1: Nov. 1999
Certificate of Achievement in Program Logic Formulation: Sep. 1999