RESUME OF DESIDERIO U. CANAY with JPEG Certificates

PERSONAL INFORMATION:

Philippine Address: 15F. IlangIlang St., Marulas, Valenzuela City (Presently working in Riyadh Saudi Arabia)

Telephone Numbers; Saudi Arabia: +966******* x237 +966*********

Philippines: +632******* +639********* +639*********

Email Address; abgp97@r.postjobfree.com abgp97@r.postjobfree.com

Place/Date of Birth; BulagaoTuao Cagayan, Philippines May 23, 1951 (63)

Height/Weight; 5 feet 4 inches / 180 lbs

Civil Status / Religion; Married / Catholic

No. of Children: 4 (3 married and 1 single)

EDUCATIONAL SUMMARY:

College ; National University, Manila City, Philippines

1972 – Graduated March 11, 1976

Secondary; Lyceum Of Tuao, Philippines

1965 – 1970

Primary; Tuao Central School, Tuao Cagayan Philippines

1960 – 1965

National University Diploma attached above

EMPLOYMENT SUMMARY:

2013-date Hired as MIS Supervisor dated Nov. 2, 1996 to date (Attached Certificate below)

Presently employed as MIS Supervisor: (Only IT personnel knowledgeable as RPG Programmer

Analyst / BPCS & DB2 Administrator, System OPR, and IT related jobs). Supervising my trained

AS/400 operator for CL operations, SQL online Data Base troubleshooting application and

technique and BPCS 6.1 end-user operators in AWAZEL Headquarter and 5 Remote areas (50

users at the Central Factory, Riyadh Sales, Dammam, Jeddah, Kuwait).

MIS Dept-2013/01 to date: AWAZEL upgrade operating system to IBM OS400 4.R4, and started

using RPGIV compilers. I started re-writing RPGII, RPG400/ILE since 1/1/13 to ILE/IV

PROGRAMMING Language, with RPGIV and all its features (DDS, SUBFILE (db2), Proto-typing,

procedure, sub-procedure, SQLEMBED, SQLPROC, etc). I analyzed, created applied, wrote,

tested, compiled by crtrpgmod – crtbndpgm - crtpgm, sqlrpgi, debug and executed new programs

objects call – callp - callb, in IV or through menu type. With much fruitful experiences stated

below, I can do any RPGII, RPG400, RPGILE & RPGIV programming & analysis jobs my employer

requires / assigns me to accomplish (connectivity and operation) through all the many years I

have been working with the said application software development since 1985, which I am fully

interested to do (in my life )and not afraid of any changes because I had many first hand labor in

new times and places on mid-range computerization projects. Ready to new software

development, studies and abreast new technology knowledge easily.

EMPLOYMENT SUMMARY

(2000-2012

Brief Actual detail works:

(Upgraded implementation and operation of BPCS 6.1)

In the AWAZEL Industries, I worked with the new upgrade from BPCS 4.1 TO 6.1 complete setup

on BPCS FINANCIAL Application and known the interrelations between databases in journal

entries (ghh,glh, gsb,gcr), a/r, a/p, Bil/invoicing, on DISTRIBUTION (iim, dst & ith, iwi, iwh, ili, iln,

ecl, ech, hph, hpo etc and on MANUFACTURING-mbm, mpn, mbv, frt, lwk, lrf, created BOM

data base, etc to be effective in the operation and maintenance of BPCS ERP, where we were

trained by SSA representative’s company Riyadh KSA. I was the MIS Supervisor to implement the

FINANCIAL, DISTRITION and the MANUFACTURING. Worked on the DTAARA inlibl for BPCS

security environment (BPCSUSR/T). Controlled the assigning of BPCS Security System and OS400

security to end-users. Our Connectivity software (fully integrated in Industrial City II, Riyadh,

Dammam, Jeddah, Kuwait, Dubai) is CLIENT ACCESS FAMILY through dedicated data lines, later

via internet through private rented IP servers. After implementation, I analyzed, planned, written

all RPGILE & CL programming and PF,LF data base requirements to augment the database engine

of BPCS which I tailored programs according to the needs of AWAZEL Industriesy, in the Physical-

Logical Files which I am well aware of the DATA BASE STRUCTURE from *DTAQ, ABK to ZZT,

parameters data base improvements of BPCS Libraries over the past 20 years. I was able once on

my own to develop websphere parameter connectivity with java script to access the pc via ip 80

that can log into BPCS or operating system anywhere in the kingdom, but was disapproved later

due to security reasons.

Practiced online-SQL, QUERY, SEU, SORT, SDA, DFU operation and function for immediate

solutions to the BPCS operation/maintenance and other subsystems that need enhancements.

Performed Critical Back-up / Recovery jobs, applied PTF and upgrades, processed BPCS Year-End

Closing requirements. Troubleshoot disaster in AS400 Operations, and BPCS when it occurred

and investigate errors by end-users and operators. Planned and implemented other workaround

solutions to BPCS Data Base engine application. I am managing DB2 administration. Given

solutions for technical requirements to run BPCS Operation and Maintenance under AS/400-170e

hardware, I designed pre-formatted business forms to incorporate in RPG400 / ILE printing

programs for automatic printing such as billing, request for purchase, receipt, issues, transfer,

returned items, etc. which BPCS do not possessed. Controlled Security System in the access of

end-users to AS/400 and BPCS Operation as a whole. Laid network cabling, coaxial, RJ45,

amphenol setup and assisted in fiber optics installation done by suppliers, in computer

department and in other AWAZEL departments, using green screen, pc in windows and client

access network. Organized Data Base by reclaim, rgzpfm command functions to rejuvenate

corrupted BPCS PF and LF data base, rewrite physical & logical files etc. Do other related jobs as

required for the Business Solution Operation and maintenance of the company as the lone BPCS

Technical and AS400 operation/maintenance Supervisor.

Company: Arabian Waterproofing Industries, Riyadh Saudi Arabia

EMPLOYMENT SUMMARY:

1996 – 2000

Brief Actual Jobs – Analyst:

Upon start of my employment Nov 2, 1996, I activated long unused BPCS 4.1 Application

Software using 1 of 4 AS/400 F series Hardware. Planned, Defined, created and documented the

coding schemes for Inventory Item Master Records, RCM/customer masters, Vendor Masters,

Location, Accounts Codes, Department Codes, Facilities Codes, Company Codes, Warehouse

Codes, location codes, Salesman codes, Reason Codes and other Codes needed to implement the

BPCS 4.1 Application Software. Presented these codes to the management for approval by using

Power Point. BPCS is a data base engine and needed many transaction pre-Formatted forms

according to company needs. I designed various pre-formatted forms and created printing/

transaction RPG programs, build in a menu type access for BPCS end-users for day to day

business dealings such as: Quotation Order, Customer Order, Delivery, Invoices, Customer

Statement of Accounts; Material Request, Purchase Order, Receipt, Issue, Returned to

Warehouse, Returned to Supplier, Returned to Vendor and others... These pre-formatted forms

were automatically printed through an RPG Programs, I had written according to the option of

the Menu created per end-users, per location/department, had been pre-formatted in all

Departments, Pointof Sales, Locations and many others.

Brief Actual Jobs - Programmer:

Written all RPGII/RPG400, CL programming requirements, do PDM, SQL, QUERY,SEU, SORT, SDA,

DFU for system ease of operation. Do Critical Back-up/Recovery jobs. Apply PTF and upgrades,

BPCS Year-End Closing. Planned and implemented other workaround solutions in BPCS 4.1, Data

Base engine application needs work around solutions for technical requirements to run BPCS

Operation and Maintenance under AS/400f hardware smooth and systematic. Wrote RPG

printing programs for automatic printing such as billing, request for purchase, receipt, issues,

transfer, returned items etc. Control Security System in the access of end-users to AS/400f and

BPCS 4.01 Operation as awhole. Laying network cabling coaxial cable and/or RJ45 in other

departments and green screen pc using windows. Manage DataBase by reclaim, rgzpfm

commands, wrote/rewrote cl, pf, lf files etc.. Repair PC hardware, install required software,

windows, Client Access connectivity, etc. Do otherrelated jobs.

Company: Arabian Waterproofing Industries, Riyadh Saudi Arabia

AWAZEL employment certificate from 11/02/1996 to date attached above

EMPLOYMENT SUMMARY:

1992 – 1996 Hired as MIS MANAGER dated Oct. 11, 1992 – Sept. 9, 1996 (Attached Certificate)

Hired as EDP Manager in 10/11/1992 to 09/09/1996. (with departmental responsibility

to Program, Analyze, Operate S/36 and later the setup/operate new AS400 acquired and

installed/implemented BPCS Manufacturing Software selected by the AG STEERING

COMMITTEE).

Brief Actual Jobs before/after the BPCS selection –AG head implementation team, EDP

Manager, Analyst, programmer:

I had written inventory database item numbering system, type, class, transaction numbers by

utilizing American standard Codes and Mc Master Codes; Account Codes, Location, company,

facilities & department, Customer Master, Vendor Master, salesman, banks, vehicles, etc…

control number coding system. Created RPG400 programs to generate transactions printing

programs such as; invoice, customer statements of accounts, supplier statements, requisitions,

purchase orders, receipt, issues, return-items to the warehouse, RMA, delivery notes, and other

printing requirements by AG group of companies. Laid coaxial cables to green screen in point of

sales in the city, offices. Setup SDLC, communication IBM controllers to dedicated telephone

lines. Planned, Analyst, created subsystems outside BPCS as required by AG group of

companies. I was the only AS400/BPCS TECHNICAL person in the area of system analysis, design,

implementor, system application and design, programming-rpgII, cl, sql, seu, sda, query, pdm,

and other IBM utility software to augment customized programs, bpcs programs and os400

operating system. I was in-charge on the network connectivity using SDLC and CLIENT ACCESS,

coaxial cable, amphenol, RJ45 etc.

ABUNNAYAN COMPUTERSTEERING COMMITTEE (2 years):

Members: 1- Chairman (Mr. Khalid Abunnayan), 3-board members, 1-

WHINNEY MURRAY& CO. (total of 5 members of the board)

Brief Actual Jobs –Executive Secretary/Analyst (not member of the board):

I was hired as EDP Manager by the Abunnayan Group (AG), October 11, 1992. The AG was using

an in-housed Accounting programs developed, running in IBM S/36. While I managed the

Electronics Data Processing(EDP) Department. My main job was to be the work-horse for the

Computerization Project Steering Committee, where acquisition of Manufacturing ERP that will

suite the all AG group of businesses, will prescribe the acquisition of hardware best suited when

ERP is selected. During board meetings, I prepared the presentation of the Chairman, in Power

Point and sometimes assisted him presenting in some areas of computer technicalities and

functionalities for the major applications in FINANCIAL, DISTRIBUTION, MANUFACTURING,

BANKING and TRANSPORTATION applications. I was tasked to write the REQUEST FOR

PROPOSALS (RFP), did research for AG needs and translated into technical writings, and

completed in one year as programmed. Distributed 30 RFP approximately 700-800 pages per RFP

manuals composed of three major needed application for all the various business of Abunayyan

Group: Financial, Distribution and Manufacturing, locally and world known ERP software

companies, including big names such as JD EDWARDS, AVALON, SSA, MPICS/IBM, LAWSON,

INFORMIX, etc., were given 3 months in the hands of the competing ERP companies to respond.

AG received 16 out of 30 software companies who responded, local and international. I had,

singled out the work, evaluated the selection working more or less 15 hours a day to cope up

with the timetable and asked top 10 shortlisted companies to present their ERP to the Board.

Shortlisted 3 companies and ranking were 1.JD Edward, 2.SSA, and 3.MPICS. After many

deliberation to AG Corporate Consultant - WHINNEY MURRAY & CO., SSA came first, and JD

Edwards were the final competitors. Due to the less features in Manufacturing from JD Edwards

during that year, but strong on the other areas, AG Board of Directors and consultants have

awarded the project to SSA. AS/400 was a strong machine to host the BPCS selected ERP

software. I head one year implementation program on AG group with ARABIAN COMPUTER

PROJECTS LTD., implementation team, SSA representatives in Saudi Arabia, completed with us

the final implementation BPCS Application Software. This was my biggest accomplishments in

research / analysis and writing technical tenders for RFP requirements of AG in the completion

in its Computerization Project.

Company: Abunnayan Group, Riyadh, Saudi Arabia

Abunayyan Group employment certificate attached above

EMPLOYMENT SUMMARY:

1991 – 1992 Hired as Section Manager dated Sept. 9, 1991 – Oct. 1992 (Attached Certificate)

Scope of my jobs and responsibilities are: Programming, Analysis and Operation.

Serving the offices and front sales sites and other management offices. Performing all

EDP jobs as I was the only technical person hired by the Farm management.

Brief Actual Jobs: Analyzed, gathered raw data per application as my basis to developed

customized programs, build prime index for inventory, Personnel & Payroll, Financial subsystems,

transportation, and other small application needed. Maintained an in-placed transportation,

marketing & sales, Supermarket Commercial point of Sales subsystems processed in IBM S/36-

5360. Do other related jobs to run the Computer Section Department of the company.

Company: ASTRA FARMS, Tabuk, Kingdom of Saudi Arabia

ASTRA Farms employment certificate attached above

1986- 1990 Hired as EDP Supervisor dated March 25, 1986 – June 7, 1990 (Attached Certificate)

Brief Actual Jobs: Gathered raw data, analyzed as a basis to build flat index file and

wrote RPGII and necessary controls and codes and personally developed Inventory

Control System, Personnel & Payroll System, Property System, Purchasing System, and

other subsystems required in the Operation & Maintenance projects of the

Establishment. The developed systems were written in RPGII, OCL, SEU, SDA, SORT and

other S/36 software utilities. Do other related jobs to run the Establishment.

Company: Al Sagri Trading & Contracting Establishment, Riyadh Saudi Arabia

VP AL-SAGRI Trading & Contracting Est. employment certificate attached above

1983 – 1986 Hired as Programmer Analyst Aug. 2, 1983 –May 31, 1987 (Attached Certificate)

Brief Actual Jobs: Study and Analyze raw records to create flat indexed files and

necessary codes for the Establishments on its computerization requirements in the King

Abdulaziz Military Academy . Have written Inventory Control System, Payroll System in

COBOL using Winchester Wang Computer hardware.

Company: King Abdulaziz Military Academy, Riyadh, Saudi Arabia

American Engineering Al-Sagri Consultant employment certificate attached above

1971 – 1983 Position: SR. DIGITAL COMPUTER OPERATOR (Government Regular Employee Plantilla)

Brief Actual Jobs dated April 5, 1971 to April 12, 1983:

Team Member on the PMIS Project for the whole Armed Forces of the Philippines in the General

Headquarters, Camp Aguinaldo, Quezon City. Doing Data gathering, research and analysis to

develop the Input Output of the Project.

Wrote programs assigned by the System Analyst for Military Personnel

Reporting, using COBOL Programming Language. Tapped as assistant instructor in the

DEPARTMENT teachinG COBOL, in-house training program. Functioned as the senior computer

operator in FACOM, IBM 4341 and IBMs/34 for the AFP COMMUTER SYSTEM COMMAND. Wrote

JCL, OCL, sort and other utilities needed to function the FACOM and S34 computer

hardware(Card System). Functioned as maintenance programmer, using COBOL and running in

IBM4341, S/34 and FACOM 230-45.

Company: Computer Systems Command, GHQ, Armed Forces of thePhilippines

AFP Computer System Command employment certificate attached above.

Management Training:

06-08 Feb 1993 MANAGEMENT SKILLS (Attached Certificate)

Training Center: WHINNEY MURRAY & CO, Riyadh, Saudi Arabia

WHINNEY MURRAY & CO. training certificate attached above.

Computer Training Summary:

10/29 – 11/28/1994 BPCS FINANCIAL / DISTRIBUTION / MANUFACTURING APPLICATION

(w/ Certificate) Training Center: Arabian Computer Projects LTD / SBM/IBM Co., Riyadh, Saudi Arabia

BPCS distributor training certificate attached above, 2 more can be provided when needed.

Computer Training Summary:

07/06 – 09/30/1994 RPG/400; AS/400 DATA BASE DESIGN & CODING; RPG BASIC

(w/ Certificates) PROGRAMMING SKILLS; AS/400 PROGRAMMING DEV’T MANAGEMENT

SBM/IBM EDUCATION CENTER, SAUDI ARABIA

RPG400 training certificate attached above

Computer Training Summary:

06/06 – 07/05/1994 AS/400 SYSTEM FACILITIES; CONTROL LANGUAGE WORKSHOP; SECURITY

(w/ Certificates) IMPLEMENTATION; OPERATION AND MANAGEMENT; DESIGNING APPL.

SBM/IBM EDUCATION CENTER, SAUDI ARABIA

12/85 - 02/2086 S/36 RPGII Work Station File Coding; Work Station Utility Coding;

(w/ Certificates) Display Station Design; Implementation Topics; Operations; RPGII PROGRAMMING

WORKSHOP; RPGII FUNDAMENTALS

SBM/IBM EDUCATION CENTER, SAUDI ARABIA

1971 – 1983 PRGRAMMING - ANS COBOL, PL1, FORTRAN IV, ASSEMBLER

DOS/VSE PROBLEM DETERMINATION; DMS/CICS/VS APPLICATION CODING& DESIGN;

CMS USAGE; XEDIT HANDS-ON; 4300 I/O DEVICES OPERATIONS; 4300 PROCESSOR FOR

OPERATIONS; VM/370; CICS/VS APPLICATION PROGRAMMING; DOS/VS ACCESS

METHOD; DOS/VS SYSTEM FUNCTIONS; ASSEMBLER LANGUAGE, PL/1; S/360 FORTRAN

IV; COBOL PROGRAMMING LANGUAGE; IBM S/360/30 OPERATIONS; 447 ACCOUNTING

MACHINE PANEL WIRING AND OPERATIONS; REPRODUCER/COLLATOR/SORTER

MACHINE OPERATIONS.

IBM PHILIPPINES EDUCATION CENTER, Paseo De Roxas, Makati, M.M.

I HEREBY CERTIFY THAT the information stated above are true and correct to the best of my knowledge. I am

determined to accomplish all responsibilities and commitment as per agreement with my employer.

DESIDERIO U. CANAY

Filipino Citizen

+966-*********

NOTE: All other certificates can be provided through direct email accepting jpeg format.

Contact this candidate