ANTONIO C. TUMULAK

**** ***** *** ******, **** **27

Lufkin TX 75901

Tel. 251-***-**** cellular E-mail: ad4lgw@r.postjobfree.com

SUMMARY OF EXPERIENCE:

A proven programmer, business analyst and project team leader who has been able to meet goals and implement effective in-house develop systems and ERP system package within a team-oriented environment. Skills include programming experience in IBM AS/400, IBM 9375 mainframe, and DEC VAX computer systems using ILE RPG IV, RPG 400, CL, DB2/400, PDM, SDA, DDS, DBU, QUERY 400, SQL, ODBC, DDM, ICF, FTP, ALDON, VSAM, CICS, COBOL, PL/I, DOS/VSE, VM/CMS, Navigator, Tab Pro, VMS, DCL, Oracle Sql*Plus, Sql*Forms, Sql*ReportWriter, Sql*Menu, Visual Studio, ASNA Visual RPG and .Net.

PROFESSIONAL EXPERIENCE:

Brookshire Brothers, EAS Admin, August 2019 – Present

● Developed new applications and retrofitted Infinium ERP custom programs utilizing Modules, Service Programs, and Binding Directories with ILE RPG IV, RPG Free, CL, FTP scripts, XML-SAX, IFS, API and embedded SQL in the iSeries system.

● Designed IBM Cognos reports, query subjects, tables, cubes and views using COGNOS BI tools and Framework Manager. Extracted retail store POS TLOG XML daily sales data from store SQL Servers to IBM AS400 IFS folder using FTP protocol, transposed and loaded it to iSeries DB2 tables and views for COGNOS consumption.

● Created Process and Data flow documentations. Interfaced with end-users in resolving production issues, and managed user profiles in AS400/iSeries and Infinium ERP modules/systems.

Caesars Entertainment Inc., Programmer Analyst, June 2017 – May 10, 2019

● Developed and maintained AS400 ILE RPG, CL and SQL based Casino Management System application programs that interfaced with Slots Data System, Enterprise Data Warehouse, Patron Data Base, and Lodging Management System.

● Responsible in assisting Casino Operations, Marketing, Call Center and CEC affiliates in identifying/researching the patterns, trends and anomalies in complex patron related transactions and DB2 files/tables defects. Tracts progress and interacts with management, internal auditors, cashiers, Marker Bank/Cage supervisors, and Caesars Rewards end-users to facilitate resolution of production related issues.

● Participated in on-call rotations supporting 40+ CEC properties on a regular basis. Works with other IT team members on projects related to IPL, Role Swap, and Java upgrades on Windows based servers. Created business process documentations and test plans for QA testers.

Mc Lane Inc., Senior Programmer Analyst, March 2016 – January 2017

● Developed online and batch application programs that interfaced with Oracle DBMS, Cognos Business Intelligence Applications, Transportation Management System, and JDE World 7.3 ERP using ILE RPG IV, CL, SQL, DDS and SDA.

● Created new reports, new video screens, maintained UDC tables and Dreamwriter versions to support various JDE Sales Order related applications, and assisted personnel in researching and resolving production issues.

E&J Gallo Winery, Programmer Analyst, August 2013 - February 2016

● Developed Truck Load Builder applications and programs that interfaced with EDI 850 Composite Order transactions, JDA Demand Planning System and JDE ERP to automate the creation of sales orders from EDI Customers and JDA inventory demand using ILE RPG IV, CL, SQL, DDS and SDA.

● Developed Grape Management System’s Logistics applications that interfaced with NuLogix Transportation Management System and JDE World ERP to automate the processing of invoice payments; improved monitoring of G3’s contract and non-contract farm trucks and equipment.

● Supported JD Edwards World 7.3 ERP system package and assisted personnel in researching and resolving Sales Order related production issues during on-call period; coded new application programs, maintained UDC tables and Dreamwriter versions to support various JDE Sales Order related applications.

Printxcel/Cenveo, Programmer Analyst, June 2006 - July 2012

● Developed new application programs to support legacy Order Entry and Order Tracking Information System using ILE RPG IV, CL, SQL, DDS and SDA. Developed and maintained batch and on-line socket ILE RPG programs to interface with FEDEX SMS Version 8 server for FEDEX Ground shipment freight computation.

● Developed and maintained application programs that interfaced with local JD Edwards World 7.3 and One World 9.0 ERP system package and assisted personnel in researching and resolving production issues with JD Edwards system package; analyzed gaps and data mapping requirements for newly acquired business units of the company. Provided production support to 3 production plants and 4 Sales call centers in a prompt and friendly manner.

● Developed Order Taking and Pricing System for Cenveo Custom Forms Business units using ASNA Visual RPG, SQL and ILE RPG IV in a client/server setup. Defined all the tables, files, reports and screens to support the system. Defined and documented all user requirements, and coded all online and batch programs in accordance with user specifications.

The Pictsweet Company, Senior AS400 Developer/DBA, August 2004 - March 2006

● Developed new application programs to support user requirements using ILE RPG IV, CL, SQL, DDS and SDA. Created batch procedures using CL to cleanup and manage PKMS PIX IFS and DB2 files.

● Designed and documented Salesman Data Warehouse using VISIO. Responsible for mapping S-390 mainframe VSAM data files into AS/400 DB2 physical files to support the necessary data cubes. Developed ETL procedures to cleanse, transport/transform and load data to the Sales Data Warehouse data marts.

● Designed DB2 database files, developed backup and restore procedures, coded RPG and CL programs to provide user requirements not available in the PKMS WMS system. Mapped PKMS shipping and invoice files to EDI 856 transaction data segments using CL, RPG and X-Analysis tools from Databorough; coded CL and RPG programs to automate transfers and processing of files between AS400 and S390 thru FTP and DDM. Assisted Computer Operations in resolving production related issues.

Bass Pro Shops, Programmer Analyst, August 2002 – August 2004

● Developed new application programs and procedures using JDA MMS files and programs to support user requirements not in the base JDA MMS system using AS400, DB2, ILE RPG IV, CL, SQL, DDS, SDA, Query, Hawkeye and Aldon CMS.

● Developed new application program interface for Intermec RF devices and barcode label printer eliminating encoding error and increased the productivity of store personnel by scanning the UPC or SKU number.

● Developed MBNA Gift Card Instant Credit system, which improved Marketing productivity and increased customer retention. Developed retail store application reports and on-line programs for management to measure and monitor productivity level at the Chain, Store, Department, Sub-Department and SKU levels; interfaced with Store Personnel, Accounting Managers, Loss Prevention, and Merchandising Managers during analysis, design and system implementation.

Staples Inc., Programmer Analyst, September 1997 – February 2002

● Integrated the wholesaler logic into Staples’ Catalog Direct Order and Logistics Distribution application systems using AS400, DB2, ILE RPG IV, CL, SQL, DDS, SDA and CMS.

● Developed application program interface to allow Call Center order entry system data to flow thru the Distribution Center application and JDA MMS system retail package. Designed all file formats, report layouts and display screens in coordination with system users.

● Re-mediated RPG ILE and CL application programs and DB2 database files for Y2K and JDA 4.4 release migration in a timely and accurate manner; resolved all system related production issues for 2 Call centers, 2 Fulfillment centers, and 4 Mini-distribution centers.

Clark International, Systems Analyst, February 1996 - July 1997

● Spearheaded in planning, developing and testing all EDI system applications using AS/400, DB2, ILE RPG Systems Analyst IV, CL, SQL, DDS, SDA, EXTOL and Query.

● Analyzed and mapped DB2 data files from and to VICS EDI 850, 860, 856 and 810 transaction set segments.

● Coordinated with trading partners in promoting new versions of VICS X12 release; responsible for preparing project charter, scope statements, project plan, change and risk management, cost and budget tracking. Lead a group of 3 programmers and 2 EDI coordinators.

Temic Telefunken Semiconductor & Microelectronics (Philippines), Systems Analyst and Logistics Systems Coordinator, August 1991 - February 1996

● Served as the project team leader, leading a group of 15 people in implementing CA Masterpiece and IBM COPICS (a.k.a. MAPICS with BOM, MRP II, IA, and COS modules) on time, within budget, and within user requirements. Developed application programs to allow COPICS data to flow thru Computer Associates Masterpiece accounting AR and AP modules; developed procedure manual, designed customized reports, and trained new users how to use the system.

● Interfaced with Production Control, Inventory Control, Budget, Accounting, Quality Control, Warehouse and Receiving personnel in dealing with system related application issues in a timely, friendly and effective manner.

● Maintained and enhanced the Fixed Asset and Inventory Cycle Count system using DEC/VAX VMS and Oracle. Lead and nurtured 2 application programmers and data encoders.

EDUCATION AND PROFESSIONAL TRAINING:

● Bachelor of Science in Mechanical Engineering from University of San Carlos, 1982

● Certificate in Project Management, Systems Analysis and Design, and Relational Database Concepts and Design Institute of Advanced Computer Technology (I/ACT)

● Supervisory Development Course, Kepner-Tregoe Problem Solving and Decision Making, Statistical Process Control, Time and Motion Study, and Process Evaluation Review Technique/Critical Path Method

● Certificate in AS400 System Tools and Implementation including RPG 400, CL, SDA, DDS, DB2, SQL and Query from IBM (Philippines)

● Attended a one week Data Warehousing Concepts and Methodology seminar conducted by The Data Warehouse Institute in Las Vegas, Nevada; attended a one week Visual Studio, Web and Windows based Visual RPG and .Net programming conducted by ASNA in San Antonio, Texas.

Contact this candidate