SPUFI/QMF File-aid
*******.******@*****.***
+** 9134 5669
Choa Chu Kang, Singapore
linkedin.com/in/ryan-aguilar-
a4a72768
WORK EXPERIENCE
Software Engineer
Accenture Inc., Philippines
**/**** – 06/2018
Mainframe COBOL Developer
Talentvis Singapore
01/2019 – Present
Philippines
Singapore
SKILLS TRAININGS AND CERTIFICATION
Mainframe COBOL Boot camp
COBOL Programming, basic TSO Navigation
DB2 Application Programming and Design
Customer Service Training 101
Communication Essentials Training
Agile Development Training
PROJECTS
American Express – USMR (Card link)
Sempra Utilities - San Diego Gas & Electric
HDB - Resale System II
LANGUAGES
English
Tagalog
EDUCATION
BS Computer Engineering
Colegio de San Juan de Letran - Calamba
06/2008 – 03/2013
PROFESSIONAL QUALIFICATION
Proficient with mainframe based applications built with CICS, COBOL and JCL Ability to quickly adapt and understand new tools/technologies Good verbal and written communication skills
Good analytical and problem-solving skills.
Ability to work independently or on a team and in a fast-paced environment Philippines
JCL CICS DB2
SQL VSAM SAS
TSO/ISPF Control-M
Mainframe COBOL
Ryan Aguilar
COBOL DEVELOPER
6 years of solid IT experience in using Mainframe COBOL & JCL. Looking for a challenging role relevant to my experience which can enhance my skills and knowledge that can also be an asset throughout my career.
Abend-aid Endevor
Xpediter
JCL Utilities
ROLES AND RESPONSIBILITIES
Talentvis, Singapore
01/2019 – Present
Key Projects:
HDB – Resale System II
Role : COBOL Mainframe Developer
Design, coded, and tested new programs using SAS, COBOL and JCL.
Modify existing software to correct errors, to adapt it to new hardware or to upgrade interfaces and improve performance
Developed, designed, coded and tested changes to Batch and Online COBOL and CICS programs utilizing VSAM and DB2 based on Change Request requirements
Build components based on program specification documents
Prepared JCL and documentation for proper execution of programs.
Provide support in the system for the issues encountered by the User
Propose solutions to issues and enhancements to existing programs
Provide support to implementation in production
Accenture Inc., Philippines
02/2014 – 06/2018
Key Projects:
Financial Services Account (Card link) – American Express Credit Card Focuses on US Membership Rewards Program
Role : COBOL Mainframe Developer/Support
Identifies approach that will deal with the issue being described
create JCL code to extract and test data from production
Migrate code change in production environment
Provide data extraction results to business
Performs test data analysis and test data set up
Prepare test case scenarios for testing based on code change
Logs issues/defects discovered during testing
Resolve incident using service now
Monitor and fix batch Abend
Manage team mailbox for any urgent request
Perform peer review as per the process
Plot and designate task for the whole team
Conduct knowledge transfer for a new resource
Provide weekend on-call support
Key Projects:
Customer 1/ Utilities Account – Sempra Utilities Focuses on San Diego Gas and Electric
Role : COBOL Mainframe Developer/Support
Build and test codes in test environment
Migrate code change in production environment
Performed Root cause analysis to identify cause of issues in the Test/Production environment by using tools such as Abend Aid, Xporter and Xpediter
Provide IT support to Customer Operations Support to solve encountered issues and resolve logged incidents
Analyzed the job log and resolved production ABENDs
Performed impact analysis to resolve user queries
Simulate accounts using CICS in test environment
Monitor and fix Batch Abend
Modified and tested SQL code and use File-Aid DB2 to retrieve and update tables per customer specifications
Analyzed, designed and created new JCL Jobs, Procs for daily, monthly & yearly Reporting purposes
Conduct peer review on table changes in production
Performs test data analysis and test data set up
Conduct knowledge transfer for a new resource.
Assign tickets to the team as the Queue Manager