JBM Programming Services - iSeries (AS/400) Consultant and RPG Programmer

JBM Programming Services

iSeries(AS/400) Senior Consultant/Programmer

Over 29 years of Information Systems and Consulting Experience

Skills Experience 1=Training 2=Light Experience 3=Solid 4=Very Solid 5=Expert/Advisory Level
Platforms	Rating	Packages	Rating	Professional Skills	Rating
iSeries(AS/400)	4	Premenos	4	Business Analysis	3
System 36	4	JD Edwards	3	Oral/Written Communications	4
IBM PC's	4	MAPICS	3	Systems Analysis	4
Windows 98	4	Lawson	2	Database (Relational)	4
NT	3	PeopleSoft	3	Project/Technical Leadership	4
Windows XP	3

Languages	Rating	Tools/Utilities	Rating	Applications	Rating
RPG ILE	4	Client Access	4	EDI	4
RPG Free	4	Websphere Development Studio Client	3	Manufacturing
RPG 400	4	Query 400	4	Order Entry	4
CL	4	DFU	4	Purchasing	4
RPGIII	4	SDA	3	Bill of Materials	3
RPGII	4	DBU	3	Invoicing	4
OCL	4	Word	4	Sales	3
Visual Basic for Applications	4	Excel	4	MRP	3
Visual Basic 6.0	4	Visio	3	Production	3
MS Access	4	PowerPoint	3	Financial
SQL	4	Change Management	3	A/P, A/R, G/L, Payroll	4
DB2	3	Hawkeye	3	Distribution
HTML	4	Turnover	3	Invoicing	4
Active Server Pages	3	Visual InterDev	3	Purchasing	4
		Workgroups	3	Order Entry	4
				Shipping	3
				Warehousing	3
				Sales	3
				FAX FastFax	3

Professional Experience

Manufacturing Company
Programmer/Analyst October 2007 to Present
Platform is an iSeries (AS/400)
The primary project is to design the file structure and process to load a 1Sync database for publication by a third party service to retailers. The design includes what data could be pulled from the current database and what data would have to be maintained separately. The project also includes writing the programs to refresh the intermediate database, maintenance of the intermediate database, and pushing the intermediate database to the third party provider. My secondary responsibility is to support the in house IT staff with the project backlog.

Programmer/Analyst October 2006
iSeries Platform
Platform is an iSeries (AS/400) and GEAC System 21 Application. Provide programming support for application development and project backlog. In October of 2007 they committed to using RPG Free with procedures and prototypes for new development and to using the Websphere Development Studio Client.

Manufacturing Company
Programmer/Analyst April 2005 to Present
iSeries Platform
Visual Basic 6 application interfacing with JD Edwards World 8.1 on the iSeries. The VB6 application is a requisition entry and approval routing system accessing and updating JD Edwards. The VB6 application did not work correctly and was not being used, the 1st phase of the project was to analyze the VB6 application to determine if it could be salvaged and identify key areas to be addressed. The 2nd phase of the project was to modify and enhance the application to make it functional, working with the users on data issues and training. This included documentation of the application, the approval routing, and data flow.

The contract was extended and changed to providing support to the in house IS Department for EDI, additional VB6 projects generating reports from the iSeries database and emailing the reports out, and modifications and enhancements to JD Edwards and the iSeries applications.

Manufacturing Company
Programmer/Analyst March 2005 thru April 2005
iSeries Platform
Platform is a iSeries (AS/400) and GEAC System 21 Application. Supported in-house staff doing a location specific unit-of measure conversion to the database. Researched and documented required file and field changes, setup project control documents, and developed programs for the data conversion.

Manufacturing Company
Programmer/Analyst Oct. 2004 thru Feb. 2005
iSeries Platform
EDI ASN’s on the iSeries. Troubleshooting and modifications to the program that builds the UCC-128 labels to match the ASN’s sent out to the customer. Write programs to audit the ASN’s prior to translation. Redesign and rewrite the ASN build process due to increased complexity caused by shipping from multiple locations and changing customer requirements. Included in the redisgn more control was given to the users requiring less direct involvement by IT personel.

Manufacturing Company
Programmer/Analyst May 2004 to Sept. 2004
iSeries Platform
Worked with a team of in-house technical staff and users to bring other locations onto the iSeries business application software. The iSeries application was GEAC System 21 and the work performed included customization of the application software and conversion of legacy programs. Two additional projects were included in this contract. One involved automating the payroll post to GL process currently being done manually. The second project was the building of interface files using data from the System 21 application to feed a client/server based Capacity Planning application.

Medical Billing Company
Programmer/Analyst April 2004 to Present
iSeries Platform
Work with users to modify existing programs on an AS/400. Work was done from an offsite location using a VPN connection.

Manufacturing Company
Programmer/Analyst May 2003 thru March 2004
iSeries Platform
Worked as technical consultant on a project team to convert from an existing payroll package based on the inhouse AS/400 to PeopleSoft payroll located at corporate headquarters. Developed flat files and spreadsheets from the AS/400 payroll database that were used to update the PeopleSoft database. Would then audit the results against the AS/400 for accuracy. Worked with inhouse staff to customize a Microsoft Access database used for Time and Attendance which was uploaded to PeopleSoft. Wrote programs to capture employee expenses from the invoice files to be used for payroll deductions. Developed procedures and wrote programs to use the files returned from PeopleSoft to update the general ledger; including programs to audit hours paid vs. hours entered, to drill down from a GL Account to the payroll employee detail, to generate accrual and reversal batches for period end posting. Time and Attendance hours were accessed using Client Access ODBC and a linked table in the Microsoft Access database. Time and Attendance hours were used for labor costing, actual labor reporting, safety reporting, etc. Developed reports for HR using the Microsoft Access HR Data Extract from corporate and linked tables to files on the AS/400.

Pest Elimination Service Company
Programmer/Analyst Aug. to Nov. 2002
iSeries Platform
Worked with in-house staff and other consultants on application conversion/modification.

Computer Consulting Company
Senior Programmer/Analyst June 2002 thru July 2002
Web Based, NT Platform
Developed a Code Repository using Visual Basic 6 and Visual InterDev to be deployed on an NT network. This would allow the consultants to add and update programs, code snippets, tips and techniques, which would be accessed over the internet. Any consultant would be able to view and copy these code examples via the internet, to use and modify them for current projects. These code items could be searched by consultant, platform, language, and/or category.

Cellular Communications Company
Senior Programmer/Analyst Jan 2002 thru May 2002
iSeries 400 Platform
Worked with a team of technical people to offer insurance to customers on their cellular phone through a third party insurance company. The programming included tracking accounts with the insurance feature, adding and removing the insurance feature, and using FTP to send and receive insured accounts, claims requests, and processed claims to/from the third party insurance company.

Medical Supply Company
EDI Coordinator
iSeries 400 Platform
Worked on a team of in-house staff and other consultants to develop a warehouse distribution system. Coordinated the EDI interface using documents 850, 855, and 856, and the Premenos EDI package. Defined the initial mapping requirements and worked with users and technical staff on the application interface.

Small Business - Sole Proprietorship
Senior Programmer/Analyst
Standalone PC Platform
Developed an application in Microsoft Access and Visual Basic for Applications to be deployed on a single PC. The application included over 20 tables and queries, 25 forms and 15 reports.

Large Manufacturer of Residential Water Treatment Equipment
Senior Programmer/Analyst
iSeries 400 Platform
Worked with a team of 15 technical and operations people to convert from MAPICS to JD Edwards World and One World Applications. Platform was the iSeries 400 and PC using RPGLE, JDE Event Rule Debugger, C++ Debugger, and Lotus Notes. Worked on the EDI setup for the Advanced Ship Notice document. Responsible for setup and testing of the steps before the creation of the Advanced Ship Notice. Used JD Edwards Event Rule debugger to determine setup and data problems. Wrote programs to extract data from JDE One World files. Wrote programs to convert MAPICS sales history to JD Edwards One World sales history. Identified and notified JDE Development of 6 bugs within One World Software pertaining to Freight update and ASN extract. Performed modifications to the code and event rules.

Manufacturing Company
Senior Programmer/Analyst
iSeries 400 Platform
Responsible for modifying custom applications as needed for MAPICS upgrade. Platform was the iSeries 400 using RPG/400, RPGILE, CL, Hawkeye, Word and Visio. Converted custom programs from RPG/400 to RPGILE. Worked on various backlog requests.

Wholesale/Retail Distributor
Lead Analyst
iSeries 400 Platform
Upgraded their Lawson system from version 6.0 to 6.1. Lawson modules supported were A/P, A/R and G/L on the iSeries 400 platform. Development environment consisted of RPG/400, CL, DBU, Word, Excel and Client/Access. Analyzed modified Lawson programs and all non-Lawson programs that interfaced the Lawson database. Determined which modifications to keep and which were no longer. Responsible for assigning of tasks and development. Worked with operations, users to schedule and coordinate the installation, setup, and modification and testing on system; then the installation, setup, and verification on the production system.

Graphic Arts Distributor
Senior Programmer/Analyst
System36 - AS/400 Platform
Platform worked on was the iSeries 400 usingRPG/400 and CL. Provided primary support for their Daly & Walcott and Premenos. Developed EDI functions with options for on-demand and unattended transmissions. Developed an interface to extract data from the user applications for out-going documents and post in-coming documents to the Daly & Walcott system. Converted a costing system from an ‘actual cost’ basis to an ‘average cost’ basis. Responsible for monitoring system performance and making adjustments. Developed a Remote Order Entry System with security features to allow sales people to access customer data remotely. Also responsible for converting the application from the S/36 to the iSeries 400.

Transportation Company
Senior Programmer/Analyst
AS/400 Platform
Platform was the iSeries 400 using RPG/400 and CL. Completed work in a team environment with three to four other members on the team. Mentored in-house programmer to develop their skills on the iSeries 400 in both operations and programming. Assisted in creating system and development standards. Designed and developed a manifest tracking and settlement system. Wrote interface programs to the order and billing systems. Responsible for the system performance monitoring. Worked extensively with and trained the users. Worked on the driver log tracking system.

Graphic Arts Distributor
Senior Programmer/Analyst
System36 - AS/400 Platform
Platform worked on was the iSeries 400 and SYS/36 using RPGII, OCL, RPG/400, and CL. Completed work independently and within a two to three member team. Converted custom software from SYS/36 to the 36 environment of the iSeries 400. Converted a Remote Order Entry system from SYS/36 to iSeries 400. Setup system values, profiles, and object descriptions on the iSeries 400. Wrote conversion programs.

Construction/Excavation Company
Senior Programmer/Analyst
System36 - AS/400 Platform
Platform worked on was the iSeries 400 and SYS/36 using RPGII, OCL, RPG/400, and CL. Completed work independently and within a two to four member team. Developed a project status-monitoring program through their A/P on the iSeries 400. Worked with IS department manager to add two levels of security to their existing applications. Assigned as Project Technical Lead to migrate from the SYS/36 to the iSeries 400. Responsible for analyzing the SYS/36. Responsible for Project Work Orders which included estimates. Assisted other team members. Wrote conversion programs. Responsible for testing and installation of all programs.

Service Stations - Convenience Store
Programmer/Analyst
PC Platform
Set up point-of-sale network consisting of three PC’s, two as cash registers and one in the office. Developed a PC database using Microsoft Access and Visual Basic for applications. Worked with users to develop a PC database using Microsoft Access and Visual Basic applications.

Manufacturing Company
Programmer/Analyst
System34 Platform
Responsible for system and application maintenance. Developed and installed application software. Responsible for training users.