Project Sales

Joseph Diamond

[pic]

JD EDWARDS APPLICATION SPECIALIST

SUMMARY OF QUALIFICATIONS

Extremely competent JD Edwards Application Specialist/Developer

with excellent Business Systems knowledge and experience

Strong Technical/Functional background with JD Edwards (a.k.a. JDE)

ERP software, which includes several Upgrades, Implementations and day-to-

day Production Support

> 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

> Extensive experience in designing and/or developing databases, queries

and reports needed by end users and/or management teams

> Ability to use SQL to drill down into a relational database structure and

identify trends and patterns

> Ability to present and communicate Data Analysis findings in a clear,

concise and effective manner to all levels of a business organization

> Ability to devise creative solutions to complex mission-critical business

problems

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 ERP Software,

Application Programming/Scripting, and Addressing Client-Customer Needs

specifically in DB2 and SQL Server environments. 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

immediately available for interview."

CONTACT INFORMATION

Email: abhjns@r.postjobfree.com

Location: San Francisco Bay Area - U.S.A.

SOFTWARE / SKILLS

Business/Data Analysis Tools: Data Collection and Analysis, SDLC,

VISIO, ERD, DFD, Data and Business Modeling, Joint Application Design

(JAD), GAP Analysis, Business Process Reengineering

Developer Programming Languages: RPG (IV, III, ILE), CLP, CLLE,

Visual Basic, VBA, DB2, SQL, ODBC, ADO, COM, Event Rules, T-SQL, HTML,

XML, SQL Server 2000 DTS

Developer Tools: Standard IBM AS400-DB2 and JDE proprietary

development tools, Microsoft(Project, Excel, Word, PowerPoint), DBU,

Client/Access, Microsoft Access, Front Page Express

Reporting Tools: DreamWriter, World Writer, MS Access, Crystal

Reports for Visual Basic 4.6.1.0, Query/400

General Business/Data Systems Knowledge: Inventory Management,

Sales Order, Purchase Order, G/L, A/P, A/R, F/A, Advanced Pricing,

Advanced Warehousing, Shop Floor Control, Work Order, Bill of Material,

Product Data Management (PDM), RDBMS

Consulting: Coaching/Mentoring, Customer Interaction, Interviewing,

Requirements Gathering, Data Analysis, Problem Resolution, User Training,

Testing, Training Plans, Gap Analysis, Implementation, Go Live and Post-

Go Live Support, Black Box Testing

Industry Expertise: High-Tech, Distribution, Retail, Government,

Professional Services, Outsourcing, Consulting, Manufacturing

EMPLOYMENT HISTORY

Papyrus - Fairfield, CA

7/07 - 5/10

Industry: Retail/Wholesale

Role: Technical/Functional Analyst (w. ERP 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.

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, Data Integration/Transformation, 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.

DataMax Software Group - El Dorado Hills, CA

1/06 - 11/06

Industry: Data Collection Software

Role: Technical/Functional Consultant for JDE Integration and Analysis

A Software Development Firm which produces and markets a Radio

Frequency-Automated Data Collection package known as RFGEN.

Responsible for client-facing, as well as, Visual Basic, and SQL

coding for the RFGEN-JD Edwards (World and EnterpriseOne) "ERP

Integrator."

Produced RFGEN-JDE OneWorld scripts using the proprietary DataMax

"ERP Integrator", OneWorld Master Business Functions (MBF), Visual

Basic, and SQL.

Produced RFGEN-JDE World scripts using the proprietary DataMax

Screen-Mapping process, Visual Basic, and SQL.

Prepared time and material estimates in response to customer

generated Request for Proposals (RFP's). Conducted product

demonstrations using WEBEX for on-shore and off-shore

customers/prospects (Pre-Sales).

Managed projects using MS Project and AutoTask (a web-based

Project Management and Customer Relationship Management (CRM) tool).

Prepared JD Edwards test scripts for Oracle-RFGEN Certification

for JDE World and JDE EnterpriseOne. Test scripts prepared for

Inventory: Transfer, Issue, Adjustment, Reclass, and Cycle counts;

Advanced Warehousing: Putaway, Pick and Replenishment Confirmation;

Kanban: Check-in, Check-out; Purchase Order Receipt; Sales Order Ship

Confirmation; Work Order: Completions, Issues, Component Scrap, and

Time Entry; Equipment and Plant Maintenance.

Successfully implemented RFGEN for a large Food and Agribusiness

Corporation in Idaho following an onsite Business Analysis Workshop,

an estimate of Time and Materials for the project, and scripting the

RFGEN-JD Edwards Integrator to meet the client's unique data and

process Oneworld XE needs.

Electronic Data Systems (EDS) - San Ramon, CA

1/02 - 1/06

Industry: Professional Services/Outsourcer

Role: Technical/Functional Consultant for JDE Configuration and Enhancement

Employed as an Internal JDE consultant to provide Application

expertise on a project-by-project basis, as required.

Project: Provide daily programming, application/data analysis, and

production support services for well-known Toy Distributor/Direct

Marketing Retailer.

Provided daily functional and technical production support, in an

IBM AS/400-DB2 environment.

Developed and modified numerous 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 (data mapping) 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 Visual Basic

scripting.

Project: Provide OneWorld development services for a Food

Manufacturer on an IBM AS/400-DB2 machine.

Enhanced existing OneWorld forms using FDA. Enhanced existing

reports (UBEs) using RDA. Performed object check-in and out for PD,

PY, DV environments using OMW.

Deloitte and Touche - San Francisco,

CA 9/00 - 10/01

Industry: Big 5 Consulting

Role: Functional Consultant for JDE Software Implementation and

Configuration

Employed as an Internal JDE Functional consultant to provide

Implementation expertise on a project-by-project basis, as required.

Project tasked with implementing JD Edwards OneWorld XE Advanced

Warehousing module for a large Food/Canning Manufacturer.

Conducted interviews to gather client business/data requirements.

Configured application setup to demonstrate findings to client's

Subject Matter Expert (SME).

Led integrated Conference Room Pilot (CRP) for Advanced Warehouse

system implementation.

Prepared GAP analysis. Compiled and documented client's

specialized reporting needs.

Produced and presented solutions within the framework of

Deloitte's Express Methodology.

Interfaced Advanced Warehousing with JDE Sales Order, Purchase

Order Receipts, Manufacturing, and Advanced Transportation.

Prepared Go Live and Post-Implementation plan.

Project tasked with conducting a JD Edwards World A73 Business

Process Assessment for a popular Health-Energy Bar

manufacturer/distributor.

Conducted interviews to gather client requirements.

Compared client's JDE usage with JD Edwards (JDE) best practices.

Presented findings and solutions to the client via a PowerPoint

demonstration and a proprietary Deloitte JDE Assessment Report.

Helped client improve JDE Financial, and Forecasting systems.

Client adopted proposed solutions, which led to $350,000.00 of

new business for Deloitte.

SDL, Inc. - Santa Clara, CA

11/99 - 6/00

Industry: Manufacturing

Role: Technical Consultant for Software Enhancement Project

Engaged as a JDE contract consultant to provide custom program

development and data analysis services for JDE version A73 in an IBM

AS/400-DB2 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

7/99 - 10/99

Industry: Retail/Manufacturing

Role: Technical Consultant for Software Enhancement Project

Engaged as a JDE contract developer to provide custom program

development and data analysis 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.

Catholic Healthcare West - Oakland,

CA 3/99 -

6/99

Industry: Healthcare

Role: Functional Consultant for Software Y2K Readiness Project

Served as contract consultant for a Y2K Readiness testing project

for JDE World A73 A/R, A/P, and G/L modules, in an IBM AS/400-DB2

environment.

Planned and developed test cases and scripts using the Catholic

Healthcare West Y2K testing methodology (limited to date-related

functionality).

Trained application testers. Provided application testers with

test cases and scripts.

Identified and tracked defects using SofFront defect tracking

database. Escalated unresolved issues and/or defects.

Generated final test reports. Generated final status reporting and

notification of completion.

Siemens Oncology Care Systems - Concord,

CA 10/98 - 3/99

Industry: Manufacturing

Role: Technical Consultant for 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

scripting languages, the JDE World toolset, and the IBM AS/400-DB2.

Implemented application changes across multiple JDE object

environments.

Galoob Toys, Inc. - San Francisco, CA & Kowloon Bay, Hong

Kong 1/98

-10/98

Industry: Manufacturing

Role: Functional Consultant for Software Implementation Project

Engaged as a contract consultant to implement Inventory Management,

Sales Order, Advanced Pricing, and Purchase Order modules for the JDE

OneWorld B73 software system in an IBM AS/400-DB2 environment. Mult-site

implementation for US and Hong Kong.

Led Business Process Review (BPR) sessions to gather, define, and

document 'As Is' business processes from assigned Business Process

Owners.

Actively coached Business Process Owners helping them adapt

existing business practices to the JDE OneWorld software for their

business area.

Configured JDE OneWorld to include, Address Book, UDCs, AAIs,

Processing Options, G/L Class Codes, Category Codes, and Item-

Branch/Plant Master. Cross-functional collaboration with other JDE

Consultants to address process overlap and dependency issues.

Helped Business Process Owners plan and prepare for mini-CRP for

their business area.

Documented key business and configuration decisions made as part of

the preparation for the mini-CRP (the 'To Be' part of the BPRs).

Actively coached Business Process Owners, Technical Writers, and

team members in the planning, and preparation needed to conduct a

successful integrated CRP.

Monitored and supported MIS data conversion and interface testing.

This included responding to requests for JDE data table formats and

relationships, confirmation of implications of data mapping decisions,

and final validation of data conversion results (loaded JDE data tables).

Monitored and supported Go Live testing. This included data

conversion support, advice on sequencing data conversion activities,

timing and performance implications of JDE data table loading during Go

Live testing and rehearsals.

Provided Go Live and Post-Implementation support as required.

Enhanced existing OneWorld forms using FDA. Enhanced existing

management reports using RDA (report design aid).

Utilized the Object Librarian to manage object 'check-in' and

'check-out' for PD, PY, and DV environments.

Utilized Microsoft Project to plan, coordinate, and manage project

activities.

Norcal Waste Systems, Inc. - San Francisco,

CA 1/97 - 1/98

Industry: Waste Management

Role: Technical Consultant for 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 IBM AS400-DB2 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.

XL Connect - San Mateo,

CA

6/97 - 10/97

Industry: Professional Services

Role: Technical Consultant for Software Upgrade Project

Served as a contract consultant to lead JD Edwards A6 to A73 full

release upgrade project for an XL Connect Manufacturing client. Project

included the JDE Financial, Distribution, and Manufacturing verticals.

Created and managed project plan, schedules, and timelines using

Microsoft Project.

Created a multi-environment upgrade plan using the JDE Upgrade

Planner utility on AS/400.

Performed file conversions and control file merges to alternate

upgrade environment.

Carried out the rebuild of Data Dictionary, Vocabulary Overrides,

DreamWriter, Field Reference Files, and build of Join Logical Files.

Applied AS/400 PTF's as required.

Reengineered A6 custom modifications to A73 standards using RPGIII

and JDE Toolset.

Supervised and participated in the testing of upgraded and

reengineered applications in the alternate environment. Upgraded

Production environment using upgraded Alternate.

Trained the Trainers on software net changes. Provided Go-Live and

Post Go-Live support.

Utilized Microsoft Project to plan, coordinate, and manage project

activities.

Supercuts - San Francisco,

CA

10/96 - 2/97

Industry: Retail

Role: Technical Consultant for Software Enhancement Project

Engaged as contract consultant to provide professional programming

services for the JDE Financial and Distribution modules in an IBM AS400-

DB2 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 2/96 -

9/96

Industry: Legal

Role: Technical Consultant for Software Enhancement Project

Served as contract consultant to deliver specialized programming

services for JDE World A6 Financial applications and non-JDE applications

in an IBM AS400-DB2 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

1992 - 1996

Industry: Defense

Role: Technical/Functional Consultant for Software Implementation and

Management

Employed as an Internal Functional Consultant and Project Manager to

provide IBM AS400-DB2 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 data 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.

EDUCATION

B.S. Studies, Information Systems Management, University of San Francisco

A.S.Degree, Accounting, City College of San Francisco

CERTIFICATIONS

Inventory Management & Control Systems Certification, United States Army

(Germany)

CMMI Level 3 Certification, Electronic Data Systems (EDS)

Software Security Awareness Certification, EDS University

Business/Data Analysis, Requirements Definition and Testing Techniques

Certification, EDS University

Technical Foundation, JD Edwards World (ERP)

Common Foundation, JD Edwards OneWorld (ERP)

CNC Foundation, JD Edwards OneWorld (ERP)

Contact this candidate