Posted by on April 06, 19103 at 19:22:12:
Seeking information technology work opportunities in other countries commensurate to my skills and qualifications, with potential options for relocation and/or permanent residency.
T E C H N I C A L S U M M A R Y
Proven competence in midrange operations inclusive of database and library/file maintenance, midrange system application analysis, administration and support, data transfer/interface and connectivity.
Proficient and capable in Helpdesk and Desktop support and administration in various client server platforms suchs Windows 98/NT/2000 and Unix/IBM Aix servers. Is knowledgeable in Xbase and GUI programming and knowledgeable in various Cobol programming in midrange-platforms. Have extensive experience in in EDP operations and MIS support functions.
Has strong analytical skills using OLAP, RDBMS, SQL and Client/Server applications. Familiar with internet development platforms and exposed to ERP systems such as SAP/R3 in a manufacturing and logistics concern.
T E C H N I C A L S K I L L S
Hardware : IBM AS/400 midrange, IBM S/36, IBM PC and compatibles,
IBM 300x Servers, Laser Jet Printers, Dot Matrix Printers, IBM 42xx
series printer, Modems, Telephony Earth Stations, PABX systems,
363X Dump Terminals, Laptops/Notebooks, 3COM products
Operating Systems : Windows 3x/9x/ME/2000/NT4/XP, OS/400, OS/36, DOS 2.0 to 7.0
Unix BSD/SystemsV
Languages : Visual Basic 5.0/6.0, COBOL400, BASIC, QBASIC, Dbase, FoxPro,
Clipper 87/5.2, xBASE, CL/400, Query/400
Software Platforms : MS Office 97/2000/XP (PowerPoint, Excel, Word, Access, Outlook),
Lotus Notes Client, Client Access/400, MS Project, Visio,
Telnet, FTP, Internet/TCP/IP, BASIS II, SAP R/3 Client 4.6, ODBC, Lotus
Smartsuite, FrontPage, Dreamweaver, Flash/Shockwave
Unix Shell/Korn scripting. Remey Action Request systems.
Database : DB/400, SQL, SQL/400, Query400, Oracle 8.05, MS Access, Dbase
III/IV/V, Visual Dbase, IBM DB2, Mercator 5.0, Hyperion Essbase OLAP
P R O F E S S I O N A L E X P E R I E N C E
CEVERA Technology Group
Safeway Philtec
15th Flr., Enterprise Tower 1, AyalaCor Paseo, Makati City (January, 2003 – Present)
POSITION: Sr/Programmer/Analyst – Team Leader
Primary duties include:
Provide offshore support to US-based users in the Safeway Inc. with regards to manufacturing and supply chain applications in Windows/Unix platforms. Resolve problems logged at the Remedy system for immediate helpdesk and application support. Develop methods in resolving issues in midrange and desktop application used by the US based company.
System Platforms: Client/Server applications in Windows, xBase systems (VB and Foxpro), Unix jobs and MQ series support and monitoring, Windows2000, Essbase OLAP systems.
BIZTEK TRADING & SERVICES
No. 4 Meadowland Village, Minglanilla, Cebu (August 31, 2002 – January, 2003)
Telefax. No. (6332) 272-9498
POSITION: Managing Consultant
Primary duties include:
Provide business technology solutions to small and medium business entities in the local province of Cebu, Philippines. A hardware and application-based service company offering desktop and pc supplies sales, repair, troubleshooting, networking and application solutions programming and web solutions to retail businesses and other small-to-medium enterprises.
Major Services:
Pepsi Cola Products Philippines – Hardware maintenance provider and applications programming in accounting systems interfaces to server-based Progress system.
TST Computers – provides partnership technology consultation.
Polgates Services – collaborative networking services.
Coca-Cola Bottlers Philippines, Inc – On-call consultancy to AS/400 midrange and data extraction services.
System Platforms: Client/Server applications in Windows, xBase systems, VB 6.0, Web development. SAP and Progress interface.
COCA-COLA BOTTLERS PHILS. INC.
6th Floor, Feliza Bldg., Hererra St. Legaspi Village, Makati City
Tel. Nos. (02) 8406-888
POSITION: Senior Systems Analyst (October 1, 1998 – January 31, 2002)
Primary duties include:
o Provide second-level hardware and software application support for computer equipment and applications to System Coordinators and end users of five (5) separate bottling plants in the CCBPI system in the southern part of the Philippines.
o Initiates and develop designs and improvements in computer systems under the AS/400 platform and WinNT Client/Server environment and introduce new applications for Workgroups and desktop users.
o Coordinate with corporate infrastructure and information technology group for project pre/post-implementations in ERP modules in Finance, Logistics, Human Resources and Sales/Marketing related to business information systems.
o Develop in-house ad hoc programs and solutions to address immediate user needs in the computing processes of the five (5) plants in the area. Design and implement other supportive application and programs using applicable software and tools (Intranet/Internet/Web or Desktop) to improve user generative job functions.
o Report and document system problems to third level support at Head Office for further systems analysis and resolution.
o Administer and monitor system processes in the AS/400, WinNT server, Lotus Notes and Legacy systems such as CA-General Ledger and Accounting Systems
o Provides collaborative services with external/third-party resources like Ng Khai Development Corporation, Primary Software, Alcatel, Siemens, PLDT, IBM Philippines in the procurement and development of computer software and hardware requirements
Major Projects
March 2001 – September 2001
1) As TEAM LEADER and DB DESIGNER, part of the team that successfully developed a data warehousing design - interfacing and consolidation of diverse databases and system platforms into a central database tables - to be used by Senior management as a benchmarking tool to monitor the financial, sales and marketing, operational performance of the company.
Roles and responsibilities:
o Spearheaded the schema design of the database project and conducted period presentation updates to corporate managers and discuss various concerns and development stages of project.
o Established, tracked and assessed project goals, plans, issues, timelines, and action items pertaining to data extraction from the AS/400 database and Excel CSV data and SAP R/3 tables into the Oracle database using Mercator tools and OLAP/ROLAP methodology of Hyperion Essbase.
o Collaborated with the team members in identifying appropriate technology enabled solutions and process improvements.
o Development of procedures for database migration.
Environment: AS/400 files and database, CL/400, SQL.400, Query/400, Mercator, Hyperion OLAP/ROLAP, Essbase, Excel Pivot Tables and Macro Programming, MSAccess tables, Oracle 8.05, IBM AIX, LAN/WAN, Windows 95/98/2000/NT, IBM DB2, ODBC, MS Project, Lotus Notes and Domino and SAP R/3.
May 2000 – January 2001
2) As PROJECT TEAM LEADER and IMPLEMENTOR, designated by Coca-Cola Amatil Computer Services to handle the ONE-BASIS (Beverage Advanced Standard Information System) centralization to the 24 plants throughout the Philippines. A project to consolidate the sales information system of the company’s 24 plants in the Philippines.
Roles and responsibilities:
o Conducted presentation modules and end user training on the new centralized system.
o Analyze existing COBOL/RPG/CL/OCL applications in the AS/400 and submit coding changes and problems to internal/external programmers for revisions or enhancements.
o Facilitated the identification and resolution of issues and the preparation of status materials/reports.
o Ensured project business designs satisfy business requirements and achieve business objectives.
Environment: AS/400 midrange, COBOL/400, RPG ILE as source language, SQL, Clipper 5.2,
Query/400, SQL/400, MS Excel, PKZIP/400, WinNT/2000, Client Access/400, MS DLC as network protocol.
January 2000 – April 2000
3) As PROJECT LEADER, successfully rolled-out implementation of the PC-based Beverage Information System to forty three (43) offsite sales office in the Coca-Cola system to interface sales and accounting/settlement data to and from these off-sites to their respective mother plants.
Roles and responsibilities:
o Revised generic system to conform to local requirements.
o Develop interface and connectivity programs from EBCDIC to ASCII data formats.
o Systems integration and documentation.
o Configured off-site PCs and network protocols to accept and transmit data to the AS/400 server.
o Conducted end user training on the application system.
Environment: Windows 95/98 as client, AS/400 as server, Clipper 5.2, Client Acess/400 Query /400 Manager, dbase files.
May 1999 – December 1999
4) As PROJECT COORDINATOR, a coordinating member of the Y2K Rollover project ensuring compliancy of software and hardware instruments and remediation to Year 2000 rollover
in collaboration with Ernst and Young Computer Auditors and requirements.
Roles and responsibilities:
o Remediate PC legacy systems and date coding changes to conform to Y2K compliancy.
o Coded and optimized stored procedures, SQL queries and triggers from FoxPro 2.0 to Clipper 5.2.
o Collaborated with users, external programmers and other analysts on the operational concerns of the possible effects of the Y2k rollover to legacy systems.
o Conducted inventory and evaluated application programs residing in desktops at five (5) bottling plants.
Environment: Windows 95/98, WinNT, SQL Server 4.0, Lotus SmartSuite, MS Office
September 1998 – February 1999
5) As TECHNICAL SUPPORT, in the AS/400 migration project - operational transfer of Visayas Region AS/400 database and objects and system files for centralization of four (4) S/36 sites to a single AS/400 national computer center.
Roles and responsibilities:
o Modify user profiles and library/object authorization list to new AS/400 native formats.
o Coded and optimized stored procedures, SQL queries and triggers from S/36 format to AS/400 format.
o Assisted users during validation, orientation and walk-through.
o Performed database administrative tasks such as creation of database objects like users, tables, granting of permissions, performance monitoring and fine-tuning, data conversion, and database backup and recovery.
Environment: IBM AS/400, Windows 95, IdeaComm twin axial connections, dial-up Modems and leased lines, Lotus Improv.
COCA-COLA BOTTLERS PHILS – TAGBILARAN PLANT
CPG Avenue, Tagbilaran City, Bohol, Philippines
Tel. No. (038) 411-3206
POSITION: Systems Coordinator (September 1, 1993 – September 30, 1998)
Primary duties include:
o Monitoring and administration of all computer equipment in the plant inclusive of hardware repair & troubleshooting, software installation and upgrades, virus installation, network setup
o Generate reports and data extractions from the S36-based sales information system using suitable computer application tools such as Query/400, SQL/400 and Foxpro/Dbase RDBMS as required by management to monitor the plants sales and financial performance.
o Validates and monitor application inputs/outputs and data linkages of legacy systems on General Ledger, Accounts Payable, Accounts Receivable-Trade, Payroll, Finished Goods and Freights Payable particularly during month-end financial closing.
o Update and maintain vital databases in the AS/400 system such as Outlet Master, Article Master, Sales database, Settlement files, Installation Codes, Sales Accounting, Personnel Master files and validates its accuracy, integrity and conformity to data and system standards. Monitor system interactive and batch jobs and fix system errors caused about by user jobs.
o Oversee the data and voice inter-networking connections within the plant and it’s sales offices under dial-up modems, PABX system, ISDN leased-lines and later satellite/telephony systems.
o Working with other department’s users in their concerns to enhance productivity and efficiency through the use of computers in report preparation and spreadsheet analysis.
o Conduct inventory of computer equipment and maintain supply level of computer supplies and peripherals.
· Major Projects
1) Designed the EDP office with suitable infrastructure and network layout.
2) Developed GL encoding and inventory monitoring program to assist users in financial forecasting, inventory, production/maintenance operations in a beverage manufacturing plant for a periodic cycle using Clipper/Dbase and FoxPro
Environment:- IBM S/36 & AS/400, IBM 5394 Controller, Windows 3.11 for WorkGroups/95
BASIS 2 , OCL/CL400, QRY400, Clipper, Lotus SmartSuite, Siemens PABX, dBase
POSITION: Stores/General Accounting Clerk (February 1, 1989 – August 31, 1993)
Primary duties and responsibilities
- Maintaining inventory levels for production materials and office supplies
- Conducting inventory cycle count
- Prepare Cash vouchers, Journal Vouchers and Stores adjustment memos.
- Assist in budget preparation and financial data preparation.
· Major Projects
- Developed and Inventory and Forecasting system to monitor materials usage in a Bottling Plant using Lotus 123 and Macro.
- Project Controller for a 20 million-expansion project for CCBPI-Tagbilaran Plant, which contributed a one-million savings after audit of project expenditures.
Environment
PC AT, Windows 3.1, Lotus 123, WordStar Pro, Freelance Graphics
E D U C A T I O N
o Systems Technology Institute (Nov. 1986 - December 1987)
Computer Systems & COBOL Programming
o Cebu Institute of Technology (June 1981- Sept. 1985)
B.S. Civil Engineering
Four Years study
o St. Scholastica's Academy (June 1977 - March 1981)
Secondary Education
Second Honorable Mention
o St. Paul’s School of Makati (June 1971 - March 1977)
Elementary Education
T R A I N I N G S/C E R T I F I C A T E S
8/2002 – 3Com University
Certification: Network Solutions Training
2/2002 – Technical Education and Skills Development Authority (Phils.)
Certification: Computer Technician Course
4/2001 - IberPacific Philippines
Certification: Hyperion and Essbase Training, OLAP design and Analysis
11/1999 Questronix Corporation Philippines-Metro Manila-Laguna
Certification: Infinium Technical training,
2/1999 Nk Khai Development Corporation Philippines-Cebu-Cebu City
Certification: MSAccess/Windows programming
2/1998 I/ACT Philippines Philippines-Metro Manila-San Juan
Certification: Visual Basic 5.0, Basic programming and application development
Brainbench Certification: Transcript ID 3387232
Windows 95/98 Proficiency
O T H E R S K I L L S a n d I N F O R M A T I O N
Feature writing, drawing and drafting, Internet research
Four-time Nominee: Employee of the Year Program for Coca-Cola Bottlers Philippines Inc. Tagbilaran Plant for the years 1989,1990,1995,1997.
RPL-assessed as Skilled Computing Professional by the Australian Computer Society
Under ASCO Code 2231-13 (Systems Designer) – September, 2002.
International English Language Testing System (IELTS) Band Score 7.5 - October, 2002.
P E R S O N A L D A T A
Birth Date 15 March 1964
Age 38 years old
Birth Place Cebu City
Marital Status Married
Religion Roman Catholic
Nationality Filipino