James W. Orr

**** ********* *********

Murfreesboro, Tennessee 37130

615-***-****

SKILL SUMMARY:

Software Development Experience

RPGIV with embedded SQL, RPG III, RPG II, CL/400, SQL/400, Query/400,

Lansa, Cobol 74 & 85, Turnover, Aldon, Robot, Paperview, Softmenu, Acom,

EzPrint, TL Ashford, FTP Scripting, DBU, Questview, Ezview, and Strfeu.

Application Software Experience

BPCS, PRMS, Infinium, CBS Banking Software, JDE World, ASI Inventory,,

Microsoft Office.

Hardware Experience

IBM AS/400, S/38, S/36, S/34, S/32, Digital DEC-VAX, Hewlett Packard

3000, Wang VS

EXPERIENCE:

Mars Petcare US, Inc. March 2008 to July 2010

Contracted Systems Analyst/Applications Development Lead

. Managed SDLC process for the last major implementation.

. Developed technical designs based on business requirements.

. Designed PRMS product special pricing matrix system.

. Designed a deduction management system for accounts receivable.

. Designed a trade spend system to track and issue payment of

promotional sales expenses.

. Designed a delivery system for A/R invoicing and credit/debit memo

that included paper, fax, EDI and email.

. Designed interfaces and templates for storage of all accounts

receivable documents into Optidoc document retrieval system.

. Designed an off-line parallel MRP process for PRMS that can run will

users are active.

. Designed and developed all accounts receivable conversion programs

during the acquisition of two companies.

. Designed and developed startup inventory load into PRMS physical

inventory module based on an external data import.

. Designed and developed automated purchase order creation based on PRMS

MRP suggestions with EDI interfaces.

. Designed and developed interfaces between multiple inventory systems.

. Designed and developed Screen Field Level Security with dynamic field

attribute control.

. Designed and developed new prompt screens for PRMS master files with

positional SQL logic.

. Designed and developed a "pro-forma" invoice process to generate

invoices prior to shipment for international orders.

. Designed and developed a purchase order purge system that prompts for

date range and percentage received over multi-company member system.

. Developed an interface to upload the actual consumption of component

inventory for produced finished goods that created variance

adjustments to inventory and GL entries.

. All application development controlled with Aldon change management

software.

. Managed 4 developers on my team.

. Developed testing scripts for all development with my area of

responsibility.

. RPGVI with embedded SQL & CL

Cinram Wireless, Inc. Jul 2007 to Jan 2008

Contracted Project Leader

. PRMS company startup.

. Project lead for operational dashboard systems presented with traditional

green screen and web applications. Both applications used common data

retrieval modules that were developed and maintained on the AS400. All

dashboards are multilingual, allow filtering and sorting of screen

information and create extracts of selected data to be emailed to the

user in Microsoft and PDF formats.

. Project lead for order processing. Designed "real-time" materials and

capacity availability modules for PRMS order release.

. Developed multilingual screen design that is used corporate wide with

maintenance screens.

. Developed "call stack" program to allow recursive calls to the same

program.

. Created conceptual, technical and user documentation for all development.

. Performed all technical interviews for new IT programming personnel.

. RPG IV with embedded SQL & CL.

Frontier Communications, Inc./Berean Group, Inc. Feb 2007 to

Jul 2007

Contracted Senior Programmer/Analyst

. Oracle to Infinium Conversion

. Developed data conversion programs for the payables ledger system files

with balancing reports for auditing.

. Developed data conversion programs for the vendor master files with

balancing reports for auditing.

. Developed data conversion programs for payroll and human resources

history with balancing reports for auditing.

. Developed ACH interface for payroll with the ability to view, print,

download to Excel, transmit and re-transmit batches. Options to view

transmission log files.

. Developed disability insurance interface.

. RPG IV with embedded SQL & CL.

Porsche A.G./Oxford International, Inc.

Aug 2006 to Feb 2007

Contracted Senior Programmer/Analyst

. Italy Importer Startup.

. Rewrote all interactive data retrieval modules using RPGLE with imbedded

SQL to replace the existing

. Lansa modules for all vehicle systems user screens.

. Created prompting windows for all screen fields that have associated

master files to be used in new data retrieval screens.

. RPG ILE with embedded SQL, CL & Lansa.

Cinram, Inc. Apr 2005 to Aug 2006

Senior Programmer/Analyst

. Developed DVD Returns Presort Forecast System.

. Developed DVD Direct to Retail Production Operational Dashboard.

. Developed RF Warehousing Tasking Processor.

. Developed RF Warehousing Cycle Counting System.

. Developed DVD Returns Reconciliation System.

. Developed DVD Fulfillment/Shipping Operational Dashboard.

. Developed package labeling system to interface with directed putaway

systems using conveyor systems.

. Enhancements and maintenance to existing PRMS modules.

. AS/400 Security Administrator. Setup new users for our two facilities

(4000 employees) and maintained library/file security.

. Assisted in SOX implementation.

. Promoted software changes and development to the production environments.

. RPG ILE with embedded SQL, RPGIV, CL and FTP scripting.

Porsche A.G./Oxford International, Inc Feb 2004 to Apr 2005

Contracted Senior Programmer/Analyst

. Developed Vehicle Allocations Reporting using Lansa.

. Development team member on Porsche Germany Importer Implementation.

. Developed Vehicles Forecasting System using Lansa.

. Developed Vehicles Interface Programs using Lansa.

. RPGIV, CL & Lansa.

Infilco Degremont, Inc./VT and Associates Feb 2003 to Feb 2004

Contracted Senior Programmer/Analyst

. Developed a CAD drawing inventory system to monitor shipment and approval

of project drawings.

. Developed a contract cost forecast module to track project expenses for

JD Edwards.

. Developed a bill of materials module with data supplied from a PC

application and interfaced it to the JD Edwards purchasing module.

. Developed a commission system for contract and parts sales.

. Developed a utility to send and receive files between the AS/400 and

their NT servers.

. RPG/LE with imbedded SQL.

Universal Studios/Partners Consulting, Inc. Nov 2001 to Aug 2002

Contracted Senior Programmer/Analyst

. Created and implemented a sales forecasting system for new title

releases. This gave visibility to the accounting department to accrue

production costs prior to the release of new films and visibility to the

planning department to forecast projected sales. This system included

accounting, planning & "what if" scenario forecasts.

. RPG/ILE with imbedded SQL, CL & Cobol

Porsche A.G./Oxford International, Inc. Jul 1998 to Nov 2001

Contracted Senior Programmer/Analyst

. Enhanced and maintained the Vehicle Production Systems, Warranty Systems,

Service Systems and

. Customer Tracking Systems, all written in Lansa.

. Maintained and installed periodic releases of Infinium to include: GL,

PL, AR, AP, HR & PY.

. Enhanced and maintained ASI Inventory Systems used for vehicle parts

inventory. Included an interfaced WarehousePRO PC Inventory System for

bar-coded inventory movement & shipping. Also involved writing data

conversion programs on-site for the initial loading of data to

WarehousePRO.

. Developed a master date conversion program to be used globally in all

programs for Y2K.

. Globally converted all programs to be Y2K compliant.

. Manned first line support of worldwide support desk for Porsche World

Systems.

. Developed automated FTP system to send and receive files from outside

vendors using Lansa.

. Developed conversion programs to move data from Infinium to SAP/R3.

. Developed conversion programs to move data from Infinium to Ceridian

Payroll Software.

. Developed interface programs from all legacy systems to SAP/R3 FI/CO.

. Developed Vehicle Event Matrix System to control proper sequencing of

transactions to the Vehicle Production Systems using Lansa.

. Porsche World Systems are multi-lingual, multi-currency & double-byte

capable. Required programming code in dynamic variables for reports and

screens.

. All programming and bug fixes were completed under strict approval

processes with 4 business analysts that required setup of test

environments for testing of all modifications of code.

A checkout system is used for all source code changes along with strict

programming standards.

. Setup all overnight processes in Robot & Robot/Client.

. Maintained Softlanding Softmenu and security for all users of Porsche

World Systems.

. Maintained Paperview optical storage of all designated reports. Required

mapping reports and setting up distribution lists of users.

. Developed extract programs to supply inventory, warranty & customer

information to outside vendors using Lansa. Programs were used with the

FTP system to automatically transmit and receive data.

. Production Support 24/7 with beeper.

. Production environments have many files that contain 5+ million records,

so efficient structured coding was essential for optimum performance.

. RPG ILE with embedded SQL, Lansa, RPGIV, CL & FTP scripting.

Rug Doctor, Inc./AS400 Personnel Agency. Feb 1997 to

Jul 1998

Contracted Senior Programmer/Analyst

. Enhanced and maintained BPCS 4.2 modules to include: Order Entry,

Accounts Receivable, Accounts Payable, General Ledger, Inventory, Bill of

Materials, Shop Floor Control, MRP, Capacity Planning & Sales Reporting.

. Developed an invoicing and statement system with automated reporting.

. Converted all program sources to RPGLE and setup service programs with

bindery directory.

. Installed and setup Gentrans EDI for customer payments.

. Developed sales reporting system with a complete suite of reports.

. Resolved balancing issues between accounting systems.

. Installed and setup ADP software for payroll and created extracts for

401k plan providers.

. Developed a customer inventory tracking system for floor samples.

. RPGIV & CL.

Infinity Consulting

Contracted Senior Programmer/Analyst May 1996 to Feb 1997

Converted banking data from 22 Wells Fargo branches that were purchased by

Tri-Counties Bank in Chico into CBS software. The data included customer

account cross-reference, deposits and loans.

Converted banking data from 9 competitor branches that were purchased by

Tri-Counties Bank in Chico into CBS software. The data included customer

account cross-reference and deposits.

Implemented CBS banking software at Cedars Bank in Los Angeles. All data

was manually entered into CBS. I created an automated spool file

accumulation from nightly reports into a text file that was loaded into a

network database for adhoc reporting. I modified all CBS spool files to

accommodate the bank's forms with their wording.

RPGIV & CL

Fiserv, Inc.

Senior Programmer Analyst Dec 1995 to May 1996

Created secure and separate data environments for the 9 banks that were

resident on a shared AS400 using authority lists by group user profiles.

Converted and implemented 2 banks to CBS software.

Developed a tape backup system for onsite and offsite storage.

Installed quarterly releases of CBS banking software.

RPGIV, Cobol & CL

Regency Bank Jan 1995 to Dec 1995

Senior Programmer/Analyst

. Developed a general ledger reporting system.

. Maintained and installed quarterly releases of CBS banking software.

This required retrofitting all modifications to the new release in a

separate environment for user approval.

. Developed automated extracts of banking data to Novell 4.0 server for

Crystal Reports.

. 24/7 Production Support

. Setup communications devices and terminals for new bank branches.

. RPGIV & CL.

EDUCATION:

Fresno City College - Introduction to Data Processing, Cobol Programming,

Advanced Cobol Programming

Skills Dynamics / IBM, Costa Mesa, Ca - RPGIV Programming, RPGIV

Concepts, RPGIV Subfile Programming, RPGIV Advanced Topics

Reno Community College - RPG ILE Programming

MILITARY SERVICE

U. S. Coast Guard

Honorably Discharged, 1984

Contact this candidate