AS400 programming experience

I have experience in the following industries; Telecommunication, Retail Distribution, Mortgage Software - LSAMS,e-commerce,Sales and Distribution.

• Programming Languages - RPGII and OCL S/36, RPG/400, ILERPG, SQL/400,OS/400, SQL, Embedded SQL, RPGLE, RPG Free CL/400 and CLLE
• Tools - SEU, SDA, DBU, DFU, RLU and QUERY/400.
• Databases - DB2/400,SQL/400,triggers and stored procedures, mySQL.
• Web Technologies - Net.Data, CGI, PHP, XML, JSON, JavaScript, jQuery

May 2004 – August 2006: AS400 Contractor in Alpharetta,GA AT&T Wireless via TechNet Resource Inc.

Responsabilities:

• Software Developer in a Contract assignment at Cingular Wireless. Design, Code, Test, debug and implement RPG ILE programs for a Telecommunication and Billing Client/Server Software System.
• Write and maintain free format RPG ILE, embedded SQL, RPG sub-procedures, RPG Modules and Service programs.
• Debug RPG ILE programs, design and write Technical definition Requirements, Unit Test Plans and Resolve problems reported on Help Desk Tickets related to the System.

Sep 1999 – Sep 2003: AS/400 programmer Analyst at Southern Wine & Spirits, inc. in Miramar, FL

Responsabilities:

• Improved buying efficiencies by creating DDS files and SQL/400 tables to collect nationwide sales for a Data Warehouse application.
• Coded Subfiles programs using SQL and RPG ILE to locate sales by multiples combinations such as items/brands/suppliers.
• Enhanced and maintenance of COBOL/400 and RPG ILE programs for a Payroll System (LAWSON).
• Maintained and created RPG IV, DSPF CL and PRTF files for a Retail/Distribution custom AS400 application.

Programmer Analyst from 02/98 - 08/99 at UAMC Lennar Financial Services, Miami, FL

Responsibilities:

• Maintained and enhanced RPG IV and COBOL/400 programs for mortgage and financial application package (LSAMS and TMO).
• Developed and maintained RPG IV programs for Credit Report (CREDCO) interfaces.
• Enhanced a foreclosure system written in RPG III and COBOL/400 and worked on the Y2K conversion.

Programmer Analyst from 02/96 – 02/98 at Southern & Wine Spirits, Miami Lakes, FL

Responsibilities:

• Developed DDS files, SQL/400 tables and RPG IV programs to collect nationwide sales to populate a Data Warehouse application.
• Created subfiles programs using SQL and RPG ILE to locate sales by multiples combinations such as items/brands/suppliers.
• Enhanced and modified RPG ILE and COBOL/400 programs for a Payroll System (LAWSON).

Application Programmer Analyst from 07/93 – 2/96 at System One Amadeus Inc, Miami, FL

Responsibilities:

• Developed and maintained RPG IV, DSPF, CLP and PRTF files for an Accounting & Travel software package (MAC).
• Isolated and corrected software errors found in RPG IV programs reported by customers of the System One Travel Application system.
• Modified and enhanced existing RPG III programs that interface the airline reservation software with SABRE and System One travel reservation packages.

07/88–05/93 at Baush & Lomb Latin American Div. Miami,FL worked as a Computer Programmer/Analyst

Responsibilities:

• Coded and modified RPG III programs, CL, DDS and subfiles for an Inventory Distribution Package (BPCS) to meet user requirements.
• Designed a fully automated End Day process to execute weekly, daily and monthly processes.
• Coded, tested and implemented RPG III programs to enhance all BPCS application modules such as General Ledger, A/P, A/R, Order Entry, Inventory and Purchasing.
• conversion and migration of all the RPG III, OCL, database files from an IBM S/36 to AS/400 system.