to contact an iSeries/AS400 Consultant please use the form below or email firstname.lastname@example.org
Emergency support available
Credentials : Edwin T. Cooke III, CDP
San Antonio , Texas
03/2006 – Present Contract Programmer Developed Inventory Chart using SEQUEL to replace a “Manual Report”. The “Manual Report” takes 2-3 days to complete. The SEQUEL report runs in less than 30 seconds. Involved in the installation of Report 2 Web, a document storage software package. Used VB Script to write custom applications to take reports written to the iSeries IFS and redirect them to the proper folder in the Report 2 Web. Responsible for setting up new users on the iSeries. Second Level Help Desk support for problems with iSeries Hardware and Software.
The Bombay Company, Fort Worth , Texas
04/2005 – 03/2006
AS/400 Project Lead Fulfillment Systems The core of the Fulfillment System is JDA’s warehouse management software. Managing a team of up to four programmers I used Microsoft Project and a time estimating model to facilitate system integration of Global Exchange Services (GXS) Logistics Visibility (LV) , Order Life Cycle Visibility product (OLV) and EDITrade/Oceanwide Customs Link Product. Using a combination of EDI formats 850, 855, and 856 as well as custom files to exchange date between the two software packages. Working with a team of four programmers work was assigned and progress monitored using Microsoft Project. Daily duties included but were not limited to the support of Inventory Accounting, Container Tracking and Distribution Center applications. Identified and corrected a 10 year flaw in a key control program which caused errors in DC transfer processing.
States General Life Insurance Company, Fort Worth , Texas
10/2003 – 01/2005
AS/400 Senior Programmer/Analyst Created applications to process Agent and Policy Information gathered from web sites. I worked with staff to develop new applications. Handled encryption and de-encryption of sensitive files retrieved from the web. I was asked to redesigned application to email commission statements to agents from the AS400.
On-Site Information Systems Inc., San Antonio, Texas
01/2003 – 10/2003
Web Developer Designed e-commerce sites for Texas Trophy Hunter’s customers. Created data driven web pages for several customers using asp and Microsoft Access. Developed web portal for Texas Deer Association. Implemented several of Texas Trophy Hunters web software applications. Designed several databases for data driven pages. Added new web sites to IIS server. Assigned email accounts for new customers. Worked on problems with memory leaks on sever.
ATSI Communications Inc., San Antonio, Texas
10/2001 – 01/2003
AS/400 Senior Programmer/ Analyst Designed web application to access call statistics on the AS400 using ILE RPG and HTML. Created application to process 7.8 Billion Codes for Call Routing. The application runs in about 20 min. Developed Customer Trouble ticket system using ASNA’s Visual RPG .to gather problem information then dispatching the information via e-mail and Cell phone text messaging to the appropriate technician. Designed, coded and tested Call Risk Management Model for the communications engineers and Corporate Management. The software was developed using Visual RPG and was used to identify positive or negative effects of changes in market prices. Supported companies web site making changes to content using Macromedia’s Dreamweaver 4 and Fireworks 4 Studio. Convert access call detail records from carrier to AS400 DB2 file for call analysis.
Aquila Gas Pipeline, San Antonio, Texas
06/1996 – 08/2001
AS/400 Senior Systems Analyst Perform systems analysis, design, coding and testing for gas Transmission Company on IBM AS/400 utilizing RPG, RPG IV and CL. The last project was Pipeline Maintenance Enhancements. Some of the added features were the ability to launch Internet Explorer for the purpose of plotting a point on a topographical map using GPS coordinates passed by the launching program. The Inquiry/Report program uses a generic subfile to display data in seven different sort sequences. Once desired information is selected the user has the ability to either print the information or write it out to a .CSV file. The program then automatically opens the file in Microsoft EXCEL. The user has the ability to select and sequence over 150 fields from 7 different data files on the fly. The print feature automatically sizes the report between 85,132,198 column print files. The limitation of the print files is 198 characters where the .CSV file has a 1024 character limitation. The Inquiry/Report application also utilizes menu bars, scroll bars, and panel groups for help. This was made possible by utilizing the AS400 DB2 architecture. As project lead was responsible for design & maintenance of Physical Inventory System and Cycle count subsystem. Designed and coded and tested General Purchase Order System. While I was at Aquila acted as mentor to junior programmers helping them with coding questions and design problems.
Bausch & Lomb, San Antonio, Texas
03/1995 – 02/1997
AS/400 Senior Systems Analyst Perform systems analysis, design, coding and testing for a manufacturing company on IBM AS/400 utilizing RPG and CL. Emphasis on implementing manufacturing process solutions to increase productivity in manufacturing operations. The last project was to develop a tracking system utilizing high-speed scanners to track product through the manufacturing process. Made simple change to shipping application, which cut the process time by 75%. Maintained accounting application using Fox Pro.
Computer Resource Management Inc., San Antonio, Texas
07/1994 – 03/1995 AS/400 Programmer/Analyst Provide custom programming support for company’s long distance software package on IBM AS/400 utilizing RPG and CL. Last project was working on a Fortune 100 company’s long distance billing package. The company had a requirement to be able to rollup the charges from a unit level up to a District/Regional total. The program utilized a parent/child account design. Took active roll mentoring junior programmers in the use of RPG, subfiles and CL.
ALCOA Fujikura Limited., San Antonio, Texas
10/1989 – 07/1994
Special Projects Coordinator Evaluate, design and implement new technologies for the AS/400. Last project was the installation of a fiber optic backbone in ACUNA Mexico. Manager Computer Operations Manage daily operations of the AS/400. Supervised three shifts of operations personnel. Acted as system administrator for the two AS/400. Worked with the AS/400 DB2 database to make sure the saves were performed. Wrote programs to reorganize the physical files as needed. Identified and journaled key physical files for later review. Responsible for AS400’s Operating System and PTF updates. Worked with a team of operators and programmers to put a Disaster Recovery Plan together. Senior Systems Analyst Manage day-to-day operation and performance of the AS/400. Act as Data Base Administrator for new systems development. Provided system administration for users and programmers.
Intelogic Trace, Systems Group, San Antonio, Texas
07/1988 – 10/1989
MIS Manager, IBM Systems Development Data processing department manager was responsible for day-to-day operations. Evaluate and make recommendations concerning future software acquisitions. Develop and implement the migration of existing software systems from the IBM System 36 to the AS/400. Supervise and work with programmer to develop and maintain programs to increase user productivity. Handled the system administration and review the AS/400 DB2 file structure to make sure all files were optimized and saved. Was responsible for AS400 Operating System Upgrade and PTF updates.
San Antonio College, San Antonio, Texas
09/1984 – 05/1986
IBM Programming Instructor SAC Instructor responsible for the planning, preparation and execution of Advance RPG classes. Acted as consultant to the Data Processing Department helping with the operation of the IBM System 38. Also taught a class in Advanced Systems Design and project development methodologies.
Texchron, Inc., San Antonio, Texas
02/1982 – 07/1988
Senior Systems Analyst Develop, design and implementation of applications software packages to include order processing, inventory control, a Service Center Tracking System, purchase order system and Marketing and Sales System utilizing an IBM System 38 with RPGIII and CL. Assisted in the system conversion from a Datapoint ARC system to the IBM System 38. Handled data communications requirements for remote data communications
Texas A&M University, Corpus Christi, Texas Masters Computer Science, 1984. GPA: 3.3
Graduate Project was an Interactive Order Entry System on the IBM System 38
University of Texas, Austin, Texas, BS RTF School of Communications, 1974.
ASNA’s Visual RPG - XML Datapoint ARC System - IBM - S/36(B24), S/38 (600), AS/400 I Series RPG II & III & IV RPG400 & ILE - COBOL Basic & Qbasic - Communication - SDLC, BSC J.D. Edwards, Order Purchasing - Lawson, Accounts Payable PCR, Accounts Receivable - AS400 System Administration/Operations Freelance, Powerpoint Excel, Symphony, Word Novell 3.11 , Foxpro Gentran - EDI , FrontPage/Dreamweaver Photoshop/Fireworks, HTML DB2 Database Design, Rumba Access, Essbase, Cognos Hawkeye Abstract/Probe DBU 6.0, Implementer, Robot , SEQUEL, SQL
References Available Upon Request