Resume

Sign in

IBM i (AS/400) Programmer Analyst

Location:
Fort Wayne, IN
Posted:
February 24, 2020

Contact this candidate

Resume:

Lonnie M. Eley

Fort Wayne, IN *****

260-***-****

adbyyh@r.postjobfree.com

Summary:

Senior Level Applications Developer who effectively communicates with financial and manufacturing leaders (C-Level, Directors and Mangers) to solve complex and difficult business issues.

Works in highly regulated organizations creating detailed and innovative systems.

Collaborative skills displayed in working cohesively and decisively to inspire confidence with constituent groups and communicating clearly to address intricate issues in both technical and non-technical terms.

Technical Background:

Operating Systems: i5/OS, OS/400, MS-DOS, Windows 95, 98, 2000, NT, XP OS/360-390, OS/MVS

Midrange Programming Languages: RPG IV/ILE, RPG/400, RPG III, RPG II, RPGSQL, COBOL/400, SQL

Mainframe Programming Languages: COBOL, JCL, BASIC, ASSEMBLER

Programming Techniques: ILE, APIs, Arrays, Subfiles, Triggers, Built-in Functions, Stored Procedures, Embedded SQL, SQL scripting

Query Languages: Query/400, SQL/400, SQL, SEQUEL, EARL

Software Utilities: PDM, SEU, SDA, DFU, RLU, DBU, ISDB, EZ-View, Aldon, Hawkeye, Probe, Aplus, FTP, IFS, iSeries Client Access, iSeries Navigator, iSeries RPG2SQL Integrator, Robot Microsoft SQL Server Enterprise Manager, DB2, TSO/SPF, VSAM, CICS, CMS, FAQS, PANVELET, DYNAM, Implementer, Turnover

Networking: Rumba, Client Access/400, N-S Elite, Extra

Hardware: IBM i, AS/400, iSeries, System i, IBM 3081, IBM 3090, IBM 4381, PCs

Package Experience:

Allied Insurance System (AIS)

Specialty Insurance System (SIS)

Business Planning & Control System (BPCS)

Advanced Patient Care Delivery System (APaCS)

Jenzabar (TE) – Student Information System

Taxware Sales/Use Tax and Verazip Systems

Infinium Financial Management Software

Kronos iSeries Central/Timekeeper

Specific Application Experience

Accounting, Sales Analysis/Reporting

Point of Sale, Accounts Payable, Inventory Control

Order Entry, Accounts Receivable, Billing/Invoicing

General Ledger, Policy Issue, Policy Premium/Coverage

Policy Claims, Agent Commissions, Demand Deposit

Mortgage, Contemporaneous Reserves, Bar Code

Labeling, Year 2000 Conversion, Electronic Data Interchange (EDI)

Payroll, Pricing, Purchase Order

E-mail

Professional Affiliations:

Member of Tri-State Midrange Users Group (TSMUG) since 1996

Member of RPG/AS400 Developers Group

Education & Certification:

Indiana Purdue University

oMajor Business Administration

Lincoln National Corporation

oComputer Training Unit (CTU)

oIBM Mainframe Course Curriculum

oA.A.S. Equivalent

IVY Technical State College

oA.A.S. Information Data Management

oA.A.S. Computer Programming

Cincinnati State Technical College

oIntroduction to RPG/400

oAdvanced RPG/400

IBM Certified Specialist

oAS/400 RPG Programmer

PROFESSIONAL EXPERIENCE

Harris Corporation (formerly Exelis/ITT Corporation) June 2010 - Present

Senior Programmer Analyst

Responsibilities:

Collaborate with finance professionals (Finance Managers, Accounting Analyst, HR Benefits Manager, Accounting Compliance Analyst, etc.) during the requirements gathering phase of the Information Service Request (ISR). Responsible for gathering requirements and translating into functional technical specifications. Work with vendor Implementation teams to determine financial data elements, data structures, and data mapping. Projects were completed on time, within budget, resulting in significant savings.

Perform full-life cycle (research, analysis, design, code, test, debug, document and implement) development of business application software. RPG IV, RPG III, RPG/400, SQL, DB2, Query/400, CL, FTP/PGP encryption, IFS, Client Access, Surveyor/400, and other technical tools and skills are used in providing business application software solutions. Subfile/Window programming is also performed.

Develop, enhance, and maintain application software related to Infinium Financial Management (AP, CM, FA, GL, GT, IR, PE, PL, PY, QY, SO, SS, and TX) and Concur Travel & Expense.

Perform Infinium HR/Payroll software version upgrades and upgrade retrofits. Custom programming work is also performed within this module.

Perform Infinium Financials (FA, GL, PL, CM, GT, SS, etc) software version upgrades and upgrade retrofits. Custom programming work is also performed within these modules.

Work with Financial Compliance Officer (FCO), internal/external audit teams, and other finance professionals in the development and enhancement of Sarbanes Oxley (SOX) and Segregation of Duties (SOD) reporting.

Setup secured FTP/PGP transmission using Patrick Townsend software for transmitting DB2/400 financial database files to business partners, banks, and other financial institutions.

Resolve software application issues related to Infinium Financials and Concur T&E software that is reported via the Remedy system based on priority (low, medium and high).

Perform Infinium system security and administration duties.

CGI - Information Technology Consulting

Dollar General March 2010 – June 2010

Sr. RPG/AS400 Programmer Analyst

Responsibilities:

Develop and enhance custom application software using RPG IV, CL, subfiles, built-in-functions, procedures, subprocedures, static binding, and static/dynamic embedded SQL.

The customized application development work is part of the retail merchandising system (Island Pacific).

Analyze and fix software related issues reported by the system analyst during system integration testing.

Perform full-life cycle application development analyst work remotely (telecommute) based on the technical design documents (TDD) prepared by the systems analyst.

Prepare unit test script documents. Unit test software application development work based on the test scripts.

Update technical design documents (TDD) based on revisions to business requirements.

Union Institute & University January 2010 – April 2010

Sr. RPG/AS400 Programmer Analyst

Responsibilities:

RPG (all versions), CL, and DB2/400 database file analysis was performed to interpret business logic and processes for converting custom application software from the AS/400 computer platform to the Microsoft SQL Server platform.

Converted the Student Information System DB2/400 database files using RPG IV and interactive SQL. SIS database file cleanup was also performed before importing the data into the Microsoft SQL Server databases.

Modified SIS software within specific modules (Admissions, Registration, Business Office, etc.) based on business requirements.

Query/400, RPG IV, CL, and user commands were used to fulfill the business users’ reporting request.

PSI Group, Cincinnati, OH

National City Mortgage July 2009 – November 2009

RPG/AS400 Programmer Analyst

Responsibilities:

Develop, enhance, and maintain custom application software within the Mortgage Originator (TMO) software package. Responsible for gathering requirements and translating into functional technical specifications based on the Information Service Request (ISR).

Create Impact/Analysis Technical Specifications related to the ISR. Based on the business requirements and IATA, develop or enhance custom software using RPG (all versions), ILE, CL, SQL, and the IFS. Other IBM i (AS/400) tools and techniques were also used during the SDLC.

Provide TMO application support for SEV (Severity) 3 through 5 service incidents. Maintain and enhance custom software related to mortgage banking regulatory changes.

General Cable Corporation July 2006 - July 2009

Senior Programmer Analyst (Finance)

Responsibilities:

Worked with Manager of Retirement Plans to facilitate Fidelity 401K Financial Conversion project. Responsible for gathering requirements and translating into functional technical specifications.

Collaborated with the Implementation Team at Fidelity Investments to determine financial data elements, data structures, and data mapping. Performed full-life cycle (research, analysis, design, code, test, debug, document and implement) development using RPG IV, CL, SQL, DB2, FTP/PGP encryption, IFS, Query/400, and other technical skills. Performed same responsibilities on the ADP iPay Check/Voucher, UHC/Aetna Conversion, and other projects. Projects were completed on time, within budget, resulting in significant savings.

Collaborate with business unit (HR/Payroll, Account Receivables, Account Payables, Credit/Collections, and Tax) professionals to gather business requirements. Translate business requirements into functional technical specifications. Develop, enhance, and/or modify application software related to Infinium Financial Management (AR, GL and Payroll), Kronos iSeries Timekeeper, and ADP Taxware/Verazip.

Perform full-life cycle (research, analysis, design, code, test, debug, document and implement) development of business application software. RPG IV, RPG III, RPG/400, SQL, DB2, Query/400, CL, FTP/PGP encryption, IFS, Client Access, and other skills are used in providing business application software solutions. Subfile and window programming is also performed.

Perform Infinium HR/Payroll software version upgrades and upgrade retrofits. Custom programming work is also performed within this module.

Perform Infinium Financials (FA, GL, PL, CM, GT, SS, etc) software version upgrades and upgrade retrofits. Custom programming work is also performed within these modules.

Perform software version upgrades for Kronos iSeries Timekeeper, ADP Taxware/Verazip.

Develop FTP/PGP scripts for transmitting DB2/400 financial database files to business partners, banks, and other financial institutions.

Create financial data for internal/external auditors and provide the data based on the requested formats (csv, xls, xml, txt, DB2/400, etc.).

Setup, configure, and implement Kronos 4500 Time Clock Terminals within Kronos iSeries Timekeeper 5.2.1 at General Cable manufacturing plants.

Resolve critical (priority 1 and 2) financial software/hardware related issues related to Infinium Financial Management, Kronos iSeries Timekeeper, and ADP Taxware/Verazip.

Perform Infinium and Kronos system security and administration duties.

Union Institute and University June 2003 - July 2006

Senior Programmer Analyst

Responsibilities:

Collaborate with business units, Director of Computer Services, and the Systems Analyst to determine and prepare program requirements and technical specifications for the development and/or modifications to application software related to the Student Information System (SIS).

Project management responsibilities included coordinating and scheduling meetings with project sponsors, business unit managers, and/or university administration during the requirements gathering phase of projects. Prepared functional specification/requirement documents in collaboration with the Business Analyst and IT Director.

Perform application, program, and database file analysis (DB2/400) to determine programming modifications for the various Jenzabar (TE) application software modules (Admissions, Registration, Financial Aid, Finance, Human Resources, etc.).

Perform full-life cycle (analysis, design, code, test, debug, document, and implementation) development of application software using RPG IV, RPG III, RPG/400, SQL/400, and CL. Subfile and window programming is also performed.

Review and evaluate software (Websphere HATS, iSeries RPG2SQL Integrator, etc.) solutions for integration into application software development/redevelopment projects.

Developed FTP scripts for the transferring of DB2/400 database files to the IFS, then to e-College.

Native OS/400 API product (iSeries RPG2SQL Integrator) is used to directly access SQL server tables for insert, update or delete using ILE/RPG programs. RPG IV trigger programs were written to invoke these ILE/RPG programs using RPG2SQL Integrator APIs.

Perform some AS/400 Computer Operations and Security functions.

Development utilities used are FUF, FM, FU, RQ, and iSeries Client Access.

Bigg’s Supervalu June 2005 - December 2005

Freelance Part-Time AS/400 (iSeries) Consultant

Responsibilities:

Developed business application software to FTP and merge ACS Upromise point-of-sale transactions into ACR Upromise point-of-sale transactions.

In addition, a subfile application was developed to enable computer operations to process the point-of-sale ACS Upromise backlog before sending the files via FTP.

Developed software solutions for administering the User Application Menu ID Control and Authorization, Segregation of Duties, and System Operations (job accounting) related to Sarbanes-Oxley (SOX) compliance. Resolve Daily Sales Variance Reporting Issues.

Enhance Vendor Inquiry Online Application. Resolve Basic/Seasonal Line Reporting Issues.

3X Corporation May 1999 - June 2003

Senior Consultant

Responsibilities:

As an IBM Certified Consultant, provided business systems analysis and application development services as part of the IBM AS/400 Solutions Group team using RPG IV/ILE, RPG/400, RPG III, RPG II, SQL, DB2, Query, CL, and other skills (requirements gathering and technical specifications) to provide business application solutions. Client list included Luxottica Retail, Drake Center, Mike Albert Leasing, Meritor Automotive, Givaudan, and LensCrafters.

GRE Insurance Group October 1997 - May 1999

Senior Application Developer

Responsibilities:

As a Year 2000 Conversion Specialist, analyzed, modified, and tested 100+ customized RPG and CL applications to ensure Y2K compliance.

Designed, developed and implemented new business applications as well as modified and maintained existing applications on the Specialty Network Auto Insurance System (policy, rating, billing, & claims).

Subfile and window programming performed on various applications.

Federal Home Loan Bank of Cincinnati October 1996 - October 1997

Senior AS/400 Developer

Responsibilities:

Senior AS/400 developer in a Unisys to AS/400 conversion. Responsible for analysis, design, coding, testing, and implementation of the Contemporaneous Reserves banking application written in COBOL/400 and CL.

Application consisted of twenty-five menu options with online interactive and batch processing functionality. Modified and maintained various banking applications (installment credit, demand deposit, etc.). Subfile and window programming performed on various applications.

AON Corporation / K & K Insurance Group January 1991- October 1996

AS/400 Developer

Responsibilities:

Designed, developed and implemented new business applications to support a rapidly growing insurance company.

Involved in all phases of the application development life cycle, including requirements definition, design specifications, prototyping and development, testing and implementation.

Used RPG/400, COBOL/400 and CL to develop, enhance, and maintain all system applications (policy, rating, billing, & claims).

Worked extensively with senior management to develop financial reports that highlighted the performance of various products and divisions.

Subfile and window programming performed on various applications. Import/export data using File Transport Protocol (FTP).



Contact this candidate