Sr. Jde Analyst Resume
Hershey, PA
SUMMARY:
- Business/Technical Analyst with 15 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.
- More than Seven years of Software Development 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 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 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 Inovis 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 - master’s Level from Brainbench.com
TECHNICAL SKILLS:
ERP Packages\AS/400 Utilities: Enterprise One, J.D Edwards One World Xe, \RLU, SDA, PDM, SYNON, Visual Age for \One World, and BPCS\Java, MQ series\
Operating Systems\Web Technologies: OS/400 V4R4 & V3R7, Windows 95/98/\JDBC, Java Applets/Servlets, Java Script, \2000/NT/XP\HTML, DHTML, CSS, JSP, Confidential Web sphere.\
Languages\Databases: C, C++, VC++, NER, JAVA, Lotus Script, Java \DB2/400, Lotus-Domino and ORACLE\Script, Java, RPG/400, CL/400, SQL/400, ILE \RPG, BPCS.\Other Skills\J.D. E One World Utilities\Lotus Notes, Visio, MS-Excel 5, MS-Word \OMW, OL, FDA, RDA, TC, UBE, ER, \6.0, MS-Access97 and WordPerfect, IcVerify, \Versions, Processing Options, Data Structures, \
Protocols: TCP/IP, HTTP
PROFESSIONAL EXPERIENCE:
Confidential, Hershey, PA
Sr. JDE Analyst
Responsibilities:
- Developed data base maps for archiving JDE World 7.3 tables to SQL data base.
- Data Migration/Solution developer purging data as per AW retaining policies.
- Designed/developed functional and technical specs and implemented as per SOX guidelines.
- Involved in day to day incidents/requests, business cases, problem solving.
Environment: JD Edwards world soft 7.3, SQL plus, OS/400, SAP Business Objects 4.0, Crystal Reports 2011
Confidential, Chesapeake, VA
Sr. JDE/EDI Analyst
Responsibilities:
- 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.
- 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
Confidential, Bear, DE
JDE Analyst
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
Confidential, Jacksonville, FL
Sr. JDE/EDI Analyst
Responsibilities:
- Involved in EDI implementation of UCS EDI transaction sets (810, 814, 820, 824, 832, 834, 837, 850, 855, 856, 860, 861, 867, 879, 880, 940, 944, and 943). Established communication with VANS, using Gentran Mailbox. Worked with several different VANS, including Advantis, Commerce: Network, Premonos.
- Working in JDE One World implementation of Purchasing and Distribution module (SAS Integration)
- Designed specs for UPS interface (advanced transportation module) and Credit Card Interface.
- Implemented JDE workflow at user level on web based (JAS), server based (SQL/Windows), citrix (fat client) based clients to communicate with external email SMTP servers.
- Involved in problem solving, coding, 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, Crystal Reports 2011
Confidential, Waterloo, WI
Sr. JDE Enterprise One Analyst
Responsibilities:
- Working in JDE One World implementation of Manufacturing module, SOD and Finance Module (A/R, A/P, GL 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
Confidential, Rockford, IL
Sr. JDE Enterprise One Implementation Analyst
Responsibilities:
- Analysis, Designed System Requirement Specifications for offshore development, coding, Unit testing, User 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
Confidential
JDE Enterprise One/World Support Analyst
Responsibilities:
- Troubleshooting, Ticket Resolution, Analysis, Designed System Requirement Specifications for development, coding, Unit testing, User 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
Confidential, Bridgewater, NJ
JDE Functional Analyst
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
Confidential, Philadelphia, PA
JD Edwards Migration Consultant
Responsibilities:
- 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.
- Troubleshooting 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
Confidential, Newark, DE
JD Edwards / EDI Consultant
Responsibilities:
- 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 ps, 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 in corporate 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.
Confidential, Miami, FL
JD Edwards OW Xe Consultant
Responsibilities:
- Responsible for Analysis, Designed System Requirement Specifications, Detail Design specs, coding, wrote validity protocols and involved in user . 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 Address 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, Confidential AS/400 V6 R6, DB2 / 400, Oracle, JD Edwards One World Xe, DcLINK Enterprise, VC++, Visio+, TOAD, Windows NT
Confidential, 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 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 Confidential AS/400 V6 R4 ; RPG ILE, SQL / 400, DB2 / 400, JD Edwards One World Xe, VC++, Visio+, Windows NT
Confidential, Lancaster, SC
JD Edwards Consultant
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 Confidential 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
Confidential, Miami, FL
JD Edwards Technical Consultant
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 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
Confidential, Boulder, CO
JD Edwards OW Consultant
Responsibilities:
- 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-s
- 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
Confidential, CT
RPG Programmer
Responsibilities:
- 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
Environment: AS/400 V4R4 I-Series, XML, JSP, JAVA Script, JAVA Servlets, JAVA Beans, HTML, WinNT 4.0