S. E. YARBROUGH

**** ****** ***** ****, ******, TX 78747, 512-***-****, E-Mail:

abm4ho@r.postjobfree.com

AS400 Senior Programmer/Analyst

Summary

Actively involved in the information technology field since 1983; full-

time consultant since 1994.

The following elements are used to build my brand.

. Service Oriented Architecture (SOA) design and deployment

. iSeries/AS400 Modularization (best practices)

. iSeries/AS400 Performance improvements

. iSeries/AS400 New Software development

. iSeries/AS400 modifications to existing legacy systems

. Project management methodologies (Six Sigma)

Work Experience

Bank of America [Banking] 07/09-1/2010

AS400 SW Engineer (Consultant)

. Provide software solutions and support for the iSeries.

. Software development for the Statement Generator loans banking

applications.

. Certification of achievement (lean Six Sigma Black Belt

Blue Cross Blue Shield [Healthcare] 05/08-7/2009

AS400 SW Engineer (Consultant)

. Implemented and upgrade a SOA COBOL ILE /DB2 interface.

. Fact finding, performance tuning, new development, coding error

handlers, and training.

. Project also involved the rewrite of COBOLII programs batch code

from the Original Programming Model (OPM) to an Integrated Language

Environment (ILE) developing new applications using COBOL ILE,

JDBC, XML, procedures, embedded SQL, API's, service programs, and

binding language. Created and implemented datamart for reporting.

Addition, responsibilities included assignments within all phases

of SDLC (specifications, design, development, testing, integration

and support).

. Member of a board that implemented corporate coding standards.

DANIEL/EMERSON, INC [MFG] 11/07-5/2008

AS400 SW Engineer (Consultant)

. Implemented and developed a SOA RPG/FREE interface. The client

needed to interface with their newly implemented AR oracle server

database application.

. Project also involved the rewrite of COBOLII programs from the

Original Programming Model (OPM) to an Integrated Language

Environment (ILE) developing new applications using RPG/ILE. TCP/IP

SOCKET, RPGIV/ILE functions, procedures, embedded SQL, API's,

service programs, and binding language. Programming new Sub-files

and data queue using GUI navigation

. JDE 7.3 (Sales)

. Other responsibilities included assignments within all phases of

SDLC (specifications, design, development, testing, integration and

support).

Q2/CARDINAL INC. [INTERNET & CORE BANKING] 2/05 - 10/07

AS400 SW Engineer (Consultant)

. Implemented and developed a SOA real time message exchange socket

communications protocol using RPGLE, CLLE, RPG/FREE, embedded SQL,

HTML and service instance.

. Finally, additional responsibilities included assignments within

all phases of full life cycle development of core banking

applications.

SECURITY FIRST (S1) [INTERNET BANKING] 9/03 - 2/05

AS400 Sr. Programmer Analyst (Consultant)

. Primary assignment involved enhancements/modifications to batch and

real-time banking interface applications.

. Assignment also involved the development and programming of new

modules and service programs to update the current package of

programs from OPM to a true ILE environment using a combination of

RPGIV, embedded SQL, RPG/FREE, CLLE, ILE procedures, embedded SQL,

CGI, C-functions, binding and socket programming supporting Voice

protocols .

. Implemented new banking functions within current interface

applications

. In addition, responsibilities included the development and

deployment of a homegrown CM (change management) system; the system

was designed using Rational unified processing tool set and TCP/IP

communication Services.

. Installed OS/400 v5r2 release and support).

MEADOWBROOK INSURANCE HOLDINGS 05/03 -9/03

AS400 Sr. Programmer Analyst (Consultant)

. Primary assignment involved the computer auditing of the company

accounting applications.

. Development and programming of new modules and service programs to

update AR, Claims, and GL systems using a combination of COBOL400,

embedded SQL, CLLE, and COBOL/ILE procedures.

. Implemented archive rule for production and new reporting to catch

out-of-balance conditions within the cycle processing during month-

end closing.

. implemented and coded new programs to report pay mode and pay code

changes for online processing, reengineering core systems without

major disruptions.

. In addition, analyzed and developed new documentation outlining the

new development within the Point insurance applications.

WEA TRUST INSURANCE CO. 12/02 - 5/03

As400 Sr. Programmer Analyst (Consultant)

. Primary assignment involved the development and programming of new

software modules and service programs to update the Subscriber

Eligibility portion of the Claims processing application

. New development using a combination of RPGIII/400, RPGIV/ILE, CLLE,

embedded SQL, CODE400 (WEBSPHERE) and Java.

. Completed HIPPA upgrades with efforts on EDI framework.

. In addition, conducted training classes (CODE400), analyzed and

gave comments on the purchase of ALDON and developed new

documentation outlining the processes within the eligibility

applications.

TEXAS MUTUAL INSURANCE CO. (WIN) 6/02 - 12/02

AS400 Sr. Programmer Analyst (Consultant)

. Primary assignment involved the development and programming of new

software modules and service programs to automate the newly

implemented WCC Claims Processing applications.

. Assisted with the coding and implementation of a new online e-

messaging and email claims/agent notification software services

using RPG/ILE, CLLE and binding language.

. In addition, developed, coded and implemented new error-correction

applications to forward required information to the Texas Workers'

Compensation Commission.

. Additional responsibilities included troubleshooting and problem

resolution (OPM, ILE, RPGIV objections) for the existing

applications.

ADVANCE PCS [INSURANCE CLAIMS] 1/02 - 6/02

AS400 Sr. Programmer Analyst (Consultant)

. Developed and implemented new software modules, object programs,

service programs to enhance and automate online processes within

Claims Adjudication applications

. Used a combination of RPG/ILE, CLLE, embedded SQL and Java

programming code on the AS400.

. Troubleshot and resolved OPM and ILE objections issues within the

nightly cycle processing. Project included 80 hours of in-house

training on existing Claims adjudication system applications.

CHARTER INSURANCE CO. (WIN) 9/99 - 1/02

AS400 Sr. Programmer Analyst (Consultant)

. Implemented new programming development for the Underwriting

processes of a new online insurance package WINS (P&C).

. Conversion of COBOL400 programs from the Original Programming Model

(OPM) to an Integrated Language Environment (ILE) developed new

applications using COBOL/ILE, procedures, API's, embedded SQL,

service programs, CLLE, and binding language within Claims, AR,

enrollment and adjudication.

. Implemented and coded sub-file processing and data queue processing

using DDS/GUI navigation.

. In addition, responsibilities included assignments within all

phases of full-life cycle project (specifications, design,

development, testing, integration and support).

ELI LILLY, INC [DRUG MFG] 1/99 - 9/99

AS400 Sr. Programmer Analyst (Consultant) Team leader

. Implemented, developed and coded new study database used for

analyzing drugs to be sent to the FDA for approval.

. Project involved the rewrite of RPGII, RPGIII/400 programs from the

Original Programming Model (OPM) to Integrated Language Environment

(ILE), developing new applications using RPGIV/ILE, C-functions,

procedures, embedded SQL, API's, service programs, and binding

language.

. Programming new Sub-files and data queue processing using GUI

navigation were also included in the upgrade.

. In addition, responsibilities included assignments within all

phases of SDLC (specifications, design, development, testing,

integration and support).

. Managed two onsite programmer/analysts

ELI LILLY, INC [DRUG MFG] 1/98 - 1/99

AS400 Sr. Programmer Analyst (Consultant) Cluster Leader

. Responsibilities include managing and developing the Year 2000

project for European sector subsidiaries in Italy, France and

Germany.

. Project involved Y2K date conversions on the AS400 and ES9000

platforms using RPGIV, COBOLII, COBOL/400 and CLP.

. Designed and implemented a knowledge database to record problems

and eventual resolutions encountered during testing and

implementation of the modified code rollout.

. Other project tasks included project risk and quality estimating,

project planning, end-user interfacing, methodology, programming

applications changes to meet Y2k standards renovation,

troubleshooting and problem resolution (within the full Y2K cycle).

. Another achievement was the implementation of an automated testing

tool (WinRunner) in the AS/400 environment.

BLOCKBUSTER ENTERTAINMENT 9/97 - 1/98

AS400 SR. Programmer Analyst (Consultant)

. Assigned to program, develop, modify current applications, and

upgrade the current JDE (ERP) software package from v5.1 to v7.3

(full life cycle).

. Analyzed and made application changes to upgrade the Procurement

and Purchase Order modules using RPGIV/ILE, RPGIII/400, COBOL/ILE,

DSPF, DDS, embedded SQL, SDA, ISDB, CLP, DDR, SAR, PTF'S, SVR, FDA,

Server Calls, JDE Standards and Case Tool to complete system.

. Project involved upgrading and modifying pre-existing code within

the procurement applications environment.

. Upgrade also included consolidating procurement of inventory and

non-inventory items.

. Also enhanced green screen (sub-file processing), replenishment

activity, automated approval routing and report monitor for

delivery, quality and price trends.

. Managed three onsite programmer/analysts

INTERNATIONAL PAPER [PAPER MFG] 2/95 - 9/97

AS400 SR. Programmer Analyst (Consultant)

. Responsible for development of a data WAREHOUSE/DATAMART to unite

21 remote AS400 sites online using the following: VB, Crystal

Reports, ODBC, sub-file processing, JCL, CLP, DB2, SQL, COBOLII,

COBOL400, OCL and CL.

. Assisted in development of Y2K procedures, using ISO Date format to

modify the in house applications to ensure accurate date conversion

for the cost and maintenance (Legacy) applications.

. Enhancement and developed online/batch processing applications

utilize COBOL400, CLP, EMBEDDED SQL, DB2, on the following

platforms: ES9000, AS/400, S/36 and Microsoft LAN. File design

utilized DDS, VSAM and DB2 (tables).

. In addition, provided problem management and user support for

new/existing applications in the newly linked sites nationwide.

UNITED STATES POSTAL SERVICE (Contract)

Consultant

. Two-day project involved the retrieval of classified information

from both the AS36 and the AS400.

ALL STATES CONSULTING GROUP 12/94 - 1/95

AS400 Programmer Analyst (Consultant)

. Project involved the migration of the Personnel database from an

AS400 to Novell LAN platform.

. As part of Acquisition team, performed pre-project vendor, data,

and method analysis. Transferred files from the JDE package on the

AS400 to the LAN using PCS and FTP for file transfer, and DOS for

the file format.

. Installed and implemented an ADP HR package on the LAN to maintain

the personnel master file information.

. Managed development and testing of the new accounting package

written in RPGIII to include the direction and coordination of

Order Entry staff regarding documentation and procedure.

OFFICE DEPOT/YORKSHIP BUSINESS SUPPLY 8/93 - 12/94

AS400 Programmer Analyst (Consultant)

. Implemented, enhanced both the Order Entry and Inventory Control

applications using RPGII, RPGIII/400, SEU, CL, DDS, and SUBFILE

processing.

. Developed various utilities used for record selection, sorting, and

sequencing files, to reduce Logical I/O overhead by sharing

files/access paths. Provided support and training related to

modifications and end users.

MAYBELLINE [HEALTHCARE PRODUCTS] 9/91 - 11/93

AS400 PRODUCT Manager (Full time)

. Modified and enhanced the MRP applications between two platforms

using COBOLII on the (ES9000), COBOL/400, RPGII and RPGIII on the

(AS400).

. Developed, tested, and installed in-house reporting applications

within the Operations Center.

. Worked with acquisition team on data and method analysis; help

developed and implemented five-year Strategic Systems Plan.

. Other accomplishments include instituting Disaster Recovery

Policies/Procedures and the reduction of paper expense by $45K

annually, with the design and implementation of an end-user

reporting database.

SCHERING-PLOUGH [HEALTHCARE PRODUCTS] 6/85 - 9/91

AS400 Supervisor/Programmer Analyst (Full time)

. Performed method analysis, designed, coded, implemented, and

maintained various Financial Systems for four manufacturing

facilities, two warehouses, and corporate headquarters, using

COBOL/400, RPGII, RPGIII, CL, CLP, and SQL on the AS400.

. Designed, coded, and implemented the Standard Cost system, Labor

Data Collection system, and multi-plant scheduling and planning

applications using RPG III on the AS400.

. Converted three multi-plant distributed systems to an AS400.

. Directed and coordinated IS staff activities; provided support and

training to end-users.

INTERNAL REVENUE SERVICE 05/83 - 6/85

Senior Tax Analyst

. Help developed tax strategy used to implement online tax

transactions.

. Trained personnel on PC-based interim application and maintained

supplier relations with software partners. The transaction process

represented 20% of each division's tax collection.

Technology Skill Sets

Hardware:

IBM AS400 (Series (e) (i)), AS34, AS36, SYS38

IBM Mainframes (ES/9000, IBM3090)

Programming Languages:

COBOL (II, 400, ILE, FREE); RPG (II, III/400, IV/ILE, FREE); embedded

SQL; JCL; CLLE/CL/OCL; DB2; QSHELL; Java

Environments:

I5/OS; OS400; MVS; JD Edwards (JDE) One World v7.3; TCP/IP; WEBSPHERE

(6.0); IFS, Windows

Utilities:

DFU; SDA; SEU; IFS; Pathfinder; WinRunner; Robot Scheduler; Dream Writer;

JDE One World Toolset; JDE SARs; Case Tool; CLIST; DBU; File-Aid;

Code400; Hawkeye

Change Management:

TurnOver; ALDON/CM; CODE400 Project; Implementer

Education

State Technical Institute, Memphis, TN

A.S., Data Processing, 1984

State Technical Institute, Memphis, TN

A.S., Accounting, 1983

Novell Training Center, Exton, PA

CNA, Novell Netware, 1994

Ernst & Young,

Project Management, 1998

REFERENCES AVAILABLE UPON REQUEST

Contact this candidate