SUMMARY:

• AS/400 (iSeries) Developer - responsible for the following:
• RPGIII, RPG400, RPGLE (RPGIV), CL, DSPF, PRTF, CMD, Embedded RPG Developer
• JDE World (A7.3, A9.0, A9.1 & A9.2) Developer
• Double-Byte Conversion
• AS/400 Project Management - responsible for the following:
• Budget control
• Developers hiring
• Business requirements
• Release Documentation
• Technical specifications
• Functional specifications
• Production deployment plan
• Project status and progress control
• Testing and testing data setup (Unit, Functional and UAT)

PROFESSIONAL EXPERIENCE:

Confidential

JDE WorldSoft Consultant

Responsibilities:

• Project Manager of iSeries, AS400, JDE World development.
• Resource Planning.
• Project Budget and Forecast.
• SOX and FDA compliance.
• Senior AS400, JDE(WorldSoft), DCLINK, RPG400, RPGLE (RPGIV), CL, DSPF and PRTF developer.
• Create new Inventory, PO and Warehouse Management Interface between JDE and Web-based application via EDI.
• Modified PO and Receipt Route subfile screen to support the new interface.
• JDE A9.1 support.

Confidential

DBCS/AS/400/JDE A73 to A92 Consultant

Responsibilities:

• Senior RPG400, RPGLE (RPGIV), CL, DSPF and PRTF developer.
• Create new Inventory, Work Order and Shipping system, interface from and to, iSeries/JDE A9.2.
• Modified PO subfile screen to support the new interface.
• JDE A7.3 to A9.2 conversion.

Confidential

DBCS/AS/400 Consultant

Responsibilities:

• iSeries DBCS Advisor.
• SBCS to DBCS project planner.
• Senior RPGIII, RPG400, RPGLE (RPGIV), CL, DSPF and PRTF developer.

Confidential

AS/400 Consultant

Responsibilities:

• Senior RPG400, RPGLE (RPGIV), CL, DSPF and PRTF developer.
• Extract JDE GL history to support web-based reporting system.
• Create title opening on-hand balance for web-based applications.
• Create Title/SKU inventory staging system from JDE Item Ledger.
• Senior RPG400, RPGLE (RPGIV), CL, DSPF and PRTF developer.
• Created Banking (BOA) interface file from JDE World A/P, G/L system.
• Senior AS400 “Time Card and Lawson Payroll System” analyst and developer.
• Senior RPG400, RPGLE (RPGIV), CL, DSPF and PRTF developer.
• Senior AS400/JDE production support and developer.
• Senior RPG400, RPGLE (RPGIV), CL, DSPF and PRTF developer.
• Developer and program analysis of applications such as, WO, Sales Agreement, Options, Commitment, Payments, Rebate, Project Master, Lot Master and Plan Master.
• Developed IFPO (e-commerce/JDE Purchase) system to provide the interface between PC/NT applications and JDE AS400. (PO, GL, AP, Job Cost and WO).
• Developer of both Batch and Interactive (Subfile) processing.
• Attached Housing - created the Attached Housing module within the JDE system to support the multilevel buildings.
• Technical support the custom “Home Builder” system.
• 1099 Year-end process.
• Developer and Technical support for the interface between JDE and Web Applications (Purchase, Vender Master, Pricing, Rebate, Real Estate, Work Order, GL and AP Processing).
• Stored Procedure, Data Studio and ISeries Navigator.

Confidential

Project Manager and Lead Developer

Responsibilities:

• Project Manager/Lead Developer (with a team of 3 programmers) of MKS’s J1C Double-byte (DBCS) conversion project. Software conversions and modifications on Physical files, Logical files, RPGIII, RPG400, RPGLE (RPGIV), CL, CLLE, Display files and Printer files to support Double-Byte (Japanese, Traditional Chinese, Simplified Chinese and Korean) AS400 system.
• Senior RPGIII, RPG400, RPGLE (RPGIV), CL, DSPF and PRTF developer.

Confidential

AS/400 and JDE Consultant

Responsibilities:

• Senior RPG400, RPGLE (RPGIV), CL, DSPF and PRTF developer.
• Supported and modified the custom “Home Builder” system.
• Modified and reported creation of Customer Service application.
• Modified and reported creation or Work Order/Project Stage application.
• Senior AS400/JDE consultant. Support Job Cost, Work Order, and PO and A/P enhancements.
• Modified and reported creation of Home Options application.
• Modified and reported creation of GL and pricing application.
• Developer of both Batch and Interactive (Subfile) processing.

Confidential

System Analyst and Lead Developer

Responsibilities:

• Senior AS/400 consultant. Support distribution, sales, inventory, invoicing and finance applications ran on AS/400.
• Senior RPGIII, RPG400, RPGLE (RPGIV), CL, DSPF and PRTF developer.
• Burton AS/400 and Edge N/T system conversion.
• Maintain Lawson 7.0 Financial (G/L and A/P) for accounting and sales analysis.
• Created AS/400 and Oracle interface through FTP.
• EDI - Bank files transfer. Payment (Check) files transfer between the bank and Lawson’s accounting system.

Confidential

System Analyst and Lead Developer

Responsibilities:

• Worked as Senior System Analyst and Programmer on projects in AS/400 (RPG400, RPGLE, CLP, DDS, SQL, QRY and so on) and JDE World A7.3 (UDC, DD, World Writer, Dream Writer, SVR, Menu, VO and so on.)
• Worked as Business Analyst, worked with users and put together business requirements, functional specifications and technical specifications.
• Integrated a “custom sales order system” into JDE Sales Order, G/L and A/R system.
• E-commerce solution - established interfaces between clients’ web sites and JDE sales order, G/L and A/R systems.
• JDE e-commerce orders entry (Sales Orders).
• G/L and AR/AP Reconciliations.
• Monthly G/L, A/R and A/P accounting closing.
• Performed year-end JDE accounting closing.
• Year-end 1099 processing (e filing).
• JDE and Credit Card system interface.
• JDE and Fax system interface.
• JDE and Telephone system interface.
• Developer of both Batch and Interactive (Subfile) processing.
• AS/400 and JDE system maintenance: Daily, Weekly, Monthly and Annual maintenance.
• Project Manager and Lead Programmer of “MBE/WBE“(Minority and Women Business Enterprise) tracking system, which interface directly with JDE’s Purchasing and Address Book modules.
• JDE System setup and maintenance (Activities Rules, UDC, DD, Menus, System Security, User Security and so on).
• JDE reports generations (WW, DW and FASTR).
• Fix Asset Support.
• Project manager of JDE and Kronos (Time Clock) System Interface.
• MKS, Source Control System for JDE.
• JDE and Infinium HR/Payroll Interface.
• Senior RPG400, RPGLE, CL, DSPF and PRTF developer.

Confidential

Project Manager and Lead Developer

Responsibilities:

• Project Manager (a team of 4 programmers) and Lead Programmer Analyst of LSP and MAP Double-byte (DBCS) conversion project (Full System). Software conversions and modifications on Physical files, Logical files, RPG400, RPGLE (RPGIV), CL, CLLE, Display files and Printer files to support Double-Byte (Japanese, Traditional Chinese, Simplified Chinese and Korean) AS400 system.
• Senior RPG, RPGLE, CL, DSPF and PRTF developer.

Confidential

System Analyst

Responsibilities:

• Worked as Senior System Analyst and Programmer on projects in AS/400 (RPG, CLP, DDS, SQL, QRY and so on) and JDE World V7.3 (UDC, DD, World Writer, Dream Writer, SVR, Menu, VO and so on.)
• Senior RPG, RPGLE, CL, DSPF and PRTF developer.
• Worked as Business Analyst, work with users and put together business requirements, functional specifications and technical specifications.
• Lead Programmer/Analyst on global consolidation of 28 JD Edwards' suites all over the world. Consolidation and globalization included JDE master and supplement files such as: Charter of Accounts, Accounting Master, G/L, Item Master, Address Book, User Define Code, P.O. Master, Company Constants, Accounting Balance, Sales Order, Sales History, Invoicing, VO, Menus and so on.
• Developed JDE interface for e-commerce, data warehouse and decision support system.
• JDE and ShowCase Interface.

Confidential

Project Manager and Lead Developer

Responsibilities:

• Project Manager (a team of 5 programmers) and Lead Programmer Analyst of MAC-PAC Version 11 Double-byte conversion project (Full System). Software conversions and modifications on Physical files, Logical files, RPG, CL, display files and printer files to support Double-Byte (Japanese, Traditional Chinese, Simplified Chinese and Korean) AS400 system.
• Senior RPGIII, RPG400, RPGLE (RPGIV), CL, DSPF and PRTF developer.

Confidential

System Analyst and Lead Developer

Responsibilities:

• Worked as Senior System Analyst and Programmer on projects in AS/400 (RPG400, RPGLE, CLP, DDS, SQL, QRY and so on) and JDE World A7.3 (UDC, DD, World Writer, Dream Writer, SVR, Menu, VO and so on.)
• Worked as Business Analyst, worked with users and put together business requirements, functional specifications and technical specifications.
• Installed JDE World 7.3 software.
• Converted BPCS 4.2 to JDE World 7.3.
• Technical support and software modifications on Sales Order, Product Cost, Item Master, Financial (GL, AR and AP), and Address Book modules.
• Project Manager (a team of 2 programmers) and Lead Programmer Analyst on JDE and Data Warehouse interface: Created two-way data interfaces running between JDE (on AS/400) and Arbor Data Warehouse (on NT client server system).
• Project leader and lead programmer of the “Item Cost system”. Which is interface with both JDE and BPCS, and to calculate the manufacturing costs for each order.
• Provide reports and PC download files from Sales, Accounting and Item Cost systems from JDE and BPCS.
• Fix Asset Support.
• Y2K modifications.
• Perform fiscal year-end accounting closing on both JDE and BPCS systems.
• Senior RPG, RPGLE, CL, DSPF and PRTF developer.
• Developer of both Batch and Interactive (Subfile) processing.

Confidential

Programmer

Responsibilities:

• Member of AS/400 to SAP/HP conversion team, specialized on sales order, general ledger, accounts receivable, accounts payable, inventory and distribution systems.
• Senior RPGIII, RPG400, RPGLE (RPGIV), CL, DSPF and PRTF developer.
• Member of BPCS upgrade and technical support team: software support and modifications on accounts payable, order entry, billing, general accounting and inventory systems.
• Senior RPGIII, RPG400, RPGLE, CL, DSPF and PRTF developer.

Confidential

System Analyst and programmer

Responsibilities:

• System analyst and lead programmer for BPCS developments and implementations.
• Double byte enabling (DBCS) the full BPCS system to support the AS400 running in Japanese, Traditional Chinese, Simplified Chinese and Korean environments.
• Technical support and lead developer on the International releases of BPCS for 11 European, Southern American and Asian languages.
• Senior RPG400, RPGLE, CL, DSPF and PRTF developer.
• Life Insurance application - CAPSUL, system 38 to AS/400 conversion.
• Double enabling the CAPSUL system to support the DBCS AS/400 in Japan and Taiwan.