SUMMARY:

• 20+ years professional experience in Information Technology, and with extensive qualifications in all aspects of IBM iSeries (AS/400) using RPG ILE, RPG 4, RPG 3, Free Format, CLP, and SQL. Programming and analysis, application development both interactive and batch process, sub - file creation, Data conversions, and Report writing.
• 12 years JD Edward World Application ver. A7+ , using PDM Manufacturing, Distribution & Logistics, and Financials A/P & A/R with formal training of application development in Confidential Architecture.
• 2 years JDA Merchandise Management System supporting Purchase Order system and Accounts Payable system.
• 1 year BPCS Distribution application, mainly focus in inventory and warehouse application system.
• Turnover Change Management, Aldon Change Management, Showcase, WebSphere and Hawkeye.

PROFESSIONAL EXPERIENCE:

Confidential, Fairfield, CA

Business Analyst/Programmer Analyst

Responsibilities:

• Support daily user request in JDA Merchandise Management System mainly to Purchasing modules.
• Modification on existing process to automate Price Event changes from spreadsheet to AS400 DB2.
• Developed new reports and maintain check printing process, invoice process, aging reports as part of Accounts Payable systems.
• Developed new screen maintenance part of purchase order entry, P.O. Inquiries, Invoice, and Receiver screen.
• Create new program using FTP process for inventory adjustment, P.O. adjustment and gift cards info upload.
• Support international UK American Greetings stores for JDA MMS providing additional reports in inventory and replenishment. Enhancement of P.O. process thru EDI and warehouse zone/slot setup.
• Support in-house EDI module for Purchase Order and Invoicing using 850, 856, 860, 810 and other related EDI types.
• Provide AS400 or IBM-i system operation backup through HMC and Robot upgrades and setups.
• On-Call support on a weekly basis 7/24.

Confidential, Newark, CA

Sr. Lead Programmer Analyst (RPGIII/ ILE/ SQL Developer)

Responsibilities:

• Revised the Purchase Order entry module to consolidate the trucking delivery date, requested ship date and mode of transportation lead time calculation in PO maintenance.
• Developed new programs to consolidate all related products based on estimated delivery date and adjustment of requested ship date.
• Modification of PO Invoice maintenance programs of its existing problems in subfile display for duplicate records.
• Developed several new screens for inventory allocation, shipment maintenance, PO invoice approval using embedded SQL/400 in RPG ILE programs.
• Revised old RPG 3 source programs in PO maintenance into Service Programs, RPG free format, & SQLRPGLE source type programs to be more efficient in retrieving data and printing reports.
• Ongoing support to IBS application system for the new release version.
• Day to day customer support for Purchasing Systems.

Confidential, Modesto, CA

Sr. Technical Analyst (RPG ILE/SQLRPGLE Developer)

Responsibilities:

• Automate the process of sending compliance reports to different state compliance department.
• Automate the process of Item dimension upload to JDE files.
• Automate the creation of new item branch plant, item cost and item Eligibility files.
• And other user support and maintenance of their JDE applications.
• Consolidate the two (2) separate AS/400 one in Hayward Distribution Center and the other in LA Distribution Center into main IBM-i AS400 in Modesto head office.
• Make changes for most of the programs to point to the new IBMi AS400 system.
• System integration test and implementation and configuration setup of Zebra printers and handheld scanners.
• Maintain EDI data mapping and setting up trading account partner for X12 (810, 820, 850, 855, 856 & 997) documents using Trusted Link EDI software.

Confidential, Melville, NY

Confidential Sr. Technical Analyst (RPG ILE/SQLRPGLE Developer)

Responsibilities:

• Development of new programs from in-house A/P reports to JDE architecture using dreamwriter, processing option, Confidential table and worldwriter.
• Enhancement of in-house A/P invoice programs to integrate with JDE applications and creating new reports running in worldwriter and dreamwriter.
• Development of new application system for Special Price Adjustment to handle supplier special prices and discount.
• Development of new Price Pend applications thru JDE architecture which integrate the processing of information to A/P in-house application.
• Modification of return to vendor (RTV) applications for domestic and foreign exchange rate vendor and generate new reports for RTV applications in A/P.
• Modification of pend release programs in A/R modules, and enhancement of Receipt Entry screen, Customer Information screen in A/R.
• Modification of 146 programs, 14 Physical Files, 22 display files and reports for Cost Expansion projects and create conversion programs.
• Data Integration and Conversion for newly acquired companies to JDE application system.

Confidential, Madison, NJ

Sr. Technical Analyst

Responsibilities:

• Data conversion of Solgar JDE Manufacturing, Warehouse Distribution and Pharmacy system to NBTY system who bought this manufacturing division.
• Pharmacy System Data file conversion to NBTY application system.
• JDE Manufacturing Data file conversion to NBTY application system.
• International data conversion of JDE system to NBTY system ( Confidential .g. UK system, South Africa, Canada, Australia & other Asian countries).
• Converts all World writer reports into RPGLE programs.
• Program analysis and maintenance most of JDE programs based on user request in the following modules: Shop Floor Control, Forecasting, PDM, Purchasing, and Sales Order Processing, Bill of Materials, and Order Replenishment.
• Form-weigh Pharmacy System - an application programming interface on AS/400 as a backend and Oracle as the front end. I designed a system using DATAQ to received Material Work Orders, Part list, Lot#, and process the inventory quantity pass from the Oracle Form-weigh Pharmacy System and process that information to JDE Shop floor modules. This process automates the issuing of materials from JDE interactive screen into batch process.
• JDE Ship Confirmation - Automate the process of JDE Ship Confirm interactive into batch process.
• Lot Control project - implement auto checking of lot and inventory quantity during scanning of order. And configuring the emulator for Motorola Handheld/Mobile Scanner to have interface with AS/400 application system.
• Sales Order Invoice & Purchase Order - Developed the new designed of Invoice form and Purchase order form using AS/400 Advance Printing Function Utility to create an overlay form.
• Create a custom Customer Packing Slip and Customer Picking ticket using AS/400 APFU - Advance Printing Function Utility
• Order Replenishment system - FTP process of order replenishment thru XML files coming from Wholefoods Corporation and Drug fair Company to the IFS (Integrated File System) and transform the order into AS/400 files and process into JDE sales order processing.
• UPS & FEDEX Manifest system - Add the FEDEX to the Manifest system for additional shipping carrier labels and maintain existing UPS Manifest system and develop shipping barcode label using Zebra printer.
• Design new approached of manifest system for Multi-carrier and multiple processing to different Warehouse.
• Create a Barcode Label for the Manifest system, Lot receiving department, Label Department and Distribution.
• On call and Customer Support for JDE Manufacturing Application and In-house Distribution system.

Confidential, Orlando, FL

Sr. Lead Programmer/Analyst

Responsibilities:

• Create a new batch & interactive programs with extensive use of sub-files in the new project.
• Developed a technical specification from the functional specification given, for major modifications of Confidential part of their transaction system.
• Creating new interface programs from and to data retrieval.

Confidential, Lake Mary, FL

Sr. Lead Programmer/Analyst 9

Responsibilities:

• Conversion analysis and programming to help Confidential ’s new clients move from their current Utility system to Confidential CX 5.0 Utility system.
• Conversion of new release of Utility environment to CX environment.
• Customer Support to their government agency clients in Utility system.
• Involved in System Change Request coding for various clients using CIS software and the fixes of various bugs that were there in the base level programs which came about during testing phase.
• Work included discussing specifications with client, writing a requirement document, modifying existing programs, and installing the new code on client’s machine.
• Customer support to move to the new CX 5.0 system version of Confidential utility software to a Y2K ready.
• Conversion - assigned in another project in Montana Power Co. in Butte, Montana for system conversion of their Utility system to Confidential utility system from COBOL to RPG ILE.
• Convert functional specification into technical specifications, and then coding the actual programs based on the specification given.
• Creation of numerous interface programs needed in building/converting several extract data files on the AS/400.
• Involved in developing Communication Programming Interface between the RISC6000 to the AS/400 machine using the CPI communication programming.
• System enhancement based on the user’s request of Montana Power Corporation.

Confidential, Orlando, FL

Sr. Lead Programmer/Analyst

Responsibilities:

• Developed a hotel ticketing and reservation system that been used by their affiliates Confidential Studios Theme Park ticket.
• Based on functional specifications provided by their System Engineer in batch and interactive, I developed a technical specification and programming to their VGS System.
• Perform unit testing, user acceptance and production support.

Confidential, Orlando, FL

Project Leader

Responsibilities:

• Assigned to design and developed a full life cycle project, the Group Reservation System for cruises under the division of Disney Cruise Line. And lead a group of four(4) program/analyst for the development of the applications.
• Preparation of functional specification, technical specification, test scripts, user acceptance and system integration.
• Conduct team meeting, business analyst meeting, user testing, and individual user training, and monitor project time frame schedule and issues.
• Assigned to another project for the enhancement of Hotel Reservation system. And customer support for most of the hotel reservation.

Confidential

Sr. Programmer/Analyst

Responsibilities:

• Tasks ranged from creation of detailed test scripts, QA testing, implementation, and production support for the GRB
• The GRB system was a Client-Server set-up with comprehensive use of data queues. Programming in RPG 3 & 4 ILE was use to developed all the reports needed.
• Extensive batch processing was used for all jobs submitted and retrieving of data from other systems.

Confidential, Orlando, FL

Sr. Programmer/Analyst 5

Responsibilities:

• Developed a conversion programs for flat data files to a new version of Confidential (Comprehensive Banking System) existing files.
• Maintenance and modification of Reports programs based on client specification in TA (Transaction Account) system, LN (Loan System).
• Maintains the old version and upgrade into new version of the Confidential system using utilities like Scompare and Harmonizer.
• Checking and modifying of programs, testing procedures in delivering the final software package to the client.