RPG Programmer/Analyst

Judy Gevjan

828-***-****

*******@***.***

Objective

Computer Programmer/Analyst Position on iSeries/AS400 using RPG ILE/400 working remotely/telecommute.

Technical Experience

20+ years in Information Technology

Programming Languages: RPG ILE/400 including Free Form

RPG III

RPG II

Control Language

SQL

FTP

SFTP

Embedded SQL

Programming Tools: QM Query

ROBOT Job Scheduler

AQuestView

DBU File Utility

Hawkeye

Surveyor (Linoma)

Broderick

TrackIt

Visual Studio

Software Packages: Varsity Shipping

Inovis/Trusted Link (EDI)

T.L. Ashford (Labels)

JBA ERP System

BPCS ERP System

Pansophic ERP System

Hardware: IBM iSeries

IBM AS/400

IBM S/38

IBM S/36

Application Experience

Order Entry, Shipping, Invoicing, EDI, Inventory, Payroll, Labels, Quality Assurance, Telecommunications

Certifications

IBM Certified Specialist AS/400 RPG Programmer

Professional Experience

iQuasar 10/2015 – 1/2016

Consultant/Programmer at Frontier Communications

IBM ISeries/AS400, RPG/ILE, Free Form RPG, RPG400, SQL, CL, Aldon, DBU

Updated programs to handle normalized databases using embedded-SQL, procedures and service programs.

Corrected defects by analyzing issue, testing process and changing programs where needed.

Updated programs to incorporate database changes.

Adecco 9/2013 – 3/2015

Consultant/Programmer at IBM/Concentrix Insurance Services

IBM ISeries/AS400, RPG/ILE, Free Form RPG, RPG400, SQL, FTP, CL, Aldon, DBU

Worked with Life Insurance applications.

Worked as Technical Lead on several projects.

Fixed multiple bugs for insurance conversions.

Centric Group, LLC 1/2004 – 9/2013

Senior Programmer/Analyst

IBM ISeries/AS400, RPG/ILE, Free Form RPG, RPG400, SQL, FTP, SFTP, CL, TrackIt, AQuestView, Surveyor (Linoma), QM Query, Trusted Link EDI, Varsity Shipping System

Created SSIS packages from template for Inmate Data Service using scripting and conditional mapping (6 months)

Trained in SQL Server Management Studio using SSRS and SSIS.

Created programs to interface with Varsity Shipping System

Handled various upgrades to Varsity Shipping System

Played integral part in making Varsity Shipping system operational

Created Bill of Lading print process used with Varsity Shipping System

Handled uploads and downloads using FTP and SFTP

Worked in Quality Assurance

Worked on Service Desk

Skilled with TrackIt to handle Help Desk tickets

Created Project Definitions and Programming Specifications with time estimates

High level of proficiency working with Service Programs and Programs with Multiple Modules

Developed and maintained programs in Order Entry, Shipping Systems and EDI

Created SQL RPGLE programs to handle file processing with Embedded SQL

Processed SQL Statements using iSeries Navigator and Surveyor

Developed programs to produce labels to be printed with T.L. Ashford

Intensive debugging and problem solving skills

Assisted with Training of new programmers

Regularly handled on-call/after hour situations

Set up job scheduling using ROBOT Scheduler

Siegel-Robert Plating, Inc. 1/2001 - 10/2003

EDI Specialist

IBM AS/400, RPG400, RPG/ILE, CL. FTP, Trusted Link

Converted EDI from Bisynch to FTP using ANX Connection

Set up FTP through ANX Connection to VANS in Trusted Link

Made upgrades to Trusted Link software

Defined outgoing 830 and incoming 856 specifications for Vendor EDI

Set up customers in EDI for various EDI documents

Created system for handling 820 Remittance Advices

Designed Shipping Labels using T.L. Ashford

Developed and maintained programs to handle incoming and outgoing EDI Documents

Oakwood System Group, Inc. 5/1994 - 1/2001

Programmer/Consultant

IBM AS/400, RPG 400, RPG/ILE, CL, JBA ERP System, Harbinger/Premenos EDI

Set up customers in EDI for 850, 810, 856 and other EDI documents

Created system for producing Advance Ship Notices 856

Created system for processing 869/870 Order Status Report

Modified JBA programs to handle customer requirements for Order processing and Invoicing

Modified JBA programs to handle Kit processing for EDI

Added Container level processing to Pick Notes in Shipping System

Added Royalty processing at Item Level

Added Commission processing at Order Level

Completed Database conversion for Serial Numbers

Supported and enhanced Order Entry (BPCS) including Shipping and Billing

Developed extensive reporting system for major distributor

Created General Ledger interface program

Developed Credit/Debit Memo reprint program

Created summary load report to show Planned and Released Orders

Programmed Retail Parts Price List, which used Product Structure to determine parts sold

Developed Customer Labels print system

Used embedded SQL statement in RPG programs to process files

Solution Consultants, Inc 12/1990 - 4/1994

Programmer/Consultant

IBM AS/400, IBM S/38, RPG III, CL, Pansophic ERP System

Developed Payroll System interface programs

Programmed Label production programs for United Way System

Converted Employee Master file to new format

Created EEO/AAP reporting and Taxable Insurance reporting system

Wrote Corporate/Division 401K Comparison reports

Created Returned Goods System, which interfaced with Order Processing system

Enhanced Tape Management system

Enhanced Pansophic Order Processing system including Order Entry, Shipping, Invoicing and Credit Memos

Created multiple reports for Inventory System

Converted COPICS data to Pansophic Bill of Material files

Converted IBM mainframe JCL to CL

Handled job scheduling using ROBOT

Contact this candidate