SUMMARY

• Setup, configured, developed, supported and administered LAMP Linux Apache MySQL, PHP/Perl environment with HTML, DHTML, XML, CSS, Javascript, PHP, JSP, Perl, FTP, and Java with JDBC for MySQL and Derby using ImageMagick, iText-PDF, Jmail and Walter Zorn Libraries running Redhat Enterprise / CentOS Linux for 10 years.
• Setup, configured, developed, supported, administered and managed RPG/ILE, RPG/Free, RPG/SQL, JAVA with JDBC for DB2/400, RPG S36EE, RPG IV, RPG III, RPG II, CLP, CLLE, DBU, DFU, QUERY, SDA, SQL and FTP for batch and interactive procedures running on AS400 for 18 years.

PROFESSIONAL

EXPERIENCE: Confidential

Retail Drug Store Chain

• Developed JAVA applets and applications with Eclipse IDE to design and print Rx labels for Zebra Label Printers using Zebra Programming Language ZPL.
• The programs maintained XML and/or Oracle DB for label format specifications. Program generated ZPL stream to be passed to a network Zebra printer for printing.
• Multiple label formats were consolidated to form a single run unit that printed multiple labels with multiple label formats.

Confidential

Photo Album Lab

• Created and enhanced web site with shopping cart , photo uploading, online ordering, photo sharing, wedding photo albums, photo books and cards.
• Programs were written using LAMP Linux Apache MySQL, PHP/Perl environment with HTML, DHTML, XML, CSS, Javascript, PHP, JSP, Perl, FTP, and Java with JDBC for MySQL and Derby using ImageMagick, iText-PDF, Jmail and Walter Zorn Libraries.
• Setup, configured and administered web server running Redhat Enterprise / CentOS Linux.

Confidential

Photo Album Manufacturer

• Developed JAVA programs using Derby JDBC for order entry of photo albums.
• The programs created XML file to be sent by FTP with the the photo images to an outside vendor to produce the album pages.

Confidential Vitamin Manufacturer

• Made custom modifications to their various systems on the AS400 using RPG/ILE and CLLE for batch and interactive procedures.
• Created Printer Overlays using Excel.
• Administered additions and modifications to user profiles, program profiles, and the DB2/400 database.
• Used Implementor, Hawkeye, and DBU application utilities in the performance of the job.
• Programs were written and modified with embedded DB2/400 SQL, RPG/ILE and RPG Free.

Confidential Telecommunications

• Made custom modifications to their various systems on the AS400 using RPG/ILE, RPG Free and CLLE for batch and interactive procedures.
• Used Implementor, Hawkeye, and DBU application utilities in the performance of the job.
• Created programs to convert data with RPG ILE Free and Embedded DB2/400 SQL.

Confidential Food/Beverage Manufacturer

• Documented a customized MAPICS/DB iSeries/AS400 system.
• Wrote programs to extract the system information from their iSeries/AS400 and create RTF documents.
• Database definition RTF documents were generated.
• Program RTF documents were generated for programs used in the last 15 months with description, parameters, called by and called programs filled in.
• Hyperlinks were created for the database definitions, called programs and report samples.
• The program specifications were manually added to the document.

Confidential

Distributor

• As a salaried employee worked as a Senior Developer to create 850 and 867 type EDI transactions for FTP to vendor FTP servers to replace the normal EDI mailbox this was written in RPG/ILE Free Format.
• Wrote and modified CLP and RPG/ILE programs and performed unit and system tests for the APLUS distribution package system.
• Also wrote and made modifications to the custom A/R, Sales, O/E and Purchasing systems using RPG/ILE, RPG/ILE free format, RPG/400, RPGIII, RPGII, RPG SQL and CLP.
• Wrote and tested programs to interface data with the PKMS system.
• Converted interactive and batch programs from RPG to JAVA.
• Created programs to generate Zebra Barcode labels on a PC not connected to the local network with JAVA, JDBC and MySQL.
• Wrote JAVA programs to generate PDF Barcode Books.
• Made an interface from the AS400 to the local network to extract DB2/400 data to a CSV file and emailing the file as an attachment.

Confidential Consulting Company

• As a salaried employee worked as a Consultant to make modifications to AS400 PKMS manufacturing/distribution software for Pliant, a manufacturer of plastic bags and packaging.
• Wrote programs to use the RF terminal barcode scanner for entry of inventory rack locations and inventory production.
• Also wrote programs for regular inventory production entry.
• Used Implementor, Hawkeye, and DBU application utilities in the performance of the job.
• All programs were written in RPG IV ILE at various client sites throughout the country.

Confidential Consulting Company

• Made custom modifications to an AS400 Garment Package.
• Worked on generating customized shipping labels on Zebra and Monarch barcode printers.
• Also worked on sales reporting, inventory reporting, warehouse inventory locator and currency conversions with the ACS and PKMS distribution packages.
• Used Implementor, Hawkeye, and DBU application utilities in the performance of the job.
• All work was done in RPG IV ILE and RPG/400 at client sites in Connecticut, and New Jersey, and the corporate office in Manhattan.

Confidential Consulting Company

• As a salaried employee worked as a Principal Consultant on Impact 2000 analysis and Implement 2000 on the AS400 for EMC at their Hopkinton, MA and Cork, Ireland locations.
• Also worked for Fort James at their Richmond, VA location.
• Databorough X-2000 tool was used for analysis and conversion of the AS400 MACPAC manufacturing systems.
• Created MS Project Plans for the conversion, modification and testing of the multi-site operation.
• Performed as project leader on the Implement 2000 projects.
• Managed the other technical consultants on the project.
• Modified AS400 CLP RPG programs as needed to correct any inappropriate changes the X-2000 tool made.
• Created procedures and programs to install database and program changes into production in the required time window.
• Created ACCESS 97, VBA and RPG IV ILE programs with API's to analyze and document the system.
• Modified COBOL programs as needed for year 2000.
• Installed an off-site AS400 system for conversion and program testing using TCP/IP to interface with the local network.

Confidential Photo Lab

• As a Consultant created web site to upload photos, order prints, and share photos.
• Programs were written in the LAMP environment using Linux. Apache, MySQL, PHP, Perl with HTML, Javascript, ImageMagick, and FTP.
• Setup, configured and administered the web server running Apache, Postfix, ProFTP and MySQL with Redhat Linux. Created a POS cash register system for film processing using VB and MS Access

Confidential Food Manufacturer

• Maintained, enhanced and developed RPG/400 and RPG IV ILE programs for a Manufacturing Work Order System which interfaced with MACPAC on the AS400.
• Used Turnover, Hawkeye, and DBU application utilities in the performance of the job.

Confidential Retail Drug Store Chain

• Installed, implemented and modified JDA Sales Audit and Rebate Systems on the AS400.
• Created and maintained JDA A/R, A/P and G/L system programs.
• Performed maintenance and customization to JDE modules.
• Designed and wrote a Product Return Tracking Entry and Reporting System using MS Access 2.

Confidential

Cable Network

• Created and maintained programs for cable subscription reporting and interactive order transaction processing using embedded and dynamic SQL in RPG/400 programs on their AS400.
• Used Turnover, Hawkeye, and DBU application utilities in the performance of the job.