Sales Project,EDI,Finance,9.1,9.2,JdeCloud

Naveen Yerratha

Phone: 949-***-****

Email: **************@*****.***

JDE Senior Programmer Analyst

EXPERIENCE SUMMARY

Over 18 years as J.D. Edwards Senior Programmer Analyst using JD Edwards OneWorld Xe, 8.10, 8.11, 8.12 & EnterpriseOne 9.0, 9.1,9.2, SQL Server, Oracle and AS/400.

Performing user requirement studies, design, analysis, development of technical specifications, custom reports, custom applications, programming, implementations, integration, documentation, testing, training, and post-production support.

Involved in a number of J.D. Edwards OneWorld development projects and have conducted corporate trainings on OneWorld, with strong knowledge of database systems such as SQL Server, Oracle and Client/Server technology.

Sound knowledge in JDE Z-Processes for Interfaces

Developed and Modified C- Business Functions and Named Event Rules.

Good knowledge on Reports, Applications, Table Conversions, Work Flows, Business Services, Web Services and RTE.

Strong hands-on J D Edwards Tools, strong debugging and testing skills.

Business and Application analysis skills with excellent communication, analytical, logical, presentation skills and quick adaptability to new technologies.

EDUCATION

Bachelors of Science in Computer Science Engineering

TECHNICAL EXPERTISE

ERP: PeopleSoft EnterpriseOne(OneWorld XE), ERP8, JD Edwards OneWorld 8.10, 811, 812,9.1 & 9.2

Languages: C++/ C, PL/SQL, T-SQL, FoxPro, Shell Scripting (Csh, Ksh, Bourne)

RDBMS: Oracle, SQL Server, Access

Operating Systems: Windows NT/2000/2003/XP, Unix, AS/400, Novell NetWare, MS DOS

Web: JavaScript, HTML, ASP

Tools: JD Edwards Enterprise Report Writer (RDA), Object Management Workbench (OMW), JDE Forms

Design Aid (FDA), Table Conversion Toolset, Processing Option Design Aid, Crystal Reports

Modules Worked on:

1Financials - AP, AR, Fixed Assets and GL, Advanced Pricing

2Sales & Distribution, Procurement and Inventory Management

3Manufacturing

4HR & Payroll

PROFESSIONAL EXPERIENCE

Client: Golden State Foods, Irvine, CA

Project Details

Duration : April 2016 – Till Date

Role : Senior Programmer Analyst

Environment : JDEdwards EnterpriseOne 9.1

Databases : AS/400

Project Scope & Responsibilities

Developed Interfaces to extract Customer Master, Item Master and Invoice Data to transmit as text files to Exten Data ePOD(Electronic Proof of Delivery) along with calling a CL program CFA_EPOD passed through Processing option for the FTP process.

To meet the requirement to send JDE E1 Sales Orders from QCD to Armada sending the Sales Order Details as they are created upon receipt of CFA purchase order data processed and generated into E1, EDI 850 SO was used to send Sales Order data outbound to Armada. In that regard created R5747001 EDI 850 SO Outbound Extract, modified R57S032 AOS Upload to update Ship Date in F47011 as each Sales Order is created into F4201 & F4211 along with another UBE R574201U – CFA PO Number Update created to update CFA’s PO Number in F4201 Reference2

Worked on EDI 810 as R57E026C and EDI 812 as R5747047 using the custom NER’s for writing F47046, F47047, F470461, F470471 & F4706 Lines to Text File

Designing and publishing the E1 Pages CFA OMS Sales Order Daily Basic & CFA Distress Order

Under the Project QCDS0226 – CFA Duplicate PO Number developed new objects R57S4201, T57S4201, V57S4201, RD_57S4201 & TP_R57S4201

Worked on P57S808A ePOD Delivery Inbound Custom Application and made the mods on R58S42520 – Packing Slip for missing CFA Item Number

Created new R58E026E CFA EDI 810 Exception Report along with the BI Pub Objects RD_58E0263 & TP_R58E026E

Worked on EDI Outbound 855 PO Acknowledgement under the Project QCDP0075 by developing new Objects R57P026, T57P026 & V57P026 along with the BI Template, Report Definition & DD Item(TP_R57P026, RD_57P026 & $5513)

Completed the development of Wendys DC Customer, Item Data Extract & Open Orders

Worked on Wendys EDI 820 Remittance Advice with the development of R57X0002, T57X0002, BI Report Definition & XML Template

Client: Zimmer Inc, Warsaw, IN

Project Details

Duration : November 2015 – March 2016

Role : Senior Programmer Analyst

Environment : JDEdwards EnterpriseOne 9.1

Databases : Oracle 12c

Project Scope & Responsibilities

Developed (R5509205A ) Monthly Income Statement financial reporting based on (F0901/F0902/F0006 ).This UBE generates spreadsheet for company’s Income statement for specified period. Row template override is used to bifurcate Internal sales,External Sales Income and Expense sheet Variable Cost, Inventory Resolution based on different company. Different members in the row were discriminated thru cat code for different companies for Smart field used "Period activity".

Shipping schedule application has two screens.

First screen filters data for distribution centers which is ready for further shipping cycle. The header part accumulates and display total load, total no of orders and total no of shipments and detail part shows each shipments with total no of order and load attached to that particular shipment.

Second screen displays all the orders detail attached to that particular shipment. User can process each shipment for further shipment cycle i.e. Print pick slip, Reprint, cancel shipper, RMA receipt

Created new Batch Program (select product for de-activation) to read the F4101 for all products and identify those items that may needs to be de-activated. The items and item branch plant records of potential de-activate have been written to a new file (deactivation file). Created Interactive program based on new file (deactivation file) using this user will be able to review the extracted items and item branch data, modify it, add to it, delete it, use it to update the F4101 and F4102, and upload data and approve the data.

Client: Catalent Pharma, Somerset, NJ

Project Details

Duration : May 2015 – October 2015

Role : Senior Programmer Analyst

Environment : JDEdwards EnterpriseOne 9.1

Databases : Oracle 11g

Tools : OneWorld Toolset UBE /ERW, Table Design Aid (TDA), Table Conversion Tool.

Project Scope & Responsibilities

Worked on Order Verification Enhancement

Manually enter JDE 9.1 EDI Order from the information on the Shipment Request into (P554203) Shipment Request Edit Update. When “Add” is clicked a flag is set in User Code (URCD) in the (F47011) EDI Header indicating Manual Entry.

Preprocessor (R554203) runs to match EDI order via Protocol Number, Branch, RAND, Supplier Lot, etc. manually entered RAND, Supplier Lot, Visit Number, Site ID

oThis process updates other required information in the EDI tables for the system to process the order into the system. Update to existing preprocessor UBE (R554203) should update the processed flag F47011/F47012.EDSP to a new status which is used for VERIFICATION. The Verification status is assigned only if the flag populated in (URCD) in the F47011. Other the preprocessor executes as previous designed.

Verification is a new step that will require a new interactive program.

oNew user (not the one who entered the EDI order from the SR) needs to enter information such as Protocol Number, Branch, and Shipment Request Number. Additional Header information will default. The number of kits will also populate on the new program. The new interactive program will have an associated new custom table. The user will enter the kit numbers from the Shipping Request. The newly entered information would have a status associated to indicated ‘new’. This new app/table should have a reference for the EDI order number (EDOC) – this should be a required filed and will be used by the new ‘Verification UBE’.

oA new ‘Verification UBE’ would process after the ‘verification order’ has been entered. This would compare the LOTN information from the F47012 file to the ‘Verification table’ by EDOC number. If there is a match on each line then the F47011/F47012.EDSP flag should updated to a status where R47011 can process the EDI order. If there are ANY discrepancies then the ‘Verification UBE’ should update the status in the new ‘Verification table’ to an error. The UBE should print a report indicating any errors or successful processing.

oR47011 should only process EDI orders which have successfully passed the ‘UBE Verification’ process.

oUsers will manually review the error report and update necessary lines and reprocess the ‘UBE Verification’ until all lines are validated and pass verification.

Client: Molina Healthcare, Long Beach, CA

Project Details

Duration : Aug 2011 – April 2015

Role : Senior Systems Analyst

Environment : JDEdwards EnterpriseOne 9.0

Databases : SQL Server 2008

Tools : OneWorld Toolset UBE /ERW, Table Design Aid (TDA), Table Conversion Tool.

Project Scope & Responsibilities

Lead the Finance, HR and Payroll team for support, enhancement and maintenance of Oracle Enterprise One implementation

Participate and lead discussions to analyze user requirements, prepare design documentation, supervise development work and formulate strategy for fulfilling user expectations.

Guide team members on design of complex interfaces and customizations

Project management for internal projects and ensure timely completion of projects

Lead successfully the Enterprise One tools upgrade project to the new toolset 9.1.2. Implemented role based E1 pages for all modules.

Client: Lang Holdings/Perfect Timing INC, Waukesha, WI

Project Details

Duration : Mar 2009 – Jul 2011

Role : Senior Systems Analyst

Environment : OneWorld Xe

Databases : AS/400

Tools : OneWorld Toolset UBE /ERW, Table Design Aid (TDA), Table Conversion Tool.

Project Scope & Responsibilities

Team lead for implementing all modules in Financial and Distribution area. Project management for Finance and Distribution areas, weekly project review meetings, updating top management about the project status and addressing integration issues with other systems.

Participate and lead discussions to analyze user requirements, prepare design documentation, supervise development work and formulate strategy for fulfilling user expectations.

Configure JD Edwards software to map the client business processes, configuration in the CRP environment including automatic accounting configuration for finance and distribution modules, PO approval processing and budget definitions.

Prepare functional specification, data upload template to convert fixed assets from legacy system in the JD Edwards fixed asset system

Configure depreciation rules including defining new Depreciation formulas to meet business requirements of Depreciation for accounting and tax ledgers.

Client: Jackson Family Enterprises, SantaRosa, CA

Project Details

Duration : Nov 2008 – Feb 2009

Role : Senior Programmer Analyst

Environment : JDEdwards 810

Databases : AS/400

Tools : OneWorld Toolset UBE /ERW, Table Design Aid (TDA), Table Conversion Tool.

Project Scope & Responsibilities

Developed Price List report

Worked on Inventory Comparison Interface

Developed JDE to HighJump Discrepancies by Lot

Worked on Regal to Vinlux Data Comparison Interface

Developed KJ – Beverage One Inbound Sales Order Processing for Regal

Worked on Vinlux Retail Invoice Process

Resolving the Daily Tickets raised by users

Client: Meyer Corporation, Fairfield, CA

Project Details

Duration : June 2008 – Oct 2008

Role : Senior Programmer Analyst

Environment : OneWorld Xe

Databases : AS/400

Tools : OneWorld Toolset UBE /ERW, Table Design Aid (TDA), Table Conversion Tool.

Project Scope & Responsibilities

Customizing the OneWorld Sales Order Processing

Developing the Credit Card Processing in OneWorld Sales Order Processing

Developed Purchase Order and Purchase Order Change reports

Developed functionality for the UBE output to be sent as an EMAIL attachment automatically

Maintaining the Schedule Jobs

Client: FirstGroup America, Chicago, IL

Project Details

Duration : Jan 2008 – May 2008

Role : Senior Programmer Analyst

Environment : Windows 2003, JD Edwards 812

Databases : SQL Server 2005

Tools : OneWorld Toolset UBE /ERW, Table Design Aid (TDA), Table Conversion Tool.

Project Scope & Responsibilities

Copied customer ledger inquiry application as a custom application and customized to display the Customer’s Primary Business Phone number and Payment Terms in the Header and validated custom tables

Customized standard receipt entry application, to validate with customer ledger file and to accept wildcard in the Customer number field to show all open Invoices for all customers.

Account Balance Inquiry application copied as a custom Application And customized to display the Customer’s Primary Business Phone number, Payment Terms and Oldest Open Invoice Date on the Grid.

Worked on Hyperion Interface

Worked on Fuel Interface

Worked on PCard Interface

Worked on TEM Interface

Worked on Vtrack Interface

Developed functionality for the UBE output to be sent as an EMAIL attachment automatically

Part of Production Support

Client: American Honda Motors, LA, CA

Project Details

Duration : Apr 2007 – Dec 2007

Role : JDE Technical Consultant

Environment : Windows 2003, JD Edwards 812

Databases : SQL Server 2005

Tools : OneWorld Toolset UBE /ERW, Table Design Aid (TDA), Table Conversion Tool.

Project Scope & Responsibilities

Worked on conversions to convert data from BPCS to E812 (On Sales, Inventory and Financials)

Worked on Custom Modification to Process Inbound EDI 850 Orders into E1

Worked on Financial Integrity Reports

Worked on Vendor Performance Reports for Purchasing

Go live support on Distribution and Financials

Involved in Setting of Items

Part of Production Support

Debugged numerous business functions, interactive and batch applications using Event rule Debugger

&VC++ Debugger and fixed the issues

Client: Cardinal Health, Piscataway, NJ

Project Details

Duration : Nov 2006 – Mar 2007

Role : Senior Technical Consultant

Environment : Windows 2003, JD Edwards 810

Databases : SQL Server 2005

Tools : OneWorld Toolset UBE /ERW, Table Design Aid (TDA), Table Conversion Tool.

Project Scope & Responsibilities

Involved in customization and implementation of Finance and Distribution Modules.

Customized Order Revisions Application to enable the user to mark records as processed and view the records by filtering Buyer, Processed and Not processed.

Developed Tabular Report Job Cost Variance Analysis Level of Detail is equal to 8 using Smart Fields.

Designed and developed 2 Way Def File Table Conversion for getting data from Citibank Text File to Custom Table

Designed and developed ACE Batch File Table Conversion for getting data from Custom Tables to Citibank Text Files, Multi Format, multiple files and multiple locations on Unix Server

Developed and created a C Business Function called Optimizer

Performance Enhancement in the Custom Application to get the total records count for the given selection criteria

Involved in Sales Order Activity Rules Setup

Created new Order Types like SY and SX used in the various channels like Warehouse, letter of Credit and direct sales

Creation of Line Types

Client: TWS, Washington DC

Project Details

Duration : July 2005 – Oct 2006

Role : Senior Technical Consultant

Environment : Windows 2003, JD Edwards Xe

Databases : Oracle 9i

Tools : OneWorld Toolset UBE /ERW, Table Design Aid (TDA),

Table Conversion Tool

Project Scope & Responsibilities

Customized purchase order entry in header form to give hard error when one of tax fields (tax explanation code, tax rate area) was keyed in and other was left blank as this condition gave hard error only during voucher match.

Developed Fixed Assets Report to show Asset Number, Beginning Asset Cost, Additions, Assets Sold and Ending Asset Cost.

Account Master Category code updates are done using Interactive application for Hierarchical roll up used in Cognos.

Developed Batch Applications to extract the monthly sales information, which will be forwarded for group reporting. The sales information will include in the calculation, standard RSS Rebates, Exception Rebates and Early Cash Payment Discount, which will be grouped by customer and by item.

Developed custom report purchase order by supplier or by Item to provide purchase department required details in required format.

Created a custom report, which gives the details of A/P Open Amount and Due Date for a supplier and also about the PO Detail information.

Client: Lafarge NA

Project Details

Duration : Dec 2004 – June 2005

Role : Senior Technical Consultant

Environment : Windows 2000

Databases : MS-SQL

Tools : OneWorld Toolset UBE /ERW, Table Design Aid (TDA), Business View Design Aid (BDA), Table Conversion Tool.

Project Scope & Responsibilities

Designed, Customized, implemented Batch and Interactive Applications in Finance, Manufacturing and Distribution Modules as per client requirement like Assort Details, Sub-Parcel Details, Worker Bonus, Lot Wise Summary, Daily Stock Report, Update Certified Lot details, Worker Production Scheduler job, Worker Production Month Wise and Worker Production by Date.

Developed process to calculate cost impact of each proposed Engineering change order by comparing ‘before’ and ‘after’ (change) costs. It will give economic impact (cost/savings) information provided to the business functions/roles, which will approve or reject a suggested Engineering Change.

Developed custom module in Shop Floor Management system to maintain work orders.

Developed way bill number tracking application which stores the way bill number, weight, quantity etc. This application is designed to accommodate multiple weigh way bill numbers for each sales order line.

Extensively wrote SQL queries (for test case scenario purposes) to retrieve data from the standard A/R tables. Used Event Rule Debugger and VC++ Debugger at Unit Testing level, to debug JDE source code and Business Functions, respectively.

Worked closely with the client on identifying business needs and technical feasibility.

Client: Cigweld Australia PTY LTD

Project Details

Duration : Aug 2000 – Nov 2004

Role : Technical Consultant

Environment : Windows 2000

Databases : Oracle

Tools : OneWorld Toolset UBE /ERW, Table Design Aid (TDA), Business View Design Aid (BDA), Named Event Rule (NER), Table Conversion Tool, SQL Plus, MS SQL Server ISQL

Project Scope & Responsibilities

A/R Aging Batch Application is developed with flexibility to select customers whose outstanding balance exceeds the minimum balances specified in processing options. It also has several other processing options to evaluate customer performance both in summary and detail modes

Developed inbound interfaces in Inventory and A/R modules to get the Cigweld legacy data into JDE system.

Developed speed status batch application to control the flow of purchase orders depending on type of commodity, in transit routing step and other characteristics related to the PO Detail.

Customized Sales Order application to prevent the status change of the order manually. Programmed and tested Cancel information application called at the point of cancellation to get detailed reason why order line is cancelled.

Created the Applications to enter the card information, days of operation for a lot, pricing history and equipment used in a lot for their Parking module.

Created an NER (N58RS002) to validate the time and display the time in HH:MM format.

Created Applications and Reports to Import the data of Customers and Jobs from their Lakeside system (Excel) to JDE.

Designed UBE’s to extract the Actual Account Balances (F0902) to custom table and to Text file for their Profix system to compare.

Created an Integrity report between F0411 and F4311.

Modified the Voucher Match (P4314) as per client requirements.

Created an Integrity report between F5603B01, F03B11Z1 and F03B11.

Modified Work with Orders Awaiting Approval (P43081) to display the additional information in the Grid and to call the Purchase Order print report

Worked on a Transaction Balance report (R560903) to give the details about the Account Balances up to the current month.

Contact this candidate