Edward H. Thuer                                 

EHThuer@yahoo.com

 

SUMMARY:

q       9+ years of adding value in the IT industry through service, diligence, and professional growth.

q       Proven ability to perform superb:

* Programming                             * Customer Service                              * Database Administration

* Quality Control                         * Disaster Recovery                            * Change Management

* Problem Resolution                  * Resource Optimization                     * Testing

* Procedure writing                     * Standardization                                 * Coaching

* Counseling                                * Training                                              * Team Building

 

TECHNICAL DISCIPLINES

 

Languages

COBOL II, 390

MVS/OS JCL

SQL

Spanish

CA-Telon

REXX

VBScript

C/C++

Data Access Methods

DB2 (w/ DBA experience)

VSAM

QMF

SPUFI

Easytrieve (EZtrieve)

CICS

Omegamon

Crystal Reports

Applications

AFS Level III

TSO/ISPF

IBM OS Utilities

CompareX

Windows 95, 98, ME, XP

MS Office Suite

Lotus Notes

MS DOS

BIM

FileAid for MVS

FileAid for DB2

Xpediter

Networking w/ TCP/IP

CA-Platinum ErWin

Maestro

PanValet

 

PROFESSIONAL EXPERIENCE:

 

2004 – Present      Automated Financial Systems, Inc.

                                Senior Programmer Analyst                                                                            4/04 – Present

q       Application Service Provider AFS Level III Release 8.3.1 Upgrade Projects

q       Analyze customers’ code base and update COBOL, as necessary for upgrades

and ABEND resolution.

q       Responsible for maintenance, testing, and production support of Batch & CICS

application code.

q       Create all ETL processes to convert production data to new formats.                                      

(To include DB2 databases, VSAM and flat files)

q       Develop and implement DB2 backup and recovery jobs for four independent

databases which total over 100 tables.

q       Created new batch cycle run, using JCL modifications to increase efficiency.

q       Create and tune all SQL queries for Batch, CICS, or ad-hoc (SPUFI) needs.

q       Bind all DB2 Packages and Plans.

q       Created Forms and Documentation to ensure best-practices approach.

q       Disaster Recovery

q       Create and implement disaster recovery jobs for all ASP customers’ application

data, to include new encrypted off-site data storage.

q       Led successful DR rehearsal 2 years running.

q       ASP Billing

q       Analyze new ASP contracts and make coding changes necessary for new fee structures.

q       Automate generation of  formatted monthly reports from Batch job output.

q       Create REXX procedures to enforce quality standards for routine maintenance tasks.

q       Overnight Batch Control – Provide as needed overnight Batch support, resolving ABENDs

and ensuring delivery of ASP Service Level Agreements.


2003 – 2004            New Castle County Police Emergency Communications Division

                                Emergency Call Operator                                                                 5/03 – 4/04

q       Answering 911 to gather information from citizens that is critical for timely, safe, and appropriate

Police, Fire, and/or Emergency Medical response.

 

2001 - 2002             Trustar Retirement Services, Wilmington, DE

                                Senior Programmer/Analyst                                                                            3/01 – 10/02

q       Perform DB2 performance upgrades, and SQL tuning and training for entire IT department. 

Assist Sr. Data Modeler, implementing changes to data models with ErWin.

q       Project Lead CICS Secure Check Processing system to use DB2, from VSAM.  This included:

coding all interface modules, the entire ETL process for the data, production implementation,

Quality Assurance, supporting Batch (JCL) processing, creation and execution of Unit and

System Test Scripts, and both dynamic and static embedded SQL. 

q       Coordinate project, develop specifications, and make coding changes to customer

correspondence system to upgrade from obsolete Xerox forms.

 

1997 – 2001            Computer Aid, Inc., Wilmington, DE

                                 Database Administrator & Applications Analyst                                        5/99 - 3/01

q       Maintained entire Finished Product Inventory Costing system for the Dupont Company. 

q       DBA for nine diverse DB2 databases, using SPUFI, Fileaid, Omegamon, QMF, and other

third-party products to optimize database value.

q       Implement and refine JCL (batch) processing to minimize disaster exposure and to streamline

disaster recovery, i.e. Imagecopies, ALTERs, and REORGs.

q       Rewrite COBOL, CICS and TELON programs, with SQL, to follow best-practices initiatives.

q       Rewrite/translate MarkIV and Focus programs into COBOL with SQL, as part of

standardization program.

q       Progressed from COBOL Programmer to Applications Analyst and Database Administrator.

 

                                 Programmer / Analyst                                                                                      9/97 – 5/99

q       Maintained Order Processing and Inventory Management systems for the Rohm & Haas Company.

q       Coding, testing, and implementing upgrades to applications using Cobol 390 and JCL.

q       Helped to institute stringent Quality Assurance standards.

 

1991 – 1997            Protection Services, Inc., Wilmington, DE

                                Foreman

Responsible for project scheduling, inventory control, and supervision of two 6-man teams

covering the entire Delmarva Peninsula. 

Responsibilities included:

q       Coordination of work schedules.

q       New hire training.

q       Reconcile physical inventory.

q       Creating reports documenting above actions using MS Office products.

q       On-Site customer service representative for construction company.

 

1988 – 1994            U.S. Army & Pennsylvania Army National Guard

                                Soldier                                                                                                                   8/88 – 8/94

Promoted to the rank of Corporal (E-4). 

Military Occupational Specialties included:

q       Helicopter mechanic (67U).

q       Infantryman (11B).

 

EDUCATION:

 

Pennsylvania State University

Media, PA            

Currently Enrolled            GPA: 3.97 

CAI Programming Academy

Allentown, PA,                    

1997

U.S. Army Aviation Logistics School

Ft. Eustis, VA                1988 – 1989