DALLAS R. WARD

**** ********** *****, *********, ** 25526

480-***-**** E-mail: abloz1@r.postjobfree.com

SUMMARY OF EXPERIENCE

Analyst, Programmer and Problem Solver, providing solutions to increasingly complex

business problems for over 15 years. Team Leader by example and consensus. Heavy

development, analysis, design, and leadership experience in several industries

(Commercial, Insurance, Government, Telecommunications and Automotive) integrating

iSeries with multiple platforms. Solid on-line and batch expertise in Logistics/Supply

Chain, Billing, Claims and Finance. Excellent verbal and written communication skills.

Enthusiastic Mentor and colleague trainer.

TECHNICAL EXPERTISE

Hardware: ISeries/AS400, Windows PCs

Databases: DB2, UDB (DB2/400)

Languages: SQL/DB2, ILE COBOL/COBOLII, FTP, CL/400

Application Tools: DBU, IFS, PDM/SEU/SDA/RLU, MS Office, UC4, QMF,ROBOT,

journals/debugger, Client Access, Visio, Implementer, Surveyor, Aldon CMS

Prior experience with: IBM 30XX/43XX, ES9000,VM/CMS, MVS/TSO/ISPF, Oracle6/8I,

VSAM, IMS, REXX,JCL,SEQUEL, Xedit, Ditto, Xpediter, ControlM, Librarian, MQ

Series, FlowCharter, Questview, Extra!, Hawkeye, Turnover

PROJECT HISTORY

Wells Fargo Third Party Administrators Analysis/Development 03/09 -- present

• Partnered with several business divisions to promote modernized Health Insurance

eligibility and claims payment processes, as well as compliance reporting.

• Drove investigation of current database for data warehouse, data scrubbing.

• Promulgated performance improvements using SQL Stored Procedures.

• Trained and mentored onshore/offshore colleagues in DB2/SQL, COBOL, ECM.

Mattel Toys Supply Chain/Logistics Systems Analysis 10/06 – 11/08

• Re-engineered broken freight cost reporting from bank through operational database to

General Ledger using COBOL/embedded SQL programs, FTP and CL jobs.

• Launched new internal-user RFID tag sales menu option, creating new DDS GUI, COBOL

drivers and SQL database maintenance on iSeries V5R4.

• Translated Sarbanes-Oxley compliance requirements into monthly management sign-off

report, creating complex DB2 database queries to monitor source code management.

• Originated automated customized DB2 database extracts daily to data warehouses on

other platforms, using SQL and FTP.

• Led team of 5 analysts (onshore and offshore) converting ROBOT job scheduling to UC4

for better CL job control.

• Extricated embedded de-licensed product from over 100 CL jobs, saving $30K annually.

Scottsdale Insurance Co Property/Casualty Database Mining 03/06 – 10/06

• Modernized financial reporting using SEQUEL, COBOL, SQL on ISeries V5R3.

American Suzuki Motor Corp Auto & Motorcycle Analysis/Development 03/05 – 03/06

• Streamlined/upgraded vehicle sales bonus processes, vendor data interfaces using DB2

SQL, ILE COBOL, OS400 V5R3 CL, FTP, data encryption.

LeasePlan USA Auto Lease Project Analysis/Development 09/04 – 02/05

• Integrated complex COBOL/SQL programs into large multi-language project.

CrossPointe Schools Online Supply Chain Database Development 06/04 – 09/04

• Analyzed/developed data warehousing/conversion solutions sold as packages to school

districts nationwide using COBOL/SQL.

Visa USA Debit/Check Card Product Development 02/04 – 05/04

• PLUS Network: Created/upgraded internal and external sales & Product support tools on

AS400, MVS using ILE COBOL, FTP.

I.Levy Associates Development, Analysis 08/03 – 02/04

• Social Security Administration Claims Adjudication/Benefits Authorization: Enhanced and

customized comprehensive claims system according to 30 state agency client requests

using ILE COBOL, queries, subfiles, menus, dynamic SQL and FTP. Intense compliance-

driven environment with tight deadlines.

Sprint Communications Database Development, Analysis 2001-2003

• High Speed Data Provisioning: Developed data warehouse using FTP, ILE COBOL, SQL,

DRDA, subfiles; synchronized DSL/Broadband customer orders, inventory between AS400

and mainframe DB2 databases.

• Inventory/Order Entry: Converted Sprint’s high-volume number/line inventory system from

daily batch to faster real-time on-line updates of millions of transactions through MQ

queues, data queues.

• Performance-tuned DB2 tables, programs using journals, debugger, commitment control.

Blue Cross/Blue Shield Health Care Data Warehousing, Development 2000

• Developed Operational Data Store, feeding vendor claim files from MVS through AS400 to

Unix Oracle warehouse using PowerMHS, ControlM, FTP, Connect:Direct, ILE COBOL,

DB2/400.

American Honda Motor Corp. Auto Distribution Analysis/Development 1998-1999

• Auto Distribution: Created 'Truck Load Make-up' subsystem on AS400 using ILE COBOL,

FTP, subfiles and screens, speeding auto loading/delivery nationwide from factory to

dealers.

• Lead analyst, Motorcycle Distribution/Reporting; enhanced AS/400/MVS FTP data

interface.

Nissan Motor Corporation Auto Parts Distribution Development 1997-1998

• Synchronized parts inventory, warehouse transactions and management reports across 10

AS/400’s nationwide with MVS mainframe via nightly upload using CL, FTP, TELNET.

ADDITIONAL EXPERIENCE

QWEST AS400 COBOL/SQL, Telephone Billing 1997

IBM Global Services MVS/COBOL/DB2, Utility Billing 1996

Anderson Consulting/Accenture AS400 data queues, Lottery 1995-1996

Maricopa County Elections Dept Project Leader, 6 P/As 1993-1995

Arizona Dept of Health Services Programmer, COBOL,VM,Oracle 1992-1993

IBM Programming Lab AS400 Systems Development/Data Recovery 1987-1992

EDUCATION & PROFESSIONAL

B.A., International Relations, University of Minnesota

U.S. Government ANSI COBOL courses

IBM language courses (various)

Member of Mensa

Contact this candidate