S. E. YARBROUGH
6724 Marble Creek Loop, Austin, TX 78747, [Send email to request phone number] 91-8189, E-Mail:
seyarbs@yahoo.com
AS400 Senior Programmer/Analyst
Summary
Actively involved in the information technology field since 1983; full-time
consultant since 1994. Project experience consists of new development and
implementing modifications and enhancements to existing MIDRANGE applications
using a variety of programming languages and utilities. Additional project
experience includes Strategic Business Systems Planning, Software Evaluation,
Disaster Recovery Planning, Project Planning, Project Risk/Quality Estimating,
HIPAA Training and New Software Development.
Work Experience
Q2/CARDINAL INC. [INTERNET & CORE BANKING] 2/05 – 10/07
AS400 SW Engineer (Consultant)
Developed and implemented a real time message exchange socket communications
protocol using service-oriented architecture (SOA), voice, service
implementation, elementary access details, Contract, RPGLE, CLLE, RPG/FREE,
embedded SQL, HTML and service instance. This real time banking application (for
which I led a team of five programmers and two QA analysts through the full life
cycle for the three-tier Cardinal Teller system) saved the company over $10,000
in license fees per each core install, replaced a (third party) 5250 utility and
greatly simplified the process for externalizing ILE business logic. The
upgraded code was ported for VB and rewritten in Microsoft .Net using RUP in a
Windows 2000 environment. Another project moved business logic processes for the
UI. As team project leader, I led a team of three through planning, data
modeling, development and deployment of a .com third party package. The package
converted AS400 green screens to GUI giving the application a Windows look and
feel. The package allowed configuration using C++ as its core HLL. Developed,
combined and enhanced voice and internet banking batch interfaces, saving the
company $1,200 per install, by designing a process to install both interfaces at
the same time. Streamlined and enhanced internal applications; modernized
management solutions and added functionality into a modern application framework;
also, automated manual processes which simplified the supply process and
reengineered core systems without major disruption. Finally, additional
responsibilities included assignments within all phases of full life cycle
development of core banking applications.
SECURITY FIRST (S1) [INTERNET BANKING] 11/03 – 2/05
AS400 Sr. Programmer Analyst (Full time)
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, COBOL/ILE, RPG/FREE, CLLE, ILE procedures, embedded SQL, CGI,
C-functions, binding and socket programming supporting Voice and SOA.
Implemented new banking functions within current interface applications to
include, LOC fund transfers, overdraft protection transfers, matching reversals
and select account processing, float processing, time-zone processing, product
code change processing, transaction code processing, end-of-day enhancements and
dual-bank processing within Jack Henry (JH2020, JHSAIL) FISERV/CBSF, Morningside
and Horizon banking databases. Streamlined and enhanced internal applications,
modernized management solutions and added functionality into a modern application
framework, as well as automated manual processes and simplified the supply
process. 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. All
assignments used all phases of full-life cycle project (specifications, design,
development, testing, integration, installed v5r2 release and support).
MEADOWBROOK INSURANCE HOLDINGS 05/03 –11/03
AS400 Sr. Programmer Analyst (Consultant)
Primary assignment involved the auditing of the company accounting applications.
Assignment also involved the 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. Also 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 using a combination of RPGIII/400, RPGIV/ILE, CLLE,
embedded SQL, CODE400 (Websphere) and Java. Development was directly related to
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. 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. As part of the Claims team, assisted with the coding
and implementation of a new online e-messaging and email claims/agent
notification software services using RPGIII/400, RPGIV/ILE, COBOL/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 using a combination of RPGIII/400, RPGIV/ILE, CLLE, embedded SQL,
COBOL/ILE and Java programming code on the AS400. Also, 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. 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). Project involved the 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 an Integrated
Language Environment (ILE) developing new applications using COBOL/400.
RPGIV/ILE 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).
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. Also 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. Resolve
application design issues for the “Perfect Store Order” by developing new code
for the application. 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. Additional enhancements and new developments of
online/batch processing applications utilize COBOL400, CLP, EMBEDDED SQL, DB2, on
the following platforms: ES9000, AS/400, S/36 and Microsoft LAN. All
enhancements and applications were developed and maintained for manufacturing and
financial applications with new code per user specifications (ad-hoc reports).
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. Instituted user support for the application, with the creation
of various file setups, A/R, A/P, and G/L modules to include reporting based on
user requests. After migration, 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 McPac 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
Environments:
I5/OS; OS400; MVS; JD Edwards (JDE) One World v7.3; TCP/IP; Websphere; 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
Christian Brothers University, Memphis, TN
B.S., Information Resource Management, 1985
State Technical Institute, Memphis, TN
A.S., Accounting, 1983
Novell Training Center, Exton, PA
CNA, Novell Netware, 1994
Ernst & Young,
Project Management, 1998
HIPAA Training, 32 hrs
REFERENCES AVAILABLE UPON REQUEST
|
