Engineer Analyst

S. E. YARBROUGH

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

*******@*****.***

System I / AS400/ Senior Programmer/Analyst

www.linkedin.com/in/seyarbs

Summary

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

- Root cause analysis

- IDOCTOR

- INAV

- LPAR

- HMC

- DM

- OS upgrade

. iSeries/AS400 New Software development

. iSeries/AS400 modifications to existing legacy systems

. Data Migration Solution Methodology

. Project Management Methodologies (Six Sigma)

Work Experience

BANK OF AMERICA [BANKING] 09/10-7/11

AS400 SW Engineer (Consultant)

. Data Warehouse project. Designed datamart(s) using MicroStrategy

as the BI, Informatica for the ETL and iSeries as the sourcing

environment. Development for various lines of business within the

corporate mortgage divisions

. DB Designed within ILE using I5/OS, RPGLE, CLE, stored procedures,

RPGLE procedures, ODBC, DB2, SQL server, exports, binding language

and data modeling.

. Technical Leader for three team members

. Other responsibilities included assignments within all phases of

SDLC (e.g., specifications, design, development, testing,

integration and support).

. Corporate level project (completed on time and on budget)

BLUE CROSS BLUE SHIELD [HEALTH CARE] 03/10-09/10

AS400 SW Engineer (Consultant)

. Designed and programmed new functions to existing real time health

care Member's data base maintenance system using Power-MHS, COBOL-

ILE, TCP/IP, JDBC, XML, MQ and DB2 on the iSeries.

. This was an existing system I help build during 2008 and 2009 (see

reference below).

. Corporate level project (completed on time and on budget)

. Technical Leader for Six team members

. Other responsibilities included assignments within all phases of

SDLC (e.g., specifications, design, development, testing,

integration and support).

BANK OF AMERICA [BANKING] 07/09-1/10

AS400 SW Engineer (Consultant)

. Provided software solutions and support for the (Loan Statement

Generator) application using I5/0S, RPGLE, CLE, RPGIV, stored

procedures, ILE Procedures, exports, binding language and

directories.

. Earned certificate of achievement (Lean Six Sigma Black Belt).

. Corporate Consolidation project(finished on time and on budget )

. Technical Leader for Six team members

. Other responsibilities included assignments within all phases of

SDLC (e.g., specifications, design, development, testing,

integration and support).

BLUE CROSS BLUE SHIELD [HEALTHCARE] 05/08-7/09

AS400 SW Engineer (Consultant)

. Developed new SOA applications for the subscriber members database.

Modularization within ILE using COBOL, DB2, CLLE, JDBC, XML,

procedures, embedded SQL, APIs, service programs, and binding

languages.

. Analyzed and provided solutions to manage fact-finding, performance

tuning, new development, coding error handlers within ILE.

. Designed and programmed datamart for reporting using Crystal

Reports as the BI and iSeries as the sourcing environment.

. Performed assigned responsibilities within all phases of SDLC

(e.g., specifications, design, development, testing, integration

and support).

. Served as member of a board that implemented corporate coding

standards.

. Corporate level project(completed on time and on budget )

. Technical Leader for five team members

. Other responsibilities included assignments within all phases of

SDLC (e.g., specifications, design, development, testing,

integration and support).

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

AS400 SW Engineer (Consultant)

. Developed and implemented SOA interface for AR (Oracle server

database application).

. Designed within ILE using RPG/ILE. COBOLII, CLLE, TCP/IP SOCKET,

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

programs, binding language and GUI navigation. Also worked in JDE

7.3 environment (Sales).

. Other responsibilities included assignments within all phases of

SDLC (e.g., 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.

. Implemented JWALK release (4.1) to modularize new DDS distribution

for remote users.

. 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)

. Enhanced/modified/created SOA batch and real-time banking interface

applications (SOA) within ILE using AS400, RPGIV, embedded SQL,

RPG/FREE, CLLE, ILE procedures, embedded SQL, CGI, C-functions,

binding and socket programming supporting voice protocols.

. Installed OS/400 v5r2 release and support.

. Other responsibilities included assignments within all phases of

SDLC (e.g., specifications, design, development, testing,

integration and support).

MEADOWBROOK INSURANCE HOLDINGS 05/03 -9/03

AS400 Sr. Programmer Analyst (Consultant)

. Audited company accounting applications; reported directly to CFO.

. Updated AR, Claims, and GL systems to fix out of balance conditions

within ILE using AS400, embedded SQL, CLLE, and COBOL/ILE.

. Other responsibilities included assignments within all phases of

SDLC (e.g., specifications, design, development, testing,

integration and support).

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

AS400 Sr. Programmer Analyst (Consultant)

. Designed and programmed database enhancements (subscriber

eligibility portion [Claims] applications) within ILE using

RPGIII/400, RPGIV/ILE, CLLE, embedded SQL, Code400 (Websphere) and

Java.

. Purpose: HIPPA upgrades with efforts on EDI framework.

. Change Management (CODE400) and ALDON.

. Other responsibilities included assignments within all phases of

SDLC (e.g., specifications, design, development, testing,

integration and support).

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

AS400 Sr. Programmer Analyst (Consultant)

. Database enhancements (WCC Claims Processing applications).

. Online e-messaging and email claims/agent notification software

services.

. ILE environment using RPG/ILE, CLLE, email, and binding language.

. Troubleshooting and problem resolution.

. Other responsibilities included assignments within all phases of

SDLC (e.g., specifications, design, development, testing,

integration and support).

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

AS400 Sr. Programmer Analyst (Consultant)

. Database modularization (Claims Adjudication applications) within

ILE using: RPG/ILE, CLLE, embedded SQL and Java programming code on

the AS400.

. Troubleshot and resolved OPM and ILE bugs.

. Other responsibilities included assignments within all phases of

SDLC (e.g., specifications, design, development, testing,

integration and support).

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

AS400 Sr. Programmer Analyst (Consultant)

. Database modularization (Underwriting insurance package WINS (P&C)

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

service programs, CLLE, binding language and DDS/GUI navigation.

. Claims, AR, Enrollment and Adjudication.

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

development, testing, integration and support).

. Technical Leader for three team members

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

AS400 Sr. Programmer Analyst (Consultant) Team Leader

. Database modularization (FDA for approval process)

. Using AS400, RPGII, RPGIII/400, COBOL, CLLE, C-functions,

procedures, embedded SQL, API's,

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

integration and support)

. Managed two onsite programmer/analysts.

. Other responsibilities included assignments within all phases of

SDLC (e.g., specifications, design, development, testing,

integration and support).

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

AS400 Sr. Programmer Analyst (Consultant) Cluster Leader

. Y2K date conversions (Completed on time and within budget)

. ILE environment using AS400, IBM mainframe, COBOLII, COBOL/400 and

CLP.

. Cluster deliverables: Italy, France and Germany.

. Implementation of an automated testing tool (WinRunner).

. Other responsibilities included assignments within all phases of

SDLC (e.g., specifications, design, development, testing,

integration and support).

BLOCKBUSTER ENTERTAINMENT 9/97 - 1/98

AS400 Sr. Programmer Analyst (Consultant)

. Database modularization JDE (ERP) AP/AR software package from v5.1

to v7.3 (full life cycle).

. Managed three onsite programmer/analysts.

. Other responsibilities included assignments within all phases of

SDLC (e.g., specifications, design, development, testing,

integration and support).

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

AS400 Sr. Programmer Analyst (Consultant)

. New development (data warehouse/datamart) uniting 21 remote AS400

sites.

. OPM environment using VB, Crystal Reports, ODBC, sub-file

processing, JCL, CLP, DB2, SQL, COBOLII, COBOL400, OCL and CL.

. Other responsibilities included assignments within all phases of

SDLC (e.g., specifications, design, development, testing,

integration and support).

ALL STATES CONSULTING GROUP 1/95-2/95

AS400 Programmer Analyst (Consultant)

. Migrated personnel database from an AS400 to Novell LAN platform.

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

AS400 Programmer Analyst (Consultant)

. Database modularization (Order Entry and Inventory Control

applications) within OPM environment using AS400, RPGII,

RPGIII/400, SEU, CL, DDS, and subfile processing.

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

AS400 Product Manager (Full time)

. 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.

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

Programming Languages:

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

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

Environments:

I5/OS; OS400; APPC; TCP/IP; DB2. Websphere (6.0); IFS, Windows

Utilities:

DFU; SDA; SEU; FTP; XML; MQ-Series; IFS; Pathfinder; WinRunner; Robot

Scheduler; SDA, DBU; File-Aid; Code400; Hawkeye

Change Management:

TurnOver; ALDON/CM; CODE400 Project; Implementer

Education

Christian Brothers University,

B.S., Information Resource Management, 1985

State Technical Institute, Memphis, TN

A.S., Data Processing, A.S., Accounting, 1983

REFERENCES AVAILABLE UPON REQUEST

Contact this candidate