Uploaded File
Terence
terenceconnor1113@gmail.com
504-812-9208
1112 Upperline St
New Orleans, LA 70115
405-589-4405
iSeries Technical Consultant
23 years experience W2
2
Recommendations
Average rating
431
Profile views
Summary

  • Systems and programming experience in warehouse, supply chain and inventory systems business application environment using IFS directory, UNIX, and LINUX environments via Client Access. Systems Administration, Perform Systems Administration,
  • 7 years with various Lawson Financials Software versions ‘90’ –‘2012’.
  • Performance Management, Capacity Planning, IBM I V5 power V7R1, and reverse engineering. This includes all language level changes in RPG, OCL to CL including APIs usage.
  • Performance Management , Capacity Planning, IBM I V5 power V7R1 (recently V6R1 for client that recently reverse engineering the IBM Mid-Range systems S3, S34, S36, AS/400 OPM and iSeries ILE.
  • 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.
  • Career Development experience in AS/400 DB2 database, File Management and SQL Tables over 16 years. Data Center Migration and Server migration to AS/400 V5R4 to V7R1. Over 15 data migration projects over 22 years.
  • MEDSERIES 4 all modules over 2 years Y2K compliant with Mass Eye and Ear Infirmary. Overall 5 years of Healthcare experience from Insurer to provider.
  • Experience in mentoring and leading programmer analysts in design and development efforts including Unit Testing and QA test scripting, MKS Implementer, Robot, PROGEN, and Hawkeye.
  • UNIX experience with process owners and identifying information technology solutions that enable e-commerce and business process improvements and developments.
  • Excellent knowledge of systems development life cycle methodology. Ability to translate the business changes, workload fluctuations and environmental changes into capacity planning & forecasting to ensure a reliable infrastructure. Proficient in I-Series programming languages from Expert in RPG ILE, RPG Free, CL, and SQL.
  • Interactive or Embedded SQL RPG ILE Software programming; DB2 usage in transferring data from or; to non-IBM I-series platform (Microsoft servers, LINUX, UNIX, & Oracle to I-Series V5 box; Methods used: FTP, SFTP, FTPs, Microsoft Access, Excel, XML/HTML to I-SERIES physical files, etc.., used COBOL, RPG ILE, Stored procedures, CLLE programs, and APIs.
  • Resolve Business Analyst complex issues: Applications Enhancements, System Performance, Availability of Job Scheduling, and Business SLAs (Interacting with all users types)

Experience
Sr. iSeries Developer/Analyst
Information Technology
Sep 2014 - Mar 2015
  • Assigned to Livingston International Inc., an international logistics company, that deals with Exporting and Importing from various Ports worldwide.
  • Assigned in the redesign effort to their current iSeries AS/400 applications processes for Export, Import, and accounting departments. The system and application integration involved adding audit fields and eliminating the System 36 environment completely along with the RPG36 and OCL programming languages.
  • Modified their legacy system from S36 in V7R1 environment to ILE object structure architecture. This process included Interfaces, EDI Transaction sets, and FTP processes.
  • Redesigned menu systems to adhere to SOX regulations in regards to Data governance and users authorizations levels.
  • Worked independently and assigned programming tasks to other contract iSeries developers.
  • Programming was done in SQL, RPGLE , CLP, CLLE, OCL, and RPG36 languages. Used prototypes and bound modules. UNIX, and LINUX scripting were utilized in these enhancements.
  • Created deployment plan and developed a solution design for Third party screening inclusive of a interface/FTP and facilitate user and vendor testing
AS/400 UNIX SQL Scripting RPG Prototype Linux iSeries ILE RPG FTP EDI Data Governance CLLE CL CLP Auditing
Remove Skill
Sr. System Integrator/Consultant
Information Technology
Apr 2014 - Aug 2014
  • Contracted to VF Corp to assess iSeries platforms that are V5R4 to V7R1. Server and application topologies were analyzed for the current production system which included EDI Mapping (TRUSTED LINK).
  • Planned project strategies and upgraded planning methodology with detail object analysis for conversions of RPG36, RPG400, and CL for six iSeries platforms.
  • Ensured business requirements were incorporated in the technical design.
  • Led Application Architecture design of integration AS/400 with vendors' packages at the business, technology and data layers, and provided input in data model design restructuring
RPG/400 RPG iSeries EDI CL Business Requirements AS/400 Applications Architecture Analysis
Remove Skill
Senior iSeries Developer
Information Technology
Nov 2013 - Mar 2014
  • Performed iSeries development in RPG ILE, embedded SQL in RPG, RPG FREE & CLLE (RUNSQL, and RUNSQLSTM).
  • Performed Sub files development for Dog Show Final internet result files.
  • Utilized RDI, I Director, CGI development for internet show entries for participants such as dog owners/Trainers/Jr Show handlers.
  • Mentored 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
RPG iSeries ILE RPG CLLE CL CGI SQL Project Management
Remove Skill
Sr. Data Mapping/Data Conv Consultant
Healthcare
Apr 2013 - Sep 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 for Providence Hospitals. Creation of data conversions programs to generate flat or non-delimited files to populate the appropriate PeopleSoft Oracle Databases. Database 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) the Oracle DB2 tables

FTP UNIX Oracle DB2 CL ILE RPG Data Conversion Data Mapping Business Analysis
Remove Skill
Sr. ISeries Technical Consultant
Information Technology
Jan 2012 - Apr 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. Eliminated 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. Database normalization

ILE RPG iSeries RPG III RPG
Remove Skill
Oklahoma State Office of Finance System Management
Information Technology
Nov 2011 - Apr 2012

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 FREE, 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) 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)
  2. Utilized RUNSQLSTM in CLLE programs and SQL Statements in a Source Physical file...View. Cyber Security, Administration, Oracle PeopleSoft help desk, Design programming and project specifications. Liaison between Executive Director and three deputy directors.

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 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 throughput; customized devices based upon functionality and user requirement; supported the i5/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; maintained application software and data access using i5/OS authorization rules; installed, upgraded and maintained MS Windows Client Terminal and printer emulations; verified security and authority of external access through VPN, FTP, etc. Modified and maintained Application Software using PROGEN-PLUS program generator; developed, coded and implemented new apps in ILE Objects design. Developed and implemented data-sharing functions between DB2.
  • Created and tested: user data entry screens, reports, query and navigation tools; preprocessors and edits, procedures for database loading and verification; procedures for periodic re-indexing (adding fields or edits, software version upgrades, etc.); performed backups/restores; and debugged problems.

Business Process Enhancements

  • Developed and implemented business policies and procedures.
  • Analyzed, recommended, and developed work flow tools, automation, and improvements to existing hardware and software architecture. DB rules applied to the ILE program automated CL process for table population for Data Dictionary, Reference, and transaction files. Use of Turnover and Hawkeye Change Management Systems.
AS/400 SQL CLLE FTP Oracle iSeries VPN DB2 ILE RPG CL RPG Turnover Hawkeye Change Management Project Management TCP/IP Data Dictionary Auditing
Remove Skill
Sr. AS/400 Software Developer
Healthcare
Sep 2010 - Oct 2011

Maintained and designed new RPG ILE software for the Oklahoma Board of Nursing. Applications were in RPG FREE, 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.
RPG III RPG FTP SQL AS/400 Stored Procedure Project Management DB2
Remove Skill
References
Average Rating

2 recommendations
Sr. Software Developer
Manufacturing
Mar 2010 - Sep 2010

Assigned FARMERS COOPERATIVE 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 required 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 process.
Windows XP Citrix Adobe Acrobat Turnover Windows SQL
Remove Skill
Sr. Technical/Functional Lawson Consultant
Retail
Sep 2008 - Feb 2010

Assigned to CORNELL, HAGGEN, WALCOAL, & BOOKS-A-MILLION.

  • Customized Lawson version 9.0 based programs for HR, AP, PR, BN and GL. Creation of copybooks, Stored procedures, Green screen SUBFILE displays, BRMS backups, RPG Free, Embedded SQL, Lawson objects: PRNT and SCRN, CLP, WebSphere (WDSC), RDI Editor, QSHELL commands, CL and RPG ILE modules and object calls to Intranet and Internet web services.
  • Performance Tuning and RPG ILE programs.
  • Created Lawson program types of B, M, and E.
  • Designed interfaces using FTP and the IFS drive to upload and download data to clients as well as INFORMATICA Server. WDSC development for clients with several version of Lawson 7.25, 8.1, to 9.1.0.0 release.
  • Installed BSI Tax factory, Technology Patches, ESP 7 and Lawson application patches.
  • Created date
  • Utilized Hawkeye and Implementer for object usage and change management system.
  • Install Upgraded?? Lawson Version from 7.0x to 8.25 to 9.X for clients’ data conversion programs for version 7.x to 9.0. Created Lawson user profiles and administration setups for menus and options.
RPG SQL CLP FTP
Remove Skill
Sr. AS400 Programmer
Insurance
Dec 2007 - Aug 2008

Assigned to HMSA. Project: Blue Cross Blue Shield

  • Designed conversion programs for the 10.1 release for claims processing.
  • Maintained and developed programs in RPGII, RPGIII, COBOL and RPG ILE. Operating languages were in OCL and CL.
  • Utilized SQL and DB2 for table development for FTP transfers and report processing.
  • Designed new applications using PROGEN for sub files development.
  • Utilized ALDON, and Hawkeye for Change Management and object usage tools.
Cobol ILE RPG CL FTP DB2 Hawkeye RPG SQL AS/400 RPG III
Remove Skill
Sr. AS400 Analyst Consultant
Information Technology
Feb 2007 - Sep 2007

Assigned to TransMontaigne

  • Developed new software applications in RPG Free, RPG ILE, RPG4, CL, RLU, SDA, DB2, WDSC, RDI Editor, IFS, DB2/400 and SQL.
  • Mentored programming staff on development concepts and db2 relationships in regards to FTP transfers, SAP, ERP, JD Edwards V8.0and several phases of interface development from vendors and clients.
  • Designed the current invoicing process along with Electronic Funds Transfer for Draft Notices.
  • Redesigned Split Load process for haulers and refineries.
  • Developed SQL procedures to generate Crystal reports.
  • Utilized Implementer Change Management tool.
RPG ILE RPG CL DB2 FTP SAP EBP J.D. Edwards SQL AS/400 Crystal Reports SAP
Remove Skill
Sr. Technical Lawson Consultant
Information Technology
Sep 2006 - Dec 2006

Assigned to Lawson Software Partner, ABSOLUTE! Duties performed for clients such as Southern Container, Ethan Allan, etc. Installed Lawson software for upgrades and releases for current and new clients.

  • Created new RPG ILE, RPG4, IFS, RLU, SDA, and COBOL processing including CL programs modifications for client.
  • Analyzed customer systems on the AS/400 for technical and system assessments.
  • Worked with Lawson modules for AR, AP, HR, Benefits, and Asset management.
Cobol CL AS/400 Asset Management ILE RPG RPG
Remove Skill
AS/400 Technical Architect
Information Technology
May 2006 - Aug 2006

Lawson Project assigned to FAIRPOINT Communications. Provided technical and consulting services to install Lawson Financial package from Release 7.2 to 8.1. Installation of LID (GUI), IFS and desk top web portals. Created three AS/400 environments and 9 product lines for production, test, and development. Assisted in functional training in the HR/Payroll ERP. Created data conversion programs in RPG ILE using service programs with embedded SQL and CLLE programs.

AS/400 ERP SQL CLLE
Remove Skill
Sr. EDI AS/400 Consultant
Retail
Feb 2006 - May 2006

Assigned to Staples HQ.

  • Provided technical and consulting services support for validating and verifying 856 inbound transactions for 25 vendors who were currently not using GENTRAN EDI for " Pick and Pack" transactions.
  • Communications were setup with vendors in regards to testing, notification of errors, element modifications. The vendors’ Setup of accepting outbound 824 application advice after receipt from Staples. Data set transactions sets, use DBU (Data Base Utility), RPG ILE, RPG4, IFS, CLP and AS/400 queries to partition out segments and compare them with Staples EDI requirements.
EDI RPG OS/400 ILE RPG
Remove Skill
Sr. Systems Programming Manager
Insurance
Mar 2000 - Sep 2002

Assigned to Neighborhood Health Plan. Major functions: SQL/AS/400 ,CLP, CLLE, RPG IV/ILE (Prototypes, API, Procedures, Java objects and Modules), Cobol, AS/400 query, SQL, DB2, Visual Basics 6.0 data definition specifications, AS/400 job scheduler for daily, weekly and monthly jobs, and XML Java (Silver Stream Software) coding responsibilities included the following:

  • Performed analysis, design, estimation, development, documentation, testing, and implementation of new business applications.
  • Provided maintenance and support of existing applications.
  • Utilized GENTRAN for X12 ANSI Formatting and EDI Mapping Vendor-Partner Setup, and MQ Series commands for servers and AS/400 file transfers.
  • Provided data analysis support for NHP customers through regular communication in order to assist with customer's information and reporting needs and developed instructional information procedures. Provided support to department management and staff in technical, training and administrative areas.
  • Participated in the development, revision and implementation guidelines, standards, and procedures including request management, project management and change management.
  • Coordinated technical systems support with in-house staff and outside vendor personnel to ensure that appropriate collaboration and maintenance have been performed for responsible business applications and related data systems.
  • Assisted and/or prepared documents related to the NHP project management process such as project plans, feasibility study, status reports, project summary reports, and presentations to document the project life cycle.
  • Developed and maintained positive customer relations with the IT client community.
  • Prepared operational and turnover documents in order to implement projects and modifications in production in accordance with IT Change Management standards and procedures.
  • Extended professional skills and knowledge through department facilities and self-motivated opportunities to remain current on new information technology trends, products, and techniques available to the healthcare industry.
SQL AS/400 CLP CLLE RPG Cobol DB2 Visual Basic XML EDI iSeries Change Management Project Management MS Visio Project Planning
Remove Skill
AS/400 Project Technical Lead
Healthcare
Jun 1998 - Dec 1999

Assigned to Massachusetts Eye & Ear Infirmary for Y2K Project. Analyzed and setup overall Y2K project using Microsoft Project, Visio, and McAfee. The following were my listed responsibilities:

AS/400 programming staff and was key leader on Y2K committee.

  • GENTRAN EDI software for X12 ANSI Formatting and Mapping Vendor Setup.
  • Coordinated detailed AS/400 project tasks for staff of 7 AS/400 Sr. Programmer/Analysts.
  • Analyzed the detailed project task for ancillary systems and server upgrades using Client Access.
  • Re-designed overall TCP/IP process for file transfers and HL7 interfaces using trigger files and trigger programs for updates from IDX (Alpha System) to the AS/400.
  • Use and Knowledge of XML, UML, and OOD for messaging systems.
  • Created a development environment for user testing of SMS Med Series 4 software, current custom objects, and interface testing (production environment software at Rel92.10 and development at 98.14).
  • Utilized parallel processing via the AS/400 job scheduler to validate environmental results.
  • Upgraded AS/400 CICS objects to RISC format.
  • Created programming and change management standards for development as well as existing programming objects.
  • Hired and Trained AS/400 programmer in AS/400 query, data definition specifications, DBU 50, interactive SUBFILE design, and in the following AS/400 languages: RPGIII, RPGIV, RPG ILE (Prototypes, API, Procedures, and Modules), CLP, and CLLE.
  • Setup and analyzed custom design standards for INFINIUM/Software 2000 human resources, financials, and payroll environments (Setup environments, customized/modify INFINIUM.
  • objects and installed upgrades) and file transfer mechanisms to the SMS medical software's general ledger and accounts payable.
  • Interviewed and evaluated (via technical exam) all permanent and contracted programming staff.
  • Primary areas of SMS Med Series 4 software: AR/ADT, Mira, accounts payable, clinical labs, grant tracking, fundraising custom software design, security, and electronic billing.
AS/400 TCP/IP XML UML OOD SMS CICS CLP CLLE RPG ILE RPG RPG IV RPG III Triggers MS Project
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Master's in Reservoir Engineering Studies
Tulane University, 1981 - 1983
Attended in Chemical Engineering
Univ. of Rochester, 1975 - 1978
Skills
RPG
2015
11
SQL
2015
8
AS/400
2015
7
CLLE
2015
5
CLP
2015
5
DB2
2013
5
FTP
2015
5
ILE RPG
2015
5
iSeries
2015
5
Project Management
2014
5
RPG III
2013
4
XML
2002
4
Change Management
2012
3
CL
2015
3
Cobol
2008
3
EDI
2015
3
Auditing
2015
2
MS Visio
2002
2
Project Planning
2002
2
TCP/IP
2012
2
Visual Basic
2002
2
CICS
1999
1
Data Dictionary
2012
1
Hawkeye
2012
1
MS Project
1999
1
OOD
1999
1
RPG IV
1999
1
SMS
1999
1
Stored Procedure
2011
1
Triggers
1999
1
UML
1999
1
Adobe Acrobat
2010
1
Analysis
2014
1
Applications Architecture
2014
1
Asset Management
2006
1
Business Analysis
2013
1
Business Requirements
2014
1
CGI
2014
1
Citrix
2010
1
Crystal Reports
2007
1
Data Conversion
2013
1
Data Governance
2015
1
Data Mapping
2013
1
Data Migration
0
1
ERP
2006
1
HTML
0
1
J.D. Edwards
2007
1
LAWSON
0
1
Linux
2015
1
Microsoft Access
0
1
Oracle
2013
1
OS/400
2006
1
Peoplesoft
0
1
Performance Management
0
1
Process Improvement
0
1
Prototype
2015
1
RPG/400
2014
1
SaaS
0
1
SAP
2007
1
SAP EBP
2007
1
Scripting
2015
1
System Administration
0
1
Test Scripting
0
1
Turnover
2012
1
UAT
0
1
Unit Testing
0
1
UNIX
2015
1
VPN
2012
1
Windows
2010
1
Windows XP
2010
1
Languages
French, Basic