Application Consultant - Cobol/Cics/DB2, Sas, Jcl, Vsam, Endevor, Csp

ANNALYN LEE GARILLO

EMAIL ADDRESS: *****.*******@*****.***

Ten years of wide experience specializing in the areas of Banking, Retail Merchandising and Resale Software Applications, Insurance, and Financial Systems. Experience includes involvement in full cycle of software development project, problem isolation and analysis, software quality testing, application and requirement analysis, implementation, and documentation. Experience in technical and production support, software and hardware installation and maintenance, troubleshooting and bench marking.

KEY STRENGTHS

• Successfully designed, developed and supported live use applications

• A self-starter and eager to learn new things, likes to take up new challenges

• Strive for continued excellence

• A result-oriented person who can work with minimum supervision even under constant pressure

• Self taught programmer and can be relied upon in the execution of assigned task

TECHNICAL SKILLS

Proficient or familiar with a vast array of programming languages, concepts and technologies including but not limited to:

• COBOL, CICS, DB2, JCL, VSAM, SAS, EZTRIEVE, CSP, Remedy

• TSO, Microfocus, Changeman, Endevor, FileAid, Expediter, OPC, SPUFI, ITST, RC Update, DTCN, AQT

• Visual Basic 6, ODBC

• MS SQL / SQL7 / SQL2000

• Oracle Forms 9i

• PL/SQL

• Crystal Reports

• Pro*C

• TOAD, Query Analyzer

• PVCS Version Manager and Visual SourceSafe

EXPERIENCE HIGHLIGHTS

EPS Computer Systems Pte Ltd

May 2009 – Present

Application Consultant

Systems Handled: Corporate Actions, Singapore Exchange

Projects: Sukuk OCBC, CDP Phone System, Vinamilk, and BAU’s

Job Nature:

• Coordination with Systems Analyst to understand Business and Functional Requirements of project scope for the creation of Technical Specifications Document.

• Provides impact analysis of affected systems that would be involved in the whole project cycle.

• Created/modified SAS programs to accommodate changes. Enhanced report layouts for new format.

• Developed and modified batch programs and online programs using COBOL/CICS/DB2 and CSP.

• Translated CSP programs to create program specifications for conversion to stored procedure.

• Carry out system integration tests (SIT) and user acceptance tests (UAT) by creating test scripts and data for regression tests.

• Created/updated documentations for changes made and unit testing (UT) scenarios. Created training materials/manuals for user guide if necessary.

• Provides support to clients/users after implementation for system maintenance.

• Coded JCL’s for batch applications. Created datasets and files for testing purposes.

• Assisted project lead/team lead in administrative tasks for the group. Maintains tracking development record of each member and gives weekly status report.

Systems Analyst

Systems Handled: Application Outsourcing for Central Provident Fund SG, NCS Pte Ltd

Project: Home Protection Scheme System

Job Nature:

• Primary support. Handles SLA for tickets and the timely resolution and closure of issues encountered.

• Provides analysis for long-term solutions on errors encountered for both Online and Batch programs.

• Attends to user queries on data inconsistencies and assists in program investigation and system behavior leading to discrepancies on client account details.

• Analysis of system and software requirements for Service Request and provides impact analysis and thorough investigation of affected systems.

• Provides man-days requirement for change and delivery date.

• Delegation of tasks to team members for timely delivery of change requests. Reviews changes done by developers as well as reviews of the Unit Test records.

• Created/updated documentations for changes made and unit testing (UT) scenarios

• Assists counterparts during system integration tests (SIT) and user acceptance tests (UAT)

• Handles Incident Reports (IR) that did not satisfy program change requirements and expected results. Coordinates with persons involved in the problem ticket.

• Assists project manager and team leader in administrative tasks for the group. Updates tracking history of changes made to components.

Module Lead

Project/Systems Handled: Concurrent Changes for Central Provident Fund SG, NCS Pte Ltd

Job Nature:

• Worked in parallel with Information Technology Revamp (ITR) project to accommodate Service Request implemented after code conversion.

• Analyzed program specifications for Work Orders requiring code conversion and delegated tasks to counterparts detailing code creation/changes and reviews Unit Test records upon completion.

• Migrated components to Endevor and provided support to client counterparts for SIT and UAT

• Investigated and provided solutions to Incident Reports encountered by counterparts

• Updated documents involved in the Work Order and assisted in the implementation to Production when ITR went live.

Troytech International Consulting Pte Ltd

May 2007 – January 2009

Analyst Programmer

Systems Handled: Client Accounting System, Singapore Exchange

Project: Extended Settlements, and Catalyst

Job Nature:

• Analysis of system and software requirements for project development. Provides impact analysis and thorough investigation of affected systems that would be involved in the whole project cycle.

• Created SAS programs to merge files and data needed in producing reports for statistical analysis, daily/monthly/yearly reports on buy and sell status of different accounts, and reports as per user group’s own request.

• Modified existing SAS programs to accommodate additional enhancements or formatting changes in reports, also to include new policies and instructions for the different products.

• Developed and modified batch programs and online programs using COBOL/CICS.

• Carried out system integration tests (SIT) and user acceptance tests (UAT) by creating test scripts and data that would satisfy the different expected results.

• Created/updated documentations for changes made and unit testing (UT) scenarios. Created training materials/manuals for user guide if necessary.

• Maintained projects implemented and applied enhancements in the course of time that new functionalities arrive. Provides support to clients/users after implementation.

• Coded job control languages for batch. Created datasets and files for testing purposes.

• Assisted project lead/team lead in administrative tasks for the group. Maintains tracking development record of each member and gives weekly status report. Assist team members in tasks issues through brainstorming sessions.

Mona Computer Systems Pte Ltd

March 2005 – April 2007

Software Engineer

Project/Systems Handled: Resale Systems, Housing and Development Board

Job Nature:

• Responsible in analyzing user requirements and formulating corresponding solutions for upcoming new projects or changes for enhancements of the system.

• Developed online and batch programs using COBOL/CICS utilizing VSAM, PDS and sequential files.

• Created reports triggered by online and batch programs. Reports and automated emails for Lotus Notes were also generated through batch programs using special JCL functionalities.

• Created and modified reports using SAS for statistical analysis and presentations and log reports.

• Carried out user acceptance tests (UAT), implementations, program staging, and post implementation support.

• Created/updated documents for changes made and unit testing (UT) cases. Created training materials/manuals for user guide. Maintained projects implemented and applied enhancements for new software functionalities.

• Coded job control languages for batch and online applications. Created datasets and files for testing purposes.

Accenture

November 2003 – February 2005

Software Engineer

Systems Handled: Retail Merchandising System, Retek

Project: Batch with Online User Project

Job Nature:

• Modified batch programs of the client’s merchandising system to enable the batch schedule to process while users may continue accessing the system.

• Using Pro C, we customized the batch modules in order to cater to 24Hour functionality.

• Double-checked forms that have production problems and retrofitted some changes to avoid conflict with the upcoming setup.

• Documented changes for every modified module and maintained version tracking for all changes.

Project: Crystal Report Development

Job Nature:

• Created reports for reference purposes for clients needs. Records were extracted from client’s merchandising system using Oracle 9i SQL then are formatted using Crystal Report v.9.

• Designed and created data mappings for each field for a certain report that has to be formatted in Crystal Report v.9. They are customized according to client's/audience preference and specifications.

• Documented each report (i.e. test plans, review points and the like) including functional specifications and requirements documents from clients. Maintained version tracking of each report created including their documents.

Equitable Data Center Inc.

April 2001 – October 2003

Senior Programmer

Systems Handled: IT Group – Appication Development Department for Treasury Systems

Project: Operations Processing Integrated Control Systems (OPICS)

Job Nature:

• Participated in production support and system testing. Installs OPICS to user workstations.

• Participated in the testing period for the system conversion from version 5.1 to 5.2.

• Assisted in the implementation of the Fixed Income and Foreign Income modules, system and data-flow analysis, and data reconciliation.

• RFA (Request for Assistance) Issues – updated issues and statistics of problems in the system, runs test and file fixes sent by MISYS, compiles previous and current issues including emails for reference.

• Kept inventory records of IP’s, PC names and PC ID’s of OPICS users for reference and update.

Project/Systems Handled: Treasury Customized Report System (TCRS)

Job Nature:

• Created new modules and revised old ones in Visual Basic 6 according to user requirements.

• Coordinated with users from different departments for system requirements and design.

• Analyzed software and system specifications for revisions and update. Designed and coded reports and other system functionalities.

• Assisted in user acceptance, implementation, enhancements, version control and supported system maintenance including installation of TCRS application to user workstations

• Trained users for enhanced and new modules implemented to familiarize them with the application

• System Administrator – Visual Source Safe for TCRS code in Visual Basic 6

• Created reports through Crystal Report v.4 for reference purposes for clients needs. Participated in the design of the reports and data analysis. Documented the reports and maintained version tracking.

Pacific Internet

November 2000 – March 2001

Technical Support Engineer

Job Nature:

• Received calls and supported clients in installing TCP/IP, Dial up Adapter and Communications, setting up and configuring dialer, setting up of proxies of Browsers and Emails

• Done field works; going to client sites and help troubleshoot internet-related problems

• Advised on basic PC troubleshooting and referring to websites needed by the client

• Guided clients in installing internet software programs to computer

TRAININGS AND SEMINARS ATTENDED

Remedy: Change and Release Management (January 19, 2011 at SGX)

Remedy: Problem Management (January 7, 2011 at SGX)

Remedy: Incident Management (December 8, 2010 at SGX)

Software Configuration Management for Application Outsourcing (September, 2009 at CPF SG)

Client Batch Development Standards (February, 2004 at Accenture)

Client Coding Standards (February, 2004 at Accenture)

Oracle 9i Forms Developer (February, 2004 at Accenture)

SQL, PL/SQL (February, 2004 at Accenture)

CMM: CMM Overview, Peer Review, Software Configuration Management, Continuous Improvement, Defect Prevention

IBM: OS/390 Security (January, 2004 at Accenture)

COBOL/CICS/DB2 (November, 2003 at Accenture)

Crystal Reports V.6 (May 5-9, 2003 at EPCI Bank)

CICS Programming (January 7-28, 2002 at EPCI Bank)

MS SQL Server 7.0 Fundamentals (October 8-19, 2001 at EPCI Bank)

Visual Basic Fundamentals (September 3-14, 2001 at EPCI Bank)

10th Information Study Program - Equitable Data Center Inc. (July 11 – May 23, 2001)

Courses Taken:

SNA Fundamentals TCP/IP

Local Area Network Bridging and Routing

Wide Area Network Data Communication

JCL and Utilities ROSCOE Fundamentals

Data Center Operations Data Structures

COBOL Programming Program Logic Formulation

Mainframe Architecture Electronic Data Processing

EDUCATION

Level/Degree: Bachelor of Science in Computer Engineering

Major: Computer Engineering

Institution: Mapua Institute of Technology, Manila Philippines

Graduated: November 2000

CHARACTER REFERENCES

Ms. Jean Ang

eBusiness Technical Leader – Emerson Climate Technologies

****.***@*******.***

Mr. Xu Yugang Simon

Senior Associate – Singapore Exchange

*****.**@***.***

Mr. Rodel Talampas

Senior Application Developer – INTTRA Pte. Ltd.

*****.********@******.***

Contact this candidate