Project Sales

Pankaj S.

[A] Summary

. Over **+ years of experience in IT industry which include

. Over 8 years of experience in JD Edwards as Project lead

. Worked on migration of data from legacy databases to JD Edwards

OneWorld. Used table conversion tools to convert data

. Strong hands-on experience on all EnterpriseOne Tools like OMW

including Table design Aid (TDA), Forms Design Aid (FDA), Business

View Design Aid (BDA), Report Design Aid (RDA), Data Dictionary (DD),

Universal Table Browser (UTB), Processing Option Design Aid (PODA),

Data Structure Design, Business Function Design Aid (BFDA)

. Expertise in ER Debugger tool Extensively in Applications, Reports,

Business Functions (NER &C)

. Worked on Create Form Design (CFD) 6.2 & version 3.0

. Trained on JD Edwards EnterpriseOne Xe & 8.11, 12 net changes

. Excellent problem-solving and communication skills and is a team

player

. Good communication skills, systematic approach, and quick adaptability

to new technologies

. Ability to work effectively in a fast paced environment

. Excellent analytical skills & good communication skills

[B] Skillsets

ERP: JD Edwards Enterprise One, MBS Navision 3.7

Environment: JD Edwards EnterpriseOne Xe, 8. 11,8.12,9.0

Operating System: WINDOWS 98/NT/2000, Windows XP

Report Design Tools: CFD 6.2,BI Publisher 11.1.1.5

Databases: MS Access 97/2000, MS SQL Server 2000

Web Technologies: HTML, ASP.NET, VB script

Query language: SQL

Languages & Tools: C, C++, Java, VB.net, J2EE, MS Office, MS SQL

Server 2000

JD Edwards Tools: Report Design, Form Design, Table design,

Business View

Design, Business Function,

Table Conversions, Debugger

[C] Project Experience

B/E Aerospace

B/E Aerospace, Inc. is the leading provider of interior products and

solutions for the commercial, business jet, and military aircraft markets.

B/E Aerospace has implemented JD Edwards E1 version 9.1 on it's North

America location.

> Project Details

Duration: July 2013 - Present

Project: JDE 9.1 Implementation

Role: Team Lead

Environment: Platform: JD Edwards 9.1,BI Publisher

> Project Scope & Responsibilities

. Auto Serialization:

The existing standard serial assignment is a manual process in E1.The

shiping process consumes too much time to process in current solution.

The auto serialization will assign the serial # in automated way based

on the production #, WO # and sales order detail records. Created new

function to assign the serial no to each item which are processing

through the shipment application.

The production reassignment application which is used for reassigning

the production # from FAI to B01 order.Added new feature of auto

serialization to this application(P34404) which will reassign the FAI

order which never ship serial # to B01 orders item.

. Flexi Accounting:

When an Item Cost is changed, the WIP Revaluation program (R30837) will

revalue the production costs for open work orders in the Production

Cost table (F3102), based on the latest item cost. The report displays

any differences between the original work-in-process values and the new

WIP values. This report does not support Flex Accounting, so critical

information are not populated in the F0911 records created by the

report. A new Report is designed and developed which is just called

after R30837 is finished.

Using JE Edit Line Business function (B0900049) is used to reverse OR

voided the existing entries, New records with Flexi accounting

information were created in F0911 and finally update all the processed

records with a flag so that those records will be filtered in the next

execution.

. R2R Interfaces:

1. Load Outbound GL Interoperability:

The purpose of this interface is to facilitate the automatic loading of

externally created allocation journal entry information into the E1

F0911 Outbound Interoperability table (F0911Z4) once the data has been

approved. Input - B/E Aerospace site finance departments prepare

monthly allocation entries in excel and some of the journal entry lines

need to be processed in JDE World rather than E1.This program will load

the entries for JDE World into the E1 outbound G/L Interoperability

table, FMW will process these records and populates corresponding

tables.

2. Cenidian Interim Solution :

This interface will take bi-weekly extract from Ceridian and process it

into a single file for E1 and a single file for World to process. All

the records will be assumed to be in a single currency code coming from

the processing option. Convert the Delimited file into a 8 column work

table. Process both the E1 and World Interim tables. All the while

reporting all records being written to various final tables, page

breaking on each target system/Currency. Output/Results - This

interface will produce an E1 J/E by populating fields in the Journal

Entry Batch table (F0911Z1) for companies operating in E1.For companies

still operating in JDE World, this interface will populate the outbound

Journal Entry Batch table (F0911Z4) for extraction and transmission to

JDE World using FMW. Since payroll processing is an external operation

an interface is needed to record the payroll expenses in to the General

Ledger Batch input table (F0911Z1) and finally in to the General Ledger

Detail table (F0911).

3. American Exp P-Card Interface:

This interface will produce an E1 J/E by populating a minimal amount of

fields in the Journal Entry Batch table (F0911Z1) and also populating

the outbound Journal Entry Batch table (F0911Z4) for extraction and

sending to JDE World.

. The ST/OT order Item Revision Planning :

Standard E1 transfer order entry does not facilitate the population of

the item revision (F4311.MERL) on the related purchase order. To

resolve this issue the standard BSFN B4200311 is modified and while

creating Purchase order related Item revision level planning info were

fetched NER to update Item Rev and Drawing Revision in F4311.

. Check Printing Program:

R40572,R40573 were customized for USA and Canada check printing as per

business requirement.BI Template for the these report were created and

mapped for single and continuous and reverse side check printing.

. CFE Program Management Utility:

This application is designed to waive the manual process involved in

CFE Item program utility. The manufacturing engineer will need to email

the program manager after the MBOM is released. After the program

manager identifies items as BE Purchased or CFE, the program manager

will need to email the purchasing program manager that items are ready

for their review. This adds manual steps to a process that is currently

automated. The manual process could lead to possible delays in

shipments, penalties, future lost sales and strained relationships with

customers as items are not purchased or CFE is not tracked in a timely

manner.

. Raw Material shortage report:

The intent is to determine raw material in the parts list that is

short. The report will subtract hard commits (both on sales orders and

work orders) from on-hand inventory, and apply remaining inventory to

the oldest soft-committed demand .Supply and demand inclusion rules

will be used to define what statuses are to be considered for

allocation processing. There will also be a processing option that will

be used to identify inclusion rules for orders that are to be

considered as hard commits for sites not using hard commits. Demand

date for sales orders will be the sales order pick date and demand date

for work orders will be the work order parts list request date for the

component item. In case of both work order and sales order demand on

the same day, a processing option will determine whether a sales order

or work order has priority. In the case of demand for multiple sales

orders or work orders on the same day, inventory will be applied by

priority code if the priority code option is selected from the

processing option. Raw material is defined by the GL class code. This

will list the work orders that cannot be release (but should be) due to

material short.

FirstQuality - USA

> Project Details

Duration: Apr 2010 - July 2013

Project: First Quality

Role: Project Lead

Environment: JD Edwards Enterprise One 8.12

Team Size: 6

> Project Scope & Responsibilities

> OTM (Oracle Transportation Management)

. AutoEDI:

The Primary purpose of this project was to remove manual intervention

involve in EDI module and remove hard coding done in the subroutines of

translators. It is divided into four sub modules

1. Item Xref (consolidation)

2. Preprocessor (in R47011)

3. Inbound ASN process

4. Inbound Invoice Process

My Job was to study and understand the complete process involved in

AutoEDI and write the functional specification for all above mention

sub modules. Forward and share the knowledge with Offshore team for few

modules. Development on ASN and Invoicing modules were done by me.

After develpment I was also involved in the integration testing with

other Onshore team members.

. Uploading shipment no generated in XML by OTM to general ledger.

Shipment no generated by OTM was not being captured for uploading to

F0911Z1 for Batch Voucher Upload . The XML parser BSFN B49T0600 was

modified to capture the value of XML node with title "Shipment ID" and

updated to EDI tables F47041 and F47042 which updated F0911Z1.

. Shipment Processing for Total quantity, Volume and weight

Sales order confirmation export UBE process the shipment with Sales

confirm status and generate the XML file which is passed to OTM for

further process at OTM side. The processed shipment was not providing

the actual total quantity,volume and weight details to OTM for each

order .B49T0800 was modified to calculate total qty,volume and weight

for each order excluding the canceled line order and updated the XML

file with new Nodes of Total volume,weight and qty for further process

at OTM side.

. OTM/E1 Interface Monitor

There are numerous components involved in integration of the Oracle

transportation management system and E1, to exchange information

between the two systems. When problems occur, there is currently very

limited visibility into where the breakdown in the process occurred. To

Monitor the same BSFN B49T0020 was modified to write monitored record

after processing F4211 and F49T211 records.

. Financial Reporting UBE

(R5509205A ) Monthly Income Statement financial reporting

(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

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 ie Print pick slip, Reprint,cancel shipper, RMA receipt

. Variance Reporting

Work Order variance in progress uses work order, Work order routing

and production cost to calculate efficiency variance . There are

different types of efficiency variance and they are discriminated based

on the cost type. Different types of variance associated to work order

are Labor, Material, Variable and fixed variances and each have there

own formula for calculation against net amount,gross amount and

Phantom cost.

. Sales Force

Sales force application which extract advance pricing and base pricing

detail for last order and last transaction order of six months for each

product sold to different customer in that particular time frame.

BAXTER - USA

> Project Details

Duration: Sep 2009- Mar 2010

Project: Baxter

Role: Team Lead

Environment: JD Edwards Enterprise One 9.0

Team Size: 15

> Project Scope & Responsibilities

. Understanding the requirement of all the modules in the Baxter and

depending on the requirement and time limit the object is shared

among the team. Interaction and knowledge sharing for better

understanding of the functionality with developer also after

development code review and testing on all the modules individually

and integration testing was done by myself.

. Modules worked on for this client are as follows:

I. Worked on Advance preference for Billing Agent and frozen product.

Custom Frozen Product preference logic to be utilized during order

entry. New customized business function to process Frozen Product and

Billing Agent rules and determine whether sales order lines need to be

placed on hold, if an invalid or non-existent rule is determined for

Frozen Products. Alternatively, this logic determines scenario's where

the Ship-to address on the sales order lines will be overridden in the

case of Frozen Products. For Billing Agents, the business function

will check whether a credit needs to be granted to the original sold-

to addressee by adding credit lines to the sales order and whether the

payment terms of the invoice need to be modified. This business

function will need to be called within the Sales Order Entry

application to allow Inbound EDI Order processing batch applications

to also invoke the function.

II. Pricing Adjustment for Credits from History :The application of

restocking fees at the line level is being dealt with standard

configuration of advanced preferences and price adjustments. This

standard configuration should also apply in scenarios where a credit

order is created from history. However, in these instances the price

adjustment does not apply. The purpose of this enhancement is to allow

the system to apply a price adjustment when it has been setup to apply

on a price over-ride, on orders created from history. This enhancement

is conducting all processing using cache records and internal business

functions

III. Re-Invoicing: The purpose of this enhancement is to easen corrections

made within the system that require two separate transactions to be

carried out - a credit and a debit note. The enhancement builds on

standard credit-from-history functionality to create either

simultaneous debit lines or debit orders, based on the type of changes

the user is attempting to make.

IV. RMA - Mode Of Transport (MoT), Unit of Measure (UoM) and Facsimile

(Fax) Number Additions: The purpose of this enhancement is to bridge

gaps in standard functionality allowing customer service

representatives (CSR) taking calls to update information within the

Return Material Authorization (RMA), without having to go to the

individual orders the RMA spawns to update that data. In certain

scenarios such as a credit with a related receipt, segregation of duty

controls will be in place to prevent a CSR from updating the related

purchase order.Uom conversion will be taken care by using the standard

functionality.

Paper Magic - USA

> Project Details

Duration: 12 Months

Project: paper Magic

Role: Team Lead

Environment: JD Edwards Enterprise One 8.11

Team Size: 8

> Project Scope & Responsibilities

. Understanding the requirement of all the modules in the Paper Magic

and depending on the requirement and time limit the object is shared

among the team.

. Customization on Purchase order application, Work order and Variance

calculation in the manufacturing modules. Which contains number of

reports,application and also business function for credit card

validation and calling RPG program thru JDE.

. Customization on P4210 for the for the back order process,which was

achieved by modifying B4200310 and B4200311.In distribution module I

have also customize on R42520 as per business requirement.

. The unit testing is done against test script provided from On site.

The through Testing is done for all the objects before delivery to On

site Team.

Lafarge

> Project Details

Duration: Mar - August 2009

Project: Lafarge

Role: Technical consultant

Environment: JD Edwards Enterprise One 8.12

Team Size: 6

> Project Scope & Responsibilities

. Understanding the Setups and business process of Lafarge as per the

SPC documentation and implementation is done based on it

. Customization of P42101 which uses MVC architecture . I have done lot

of customization at the front end level on P42101 and the back end on

View controller .View Controller which has been customized to update

F4211 for User reserved fields.

. Variance calculation for scrap engineering Work,Labor and work Order

depending on different csl class set in Bill of material. Also set up

for the Different Item in the BOM table was taken care Development and

customization of Transport Module application and report which uses a

number of Customized Plug & Play NER's . The respective NER's

activate OR deactivate depending on the User, Company and Line of

Business.

Tops Securities Pvt. Ltd.

> Project Details

Duration: January 2008

Project: Tops Securities Pvt. Ltd.

Role: Technical Consultant

Environment: JD Edwards Enterprise One 8.12

Team Size: 8

> Project Scope & Responsibilities

. Understanding the Setups and business process of Tops Securities

. Development of customized applications for uploading data

. Development and customization of HR Module application and report for

attendance sheet update

. Development of Work Flow process for approval of more than 16 Hr

worked per resource depending on which Duty worked per day is updated.

The process takes care of escalation rules.

. Development of Table conversion fro uploading data in F0101 etc.

Parker

> Project Details

Duration: December 2007 -

Project: Parker - Asia Pacific

Role: Technical Consultant

Environment:Create!form version 6.2

Team Size: 1

> Project Scope & Responsibilities

. Basically this is a Migration Project from Create!Form Version 2.7 to

Create!From version6.2

. Understanding the Technical Specs which has been sent from client

. Understanding the technical design of different overlays and layout

based on various location of Parker

. Based on Technical requirement discriminating the text O/P file from

world soft into different sections and mapping all the required data

on the Create!Form

. The different overlays of different location of Parker were

accommodate in a single object of Create!From and depending on the I/P

text file from Wold soft the Create!Form pick up it's corresponding

overlay and sub forms. This was achieved using Project Organizer and

variable sub form functionality of Create! Form 6.2

. Depending on the I/p File, Create!Form 6.2 divide the file into

different sections and it's corresponding data is being mapped on the

form and the same is redirected to the Create!Form Sever through

Create!Form Project Organizer functionality

Crocs - Japan

> Project Details

Duration: August 2007 - January 2008

Role: Technical Consultant

Environment: JD Edwards Enterprise One 8.11

Team Size: 5

> Project Scope & Responsibilities

. Understanding the Technical/Functional Specs which has been sent from

Onsite

. Understanding the Setups and business process of Crocs - Japan

. Development of customized reports on Invoice and Pick Slip,

applications & business functions

. Development on Create form design for the E1 customized report

(Invoice and Pick slip)

. UTC Date time methodology

Crocs - Canada

> Project Details

Duration: January 2007 - July 2007

Project: Crocs - Canada

Role: Technical Consultant

Environment: JD Edwards Enterprise One

8.11

Team Size: 4

> Project Scope & Responsibilities

. Understanding the Setups and business process of Crocs - Canada

. Development of customized applications for uploading data

. Development and customization of Sales Commission Report for uploading

data

. Development of Table conversion fro uploading data in F03012, F4106

etc

. Development on Create form design for the E1 customized report

(Invoice, Pick slip, Proforma Invoice and Cheque Printing)

Lafarge - USA/South Africa/ Malaysia

> Project Details

Duration: March 2005 - December 2006

Role: Technical Consultant

Environment: Client End: JD Edwards EnterpriseOne 8.9

Server End: Oracle 8.1.7 on Unix Server

Team Size: 8

> Project Scope & Responsibilities

. Worked on modules - Shop Floor Mgmt, Advanced Pricing System

. Detailed study of technical specs

. Development of customized reports, applications, table conversions and

business functions

. Carried out Technical documentation

. Debugging of Applications & Report using One World Event Rules

Debugger

. Testing of Applications and Reports

. Creation of Versions and PO setup

. Created an application to adjust payable rates by branch plant,

carrier, ship to and truck type at a quote level and updating the

master rate tables

. Created an UBE to display hours worked, duration, number of entries,

workstation and machine ID for prior period

. Created an UBE to display Freight Charges for each order and load. It

shows the maximized loads

. Created an UBE to display Monthly EOM Analysis of BP

. Created an UBE to display Weekly EOM Analysis of BP

. Created a Table Conversion to transfer data from excel sheet to JD

Edwards Table

. Created a Table Conversion to transfer data from JD Edwards Table to

CSV file

. Created an UBE to display the annual budget of Shop Floor management

for given Branch Plant and Work Center

. Created an UBE to display personal payments made by cardholder (ignore

corporate payments) in order to calculate the Running personal balance

. Created an UBE to updates the Forecasted price, FTC and Rebates (APS)

. Worked with a JD Edwards OneWorld Xe to EnterpriseOne 8.9 Upgrade

project (Retrofit)

[D] Other Experience

POBC (October 2003 - March 2005) - Programmer

Responsibilities: Responsible for working as Software programmer

Rizvi (September 1999 - September 2003) - Programmer

Responsibilities: Responsible for working as Software programmer

Key Achievement in JD Edwards:

. Worked for JDE offshore support projects for 'Lafarge North America'

client

. Created an application to adjust payable rates by branch plant,

carrier, ship to and truck type at a quote level and updating the

master rate tables

. Created an UBE to display hours worked, duration, number of entries,

workstation and machine ID for prior period

. Created an UBE to display Freight Charges for each order and load. It

shows the maximized loads

. Created an UBE to display Monthly EOM Analysis of BP

. Created an UBE to display Weekly EOM Analysis of BP

. Created a Table Conversion to transfer data from excel sheet to JDE

Table

. Created a Table Conversion to transfer data from JDE Table to CSV file

. Created an UBE to display the annual budget of Shop Floor management

for given Branch Plant and Work Center

. Created an UBE to display personal payments made by cardholder (ignore

corporate payments) in order to calculate the Running personal balance

. Created an UBE to updates the Forecasted price, FTC and Rebates (APS)

. Working with a JDE OW Xe to EnterpriseOne 8.9 Upgrade

project(Retrofit)

[E] Other Industry Experience

BITRA (June 1997 - June 1998) - Technical assistant

Responsibilities:

. To design & develop programs for textile machines

. Integrating that with Auto camera captured data.

. Updating the final concluded data to the system.

. Generating reports for reporting purposes on daily basis.

. Co-ordination with other team members for executions.

[F] Training & Education

. Bachelor's Degree in Engineering (Electronics)

. Training on JD Edwards XE, Oracle Enterprise One 8.11

[G] Contact Information

*************@*****.***, Tel: 336-***-****

Contact this candidate