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 several Upgrades and Implementations

 Extensive experience providing leadership and technical expertise for the implementation and enhancement of complex information systems

 Strengths include results oriented nature; strong belief in the importance of being a team player; willing to do what it takes to get the job done resourcefully and successfully

 Heavy RPG (III, IV, Free) AS/400 (iSeries) Development (10+ years). Strong emphasis on Life Cycle Development, Best Practices, and structured Project Management Techniques

SELECTED ACHIEVEMENTS

 Designed interview, analysis, and result documents used in a corporate-wide analysis, 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 level personnel in several different areas: Data Entry, Operations, Programming, and Application Analysis.

 Designed, programmed, tested, and implemented applications, consolidating data from multiple platforms and system environments to single reporting and interactive views. This allowed corporate access to vital management and operational information.

“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 systems and have had the opportunity to hold several positions of leadership. I have excellent interpersonal skills and over 10 years of AS400 experience--Immediately Available for Interview.”

CONTACT INFORMATION

Email: jyqnq4@r.postjobfree.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, Spool 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, ODBC,

Windows XP, Crystal Reports, MS Access, MS Word, MS Excel, MS Project, MS PowerPoint, 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 2000, 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 Integrity 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, Accounts Receivable, Forecasting, Shop Floor Control, Purchase Management, Sales Order Management, Inventory Management, Warehouse Management, Equipment Billing, Order-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 Charts, Top-Down Analysis, Data Modeling (ERD), Unit Test Scripts, System/Integration Test Scripts, Software Project Estimating Tools, User Training, User Documentation

 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, User Training, User Documentation, Business Analysis Workshop (BAW), Conference Room Pilot (CRP), Business Process Assessment

RELEVANT PROFESSIONAL EXPERIENCE

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 functions. Developed ad hoc reporting and resolved functional problems as required. Also supported JD Edwards Procurement and Inventory Management modules, in addition to Legacy (custom) Retail system modules and interfaces. Performed 24/7 application on-call support.

 Technical Lead for the development of a ‘Scan Based Trading (SBT)’ module, which integrated seamlessly with JD Edwards Order Processing, Financial, and Inventory modules. The SBT module was integral to the successful management of a multi-million dollar account with Target Stores nationally.

 Technical Lead for the development of EDI front and back end processes for the successful integration of Customer Orders (850 Inbound), Invoices (810 Outbound), ASN (856 Outbound) with JD Edwards World “47” tables within the framework of the TrustedLink-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 business to AG. Managed the day-to-day technical activities of several Independent Contractors to include Change Management Control, Technical Support, and the initial candidate interviews--Efforts integral to the project’s on-time completion and within predetermined budget requirements.

 Developed and maintained numerous mission-critical custom applications (using RPG Free, IV and III) to manage and integrate Legacy Retail Systems, and Distribution Center & Store Inventories (178 Stores).

 Developed a batch interface (an automated FTP nightly procedure) with Wells Fargo 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 Financial 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 Development expertise on a project-by-project basis for external EDS clients, as required.

 Project: Provide daily programming, application analysis, and production support services for well-known Toy Distributor/Direct Marketing Retailer.

 Provided daily functional and technical production support, in an AS/400 environment. Rotated 24/7 application on-call support.

 Developed and modified numerous Custom and JDE World application programs including G/L, A/P, F/A, Inventory, and Procurement.

 Developed automated FTP scripts to interface files via the Internet to outside vendors and customers.

 Daily client-facing and functional support of JDE G/L, A/P, F/A, Inventory Management, 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 Transfers.

 Helped Controller successfully complete a Repost of G/L and F/A for fiscal year change.

 Coded application solutions with RPGIII, RPGIV and the requisite iSeries utilities.

 Project: JDE OneWorld Implementation expertise for a large Food Producer/Distributor.

 Shared functional/implementation knowledge and expertise with implementation Team 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 services for JDE version A73 in an AS/400 environment.

 Developed and customized a wide-range of interactive, report, and batch update 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 application 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 services for a JDE A8.1 application improvement project. Conducted interviews to gather programming requirements.

 Developed a wide-range of interactive, report, and batch update programs ( Financials, Sales, Inventory, Advanced Pricing, Purchasing and Manufacturing modules) using RPGIII and RPGIV; and the JDE CASE driven toolset.

 Created several Sales and Profitability Analysis Reports for both Regional and 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 update programs (Financials, Purchasing, PDM, and Manufacturing modules) to A73 application standards using the RPGIII and RPGIV languages; the JDE World toolset, and 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 requirements from old data structures, validating detailed data mapping conversion decisions, and obtaining Norcal MIS signoffs.

 Developed interfaces, enhancements, and conversions using the RPGIII and RPGIV 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. Developed 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 activities.

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 specifications 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 environments.

 Utilized Microsoft Project to plan, coordinate, and manage project activities.

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 for JDE World A6 Financial applications and non-JDE (Legacy) applications in an AS400 environment.

 Developed custom interactive and batch applications from detailed specifications using AS400 subfile technology, RPGIII and RPGIV; and custom JDE DreamWriters. Conducted unit and integration testing. Prepared User Documentation. Conducted User Training.

 Provided application and implementation support across multiple JDE environments.

 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 inflows resulting from payments on account balances due.

 Utilized Microsoft Project to plan, coordinate, and manage project activities.

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 expertise and daily production support.

 Project tasked with the implementation of JD Edwards World A73, specializing in, Sales Order Processing, Purchase Order Processing, Inventory Management, and Financials.

 Completed Common & Detailed Design which included: interviewing key personnel, analyzing as-is processes, gathering report requirements and business transactions, analyzing gap requirements, and compiling Business process Information (BPI).

 Assimilated all JDE configuration decisions into a permanent Enterprise Model.

 Completed knowledge transfer and documentation for the system at project completion.

 Setup and tested objects in the Development, Test, and Production environments.

 Developed end-user security requirements to manage batch and menu control.

 Updated and maintained the Enterprise Model, Process Flow, and Business Design documentation.

 Analyzed conversion requirements between legacy system and JDE for Open Sales Orders, Open Purchase Orders, Vendor Master, Customer Master, Address Book, Customer 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 enhancements to improve business processes. Software enhancements performed using native AS400 RPG scripting language.

 Project tasked with client/server development of an AS/400 Report Download Utility for JDE Financial and Sales data.

 Using Visual Basic 4.0, the process downloads an AS/400 spool file to an Excel spreadsheet and runs an Excel macro over the downloaded data. The process improved the financial budgeting and the sales analysis/projection activities.

 Utilized Microsoft Project to plan, coordinate, and manage project activities.

 Extensive SDLC (System Development Life Cycle) and RPG III coding for JD Edwards 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 Configuration

 (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 (Germany)

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. Jacot

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

Contact this candidate