Objective:

To obtain employment with a consulting company for an onsite or remote Sr. IT Lead Consultant as a Technical Project Leader, or Data Architect, or Developer/Analyst. I can provide technical expertise in various coding, analysis, and project leadership positions for both systems and software.

Accomplishments with various diversified roles:

·EDI Manager, Technical leader, and Team lead. System engineering roles for vendor software packages installations and patches for IBM V5R4 to V7R1, LAWSON V.7. X to 10.1, GENTRAN 1.x to V.3.x, MEDSERIES 4, TRUSTED LINK, INOVIS, ISLAND PACIFIC, and VERTEX.

Data Migration ERP Projects: INFOR LAWSON; INFINIUM, JD EDWARDS VENDORS (ABSOLUTE and CENDIEN)

·VANITY FAIR (LAWSON, JD EDWARDS WORLD, INFINIUM) {40 ISERIES MIGRATION}, PHILLIP VAN HUSSEIN

·INT TECHNOLOGIES

·HAVERTY

·SOUTHERN CONTAINER

·ETHAN ALLEN

·WALCOAL

·CORNELL

·Installs of upgrades and patches I install for all modules including portal and GUI Administration. Menu setups for functional users. V7.x to 9.x TO V10.1 ISERIES POWER and AMAZON WEB SERVICES

SECURITY OFFICER AND ADMINSTRATIVES DUTIES:

·To setup profiles groups, security classes, user security to functions, roles setup, Setting up preferences (rules/assignments), security classes (PL1, LOGAN, & GEN), System Configurations Authority Collections of sensitive data, IFS Security (CLIENT ACCESS VIA PC REMOTE CONNECTIONS), Security Reporting, Multifactor Authentication, Security Automation, Group Profiles, Authorization Lists, Adopted Authority, Security Remediation, Public Authority, Private Authority, User Auditing, Security Auditing, Security System Values, Audit Log Review / History Log Review, Exit Point Security

Environment Scripting and API build:

·(INFOR LAWSON, INFINIUM, and JD EDWARDS ONE WORLD SECURITY data via internet interfaces or mirror redundancy).

Business Analyst Duties:

·Functionally test higher version applications for balancing financials, and security protocols for http, https, EDI, migration data files, including LMS IBM ISERIES, Integration, cryptographic, EIM entity integrated mapping, network (TCPIP, ODBC, JDBC, IP filtering, KOBEROS), AND Digital signing firmware, imaging, HW storages,

·CLLE, RPG ILE, EXIT POINTS, AND COLLECTION DATABASES, Authority Broker, Command Security (API, CL, UNIX, LINUX, JCS, RJE)

·ORACLE, DB2, RDMS, EXCEL, XML, HTML, JSON, and ACCESS

·Programming Experience (SQL, CL, CLLE, API, RSS, Java, JAVASCRIPT, and RPGILE)

·Configuration Management (AIX, NT MICROSFT, RAS, ISERIES, TOMCAT, CONTOLLERS, LINES, DEVICES, AND SUBSYSTEMS)

·Disaster Recovery – Designer (Mass Eye and Ear Infirmary Y2k project; Oklahoma State for Board of Nursing; and Livingston International)

·Load Balancing, Performance, PTFs (Patching), Operations MQ – Messaging developing of channels and receiver, Capacity Management, Object ownership in production and usage. (CHANGE MANAGERMENT SYSTEMS)

Software:

·GENTRAN, GIS, INOVIS TRUSTED LINK, OPENTEXT, PREMENOS, EDIFACT, SAP IDOCS, and native EDI PROGEN code generator, & BCD Products

Utilities:

·Microsoft Office Products: WORD, EXCEL, POWERPOINT, and Visual Studio;

·McAfee HELPDESK, SAP Oracle based Ticket systems, TFS with VB Studio; and

·PROGEN BCD > HELPSYSTEMS SUITES: RODIN ETL, ROBOT SCHEDULER, SHOWCASE, SEQUEL

Experience:

DISYS/SOFTNICE Sr. I-SERIES Analyst

Chattanooga, TN July 2019 – June 26, 2020

I was assign to USXPRESS in Chattanooga, TN. Design and develop new software applications in SQLRPGLE, RPGLE, SQL, and CLLE for the Rapid Response Team for leading local transportation in Chattanooga, TN. Created API (XPM, Informatica, and Infinium), PROTOTYPES, SUB-PROCEDURES, and Sub procedure, and SUBFILE programs. Interfaces to EDI and XPM customer service system. Sub-Files work with tables to add, change, delete, and Position To.

The following projects are examples that I designed, coded and tested with business users in SQLRPGLE and total of 26 programs:

1. 3th Party Power Gateway wrapper - Recieve XML data as passed through Gateway process, validate function passed as valid(assign, Depart, and Drop/Hook).

2. 3th Party Assign functions - to call API if record is in an active status to assign a tractor to a trailer.

3. Gateway modified to XPM system to accept new APIs via DPGATERT, log file program to update records.

4. Webservices REST and SOAP for non-USXpress tractors and trailers.

Fortitude Systems Sr I-Series Developer IV

Irving, TX June 2018 – March 2019

I was assigned to MrCooper, formerly NationStar in Irving, TX. Project involved assignment to a leading mortgage lender for development in RPG ILE Free format using embedded SQL to design Successor’s in Interest Inquiry screens, LOCKBOX FTP processing, and NSF Exception charges for REO processing. The use of Implementer and IBM ARCAD for Change Management and code conversions for Production, UAT, and development environments.

MIAMI-LUKEN IT Systems EDI consultant

Springboro, OH April 2017 – April 2018

Project involved upgrading IBM Sterling GENTRAN from 3.4 to 3.6 operating software. Coordinated upgrade processes with IT manager and operations manager to lay out project plan and aid with installation processes for both test and production environments. Programmed interfaces in RPGLE and embedded SQL. Designed all interfaces in RPGLE, RPGSQLLE, RPGLE, and CLLE. All ne development including subfile design in DDS for Control Substances for the DEA. EDI documents 810, 850, 832, 852, 856, ANSI x12, 997, 834. Integration OLS ERP to VAI S2K ERP software. Partner Information, Partner Supported Documents, and interfaces to LIASION Pharmaceutical and STERLING GENTRAN. Created data conversion programs in SQL and changed secure protocol for control substances reported to DEA.

Created new production, test, and development LPARS from V7.1 to V7.2 OS 400 operating systems.

LIGHTWELL INC. IT Systems EDI Consultant

Remote December 2016 – April 2017

Assigned to HENRY SCHEIN in Dublin OH to upgrade IBM Sterling GENTRAN from 3.4 to 3.6 operating software. Coordinate upgrade processes with IT Manager and Operations Manager to layout project plan and assist installation processes for both TEST and PRODUCTION environments. Designed data extraction programs in RPGLE, RPGSQLLE, and CLLE. . EDI documents 810, 850, 832, 852, 856, ANSI x12, 997, 834.

INTTECHNOLOGIES IT LAWSON ISERIES Consultant

Remote February 2016 – May 2016

Assigned to CENTERPLATE in Greenville SC to analyze their current LAWSON version 9.16 and custom programming to upgrade to LAWSON version 10.x either on current ISERIES v6.1 OS or migration process to Amazon Web Services on Cloud platform. Developed migration programs in RPGLE, RPGSQLLE, and CLP programs. to populated hybrid LAWSON DB2 tables for interfaces processing from several event venues. Duties included analyzing objects usage for files, programs, journals, and system objects. Creations and Review of migration documents per INFOR LAWSON module usage for Financials, Time and Attendance, Human Capital Management, Landmark, LSF9, and Health Managed Services. Evaluation of all FTP processes and recommendations for either platform for off or on premises of AWS or ISERIES Cloud methodologies with possibly of using Salesforces computation for GL.

CARTESIAN Consulting IT Sr. Developer Contract Consultant Remote October 2015 – January 14, 2016

Assigned to telecommunications company, Frontiers Communications, in Richardson TX for their Fiber Auto Assignment project. Primary duties were to create source objects in RPGLE (copybooks), SQLRPGLE (service programs with embedded SQL statements, EXTNAME DS, cursor I/O), and SQLRPGLE SUBFILE Maintenance program using SQL I/O on DDL Table. Use of Turnover, TFS, and Visual Basic Studio.

Oxford International Inc. Contract EDI Manager

White Plains, NY August 2015 – October 2015

Assigned to DANNON North American headquarters in White Plains, NY to provide EDI TRUSTED LINK expertise in resolving EDI backlog issues and current on-going projects for onboarding new Trading Partners such as WALMART, AMAZON, and Dairy on AGILE methodology. Cloud systems migration to AMAZON. Danone, French International Parent, used TRUSTED LINK for Sales orders, invoicing, procurement, and Warehouse transactions. INOVIS OPENTEXT vendor managed services on for HP Operating

System with Oracle DB using EDI functionality of TRUSTED LINK in SAP. Oracle EBUSINESS Suites tools to managed current EDI processing reports and User Defined Data analytics to govern right remedies for data issues and overlaying R/3 Architecture for current Onboarding projects and outline OPENTEXT managed services implementation versus project timelines and data segment issues. The EDI Transactions sets used 810, 812, 850, 820, 824, 860, 875, 876, and 880 including SAP IDOC creations. APO business processes for specialized business rules for type of Trading Partner required setup needs. Communications protocols AS2, VAN, and SFTP. Trading Partners in North America base of 120 and 50 suppliers for STONYFIELD, DANNON, DANONE Canada, and DANONE Water.

RHI Consulting Inc. IT Sr. Developer Contract Consultant

New Orleans, LA September 2014 – April 2015

Assigned to Livingston International Inc., primary shipping logistics company that handles freight via shipping vessels, rail, trucking lines, and air cargo as assignee broker for customer. Export Department was undergoing a redesign effort to ILE architecture on V7R1 Power Series server. The custom design applications in production 10% RPG36, RPG3 coding and 90% RPGIII source to RPGLE. Implementation of SQLRPGLE with embedded SQL using modules, copybooks (RPG source) and prototypes usage for fields attributes definitions for entry parameters, KLIST, and common variable fields names. The integrations involved adding audit fields and eliminating the System 36 environment. TCPIP communications interfaces programs using UNIX SFTP scripting. STMF copy commands to upload from IFS directory for US Customs Reports and copy to transactional DDS pf or DDL table via QTEMP, ACH transmissions for Letter of Credit, and non-EDI documents via interfaces of Lawson v7.1 A/P, GL, & A/R modules to INFINIUM comparable modules. Redesigned application menu systems from ad-hoc to SOX standards to Data governance, users’ authorizations levels, and programming standards for new development templates in SQL, RPGLE, CLP, CLLE, SQLRPGLE, and bind modules in directory. API to/from Informatica UNIX, and LINUX scripting standards for source code tracking for billing system

TEXT source. Create deployment plan, implementation solution design using AGILE project planning techniques projects such as Third-party screening process to adhere to each federal agencies and international treaties for prevention of shipments to Terrorist organizations both national and international.

SYSMIND LLC Sr. Lead IT Integration Consultant

Greensboro, NC March 2014 – August 2014

Contracted to VF Corp via WIPRO(SYSMIND) to analyzes and evaluate forty AS400 operating systems from V5R4 to V7R1. All Server application topologies were created for the current production including EDI Mapping for INOVIS, GENTRAN v.1.x 3.4, TRUSTED LINK, PREMNOS. Plan project strategies with software upgrades and applications solutions for custom programs affected. SYNON, LAWSON V7.1 to V9.x, JDE ERP, ISLAND PACIFIC, INFINIUM, PKMS, VERTEX with detail object analysis for migration conversions of RPG36, RPG400, and CL for 6 I-Series platforms. Ensure business requirements are incorporated in the technical design using RODIN Help System ETL usage for WMS and DWS to Change Data capture extract, transfers, and load with error management control. Field attribute errors on fields in Db2. Lead Application Architecture design of integration process for 10 AS/400 platforms with over 30 various vendors DB2 packages at the incompatible Release Levels; and table fields with DB normalization by Primary and Foreign Keys designated in fields in fields to connect record event lifecycle. HELPSYSTEMS utilities and RODIN management of ERRORs capabilities were used in the automated processes of unit and user testing prior to implementation. This usage provided production input in data model design restructuring when modified in the development stages. All programs redevelopment was inclusive on project plan to assist offshore team’s development in ILE concepts.

Jack Onofrio's Dog Shows LLC I Series Software Developer

Oklahoma City OK November 2013-March 201

I-series development in CGI, java, JavaScript, xml, html, RPG ILE, embedded SQL in RPG & CLLE (RUNSQL, and RUNSQLSTM). Sub files development for Dog Show Final internet result file. RDI, I Director, CGI development for internet show entries for participants such as dog owners/Trainers/Jr Show handlers. Mentor staff on new sub file designs for options (change, delete, and display records) and function key usage for adding records, field prompting F4, and F5- refresh screen.

The Stowe Group/Med Series 4 Data Mapping Conversion Consultant

Washington DC April 2013-September 2013

Business analysis of current Med Series 4 V2K HR/Payroll/Benefits Physical files compared to PeopleSoft V9.1 HCM Oracle tables for HR/Payroll/Benefits. Creation of data conversions programs to generate flat or non-delimited files to populate the PeopleSoft Oracle Databases. Data base normalization rules were checked, confirmed via table structure analysis. (1 to 1, 1 to many relationships as it applies to Parent to child/children or dependency tables to file fields correlation for dependent file fields for business rules integrity for records additions, maintenance (updates and deletions). These DB2 business rules were implemented in the program logic of all the RPG ILE, and the CL conversion programs handled the automated process to convert, populate flat files as IFS stream files, and transfer via V7R1 platform (FTP UNIX scripting) to the Oracle DB2 tables.

Raven Industries SYNON Cool 2E /Data Mapping Consultant

Sioux Falls, SD December 2012 - February 2013

Analysis of all SYNON PRODUCTION objects for Raven Industries and their dependencies. Created test environment which should parallel production current environment. Convert SYNON generated RPGIII programs to RPG ILE V6R1 syntax. Dropped Object dependency on all associated SYNON references or dependencies. Convert common subroutines to internal prototypes/modules. Use of Built-in-Functions replace numerical indicators for HI_EQ_LO values replaced with %EOF, %EQUAL, %FOUND, etc. Date calculation where restructure for %Date, %Time. Etc. Mapping legacy files field’s definitions (1992 versions) to .net db2 tables for windows frames. Data base normalization rules applied to the ILE program automated CL process for table population for Data Dictionary, Reference, and transaction files. Use of Turnover and Hawkeye.

T G Connor Software Services LLC Lead Senior I-Series Systems/Application Engineer

Oklahoma City, OK 11/2011 – 4/2013

Assignment to Oklahoma State Office of Finance: System Management - Authorizations, User, Display, Printer, Writer, Users Setup, FTP/TCPIP communications configurations. Software development/Maintenance - WDSC, RPG ILE, CLLE, Service Programs, APIs, BCD PROGEN WEBQRY DB2, and SQL (Embedded and Interactive). Project Management V5R4 to V7R1 (3/11), Date field conversions, and Standards for program architecture design, database normalizations standards, unit testing, user testing, and implementation. Mentoring: System Admin, CL programming, FTP scripting and AS/400 Concepts. (Open)1 project SQL Usage in V7R1 Operating System – 2012 1. Implemented Embedded SQL in RPGILE programs (Reduced Files in F-specs, avoid locking issues, elimination of I/O hits, and eliminating OPNQRYF command usage) Utilized RUNSQLSTM in CLLE programs and SQL Statements in a Source Physical file.

Cyber Security

Collaborated with OBON IT Security Officer to review existing security policies and develop new policies as needed while conforming to the Office of State Finance’s published Information Security Policies, Procedures, Guidelines, for the security of sensitive data. Audited security logs as specified in IT Security Policy. Evaluated security needs when/if new technology or services were added.

System Administration and Application Support

Maintained the integrity of the IBM I-Series (AS/400) platform Hardware and Client Devices; analyzed performance of disk drive and CPU through-put; customized devices based upon functionality and user requirement; supported the i5/OP Operating System and network; maintained PTF levels and i5/OS software compatibility; administered the TCP/IP protocol. Administered and managed the DB2 Universal Database for I-Series. Managed User Access to the ISERIES; modified and controlled user profiles based on personnel changes; supported application software and data access using i5/OS authorization rules; installed, upgraded, and supported MS Windows Client Terminal and printer emulations; verified security and authority of external access through VPN, FTP, etc. Modified and supported Application Software using PROGEN-PLUS program generator; developed, coded, and implemented new Applications using ILE and RPG compilers; developed and implemented data-sharing functions between DB2. Developed and supported custom developed software. Created and tested: user data entry screens, reports, query and navigation tools, preprocessors and edits, procedures for database loading and verification (as well as for database updating), procedures for periodic re-indexing (adding fields or edits, software version upgrades, etc.); performed backups and restores; debugged problems.

ADVANIA Sr. AS/400 Software Developer Oklahoma City, OK September 2010 - November 2011

Maintained and designed new RPG ILE software for the Oklahoma Board of Nursing. The current applications are in RPG III and RPG ILE. RDI development I-Director. Redesigned programs to the current version of RPG for V7R1. Utilized FTP and stored procedure processing to download and upload files to several state government agencies. Utilized embedded SQL RPG ILE programs using RPG Free. Data handling of error messages and user support tickets. Performed AS/400 administration duties such as user profiles, job descriptions, operating/system commands, and system job scheduling, menu authorizations, and printer setups using Client Access. Created tables and indexes using SQL and DB2/400.

Farmers’ Cooperative Sr. AS/400 Software Developer

Bondurant, IA March 2010 - September 2010

Expanded location and sales fields in their database system. In addition to replace and OPNQRYF commands with embedded SQL/400 in RPG ILE free form. Unit testing needed verifying current results with enhancements. Microsoft Office, Lotus Notes, Windows XP Professional, Citrix, Visio, and Adobe Acrobat 8 Standard software, RDI Editor Web Studio Development, and Turnover change management. Redesigned the entire sales process for data entry (Interactive) as well as day end, and month end batch pro

Education:

St. Augustine High School 1975 Honors Advance Placement

University of Rochester 1976-78 Chemical Engineering Studies 132 hrs

Tulane University 1981-83 Graduate Business School/Reservoir Engineering 48 hrs

Technical Education:

·IBM Programming School-Atlanta, GA 1991 AS/400 Application and System Certification Classes

I.Certified RPG ILE (12/2005 Brain Bench) Tools/Utilitiesusing I-NAVIGATOR),

II.IFS Directory: QSHELL (UNIX) and QOPENSYS (LINUX).

·RDi

I.I-SERIES Client Access including BRMS, Scheduling, SERVERS configurations (Mail, Printers, Subsystems, Devices, Profiles, SQL Schema)

II.GUI Developer’s Tool Box

III.ARCAD

IV.Change Management ALDON, Service Now, Turnover

Contact this candidate