Louis J. Damasco

**** * ****** ****** # *** Phoenix, AZ 85008

Ph: 480-***-**** email: acwh2p@r.postjobfree.com Skype: keystonepilc

ISeries AS/400 Business Application Programmer

Skill Section: RPG III, IV, RPG ILE, RPG FREE, EMBEDDED SQL, COBOL, CLLE, CLP, OCL, XML, Service Programs, Binding Language, API, CEE MS OFFICE, WINDOWS, SYNON, HTML, VBA for Office, IFS, FTP, TCP/IP, ALDON CMS, MySQL, Apache, Python, PHP, Wordpress

Hardware: iSeries AS/400 IBM 3090 Intel PC SYSTEM/38-36

Education: The Pennsylvania State University, B.S.

Delaware County Community College, Data Processing

Keystone Property Investments, LLC 1/02-Present Phoenix, AZ

Consulting Services. IT Contracting, R/E Assignments, E.S.T. consumer product development.

“My Color” Card Stock, LLC Mesa AZ

ISeries AS/400 batch processing back office services, EDI system analysis and data migration programming for proposed EDI systems using RPG FREE, SQL, DB2 and CL programming, Client is a startup company in its first year

ROI Off Market Investment Tracking Phoenix, AZ

Design and analysis of software tracking non listed investments for mapping ‘hot spot’ areas identifying areas of high turnover and properties providing the highest return on investment

Time Warner Cable Company Mililani, HI

RPG FREE, III, IV, and Embedded SQL Programming. Developed Intelligent Home System in XML. Applications for Order Processing, Rates, PPV Event Online, and equipment logistics. Managed IFS services to vendors. Provided Level 2 UR Incident Response.

Automated Appraisal and Valuation System Phoenix, AZ

S/W product development using web APIs to return valuation estimates for lists of properties. Designed AS/400 DB2 database and programs in RPG FREE and SQL. Integrated MySQL database and APACHE server on Windows. Developed multi-platform iSeries/ PC application software.

Mount Vernon Mills 1/00-6/02 Greenville, SC

RPG ILE Embedded SQL Programming in ILE for General Ledger, Accounts Payable and Accounts Receivable Transaction and Inquiry. Programmed service programs imported and exported modules of common procedures used by EMO manufacturing system. Created new VBA reports for BOD using ODBC and SQL Server. Mapped and installed GET PAID credit collection software 3 months ahead of schedule.

Country Curtains 5/99 – 10/99 Lee, MA

Performed system migration to ASTI M/O, Accounting, and Inventory Management Systems on an AS/400. Enhanced current inventory system with a custom application for the controller to locate and inspect missing amounts on year-end reports, disposition of returns, state tax liability reporting, and year-end auditing information. Enhanced data validation procedures.

Montgomery Securities LLC. 12/98-5/99 San Francisco, CA

Managed Y2K preparedness project using a production mirror of the iSeries to test turn of the century functionality. Performed regression testing to establish matching benchmarks on current systems. Developed recovery procedures

Countrywide Home Loans 3/98-9/98 Calabasas, CA

Developer for loan servicing, branch servicing, wholesale and retail loan, marketing, and accounting, divisions using CLP, RPG IV, ILE SQL. Production support of PC network and mainframe-integrated applications. Program enhancements. Maintained FTP and EDI file transmission applications.

Biological Research LLC 10/97- 3/98 Oakland. CA

Private PC Network Information Backup, Recovery and Security System for confidential scientific research project

On Line Systems 9/97 - 10 97 San Jose, CA

MAPICS system modified for hard disk manufacturing company.

Bank of America 5/96- 11/96 Phoenix, AZ

System tuning improvements on AS/400 for client services resulting in a 200% improvement in response time, and

Circle Harper Group, Inc. 10/95-4/96 San Francisco, CA

Developed EDI programs in RPG for a customs brokerage firm, migrating from a mainframe 3090. Formatted all EDI transactions in accordance to EDIFACT standards. Migration support for mainframe 3090 COBOL to CLASS software system on the AS/400 iSeries.

Gourmet Specialties, Inc. 3/95-9/95 . Hayward, CA.

Conversion to Gateway Warehouse System. PREMENOS P/O EDI interface. Programmed software which converted scanned item volume and weight information for use in new GWS BIN creation.

Select Foods, Inc. 8/94-2/95 Hayward, CA

System capacity planning and migration to AS/400 from System /38 Programming in COBOL and RPG. Installed PCAW and supported TRUCKS PC and EDI support for GENTRAN.

PMI 2/94-7/94 San Francisco, CA

Claims processing project using SDLC. Combined functions from several production systems into one custom interface. First release by IBM of embedded SQL in RPG.

McKesson Corporation 8/93-1/94 San Francisco, CA

Wrote applications for distribution, marketing, inventory and sales systems using the AS/400 with networked SYSTEM/36’s at the distribution centers: Process Improvement Project involving a worldwide network of distribution centers.

Bank of America 4/93-7/93 Concord, CA

Programmed PC to AS/400 interface for credit card systems which passed data and image information over ETHERNET link using CPIC on the AS/400.

Los Angeles County Assessor 9/90-2/93 Los Angeles, CA

Programming on multiple platform mainframe, mini, and microcomputer systems written in RPG, COBOL, SAS, JCL, and TURBO BASIC. Manager for a FOXPRO P.C. development and project lead for the County Database Address Correction Project.

Toshiba Electronics 6/90-8/90 El Toro, CA

Programmed in RPG a custom sales tracking and order entry interface to the Arthur Anderson Accounting system for the sales team.

Carnation Company 1/90-4/90 Los Angeles, CA

COBOL Development of the Remote Inventory Management System using System/36 COBOL on the AS/400. Performed code conversion of System/36 OCL to AS/400 CL.

Avery CPD 11/89-12/89 Covina, CA

DMAS/MAPICS System/38 conversion to ASI software. Modifications to Data Collection on System 36’s for B.O.L Interface to production system from warehouses. Installed Hawkeye.

RMC/Lonestar 9/89-11/89 Pleasanton, CA

Analysis of the Address Book in J.D. Edwards Accounting System integrate state/local tax rates at new installation.

Western International Media 9/87-8/89 Los Angeles, CA

RPG programmer for Media Buyers System, YP Advertising System. Networked 3270 emulation to IBM 3090 Donovan Media Buying System in NY. This successful execution resulted in saving the company $500,000 in hardware expense.

Contact this candidate