Rpg Edwards

SUMMARY

Business/Technical Analyst with ** years of experience in maximizing the utilization of business software for Manufacturing, Retail and Service-related industries using JD Edwards/PS One World ERP Software.

EXPERIENCE

Worked as Delivery Coordinator, Systems Architect, Project lead, Team leader for small to large project assignments in agile environments.

More than Fifteen years of Software Lead Experience in ERP using JD Edwards World (A7.1, A7.3, A8.1) One World (B733, B7332), One World Xe (B7333), People Soft Enterprise One (8.10/8.11/8.12), E900/E910/E912 and AS/400 systems.

Expertise in both Technical and Functional aspects of Financials (G/L, G/A, A/P, A/R, Fixed Assets, Modelling and Budgeting, Multi Currency, Address Book), Sales and Distribution & Logistics (Sales Order Management, PO, Inventory and Warehouse Management, Procurement, Supply Chain, Advance transportation), HR-Payroll, Manufacturing (Shop Floor Management, Forecasting, Work Orders, CSMS) modules.

Extensive experience in JDE One World Xe tools - Object Librarian (OL), Object Management Workbench (OMW), Enterprise Report Writer (ERW), Business View Design Aid (BDA), Report Design Aid (RDA), Form Design Aid (FDA), Object Configuration Manager (OCM), User Defined Codes (UDC), Universal Table Browser (UTB), Universal Batch Engine (UBE), Table Conversion Utility (TCU), Menu Design and Debugging tools with including ER & Visual C++ Debugger.

Extensive experience in Order to Cash (OTC), Order Processing Systems (OPS), Procure to Pay (PTP)

Expertise in Analysis, Design, Develop and Test Commercial and Business applications using AS/400 with RPGIII, RPG/400, RPGILE, CL/400, SQL/400 and DB2/400

Developed maps for 810(Invoice out bound), 820-PaymentOrder/Remittance Advice (Outbound) 850(Purchase Order), 855(P.O Acknowledgement), 856(Advance Ship Notice), 862, 867, 869(Order status report –Inbound), 870(Order status Report-Outbound, 997-Functional Acknowledgment (both inbound and outbound) transactions in EDI sub-system Innovis Trusted Link Ev5, Gentran EDI X12, EAI, Gentran Server for Windows NT to Interface with JD Edwards ERP OW Xe and ERP 8.10/ 8.11 applications

Innovative, resourceful, enthusiastic and Project oriented team player with good communication and interpersonal skills.

J.D Edwards One World Report Design – Masters Level Certification from Brainbench.com

EMPLOYMENT HISTORY

JDE Integration Architect Sept’2017-April’2021 Project: Ariba-JDE Client: Conduent Inc, Florham Park, NJ

Responsibilities

Managerial: Leadership, Negotiation, Conflict Mediation, Requirements gathering, Stake Holder Identification, Scheduling, operation Development, and Team Motivation.

Project Management: Agile Methodologies (Scrum), Global Delivery Model, Team lead and functional Analyst for Ariba to JDE Integration architecture for P2P module.

Worked with Deloitte Offshore 12-member team in fast paced Implementation.

Developed Functional and Technical specifications for cloud based Ariba – JDE Integrations.

Data Migration/Solution developer JDE-ARIBA Implementation.

Involved in day-to-day requests, use & business cases, problem solving.

JDE Application development framework, well versed with JSON REST/SOAP APIs

Environment: JD E1, SQL Server, AWS, SAP Business Objects 4.0, Crystal Reports 2011, SAP Ariba 4.1, SSIS

Sr. JDE Functional Lead August’ 2007 – Aug’2017

Project: GPS/OTC Client: Volvo Information Technology, Chesapeake, VA

Responsibilities

Technical Project Manager with Lead Analyst with team of 4 developers and a Tester.

Developed maps for 810(Invoice out bound), 850(Purchase Order), 855(P.O Acknowledgement), 856(Advance Ship Notice), 862, 867, 869(Order status report –Inbound), 870(Order status Report-Outbound, 997-Functional Acknowledgment (both inbound and outbound) transactions to Interface with JD Edwards ERP 910 applications

Data Migration/Solution developer for Order To Cash project (OTC) and Procure to Pay (PTP)

Brazil implementation.

Involved in integration of purchasing systems [GPS (“Mainframe”) /EDI with JDE Enterprise one].

Designed/developed functional and technical specs and implemented as per SOX guidelines.

Currently maintain the Volvo Penta Finance/Purchasing/Manufacturing/Sales-Distribution modules.

Point of contact for support issues in Manufacturing (BOM, Routing, MRP, Supplier Schedules, Product costing).

Maintain Volvo Penta Supplier Self Service/customer Purchasing/Sales-Distribution EDI daily transactions/issues.

Involved in day-to-day incidents/requests, business cases, problem solving.

Environment: JD Edwards Enterprise One E812/E900/E910 (Tools Release 9.1.2), JDE E1 810 (Tools Release 8.96), VC++, SQL plus, OS/400, EDI X12, SQL Server 6.5, Windows XP, Web sphere 6.0, AIX (Unix), SAP Business Objects 4.0, Crystal Reports 2011, RFSmart 4.6

Team Lead / JDE Analyst April’ 2015 – Nov’2016

Project: ArlonOne Client: Rogers Corporation, Bear, DE

Responsibilities

Data Migration/Solution developer for JDE to People Soft Conversion.

Currently maintain the Arlon JDE System and business requests from A/R, A/P, Manufacturing, Sales teams.

Involved in day-to-day incidents/requests, business cases, problem solving and business reporting using Crystal reports.

Environment: JD Edwards Enterprise One E810/ JDE E1 810 (Tools Release 8.96), VC++, SQL plus, OS/400, EDI X12, SQL Server 6.5, Windows XP, Web sphere 6.0, AIX (Unix), BI Publisher 4.0, Crystal Reports 2011, RFSmart 4.6

Sr. JDE/EDI Analyst May’ 2006 – Aug’2007

Project: SAS Phase2 Client: PSS World Medical, Jacksonville, FL

Responsibilities

Involved in EDI implementation of UCS EDI transaction sets (810, 850, 855, 856 and 860).

Working in JDE One World implementation of Purchasing and Distribution module (SAS Integration)

Designed specs for UPS interface (advanced transportation module)

Involved in problem solving, coding, QA testing and user testing.

Environment: JD Edwards One World B7333 (Tools Release 7.90), B7334, VC++, Visio+, SQL plus, Oracle, Gentran 2.01 for NT, SQL Server 6.5, Windows 2000

Sr. JDE Enterprise One Analyst Jan’ 2006 – April’2006

Project: Project One Client: Trek Bicycle Corporation, Waterloo, WI

Responsibilities: Troubleshooting, Task Resolution, Analysis, Designed System Requirement Specifications for development, Unit testing, User training in system performance upgrades.

Working in JDE One World implementation of Manufacturing module, SOD and Finance Module (A/R, A/P, G/L and Fixed Assets).

Fixed the Account Ledger Balances Inquiry (AOCL bucket) for child and parent based on credit limits.

Developed Trek Apple label charge batch process to generate SO lines.

Designed and developed Comstock interface, Canadian Duty Import and export interface.

Created Trigger programs (RPG) for all major JDE files and implemented successfully.

Environment: JD Edwards Enterprise One (8.10) (Tools Release 8.96), One World B7333, VC++, Visio+, Crystal Reports, Windows 2000, RPG/400, ILE RPG, SQL/400, DB2/400

Sr. JDE Enterprise One Implementation Analyst March’ 2005 – Jan’2006

Project: Repair Finance Client: Hamilton Sundstrand, Rockford, IL

Responsibilities: Analysis, Designed System Requirement Specifications for offshore development, coding, Unit testing, User training in system performance upgrades.

Working in JDE One World/ World Soft implementation of Repair Finance Module (SO, A/R, A/P, GL, Fixed Assets, Supplier Self Service and Contract Billing) and Customer Service Module.

B4200520: Master BSFN modified to process repair finance sales update.

Consolidator: Batch process to consolidate the cost on the parts used in repair of the main item and Warranty info.

Repair Warranty Process: This process determines the Warranty on Repair orders and creates new SO for international warranty orders populated the Driver file for domestic warranty.

End of the day Posting: Written One world code from RPG process for Repair sales orders

Evaluated test scripts and test results to ensure project meets requirements on coordination with Offshore Team.

Environment: JD Edwards Enterprise One (8.11) (Tools Release 8.9), One World B7333, World A7.3, VC++, Visio+, Windows 2000, RPG/400, SQL/400, DB2/400, FTP, OPTIO, TURNOVER.

JDE Enterprise One/World Support Analyst Aug’ 2005 – Dec’2005

Project: IBM AMS Team Support Client: Medtronic’s, MN

Responsibilities: Troubleshooting, Ticket Resolution, Analysis, Designed System Requirement Specifications for development, coding, Unit testing, User training in system performance upgrades.

Working in PeopleSoft One World/ World Soft implementation of Manufacturing module, SOD and Finance Module (A/R, A/P, GL, Contract Billing).

Involved in Trouble ticket/ work request on time bound resolution goals.

Environment: JD Edwards Enterprise One (8.10) (Tools Release 8.96), One World B7333, World A7.3, VC++, Visio+, Windows 2000, RPG/400, ILE RPG, SQL/400, DB2/400, FTP, ALDON, DREAM WRITER.

JDE Functional Analyst Jan’ 2005 – March’ 2005

Project: EMS Client: Ethicon, Bridgewater, NJ

Responsibilities

Working in JDE One World implementation of Manufacturing module

Designed specs and mapping for JDE to EMS interface, WO / Parts List download.

Involved in problem solving, coding, testing and user testing

Environment: JD Edwards One World B7333, VC++, Visio+, Windows 2000

JD Edwards Migration Consultant April’ 2004 – Dec’2004

Project: FINANCEIT Client: Glaxo SmithKline, Philadelphia, PA

Responsibilities

Responsible for Data Blending & Data mapping, system monitor, Analysis, Designed System Requirement Specifications, coding, User training in system performance upgrades and a strategic thinker with Sarbanes Oxley auditing experience.

Working in PeopleSoft Enterprise One 8.10 / World Soft implementation of Finance (A/R, A/P, GL, and Fixed Assets), EDI and CNC Process.

Data Mapper: Created required RPG ILE, CLP, journals to map and transfer data between World and One World systems.

Data Mapper Monitor: This Interface is created to monitor journals, journal receivers, and data areas and send mail to alert about system status, user activity, and data record differences. Developed CLP, RPGLE, File server functions to support batch & Interactive applications to meet the requirement. Configured and created journals & receivers and data areas.

Data Blender/Conversion: This Interface is created to mix the data between UK servers and US. Developed TCU’s, File server functions and interactive applications to meet the requirement.

Anonymizer: This Interface is created to authorize & login to database (F98OWSEC) even if the JDE login is disabled. Users are not impacted and transaction & system performance improved.

OMW Monitor: The complete Interface is designed to monitor OMW operations (F9861), user activity on One World objects and sending action messages using AS/400 distribution lists.

Created JDE trail balance extract for Hyperion, IFRS adjustment ledger extracts for Essbase reporting.

Involved in CNC activity to configure environments, Package build, and deployment on web and enterprise servers and to users, set up security using OCM.

Trouble shooting the object, server related errors and customization to Standard Drill down future in Financial reports.

Environment: JD Edwards One World (PS Enterprise One 8.10), One World B7333, World Soft A7.3, AS/400 [V5R1M0/V5R2M0], VC++, Visio+, Dream Writer, Windows 2000, Turn Over, ROBOT, JAVA, Apache Web Server, Generator V4.5, Gen.BAT SP22.

JD Edwards / EDI Consultant July’ 2003 – April’2004

Project: STEP- OTC Client: F. Schumacher & Company, Newark, DE

Responsibilities

OTC project Responsible for Analysis, Designed System Requirement Specifications, Detail Design specs and coding. Involved in user training on A/R, A/P, Sales and Distribution modules Proficient with Gentran: NT EDI server

Working in JD Edwards One World Xe Implementation of Sales & Distributions, Financial (A/R & A/P) and EDI Scheduling Process.

Credit Card Interface: This Interface is created to authorize & settle credit card transactions generated from SO application (P004201) through IcVerify. Developed NER, C business functions, supportive batch & Interactive applications to meet the requirement.

Print Invoice Interface R42565: The complete Interface is made up of four pieces:

Required XML output (split xml file to Invoice level) to Reform Process, combining split lines, EDI out bound transactions generation based on trading Partner activity rules, Schumacher logo logic.

Configured Cycle Billing Set up (R49700) to produce invoices based on customer preferences, by date/day, by week, by month, by PO.

Enhancement to the JD Edwards One World Xe software to provide Schumacher with automated functionality to send / receive EDI transactions (850, 856, 869, 870, 855, 810, 820, 823, 830). Created R55JDEIN to read all the inbound files from Gentran: NT, Customized R4702C with EDI processing options set for processing all transaction sets to JDE EDI inbound tables. Modified R47011 to generate EDI orders. Created SMTP Interface (UBE) to submit all the outbound EDI files from a folder to Gentran Aux Integrator.

Lock Box receipts process (R47111 & R03B551) is modified to fit FSCO A/R processing.

P4210 - Zip code, City validation to populate new GEOCODE when ship to address changes using Vertex database connections and developed allocation split line changes.

Utility to load all PO’s and Invoices from Reform to JDE, this is accomplished by creating servlets to show the file in PDF format.

Modified Print Automatic Payments (R04572) to create A/P Checks using Pay formance software.

Modified Pick slip process R42520 to incorporate customizations as per FSCO distribution process.

Modified BD3N4205 BSFN – dcLink Ship confirmation provide customer AN8 as the key element, PD3N4312 – dcLINK PO receipt application to cross check with EDI orders.

Environment: PS Enterprise One 8.10, One World B7334, SQL server, SQL Plus, Oracle, JD Edwards One World Xe, VC++, Visio+, TOAD, dcLINK, Windows 2000, IcVerify, Gentran 2.01 for NT, AI, Java.

JD Edwards OW Xe Consultant Jan’ 2003 – July’2003

Project: Atlas Client: Cordis Corp (a Johnson & Johnson Company), Miami, FL

Responsibilities

Responsible for Analysis, Designed System Requirement Specifications, Detail Design specs, coding,

Wrote validity protocols and involved in user training. Proficient with 21 CFR Part II FDA compliance regulations

Worked in JD Edwards One World Xe Implementation of Sales & Distributions and Manufacturing modules

FTP Utility: This utility is created to transfer the files through FTP from JDE server. Developed NER, supportive batch & Interactive applications, Unix SHELL Script, EXE to meet the requirement.

Employee Master Interface: The complete Employee Master Interface is made up of four pieces:

JJEDS, JJEMS, Mexico (PRISMA) and Roden (AFAS-BPCS), only JJEDS add Employee records to Addres

Book. The other three only update the fields in F0101 and the Tag File to F0101. JJEDS

Employee Extract will bring Cordis and BWI employee information from corporate JJEDS into a

Flat file, which is created by using the Oracle dblink mapped to JDE Custom table.

This interface will read the above-mentioned flat file and populate the JDE Address Book.

Head Count Interface & Report: The system is developed to provide the ability to receive and store headcount (statistical) data from the JJEMS system and interface this data to COGNOS through F0911Z1 file. Each transaction is posted to G/L and On-demand reports are generated from F0911.

Standard Cost Interface: An interface is created to provide DCS with standard costs for finished.

Good items. The information (Item number from F4105 / Standard Cost (in euros)) forwarded to external order to cash applications (DCS or HCS). An exception error report is generated with the

Item details in error to identify the ITEMS with zero cost in all branch plants.

BPCS to JDE account balances Conversion: The General Ledger Account Balances conversion will transfer the BPCS General Ledger account balances for a given company as of the end of a specified period to One World Xe. This conversion is part of the overall transfer of data from the BPCS system to One World Xe. Written BPCS AS/400 program (RPG) to extract and transfer G/L balances to a flat file, One World Xe program (UBE) to transfer the data from the flat file into the G/L transactions table (F0911Z1) in the One World Xe system

Modified ND3N911 – UCC 128 for labels NER to alter the SKU number.

Environment: One World B7333, Citrix Server, Unix, IBM AS/400[V6 R6], DB2 / 400, Oracle, JD Edwards One World Xe, DcLINK Enterprise, VC++, Visio+, TOAD, Windows NT

JD Edwards OW Xe Consultant Dec’ 2002 – Jan’2003

Project: Version Upgrades Client: Paper Magic Group (CSS Company), Scranton, PA

Responsibilities

Responsible for creating Functional, Technical, Detail Design specs, coding and Unit Testing to the following applications.

The existing EDI inbound PO (850) system on the JD Edwards One World B7332 does not support Commission Calculations, developed ER logic and used GetCommissionMatrix Business function to meet the requirement in B7333 Xe6.

Current Sales Order Entry P4210 application does not have Mark for Information (this is needed incase not coming from EDI Orders). Designed Custom app, form that are called from a Form exit of the form W4210B and also developed ER Logic to provide the functionality.

Modified Coding logic to Get Customer Address Number based on the hierarchical look up of PO type, ASN, XRef and Label type in Customer master Interactive app. (P03013). Used Business Function for hierarchical look up

Environment: One World B7332, Citrix Server IBM AS/400[V6 R4]; RPG ILE, SQL / 400, DB2 / 400, JD Edwards One World Xe, VC++, Visio+, Windows NT

JD Edwards Consultant Feb’ 2001 – Dec’2002

Project: One Springs Client: Springs Industries, Lancaster, SC

Present Production System: Manufacturing – Manugistics; Warehouse and Logistics – PKMS, Order management System, Distribution & logistics, FRIEDMAN, SPI, PACER running in different platforms like AS/400 and Domino. Future Production Systems: ERP – JD Edwards’s one world Xe

Responsibilities

Working in JD Edwards One World Xe Implementation of Financials, Distribution & Logistics, Material Management, Scheduling and Shop Floor.

Designed and developed critical reports by using Enterprise Report Writer (ERW), Created user interface applications, BSFN by using NER, VC++ and table Conversion for converting legacy data to JDE One World data.

The responsibilities also involved performing functional system setup, promoting objects from one environment to another, monitoring and maintaining the log for object development.

Responsible for gathering design requirements from the Systems Analyst and providing conceptual, functional and technical designs for the Financial System.

Used JD Edwards One World Debug Techniques like Event Rules, JDE.INI file and JDEDEBUGLOG file.

Worked with JD Edwards One World Media Objects, used to bring the common text and images from the forms and shown into the reports.

Extensively worked on creating New Business Functions using NER and Visual C++

Evaluated test scripts and test results to ensure project meets requirements.

Environment: One World B7333Xe, Citrix Server IBM AS/400[V6 R4]; RPG ILE, SQL / 400, DB2 / 400, World Soft A7.3, VC++, MQ Series v5.1, Visio+, Windows NT, ES9000, OS/390, RS6000.

JD Edwards Technical Consultant June 2000 – Jan 2001

Project: Order Processing Interchanges Client: Security Plastics Inc, Miami, FL

Responsibilities

Created an interface program to send Dependent Demand Master file from JDE tables including F3111, F4801, F4101, F0005 and F41092 to AS/400 thru Table Conversion Tool (TCU).

Setting up Trading Partner Relationships using commerce manager software. Developed the custom made & standard maps, Creating & Using EDI Documents for the EDI Maps

Created a report (R554303) that is to be printed and mail a purchase order to the supplier. Used the current R43500 as a guide for some of the purchasing considerations. This JDE program creates a PO print, but we are created a new report form. Provide the same processing options used in T43500, create new processing options in T5543003. There will need to be multiple versions created for different data selection. Used handles whenever possible and Business Views when needed.

Developed maps for following transaction sets are 810-Invoice (Outbound), 820-PaymentOrder/Remittance Advice (Outbound), 850-Purchase Order (Inbound), 855-Purchase Order Acknowledgement, 856-Shipment Information (Outbound), 870-OrderStatus Report and 997-Functional Acknowledgment

Mapped the EDI information to a flat file via the Trusted Link AS400 translator.

Used FTP to get the 860 flat files to the JDE AS400.

Used a new TCU (RS5647002) to load input 860 flat files to existing 860 F47 tables.

Used a new UBE (R5642002) to read the F47 tables and create the 860 PO Change.

Used a copy of JDE UBE (R47138) to purge the 860 related F47 tables at a specified time.

Created an interface program to load EDI PO Header and Details tables from AS/400 to JDE tables (F47011, F5747011, F47012 and F5747012) thru TCU

Environment: JD Edwards OW Xe (Distribution & Logistics, Financial and Manufacturing), Windows NT, Citrix Server, Gentran NT, MS-SQL Server, and DB2/400

JD Edwards OW Consultant Duration: Feb 1999 – May2000

IBM Redbooks Distribution System Client: IBM at Boulder, CO

The project involved development and migration of data and programs in RPG & CL, JD Edwards World to One World. This system is developed from multiple systems to single system.

Responsible for Client requirements gathering, definition, analysis, and design of the system Data migration, Designing and development for the interface between Address book (F0101) to Financial (General Ledger, AP, AR, Job Costing, Manufacturing and HR Systems (Human Resource Module)

Set up the Category codes and worked with Business Units, Assigned Category codes to business units, Modified the Organization Report structure, Setup AAI’s (Automatic Accounting Instructions), Migration from World to One World and Modified Database files, Tables according to one world Standards.

Developing the Interface Programs Using CL/400 between Database to application

Setting up Default Locations, Standard units of Item cross-references

Developing Required RPG/400 According to Client Requirements for Migration

Using FTP Uploading the data from different system into Major system

Customizing the database to fit client needs by creating user defined information and attaching the records to address book records.

Environment: JD Edwards One World B7333, World Soft A7.333, World writer A7.3, OS/400, Manugistics, AS/400, DB2/400, RPG/400, CL/400, Query/400 and SQL/400

RPG Programmer Duration: Sep 1998 - Feb 1999

Pharmacare Web Site Development Client: CVS Pharmacy, CT

Description: Pharmacare is a Pharmaceutical Benefits Manager or PBM who has many members and various facilities for members. This new Web Site will provide various information and facilities to the members and clients including the functions that are supported by the host systems. This Information is on DB2/400 and retrieved to web using JDBC-ODBC driver coding.

Responsible for:

Wrote Triggers in DB2/400 to validate and authorize each transaction.

Programming with MQ Series experience

Design and coding of a complex RPG/400 Sub file programming

Involved in unit testing of the application.

Development of front-end web-based panels using Java Server Pages

Interaction with End-users and end-user training

Environment: AS/400 [V4R4] I-Series, XML, JSP, JAVA Script, JAVA Servlets, JAVA Beans, HTML, WinNT 4.0.

EDUCATION

Bachelor of Technology in Engineering. Advanced Diploma Course in Computer Applications.

Certified Lotus Notes Professional Application Developer R5 (CLP) / Certified Lotus Notes Administrator.

IBM Certified AS/400 Programmer

Masters Level Certification from Brainbench.com – JD Edwards One World Report Design

SOFTWARE SKILLS

ERP Packages

Enterprise One, J.D Edwards One World Xe, One World, and BPCS

J.D.E One World Utilities

OMW, OL, FDA, RDA, TC, UBE, ER, Versions, Processing Options, Data Structures, Debugger, Data Dictionary, Business Functions, NER, Business Views, UTB, VC++

AS/400 Utilities

RLU, SDA, PDM, SYNON, Visual Age for Java, MQ series

Operating Systems

OS/400[V4R4] & [V3R7], Windows 95/98/2000/NT/XP

Languages

C, C++, VC++, NER, JAVA, Lotus Script, Java Script, Java, RPG/400, CL/400, SQL/400, ILE RPG, BPCS.

Web Technologies

JDBC, Java Applets/Servlets, Java Script, HTML, DHTML, CSS, JSP, IBM Web sphere.

Databases

DB2/400, Lotus-Domino and ORACLE

Other Skills

Lotus Notes, Visio, MS-Excel 5, MS-Word 6.0, MS-Access97 and WordPerfect, IcVerify, GENTRAN: Server EC Workbench and GENTRAN:Server Workstation (5.x, 6.x), GENTRAN:NT Server(1.0,2.0,3.0,4.0,4.02), TIDAL, ROBOT, TURNOVER

Protocols

TCP/IP, HTTP

Contact this candidate