Over 25 years experience in ISeries RPG application development, enhancement and support mostly on a contract basis.
Currently developing user friendly .Net VB applications that pull data seamlessly from DB2 and remove some of the“green screen” stigma.
Worked on a number of integration projects with outside companies (Sales Simplicity, Sales Force, BuildLinks, Computer Presentations Systems, Corrigo, Texas Capital Bank, IBC Bank,Bank of America, American Express, US Bank, IRS ).
Worked on a number of system conversions to the AS/400 from a variety of systems for companies that have been acquired.
Worked for a number public companies and so am familiar with the rigors of SOX compliance.
OCL Procedures and CL programming (CLP)
RPG II. RPG IV, RPG ILE, RPG SQL, Free format RPG
DB2/400: DDS-Physical Files, Logical Files, Join Files, Data Dictionaries
Screen Design Aid (SDA). Menus, Display Files, Sub-File Programming
File Transfer Protocol (FTP)
SQL Stored Procedures used extensively by my .Net VB applications to pull DB2 data
Java POI used to create native RPGexcel reports and to enable RPG to read an excel spread sheet
Turnover support and administration
IFS object management
Extensive use of XML file data to import/export data to other systems
.Net to DB2 data communication
MS Access, ExcelDB2 data integration