Michael Nitka

469-***-****

Objective:

Innovative IBM AS400 System IBMi Programmer Analyst seeks a challenging position where creative ideas can be fully developed into software products, solutions, or enhancements.

Background Summary:

25 + years of programming RPG-FREE, RPGIV-ILE, RPGII, RPGIII, RPG400, DB2 for i SQL, SQLRPGLE, XML/JSON (AWS Web Services) RESTful APIs, Stored Procedures, CLLE, CLP, & OCL.

Experienced in new software development and major modifications to in-house software systems, as well as Integration with 3rd party systems via RESTful APIs and stored procedure API’s using XML, JSON if efforts to customize proprietary vendor software packages.

Modernization skills to transform and modernize client systems.

Development and Analysis of software within Multiple Industries:

Retail, Banking Mortgage/Financial, Distribution, Manufacturing ERP, Oil & Gas, Life/Property Insurance, Transportation, Software, Construction as well as Health Care.

5/2023 to - Senior iSeries RPG-FREE, RPGIV, DB2 for i - Developer /Analyst.

Consultant @ Insurance (remote) - Integration / Modernization Project.

Utilize new RPG-FREE, DB2 for i, SQL DB2 Programming for New Development and modernization of existing applications and Data Analysis.

Build RESTful APIs for Credit Card Maintenance. ADDCC, UPDCC (et.al) Web Services.

Administrated IWS (WebSphere) To Deploy, Maintain and Redeploy Rest Services as needed.

Test Restful APIs using POSTMAN.

Create Test Scripts via POSTMAN and work with QA to gain approvals for Implementation.

Create MTF Solutions using GoAnywhere MFT software to process S3 folder.

2/2022 to 6/2022- Senior iSeries RPG-FREE, RPGIV, DB2 for i - Developer /Analyst.

Consultant @ Win Supply (remote )

RPG - RPG free Modernization Project.

Utilize RPGIV ILE, RPG-FREE, DB2 for i SQL DB2 Programming for New Development and modernization of existing application.

Profound UI tool to develop DAO for MVC 3 Tier architecture stack model using RPG-Free ILE Binding Service Programs and Stored Procedures. IFS, XML Web services

Modernization Converting PF DDS to SQL tables.

Data base Trigger programming.

Agile, JIRA and ARCAD.

4/2021 to 12/2021 - Senior iSeries RPG-FREE, RPGIV, DB2 for i - Developer /Analyst.

Consultant @ AAA Life Insurance – Production Support, Systems Integrations

Utilize RPG400, RPGIV ILE, RPG FREE, DB2 for i SQL Programming for New Development and maintenance of existing legacy application.

RPG-Free, FTP scripts, Embedded SQL developed, implemented, documented all programs tables and data structures required to build/maintain an Automated Interface process that receives payments and transactions electronically from Financial Entity and Clients and subsequently post or maintains accounts to Production database monthly or premium/payment cycle.

General Break Fix maintenance and production support of RPG programs and iSeries processes via ALDON ticketing change management system.

Created “Daily Agent Transaction Report” in CSV Utilizing RPG-Free Format and SQL

Create ROBOT job entry to Send via SFTP.

Provide Triage root cause analysis of ServiceNow Incident Tickets to resolve policy related software issues or assign to resources.

Research Data Journals on Production system for data errors related to Work Tickets.

Perform DEV Ops Admin functions Security, Configurations,Password Resets.

Monitor Xpressions Print Queue and trouble shoot and resolve any issues with Policy prints.

Monitor Ultera Image Server and trouble shoot and resolve any issues with Document Imaging.

Provide Webservices programming XML document transfers and Web Interface using RPGFree DB2 XML-INTO and CGIDEV2 XML toolkit

4/2020 to 4/2021 - Senior iSeries RPG-FREE, RPGIV, DB2 for i - Developer /Analyst.

Consultant @ Allsups /Yesway Stores - Retail Data Migration Iseries Decommission Project

Responsible for Decommissioning And Sunsetting of Allsup’s i7/AS400 Hardware and Software as well as the Data Extraction Project to offload 2 TB of Allsup’s data to Yesway’s SQL storage Server.

Analyze and Manually Convert RPGIII and RPGLE Source Code to RPG FREE or SQL Scripts Equivalents.

Utilize RPG400,RPGIV ILE, RPG FREE, DB2 for i SQL Programming for New Development and maintenance of existing legacy application interfaces with Infinium INFOR ERP- HR, PY, GL,AP, AR modules.

Retro Fit Existing “Green Screen” UI programs to also Export a “CSV” version of report or Subfile.

Database Analysis to resolve User issues at data, program and System level.

Provide Web services stored procedures programming for XML document transfers and Web Interface CGIDEV2 for XML and RPG SQL XML-INTO.

for iSeries System Admin tasks including Security.

Manage i5/OS Net Server via I-Nav monitor 24/7.

Responsible for Daily BOD and EOD processes for Retail Sales Interfaces, Uploads.

Daily, Monthly G/L Reporting and Processing Functions on iSeries.

Responsible for iSeries RPG-FREE programming and development to support System Conversion/Migration effort from AS400 ERP financial applications to SQL Server based PDI accounting software.

Responsible for Support and Coordination of ongoing Migration & Conversion Activities on the AS400 with Server Network IT staff and User Community.

Created i7/AS400 based Source & Data Extraction Tool written in RPG-FREE DB2 for i to automate the Extraction of entire database(s) and Associated Program Source Files and export to IFS and/or route to SQL Servers by library(s).

Tool includes Creation of Data Dictionary Schema of all Tables and Column attributes included in the iSeries Data Extract sent as part and package of Extract to be used as cross reference by Server DBA(s).

Tool Automatically generates the new SQL Tables Scripts based on the Extracted AS400 Data Objects.

Tool allows for tailored Data Extractions by the “Last Changed Date” of an AS400 Data Object.

Created i7/AS400 based Spool File Extraction Tool written in RPG-FREE DB2 for i to Automate Archiving of 120+ Spool file Out Queues and Migrate to IFS or Server while converting to PDF documents.

09/2019 to 03/2020 - Senior iSeries RPG-FREE DB2 for i Programmer Analyst.

Farm Credit Bank Austin Tx

Provide iSeries management and support for Farm View Credit Conversion project as they had no longer employed any iseries personnel on staff. Short Term project because some one has to help them.

DB2 SQL Scripting for Verifications of result of Conversion from Cardinal AS400

Software to the new network based Azure CME system.

01/2019 to 8/2019 - Senior iSeries RPG-FREE RPGIV DB2 for i SQL Programmer Analyst.

USA Staffing @ SWBC - San Antonio, Tx

Created Program and Data Interface(s) to process Srvice Now and Wrkday monthly Inbound Loan and Insurance premium payments contained in a multi format documents sent to the SWBC “Inbound Payments” network folder once a month.

Writing RPG-Free, FTP scripts, Embedded SQL Created, developed, implemented, documented all programs tables and data structures required to build/maintain Automated Interface process that receives payments and transactions electronically from Financial Institutions and subsequently post or maintains accounts to Production database monthly or premium/payment cycle.

General Break Fix maintenance and production support of RPG programs and iSeries processes via ALDON ticketing change management system.

Modify Legacy RPG400 programs allowing option of creating XL spreadsheet versions of “paper” reports.

Programming with RPG-Free and FTP automated scripting via Simple FTP / VB.INI to distribute to the “requestor(s)” via email automatically or on demand Data or Reports.

Utilize RPG programming for Web Services, XML, Parse incoming XML documents (et.al) from IFS and Corporate Network folders and post transactions and incoming member form data to iSeries DB2 database.

Provide Webservices programming for XML XML document transfers and Web Interface using native XML RPG and GIDEV2 for XML.

11/2017 to 11/2018 - Senior iSeries RPG400 RPGIV RPG-FREE DB2 for i SQL Programmer Analyst

BravoTech @ Penhall Industries - Dallas, Tx

Analyze Troubleshoot Financial Database and remediate 26 “Out of Balance” issues in General Ledger.

Enhance Modify Existing CMS/CGC ERP System for A/P, A/R & G/L

Tech Lead coordinate various tasks associated with programming Activities.

Production support Triage of Application and System errors.

Oversee Year 2017 G/L Closing Activities.

Provide Webservices programming for XML document transfers.

Analyze and Implement New Purchase or System.

Generated all new PO data and Item tables from uploaded spreadsheets.

All enhancement written in RPG-FREE format

Create User Documentation and provide Training

2/2017 to 09/2017 - Senior iSeries RPG400 RPGIV RPG-FREE DB2 for i SQL Programmer Analyst

Consultant @ DELL Plano Tx - Dallas, Tx

Modify Enhance expand capabilities of DMS (IBM Document management system) Using RPGIV - RPG FREE Format programming language.

Create Process Control Utility(s) to give granular control of the image copy process by ability to stop and re start an image "Extract" script that can run for as long as 24 hours and crossing System Maintenances hours.

6/2016 - 12/2016 - RHA Dallas Tx - FFE Transportation - Dallas, Tx

Senior iSeries RPG400 RPGIV RPG-FREE DB2 for i SQL Programmer Analyst

Conversion project to Separate Two independent companies that were using same “Innovative” software transportation package and database.

Expand Billing and order amount fields from 7 decimal positions to 17 to accommodate higher rated loads in Oil Gas.

Convert/Upgrade/Test Oil and Gas Deep well “TL” order Entry Dispatch Freight rate.

Convert /Upgrade/Test Oil and Gas Deep well “TL” Invoice Billing and RVI scanning system.

9/2015 - 3/2016 - Senior iSeries RPG-FREE RPG-IV ILE DB2 for i SQL Programmer Analyst

Matrix Resources Dallas Tx GM Financial Services - Arlington, Tx

Payment Incentive Project – Modify FISERV application to incorporate a module to calculate an incentive amount for enrolled customers.

Production support problem solving in LSAMS Loan Servicing environment.

Conversion project to migrate FISERV database.

Analyze database and Create Mapping documents to be used in directing data across systems.

Develop RPGIV RPG FREE solutions to cleans/mask sensitive client information during conversion testing activities.

Develop RPGIV RPG FREE solutions to perform data modeling and migration activities.

IBM Db2 SQL Optimization of RPGSQL programs and scripting.

Testing & Validation of Results.

Embedded SQL Stored procedures & Service programs.Webservices programming XML document transfers and Web Interface using native XML toolkit

9/2014 - 8/2015 - Senior iSeries RPG FREE RPGIV Programmer AnalystDB2 for i SQL GDC General Data - Chambersburg, PA

Conversion project to Migrate HCS (Health Care systems) iSeries data to Non iSeries platform Allscripts. Including Demographics, Billing, Pharmacy data bases

Analyze database and Create Mapping documents to be used in directing data across systems.

Develop RPGIV RPG FREE solutions to perform migration activities.

Testing & Validation of Results. General maintenance to MAPICS XA INFOR XA Manufacturing ERP system

Experience:

Avatar Consultative Services - 1998 to 2014

Senior iSeries RPGIV RPG-FREE DB2 for i SQL Programmer Analyst Data Analyst

TIAA-CREF – Charlotte, NC - ID3 Insurance Software 2012-2013

AS400 Decommission and ID3 Sunset Project

Senior iSeries RPG-FREE,RPGIV, DB2 for i SQL Programmer Analyst

Project to identify applications and components to be sunset as part of an overall project to decommission an existing AS/400 iSeries attached to large network infrastructure. And subsequently provide data archive and retention plan going forward as well as functional programming to achieve result for client.

Gather application/component documentation and technical knowledge.

Create application/component decommissioning requirements specification.

Validate application/component technical decommissioning solution.

Develop technical programming specifications.

Develop data conversion programs and archive solutions in RPGIV RPG-FREE format.

Prepare implementation schedule / transfer knowledge.

Apply any defect remediation post implementation.

Delete data and source code.

Citizen/Frontier – Allen, Tx 2011

Senior iSeries RPGIV Programmer Analyst

Analyzed and designed RPGIV RPG-FREE and DB2 for i programs & modules to meet

requirements for Plant Field Operations in break fix environment.

Modify RPGIV, Embedded SQL per LLD utilizing ILE Binding techniques.

Created CDM Data Scrubs to correct various problems in database.

Part of the BAU team to resolve Heat Tickets, REMEDY tickets for various Defects.

Part of PR/QC team to check the integrity of the new or modified programs.

Provide system documentation and testing.

Assist users in testing and implementation of enhanced programs and modules.

Embedded SQL Stored procedures & Service programs.

Provide Webservices programming XML

FEDEX Ground – Pittsburgh, PA 2008-2010

Senior iSeries RPGIV Programmer Analyst

Utilizing RPG IV RPG ILE SQL RPG-FREE DB2 for i SQL

Changed the NB delivery system to comply with mandatory eManifest requirements.

The new US Regulation called ACE (Automated Commercial Environment) mandates the carriers provide all shipment truck and driver data in electronic format in advance of arrival of the goods at International borders.

Embedded SQL Stored procedures & Service programs.

IBM MQ Series API set

CVS Caremark– Richardson, TX 2007

Senior iSeries RPGIV Programmer Analyst

Technical RPG Lead between Offshore team.

Advised Offshore team with code reviews, database design, and technical documents.

Obtain project and document approvals from on shore Application Dev manager.

Complete production support tickets for the RxClaim application. Involved coding in tool SYNON, RPGLE and CL.

Major modifications to the complicated drug adjudication and pricing using tool.

Bank of America – Addison, TX 2006

Senior iSeries RPGIV RPG FREE DB2 for i SQL Programmer Analyst

Analyze existing job for the occurrence of programming that hard-coded Directives between primary system and the other systems on IBM network with attention to Load balancing servers and Backup Secondary server(s).

Create and distribute LLD (low level designs) as technical documents to detail the actual changes required to accomplish project goals.

Documenting and preparing Test case Scripts for assigned project.

Modify RPGIV, Embedded SQL per LLD utilizing ILE Binding techniques.

Implement projects results thru Turnover change management software.

Defect tracking from initiation to completion

Stored procedures accessing service layer between .NET Ja-va and System–i.

Convert Countrywide Loan database to B of A formats.

Enhance and modify MERS / BOA Mortgage Electronic Registry system.

utilizing RPGIV ILE and RPG-FREE.

Interview and test prospective iSeries developers before allowing them to join team.

Embedded SQL Stored procedures & Service programs.

IBM MQ Series API set.

Victory Packaging Senior iSeries RPGIV Programmer Analyst– 2006 to 2007

Convert UNIX based Accounting, Warehouse Distribution system to IBS-ASW V5.

Responsible for ETL, Mapping, conversions & data load into Sales Order system.

Implement customized RPG programming to client specific requirements.

EDI invoice outbound and inbound EDI to pay creation.

Reporting directly to CIO/Director, independently developed and completed three key projects, in conjunction with scheduled on-site meetings for project coordination, requirements gathering, and technical documentation. On-going support is still being provided on an as needed basis.

Create new RPGIV RPG/400 RPG/FREE SQL programs to Migrate and Convert ETL Financial and Sales data in Manufacturing Retail environment from UNIX file system to AS/400 I-Series Native DDS and DB2/400 and third party vendor software.

Create new Retail Sales Commission system on I-Series written in RPGIV RPG/400 RPG/FREE SQL.

Customize/Expand in-house software package for sales order and EDI system.

Created inbound 860 PO change, inbound and outbound 856 ASN, inbound 864, 942 and 810, and outbound 940 EDI maps and interface with Trusted link.

Create DDS via RLU to print BARCODE field on label as a specified. BARCODE for printer files with device type *IPDS.

IBM International Business Machines IT Specialist 2004 to 2006

Technical Project Manager for Perot Systems Plano TX.

I provided several key functions to the Perot systems management and staff.

Weekly Health Check report that analyzed the Tenet Health Care’s IBM I-Series Network. The report included installed PTF levels as well as the current PTF levels available from IBM for HYPER CUM and Firmware.

This report also kept track of scheduled completed Hardware/Software maintenance

and this was the catalyst for getting all the 25 machines to stable Firmware levels.

Deliver HA Availability Assessment for all Tenet i570 complexes

Advise I5 system programmers on mission specific tasks.

Onsite resource to research Technical questions for Perot systems in a timely manner and assist other consultant team members with the work they were enlisted to do here during my tenure.

Perot and Tenet Health Care system specialists were provided an approximate age of internal disk drives report for 10 of the systems.

Project Manager lead programmer Rent conversion/increase project for NYCHA, the City Of New York Housing Authority as well as lead programmer and technical writer.

Responsible for creating detailed technical documentation of existing systems based on analysis of existing systems written in RPGII RPG II RPG/400 RPGIV CL OCL

Responsible for creating flow charts and user manuals for both business users and technical staff of client's legacy systems.

Dicks Sporting Goods - Pittsburgh PA 2003 to 2004

Senior iSeries RPGIV Programmer analyst

Analyze Design Program and Implement JDA software conversion.

Provide level 1 and level 2 software support for a highly complex proprietary continuous system including diagnosing software issues and writing up defects to facilitate triage.

Provide implementation assistance, application training and problem resolution to customers as well as operating system and hardware support for the IBM power system I platform.

Maintain Break/Fix issue list by application and ensure all are forwarded to the appropriate personnel for resolution.

Responsible for maintenance and administration of pre-production code environments and regression testing.

Interact with Quality Assurance personnel during system testing phases of application development.

Embedded SQL Stored procedures & Service programs.

FEDEX Ground - Pittsburgh PA 2002 / 2004

Senior iSeries RPGIV Programmer analyst

Analyze FEDEX in-house HA / Fail over Primary VS a Secondary system.

Primary located in Memphis TN. and the Secondary in Pittsburgh PA.

The keystone to this was to have a remote data area indicating the current primary system.

The second key was to have the Secondary perform exactly like the primary at a flip of the switch,

Both systems must have identical databases and they must be kept in sync at 24/7 for this Solution to work.

Embedded SQL Stored procedures & Service programs.

IBM MQ Series API set

Kronos TimeKeeper - Cleburne Tx. 2001

Create in RPGIV – ILE RPG-FREE a Bio Metric interface from Kronos time clock to AS400

Develop software interface between System I and biometric device utilizing sockets programming for use in Kronos Timekeeper software.

AmeriServe- Dallas TX – Consultant 2000

Senior iSeries RPGIV Programmer analyst

JD Edward development/ Customization of Logistics system.

CCE Coca Cola Enterprise Atlanta GA. 1999

Project Leader and lead programmer CCE Coca Cola Enterprises Atlanta for the Y2K/Native AS/400 Conversion Project, addressing full date expansion and converting legacy RPG II applications to ILE specifications

Solutions Technology Inc. - Camp Hill, Pa. 2/96 to 2/98

AS/400 Senior Programmer Analyst

RPG/400, RPGIV, ILE Application Software Development utilizing interactive sub files and batch processing methods.

Analyze, design, program and implement enhancements and modifications to MAPICS XA per client request

Analyze, design, program and implement optical storage solution for LAN attached 3995 data servers.

Analyze, design, program and implement programming necessary to convert S/36 OCL, RPG to native AS/400 RPG/400 and ILE/400.

Analyze, design, program and implement advanced system 36 interface for transfer of international Banking information.

Analyze, design, program and implement programming necessary to convert S/36 and AS/400 source code to YEAR 2000 compliance.

Responsible for Project Management

YMCA of Metropolitan Dallas, TX. 9/94 to 12/95

Technical Service Director, AS/400 - Senior Programmer Analyst RPG/400 RPG/ILE AS/400 RPGIII Application Software Development utilizing interactive subfiles and batch processing methods

Analyze, design, program and implement accounting software module that computerized manual Budgeting software and interface to the General Ledger, streamlining process that formerly took 4.5 months to 60 days.

Analyze, design, program and implement electronic mail system for use by 200 plus users at 26 remote sites.

Responsible for Project Management

Responsible for system resource management, security and database design.

Responsible for technical support to operations and users.

Install and maintain communications software and hardware at remote and local sites.

Design implement and manage AS/400 system workflow to facilitate problem solving and operations.

Implement and manage appropriate AS/400 security for system and applications at object and user level.

Utilize AS/400 Job Accounting to track jobs and system resources.

Effect upgrade of AS/400 OS to New version or release.

LXI Corporation Irving, TX. 6/93 to 9/94

Project Manager, AS/400 Senior Programmer Analyst RPG/400

AS/400 RPGIII - RPG400 System Software Development Analyze, design program and implement STARS optical storage product for the IBM AS/400 LAN attached or direct attached 3995 data server.

Analyze, design, program and implement disaster recovery product for the AS/400.

Responsible for Project Management and administration

Responsible for system resource management and database design.

Responsible for training and installation of LXI products.

USTI Inc., Dallas, TX. 1/89 to 6/93

AS/400 Programmer Analyst, RPG/400

AS/400 RPGIII - RPG400 Application Software Development Design program and implement Utility billing software for use in City government.

Design program and implement accounts receivable "generic report writer".

Develop and maintain EDI interface between AS/400 and Norand handheld devices.

Coordinate project specific tasks for other team members.

Responsible for general software maintenance.

Collaborate with clients on program analysis and enhancements

Programming language/operating system and Skills knowledge base:

** Job Control: OCL Procedures and CL Programming (CLP)

** Language: RPG II, RPG IV, RPG ILE, RPG/FREE Embedded SQL

** Structured, Modular Design

** Arrays; Data Areas; Data Structures

** Relational Database Design and Normalization

** DDS-Physical Files, Logical Files, Join Files, Data Dictionaries, DDM .

** DB2/400: SQL Tables, Query, CTE Common Table Expressions . Visual Explain, SQL Optimizer

** SQL & DB performance monitoring & tuning - utilizing tools like DBMON & iDoctor** Screen ** Design Aid (SDA): Menus, Display Files, Sub-file Programming & RLU

** File Transfer Protocol (FTP)(SFTP)

** Query/400 and Open Query File (OPNQRYF)

** SEQUEL, Strsql

** System Administration-PTFs, System Values, Basic Configuration

** Security Administration-User Profiles, Authorization Lists, Object Authority

** Operations-Backup & Restore, Print Management, Job Scheduler

** UIM User Interface manager

** DDM Distributed Data DS, DDM, DDL HTML, XML.

** CGIDEV2 for XML

Experience with Web

** I Series Navigator

** IBM MQ Series API set

** JIRA Ticket system

** SDA Screen Design Aid

** RLU Report Layout Utility

** DBU Database Utility

** VISIO Flowcharting Software

** Microsoft Project

** Hawkeye Data analysis Tool

** Turnover Change Management software

** Implementer Change Management software

** Aldon and Arcade Change Management.

** ROBOT Job Scheduler

** Abstract

** Clarity

** AGILE

** JBA

** FTP & Secure FTP

** SMSS Data tool

** PASE QSHELL

Contact this candidate