Sales Manager

Engr. Eliseo R. Mendoza, Jr.

#* ******** **., ******** ******

Brgy Maybunga, Pasig City, Philippines 1607

Phone: 632-***-**** • Mobile: (639**-***-**** • magicJack: 925-***-****

Email: *******@*****.***

IMS DATABASE ADMINISTRATOR

An IMS database administrator for more than three (3) years. With relative experience in IMS

database design, backup and recovery.

Experienced programmer for more than fifteen (15) years in Payroll, Point-of-Sales, Inventory,

Insurance and Telecommunications Systems. Proven talent in the analysis, programming, testing

and implementing applications in support of business operations.

Highly self-motivated, enthusiastic, and profit oriented.

Proficiency in MVS JCL, COBOL/CICS/VSAM/IMS DB/DC/DB2 and Clipper 5.2.

Additional knowledge in Visual Basic 6.0 / MS Access, ADO and HTML.

Summary of Qualification

• MVS/JCL

• Mainframe IMS Database Administration

• Windows NT 4.0 Administration

• Visual Basic 6.0

• Programming in Clipper 5.2

• COBOL/CICS/VSAM/DB2/IMS DB/DC Programming

• ORBIX (Middleware) Programming

• AS400 Operation and System Administration

• NOVELL Netware 4.10 Administration

• Web Page Design (MS FrontPage)

Professional Experience

Developer, Telus International Philippines, 5th Floor, Market! Market!, Bonifacio Global

City, Taguig City, Philippines, 01 April 2008 - Present

Assigned to the Facilities Management System (FMS) project of Telus,

•

the largest telecommunications company in Canada.

Responsible for the program maintenance and testing. Creates or

o

revises programs that conform to the interface agreement (IA).

Does unit testings of the programs created or revised in an

environment dedicated. System testing are done by the clients.

These include components such as COBOL/IMS DB/DC/DB2

programs, PSBs (program specification block), link cards, bind

control cards, PROCs and JCLs. Common tools used are

ENDEVOR (for the version control); SMARTTEST (for testing

online and batch programs); ABENDAID (for abends analysis);

FILEAID (for browsing and editing flat files, VSAM and IMS

databases); and Microsoft Office Communicator and Microsoft

Outlook (for all communications).

Responsible for documentation. Designs UTP (unit test plan) to

o

cover all requirements of the projects and adds results. Common

tools used are Microsoft Excel (for spreadsheets of UTPs) and

Microsoft Office Communicator and Microsoft Outlook (for all

communications).

Analyzes system test and production defects. Posts notes of

o

analysis of the defects assigned. Finds resolutions and delivers

fixes to problems. Reassigns the defects to other groups, if found

incorrectly assigned. Common tools used are Remedy (for

monitoring and filing of defects); and Microsoft Office

Communicator and Microsoft Outlook (for all communications).

Developer, WeServ Systems International, 12th Floor, Net Square Building, 3rd Avenue

corner 28th Street, Crescent Park West, Bonifacio Global City, Taguig City, Philippines, 12

October 2004 - 31 January 2008

Assigned to the Payments and Collections Management Systems (PCMS)

o

project of A T & T (formerly Southwestern Bell Corporation), the largest

telecommunications company in the United States of America and one of

the largest in the world.

Responsible for the program maintenance, testing and

enhancement. Creates or revises programs that conform to the

technical requirements (TR), system feature design (SFD), system

feature application design (SFAD) and interface agreement (IA).

Works closely with the technical architect (TA) in the review and

approval of tasks. Does unit testings of the programs created or

revised in an environment dedicated. System testing are done by

the clients. These include components such as COBOL/IMS

DB/DC/DB2 programs, PSBs (program specification block), DB2

plans, control cards, PROCs and JCLs. Common tools used are

CHANGEMAN (for the version control); EXPEDITER (for testing

online and batch programs); ABENDAID (for abends analysis);

FILEAID (for browsing and editing flat files, VSAM and IMS

databases); and Q Team-Link Messenger and Microsoft Outlook

(for all communications).

Responsible for documentation. Prepares SFAD (system feature

application design) for small projects as in resolutions to live

(production) defects. Creates DD (detailed design) for any

component created or revised and that requires such. Designs UTP

(unit test plan) to cover all requirements of the projects and adds

results. Opens CR (change request) for any change requested on

any environments (lpars). Drafts OIG (operations installation

guideline) for attachment to any change request. All these

documents are reviewed and approved by the technical architect

before filing in a designated folder. Common tools used are

Microsoft Word (for DOCs of SFAD, DD and OIG), Microsoft

Excel (for spreadsheets of UTPs); Vantive (for monitoring and

filing of CRs); and Q Team-Link Messenger and Microsoft

Outlook (for all communications).

Analyzes system test and production defects. Posts notes of

analysis of the defects assigned. Finds resolutions and delivers

fixes to problems. Reassigns the defects to other groups, if found

incorrectly assigned. Provides root causes of the defects solved.

Common tools used are Vantive (for monitoring and filing of

defects); and Q Team-Link Messenger and Microsoft Outlook (for

all communications).

Attends to callouts during the system test and production cycles.

Analyzes and implements the most appropriate and accurate

resolutions in timely manners. Escalates live (production) defects

to technical architect (TA), if neccessary. Common tools used are

Vantive (for monitoring and filing of defects); EXPEDITER (for

testing); ABENDAID (for abend analysis); and Q Team-Link

Messenger and Microsoft Outlook (for all communications).

Database (IMS) Administrator, Government Service Insurance System, 2nd Floor,

Financial Center, Roxas Boulevard, Pasay City, Philippines, 01 October 2001 - 30

November 2004

Upgrades from IMS 5.1 to IMS 7.1. Lead in the upgrading of IMS version

to 7.1

Migration to High Availability Large Database (HALDB).

Converts a large HIDAM database exceeding 8 Gbytes to

PHIDAM.

Participates in design reviews. Attends formal meetings in the design and

implementation of the database.

Analyzes data requirements. Constructs and organizes data structures once

the users have identified their data processing requirements.

Designs database. Database design involves:

Choosing how to physically organize the data

Deciding which IMS processing options needed to use

Making a series of decisions about design that determine how well

the database performs and utilizes available space

Develops and tests database. Creates, loads dummy record, and test the

test database.

Monitors the database. Routinely monitors or checks on it's performance

in TEST and PROD LPAR.

Modifies the database. As new applications are developed or the needs of

the users change, there is need to make changes to the database such as in

database hierarchies (or the segments and fields within them), and addition

(or deletion) of IMS functions.

Implements the database design. Implements the design by describing the

database's characteristics and how application programs will use it to IMS.

This task consists of coding database descriptions (DBDs) and program

specification blocks (PSBs), both of which are a series of macro

statements.

Creates backup of all IMS databases. Implements the daily and monthly

database backups in tapes. They may be physical/volume backups or

image copies.

Recovers database. Restores database to its original condition after it is

rendered invalid by some failures.

Interacts with programmers, system personnel and users in relation to

DBD, PSB and COBOL/CICS/IMS programs.

Participates in the development, modification and testing of

COBOL/CICS/IMS programs for the database integration of all branches.

Analyst / Programmer, Insular Life Assurance Company, 17th Floor, The IL Corporate

Center, Corporate Avenue, Filinvest, Alabang, Muntinlupa City, Philippines, 20 March 2001

- 25 September 2001

Participates in the development, modification and testing of UNIX

COBOL programs.

Interacts with other programmers, system personnel and users in relation

to program specification, change requests, test results and exception

reports.

Develops and maintains Project Activity Tracking System (PATS) using

MS Access.

Analyst / Programmer, Leverage Systems Technologies, Inc., 27th Floor, The Orient

Square, Emerald Avenue, Ortigas Center, Pasig City, Philippines, 01 April 1998 - 30 June

2000

Performs revisions for Y2K compliance of COBOL/VSAM batch

o

programs of CYBORG SS/ST 2.5.

Performs revisions for conversion of COBOL/VSAM batch programs of

o

CYBORG SS/ST 2.5 to CYBORG SS/ST 3.0.

Does service requests for CYBORG SS/ST 3.0 users. This includes

o

new/revision of programs either in COBOL/VSAM or English Language.

Production-on-call support for the Payroll Batch Run.

o

IT Manager, Hang Ten Philippines Corporation, Anaconda Building, 76 F. Mariano Avenue,

Brgy. Dela Paz, Pasig City, Philippines, 01 September 1996 - 31 March 1998

AS400 Operation and System Administration.

•

Develops and maintains Payroll System and Employees Evaluation

•

System using Clipper 5.2.

Maintains the Point-of-Sales System according to the needs of different

•

malls using Clipper 5.2.

Windows NT / Novell 4.10 Network Administration.

•

Web Page design and development for the company’s Web Site in the

•

Internet.

Responsible for supplying management and other departments with

•

accurate and updated data regarding merchandise, sales status and other

information that is vital for the proper management of the business.

EDP Manager, Giordano (Phils.), Inc., 170 Blumentritt cor. Gen. San Luis Sts., San Juan,

Metro Manila, Philippines, 01 June 1993 - 31 August 1996

Develops and maintains Payroll, Inventory and Point-of-Sales Systems

•

using Clipper 5.2.

Novell 4.10 Network Administration.

•

Responsible for supplying management and other departments with

•

accurate and updated data regarding merchandise, sales status and other

information that is vital for the proper management of the business.

Responsible for the hardware maintenance of all computers in the shops

•

and in all offices of the company.

Education & Credentials

B.S. in Civil Engineering, Mapua Institute of Technology

1983 Civil Engineer Licensure Examination, 82.9%

1983 Career Service Professional Examination, 78.17%

Contact this candidate