SUMMARY:

• IBM iSeries Senior Programmer Analyst / Lead Consultant with over thirty years experience.
• Specialty area of work is on the IBM System i platform using RPG, COBOL and CL.
• Prepared specifications, flow charts, UML diagrams, test scripts and screen designs.
• Developed QA data for quality assurance department to check and verify new and modified programs.
• Instructed computer operations personnel on production runs and end - user material.
• Provided all necessary requirements, test scripts for PMO compliance standards as pertinent.

TECHNICAL SKILLS:

Hardware: IBM 360/370, 43xx, S3/x, iSeries (AS/400) and PCs.

Operating Systems: OS/400 through V7R3, Windows / NT.

Languages: RPG II through ILE, ILE COBOL, SQL, VB, CLLE, CL, OCL and JCL.

Scripts: SQL, FTP / SFTP, HTML, ASP, VB, and JAVA.

Administrative: HP Quality Center, MS Office Suite, Aldon, Turnover, MKS Implementer and Source Safe.

Utilities & Tools: RAD, DBU, SQL, Navigator, Winsmart, Presto, Nexus, Client Access, WDSC, WMQ, IFS management, DB2, Spy View, Sequel, Robot, DBG,, DDS, RLU, RDA, SDA, SEU, TCP/IP, FTP, TATOOLS, NetSoft/400, Reflections/400, EXTERMIN8, RUMBA, Chameleon, Hawkeye, VID 6.0, Connect Direct, ODBC, MPLUS and Manage Now.

Case: Knowledge Ware, MANTIS, CODE/400, Code Generators and ASNA/RPG.

Database Design: DB2, IFS, SQL, CODE/400, Data Queues, stored procedures, triggers, journals.

Applications: PKMS (WMS), JDE World (AR, AP, GL, HR, PR, SA, FA, SOM, WM, MFG, Configurator),LAWSON (AP, AR, PR), ERPLX, BPCS, DATA 3 (Product Manufacturing), EDI, LSAMS, HTE, Eximbills, Archiving, BPCS, ERPLX, BOSS, JDE to SAP migration.

Industries: Designed and developed applications for Logistics / Distribution, Transportation

PROFESSIONAL EXPERIENCE:

Confidential - Deerfield Beach, Fl

Sr. Lead Consultant /Developer

Software: RPG ILE, RPG FREE, CLLE, CLP, RAD, SQL, PML, Javascript, Websmart, Nexus, Presto

Responsibilities:

• Maintenance Programming - Upgrade from BPCS to ERPLX 8.3.5.
• Webmart applications using data from BOSS, BPCS, ERPLX and DB2 data.

Confidential - Sunrise, Fl

Sr. Lead Consultant /Developer

Software: RPG ILE, RPG FREE, ILE COBOL, CLLE, CLP, SQL/

Responsibilities:

• Maintenance Programming - Custom development and product upgrades.
• Production support for Web interfaces with the Power i.

Confidential - Philadelphia, PA

Sr Applications Programmer - International Systems

Software: RPG ILE, RPG FREE, ILE COBOL, CLLE, CLP, SQL, Connect Direct, DB2, DDM, Exit programs, Triggers, Data queues, Turnover, MS Office Products, Windows 7.

Responsibilities:

• Eximbills - Decommission, Archiving, Custom development and product upgrades.
• Constructed test data for the UAT process. Built SQL modules for monthly reporting.

Confidential - St, Petersburg, FL

Sr. Lead Consultant /Developer

Software: COBOL/ILE w / SQL, RPG ILE, RPG FREE, CLLE, SQL, SEQUEL, Viewpoint, HP Quality Center11.0, CD/400, ALDON, MS Office Products, Windows 7, RIVA financial systems interfacing using the IBM I.

Responsibilities:

• Designed and wrote API utility programs for XML using COBOL SAX handler modules.
• Designed the GEP, Export / Transformation batch transactions using IFS, XML, DB2 and ZIP files.
• Designed and wrote the online NEP monitor modules with inquiry, audit and resend control.
• Instructed, trained the programming staff to use the Generic Extract Process and problem support.
• Constructed data for Q/A testing. Assisted Q/A team from inception to implementation phase.
• Developed modules to retrieve total units for a portfolio / customer / sub fund by business date, trade date or price date for batch processing and online inquiry.

Confidential - New Holland, PA

Sr. AS/400 Consultant

Software: COBOL/400, RPG/400, ILE, SQL (embedded), JDE A7.3, Windows Server 2003, DBU, EDI, MS Office Suite, MKS Implementer, Warranty, Marketing, Government Fleet Concessions, AOM, Manufacturing, Order Processing, Logistics / Distribution, Manage Now, MPLUS, Websphere - MQ Series, JDE World A7.3 SAR upgrades.

Responsibilities:

• Developed and modified JDE programs for Logistics Order Processing Network.
• Problem solving, production support and trouble shooting production issues.
• EDI interface programming (214, 219, 220 and 315).
• Corrected, enhanced and modified complex order processing programs.
• Constructed programs, functional/technical specifications, test scripts, flow charts and PMO/SOX documentation.
• In house TMS system, JDE to SAP migration (Address Book, Revenue and Warranty)

Confidential - Houston, TX

Sr. AS/400 Consultant

Software: RPG III/IV, MQ Series, Sterling EDI, Vista, PKMS Version 2001.2 WMS implementation.

Responsibilities:

• Designed, coded/tested MQ Series Bridge using RPG IV and MQ API's for VISTA and PKMS.
• Recreated the MOVEX communications program logic in order for the process to run smoother and improve job performance.
• Designed and coded custom programs for the Hagemeyer PKMS installation.
• Flowcharted job streams and programs using Visio 2000.

Confidential - Ft Lauderdale, FL

AS/400 Consultant / Senior Programmer / Analyst - Special Projects

Software: COBOL/400, RPG/400, ILE, SQL/400, DB2/400, MS/SQL, PKMS, IntrepidVisual Interdev 6.0, VB 6.0, VFP 6.0, VB Script, ASP, JSP, HTML, Email, Custom Fax

Responsibilities:

• Custom programming within the PKMS and INTREPID environments.
• Modified, tested developed new programs, test scripts, flow charts and documentation.
• Assisted the business analyst in creating test scripts for the Q/A process. Mentored co-workers and contractors in the department, reported to the special projects manager and CIO.
• Created interface programs to check and approve credit card customers, to send via email custom reports to designated staff members, send and receive faxes between the vendors and Confidential staff.

Confidential - Delray Beach, FL.

AS/400 Consultant

Software: RPG/400, SQL/400, Excel, HTE Software applications, Y2K, maintenance programming and testing.

Responsibilities:

• Developed, modified tested and debugged code when required on CIS, Client Server, ORACLE API interfaces to Financials, Police, Fleet Management, Cash Receipts, Human Resources and Payroll.

Confidential - Ft. Lauderdale, FL

AS/400 Consultant

Software: RPG/36, RPG/400, Y2K, Banking.

Responsibilities:

• Modified Equation interfaces to the First Data credit card processing system at SFT Bank - Curacao.

Confidential - Boca Raton, FL

AS/400 Consultant

Software: RPG/400, ILE, COBOL/400, SQL, Medical records and Pharmacy systems, Y2K.

Responsibilities:

• Corrected serious data issues from previous Y2K conversion attempts in the data files.
• Developed, modified, tested and debugged programs as requested by the IT manager.

Confidential - Delray Beach, FL

AS/400 Consultant

Software: COBOL/400, RPG/400, LAWSON, DATA 3, Y2K, JDE and Windows NT

Responsibilities:

• Developed, modified, tested and debugged programs as requested for DATA 3. Supported the LAWSON package and designed the file conversion process from DATA 3 for the JDE implementation.

Confidential - Miami, FL

AS/400 Consultant

Software: RPG/400, LSAMS.

Responsibilities:

• LSAMS maintenance project using RPG/400.

Confidential - Ft. Lauderdale, FL

AS/400 Consultant

Software: COBOL/400, RPG/400, JDE and Windows NT.

Responsibilities:

• JDE upgrade and conversion from 5.2 to 7.3 with heavily modified custom code.
• Modified the Human Resources, Payroll and time clock modules.
• Enhanced the Sales Analysis module and created utility programs.

Confidential - Ft Lauderdale, FL

AS/400 Consultant

Software: RPG/400, JDE and Windows NT.

Responsibilities:

• JDE upgrade and conversion from 5.2 to 7.3 with heavily modified custom code.
• Modified the Human Resources, Payroll and time clock modules.

Confidential - Palm Beach, FL

AS/400 Consultant

Software: COBOL/400, RPG S/36, RPG III, RPG/400, ILE, Hawkeye and Windows NT.z

Responsibilities:

• Upgraded S/36 files layouts and programs to improve performance and maintenance of the banking software. Developed file extracts from LSAMS database to archive to the Spyview applications.

Confidential - Boca Raton, FL

AS/400 Consultant

Software: RPG/400, JDE

Responsibilities:

• Historical archiving - created reports, enhanced and maintained RPG JDE modified programs.

Confidential - Delray Beach, FL

AS/400 Consultant

Software: RPG II, RPG III, RPG/400, COBOL/400, SQL/400, MQM/400, AOPS, and Windows.

Responsibilities:

• Used MQ Series to check mainframe inventories for the AS/400 automatic order processing system.
• Cleaned up the contract order processing and data problems.

Confidential - Ft. Lauderdale, FL

AS/400 Consultant

Software: RPG/400, COBOL/400, SQL/400, JDE, OS/2, CODE/400, SNADS, SDLC.

Responsibilities:

• JDE conversion from 2.2 to 5.2 with heavy customized JDE code (AR, AP, FA, SA, AND GL).
• Constructed the General Accounting Remote Pipeline and streamlined warehouse distribution process.

Confidential - Coral Gables, FL

AS/400 Consultant

Software: RPG III, COBOL/400, BASIC/400, OV/400, PC Support/400, JDE, VB and Access.

Responsibilities:

• Migration of data between the AS/400 and LAN systems. Enhanced and customized JDE code.
• Converted the loading rack communications system, WANG COBOL to IBM COBOL/400.
• Developed, modified, tested, debugged and corrected program source code.
• Created interfaces from the ESSO custom COBOL package to the JDE databases.
• Provided remote technical support for the client when problems occurred in the field.

Confidential - Omaha, NE

AS/400 Consultant

Software: COBOL/400, OV/400, DDS, CL, CODE/400, EXTERMIN8, OS/2 and Knowledge ware.

Responsibilities:

• Designed the Child Support Enforcement software for the state
• Determined the magnitude and scope of the project with a projected time line.
• Coded appeals software from design specifications.
• Created complex reports and online programs.