• 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

• 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

• 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

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

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

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.