KURT WAGNER

*** ****** ***.

Lake Mary, FL *****

Phone: 407-***-**** e-mail: adhow8@r.postjobfree.com

Sr. Software Development Engineer

Summary

** ***.

(i)

RPG III, ILE RPG IV, RPG Free (modular, RPGLE service programs, OS APIs), CL, CLLE

10 yrs.

(ii)

IBM i Java, PHP, HTML5, Net.Data, QShell scripting, PASE, COBOL, DDL, SQL, Web Server, WAS, Actionscript Flash, e-commerce integration, JDBC, IBM i Toolbox for Java, Linux scripting

20 yrs.

(iii)

IBM i (iSeries, AS/400, i5) OS v3r1 to v7r3 installation, networking, administration, configuration, sizing

10 yrs.

(iv)

DB2, DDL, SQL, Embedded SQL, Relational & Check Constraints, Stored Procedures, UDFs, UDTFs,

Json_table function, Consuming and Deploying Rest Web Services and processing JSON via SQL, RPG, YAJL

10 yrs.

(v)

JSON & SOAP Web Services, WSDL, XML, XSD, Oxygen, SOAPUI, SOA, ESB, WAS, LWI, JBoss

10 yrs.

(vi)

CRM DPI Telecom Application (Service Order Processing, Switch & DSL Provisioning, Billing, Promotions, Telecordia USOCs, Outside Plant Service Qualification, POTS, DSL, DSLAM, Wholesale LSR LSOG, SID, Scheduling, Pricing, Promotion, Discount, and Contract Pricing and Qualification.

10 yrs.

(vii)

J.D.Edwards ERP (Sales Order Processing, Billing, Manufacturing, BOM, Routing, Standard Cost Roll-Up, A/R, Purchasing, G/L, Shipping, WordSoftware A7.3, One-World XE, World-Writer, FastR, DD, UDC, VO, Advanced Pricing, Product Configurator, AAIs, Multi-Currency, Multi-Language

10 yrs.

(viii)

RDi, RDP, WDSc, & Eclipse IDEs, Aldon Lmi, Turnover, Hawkeye, X-Analysis, System i Navigator

10 yrs.

(ix)

Websphere MQ Series, EDI X-12, FTP, TCP/IP Socket Layer Programming, FFM, PCML

15 yrs.

(x)

Agile, Waterfall, SDLC, HLE, Dev, QA, UAT, & Prod support, Defect resolution, HP Quality Center, Remedy Heat Tickets

20 yrs.

(xi)

Software Engineering, Architecture, Design, Integration, Conversion, Development, & Modernization

I am interested in a position as RPG Software Engineer or Architect. I am very experienced with the design and development of large databases and enterprise CRM and ERP software. I have over 20 years IT experience in development and architecture roles in telecommunications, manufacturing and distribution, and banking:

Employment History

Tek-Connexion at Federal Express 700 Washington Ave. Suite 566, Bridgeville, PA 15017

Modernization and production support: • Enhancement of TCP/IP socket communication to increase performance needed to handle over a million package transactions per day.

Brightray Consulting Software Engineer at Express-Scripts - 5415 Lake Howell Road #245, Winter Park, Fl 32792 ….. May. 2018 - Present

Modernization: • RPG to RPG Free using procedures and functions in modules and service programs:

•De-coupling of code to database by grouping procedures and functions into service programs where service programs are separated into distinct functional layers - JSON Web Service Layer, Business Logic Service Layer, Data Access Layer, Logical View Database Layer, and Physical Data Table Layer

•Segregation of data and application service program layers into logical domain entities by business unit using domain driven design.

•Decoupling using Domain Model Isolation and requiring the application service layer to only access the Data Access Layer for data within the same domain. When data is required from outside of the domain, it must be obtained by making a web service request and not by accessing the database directly. This allows moving the domain (i.e. customer, product, vendor, etc.) to another provider by repointing the web service request for data retrieval.

IBM i DB2 Database conversion from DDS to DDL for creation of tables, relational constraints, views, and indexes. For application programs, F-Specs and direct I/O access was replaced with embedded SQL, SQL User Defined Functions (UDFs) and Stored Procedures.

•Restful Web Service Conversion of the existing RPG application separated by business units using Domain Model Isolation: I created applications that both provided and consumed web services using a multi-tier architectural approach by separating application processing, data management, and JSON web service functions for various components of business logic.

•Agile Methodology for iterative and rapid development.

STS Consulting Software Engineer at Verizon - 620 Cranbury Road, East Brunswick, NJ 08816

Conversion of large IBM i application from ILE RPG to Java. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Sept. 2015 - Dec. 2017

•Migration of IBM i application to run on IBM AIX or Solaris with the database migrated from DB2 to Oracle.

•Wrote the technical design document for the development team for the conversion of the on-line application.

•Re-engineered the RPG logic into complex SQLs to access the database through JDBC for presenting and updating display fields.

•Researched best approach for to the quickest possible conversion of 400Gb of DB2 tables to Oracle using combinations of imports via SQLLDR and Oracle Gateway for DRDA.

•Created SQL stored procedures and user defined functions that can be called from Java to improve performance for critical functions.

•Migrated processes using Websphere MQ messaging from IBM i (AS/400) to MQ running on AIX and Solaris servers.

•Participated Quality Center defect resolution during UAT testing.

FIS – Fidelity Information Systems 2001 Summit Park Drive, Orlando, FL 32810

Sr. Applications Developer – IBM i . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . December 2013 - Sept. 2015

Banking application conversion from RPG to Java

•Banking application conversion from RPG to Java. Large back end and teller banking application is being converted to have a nice, friendly, and intuitive new user interface, modernization of the database from DDS to DB2 DDL. Utilization of SQL Stored Procedures and User Defined Functions to facilitate calling RPG processes from Java using JDBC or web services, and maintaining IBM i hardware compatibility.

•X-Analysis - Maintenance and use of X-Analysis repositories for “where used” analysis and to generate business rules from RPG to speed the development process and conversion of RPG programs to Java.

•Websphere Application Server 8.5 for IBM i and LWI are used for Java deployments. Java, RPG, & SQL projects are maintained in

•Rational Developer for System i.

Costco Wholesale 2001 NW Sammamish Rd., Issaquah, WA 98027

iSeries EDI Consultant October 2013 – November 2013

•Trusted Link/400 EDI conversion from X12 to XSD (XML schema)

* 204 Load Tender

* 812 Credit Adjustment / Debit Memo

* 820 Remittance Advice

* 810 Invoice

* 850 Purchase Order

Frontier Communications 180 South Clinton Avenue, Rochester, NY 14646

Solutions Architect - DPI Telecom Applications Consultant January 2004 – September 2013

CRM - Web Service Architect for DPI Service Order

•Web Services API Team Lead - Designer & Developer of API SOAP based web services on iSeries (AS/400) written in RPG and Java.

•Designed and developed the SubmitOrder API which processes 60,000 service order requests per day. The SubmitOrder API creates and maintains service order requests and includes new and existing account maintenance, single and monthly recurring item pricing, S&E / USOCs, promotions, scheduling of field service technicians, auto-assignment of plant facilities, automated provisioning of telco switches and DSLAM equipment for POTS and DSL internet service, customer e-mail accounts, directory listings, credit card billing, credit history maintenance, automatically determines order type and service type, and provides confirmation to initiate billing.

LSR Wholesale Order Processing for CLECs

•LSR (Local Service Request) – Wholesale Order Automation - Co-Designed the LSR order framework which accepts wholesale LSR order requests as from CLEC telcos and converts them from the LSOG format to SubmitOrder XML requests which create DPI service orders and set up CLEC billing. Processing differed by region and tariff because some regions adhered to Telecordia USOC definitions while others used proprietary service and equipment items. This automation for CLECs was a requirement of the acquisition of 3 million access lines from Verizon to Frontier.

Switch provisioning and plant automation

•Websphere MQ Series messaging is utilized to transmit central office, switch type, cable, line card, phone number, and feature information to The Connexn for switch provisioning in the appropriate city.

Qualitrol Corporation 1385 Fairport Road, Fairport, NY 14450

IT Systems Manager / JDE Global ERP Director April, 1999 – January 2004

•IT Manager for locations in Fairport, NY location and Stockholm, Sweden

•Project Manager for the implementation of J.D.Edwards ERP in Fairport, NY and converted data from their prior Mapics system.

•Full ground up JDE ERP implementation of JD Edwards WorldSoftware A7.3. Sales order processing, product configurator, advanced pricing, manufacturing, bill of materials, routings, standard cost, purchasing, inventory, warehousing, shipping, A/R, A/P, and G/L.

•Implemented JDE and converted data for company acquisitions in Sweden and Germany. I set up sales order processing, work order printing in manufacturing cells with bill of material and routing instructions. I implemented multi-company, multi-currency, and multi-language components based on user profiles and customer preference profiles.

•Trained financial and manufacturing users in many areas on the new system and modeled process flow on the Fairport, NY operations.

•Implemented Gentran EDI for shipments and invoices (820 & 810).

•Modified the JDE Configurator to allow sales ordering of customized versions of complex manufactured products. Assembly inclusion rules determine which features will work together. Finished product pricing is calculated based on configurator selections. Dynamically created work orders have a bill of material, routing, and work instructions. Unique configurations are added to the item master and branch plant.

•Automated the shipping department by interfacing the UPS WorldShip application JDE. Finished goods are bar-coded in manufacturing by customizations that generate ZPLII language for Zebra bar code printers. A feed is sent to the UPS WorldShip platform that includes the customer's shipping information and the bar code information on the packages. The boxes are then scanned which creates shipping labels and prices the shipment. J.D.Edwards then imports a return feed which adds the freight charges to the customer's invoice and stores the tracking information for the customer facing web interface.

Dole Fresh Fruit Deutschland Stedtdeich 7, 20097 Hamburg, Germany

Sr. Systems Analyst / Programmer July 1998 – April 1999

•Implemented JDE interface feeds from a custom invoicing system to create batch journal entries in JDE and automatically post to the general ledger. This included modifications to the accounts receivable cash applications program to automatically attach relevant accruals such as bonuses and discounts when a customer pays on a specific invoice number.

Johnson & Johnson Ortho-Clinical Diagnostics 100 Indigo Creek Drive, Rochester, NY 14626

Sr. Systems Analyst / Programmer February 1995 - July 1998

•Set up EDI mapping with J.D.Edwards to automate 850 purchase orders using Gentran/400 and Gentran:Director.

•Automated warehouse: Bar code scanning of packages for automatic ship confirmation and addition of freight charges. Created interface feeds between J.D.Edwards and Federal Express Powership Passport and UPS On-Line Professional for ship confirm, billing, and proof of delivery.

•Implemented and supported EMS2000 as a solution to provide export documents for international sales.

Education BACHELOR OF SCIENCE, State University College at Buffalo, May 1990

Major: Information Systems Management and Computer Science

Minor: Astronomy

Fluent in English and German

References Furnished upon request

Contact this candidate