Joseph Diamond

SENIOR PROGRAMMER/ANALYST
SUMMARY OF QUALIFICATIONS
 Extremely competent AS400 Senior Programmer/Analyst with excellent Business
Systems experience
 Strong background with JD Edwards (ERP) software (6+ years), which includes seve
ral Upgrades and Implementations
 Extensive experience providing leadership and technical expertise for the implem
entation and enhancement of complex information systems
 Strengths include results oriented nature; strong belief in the importance o
f being a team player; willing to do what it takes to get the job done resourcef
ully and successfully
 Heavy RPG (III, IV, Free) AS/400 (iSeries) Development (10+ years). Strong
emphasis on Life Cycle Development, Best Practices, and structured Project Manag
ement Techniques

SELECTED ACHIEVEMENTS

 Designed interview, analysis, and result documents used in a corporate-wide ana
lysis, which contributed to the decision to purchase JD Edwards (JDE) and the AS
/400 system. Gross sales increased from $20 million to over $30 million.
 Successfully led system, data, and application conversions to the AS/400 and JD
Edwards (JDE/Peoplesoft) software.
 Successfully supervised and trained a small staff from entry level to senior lev
el personnel in several different areas: Data Entry, Operations, Programming, an
d Application Analysis.
 Designed, programmed, tested, and implemented applications, consolidating data f
rom multiple platforms and system environments to single reporting and interacti
ve views. This allowed corporate access to vital management and operational inf
ormation.

“I have developed a good solid background in JD Edwards (JDE) software, specifically
in an AS/400 environment. I am thoroughly familiar with various business syste
ms and have had the opportunity to hold several positions of leadership. I have
excellent interpersonal skills and over 10 years of AS400 experience--Immediate
ly Available for Interview.â€

CONTACT INFORMATION
Email: joseph.diamond96@yahoo.com

AS400 (iSeries) SKILLS

 High-Level Languages: RPG III, RPGIV, RPG Free, Embedded SQL/400, CLP, Subfiles,
Subprocedures, ILE, Activation Groups, OP Codes, API, Interactive SQL/400,
SDLC,
DB2/400, Stored Procedures
 System Administration/Operations: OS/400 Upgrades, PTF, Security and Authority,
IPL,
 Backup and Restore, Operational Assistant, iSeries Navigator, IFS, System
Values,
Work Active Jobs (WRKACTJOB), Work System Activity (WRKSYSACT), Job Descriptions
,
Work System Status (WRKSYSSTS), Work Disk Status (WRKDSKSTS), System Values,
Subsystems, Output Queues, Job Queues, Job Logs, Debug Logs, User Profiles, Spoo
l Files
 Toolset/Utilities: DB2/400, Interactive SQL/400, OfficeVision/400, DDS, SDA, RDA
, Open Query File, Query/400, PDM, DBU, FFPLUS, IBM Client/Access, RUMBA, ALDON
(Change Control), DFU, STRISDB (OPM Debugger), STRDBG (ILE Debugger), SEU, FTP (
Automated),
iSeries RDBMS, iSeries Database Schema, Database Mapping
 Third-Party Software: JD Edwards World A7.3 Cume 15, JD Edwards OneWorld XE, ODB
C,
Windows XP, Crystal Reports, MS Access, MS Word, MS Excel, MS Project, MS PowerP
oint, VISIO, EDI Inovis-TrustedLink (ANSI), Track-IT, MS Sharepoint, OLAP, Data
Warehousing,
ROBOT Scheduler, ROBOT Client, VB 4.0, VB 5.0, VB 6.0, VB.Net, OLE, SQL Server 2
000, RFGEN (DataMax Software Group), T-SQL, MS Visual Studio 2008

JD EDWARDS (ERP) SKILLS

 JD Edwards World A7.3 Cume 15: Menu Build, Data Dictionary, Vocabulary Overrides
, UDC Build, DreamWriters, WorldWriters, FASTR, World RPG Programming, Fast Path
, World Security, World CL Programming, SVR, SLEEPER, SDA, RDA, FDA, Z-Files and
Processors, EDI Processing (System “47†), Processing Options, iSeries DB2 RDBMS, JDE In
tegrity Reports
 JD Edwards OneWorld Xe: OMW, UBE, Data Dictionary, Menu Build, OCM, Table Design
, Business View Design, Processing Options, UDC Build, Interoperability, Master
Business Functions, Crystal Reports, SQL, SQL Server 2000 RDBMS, UTB
 JD Edwards Data Model: General Accounting, Address Book, Accounts Payable, Accou
nts Receivable, Forecasting, Shop Floor Control, Purchase Management, Sales Orde
r Management, Inventory Management, Warehouse Management, Equipment Billing, Ord
er-To-Cash, Procure-To-Pay, Supply Chain, Advanced Pricing

SYSTEMS ANALYSIS SKILLS

 Software Engineering: Define phase, Analyze phase, Design phase, Produce phase,
Optimize phase, Implement phase, Manage phase, Action Diagramming, Structure Cha
rts, Top-Down Analysis, Data Modeling (ERD), Unit Test Scripts, System/Integrati
on Test Scripts, Software Project Estimating Tools, User Training, User Document
ation
 Business Analysis: Joint Application Design (JAD), Business/Enterprise Modeling
(DFD), Project Management, Issues Management, GAP Analysis, IBM Business Systems
Planning, Deloitte and Touche Express (Package Implementation) Methodology, Use
r Training, User Documentation, Business Analysis Workshop (BAW), Conference Roo
m Pilot (CRP), Business Process Assessment

PROFESSIONAL ACCOMPLISHMENTS
Papyrus – Fairfield, CA
Industry: Retail/Wholesale
Role: Senior Programmer/Analyst (w. JDE Emphasis)
 Provided daily and end-of-period support for JD Edwards A/P, A/R, and G/L fu
nctions. Developed ad hoc reporting and resolved functional problems as required
. Also supported JD Edwards Procurement and Inventory Management modules, in add
ition to Legacy (custom) Retail system modules and interfaces. Performed 24/7 ap
plication on-call support.
 Technical Lead for the development of a ‘Scan Based Trading (SBT)’ module, whic
egrated seamlessly with JD Edwards Order Processing, Financial, and Inventory mo
dules. The SBT module was integral to the successful management of a multi-mill
ion dollar account with Target Stores nationally.
 Technical Lead for the development of EDI front and back end processes for t
he successful integration of Customer Orders (850 Inbound), Invoices (810 Outbou
nd), ASN (856 Outbound) with JD Edwards World “47†tables within the framework of the Tr
ustedLink-Inovis EDI engine. Participated in the EDI User Definition and Mapping
configuration to the ANSI standard.
 Technical Lead for the successful transition of Papyrus data to the American
Greetings (AG), Inc. systems following the sale of the Papyrus Wholesale busine
ss to AG. Managed the day-to-day technical activities of several Independent Co
ntractors to include Change Management Control, Technical Support, and the initi
al candidate interviews--Efforts integral to the project’s on-time completion and wi
thin predetermined budget requirements.
 Developed and maintained numerous mission-critical custom applications (using RP
G Free, IV and III) to manage and integrate Legacy Retail Systems, and Distribut
ion Center & Store Inventories (178 Stores).
 Developed a batch interface (an automated FTP nightly procedure) with Wells Farg
o to process ACH Transfers—this process helped to ensure timely and correct bank and
G/L account balances.
 Supported end-of-fiscal year external Financial Audit. Provided JD Edwards Fina
ncial data to “PricewaterhouseCoopers†auditors.

Electronic Data Systems (EDS) - San Ramon, CA
Industry: Enterprise Services
Role: Senior Information Specialist (w. JDE Emphasis)
 Employed as a Senior Information Specialist to provide Application and Develo
pment expertise on a project-by-project basis for external EDS clients, as requi
red.
 Project: Provide daily programming, application analysis, and production sup
port services for well-known Toy Distributor/Direct Marketing Retailer.
 Provided daily functional and technical production support, in an AS/400 env
ironment. Rotated 24/7 application on-call support.
 Developed and modified numerous Custom and JDE World application programs in
cluding G/L, A/P, F/A, Inventory, and Procurement.
 Developed automated FTP scripts to interface files via the Internet to outsi
de vendors and customers.
 Daily client-facing and functional support of JDE G/L, A/P, F/A, Inventory M
anagement, Procurement and custom Warehouse Management application.
 Interfaced client’s legacy systems with JDE using ‘Z’ file methodology.
 Prepared program specifications and unit and integration testing scripts.
 Developed a batch interface with an off-shore Canadian Bank to process ACH T
ransfers.
 Helped Controller successfully complete a Repost of G/L and F/A for fiscal y
ear change.
 Coded application solutions with RPGIII, RPGIV and the requisite iSeries utiliti
es.
 Project: JDE OneWorld Implementation expertise for a large Food Producer/Dis
tributor.
 Shared functional/implementation knowledge and expertise with implementation Tea
m Leader on JDE Best Practices and Implementation Strategies.
SDL, Inc. – Santa Clara, CA
Industry: Manufacturing
Role: Technical Consultant for JDE Software Improvement Project
 Engaged as a JDE contract consultant to provide custom program development s
ervices for JDE version A73 in an AS/400 environment.
 Developed and customized a wide-range of interactive, report, and batch upda
te programs (Financials, Sales, Inventory, Purchasing and PDM) using the RPGIII
and RPGIV scripting languages and JDE software best practices.
 Conducted user training. Prepared user documentation. Implemented applicatio
n changes across multiple JDE object environments.

Coastal Unilube, Inc. – Memphis, TN

Industry: Retail/Manufacturing
Role: Technical Consultant for JDE Software Improvement Project
 Engaged as a JDE contract developer to provide custom program development se
rvices for a JDE A8.1 application improvement project. Conducted interviews to g
ather programming requirements.
 Developed a wide-range of interactive, report, and batch update programs (
Financials, Sales, Inventory, Advanced Pricing, Purchasing and Manufacturing mod
ules) using RPGIII and RPGIV; and the JDE CASE driven toolset.
 Created several Sales and Profitability Analysis Reports for both Regional a
nd Territorial Managers to improve sales performance tracking.
 Developed a custom Daily Labor Cost Efficiency Report for Plant Managers to
improve performance tracking of the supervisors under their direct control.

Siemens Oncology Care Systems – Concord, CA

Industry: Manufacturing
Role: Technical Consultant for JDE Software Upgrade Project
 Engaged as a JDE contract consultant for an A6 to A73 upgrade project.
 Reengineered mission critical custom A6 interactive, report, and batch updat
e programs (Financials, Purchasing, PDM, and Manufacturing modules) to A73 appli
cation standards using the RPGIII and RPGIV languages; the JDE World toolset, an
d the AS/400.
 Implemented application changes across multiple JDE object environments.

Norcal Waste Systems, Inc. – San Francisco, CA

Industry: Waste Management
Role: Technical Consultant for JDE Software Implementation Project
 Engaged as a contract consultant to perform all assigned JDE data conversion
and custom programming activities. This included actively soliciting necessary
Norcal MIS support and Subject Matter Experts to understand data mapping require
ments from old data structures, validating detailed data mapping conversion deci
sions, and obtaining Norcal MIS signoffs.
 Developed interfaces, enhancements, and conversions using the RPGIII and RPG
IV scripting languages, and JDE “Z†file conversion methodology, in an AS400 environment
. Responsible for Address Book, A/R, A/P, G/L, and Chart of Accounts. Develope
d custom reports.
 Led Norcal technical resources in the installation of JDE software, provided
skills transfer, and answered installation questions.
 Provided Go Live and Post-Implementation support.
 Utilized Microsoft Project to plan, coordinate, and manage project activitie
s.

Supercuts – San Francisco, CA

Industry: Retail / Wholesale
Role: Technical Consultant for JDE Software Improvement Project
 Engaged as contract consultant to provide professional programming services
for the JDE Financial and Distribution modules in an AS400 environment.
 Gathered specifications and developed interfaces from a custom Co-operative
Advertising application to JDE Financials using RPGIII scripting language.
 Developed custom interactive and batch applications from detailed specificat
ions using AS400 subfile technology, and custom JDE DreamWriters. Conducted unit
and integration testing. Prepared User Documentation. Conducted User Training.
 Provided application and implementation support across multiple JDE environm
ents.
 Utilized Microsoft Project to plan, coordinate, and manage project activitie
s.

State Bar of California – San Francisco, CA

Industry: Legal
Role: Technical Consultant for JDE Software Enhancement Project
 Served as contract consultant to deliver specialized programming services fo
r JDE World A6 Financial applications and non-JDE (Legacy) applications in an AS
400 environment.
 Developed custom interactive and batch applications from detailed specificat
ions using AS400 subfile technology, RPGIII and RPGIV; and custom JDE DreamWrite
rs. Conducted unit and integration testing. Prepared User Documentation. Conduc
ted User Training.
 Provided application and implementation support across multiple JDE environm
ents.
 Provided daily production support for JDE A/R, A/P, and G/L applications.
 Designed and developed a custom report used to project short-term cash inflo
ws resulting from payments on account balances due.
 Utilized Microsoft Project to plan, coordinate, and manage project activitie
s.

Diversified Contract Services – Oakland, CA

Industry: Federal Government
Role: Senior Programmer/Analyst (JDE Implementation and Management)
 Employed as a Senior Programmer/Analyst to provide AS400 hardware/software ex
pertise and daily production support.
 Project tasked with the implementation of JD Edwards World A73, specializing
in, Sales Order Processing, Purchase Order Processing, Inventory Management, an
d Financials.
 Completed Common & Detailed Design which included: interviewing key personne
l, analyzing as-is processes, gathering report requirements and business transac
tions, analyzing gap requirements, and compiling Business process Information (B
PI).
 Assimilated all JDE configuration decisions into a permanent Enterprise Mode
l.
 Completed knowledge transfer and documentation for the system at project com
pletion.
 Setup and tested objects in the Development, Test, and Production environmen
ts.
 Developed end-user security requirements to manage batch and menu control.
 Updated and maintained the Enterprise Model, Process Flow, and Business Desi
gn documentation.
 Analyzed conversion requirements between legacy system and JDE for Open Sale
s Orders, Open Purchase Orders, Vendor Master, Customer Master, Address Book, Cu
stomer and Vendor Item Cross Reference, Base Price, and Cost.
Used JDE “Z†file methodology to map and integrate data into the JD Edwards database.
 Responsible for issue resolution, end user-support, and software enhancement
s to improve business processes. Software enhancements performed using native A
S400 RPG scripting language.
 Project tasked with client/server development of an AS/400 Report Download U
tility for JDE Financial and Sales data.
 Using Visual Basic 4.0, the process downloads an AS/400 spool file to an Exc
el spreadsheet and runs an Excel macro over the downloaded data. The process im
proved the financial budgeting and the sales analysis/projection activities.
 Utilized Microsoft Project to plan, coordinate, and manage project activitie
s.
 Extensive SDLC (System Development Life Cycle) and RPG III coding for JD Edw
ards enhancements and custom modules.

EMPLOYMENT HISTORY
 (7/07 – 5/10) Papyrus – Fairfield, CA
Industry: Retail/Wholesale
Role: Senior Programmer/Analyst (w. JDE Emphasis)
 (1/06 – 11/06) DataMax Software Group – El Dorado Hills, CA
Industry: Data Collection Software
Role: Technical/Functional Consultant for JDE Integration and Analysis
 (1/02 – 1/06) Electronic Data Systems (EDS) - San Ramon, CA
Industry: Enterprise Services
Role: Senior Information Specialist (w. JDE Emphasis)
 (9/00 – 10/01) Deloitte and Touche – San Francisco, CA
Industry: Big 5 Consulting
Role: Functional Consultant for JDE Software Implementation and Configurat
ion
 (11/99 – 6/00) SDL, Inc. – Santa Clara, CA
Industry: Manufacturing
Role: Technical Consultant for JDE Software Improvement Project
 (7/99 – 10/99) Coastal Unilube, Inc. – Memphis, TN
Industry: Retail/Manufacturing
Role: Technical Consultant for JDE Software Improvement Project
 (3/99 – 6/99) Catholic Healthcare West – Oakland, CA
Industry: Healthcare
Role: Functional Consultant for JDE Software Y2K Readiness Project
 (10/98 – 3/99) Siemens Oncology Care Systems – Concord, CA
Industry: Manufacturing
Role: Technical Consultant for JDE Software Upgrade Project
 (1/98 – 10/98) Galoob Toys, Inc. – San Francisco, CA & Kowloon Bay, Hong Kong
Industry: Manufacturing
Role: Functional Consultant for JDE Software Implementation Project
 (1/97 – 1/98) Norcal Waste Systems, Inc. – San Francisco, CA
Industry: Waste Management
Role: Technical Consultant for JDE Software Implementation Project
 (6/97 – 10/97) XL Connect – San Mateo, CA
Industry: Professional Services
Role: Technical Consultant for JDE Software Upgrade Project
 (10/96 – 2/97) Supercuts – San Francisco, CA
Industry: Retail
Role: Technical Consultant for JDE Software Improvement Project
 (2/96 – 9/96) State Bar of California – San Francisco, CA
Industry: Legal
Role: Technical Consultant for JDE Software Enhancement Project
 (1992 – 1996) Diversified Contract Services – Oakland, CA
Industry: Federal Government
Role: Senior Programmer/Analyst (JDE Implementation and Management)

EDUCATION
B.S. Studies, Information Systems Management, University of San Francisco
A.S. Degree, Accounting, City College of San Francisco

MILITARY SERVICE
United States Army, Air Defense Artillery
Federal Republic of Germany (3/7th ADA)

CERTIFICATIONS
Inventory Management & Control Systems Certification, United States Army (German
y)
CMMI Level 3 Certification, Electronic Data Systems (EDS)
Software Security Awareness Certification, EDS
Business Analysis, Requirements Definition and Testing Techniques Certification,
EDS
Technical Foundation, JD Edwards World
Common Foundation, JD Edwards OneWorld
CNC Foundation, JD Edwards OneWorld

AFFILIATIONS
JDELIST User Group (JD Edwards)
QUEST International User Group (JD Edwards)
MC Press Online (AS/400 – iSeries – RPG)
Lab400 (AS/400 – iSeries – RPG)
TimeShare400.Com (AS/400 – iSeries – RPG)
APICS (ERP – SCM Educational Resource)
MGI Management Institute (SCM Educational Resource)

PROFESSIONAL TRAINING
JD Edwards Application Training
 General Ledger
 Accounts Payable
 Inventory Management
 Advanced Pricing
 Advanced Warehousing
 Sales Order
 Purchase Order
 Shop Floor Control
 JDE) Application Data Models
 JD Edwards OneWorld XE: Object Management Workbench (OMW), A. Jacot and K. Jacot
 JD Edwards World Software: An Administrator’s Guide, Panza and Edelstein
 Implementing JD Edwards OneWorld, Starinsky
 JD Edwards OneWorld: A Developer’s Guide, Hester and Enyeart
 JD Edwards OneWorld: The Complete Reference, J. Miller, J. Stern, A. Jacot, M. J
acot
MGI Management Institute Web-Based (APICS Certification) Training
 Basics of Supply Chain Management
o Introduction to Supply Chain Management
o Material Requirements Planning
o Master Planning
o Forecasting
o Inventory Fundamentals
o Inventory Management
o ABC Classification and Physical Distribution
o Capacity Management and Production Activity Control
o Quality Management and Purchasing
o Just-in-Time Manufacturing
EDS University Web-Based Training
 PM2 (Project Management Version 2) - EDS
 SLC3 (Systems Lifecycle Methodology Version 3) – EDS
 Customer Relationship Management (CRM)
 Supply Chain Management
 Data Modeling (ERDs)
 Object Oriented Design/Programming
 AS/400 Information Engineering, John Porter
 SLC Application Testing Techniques
 VBScript
 JAVA (J2SE/JDK)
 JAVASCRIPT
 Visual Basic.Net
 ADO
 HTML
 SLC3 Testing (Software) Techniques and Documents – Part 1 and 2
 CMMI Level 3