Cobol, Natural Adabas, DB2 SQL

Jaime R. Martin, Jr.

*** *. ***** **., *********, Pateros, NCR, Philippines

Phone: (632-****-**** Mobile: +63-917-*******

Email: adcgp4@r.postjobfree.com

CAREER OBJECTIVE

In quest of assignment either in the domain of Project Management, Release and Change Management, Systems/Business Analyst, Natural Adabas or Cobol or Mainframe Technology. Open and willing to learn new technologies and passionate to work in Java, ABAP, Oracle and other modern platform and technology.

CAREER SUMMARY

IT Professional with twenty five (25) years of solid experience in information technology. Fifteen (15) years of which is in Natural Adabas technology. Strong background in Release and Deployment Management, Systems Analysis, Data Analysis, Systems Design, Programming, Testing, Data Migration for Oracle Tables and Data Warehousing, Implementation, System Development Lifecycle (SDLC), Project Monitoring, Technical Documentation, and Training in Mainframe Applications. Extensive experience in the design, development and implementation of business application systems for various companies and organizations in:

Consumer/Commercial Banking - Eighth (8) years experiences

Telecommunications - One (1) year experience

Customs Duty Taxes - Two (2) years experiences

Asian Financial Institutions - Seven (7) years experiences

Social Service / Healthcare - Four (4) years experiences

Energy Utilities - Two (2) years experiences

Insurance - Six (6) months

TECHNICAL SKILLS

Hardware

IBM S/390; IBM ES/9000; IBM S390; HP 9000; RISC 6000; IBM PC and Compatibles

Operating System

Z/OS; MVS/ESA; OS/390; HP-Unix; IBM-AIX; Windows 98/2000/XP

Database

ADABAS; VSAM; Oracle DB; DB2; MySQL

Mainframe Languages

NATURAL; COBOL; CICS; DB2/SQL; Oracle PL/SQL; Oracle Developer 6i

Web Programming

Languages

JAVA; AWT; Swing (Trained); Python; HTML5, CSS; MySQL; PHP

Coding Tools

Natural Facility, PREDICT; TSO/ISPF; TOAD; RDZ (Trained)

File Browsing Tools

SPUFI; CA File Master Plus

Debugging Tools

Natural Debugging Facility; CA Intertest Online/Batch

Build & Release Tools

Jenkins; GIT

Code Management Tools

Endevor; Changeman

Process Workflow Tool

IBM Rational – Rational Team Concert (RTC) ; BMC – Remedy

Ticketing Tools

Application Lifecycle Management (ALM);

SDLC Methodology

Waterfall ; Agile (Trained)

SAP

SAP B1 Logistics (Trained)

IDE

Eclipse; NetBeans; Sublime; TOAD

WORK HISTORY

IBM Solutions Delivery, Inc October 20, 1997 - April 6, 2018

IT Specialist / Release Manager / Team Lead

Assumed different roles according to projects.

Assigned in various projects/clients of IBM.

EA – Energy Australia – Jan 2017 – Apr 2018

Software Configuration Management Specialist.

Assigned in Energy Australia project. They provide electricity and gas services to homes and businesses thoughout Australia.

oAssign in Software Configuration Management Team, handling Oracle Customer Care and Billing System (CC&B)

oMigrating changes across the development lifecycle

oManaging the compile and build process.

oManaging the distribution of changes.

oObtaining approvals and sign-offs.

oManaging change requests.

oManaging defects encountered during build and release.

oCommunicate and Coordinate among stakeholders.

oObtaining project status.

oTracking bugs and fixes

oMaintaining Git Repositories

oManaging deployment activities (including data refresh and flash copy)

oUses Jenkins, GIT and Eclipse Tool to manage build and release of all changes across environments.

BPI – Bank of the Philippine Island – Sep 2016 – Dec 2016

Release Manager

Assigned to BPI project. The oldest and one of the biggest commercial banks in the Philippines.

oSpearheading the deployment of IBM Rational Team Concert deployment for the banks Mainframe code migration and version control.

oIdentify the banks current requirements against the software to be installed.

oLiaise and conduct meetings with various stakeholders - IT Operations / Change Management / Application Teams / Software Services / Pre-Sales.

oDetermine current change management operations and existing processes (As Is).

oApply best practices for code deployment processes.

oUses IBM Maximo for Change Management work flow process.

USAA – United Services Automobile Association – Feb 2016 – Aug 2016

Technical Team Lead

Assigned in USAA project. A US company based in Texas that serves military men and their families with competitive rates on insurance, banking and investment services.

oHandled 4-5 Developers.

oInvolved in Fine Tuning project for Insurance System application.

oAttend Meetings and Liaise with Onshore Lead and Business Analyst.

oPrepare Technical Specification Design (TSD).

oEnhanced COBOL and JCL scripts according to their Software Engineering best practices and standards

ESI - Express Scripts, Inc. – May 2011 – Jan 2016

Release Manager – Feb 2015 – Jan 2016

Assigned in ESI project. A US company, largest pharmacy benefit management organization.

oManages / Lead deployment of Non Standard Release / Minor Release / Major Release.

oDrive and Chair Deployment of Non Standard, Minor and Standard Releases for Mainframe, Java and Midrange Deployment with US and India stakeholders. Releases must be deployed within the specified release window.

oEnsures that release trackers have complete information. Communicate and coordinate with Project Managers and Delivery Leads for incomplete or missing artifacts.

oReviewed and Audited artifacts if necessary approvals are provided.

oEnsure that CICS regions are stable after each deployment via Wily Monitoring Tool

oCreate Implementation Plan (IP) for Mainframe / Java / Midrange Deployment to be presented with the stakeholders via Walk Thru

oEnsure that back out plan is complete in case of issues or problems

oPrepare various Leadership Reports for PM / DL to Senior Executive Leadership informing of the current status of each release.

oManages issues and defects encountered during and after deployment. Point of Contact for issue resolution.

oManages / Lead and conducts post deployment system health check and application monitoring. This is to check that system is healthy after each release in order to ensure that the system is functioning well without abends or issues encountered.

oUses BMC – Remedy for Change Request and Work Flow management.

Team/Tech/Project Lead role – May 2011 – Jan 2015

oImplement fast phase projects for Eligibility System Processing.

oHandle 4-5 Developers.

oGathered user requirements from High Level Requirements document.

oAttend Meetings and Liaise with Onshore Lead and Business Analyst.

oCreated the Technical Specification Design and document it.

-Design input/output structures.

-Identified impacted modules and if a new module will be created.

oDevelop/Build using Cobol/CICS/DB2/SQL/VSAM/JCL.

oPerformed Unit and Integration Testing.

oCoordinated User Acceptance Testing (UAT) with business user.

oDeployed various modules in production area.

oMonitored the system during the warranty period.

California Department of Health Services - California, US – Apr 2010 - Apr 2011

IT Specialist / Application Consultant

Assigned in IBM US for their Sacramento project. DHCS is a department of California Health and Human Services that finances and administers a number of individual health care service delivery programs.

oAttended meeting with business users. Gather detail requirements.

oDesigned system in accordance with the requirements.

-Defined and Identified Data Structures for Healthcare Claims Processing.

-Designed file structures and user friendly screens.

-Prepared Technical Specification Design and System Functional Design.

oDeveloped new online and batch modules.

oUsed COBOL/CICS, JCL, MAPR and Expediter for building functional modules.

oPerformed Unit Testing and Unit Integration Testing using WPI form.

oCoordinated User Acceptance Testing (UAT) with business user.

oDeployed the modules in production environment.

oMonitored the system during the warranty period.

oFiles used are DB2, VSAM and Sequential Files.

oUsed the SDLC framework using Waterfall model.

Centrelink - Canberra, Australia - Jan 2009 – Dec 2009

IT Specialist / Application Consultant

Assigned in IBM Australia for their Canberra project. Centrelink is part of Department of Human Services. It delivers social security payments and services to Australians.

oDeveloped M204 applications.

oCreated and designed metadata structures for Core Component (SOA).

oDeveloped and enhanced program written in M204 for Benefit Application system.

oPrepared Technical Documents and conduct/headed Peer Code Review.

oProvided impact/gap analysis on the whole system as new field definition will be introduced.

Alinta Energy – Sydney, Australia - Nov 2007 – Dec 2008

IT Specialist / Application Consultant

Assigned in Alinta project. Alinta Energy is involved in Electricity generation and gas retailing in Australia.

oHandled development and system maintenance of GASS system. This application is written in NATURAL/ADABAS.

oModified various JCL.

oManaged and solved various severity tickets raised by user within agreed Service Level Agreement.

oDocument solutions, provide RCA and recommend to user for approval.

oPrepared training materials and conducted Natural/Adabas training for junior hires.

oPredict Utility is used.

oSDLC methodology is Waterfall.

Software AG Philippines April 2, 2001 – October 12, 2007

Senior Application Engineer

oFunctioned as Project/Team/Tech Lead.

oAssigned in Asian Development Bank (ADB). An international development finance institution dedicated to reducing poverty in Asia and the Pacific trough loans, grants, assistance to its member countries.

oWorked on development and maintenance of various Mainframe Applications build in NATURAL/ADABAS. Also created various JCL programs for batch runs.

Main Responsibilities

oLed/Participated in user meetings to determine user requirements.

oPerformed Impact Analysis.

oAnalyzed and developed new modules based on user requirements. Created Technical Specification.

oPerformed Unit and Integration Testing for online and batch programs.

oConducted User Acceptance Testing with the end user.

oReleased and deployed affected modules.

oMonitored performance of the system.

oPredict Utility is used.

oSDLC Methodology is waterfall.

oInvolved in development and maintenance of ADB existing Legacy Systems:

-Grant Financial Information System (GFIS)

-Loan Financial Information System (LFIS)

-Technical Assistance Information System (TAIS)

-Housing Loan System (HLS)

oInvolved also in development and maintenance of the following Legacy Systems until its migration to Oracle.

-Insurance Administration System (BAS-IAS)

-Dependency Allowance System (BAS-DA)

-Education/Travel Grant System (BAS-EG)

-Leave Administration System (LVAD)

-Rental Assistance Subsidy System (BAS-RAS)

-Handles data migration/conversion of some Legacy Systems to Oracle Applications.

-Handles Data mapping and preparation of conversion mapping documents.

-Preparing data conversion program specifications.

-Coding/Testing data conversion programs.

oPerformed the following during upgrade of NATURAL/ADABAS and OS upgrade.

-Attended meetings during the Initiation stage of the project.

-Identified all programs affected and modified them to a newer version.

-Prepared and conducted Unit Testing.

-Prepared Test Plan and Test Script for System Integration Testing.

-Conducted User Acceptance Testing with the end user

-Released and deployed affected modules

-Monitored performance of the system

National Computer Systems Pte. Ltd., Singapore June 4, 1999 – December 12, 2000

Senior Software Engineer

Functioned as Assistant Project Leader.

Assigned in Customs and Excise Department (CED) of Singapore. It is the lead agency on trade

facilitation and revenue enforcement of Singapore.

Developed and enhanced CED existing Legacy Systems created using NATURAL / ADABAS

oDuty Payment System (DPS)

oLiquor/Tobacco System (L/TS)

oMotor Vehicle System (MVS)

Responsibilities includes:

oParticipated in user meetings.

oAnalyzed user requirement and develop functional and program specifications.

oAnalyze service requests and estimating effort required.

oDesigned system architecture to ensure integration of components and satisfactory performance.

oWrote Functional Specifications and Technical Design Specifications.

oManaged and provided guidance to the team to meet acceptable levels of efficiency and performance.

oTested efficiency of new/modified programs prepared by Programmers according to standard and satisfactory performance.

oWrote System Test Plan.

oHandled development, implementation of existing application system.

oConducted User Acceptance Testing (UAT) with the business user. Obtained UAT sign-off.

oDeployed components after release has been approved.

oPrepared system sign-off document.

oProvide support by monitoring the system.

oPredict Utility is used.

oSDLC methodology is waterfall.

oInvolved also in the initial phase of Data Warehousing project.

-Coordinated with user and data warehouse application group.

-Handled data mapping and conversion mapping documents for data warehouse application.

Perrini Management Pte. Ltd., Singapore February 25, 1998 – April 30, 1999

Systems Analyst

oAssigned at Ministry of Defense (Singapore).

oHandled maintenance of National Servicemen Payroll System (NSPAY 1) written in Natural/Adabas.

oResponsibilities included maintenance and enhancements, data analysis, developing and coding new programs, data cleansing and conversions, file maintenance and inquiry, unit testing, system testing and program documentation.

oInvolved in data migration from Mainframe to Oracle Application by creating conversion programs that will extract ADABAS data from Legacy System.

oPredict Utility is used. SDLC methodology is waterfall.

DL Resources Pte. Ltd., Singapore September 15, 1997 – February 21, 1998

Analyst Programmer/Lead Programmer

oAssigned at Customs and Excise Department (CED) of Singapore.

oPrepared Impact Analysis for Duty Payment System (DPS), a NATURAL/ADABAS system, to determine usage of each date field in preparation for Y2K enhancement.

oCreated Program Amendment Specifications. Wrote and modified online and batch programs and JCL accordingly.

oDid a Unit Test and System Integration Testing, Document results.

oPeer reviewed junior programmer’s works especially for critical programs.

oSDLC methodology is waterfall.

A-IT Software Services, Singapore June 6, 1996 – August 31, 1997

Analyst Programmer

oAssigned at Citibank Singapore.

oInvolved in the development, implementation of Customer Net Revenue System and Consolidated Statement System.

oApplication is written in NATURAL/ADABAS with imbedded DB2/SQL statements and COBOL for some batch runs.

oResponsibilities involved user requirements gathering, programming of system modules, developing and revising NATURAL and COBOL programs, Data Conversion, prepares system flows (online and batch) and writing JCL to execute batch programs, performing system and integration testing, monitoring scheduled jobs, report output verification, preparing operation manuals and production support.

Execnet Consulting Bhd. Sdn. January 1, 1996 – May 31, 1996

Software/Systems Engineer

oAssigned at Software AG Malaysia

oFunctioned as Analyst Programmer for the development of Marketing/Production Planning System (M/PPS), a new system developed using NATURAL/ADABAS for a Japanese manufacturing company.

oDeveloped simple to complex NATURAL online programs according to user requirements and performed program testing.

oPredict Utility is used. SDLC methodology is waterfall.

ICC Telecoms-Bayantel Philippines August 1, 1995 – December 31, 1995

Analyst Programmer

oHandled development and maintenance of Purchasing System written in MS Foxpro.

oConducted training for users to better familiarize themselves with the system.

oEnhanced application system by adding in new user requirements.

oOther responsibilities includes unit and system testing, coordination with user, preparation for implementation in production.

Bank of South East Asia Savings and Mortgage Bank August 1, 1994– December 1, 1994

Philippines

Analyst Programmer

oHandled maintenance of Personnel System which keeps vital information of all employees of the company.

oHandled initial development of Trust System, handling client’s investment from account opening, ledger tracking of their investment up to closing of account. Maintained Personnel System

Union Bank of the Philippines October 17, 1988 – July 27, 1994

Analyst Programmer

oUnion Bank of the Philippines is a universal bank and one of the largest in the Philippines.

oInvolved in Mainframe and PC application development for various bank system.

oMember of the developing team that implemented AUTO LOAN SYSTEM. This system is initially developed in HP-Unix platform, but after six (6) months, it was migrated to Mainframe.

oCreated several on-line, batch and JCL programs using Natural/ADABAS and DOS/VSE.

oUsed Natural CONSTRUCT for Development for a year.

oOther responsibilities are gathering of user requirements, systems analysis and technical design, and performing unit and system testing. Coordinated with user during User Acceptance Testing (UAT). Deployed modules to Production. Monitored system performance after release.

oHandled several PC based applications.

oPredict Utility is used. SDLC methodology is waterfall.

EDUCATION

Bachelor of Science in Computer Data Processing Management

Polytechnic University of the Philippines

Manila, Philippines

TRAININGS

HTML5,CSS,PHP - Meralco Foundation, Inc. 2019

Python Programming - Top ECE Review Center 2019

SAP B1 Logistics - FastTrack IT Academy 2019

Java - Informatica 2011 / Meralco Foundation, Inc. 2019

Oracle 8i & Developer 6i - Aptech Philippines, 2003

IDA IT Security Standards Workshop - NCS Singapore, 2000

PL/SQL Programming - Oracle Philippines, 1995

Contact this candidate