SUMMARY:

• Sr. JDE Techno Functional Consultant with 9 years of experience in JD Edwards World and Enterprise one with excellent track record in entire SDLC including requirements Gathering, Analysis, Design, Development and testing.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. JD Edwards (World, Enterprise One 8.12&9.0) Techno Functional Consultant and Junior CNC

Environment: JDE Enterprise One (9.0 & 9.1), RDA, FDA, TDA, BDA, NER, Windows NT, Oracle, ToadJDE World A7.3, AS400, DB2, FASTR, STAR, World Writer, CL&RPG

Responsibilities:

• Reviewing the JDE World Migration Plan to E1 and Verifying the JDE World Objects and Gap Analysis.
• Developed a Custom UBE(JDE E1 for US Region) for Updating Date of Last Cr. Review by taking current Date of Last Cr. Review (DLC) and add 365 days, then populate results into DLC field. The data selection was locked for Bill to accounts that payment terms not equal 30, 32, 35. Provided Proof and Final versions with the report.
• Closely interacted with Functional analysts and end users.
• Given the demos for the users and department managers about the modifications and explained them how the modifications are going to work. Also involved in the company status report meetings to discuss the project status.
• Attended the meetings to design the specs and interacted with users to Identify the requirements.
• Created Power Browse forms, used Mapping Links, FI’s in JDE to create a single view of multiple data for Items and Item Categorization codes.
• Involved in the preparation of Functional and Technical specification documents.
• Created XML Source files using Embedded JDE BI, Modified RD’s, templates and consumed templates in BI publisher. Provided bursting capability for the reports delivery.
• Developed a Custom UBE(JDE E1 for US Region) to Update Credit Limit & Payment Terms by taking Last Invoiced Date (DLIJ) and add 365 days, if calculated date is less then today date, then update Credit Limit (ACL) to 1 and Payment Terms (TRAR) to 30 cash. The data selection was locked for Bill to accounts that payment terms not equal 30, 32, 35. Provided Proof and Final versions with the report.
• Developed a Custom UBE(JDE for US Region) to Update Date of Last Cr. Review (DLC) for customers with payment terms (TRAR) equal 30, 32 to set date of 01/01/2020.
• Working on creating Custom FASTR versions for Year End EL Ledger Auditing requirements
• Worked on Custom FASTR Balance Sheet and Income statements based on Entity Structure of ASIA Region
• Worked on Year End FS Package Custom Reports including BS, PL, Capital Roll Forward Reports for Investors and operators.
• Worked on customizing Payment Group and Payment Control Reports
• Reconciliation Custom reports Creation and Audit report for payments related to Vendors Processed through 3rd party payment systems.
• Involved in New Entity, BU, COA, Vendor GL Bank Account setups
• Involved in Production SQL Select & Update Queries for User Group security Migration
• User security Setups and Maintenance
• Developed Custom FASTR Report Versions FSPKGBS and FPPKGPL to pull the data from F0902 and format to the User Requirements.
• Modified FASTR Column, Row Spec Masters and tested multiple FASTR Versions utilizing these Master Specs.
• Created Custom World Writer Report for generating Interface Feed for Security User List. The world writer Report utilized Joining F0092 and Custom Tag tables to pull the Descriptions and generate Feed.
• User Security Management.
• ESU Updates to JDE E1.
• User Role management Java based Interfaces to JDE.
• Package Builds and Deployments.
• Knowledge and Exposure to Windows server Manager for JDE .
• Very Good Knowledge in and Oracle SQL Queries.
• Good in understanding and troubleshooting interfaces with .Net, VB, Java based technologies.
• Good Knowledge in BI Publisher and BSSV.
• Created Custom World Writer Report to generate FX Interface Data to load into F0015 table.
• Knowledge in JDE Sub System Processing, JDE connecting to Oracle Gateway for intranet financial reporting in Europe Environments.
• Strong SDLC skills in JDE environment with JIRA, Conductor, SVN and Build/Deploy AGent.
• Knowledge in data mirroring and disaster recovery planning with offsite backups and restoration using vision 2rd party systems.

Confidential, Somerville, NJ

Sr. JD Edwards (World, Enterprise One 8.12&9.0) Technical Consultant

Environment: JDE Enterprise One (8.12 & 9.0), RDA, FDA, TDA, BDA, NER, Windows NT, SQL ServerBI Publisher, Windows NT, Oracle, Toad, UNIX, BSSV

Responsibilities:

• Retrofitted the objects from E8.12 to E9.0 on up gradation to E9.0.
• Worked on Item Trace/ Track functionality enhancements. Completely revamped an existing Technical Design and Written a Multi sectional UBE utilizing many complex Business logics.
• Worked on creating a new Custom made Sales Order application (P554210) to suit to the client requirements like adding Acknowledgement#, Customer Ref#.
• Developed a Custom Report to update F5642565 table to include JC line type records so that all costs including subsequent work order costs for reopened work orders by updating DOC with the original Invoice Number. This UBE runs after the sales update in the midnight and Also Updated F4211 with JC line type with a flag that these records are processed.
• Developed a Custom UBE for Updating Date of Last Cr. Review by taking current Date of Last Cr. Review (DLC) and add 365 days, then populate results into DLC field. The data selection was locked for Bill to accounts that payment terms not equal 30, 32, 35. Provided Proof and Final versions with the report.
• Developed a Custom UBE to Update Credit Limit & Payment Terms by taking Last Invoiced Date (DLIJ) and add 365 days, if calculated date is less then today date, then update Credit Limit (ACL) to 1 and Payment Terms (TRAR) to 30 cash. The data selection was locked for Bill to accounts that payment terms not equal 30, 32, 35. Provided Proof and Final versions with the report.
• Developed a Custom UBE to Update Date of Last Cr. Review (DLC) for customers with payment terms (TRAR) equal 30, 32 to set date of 01/01/2020.
• Developed Custom application for IBTL Ship Confirm and Added prompt call the Packing List Application each time a ship confirm is completed for an ST so that the user can enter Pallets#. This Packing list will have Bar Codes for each item. The Number of pallets are mapped to the SDUPC2 (Price Code 2) field.
• Worked on IBTL Pick Confirm application version to Enable the Hand Held to Pick Confirm ST orders.
• Worked to Enhance P4312 to call the Back Order Release P42117 via processing option.
• Worked on Material Component Shortage Report R5531418. Added 2 New fields to the report. Made sure that the fields show up correctly on the report Both in PDF format and as well as on CSV format report.
• Used Item Quantity conversions, Date Business functions, GET UDC, Get Environment, Get Company Name and many other JDE Business functions including NER’s and C Business Functions.
• Good understanding of Debugging techniques including JDE Debugger and Visual Studio for C Business Functions.
• Good understanding of the Job Schedulers (Unix, IBM Maestro) and their functionality.
• Very Good experience in Using Toad on Oracle Database and writing SQL Queries Pulling the data from JDE tables.
• Extensively Coded & tested EDI 856 ASN Custom program and a Custom UBE to load the data into the 856 Staging Tables. Worked with the EDI coordinator to resolve the issues related to the EDI mapping and calculations for Total quantity, Total Weight and Total Cube.
• Extensively worked with AS/400 and identified business logic that need to be implemented in the JDE system. Involved in the EDI processes to bring in the data in to the EDI interface tables (System 47) from AS/400 Legacy system.
• Modified the work order time entry application (P311221) to report the scrap at any sequence level. Made the scrap order type is as ‘IU’ and did change the system setups to post the right value into the GL. Made the changes to show the ‘IU’ variances in variance report.
• Worked with the work order applications (P31116) to show the correct scrap value on work order for MRP process when the users scrap at any level or stage.
• Created the new UBE to update the required data from Item Master to Item Branch and Item Location files.

Confidential, Columbus, IN

Sr. JDE (Enterprise One 8.12) Technical Consultant

Environment: JDE Enterprise One (8.12), RDA, BDA, TDA, FDA, NER, Windows NT, AS400DB2400, RPG400.

Responsibilities:

• Converted JDE World data files to JDE Enterprise One data files. As a part of table conversion, World data files are converted into Z - files and then loaded into Enterprise One by solving the data integrity problems. These conversions include the following files: Address Book, Customer Master, Sales order, Work Order.
• Involved in updating or correcting the World data using RPG programming.
• Involved in modification of hours and Quantities Update UBE (R31422) to issue Burden Materials automatically. And also changed the material Issues application (P31113) not to show the Burden Materials for Issues.
• Created new Yearly Quantity report (R56YRQTY) to display the quantities produced by present year and also calculated the difference between present and last year. Calculated the % of growth based on the items and business unit.
• Created the report to balance between work orders (R56WORK) and produced items (R56ITEMS)
• Created the Customer Information Report (R560101) from scratch. Used table I/O in report to fetch the data from F0116 and F0115 using the Address Number. Added the processing option template to enter the Customer Number to get the client required output.
• Created the Next Numbers and added them to the application fields using override or business functions where the client needs to get the next number automatically.
• Added the invoice print report to the sales order detail (P4210) application’s exit bar to print the invoice for selected row based on the order number.
• Modified the Pick Slip (R42520) report as per the client request Created Request For Quote Report (R5543530). This report displays the details of the supplier. F0010 Get Company and Report Description Business function is used
• Created In Transit Reconciliation (R564211/R564311) This report displays the customer details based on Date Range and calculating the Totals on Order Company.
• Developed Monthly Billing Statements Report (R564201) to show the details of Customer Statement and calculated the totals and Balance Due for particular Store number. Added a Section header to display customer description as per the client request.
• Implemented Form Scape with JD Edwards in creating and accessing some reports, forms and labels. And also used in some important company required documentations like invoices, custom reports etc.

Confidential, Gary, IN

Sr. JDE (Enterprise One 8.12) Technical Consultant

Environment: JDE Enterprise One (8.12), RDA, BDA, TDA, FDA, NER, Windows NT, AS400DB2400, RPG400.

Responsibilities:

• Used the Data Conversion programs to transfer the data from legacy system (Mainframes) to JD Edwards system. Loaded the data into Purchasing Tables (F4301 and F4311) using the data interface programs and Z-File conversion programs. If data has the problem to load into JD Edwards, found the reason for not loading through the work center and corrected the Z-file data.
• Modified the Print Invoice Report (R42565) program by adding level break sections to show the different types of totals, changed the sequence properties to show the data how the client required, added some extra fields and fetched the data using file I/O, Calculated the taxes and shipping totals based on the client request.
• Involved in doing the small modifications to the existing Sales Pick Slip report (R42520) by adding OSP purchase orders information and added the level break and page break to get the total OSP items based on the branch plant and business units.
• Created Sales Person Report (R5642SLS) to get the business done by the sales person. Sale person data is retrieved from Sales order history table (F42119), sorted and given level break for each sales person. Calculated the total number of sales order done by each sales person by taking section footer.
• Created the Cancelled Sales Order report (R5642CANC) to display the cancel orders, retrieving the data from F42119 based on the status code ‘999’.
• Created the Batch Report (R56INCEN) and created Named Event Rules to give the information about work orders done by the worker. If the orders are exceeded by the normal calculated Orders, incentives are given to them depending on their basic pay scale.
• Modified and Added the User Defined Code (UDC) tables for Sales Order Application (P4210) to some fields to restrict the users in selecting the valid data as per company requirement. Used the Business function to attach the UDC code to some of the fields.
• Added Image Attachments by creating Media object (GT564210) in Sales Application (P4210) to display the item pictures with different views.
• Inserted the report variables to get the salesperson name by using visual assist Search and select form in Sales Application (P4210), this process involved by taking the salesperson category code from Address Book Master table (F0101) and displayed the description using the UDC code.
• Involved in importing the data to JD Edwards One World from embedded systems like Internet based, packaged based and database based and flat system based data.
• Inserted the script commands in UBEs, by loading the data to process and run essential One World functions. And also tested the data integrity by performing database validations
• Created and added a new Menu (G564209) to SOM to attach the customized and new applications and reports. This menu is attached to the main Sales Menu (G42) and given security to authorized persons.
• Involved in stress test for the Sales Module application (P4210).
• Prepared the hard copy and soft copy documentation for all the above Applications and Reports.

Confidential, Daleville, VA

Sr.JDE (Enterprise One XE) Technical Consultant

Environment: JDE Enterprise One XE, Windows NT, AS 400, DB2 400.

Responsibilities:

• Worked on Item, Item/Branch applications and provided various Enhancements to suit to the Customer needs.
• Worked on SQL in SQL Server to validate the number of records in the Sales order tables and also with that of the transportation tables. Wrote SQL Scripts to clear the tables and load the data into EDI staging tables.
• Developed a number of Table conversion & JDE UBE programs for validating the Legacy data and cross-referencing with custom cross- tables.
• Created a Table Conversion (TC) program (R55TCAB) to upload supplier data into address book and supplier master ‘Z’ files (F0101Z2, F0401Z1) and used existing batch upload programs to load data from ‘Z’ files to application tables (F0101, F0111, F0401).
• Developed custom integrity report between Cardex and G/L to show the item usage by work order
• Customized the GL Cash Forecasting Report (R09520) to review the summary of current balance information in general ledger
• Developed Custom Aging Trend Analysis Report (R5503B166)
• Developed Custom Purchase Order Print (R5643500B), which was based on standard JDE report (R43500). Purchase order printed on clients existing purchase order with their add-on requirements
• Customized the AP check printing programs R04572, R04570 in order to meet client requirements. Changed format and added new payment instrument type and new version to payment control group program to use custom program R5504572 to print AP checks
• Customized Purchase Price Variance Report (R5504003A) for additional columns requirement
• Customized the Customer Totals by G/L Account Report (R09450)
• Involved in GL Conversion Uploads from multiple sources including EDI and legacy systems
• Prepare & execute Test Cases and used defect tracking tools.
• Performing code review, mentoring and team.
• Prepared Documents and material for the End User.

Confidential, Detroit, MI

Sr.JDE (Enterprise One XE) Technical Consultant

Environment: JDE Enterprise One XE, Windows NT, AS 400, DB2 400.

Responsibilities:

• Modified the work order completions Batch application (R31811) to separate the Buren Materials and Actual Materials. Changed the F3102 A1Standard and actual cost by decrementing the Burden cost and added the decremented Burden cost to Z1 cost type.
• Changed the Work Order Variance UBE (R31818) to show the variance of Z1 by comparing between Actual cost and completed cost instead of Planned vs. completed cost as per the client request.
• Added a new line to F3112 file when the scrap occurs at sequence level and updated the URAT field to show the sequence level scrap amount for the user .
• Modified the Print Work Order Status Summary report (R48496) by adding the extra field for the equipment information, this information is retrieved from Equipment Master Extension file (F1217) and Equipment Messages file (F1205).
• Involved in creating the custom Equipment Sticker report to show the service information for the serviced part. This report prints two identical stickers one for equipment and one for service department records.
• Modified and renamed the Print Invoice report (R42565) to retrieve retail price and Trade Discount from F4211 / F42119 for every Item Number in the Order detail line. Restricted the output to print only 7 detailed records per page on preprinted invoice forms of company.
• Involved in changing the UBE’s and Printer setting to print the requested data from JD Edwards to laser and line printers. Also involved in creating different types of files to fax the customers by taking the JD Edwards PDF output files.
• Created the Branch Plant Information Report (R5700061), which gives the information about branch plant based on table F0006. Used the table I/O Fetch command option in event rules to get the data from other tables by passing the Business unit number. Added the header section to display the common branch plant information.
• Created and added Data Structure for the print invoice Report (R5742565) and added to the Sales Order Detail Application (P4210) row exit bar to print the invoice report for the selected rows.
• Developed the new Table (F57SMNW) to display the Migrated Data from multiple Foreign Tables also created the new find/Browse application to see the migrated data. Given the update facility for the managers.
• Modified and renamed the Sales Order Entry Application (P4210) by adding some extra fields to the grid, given the QBE facility for some of them to search the data based on entered value. Used the fetch command to get data from other tables.
• Involved in tuning the Find/Browse forms for the applications, when the find performance is very slow then added some extra business view fields for filtering. Entered the default values using event rules and disabled them for not changing by the users.
• Involved in attaching the attachments, special notes and files to JD Edwards files by taking from Other Embedded systems.
• Involved in Applying the Paper Fixes for the Company requested reports and applications by taking the code from the latest SAR released by the JD Edwards. Documented the hard copy of the Paper Fixes on the reports and Applications, which are updated.
• Developed Message Forms in Sales Application (P4210B) according to the client required format to show errors and give error information user friendly.
• Trouble shouted the reports, conversion programs and applications to find out the problems using JD Edwards Debugger tool.
• Added custom reports and applications to the menus where the management requested.
• Prepared the hard copy and soft copy documentation for all the above Applications and Reports.

Confidential

Sr. JDE Technical Consultant

Responsibilities:

• Project Managed Implementation of JD Edwards One world for a number of clients.
• Managed Technical resources of at least 25-50 members in Size with various levels of technical Expertise including 2-3 Project Managers and of 6-8 module Leaders.
• Experience and expertise in Recruiting JDE Resources including the interview process, Negotiating salaries, Managing Employee expectations within Budget Limits.
• Demonstrated expertise in business / system analysis, requirement analysis, project scoping, end-user and documentation.
• Independently developed the JD Edwards ERP practice including developing clients, Recruiting Technical & Functional Resources, Managing the Client expectations, reporting the status to the Upper management in the client locations.
• The JDE Practice has grown from $100,000 to $1 Million in a span of 3 years.
• Prepared Weekly reports to Clients of PS Info tech, LLC detailing the current status of the different activities in the projects and supporting the decision for adding or removing a resource.
• Created and executed the presentations for external/ internal reviews for requirement, prototype, design (functional and technical), test plan and development.

Confidential, Boonton, NJ

JDE (Enterprise One XE) Technical Consultant

Environment: JDE Enterprise One XE, RDA, FDA, TDA, BDA, NER, Windows NT, SQL Server

Responsibilities:

• Created a new report R551099F - Print data into1099 Form
• Retrofitted custom modifications from JDE legacy version to Enterprise One XE
• Developed the Item Master, Item Cost, Item Balance conversion Programs for converting the data from Prism to E1 by using the JDE Z-file process.
• Developed Sales reports for daily orders, yesterday’s orders and shipments
• Developed the Item Cost component interface in E1.
• Developed an interface in E1 for daily shipments and sales activities for web reports in SQL Server.
• Changes were made to the Bill of Lading report R5549115.
• Created a Workday calendar report for shop floor system using Report writing.
• Developed Tracking report for user to track the order information for a customer.
• Developed an interface for month to date, year to date orders for daily web reports on SQL server.
• Developed Advanced Cost calculation balance report R5516102.
• Developed a cost audit trail Report R5516114 and Cost activity master Report R551640.
• Involved in the EDI process (Inbound & Outbound) to bring in the data in to the EDI interface tables (System 47) after validating the data and cross-referencing with custom cross- tables. As per requirement created the custom tables, Business views, data dictionary items, Interactive applications and reports to meet requirements.
• Created TC’s R5941005 & R5941006 for converting data from the F4102 table within JDE World and CSV file to the F4101Z1 table. The data was uploaded into the Z file using the TCs and Subsequently, the Z processor ( R4101Z1) was run to pull the data from the Z file and push it into the main table F4102 in E1.
• Created TC’s R5941008 & R5941009 to upload data from F41021 in JDE world and CSV file to the F47121 and F47122. The EDI processor R47121 was run to pull the data from the EDI tables and push into the main tables F41021 & F4111 in E1.

Confidential, Burlington, MA

JDE (Enterprise One XE) Technical Consultant

Environment: JDE Enterprise One XE, RDA, FDA, TDA, BDA, Windows NT, SQL Server

Responsibilities:

• Customize the application P4103M for valid customers.
• Created a Report to display the mismatch items of F4101 and F4102.
• Customize the P554210 for Price history and Substitute items.
• Modified the Pick Note, Amended Note and Load Note Generated in Load Management.
• Modified the P554210 for Customer Number changes for Rebate.
• Created an application to Upload the data from excel to Supplier/Item Price table F43090
• Created an application to Upload the data from Excel to Item/Price table F4106
• Customized the a packing slip report (R5542520) page break for every box number.
• Created a Report R0015A for Daily Exchange Rates
• Created an Interface for uploading exchange rates to the External Multicurrency Fields in the F0015Z1 Work file.
• Customized the Supplier Analysis report (R04602) for the A/P department to show the voucher amounts in multi-currency.
• Worked on modifying the existing Applications, UBE’s and Processing option Templates to fulfill the New Requirements. Promoting the objects from DV to PY, QA and production.
• Created a new Complex report R554211W to create Inter Branch (S1/O1) and Inter Company (S2/O2) Transfer Orders.
• Developed Custom Purchase Order Print (R5643500B), which was based on standard JDE report (R43500). Purchase order printed on clients existing purchase order with their add-on requirements
• Customized the AP check printing programs R04572, R04570 in order to meet client requirements. Changed format and added new payment instrument type and new version to payment control group program to use custom program R5504572 to print AP checks
• Customized Purchase Price Variance Report (R5504003A) for additional columns requirement
• Customized the Customer Totals by G/L Account Report (R09450)
• Enhancement and customization including customization on Auto Voucher Match - EDI file generation.