Developer Analyst

MIKE KATS

*** ******* **** **. • MONROE TWP., NJ 08831

PHONE 732-***-**** • E-MAIL *********@*****.***

OBJECTIVE

Senior Programmer Analyst/Developer with over 20 years experience in an iSeries environment with excellent hands-on skills would like to make worthy contributions toward the success of the organization.

TECHNOLOGY

AS400 RPG-ILE, CL-ILE, DB2 for i, DDS, DDL, SQL, QRY/400, IBM iSeries, EDI, MKS Implementer, TURNOVER Implementer, Abstract, RDi, DBU, Hawkeye, iSeries Navigator, Visio, MS Office

EXPERIENCE

February 2000 – February 2019 New England Motor Freight, Elizabeth NJ

Senior Programmer Analyst/Developer

Strong knowledge and great skills in Free Form RPG programming in RDi environment. Deep understanding and extensive utilization of various ILE concepts such as a modular programming, prototyping, sub-procedure, activation group, binding directory, service program and binder language.

Providing Web Services using DB2 for i support for procedural SQL objects, such as stored procedures and functions, static and dynamic embedded SQL

Researched the best approaches and using modern programming techniques coded the most critical modules of the systems including

-For the Pick Up and Billing systems transforming the EDI 204/211 data into AS400 database; then sending back to EDI customers the 214 files with the freight statuses and 210 files with the invoices.

-Developed from scratch the new Discount System for US shipments and the new Pricing System for US/Puerto Rico shipments by the sea/air.

-For the Request For Quotes system creating stylish Excel reports using Java classes, saving the reports into the IFS using ILE C-language APIs, and e-mailing the reports directly to a client as an attachment using the JavaMail API

-For the Routing Guides and Shipping Schedules system exposing legacy green screen applications to browser using SQL stored procedures that were created and tested with iSeries Navigator tools such as SQL scripting tool

-For the Booking system requesting the server services to transmit the XML outbound document to a client using the TCP/IP Sockets APIs

-For the Billing system zipping and FTPing an Excel or XML document to a client server using Qshell scripting

1993 – 2000 Westwood One Radio Networks New York, NY

Programmer Analyst

Participated in development of the Cost Accounting System to provide the user with fully automated environment for the expense processing. The responsibities included

-Analysis and creation of databases and project specs, programming

-Automate database and ensure data integrity with Referential Integrity and triggers, journaling, and commitment control

-Design of the multiple display files and menus using SDA, subfile techniques, provide contextual help support using UIM panel groups

-For management reporting designed the printer files using RLU; code the batch programs utilizing embedded SQL and Open Query file techniques

-Messages handling utilizing APIs; system testing and debugging

EDUCATION

Kaliningrad University Kaliningrad, Russia

B.S. Degree in Computer Science

Contact this candidate