Frank Z. Fan

*** ******* **** **, ********, PA 19446 835-***-**** (C) adxe15@r.postjobfree.com

OBJECTIVE JDE Programmer

EDUCATION UNIVERSITY OF TEXAS AT ARLINGTON, Arlington TX MIS 05/94, Advanced Study Certificate in

Finance, 1996

EXPERIENCE

06/14- – J&J Snack Food Corporation, Pennsauken, NJ, E910 and E920

Senior JDE Developer

· Total 400+ OMW projects accomplished, Complete mile stones including a Custom Work Order Scheduler, a JJSF

MRP process, a complete PO Entry and Approval systems, 3 major Product Management (including Warehouse and

Shop Floor),JJSF Multilevel BOM setting and implementation for MIA.

· Work closely with Business & Operations across all modules and users to identify opportunities to leverage technology

to drive efficiencies and provide key productivity improvements. Team up with BI Publishers team and help for XML

data structure (P95600), and help for configuration of Orchestration processes, such as PO Approval automation

· Work closely with management to understand and prioritize business goals and information needs to develop the

business spec for OMW programming, testing and implementation.

· Routine support Warehouse and Inventory Management for Manufacturing, Sales, Procurement and Transfers, help to

configurate JJSF DMAAI for product management and accounting.

· Developer Major JDE Custom application with and/or Power Forms, Custom MRP Processing P583415 and R583415X,

Manufacturing Performance P553111B/C/D, Backflush and BOM Distribution with Finished Goods (P564801A)

Application, Inventory Summary Application (P5541006), J&J Sales Summary with Account Integrity (P554216),

PO Entry P4310 (Retrofit from E910), PO Approval with Custom Settings (in Cloud Environment), J&J Warehouse

Management Systems (P5541215) Custom Sales App (with Retrofit from E910, P4210), JJ Blanket PO and

Release(P553412) PO Inquiry (P554210) PO Delivery Detail Schedule (P554316A)

· Developer Major UBE and Batch programs Item Part List with Cost Ledger (R554105A), Inventory Balance and

Cardex Ledger R554111B PO Print (R5543500) Sales Summary by GL Period (P554219) Inventory Summary

(R5541006) Consolidated Inventory by B/P (R5541CONS) Purchase Order List by Vendor (R554312A) Warehouse

Item Expiration Date (R554126) Slow Moving and Obsolete (R5541006O); Item BOM for MIA UOMs (P553125A/

R553125), Sales Shipping Detail by Date (R5542125) Commission Report (R584216), Custom BOL/Custom Pack Slip

(R554205A) Custom Receive Register (R5541115)

· Custom/Debug and Developer major C business Functions Sales Master Business Functions B4210XX Package;

Purchase Master Business Functions XT4311ZX Packages; DSI Interface Business Functions (NER Categories); JJSF

Cloud Interface Business Functions; Custom and Retrofit C business Functions in E920, ALL in updated MS C++

VS Environment

10/07 – 5/14 – First Quality Inc, King of Prussia, PA

System Analyst IV (JD Edwards EnterpriseOne 9.0)

· Over 300 E1 Pristine/Custom programs updated/developed. Worked with major modules\suites include: Sales

\Distribution\Logistics\Manufacturing\EDI\Finance(AR\AP\GL\Purch\Inv Mgmt\Shop Floor\MRP\DRP\Work Force

MGMT, etc. Major applications include: Sales Order Entry(P4210), Shipment(P4205), CRM Customer

Profile(P5503010) ; EDI Inbound R47011 with Price Variances App(P554711A\B\C)Pricing Management

(P5541015); BOL(P5542002)Check Price\Avail(P4074) Employee Master(P0801\EMP\ORG); FQ Tech File

MGMT(P5501020); CIM(P5542007\9\11, P5542010); Sales Ord Appointment(P5542006); Base Price Rev(P4106);

Personal/Dep/Bene Info(P054201); Auto PMT Grp(P04571\P04572); Msg Detail (P3411); PO Entry (P4310); PO

Approval(P43025); PO Rec (P4312); Prod Rpt (P554806B); FQ Consolidated E1-OTM Inter-Driver; AP Manual

PMT(P0413M); AP Void PMT(P0413V); Std Prod Run Rate(P554801); Vendor Audit (P01012/P04012);

· Cust Label Maintenance (P5503500); AP Check Print (R04572N); Purchasing\Inventory Module Batch Program:

Item Cross Ref (R5541022); Base Price

Conversion (TC – R5541520) and R554106; Manufacturing\Shop Floor Module: Work Order/w Raw

Materials (R5548015); Non wovens Item (R5541012); Financial Module:

Customer Label Conversion (R5503500) etc.(Total 20 Programs)

Major Tabe Triggers:

· EnterpriseOne Training – On-going Training provided for 3 Junior programmers in E1 Foundation;

Development Tools; OMW Tools; FDA/RDA/TC; C-code and NER; Debugging Tools. Web-Tools in E1

(Form Design); Master Business functions; DD and Error Messages; Media Object;

· Research and develop enhancements standards (text documentation/template update standard/Version override

9/06 – 9/07 Unique Industries, Inc. Philadelphia, PA

JDE Applications Developer (B7334 Xe)

· Application custom and support (FDA/RDA) (Custom 11 APPLs and 5 UBEs): Cycle Count program

(P41413); EDI Programs (R47xxx); Item Availability (P41202); Manufacturing Work Order (P48013); Credit

Check (P42050);Print Variance Detail (R41013); Stock Status (R41530);Print Pick Slips (R42520); Receipt

Journal (R03B311); Message Summary (P3401);

· Report and batch program (RDA): EDI Pre-edit; Cost Analysis; Daily Out of Stock; Daily Backorders;

Inventory Forecast by Week; SQ/RMA Cancellation; Daily Order by Currency; All Open Back Orders;

Inventory Adjust; Open Order by Due Date;

· Interface Programs (TC) (Create/custom 30 batches): MRP Analysis and Export; Customer and Invoice

Export; WMS Daily Sales into Sales Detail; RSOE Sales Journal;

· Business Functions (C/C++): Custom about 20 BFSN and update ESU:B3400170; B4301030;

B4500250/X3111T/X4801T, etc.

1/03 – 8/06 Franklin Electronic Publishers, Inc. Burlington, NJ

JDE Developer

· Maintain all Financial\Distribution\Manufacturing UBEs/APPLs; Re-write major master business functions

which is used by company-wide management; Developed a very successful new design to replace

previous PwC programs; Write major enterprise executive reports; Create major Sales/Inventory forecasts ;

· Create/maintain FEP Warehouse/Shipping System interface; replace initial manual bar-code scanning

process with automated streamline programs which process/print Pick/Pack Slip/BOL in sub-systems;

· Technical support to CNC/ESU and retro-fit/trouble-shooting system-upgraded problems; Custom/reformat

Financial reports for end-user within Tabular spec to meet industry standard; modifying related functions;

· EDI Support in major in/out bound programs; new partner date mapping/settings; ASN configurations; Write

Table Conversion to Prescient Forecast & EDI interoperability tables; Developed APPL interface

to fix/updated current transportation/inventory tracking system to reflect new workflow;

· Routine support in package builds; menus; scheduled jobs; security settings; partially end-user support;

· Debugging all JDE and custom programs with C++ and write/custom C business functions;

1/01 – 12/02 Business Oriented Software Solutions, Inc.

Sr. Systems Analyst

Tyco Fire & Building Products Project, (Lansdale, PA, 1/01 – 1/03)

· Report writing for Manufacturing\Financial\Distribution Modules; trouble-shooting client-generated

UBE reports; Custom UBE and Interactive APPL(Warehouse/Shop Floor/Work Center/Inventory, etc);

· EDI Support (both inbound and outbound) for on-line Sales/Purchase and Z process to JDE systems;

· Provide daily support for all JDE system related UBEs and help desk tickets and inquiries.

· Create C business functions or calling JDE API as needed; Analysis/update/error-purge data source

to maintain integrity; create Error report/log attachment for system audit;

Com-NetEricsson Project, Lynchburg, VA, 11/00 – 01/01

· Financial\Distribution Report writing; write checking program to verify and correct data error

and update database; Write conversion and interface program between OW and other

applications; Migrate client non-JDE reports to JDE applications;

· Technical support for all UBE\TC related issue for junior developers; debug\test programs;

PCI Project, Philadelphia, PA, 2/00 – 9/00

· Analysis, design and implementation Interactive Financial/Distribution applications; data conversions

and develop interactive/batch applications and enterprise reports; Write custom program from JDE

World to OneWorld; Create new user-defined interface; Write\debug JDE Business Functions with

NER/C++;

· Build system package; Test and debug programs and UBEs; Data conversion from World AS\400

and Imaginera to OneWorld (AR,AP & GL); Migrate Cardinal Medical HR, ADP and Financial System

to new JD Edwards interface.

3/99-12/00 Perot Systems, Inc, Dallas, Texas,

Associate (JDE Consultant) (One fully-implementation from World to OneWorld B733.1)

Upper Deck of California project, Carlsbad, CA 4/00 – 11/00

· Technical training for Xe Tools\Application\UBE in design, testing, debugging (with VC++);

Coordinate with other functional, technical associates and end users to integrate JDE packages;

· Re-define the new interface for A/R systems and custom APPL to meet user’s specific business

· On-line help-desk nationwide support and provide technical solutions for web-based applications;

· Write Table Conversion and interface program between OW and third applications SQL,BPICS;

Design and coding business rules into UBE and APPL to stream-line client’s integrated workflow;

· Provide seminar\real-time support to junior developers and responsible for final sign-off;

Laboratories Service Project Fort Worth, TX 11/99 – 3/00

· Data conversion from JDE World to OneWorld. Other conversion for historic data from HP to

costumed JDE tables;

· Re-define the new interface for A/R systems and custom APPL to meet user’s specific business

need; convert all Financial reports from RPG based version into OneWorld ER-based versions.

· Debug system interface and write business function (C and C++). Batch process company global

branches transactions with a costumed EDI programs (Distribution Module).

Diamond of California Project, Stockton, CA, 3/99 – 10/99

· UBE Report trouble-shootings. Complete major Financial reports validation with company’s historic

reports. Create data mapping and cross-reference file for management audit

· Create batch application to validate system integrity. Data purging for those wrongly processed GL

batches into Account Balance and related system database. Create Error Reports for auditing.

· Coach end-users and client’s IT personnel for technical foundations and JDE architecture.

10/96-2/99 Nenstiel Technologies, Inc, Denver, Colorado

OneWorld Developer (One fully-implementation from Platinum to OneWorld B733.1)

AMR Project, Denver, CO, 7/98 – 2/99

· Design and implementation of initial data mapping, intensively coding in SQL and generate

normal foreign data source; Setup OCM, ODBC and system configuration

· Pre-conversion client demonstration of Database\Applications\Interfaces; write SQL for client,

analyze data and purge error\duplicate records; write\debug conversion programs for Finance;

· Create cross-reference tables, custom default UBE batch programs as needed; debug

applications; update OneWorld tables for AB, HR\Payroll; ;

Safeskin Project, San Diego, CA, 2/98 – 6/98

· Analyze and write systems programs for major Financial Modules (A/R, A/P FA and GL);

Database conversion from JD Edwards World to OneWorld systems;

· Write custom program; Build and deploy ERP package to end users; write SQL and EDI conversion

programs for internet transaction and E-commerce.

Bison Group Project, Dallas, TX, 4/97 – 1/98

· Trouble-shooting Interactive application developed by previous JDE consulting company (Sales,

Inventory, and UDC forms); Create audit UBE to purge bad data; write integrity report between major

Modules and tables (GL with sales, Sales-update with Batch J/E);

· Upgrade all client major reports from AS/400 system to OneWorld; User-support and tech training.

conversion programs for internet transaction and E-commerce.

Energy Alloys Project, Houston, TX, 10/96 – 3/97

· Custom JDE canned UBE and versions; Create new Forms for all department (PO Form, Bill

of Lading, Pick Slip, Receiver, Invoice Reprint, Check Print (re-write), RMA forms, AR Aging

Write 35 custom reports for Finance, Distribution and Manufacture;

· Technical support for conversion from AS/400 and client-developed database; write all mapping

spec and RDBS design, write conversion programs for different input format into JDE systems;

6/94 -9/96 SEMATECH, Inc. Austin, Texas (A multinational High-tech Company)

Application Developer

· JD Edwards technical support in automated account J/E, monthly closing; write\audit

periodic financial report; data integrity\warehouse; write SQL for financial models, data flow

and batch J\Es; update financial reports from WorldWriter\FASTR to UBE batch programs.

· Migrate multidimensional corporate software APIs and create universal user-interface for

organization-wide access (SEMATECH Project Management Systems \ Navigation Systems)

· Support/coordinate with IT to define issues/solutions of financial systems; develop ad hoc

applications with VB5.0\MS Access 2.0&7.0; Maintain 180 Oracle (financial portion) tables

and all MS Access database

SKILLS

· Software: JD Edwards ERP Toolset; C\C++ (Enterprise Edition of Console and Project for Debugging and development C functions in MS Visual Studio) (JD Edward API and Function Source code); Java 2;Crystal Report Tool 8.5 to XI; MS XML; Knowledge with IBM Websphere ; Visual Basic (4.0&5.0) PowerBuilder 5.0; MS SQL Server (6.5/7.0) and Oracle Financial, knowledge on RPG IV and BPICS. MS Access; AS/400 SQL; Oracle Financial; Working knowledge in Java and Python and associated database access; JDE E9.0, E910 and E920, the most updated knowledge in OMW Development ; Build Eone Pages, knowledge BI Publishers, Very knowledgeable in JDE Orchestrator,AIS and UDO architecture, working experience for PO automation using Orchestrator Studio

· Hardware: advanced skills in SQL and relational database AS/400, OneWorld and CITRIX Servers. Windows 98/2000,

NT and Unix operating systems, Platinum SQL, Monarch, IBM Client Access; iSeries Navigator; HP;

Contact this candidate