SUMMARY:

• With nearly 20 years iSeries custom application development in CLP, CLLE, RPG II, III, IV and ILE and embedded SQL, I bring the experience required to hit the ground running on any iSeries programming project.
• My talents shine in the development/management of programming on the iSeries which range from native iSeries green screen programming to enterprise programming that interface with iSeries backend modules/ service programs and DB2/SQL/Stored Procedures.
• My core job responsibilities would include all phases of the software lifecycle: analysis, design,code,test,implement, as well as working in an Agile/Scrum program management methodology.
• Eager to work on assignments involving new technologies and web services that interface with iSeries backend modules and service programs, however, very comfortable with native iSeries application development.

SKILLS & EXPERTISE:

• IBM iSeries, AS/400, Sys38
• RPGLE (modules, activation groups, service programs)
• RPG FREE
• RPGIV, RPGIII, RPGII
• DB2 SQL & Embedded SQL
• SQL Stored Procedures
• WebServices (limited)
• CLP
• Technical Recruiting Leadership
• SDLC Team Building
• Agile Team Methodology
• Aldon Change Management
• Turnover Change Management
• X - Analysis
• Hawkeye

EXPERIENCE:

Confidential, TN

ISeries Rpgle/SQL developer

Responsibilities:

• Utilizing Agile/Scrum programming methodology, main job duty is custom iSeries application development utilizing RPGLE/SQL/Stored Procedures/WebServices.
• Sprints consist of 2 week of programming with small to medium deliverables to the business.
• Areas of programming: Global Financial System, Custom Retail Marketing and Accounting application development.
• Examples of deliverables would be:
• Automatic crediting of Global accounts payables each close.
• Apply data gathering “hooks” in deal receiving/booking system to collect promotional contests for marketing.
• Developed an RPGLE program that utilized native spool files and ESNDFILE command to send HTML emails from iSeries.
• Took a 101 class on .NET programming utilizing VS Express 2013.
• Gravitated away from traditional RPG/DB2 programming by eliminating F - specs and utlizing much more embedded SQL and stored procedures to accommodate programming tasks.
• Worked alongside .NET development team to provide stored procs and webservices (SOAP) for data retrieval from the iSeries Power 8 server.
• Coded and implemented RESTFUL webservices to retrieve data from other business units within the company on different LPARS.

Senior i5 Programmer/Analyst

Confidential, Panama City, Florida

Responsibilities:

• Acquired to transition 30 year career long senior developer to retirement who developed %90 of the core legacy applications for the company. Served as technical lead to other developers.
• Modernized many RPGII, III programs to RPGIV and ILE /FREE, as well as implementing improved programming standards and streamlined coding practices.
• Developed a programming tool to aid in the conversion of PF/LF s into DB2/SQL tables and indexes. Incorporated the tables along with embedded SQL into the modernized RPG programs.
• Developed an iSeries application error handler procedure that became mandatory in all iSeries RPG programs. The error handler would handle the exception message by gracefully displaying a user friendly message to user, log the bombing, email IT staff, and exit with no black screen of death and issuing a D ump automatically for further research.
• Developed an iSeries application to serve as a research tool for developers which would allow a search argument to search ALL iSeries source files/members in multiple libraries in the matter of seconds. Found to be far superior than tools such as Hawkeye which usually require a manual FNDSTRPDM to be issued also just to be sure .
• Raw Materials Hold Project - modified pipe mill station programs to check customer requirements and lot counts to prompt operators to cut raw material coupons for internal Q/A testing.
• MUT Prove Up Project - new development implemented to process indications from ID/OD welding station PLC hardware, extract the indication ranges and allow station operator to review indications for each pipe via iSeries RPG subfile program and accept/reject the indications.
• Gained a working knowledge of PHP utilizing iSeries ToolKitService and Zend Server - completed self study assignment calling an iSeries *module from PHP program and displaying returned parm values to screen along with sql calls to DB2 database on iSeries and returning result set to PHP and html browser.

Software Developer

Confidential, Bradenton, FL

Responsibilities:

• Physical inventories are currently allowed Sunday through Wednesday.
• This is problematic for scheduling inventory counts for all stores in a short period of time.
• Modify physical inventory scheduling, processing and posting to allow a physical inventory on any week day.
• Merchandise Price Change Override
• Currently the price change entry programs are being tricked into allowing certain effective dates by setting a job date in the calling CL program.
• This is problematic in that it is allowing any effective date to be entered if desired.
• Prevent price change entry override from allowing past effective dates, allow users with override access to enter an effective date without restrictions from the price change calendar. SAS - Internal Intransit Relief
• Internal In-transit occurs as a result of an Allocation Released in SAS for:
• DC Post Receipts Pre-Allocated Purchase Orders
• Internal In-transit must be relieved when the Merchandise allocated is owned by the store.

Contract iSeries Software Development

Confidential, Miramar, FL

Responsibilities:

• Coding and testing programs written in RPGIV/ILE Free Format on the reservations team.
• Assigned to the compilation of an internal coding standards and processes document to be considered the essential guide for new contractors and existing staff for enforcing a new modern approach to outdated practices.
• Completed a project related to the conversion of cabin configurations in the main booking voyage file. The conversion will address the business need to eliminate hours of housekeeping efforts on board the cruise line ships.
• Converted sql scripts used to create an archive table and purge a production master file into native I/O processing in an RPGLE free program. Program accepts a parm for Inquiry/Report or Update.
• Developed a series of programs utilizing Hawkeye, QROBOT, SOFTMENU, to eliminate countless hours of manually detecting obsolete objects to be de-staged. This program will be used on-going as the tool of choice for the client to use for future de-staging of objects from the system.