Sales Manufacturing

Venky Gumpula 412-***-**** 630-***-****(W)

Over Twelve years of experience in IT Industry, currently working as

a senior Oracle JD Edwards EnterpriseOne (PeopleSoft E1/ Oneworld XE)

Implementation and Upgrade specialist. Very strong in the analysis, design,

development and implementation of JD Edwards Enterpriseone and JD Edwards

World business applications. Versatile team player with excellent

analytical and problem solving skills, ability to work with people at all

levels. Has extensive work experience in

. JD Edwards/Peoplesoft Enterpriseone 9.0,8.12,8.11,8.10, 8.9, ERP

8.0, One World XE and World A7.3

. One World Tool Set(8.98, 8.97 and 8.9x)

. Enterprise Report Writer (ERW), Crystal Seagate Report tool, Create

Form

. JD Edwards Case Tool (CASE), FASTR, World Writer, Dream Writer

. RPGLE, RPG/400, CL/400, SQL/400,C, C++

. Windows NT, Windows98, UNIX, Citrix

. Modules: Procure t o Pay(PTP), Inventory Management, Sales

order(OTC) (OTC), Advanced Pricing, Real estate Mgmt, EAM,

Finance(FIN) (GL, AP, AR and Fixed Assets), Job cost,

Manufacturing(PDM) and HR/Payroll

. Object Management Workbench (OMW), Table Design (TDA), Business

View Design, Form Design (FDA), Power Forms, Processing Option

Design, Menu Design, Business Functions (BSFN), Business Services

(BSSV), Named Event Rules (NER), Enterprise Report Design (RDA),

XML BI Publisher, Table Conversion tool (TC) and Debugger.

. Developer 2000, Delphi

. DB2/400,Oracle, SQL Server and MS Access

. Implementation and Upgrade Expertise

. Team lead and Techno-functional expertise.

. Expert in handling go-live, post go-live and production support.

EDUCATION &TRAINING

. Master's Degree in Computer Applications

. Trained in World 7.3, One world B73.3.1 and One World XE under JD

Edward's partner program

. Trained in JAVA, Crystal Seagate 7.0 and Create Form

. Brain bench certified ERW report writer

. Attended Oracle training in Workflow 8.9, JDE Security Admin, XML

BI Publisher,

Business services/Web Services and Maintaining C Business

Functions. UPK Training.

. Oracle SOA/BPEL Online training

Summary of Key Professional Skills

. Proficient in working with Enterprise One (JDE) Modules: Financials,

Fixed Assets, Job cost, Order to Cash, Advanced pricing, Procure to

pay(PTP), EAM, Manufacturing and HR/Payroll

. Worked on all phases of software development cycle including Analysis,

Design, Development, Testing, Implementation, Support and

documentation.

. Expertise in creating custom modules using SDLC.

. Expertise in customization of existing and creating new Interactive

applications, Batch applications (UBE) pertaining to user

requirements. Created form user overrides and Vocabulary overrides

. Expert in customizing standard JDE reports (all modules) and Custom

reports. Creating custom reports using ERW

. Expert in Advance Financial report writing. Creating financial,

Row/Columns, Row/Cell Override reports using smart fields, Drill down

and Auto row generation reports.

. Sound exposure in converting JDE world FASTR reports in to One World

Financial reports.

. Expertise in creating Reports using JDE World Dream writer

. Expertise in Customizations, Creating most complex and critical

reports. Created numerous user friendly, performance based flexible

reports and Version level reports (Version Overrides)

. Extensive knowledge in writing data conversion, Interface applications

using Table conversion tool (TC), UBE to convert data from legacy

system to World and One World tables. Creating Data conversion Audit/

Maintenance applications and printing error log reports.

. Experience in Interoperability, Interface (Z-files) and Integration

with third party tools.

. Sound knowledge of Co Existence, Migration from World to One World XE

and to Enterpriseone 9.0 and 8.XX. Upgrading one release/version to

another in World and One world. Used Visual ER compare tool

. Expertise in writing event rules, using available system functions,

business functions and Named event rules business functions (NER).

. Expertise in debugging event rules using ER debugging tools and Visual

C++ debugger

. Extensively used JDE Cache, experience on Master business functions

(MBF)

. Proficient in creating tables, business views, data structures, media

object data structures, processing options and event rules (NER). Data

Dictionary fields

. Extensively used One World provided tool set like OMW, TDA, BSVW, PO,

FDA, RDA, Menu design and Visual ER compare tool.

. Basic CNC activities (OCM mappings, Package build, User profile setup,

Data sources etc.)

. Followed strict JDE naming conventions, programming and development

standards.

. Experience in Object transfers (Package building and deployment) from

Development to System Test Environment.

. Expertise in Defining, analyzing and resolving day-to-day operational

issues with the JD Edwards application, interfaces and data by working

closely with the users, analysts and if required, with the JD Edwards

support line.

. Expert in study and analyzing the business processes.

. Sound exposure in working with legacy system files and transactions

. Expert in Data mapping. Mapped and converted legacy system data in to

JDE (Address book, Sales order(OTC), Item master/branch, Procure to

pay(PTP), HR/Payroll and other Finance(FIN) modules(Fixed assets, G/L,

A/P and A/R).

. Expertise in set up of Business Units, Branch Plants, Item Master,

Document types, UDC, AAI's for Inventory, Purchasing and Sales, set up

Order Activity Rules, Status codes and Menu Options.

. Maintaining delivery schedules and meeting deadlines.

. Experience in Issue resolving, Functional assistance.

. Expert in preparing technical and functional specifications for

customization and new requirements

. User interaction, Training and writing User scripts.

. Logging issues with Oracle/JD Edwards, Accessing Knowledge garden

and other JDE list groups.

. Using Third party tools like Boomerang, OneAssist and OWDLC

. Experience in working with functional team and business users.

. Expertise in estimating time, cost and resource allocation. Reporting

Risks, time and cost escalation of the project to the management/

steering committee.

RECENT ASSIGNMENTS

1. June 2009 - Till Date Industry: Real Estate/Property Mgmt

JLL, Westmont

Working as a senior JDEE1 technical consultant for a financial and

professional services firm specializing in real estate services and

investment management Company. JLL keep adding clients all over the

world and integrates its software with client software. Helping JLL

integrating new clients all over the world by writing interfaces,

creating custom applications and reports in G/L and Procure to

pay(PTP) modules.

. Working on Funding reports, G/L Interfaces, Flat file and XML

file creation

. Application modifications.

. Creating interfaces between JLL and Suncorp Bank, Australia,

Pfizer, HSBC, BOA and Sabre company

. Involved in JDE 9.0 Upgrade

Environment: World and Oneworld Co-existence, JD Edwards

9.0, 8.10, 8.97/8.98 tool set, World A7.3, AS/400.

2. September 2008 - Feb 2009 Industry: Food

KEHE Foods, Romeoville

Worked as a senior JDEE1 technical consultant for an Employee Owned,

privately owned leading US based natural and specialty food

distributors. Client opted for new JDE 8.12/8.97 implementation with

the modules include Sales order(OTC), Advance pricing, Procure to

pay(PTP), Inventory, Finance(FIN) (A/P, A/R, G/L) and hired IBM as

implementation partner. As part of an implementation team helped

client analyzing business process, writing interfaces, data mapping

and conversions, creating custom applications and reports.

. Created daily A/R Inbound Interface between legacy systems and

JDE.

. Modified, tested Sales order(OTC) EDI inbound and Outbound

process.

. Created, modified UBE's and Interactive applications.

. Modifying and running SQL scripts for data conversion

. Go live and after go live support

Environment: Oracle JD Edwards 8.12, 8.97 tool set, SQL Server, Web

sphere.

3. August 2007 - June 2008 Industry: Refinery

Placid, Port Allen

Worked as a senior JDEE1 technical consultant for an independent,

privately owned refinery company which produces transportation fuels

and military jet fuels. Client is implementing new JDE 8.12/8.96

tool set with the modules includes Sales order(OTC), Advance pricing,

Procure to pay(PTP), Inventory, Finance(FIN) (A/P, A/R, G/L).As part

of an implementation team helped client analyzing business process,

writing interfaces, data mapping and conversion, creating custom

application and reports.

. Modified standard JDE UBE's like R42800 to change A/R due dates

and payment terms based on Advance pricing tables.

. Created BSFN to get custom price in to JDE Advance pricing

system.

. Writing Design, Technical and User documents.

. Designed and Created complete Custom Pricing Module in JDE which

replaced existing third party RIMS pricing software. This whole

pricing module is a core module for the company as it manages

everyday petroleum and gas product prices and price changes.

o Replicated RIMS software with strict JDE standards.

o All the prices or price change will be communicated to DTN

Company which distributes and communicates with energy

companies. The pricing module also sends Global, Zone and

customer level messages to DTN for the message

distribution.

o The module also manages the special prices for each

customer based on their contract agreement.

o It interacts with the JDE Advanced pricing and SO modules.

o It manages the items, rules, prices, customers,

customer/item cross reference, Pricing History and

generates related reports.

o Created module related applications, tables, NER's, C

BSFN's, UBE's and Interfaces

o Designing, Coding, testing and validating within the

defined parameters.

Environment: Oracle JDEdwards 8.12, 8.96 tool set, Oracle9.x,

Oracle Application server.

4. August 2006 - July 2007 Industry: Telecom/Electronics

Stratos Intl, Chicago

Worked as a senior PSE1 analyst and technical consultant for a

company who is a leading designer and manufacturer of optoelectronic,

fiber optic, FR and microwave components and subsystems used in

telecom, enterprise networks and video broadcast markets. Helping

client analyzing business process, conversion and mapping it to

Dataflo package as client is migrating from JDE to Dataflo. For a

period of time supported multiple clients at same time.

. Worked on reports, applications, interfaces, bug fixing, testing

and supporting various modules of Oneworld.

. Analyzing business and mapping Sales order(OTC), Procurement,

Inventory, Finance(FIN) and Mfg(PDM). modules between JDE and

Dataflow package.

Environment: One world XE, SP22, AS/400 IBM i Series.

5. September 2006 - January 2007 Industry: Food/Beverages

O'Charleys, Nashville

Worked as a senior PSE1 technical consultant for a leading casual

dining restaurant chain in the Southeast and Midwest area. Helped

client implementing Payroll module as client bought 2 more restaurant

chains.

. Created new interface program to convert acquired company data

in to O'charleys existing system using available Z-Process and

normal UBE/TC conversion.

. Created new business functions to capture current submitted

UBE' to copy, export archive and email it to concerned users.

. Designed, developed and automated complete change management

complying SOX rules.

Environment: ERP 8.0, IBM i Series. Windows NT.

6. June 2006 - July 2006 Industry: Packaging/Supply Chain

PERSECO, Downers Grove

Worked as a senior PSE1 technical consultant for a global company,

which provides packaging and supply chain services to food and

beverages industries. Assisting client for the upgrade Oneworld XE to

JD Edwards enterpriseone 8.11.

. Supporting Oneworld XE, bug fixing and testing.

. Writing data conversion, interface programs, comparing and

merging specs from XE to 8.11 using visual ER

Environment: Peoplesoft Enterprise one 8.11/SP1, Tools 8.95I2,

AS/400 IBM i Series.

7. August 2005 - April 2006 Industry: Financial/Construction

Goldman Sachs, New York

Worked (remote/onsite) as a senior PSE1 technical consultant for a

financial company, helped client for their construction division's

new implementation of PSE1 8.10 with Address book, G/L, AP,

Procurement and Job Cost.

. Writing interfaces to uploading Address book, Vendor, Customer,

A/P and Job cost information using Z- file process, table

conversions (TC), and UBE.

. Extracting payment information from PSFTE1 to PSFT and

upload/feed information from PSFT to PSFTE1

. Creating new reports, interactive (Web) applications including

power forms and customizing standard JDE reports and Interactive

applications.

. Analysis, design, coding and testing by following strict JDE

standards. Writing design, technical and user documents.

Environment: Peoplesoft Enterprise one 8.10, UDB, Solar UNIX

8. November 2004 - August 2005 Industry: Manufacturing

Ralcorp, St Louis

Worked as a senior PSE1 technical consultant for a private label and

store brand food manufacturing company, helping client implementing

Order to Cash, Procure to pay(PTP), EAM and Financial modules.

. Creating Financial and regular ERW reports, Modifying batch and

interactive applications based on user requests.

. Uploading Item master, Item branch, Item Quantities and Item

cost details using Z- file process, Vendor upload and other data

conversion from legacy system to Enterprise one.

Environment: Peoplesoft Enterprise one ERP8.0, SP23, Oracle 9i

9. October 2004 - November 2004 Industry: Manufacturing

Cooper Standard, Auburn

As a PeopleSoft Enterpriseone Sr. consultant for an automotive

manufacturing company Involved in developing and customizing reports

in Financial & Procurement modules.

Environment: Peoplesoft Enterprise one XE SP22, IBM i Series AS/400

10. March 2004 - September 2004 Industry: Service Oriented Charter

Communications, St. Louis

Worked as a PeopleSoft Enterpriseone Sr. technical developer for a

service oriented company, which provides telecommunications,

broadband, cable TV and high speed Internet. Responsibilities in the

job include working in Upgrade (Deloitte managed upgrade from World,

One world XE to Peoplesoft Enterpriseone 8.9) and supporting

Financial (G/L, A/P, A/R), Supply chain Management (Sales order(OTC)/

Inventory/Procure to pay(PTP)), Job cost and HR/Payroll modules.

. Creating Financial and regular ERW reports, Modifying batch and

interactive applications based on user requests. Recreated World

FASTR reports using ERW

. Writing conversion programs and Interfaces to upload tables, Z-

Files and to export as flat files

. Rewriting AS/400 and World programs in to PS E1 8.9

. Retrofits form XE to PS E1 8.9 using Visual ER

. Supporting and resolving production issues, writing technical

and change control documents

Environment: World and Oneworld Co-Existence. Peoplesoft

Enterprise one 8.9 SP3, One World XE SP21, World A7.3, IBM i Series

AS/400, RPGLE, DB2/400, Windows 2000

1999 to Dec 2003 worked as a JD Edwards consultant with iGate(Formerly

Mastech/Emplifi) a former JDE partner, Pittsburgh, PA. Following are the

JD Edwards projects implemented at various client sites.

11. June 2003 - November 2003 Industry: Manufacturing

Maverick-Tube, St. Louis

Worked on a project for a company, which manufactures of premium

quality Oil & Energy related tubular goods and standard pipes as a

One World XE Technical Developer/Analyst. Responsibilities in the job

include working in Financial, Order to cash), Procure to pay(PTP),

Inventory and Mfg (BOM, Standard cost etc.) modules:

. Support, Maintenance and Bug fixing.

. Creating new standard ERW reports, Modifying batch and

interactive applications based on user requests.

. Creating new and modifying financial (using smart fields)

reports for Fixed asset module

. Creating reports using Seagate Crystal report tool.

Environment: JD Edwards One World XE, SP 16.1, Update 3, Oracle8,

Crystal Seagate 7.5 and Create Form

12. November 2002 - March 2003 Industry: Manufacturing

ADM World, Decatur

Worked for a manufacturing company, which processes and produces

soybeans, cocoa, corn, oil, ethanol and other by products. Involved

as a One World XE Technical developer in new implementation of

extensively customized Agreements and Contract management module.

. Creating Complex reports with the feature of mailing reports as

mail attachments to top management.

. Creating and Modifying Interactive applications

. Writing table triggers for Audit log purpose and writing

interfaces etc.

. Modifying design specifications as per requirements and Writing

Technical Documentation

Environment: JD Edwards One World XE, SP 17.1, Update 6, SQL Server

2000

13. August 2002 - October 002 Industry: Service Oriented

ARS, Memphis

Worked on a project for a company, which provides residential and

commercial services.

Involved as a One World XE Technical developer/Analyst in developing

new Interactive application module for Budgets

. Budgeted Workers Compensation, Budgeted Insurance Deductibles,

Budgeted Advertising, Budgeted Detail Labor, and Budgeted Detail

Travel and so on.

. Budget related Reports

. Created NER Business functions.

. Application and Data base design.

. Functional, Technical and User specification writing

Environment: JD Edwards One World XE, SP 18.1, Update 3, Oracle 8.1,

UNIX

14. July 2002 - August 2002 Industry: Tax/Finance Service

Oriented Nelco, Greenbay

Worked on a project for a company, which provides software products

to Tax & Accounting, Mortgage and Business communities.

Involved as a One World XE Technical developer up-grading One world

XE SP 15.1, update2 to SP 19.1, update6.

. Reapplying all custom modifications to Interactive applications,

Batch applications, Data structures, NER, Business functions.

. Reapplied custom event rules using visual ER, for business

function C code comparison used C code compare tools like Beyond

compare2 tool

. Created New Applications for Customer service

. Coding, testing and documentation

Environment: JD Edwards One World XE, SP 19.1, Update 6, AS/400

15. June 2002 - Jul 2002 Industry: Insurance

Amerus Life, Desmoins

Worked on a project for a large insurance company as One World XE

Technical developer and Enterprise report writer with

CapGeminiErnst&Young (CGEY) Implementation team involved in

Development and Customization of Financial reports. Responsibilities

of the job include:

. Added financial Drill down feature to Income statement and Balance

sheet reports.

. Modified Consolidated balance sheet report to print YTD Income

amounts in middle of the report as per client requirement

. Created Row, Column and Cell override reports

. Statutory Reports (six different reports) to submit state

insurance department

Environment: JD Edwards One World XE, SP 18.1

16. July 2001 - April 2002 Industry: Transport/Educational Services

Laidlaw, Naperville

Worked on a project for an Education Services provider, the largest

private contractor of student transportation in North America.

Involved in the new implementation of One World XE financial (G/L,

AP, AR and Fixed Assets) and Procurement modules as a One World XE

Technical developer and Enterprise report writer with an Accenture

Implementation team. Responsibilities include Set up, Analysis,

designing, issue resolving, coding, testing, documentation and

writing User scripts.

. Created all new financial reports using smart fields and modified

standard JDE reports.

. Voucher Journal Report, Open PO Status Report and Purchase Order

Report

. Writing new conversion program to update F03B11 with proper

business unit in to work file and AR/Aging details report for

unapplied cash.

. Written Conversion programs to convert data from legacy system to

One World tables using Table conversion tool and UBE. Fixed asset

Data conversion

. Setting up User defined dates, Category Codes etc.

Environment: JD Edwards One World XE, SP 17, Update 3, Oracle 8i,

UNIX, Citrix

17. March 2001 - May 2001 Industry: Manufacturing

Werner Company, Greenville

Worked on a project for a Manufacturing and Distribution Company as a

One World XE Technical and Enterprise report writer with IBM

Implementation team involved in Development and Customization of

Financial reports. Responsibilities of the job include:

. Converting JDE world FASTR reports in to One World Financial

reports.

. Creating new and modifying existing Financial reports

. Designing Technical and functional Specifications. User Training

and writing User scripts.

Environment: JD Edwards One World XE, SP16, AS/400 (DB2/400,

OS/400), Citrix

18. October 2000 - February 2001 Industry: Manufacturing

Emplifi, PA

Worked on a project for a Manufacturing and Distribution Company as a

JD Edwards Technical Consultant involved in Customization and Data

Conversion of One world Sales order(OTC), Purchase Order and

Inventory Management. Responsibilities of the job include:

. Customization of existing and creating new Interactive

applications, Batch applications (UBE) pertaining to user

requirements.

. Writing data conversion, Interface applications to convert data

from legacy system to One World tables.

. Preparing Technical Specifications for customization and new

requirements

Environment: JD Edwards One World XE, AS/400 (DB2/400, OS/400)

19. April 2000 - September 2000 Industry: Manufacturing

IPG, Columbia

Worked for a manufacturing company as a JD Edwards Technical

Consultant, Involved in Implementation, Customization and Data

Conversion of JD Edwards Payroll System. Responsibilities of the job

include:

. Data Fields mapping

. Writing data conversion programs for ADP payroll data into JDE

payroll system

. Customizing pristine Canadian and US check printing, auto deposit

programs and report layouts pertaining to client existing check

format with additional features.

. Customized A/P Payment check report programs.

Environment: JD Edwards A 7.1, RPG/400 and CL/400

20. October 1999 - March 2000 Industry: Manufacturing

Mastech, PA

Worked as a J.D. Edwards Consultant for a Distribution Company was

involved in the customization of One World Sales order(OTC), Purchase

Order and Inventory Management Responsibilities include:

. Writing event rules and ER debugging, attaching processing options

. Data mapping, Writing data conversion applications to convert

legacy data to One world using table conversion feature

. Upload customer information, Sales order(OTC), Invoice from the

Legacy system to One World

. Uploading Vendor/Item Details & Prices, Item Cross-reference.

. Customizing the various forms and UBE reports based on client

requirement.

. Preparing technical documentation

Environment: JD Edwards One World

21. June 1999 - Sep 1999 Industry: Manufacturing

Frigidaire, Mcrae

As a J.D. Edwards Consultant for a Manufacturing and Distribution

Company, was involved in Implementation and customization of Sales

order(OTC) and Accounts Receivable modules.

Responsibilities include:

. Developed programs to upload data from legacy system to JD Edwards

system using Z - Files.

. Customized JD Edwards's reports in Sales order(OTC) according to

Client specific printed layout format. Print Pick slip, Invoice

Printing etc.

. Customized JD Edwards Accounts Receivable reports. Aging, Summary,

Statement Reports etc.

. Developed various Conversion and Interface Programs for Sales

order(OTC).

. Developed and customized the new and existing reports and Menus as

per user specifications.

. Upgraded Customized & JD Edwards programs from A7.2 to A7.3 Cum10

Environment: JD Edwards A7.3, RPG/400 and CL/400

22. August 1998 - May 1999 Industry: Manufacturing

ScottSystems/Electrolux, UK/India

. Worked as a J.D. Edwards Consultant for a manufacturing company,

was involved in the implementation and customization of Purchase

Order, Inventory Management and Work Order modules.

Environment: JD Edwards A7.3, RPG/400 and CL/400

23. March 1998 - August 1998 Industry: Service Oriented

CTSI, Memphis

Worked as a Programmer, involved in design, development, and

implementation of offshore project for CTS Inc. Memphis.

Responsibilities included:

Environment: RPG/400, CL/400, SQL 400, Query 400.

24. January 1996 - March 1998 Industry: Software

FCS/LK Global Software, India

Worked as a Programmer, involved in design and coding and testing

different modules.

Environment: RPG/400, CL/400, SQL 400, Query 400.

Contact this candidate