Overview

Around 11 years of experience in JD Edwards EnterpriseOne, JD Edwards OneWorld Xe Technical and Development Tools covering Distribution, Manufacturing, Finance, Grower Management and HR including the experience of working with JD Edwards offices - JD Edwards, Denver in US and JD Edwards, Sydney in Australia. Has had the experience to work in over12 JD Edwards implementations.

Application & Tool Release(s)

Oracle's JD Edwards EnterpriseOne 9.0, 8.12, 8.11, 8.10, 8.9, Xe, B733.x

Tools: Release 8.98 / 8.97 / 8.96

Oracle Functional & Toolset Expertise

JD Edwards Foundation Tools, Technical & Implementation Experience

Business Function - C/NER

Performance Workbench

Workflows

EnterpriseOne provided APIs

Forms Design Aid

Enterprise Report Writer

Table Conversion

OMW

Data Conversions & Migrations

Visual ER Compare & Retrofitting

ER Debugger

Interoperability

Electronic Data Interchange (EDI)

XML Publisher

Dashboard

Technical Expertise

Languages C, C++, VC++, Visual Basic, .NET, XML, Java

Databases Oracle 9i, MS-SQL, Server, MS Access

Operating Systems Windows Vista, Windows XP, UNIX, DOS

Environment: JD Edwards EnterpriseOne / OneWorld Xe B73.3.x

Other Web Methods - EAI Tool for Integrations

Employment History

Confidential

Technical Project Lead

Confidential

Senior Technical Lead

Confidential

Technical Lead

Confidential

Programmer Analyst

Confidential

Software Engineer

Confidential

Software Engineer

Confidential

Software Engineer

Professional Summary

Confidential

Project Details

Duration

Role Senior Technical Lead

Project Title Sales & Distribution

Environment: Enterprise One 8.12

• Modifications to advanced preference type business functions for GL Souring (Inventory Sourcing) so that the detail Branch Plant can be defaulted on the sales order detail line based on the advanced preference type. In order for this to work customizations were done to the standard business functions - B4200850 (Preference Calculate Commitments), B4002710 (Preference Driver), B4500050 (F4072 Calculate Price Adjustments), B4002720 (Preference Analyzer), B4200780 (F42UI130 Get/Update Commitment Work File) and B4205230 (Process Commitment Preferences For SOE).
• The sales order detail Branch Plant would be sourced based on the geographic location (zip code) of the customer, customer search type & sales order mode of transport. This enables a single Sales Order line to be automatically committed from a different branch than the header branch, or be committed across several branches. This will increase the chances that an order will be completely filled, and gives users greater flexibility to commit from locations that make sense in their business

Confidential, Grandville, MI - Confidential

Project Details

Duration

Role Senior Technical Lead

Project Title Sales & Distribution

Environment: EnterpriseOne 8.12

• Customization to the standard JDE report R42520 - Pick Slip. All locations were assigned a sequence number. The item locations were assigned the following format ANN-A-NNN where (A=Alpha and N=Number). The first three characters is the zone & the alpha character following the zone is the rack level. The report output was sequenced by location sequence number. The pick list had the ability to pull items in the following order B Zone (Cases),E Zone (Inner pack) & F Zone (Eaches)
• Customization to standard JDE reports R42565 - Invoice & R42530 - Bill of Lading. Development of new report to pay the commission payable based on the tables F4211 & F42005
• Conversion program for Address Book Upload - F0101Z1,F0101 & different other tables of address book
• Conversion program for Customer Master Upload - F0301 & F03012
• Conversion program for Purchase Orders & Purchase Receipts - F4301,F4311,F43121

Confidential, Napa, California - Confidential

Project Details

Duration

Role Senior Technical Lead

Project Title Grower Management

Environment: EnterpriseOne 8.12

• Custom applications using power forms & sub forms for allocating the grapes. This allows the winemakers to see how their supply covers all their programs while focusing on their best, highest return programs. If additional grapes are needed, more can be reallocated from another lesser return program or put under a new contract. If there is over-supply, the grapes may be diverted. Plans can be made sufficiently in advance for over- or under-stock conditions.
• Custom application using power forms & sub forms so to provide ability to allocate inbound grapes to specific crush sites. This allocation is based on the capacity of the given crush sites.
• Custom application so as to give field managers the ability for taking Field Quality Samples in the vineyards. The results of those tests will be stored in the JDE Grower Management files for review and reporting. Because of the volume of tests and their results, this needed to be a simple and efficient means for entering the field sample results.
• Working closely with the applications/JDE files of Farm Maintenance (P40G01),Grower Block Maintenance (P40G02),Grower Harvest Maintenance(P40G03),EUR definitions (P31B0780),Harvest Workbench (P40G032),Harvest Period Patterns, Farming Operations / Grower Weight Tag Receipts (P40G30), Grower Speed Weight Tag (P40G301)
• Grower Sales agents accept products on consignment. They assign pools based on transportation groups. Every shipload for a given grower is a pool that will be settled independently. In addition, each truckload coming in represents a pool.

Every sale was connected to a PO Receipt. The proceeds of each sale are due to the Grower less grower charges, advances, and payments made to third parties on the Grower's behalf. For the most efficient reporting, the ability to do interim "As Of" reports prior to final settlement, a history file was created along with a batch application to update the Grower History table. A Grower Statement was created of one or more reports that read through the Grower History file and group transactions by Pool to determine the amount owed to the Grower, with the detailed back-up shown for verification. When run in Final Mode, the Grower Statement would create the Accounts Payable (A/P) Voucher necessary to pay the Grower. Following development tasks were done to achieve this create Grower History table & interactive editing application. Batch update for Grower History file & reports for Grower Statement and Voucher Creation.

Confidential, Atlanta, Georgia - Confidential

Project Details

Duration

Role Senior Technical Lead

Project Title Workflows

Environment: EnterpriseOne 8.12

• Workflow whenever a case is assigned or reassigned. When the value within the 'Assigned To' field changes for the table F1755 the workflow gets initiated.
• Customize the standard JDE workflow CALLSTATUS & its associated objects N1701080 & P90CG501
• Customize the standard JDE workflow CALLESCAL

Confidential, Washington, DC - Confidential

Project Details

Duration

Role Onsite Technical Lead

Project Title GL, Time Attendance

Environment: EnterpriseOne 8.11

Project Scope & Responsibilities

TWS uses its scientific expertise, analysis and bold advocacy at the highest levels to save, protect and restore America\'s wilderness areas.

• Custom Employee Quick Hire. Similar to vanilla program P060116Q for uploading data into F060116 (Employee master), F0101 (Address Book), F0111 etc. The Employee Quick Hire application allows a user to add employee records to the Employee Master Table (F060116) with minimal data entry. The new employee records will either update the Employee Master (F060116) and Address Book (F0101), or the Quick Hire Transaction table (F060116Z). The Update Master Files processing option on the Action Tab of P060116Q controls which tables are updated.
• Designing of Budget Connect - Revision to Budget Process Design and Implementation. Project was to redesign the existing Custom Budget connect Module consisting of applications like Proxy Budget connect, Time entry, Programs and Projects setup applications, Discretionary Budget, Revenue Budgets, setup applications and reports based on budget connect applications.
• Custom applications for uploading Budget data to GL (F0911). There are four types of data required to complete the budgeting process within Budget Connect: Time Allocations, Project Numbers, Revenue (entered by the Finance Department), and Discretionary Expenses. Create F0911Z1 records in order for it to be uploaded in F0911 for Labor Budget Connect
• Custom reports for Time & attendance

Confidential

Project Details

Duration Sept 2007 - Jan '08

Role Technical Analyst

Project Title Sales Order Management

Environment: EnterpriseOne 8.12

Project Scope & Responsibilities

Founded in 1944, Triple L is one of the largest independent master distributors on the West coast, supplying distributors with a wide range of products into categories such as: Glassware, Beverages, Grocery, Snacks, Tabletop, Bar Equipment, Foodservice, Disposables and Janitorial Supplies.

• Modified sales order programs such as P42101 (Sales Order Entry), P421001 (Sales Order Header Reusable Subform), P421002 (Sales Order Detail Reusable Subform), P421007 (Sales Order Header Reusable Subform) using power forms.

Confidential

Project Details

Duration

Role JD Edwards Technical Lead

Project Title Q2C, O2C, P2P, GL, Job Cost, Address Book, AP, AR

Environment: EnterpriseOne 8.9

Project Scope & Responsibilities

Lafarge is the largest HTML client user of EnterpriseOne. Onsite Technical Lead Consultant for offshore Team Co-ordination team size 8 in India (total team size of offshore in India - 35 resources).

• Making technical design document based on user requirements / specifications & sending it offshore for development mostly for Quote to Cash / Order to Cash / Procurement / Accounts Payable (AP) / Accounts Receivable (AR) / General Ledger (GL) / Job Cost (JC)
• In Quote to Cash, developed bolt-on Applications for a huge module Project Master (The Opportunity for business identified for Lafarge North America, needs to be shared across the product lines to have better visibility of the market), which can be a Quote or a Job Cost Service in EOne depending upon the Lafarge Business Line. This module has around 40 customized objects. Integration between EOne and mapping s/w PC Miler / costing tool Bid2Win. Status Update functionality to track different phases of project using the E1 standard activity rules.
• Workflow requirements gathering. Developing new workflow processes, testing and delivery of the workflow processes. Designed and developed an Item Master Approval workflow which routed newly added Item(s) through a series of departmental approvals before the item actually gets inducted into the Item Master.
• In Order to Cash customizations to programs such as R42565, R42520, R42800, freight to customer etc. Customized Applications P03B2002, P03B202 so to access prior formatted invoices & statements generated thru optio. Due to concurrent enquiry of a customer, there often arises a need to review the already generated Invoices. Standard Enterprise One (E1) does not provide this functionality. This complex functionality in E1 was achieved successfully after working closely with optio & UNIX team. Table conversion for an E1 outbound process from F4981, F4211 & F42119.
• In Procure to Pay (P2P) customization to programs such as R43500, R43520, R43512, P4312 & new developments for Spend Analysis on reporting code, supplier wise. Customized master business functions XT4311Z1 & XT4311Z2 so that the approval route and transaction originator need to be that of the requisitioner instead of the buyer while generating a "Blanket Purchase Order" and the approvals will properly go to the correct management team. Automated the purchase order receipts process (P4312) in E1 so that the user while receiving any quantity just scans the bar code for the purchase order no & item number instead of typing them. The navigation from one screen to another is also automated.
• In Address Book, automate the creation of the ship to address book record and customer master record from the Project Master using the following R01010Z, R03010Z, R011110Z, R58730101 and R5849001.
• Designed & Developed table conversions programs for various inbound & outbound processes of E1. Also worked closely with web methods to facilitate them design their integration processes with EOne. Conversions programs for F40095 (Default Location / Printers), F42008 (Order Hold Constants), F43008 (Approval Levels)
• P2P / Accounts Payable (AP) reports such as Segmentation Spend Amount by Category, Segmentation Spend Amount By Supplier, Order commitment analysis,
• POs Created Without ORs, R5843420- PO Change Report (Purchase Journal),
• Inventory reports such as Inventory Receipt Register (R5843512), R5841116 Non Usage
• Customization in AR such as P5903B02 (View Statement / Invoice)
• New report developments for GL such as Post-Interface Integrity, Trial Bal with DB output, Journal Entry Detail By Cat Code, Received Not Vouchered Account Analysis, Trial Bal by Object Account, Unmatched T2(document type) Detail Report
• On the sales order like ship to over-rides, tax info etc. The entire credit and re billing process was handled via EDI 850 Inbound process. All the credit orders were written to F47011, F47012 and F4706 as reversed entries. For the re bill process the entries were written as is and a custom application was developed over the EDI files to rectify the data for re billing before the EDI process R47011 brought the data in JDE SO system(F4211, F4201, F4006).
• Development & Maintenance of EDI Lockbox interface (823/CREMUL) from Bank to JDE. The EDI interfaces were developed and mapped for the bank feeds (containing payments and checks info) coming in via Gentarn files.
• The EDI lockbox tables F47111 (EDI Lockbox payment header), F47112 (EDI Lockbox Header -Transaction), F47113 (EDI Lockbox Detail -Batch) and F47113 (EDI Lockbox Payment Detail) were mapped and set up for the data feed from Gentran.
• Mass Price Changes for Inventory Price Table - F4106
• Customization in work orders such as Work Order Revisions (P17714),Maintenance Work Order Report (R5848425)
• Design & Development for the different functionalities such as Emailing (in email client) E1 report PDF output from print queue once the batch job is run, Issuing Print Immediate on certain batch jobs on runtime, display work center messages on E1 PDF for the batch job run
• Visual ER Compare & retrofitting. Used E1 tool Performance Workbench for performance tuning of E1 batch jobs.

Confidential, Dallas, US - Confidential

Project Details

Duration

Role JD Edwards Technical Consultant

Project Title Inbound - Enterprise One 8.9

Environment: JD Edwards - Enterprise One 8.9

Project Scope & Responsibilities

Inbound - Sales Order Process for Advanced pricing

• Optimizing the Inbound - Sales Order Process for Advanced pricing thru the XML wrapper
• Customizing the Sales Order Master Business Function which is called by the XML wrapper

Confidential

Project Details

Duration

Role JD Edwards EnterpriseOne - Technical Consultant

Project Title SAR Fixing - Enterprise One 8.10 / 8.9 / Xe

Migration - Enterprise One Xe to Enterprise One 8.9

Environment: JD Edwards EnterpriseOne 8.10 / 8.9 / Xe

Project Scope & Responsibilities

SAR Fixing for Distribution/Logistics

• To allow users to run R42800 (Sales Update) for consolidated invoices where the companies are different for each sales order and where Vertex taxes are being applied
• R47121 (EDI Product Data Activity) needs correction to write correct quantities when using an R replacement in PACD and entering quantity within 47 detail tables in a non-primary uom
• Not to have the Requested date printing in R42565 (Invoice Print) as it is incorrect when working with item summarization, for several lines which have different Requested Dates or not doing item summarization in R42565, when the Requested dates are different
• The Item Master Tag file F4101T was merged into the Item Master (F4101) file in ERP 9.0. The UPC Number (UPCN) should be retrieved from Item Master in ERP 9.0. for R42800 (Sales Update)
• System should not be generating error in jde.log "failed to find requested column BNOP in F76111B when running programs R76B4000, R76B4016, R76B4003, R76B4007, and R76B201. The application runs correctly. The table now contains the new field BRNOP, not BNOP
• The R42810 (Print Sales Journal) should run if called from R42800 (Sales Update), the data selection for this report should pick up data selection from R42800. The error in the WC "Invalid Data Selection" should be more specific

Developed Table Conversion programs for migration from Enterprise One Xe to Enterprise One 8.9 for tables such as

• F4093 - Item/Customer Group Relationship
• F4330 - Supplier Selection File
• F4331 - Quantity Breaks File
• F4311Z1 - Purchase Order Detail Unedited Transaction Table

Confidential, Nagpur, India - Manufacture & construction of turnkey projects (Power Transmission)

The project based company having the turnover of around 800 cores with the manufacturing base at Nagpur, Jaipur, and Jabalpur and head office at Bombay with employees of around 2500. They are in the erection of electrical transmission lines business for the states electricity boards.

Project Details

Duration

Role JD Edwards Sr. Technical Consultant

Project Title Manufacturing - Quality Management Module

Environment: JD Edwards - OneWorld Xe (now JD Edwards EnterpriseOne)

Project Scope & Responsibilities:

JD Edwards provides Quality Management Module, but it does not suffice the Client requirement regarding the Offerings made by the Vendor for Inspection (QC) of the Items. Neither JDE takes care of observations for neither Tests nor sampling methodology. KEC required capturing all these details of the Offerings made by the Vendor to them and then performing sampling on it.

New Development:

• The Solution for the above was provided by creating Bolt on Tables namely Sampling Definition Master (F57RP804), Sampling Plan Header (F57RP805), Sampling Plan Detail (F57RP806), Observations for Specifications (F57RP807).
• New Interactive applications namely Sampling Definition Master, Sampling Plan Header/Detail (P57RP804), Observations for Specifications(P57RP807)
• Copied and Modified the standard JDE program - Enter Test Results Application P3711 for JDE to validate the observation results based on allowed values of TestIds
• Interactive application for providing upload of masters of TestIds, Specifications, Specification Details and Preference Profile
• Re-Sampling facility for a failed Specification is also provided which works on similar grounds.

Confidential, Brisbane, Australia - Leading manufacturer in plumbing bathroom and bathroom renovation supplies

Confidential, is a big plumbing house in Australia which implemented all modules of JD Edwards. JD Edwards, Australia carried out the implementation.

Project Details

Duration

Role JD Edwards Technical Consultant

Project Title Implementation of JD Edwards OneWorld Xe

Environment: JD Edwards - OneWorld Xe

Project Scope & Responsibilities

• Customization and development of interactive applications mostly related to Distribution - Sales Order Management
• Modified the Sales Order Entry Program (P4210) so that the user has ability to refer a Sales Order to a Branch based on the geographical location of the Delivery address
• Modified the Confirm Shipment Program (P4205) in such a way that when a location is to be created, it will detect whether it is a "Special Location".
• Modified Sales Order Entry (P4210) Program to gather sales order information into the Sales History Work File - F55UI4219 so as to load the data into the Sales History Tag File F5542119. This tag file will hold the additional detailed costs / rebate levels for each sales order line. This will assist with detailed margin analysis and profitability, by customer, by product item.
• The set-up of the Shipment Confirmation Application is such that all users will be instructed to inquire on a Sales Order by number and then use the Form Exit "Confirm Shown Rows" to Confirm Ship the select Sales Order. A potential risk exists whereby the User unintentionally Confirm Ships all open Sales Orders. It is then quite difficult to reverse the Confirm Shipment process. As a solution to this Sales Order Shipment Confirmation Application (P4205) was modified.
• Modified the Work with Printers application (P98616) so that the printer output is directed to a particular printer based on the printer's relationship to the terminal the print request was issued from. This table of printer to terminal relationships is maintained at each branch.
• A batch program was developed to calculate the commission payable by the Despatch Branch to the Originating Branch and generate General Ledger Journal entries. This program creates an audit report of Sales Detail Lines that have been referred and any exception errors that may occur.
• Developed a batch program to Extract Supplier Price To Cost Work File

Modification of JDE Program(s):

• P4210/ T4210 - Sales Order Processing.
• P4205 - Confirm Shipment.
• P4006 - Order Address Information
• P98616 - Work With Printers Application
• P41202 - Work With Item Availability

New Development:

• Branch Post Code Relationship Maintenance application
• Post Code Maintenance application - P550117. To facilitate the speed and accuracy of entering an address, One World has the ability to retrieve the City, State and country from the Post Code Table F0117. This table is populated with Post Codes details supplied by the local Postal Authority. This is a Master maintenance application where the user can Add /Update/Delete Postal codes as and when required.
• P5501BDW, copy of the base Address Book Word Search Program P01BDWRD
• Developed batch program using Report Design Aid for capturing the cost parameters whenever a Sales Order is keyed in

Confidential, Mumbai, India - Confidential

Project Details

Duration

Role JD Edwards OneWorld Xe Technical Consultant

Project title Interface between JD Edwards (Distribution - Transport Management) and Terminal Automation System

Environment: JD Edwards - One World Xe

Project Scope & Responsibilities

The objective was to build an interface between JDE and TAS (Terminal Automation System) system such that JDE provides filling data (products and quantities) to TAS in form of a pre-load packet (flat file) and TAS sends 'Actual' data (time of filling, Ambient density and temperature, seal numbers) back to JDE in form of a post-load packet.

New Development

• Business function 'AddSubsystemRecordForTAS' (B5603001) which wrote a Subsystem record to the Subsystem Job Master table (F986113) along with the subsystem UBE data structure consisting of Load Number and Planning Depot
• Created a new custom Subsystem UBE (R560301) using Report Director which continuously polls the table (Standard JDE subsystem functionality) and on finding a record called the 'Invoking Business function' (B5603002) with 'Planning Depot' and 'LoadNumber' as parameters.
• "Invoking Business function" (B5603002) which called the Location Specific Business Function
• "Location Specific Business Function" (N5603002) - concatenated all the information from JDE files in format required by TAS and wrote it to a file path on the enterprise server with filling data.
• Another Business Function (B5603003) - an "External Polling Program" then picked this file and transferred it to a directory on the TAS system

Modified JDE Programs

• Modified the JDE base interactive application - P4960 (Load Build)
• Modified the Load Header table (F4960) using Table Event rules

Confidential, Mumbai - India

Project Details

Duration

Role JD Edwards OneWorld Technical Consultant

Project Title Address Book synchronous integration between OneWorld (B7332) and Siebel as a proof of concept

Calling E1 Sales Order Business function thru GenJava

Environment: web Methods Enterprise EAI tools, JD Edwards - OneWorld B733.2

Project Scope & Responsibilities

• Carried out Address Book synchronous integration process between One World and
• Siebel as a proof of Concept
• Calling E1 Sales Order Business function thru GenJava
• Identifying the data to be transported from / into JD Edwards
• Designing canonical table
• Process Mapping
• Technical Set-up for Integration Testing
• Test Data Creation