Sales System

Rick J. Cunliffe

Huntington Beach, CA 714-***-****

****@***-*****.*** http://www.ibm-as400.com

OBJECTIVE:

Experienced Independent Consultant seeking Information Technology position

to manage, design, develop and implement projects using the System

Development Life Cycle.

WORK EXPERIENCE:

JXP Solutions, Inc. (Aerospace Manufacturer)

2009 to Present

Consultant

Developed a VB.Net program to convert a SQL Server based payroll system to

Kronos Timekeeper system on an i-Series. Created an RPGLE program to

convert BPCS Shop Floor Labor / Time & Attendance to Kronos. Designed and

developed an RPGLE union dues system to calculate, maintain, report and

build a .CSV file for FTPing to ADP. Developed Kronos ADP Payroll

interface report. Created a BPCS Shop Order Release/Maintenance program to

interface into Kronos Work Order database. Coded a VB.Net program to

interface SQL Server Shop Floor Operation hand backs into the i-Series

along with a i-Series report of this data. Created a Kronos to BPCS Labor

Interface program allowing Kronos Shop Floor time punches to update BPCS

Labor files. Developed several BPCS MRP Labor Analysis / Cost Center

reports.

Hardware: i-Series 820 Software BPCS, Kronos, ILE RPG, RPG Free,

Embedded SQL,VB/ASP.Net

Toshiba America Information Systems, Inc.

Consultant

2003 to 2010

Created packing list program for warehouse management using custom logos

for many of Toshiba's customers including Home Depot, K-Mart and Sears.

Developed programs for handheld Teklogix RF scanners to allow bar code

scanning of PO Receiving information for stocking warehouse lots/locations.

Created Just In Time inventory replenishment system that allowed warehouse

personnel to quickly pick parts and provide substitution part locations

when the original part wasn't available. Developed monitor programs to

interface Sales Order information into the Automated Warehouse System from

Oracle using webMethods as the EAI. Responsible for production support for

Toshiba's Automated Warehouse System (IBM), Varsity Logistics and Mac Pac

Order Management systems. Developed Functional and Technical Designs for

Oracle ERP system conversions and interfaces in accordance with Accenture

Consulting's specifications. Managed the production setup for Oracle

interface environments for all divisions of the company. Developed utility

programs for file conversions and mass file seeding. Extensive use of

embedded SQL in ILE/RPG. Developed embedded FTP ILE/RPG scripting programs

for transmitting and receiving data to/from clients host servers.

Developed a Warranty Entitlement system with FTP to EDS/e-Claim for laptop

warranty claims. Developed a bar coded system to allow the harvesting of

laptop computer components for use as repair parts. Developed a Visual

Studio VB project integrating Oracle Pricing files into custom Excel Price

List and Price Protection worksheets that are automatically e-mailed to

Toshiba's channel partners. Created a VB.Net program to extract Price/Cost

information from an Excel worksheet and populates price/costs on the i-

Series

Hardware: Three I-Series 850's Software ILE RPG, Embedded SQL, FTP,

Robot, Silvon Implementer

Drive Financial Services

Consultant

2001 to 2003

Improved the Report Distribution system to allow archiving and retrieval of

previous daily and month end spooled reports using an IBM 3995 optical

storage drive. Developed a Vehicle Sales Analysis system in ASNA Visual

RPG to track the Sales, Expenses and Recovery Amounts on sold repossessed

vehicles. Implemented a Vehicle Inventory Analysis system in ASNA Visual

RPG to track the progress of repossessed vehicles prior to sale.

Hardware: Two I-Series 820's Software: ILE

RPG, ASNA Visual RPG

Toshiba America Information Systems, Inc.

Consultant

1993 to 2001

Developed a WIP (Work In Process) Tracking system and Quality Data

Collection system to control production lines for the manufacturing process

of laptop computers. This system produces barcoded labels that are then

scanned using hand held RF terminals to track each step of the PC's

production and shipment. Designed and coded a Sales and Inventory tracking

system allowing Sales Reps through out the country to dial in and enter

customer information. Integrated the Premenos EDI transactions into the

Sales Tracking system. Developed RMA (Return Materials Authorization)

programs to automate customer returns via EDI. Implemented a Purchasing,

Sales and Inventory system used to track and forecast Purchases and

Manufacturing requirements for twelve months into the future. This

improvement supported production planning orders sent to Tokyo, Japan.

Applications are integrated into Mac-Pac and have been developed in AS/SET,

RPG/400 and ILE RPG.

Hardware: Three AS/400's E70's Software: MAC-PAC, RPG/400, ILE RPG,

AS/SET, Premenos EDI

CAPP Care

Consultant

1992 to 1993

Consulted to CAPP Care, a national health care provider network, supporting

a federal government sponsored project to improve system performance of a

Medicare billing analysis system.

Hardware: AS/400 Models E60 and B45

Software: RPG/400, CL

IBM Corporation

Consultant

1991 to 1992

Worked as a consultant to IBM to analyze their client's (Nissan/Infiniti),

Dealer Information System. Recommended and programmed performance

improvements to the system. Gained invaluable knowledge of IBM performance

techniques while working with IBM system engineers.

Hardware: AS/400 Model D50 and D20

Software: RPG/400, CL

Toshiba America Information Systems

Consultant 1991 to 1992

Consulted to Toshiba to design and code a Shop Floor Control subsystem

integrated into Arthur Andersen's MAC-PAC Manufacturing software for

Toshiba's Toner manufacturing division. The subsystem was written in

AS/SET, a 4th GL Case Tool.

Hardware: AS/400 Three E70's Software: MAC-

PAC, AS/SET,RPG/400

Toshiba America Medical Systems

Consultant

1989 to 1991

Provided contract programming services to Toshiba assisting in the

implementation of BPCS (Business Planning Control System) manufacturing and

distribution software. Responsibilities included modifications to BPCS

Inventory Control, Billing Systems and Order Entry Systems. Developed a

system to display exploded Bill of Materials to allow tracking of serial

numbers. Developed Sales Forecasting and Parts Shortage systems based on

BPCS database. Hardware: AS/400

Software: BPCS,

RPG/400

Optimum Software

Contract Programmer

1989 to 1990

Provided contract programming services, developing loan application systems

for this facilities management corporation. TOPA Thrift and Loan was one

of several savings and loan customers of Optimum Software.

Hardware: System 36

Software: RPG II 1/2

AWR II, Inc. (Del Taco/Naugles) Sr.

Programmer Analyst

1988 to 1989

Responsible for AS/400 migration from a System 38 for the following

systems: Financial Operating Statements, G/L, Payroll, A/P, Investment

Services, K1 Tax Processing and PC related systems. Project Leader for

several projects managing four programmers. Converted Naugles G/L system

on an S/36 to Computer Associates General Ledger package on the AS/400.

Designed and developed a new Operating Statements system that reflected the

consolidation of the Del Taco/Naugles restaurant chain merger. Maintained

all System 36 Systems.

Hardware: AS/400, S/38, S/36, PC's Software:

C/A, COBOL/400, RPG/400

All Valley Acceptance Corporation

Sr. Programmer Analyst

1988

Developed interface programs to use uploaded PC files to update J.D.

Edwards Accounts Receivable and General Ledger Files. Developed

Repossession Tracking and Force Placed Insurance systems.

Hardware: S/38, PC's Software: J.D.

Edwards, RPG III

FEDCO Incorporated Sr.

Programmer Analyst

1987 to 1988

Responsible for new development and maintenance of the Purchasing, Accounts

Payable, Rebate and Allowance Receivable systems. Maintained all

Merchandising related systems. Designed and programmed Inventory Control

system for POS.

Hardware: Three System 38's Software: RPG

III, CL

Melling Tool Company Sr.

Programmer Analyst

1985 to 1987

Designed and coded front end and post processing programs for MAPICS.

Designed and developed programs to convert MAPICS files to BPCS

Manufacturing and Distribution software format. Developed and implemented

a Competitor Cross Reference and Price Comparison, a Trucking Control

System and an Interactive Parts Catalog with options for downloading to

diskette for typesetting.

Hardware: S/36, PC's Software: MAPICS,

BPCS, RPG II 1/2, OCL

County of Jackson, Michigan Sr.

Programmer Analyst

1981 to 1985

Converted the county's System 3-15/D to a System 38 with seven remote

sites. Assisted in the configuration and addressing of 65 remote and local

devices. Designed and coded a Circuit Court Tracking System on-line to the

Court using an IBM Series 1 for remote communications. Responsible for

programming of Property Tax and Accounts Receivable and all court related

systems. Implemented a time accounting package to allow billing of actual

computer usage to user department budgets.

Hardware: S/38, S/3-15/D, PC's Software: RPG

II, RPG III, OCL, CL

City of Jackson, Michigan

Acting Director of D.P.

1979 to 1981

Served as the acting Director of Data Processing, supervising five

employees and responsible for balancing a $300,000 budget. Converted a

remote job entry system (IBM 370-158) to an IBM System 34 with three remote

communication sites. Coded and maintained Payroll/Personnel system, A/P,

A/R, G/L, Budgetary system, Property Tax and Parking and Court Accounting

systems.

Hardware: IBM 370-158, S/34 Software: COBOL,

RPG, OS JCL

W.A. Foote Memorial Hospital

Programmer 1977 to 1979

Designed and developed a Medical Record system containing patient admission

information to replace a manual index system. Modification and conversion

to a new computer system included Accounts Receivable, Budget Statistics

and Inpatient Billing systems.

Hardware: NCR Criterion 8500 Software:

COBOL, RPG, Neat/3

EDUCATION:

ASNA Visual RPG ASNA Headquarters San Antonio, TX

Java Programming Saddleback College Irvine

Manufacturing Inventory Control Lansing Community College

IBM System 38 and Various AS400 Courses IBM Lansing, Michigan

Jackson Community College Associates Degree in Arts and

Science - Data Processing

Contact this candidate