Abundio Catarman Navarro
*** *-******* ******, ***** Culo Labangon Cebu City, Cebu Philippines
Mobile No. : +634********/+639*********
Home Tel. No. : 63-32-520****
E-mail : ************@*****.***
TECHNICAL SUMMARY
Almost twenty (20) years of professional experience in Information Technology
Strong analytical and problem solving skills
Sufficient background in business software development and analysis from small to large scale applications using AS400 platform.
Sufficient background in business software development and analysis from small to large scale applications using C#.Net.
Basic knowledge in COBOL/400, CL/400, SQL/400, Query/400, SDA/400, RLU/400
Excellent programming skills in C#.Net,Visual C++,VB.Net, FoxPro 6.0/8.0, PowerBuilder 7.0/9.0/10.5, Java EE,Java SE.
Excellent in MVC 4.0, JQuery, Ajax, Json, HTML5.0, JavaScript,CSS3.0.,DataTables.
Basic knowledge of RPG/400, Smart400
Hard working and team player
SKILLS
Hardware : IBM AS/400, IBM PC Compatible
O/S : OS/400, Windows 95/98/2000/7/8.1/10/MS Server 2003/MS Server 2008, DOS
Languages : COBOL/400, CL/400, SQL/400, QUERY/400, RPG/400, Smart400, C#.Net,Java SE/EE, PowerBuilder 7.0/9.0/10.5, VB.Net, Visual Foxpro 6.0/8.0.
Database : DB2, MS SQL2000,MS SQL 2005,MS SQL2008 R2,MySql 5.2,Dbase 3plus, Foxbase
EMPLOYMENT SUMMARY
August 22, 2007 - March 31, 2017 Sr. Programmer/Supervisor Primary Structure Corporation
V333 V-Rama Ave, Cebu City
Primary Structure Main Building
6000 Cebu City, Philippines
Telephone No. : 63-32-253**** Loc. 1123
January 2, 2007 - July 4, 2007 Analyst/Programmer
Halsangz Plating Cebu Corporation 1st Avenue corner 3rd Street
Mactan Economic Zone 1
6015 Pusok, Lapulapu City, Cebu, Philippines
Telephone No. : 63-32-340****
April 24, 2000 – December 29, 2006 Sr. Programmer/OIC
VGL-Industries, Incorporated
M.C. Briones Street, Mandaue City, Philippines
6015 Mandaue, City
Telephone No. : 63-32-345****
November 03, 1999 – March 30, 2000 Programmer/Assistant IT head
University of Cebu - METC
Alumnus Street, Mambaling Cebu City 6000 Cebu City, Philippines Telephone No. : 63-32-261-****
October 01, 1998 – November 02, 1999 Analyst/Programmer
Gaisano Bros. Incorporated. 50 Colon St., Bgy. Santo Nino, Cebu City,
Colon Street Cebu City
6000 Cebu City, Philippines Telphone No. : 63-32-232-****
FREELANCE EXPERIENCE
Around 2011 Application System Developer
Bohol II Electric Cooperative, Inc.
Cantagay, Jagna, Bohol
Jagna Main Office
6308 Jagna, Bohol Philippines
Telphone No. : 63-38-531-****
Sr. Programmer/Supervisor
Primary Structure Corporation
August 2007 - March 2017.
Accomplishments:
Responsible in the development, system analysis, maintenance and documentation of the existing system of Primary Structures, Corporation and affiliated companies.
Maintained and Developed the following existing systems:
• Customized Human Resource Information System.
This application system is used in generating all needed reports by HR department and employee rates editing when they had salary increase and it includes recruitment process, and employee leaves credit resetting. and this is used across Primary Structures affiliated companies. and written in PowerBuilder 7.0 with MSSQL2000 server backend.
• Customized Payroll Systems
This application system is used in all customized entries and reports it includes customized transaction payslips generation for all staff employee on Primary Structures and in all affiliated companies. and this is written using PowerBuilder 7.0 using MSQL2000 server backend.
• Daily Time Record Systems
This application system is used in processing employee log-in log out transaction per payroll period it will automatically computer the total hours of employee then post to payroll total hours transaction for payroll processing. and this system is used across Primary Structures affiliated companies. and this is written in C#2010 desktop application with MSSQL2000 server backend.
• Bank Generation Systems
This application system is used in auto generating payroll text file format used to upload on the authorized in lined bank of primary structures across to affiliated companies. and the system is capable of generating multiple types of payroll text file format base on bank required column format. The code is written in C#2010 with MSSQL 2000 sever backend.
• Bio Metrics Synchronizer and Scheduling Systems.
This application system is used in automatic synchronization of Bio employee entries on remote
area across Primary Structures affiliated companies so that employee can view live on their Bio entries
on the web, the system has capable of multi scheduling on synchronization process it depends on the
admin settings. Code were written using C#2010 with MSSQL2000 server backend.
• Electronic Eforms Systems
This web application system is used in online employee viewing of Bio Entries, filling OT,DTA,LEAVES and even employee appraisal, personal achievement notice, company accident report, room reservation monitoring, and service vehicle monitoring activity, and with online signatories approval and this application system is accessible through tablet and cell phones which has google chrome application and internet access and this is used across Primary Structures affiliated companies. Code were written using C#.Net with MVC technology, JQuery, DataTables, Json, Ajax, JavaScripts, HTML5, CSS3.0 and in MSSQL2008 R2 server backend.
Halsangz Plating Cebu Corporation
Analyst/Programmer
January 2007 – July 2007.
Accomplishments:
Responsible in the development, system analysis, maintenance and documentation of the existing system of Halsangz Cebu Plating Corporation.
Maintained and Developed the following existing systems:
• Manufacturing Plating System
This application system is used in Monitoring Plating process and capable of tracking materials inventory used for Plating process. written in Visual Foxpro 6.0/MS Access 2007.
VGL-Industries, Incorporated
Sr. Programmer/OIC
April 24, 2000 – December 29, 2006.
Accomplishments:
Responsible in the development, system analysis, maintenance and documentation of the existing system of VGL groups of company.
Maintained and Developed the following existing systems:
• Sales and Inventory System(s).
This application system is used in track down all Inventory process base on different clients requirements. Every clients has it's own suited Sales Inventory System and there are 7 different clients during my time, and I made the 7 different Sales and Inventory system to meet each and every client needs. the system is capable of tracking down every in out of goods from VGL warehouse. and it has capability of tracking damage products until proper disposal. and the system is capable of transaction life cycles which is adjustable scheduled it depends on the client needs. All needed reports transactional and summaries is properly define, tested and implemented to each client. the code are all written in Visual Foxpro 6.0 with MS SQL 2000.
• PIPO's Ice Cream Manufacturing System.
This application system is used in monitoring the process of making Ice Cream and capable of tracking down the materials inventory for the whole Ice Cream process, the dosage is made by authorize personnel who knows everything on Ice Cream making process. and the system also capable of auto generating near out of stock materials then automatically create purchase request then automatically see by authorize signatories on every transaction moves with needs on approval. Code were written in foxpro6.0 with MSSQL 2000.
University of Cebu - Maritime Education and Training Center( METC )
Programmer/Assistant IT head
November 1999 – March 2000
Accomplishments:
Responsible in the development, system analysis, maintenance and documentation of University of Cebu - Maritime Education and Training Center.
Maintained the following existing systems:
• Student Registration System
This application system is used in student registration, generating study load, making available class scheduling per student year level. Code were written in CA Clipper5.2 and in Dbase 3plus database backend.
• Student Accounting System
This application system is used in premium computation of student assessment, generating grades, all students account is properly monitoring. Code is written in CA Clipper5.2 and in Dbase 3plus database backend.
Gaisano Bros. Incorporated
Analyst/Programmer
October 1998 – November 1999
Accomplishments:
Responsible in the development, system analysis and technical design, maintenance and documentation of the following systems of Gaisano Bros. Incorporated.
Maintained the following existing systems:
• Payroll System
This application is used in monitoring/recording payroll of all employees. The system involves bonuses, allowances, 13th month pay and calculations of company and employee's share for SSS and HDMF contributions. Involvement includes program modification, programming and documentation. Codes were written in CA Clipper 5.2.
• Gasoline Purchase Order System
This application is used to track down all Company Service Vehicle Gasoline Consumption at it capable of generating monthly service vehicle consumption gasoline report and it is integrated to the accounting system. Code were written in CA Clipper5.2 and in Dbase 3plus database backend.
FREELANCE EXPERIENCE
Bohol II Electric Cooperative, Inc.
Around 2011.
Accomplishments:
Responsible in the development, system analysis and design, maintenance and documentation of the following system of Bohol II Electric Corporation.
• Inventory System
This application system is used in monitoring/recording electrical materials inventory in out, compute number of materials used in installing electrical materials per installer as a custodian of the electrical materials withdraw from stock warehouse. the system is capable of tracking down transaction movement of electrical from purchase requisition until electrical material returns from withdrawing custodian and it will generate monthly transactional and summary report which is feed to accounting department for accountability recording. Code were written in PowerBuilder 7.0 and MSSQL2005 as backend.
Responsibilities
Study the system
Maintained/Developed/Revised modules per request
Produced additional modules per request
Developed from scratch according to client needs
User support/IT Helpdesk
EDUCATION
Bachelor of Science in Information and Computer Science (BSICS)
University of Cebu
Cebu City, Philippines
1997
PERSONAL DATA
Date of Birth : June 27, 1974
Place of Birth : Cagnocot, Villaba, Leyte
Country : Philippines
Home Address : 308 R-Arcenas Street Sitio Culo, Labangon Cebu City, Cebu, Philippines
Civil Status : Married
Religion : Roman Catholic
Weight : 150 lbs.
Height : 5’ 7”
Citizenship : Filipino
SEMINARS/TRAININGS ATTENDED
Visual FoxPro 6.0(Advanced) Oct 15-26, 2001 NG KHAI Development Corporation
conducted at VGL-Industries, Inc.
Main Office
Instructor Oliver Abellanosa
Ng Khai Representative
Microsoft SQL Server 2000 Feb 7-11, 2005 NG KHAI Development Corporation
Design & Implement Databases conducted at VGL-Industries, Inc.
Main Office.
Instructor Luke Patrick C. Seno
Ng Khai Representative
Administering a Microsoft SQL Feb 25, 2005 Computer Training Labs Cebu, Philippines
Server 2000 Database conducted at VGL-Industries, Inc.
Main Office
Instructor Rodolfo S. Tud Jr.(Microsoft Certified)
MCT/MCDBA/MCSA