Developer System

CAROLINA MENDIOLA SANDOVAL

* *** Oakleaf Plantation Parkway Orange Park, FL, 32065

( Mobile phone/ Viber : +1-210-***-****

: E-mail : ***************@*****.***

CAREER SUMMARY

I possess in-depth knowledge in COBOL programming (for both Unix, AS400 and Mainframe), UNIX shellscripting, Mainframe JCL, XGEN Cobol, Oracle SQL and PL/SQL, DB2 as well as in various other platforms and applications as stated herein. I am familiar with the full cycle of system development, from design up to its final implementation and support. I had handled various projects from retailing to banking applications. I am a dedicated, resourceful, motivated, hard-working and result-oriented person and have high aptitude in learning new technologies. I currently work on H1B visa with GC in process under Varnar Inc. and I am able to work through this company or through Corp-to-Corp arrangement.

SCHOLASTIC RECORD – COLLEGE

1987 - 1993 POLYTECHNIC UNIVERSITY OF THE PHILIPPINES

Sta. Mesa, Manila

Bachelor of Science Major in Computer Engineering

WORK EXPERIENCES

Jan. 13, 2016 to Present Varnar Inc.

Software Developer

Design and develop Software applications.

Modify existing software to correct errors, allow it to adapt to new hardware, or to improve its performance.

Analyze user needs and software requirements to determine feasibility of design within time and cost constraints.

Interact with customers about software system design and maintenance.

Develop and direct software system testing and validation procedures, programming and documentation using XGEN Cobol, XGEN Online Designer, UC4 Job scheduler, SQL Developer, PL/SQL and Oracle Database.

Dec. 12, 2005 to Dec. 31, 2013 BNP Paribas, ASIA PACIFIC (Singapore)

Senior Analyst/Programmer

Handled analysis, design, development, implementation, maintenance and system support of the bank's Payment System applications involving SWIFT Alliance and Connexis message transfer for the bank’s ASIAPACIFIC branches. Used Cobol, Unix Shellscripting, PL/SQL, and Oracle Database.

Created test scripts, scenarios and test data to support for all phases of testing: from unit testing, system testing, regression testing and user acceptance testing.

Dec. 23, 2002 to Dec. 9, 2005 United Overseas Bank

DL Resources Private Limited (Singapore)

Senior Analyst/Programmer

Rebuilt the entire bank’s statement generation application that runs in UNIX using Papyrus software.

Developed, tested, implemented, maintained and provided production support to Core Retail application modules using Cobol and AS400, RPG, CL and CICS.

Provided support on conducting system and regression testing as well as in user acceptance tests.

Set-up UNIX environment for bank statement processing to cater with the bank’s Global Hubbing project.

Mar. 01, 2001 to Dec. 20, 2002 BNP Paribas, ASIA PACIFIC

DL Resources Private Limited (Singapore)

Senior Analyst/Programmer

Migrated applications like AP Payroll interfaces, GST Reporting and Fixed Deposit Systems from mainframe to UNIX environment using Cobol, RPG, CICS, VSAM, Easytrieve, DB2 and Oracle PL/SQL.

Provided thorough unit testing to ensure that the actual capabilities of the mainframe application is inherited after migrating to Unix.

Participated actively during System testing and User acceptance testing to ensure that the migration can be integrated successfully into the whole banking system.

Oct. 1, 1997 to Feb. 25, 2001 United Coconut Planters Bank (Philippines)

Senior Analyst/Programmer

Lead a team of programmers handling the bank’s Trust Banking and Portfolio Management Systems which ran in AS400, RPG, CL and CICS.

Defined functional and system specification and analysis, impact analysis and database design.

Provided thorough testing on each application to ensure proper implementation.

Provided 24x7 production support to all applications within my areas of responsibility.

Assigned as part of the special team to migrate and improve the Loan Management System of the Philippine’s Social Security System from mainframe to Unix using Pro*Cobol and Oracle Developer.

Developed complex UNIX scripts and Oracle PL/SQL and stored procedures for both batch and online processing.

Nov. 15, 1993 to Sep. 30, 1997 Robinsons Incorporated, Phils.

Programmer/Analyst

Converted, developed, enhanced, implemented and maintained Retail applications from mainframe to UNIX. Used Cobol, MFCobol, PL/SQL, ReportWriter, SQL*Forms, COBOL-74, XGEN

Set-up and maintained programs for the store’s back-end Barcoding System using CLIPPER.

Conducted unit and system tests and supported actively during user acceptance tests and in addressing production incidents.

MAJOR APPLICATIONS/PROJECTS

2017-2017 Interline Brand’s UC2 Project – Use of Interline Brand-issued purchasing cards in Home Depot stores throughout USA.

2004-2005 Set up of UOB’s Statement Processing System that runs in UNIX and Papyrus which was to be used by all its ASIAPACIFIC branches in compliance to the bank’s Global Hubbing project.

1997-1998 Loans Repayment System: Migration and enhancements of the system that monitors a member’s loan activities and status for the use of the Philippine Government’s Social Security System. Used Unix, SQL*Forms, SQL*ReportWriter, and Cobol.

1995-1996 Robinsons Incorporated Barcoding System: Maintained and enhanced system that retrieves data from the merchandise database to generate barcode for each item received before they are being taken to the selling floor area.

TECHNICAL SUMMARY

Computer Software/Languages/Applications:

20 years experience: COBOL, Oracle SQL and PL/SQL, UNIX Shellscripting, Microsoft Word, Microsoft Excel,

FTP

12 years experience : DB2/SQL, SPUFI, Lotus Notes, Reflection, Serena Dimension, Mercury TestDirector,

Remedy System, StorQM Plus, PDM debugger

8 years experience : CICS Cobol

6 years experience : SQL *Forms, SQL *Menu, SQL *ReportWriter, ORACLE Developer 2000,

Visio, VSAM, IMS, JCL, syncsort, AS400, ILE RPG, ETL

4 years experience: MS-COBOL, XGEN, Micro Focus Cobol, Papyrus Designer version 5.2, Papyrus Client

version 5.2, TSO/ISPF, Clipper, ITX (Interactive Transaction Executive)

3 years experience: Oracle SQL Developer

1+ year experience: Easytrieve, XIDE, Microsoft Visual SourceSafe, JIRA, XGEN Online Designer,

UC4 scheduler, Bridge for Windows, Zephyr, Snaggit, Agile

6 months : C#, Visual Studio

Platforms:

20 years experience: UNIX (user and intermediate admin), Windows, ORACLE RDBMS (with basic

datawarehousing and ETL)

12 years experience: DB2

8 years experience: IBM OS/400

6 years experience: IBM OS/390, IBM VSE/ESA

3 years experience: UNISYS

TRAININGS/SEMINARS ATTENDED

BNP Paribas Asiapacific, Singapore Information Security Management, August 2009

Institute of Advanced Computer Technology Structured System Analysis, November 1999

Structured System Design, December 1999

Documentation Standards, January 2000

United Coconut Planters Bank Developer 2000, October 1997

Forms Designer, Reports Designer

ORACLE Phils ORACLE v7, May 1994

SQLPLUS, SQLForms, ReportWriter,

PL/SQL, SQLMenus

Robinsons Incorporated UNIX SVR4 Operating System, October 1994

Contact this candidate