Project Software Engineer

Willie Ocop

***** ******** ****. **** **, Sylmar, CA 91342

Tel. 832-***-****

Email: abnnkn@r.postjobfree.com

IT Experience: DB2/400, SQL/400, Stored Procedures, Query/400, RPG400, RPG/ILE,

CL, Synon2/E, Synon CM, Implementer, Aldon Change Management, Oracle, SQL,

PL/SQL, Unix, FTP, MS Office Suite, MS Project, Lotus Notes, Visio, KiXtart (PC

Scripting tool), XML, Java and IEF Case Tool, SAP-ABAP

Work Experience:

Jul. 2006 to Mar. 2009 Contract Developer

CEVA Freight Management (formerly SCG Select Carrier Group, a subsidiary of Eagle

Global Logistics, Inc.), Houston, Texas

Duties and Responsibilities:

- Design, develop and implement the SMART400 database and application using

Synon2/E, RPG/ILE (free format) and CL. SMART - Scan, Manifest, Arrive,

Rate and Track CEVA shipments

- Design, develop and implement Multi-Stop Manifest using SMART400

- Design, develop and implement SMART400 Fuel Surcharge Auto -Rating in

Sysnon2/E and RPG/ILE (free format).

- Documentation of Support and Maintenance for the SMART400 application that

was transitioned to HCL consultants.

- Maintain and enhance the HubScan Trailer Application in Synon 2/E

- Develop and implement the data interface application between HubScan and

TMW Software using XML, RPG/ILE (free format), CL and FTP. IBM’s Web

Service Toolkit (developed by Rich Diedrich) was used to create XML files.

- Develop and implement interface application between HubScan and Handheld

applications using SQL Stored Procedures, RPG/ILE (free format), Synon 2/E and

CL on the AS400 (System i).

- Coordinate with Java developer in mapping data fields between AS400 (System i)

files and Handheld system tables.

- Design and develop Mileage database and the corresponding user interface

(display and maintenance functions) in Sysnon2/E.

Oct. 2005 to Jul. 2006 Contract Developer

AMKOR Technology Inc., Chandler, Arizona

Duties and Responsibilities:

- Maintain and enhance Forecast vs Actual Sales application in RPG400.

- Support and maintain Sales Analysis application in RPGIV with embedded SQL.

- Develop CL and Query/400 reports that was used by business users.

- Provided assistance to Billing Support team when additional resource is needed.

- Ensure that AMKOR SDLC (Software Development Life Cycle) proc esses are

adhered to in every step of the application support, enhancement and

development.

Nov. 2000 to Oct. 2005 Sr. Software Engineer

Eagle Global Logistics, Inc., Houston, Texas

Duties and Responsibilities:

- Develop and maintain interfaces between AS400 and Oracle applications using

RPG/ILE (free format), CL, FTP and PL/SQL.

- Maintain and enhance existing Cash Deposit and A/R application using Synon2/E

- Maintain and enhance existing Accounts Payable application using Synon 2/E

- Develop recon reports for Accounting Dept. using Query/400, SQL/400, or

RPG400

- Convert Query/400 reports to Synon 2/E programs

- Use Synon CM and Implementer to promote objects in both the lower tier and

production

- Lead the effort in developing interface programs to migrate Worldport Financials

data to Oracle Financials database using Synon2/E, CL, RPG/ILE (free format),

Unix scripts, SQL Loader and PL/SQL.

- Lead the support of GetPAID Collection Software and maintain and enhance

automated AS400 and GetPAID data interface using RPG400, CL, FTP and

KiXtart (PC scripting tool).

- Develop and maintain Automated Driver Settlement process in Synon 2E

- Develop and maintain Automated Line Haul and Airline Invoice Upload process

using FTP, CL, RPG400, and Synon 2/E

Aug. 1995 to Oct. 2000 Sr. IT Business Analyst

Excel Corporation, Wichita, Kansas

Duties and Responsibilities:

- Maintain and enhance Order Entry System using Synon2 /E

- Use Synon CM and Implementer to promote objects to both test and production

environments

- Lead the effort in implementing Goods & Services Tax (GST) project in Cargill

Australia's Beef business (location: Wagga Wagga, Australia).

- Support Cargill Australia’s Beef Procurement System as well as the data import

process to J.D. Edwards.

- Develop SQL/400 scripts, MS Access database, CL, RPG and FTP programs for

the 1992-1998 Tax Recalculation project which resulted into a $40M refund from

the IRS.

- Served as Project Coordinator for the Y2K Remediation project.

- Prepared and implemented Software Development Methodology

- Lead the effort in implementing MS Project 98 for the IT Dept.

- Lead the effort of MS Project 98 Standards and Guidelines that was published in

the company’s intranet

- Develop and implement Selection and Prioritization of I/T Projects processes

using Lotus Notes.

- Introduce and implement Earned Value Analysis for IT projects

- Lead the effort in preparing business process and data flow diagrams for new IT

projects.

May 1993 to Aug. 1995 Manager (Hands on), AS400 and PC Development

Guarantee Mutual Life Company, Omaha, Nebraska

Duties and Responsibilities:

- Provide technical leadership and guidance to the AS/400 and PC Development

team.

- Prepare, manage and control the budget of the AS/400 and PC Development team.

- Manage the system admin of all Case Tools (IEF, Synon 2/E & Synon CSG).

- Design and develop data models using IEF Case Tool.

- Support data transfer processes between the AS/400 and Oracle database.

- Support document imaging and workflow management (IBM WAF/400) in

AS400.

- Managed successful implementation of the Persistency System project.

- Managed successful implementation of the Agent Information System project.

Mar. 1989 to Apr. 1993 Contract Analyst/Programmer

Saticoy Lemon Association, Santa Paula, California

Duties and Responsibilities:

- Lead the support and enhancement of Citrus Growers Accounting System

- Conduct analysis and design of new and incoming data processing projects

- Provide technical support of IBM S/36 (24x7 schedule)

- Develop data interface programs that transfers CGAS data to MAPICS.

- Develop automated error recovery and system backup procedures.

- Design, develop and implement Auto-Fax of Shipment Orders and Confirmation

using RPGII, OCL, PC Support/36, DOS scripts and Fax server.

- Develop, implement and maintain Lemon Inventory application in S/36.

- Develop, implement and maintain Job Application Process System .

Education: Bachelor of Science in Mechanical Engineering

Far Eastern University, Manila, Philippines

Contact this candidate