Sales Customer Service

Vamsi

*******@*******.*** Ph# 415-***-****

PROFESSIONAL SUMMARY

Highly motivated, fast learning Application Consultant with over 7+ years of IT experience in Analysis,

Design, Coding, Testing, Debugging and Support of business applications using JD Edwards One

World (73.3.2,XE),Enterprise One 8.11/8.12 and World software A7.3 with Oracle,AS/400 and SQL

Server Databases.

Successfully completed four full life cycle implementations using JD Edwards One World (73.3.2, XE),

Enterprise One 8.11/ 8.12 which includes upgrade and Migration Experience.

Extensive experience in using PL/SQL, Developer 2000/6i/9i, SQL Loader, Discoverer 3i/4i/9i/10G,

Workflow, XML Publisher 4.5, Oracle 10g/9i/8i/8/7.x, Unix, Linux, Shell Scripts.

Worked in JDE Financials (GL, AP, AR, FA), Manufacturing (INV, WIP, BOM), Procurement, Sales

and Distributions, HRMS (Core HR), Payroll.

Experience in RICE like Conversions, Interfaces, Reports & Enhancements

Developed Reports in modules GL, AP, AR, FA, Procurement, INV, BOM, and Sales Order Managment.

Experienced in the implementation of Procure to Pay (P2P) and Order to Cash (O2C) business

processes.

Extensive experience identifying product gaps coordinated with development team by creating

SAR/TAR/SR and obtained one-off fixes. Managed and monitored TAR’s for several P1 issues.

Extensive experience in Customization of JDE modules, which involved developing the Interactive and

batch Applications.

Experience in Standard JDE Program Modifications, Custom Report Development (Report Writer),

Custom Application Development, Conversions, and Interface program Development and Technical

Production Support.

Having hands on experience in creating System Requirement Specifications (SRS) documents, Test

scripts with various scenarios, Risk Analysis reports, Code reviews, Validation reports (VR) and

Validation Protocols (VP) according to the FDA (Food & Drug Administration) regulations.

Developed Interface programs for importing data from feeder systems to Oracle using PL/SQL,

SQL*Loader.

Hands on Experience in ETL (Extracting, Transforming and Loading) development using DTS and

(Microsoft SQL Server Integration Services) SSIS.

Designed and developed various interfaces for inbound and outbound communication with legacy

systems like Demantra, Sales force, Informatica files, Operative, Ariba, Get paid.

Extensively worked on AIM documents like MD050, MD070, CV40, CV60 and MD120.

Experienced in Fine Tuning Applications for better performance RICE implementation with high Level

of Customer Satisfaction.

Worked on several Sarbanes-Oxley projects to meet the company audit needs.

Strong Analytical, Interpersonal, Problem Solving, written and communication skills.

EDUCATION:

BS in Engineering.

TECHNICAL SKILLS:

ERP : JD Edwards OneWorld B73.3.1/B73.3.2/Xe, Enterprise One 8.0/8.9/8.11/8.12

JDE Tools : JDE Object Librarian (OL), Object Management Work Bench

(OMW), Enterprise Report Writer (ERW), Business

Views (BSVW), Report Design Aid (RDA), Form Design

Aid Tool (FDA), Object Configuration Manager (OCM),

User Defined Codes (UDC), Data Dictionary (DD), Table

Design Aid (TDA), Table Conversion (TC), Universal Table

Browser (UTB), Debugging Tools.

Hardware : Sun ES 3500, IBM M/F and AS/400

Operating System : UNIX, Linux, Windows, OS/400, HP-UX, AIX

Software : Visual Basic 5.0/6.0, VB Script

Database : Oracle10g/9i/8i/8.0/7.3, MS-SQL, ADABAS, DB2/400, VSAM, IMSDB/DC

Database Tools : PL/SQL, SQL*PLUS, SQL*LOADER, TOAD

EDI : Mercator 1.4.2/5.0

ETL/BI tool : Informatica,Cognos,XML/BIPublisher,Discoverer3i/4i/9i/10g,Reports2.5/6i/9i/10g,

Forms 4.5/6i/9i/10g, Developer 2000/6i/9i/10g, Business Objects 6.5/XI2, SSIS/ DTS

Version Control : CVS, Dynamsoft source, PVCS

PROFESSIONAL EXPERIENCE

Pernod Ricard; Purchase, NY Feb09-Till date

Sr. JD Edwards (Enterprise One E8.12) Consultant

Modules: Finance

Responsibilities:

Involved in Design & Implementation process for factoring receivables.

Created Functional, Technical, Test cases and process flow (Business requirement) documents.

Created Securitized receivables file formatted according to Business requirement.

Developed Interface for financial transactions of the business required all Receivables Invoices to be

tracked within Applications by validating the Acknowledgement file data.

Developed process to update the receivable closed invoices for the day, which will not be considered for

the future transaction file.

Customized and supported the Auto lock box interface for Banks.

Developed interface for positive pay to Submit a separate text file to bank for both USA and CAD bank

accounts, retain a copy of the file sent and able to locate and re-send a file in the event the bank was not

able to retrieve the original file.

Created batch process for Auto debits process EDD (Electronic Direct debit) interface.

Analyzed the security needs, prepared the security matrix and implemented the Security.

Worked on the financial process (Custom UBE’s) tuning process using Explain plan to improve the

system performance.

Designed, Developed & Trained users on the custom Securitized receivables processes.

Extensively used interoperability Custom tables for building the inbound and outbound interfaces.

Reports

Created Daily receipt Payment report/Invoice payment report is used typically to review Invoice

payments based on customers. The purpose of this report to serve the consolidations of payment amounts

for internal references.

Created Custom status report to trace the process status of invoice for each stage.

Developed custom report to update ship to address to the account receivables ledger.

Create Check reconciliation exception report to reconcile the amounts between the banks and A/P.

Customized financial reports for Customer Totals by G/L Account.

Developed reports used for IRS taxing to list all taxes, deductions and other payment details by company.

Environment: Enterprise One 8.12; Oracle 10g, Create Form, Report Writer, UNIX and Citrix Server.

NCH CORP, Irving, TX March08-Jan09

JDE Enterprise One (Upgrade Xe to 8.12) Consultant.

Modules: Finance and Distribution & Logistics

Responsibilities

Involved in the Migration of World to Enterprise One 8.12 and Upgrade of OneWorld Xe to

Enterprise One 8.12

Extensively used Conversion and Migration tools to retrofit the changes to E 8.12

Worked on data conversion from Non-Unicode database to Unicode database and coordinated the efforts

for the conversion cut-over.

Prepared the test scripts for the users to test the migration & upgrade.

Designed & developed the process flows for AR, AP, GL and Fixed Assets to test the migration

Created SSIS/DTS packages for Finance application that would transfer data among servers and perform

other data transformations; scheduled the same SSIS packages by creating the corresponding job task.

Replaced the Table Conversion programs with SSIS packages to create a foundation for the intranet

application to monitor the jobs.

Accounts Receivable:

Worked with Customer Setup (P03013), Standard Voucher Entry (P03B2002), and Standard Receipts

entry (P03B102), Speed Status Change (P03B114), Account Activity Log (P03B31), Deduction

Processing (P03B40), and Statements & Delinquency (P03B202) Etc.

Accounts Payable:

Worked with Supplier/Vendor Master (P04012), Voucher Entry (P0411), Manual Payments (P0413M),

Recurring Voucher Review/Cancel (P04120), Currency Exchange Rates (P0015A), Speed Transaction

Currency Rate Entry (P11154) Etc.

General Accounting:

Worked with Companies/ Fiscal Date Patterns (P0010), Setting Up Business units (P0006), Setting up

Accounts (P0901), Journal Entry (P0911) application to add /Update/Void/Delete Journal Entry, Batch

review and Approval (P0011), Indexed Allocation/Computations (P09121), Account Balance by Sub

ledger (P092131), Trial Balance by Object (P09214), Trial Balance by Sub ledger (P09215) Etc.

Customized the financial reports like Income Statements, Balance Sheets, Profit and Loss

Statements to accommodate the new companies and business units.

Fixed Assets:

Worked with Asset Master (P1201) for Asset Setup, Revised un Posted Entries (P12102) for Review,

Pass, hold a fixed Asset, Manual Payments (P0413M), Work with Assets (P1204) for Review/Update

/Split Existing Asset, Single asset Disposal (P12105) Etc.

Customized Master Business Function B03B0011 for Increment the Pay item as per client requirement.

Reports

Worked on Open A/R summary analysis report and defined sequencing, selections and level break

criteria based on client requirements and implemented the grand totals and subtotals to meet customer’s

requirements.

Modified A/R Details with aging Report according to Client’s requirement.

Created A/R Conversion report, which is used to convert data from flat file to A/R Interoperability files.

Customized Check Print (R04572), Statement of Account Print (R03B5001), Invoice Print (R03B505),

Open A/P Summary Report Change (R04413), Open A/P Details with Aging (R04423B).

Created a custom UBE to print Financial Balance sheet by company on demand.

Customized the GL Cash Forecasting report (R09520) to review the summary of current balance

information in general ledger.

Reviewed edit reports and operator error messages and provided applications support to end users for

supply -chain management (SCM) system and related applications

Environment: JD Edwards World, One World Xe, Enterprise One 8.12, AS/400,i-Series config,RPG

ILE, SSIS/ DTS, Create Form, Report Writer, Bartender and Citrix Server,XML publisher.

Roseburg Forest Products; Dillard, OR Jan07-Feb08

Sr. JD Edwards (Enterprise One E8.11) Consultant

Modules: Finance, Manufacturing, Distribution & Logistics

Responsibilities:

Involved in Design & Implementation process to improve the Shipment Process.

Modified P4210 to meet the Advance planning features that can give better capabilities to promise an

accurate date of delivery.

Duplicated the efforts of custom mod on Sales order application in to the Customer Service application

(P42101), which has better capabilities.

Analyzed the security needs, prepared the security matrix and implemented the Security.

Worked on the Financial & Sales Order Archive (Old Records) process to improve the system

performance.

Designed, Developed & Trained users on the custom Work Order processes.

Modified P4981 (Work with Freight Audit history) to meet the S-Ox and internal audit compliance.

Worked on Un-posted Fixed Assets application to improve performance on Revise.

Customized JDE process to send the ACH- Direct Deposit to the banks.

Extensively used interoperability Z-tables/processes for building the interfaces.

Designed & developed a new Batch Program to generate the EDI transaction 850 for Inbound Purchase

Order.

Worked on the Sarbanes-Oxley audit programs for the company audits.

Reports

Designed & Developed dispatched-unshipped orders report to cleanup the inventory.

Create Check reconciliation exception report to reconcile the amounts between the banks and A/P

Customized financial reports for Customer Totals by G/L Account.

Supported critical reports used for IRS taxing to list all taxes, deductions and other payment details by

company.

Worked on R41540 (Item Ledger Detail Report), R41530 (Stock Status Report), R41550 (Inventory

Journal Report).

Customized R41543 (Item Ledger/Account Integrity Report) and R41580 (Cost Report).

Customized Inventory journal report according to customer’s requirement.

Customized the Purchase Order Print (R43500), Received/ Vouchered Status (R43412), Print Open Sales

Orders (R42620), Delivery Receipt (R42565), and Stock Status Report (R41530).

Involved in the design and development of inventory integrity reports to check for any Duplicate lot

numbers, Primary location errors, Duplicate serial numbers and Negative numbers in inventory. Also

developed custom reports for Summary Inventory Valuation and VAT Prices.

Environment: Enterprise One upgrade Xe to 8.11; SQL Server, SSIS Packages, Create Form, Report

Writer, Windows XP and Citrix Server.

Medtronic,Memphis, TN July04-Nov06

Sr. JD Edwards Programmer Analyst

Modules: Distribution & Logistics, Financials and Manufacturing

Responsibilities:

Involved in full life cycle implementation and Upgrade Distribution, Financials and Manufacturing.

Customized various Financial Applications & Reports.

Designed, Implemented "Automated Lockbox" according to Client requirement.

A custom interface program developed receive the lockbox transaction data from Bank Of America Bank

& load into JDE cash payment Z file (F03B13Z1). Then submit the JDE standard batch program

R03B13Z1I to create the payment receipt records in JDE.

Modified the Sales Order Entry (P4210) to prompt the user to enter ‘Order Number’ for specific credit

orders via a form. This process will link credits back to the original order.

The Sales Order application (P4210) was modified such that the Transfer Orders tab will have an

additional field Request Date (DRQJ); where the user enters the data at the order entry time.

Made custom modifications to the “Base price Revisions - (P4106)” program as per the client’s

requirement.

Modified the “Supplier Price Maintenance Program (P41061)” program as per the client’s requirement.

Modified Held Order Reports (R42640), Back Orders to Fill Reports (R42118), Open Orders (R42620)

and Sales Ledger Report (R42600).

Created a NER to provide Security for Lot Status Field to change by a approved users only.

Customized Sales Order Application for “Shipment Cancels” and “Removals” and also added new fields

to Customer Service Inquiry Application (P4210).

As a JDE Programmer/Analyst, actively involved in Design, Develop and Modify Various Applications,

Reports and Business functions (NER) according to Client Requirement in Distribution & Logistics,

Financials and Manufacturing modules.

Debugging ‘C’ business functions and writing NERs.

Created many custom tables, business views, UDC’s and Data dictionary items as per the requirement.

Created system requirement specification (SRS) for all the requirements.

Involved in preparing of Unit test plans and test cases, Code Reviews, Risk analysis reports and

validation Protocol Reports according to the FDA (Food & Drug Administration) regulations.

Provided Go-Live support.

Reports

Developed Income Statements and Budget report by company, Business Unit and Divisions.

Created Consolidate Balance Sheet R5509002 to get the Assets and liabilities.

Created Account Receivable Aging Report (R5503AG) to review open A/R items for specific aging

categories.

Created year-end Balance Reports (R550901GL) using the Smart Fields.

An on-demand Loaner Extra Report is also designed and developed to retrieve data from the audit table

with reference to the Recon Detail table.

Developed Un-invoiced Report According to Client Requirement.

Environment: JD Edwards One World Xe, AS/400, Report Writer, Oracle 8i, Windows NT and Citrix

Server.

FOX Interactive media, Brisbane CA April03-June04

JDE developer

Modules: Distribution, Financials and Manufacturing

Responsibilities:

As a JDE developer I was involved in developing many enhancements and reports.

Involved in full life cycle of implementation of Distribution, Financials and Manufacturing.

Extensively worked on Bill of material.

Extensively worked on Customer Ledger, Payments Inquiry, Account Balances, and Worklist.

Worked extensively on Z-files/ Processes.

Created a custom UBE to print Financial Balance sheet by company on demand.

Created UBEs to populate the Z files and post the Journal entries as per the user requirements.

Created Labor Exceptions report to show exceptions outside a tolerance limit to labor that is reported

versus labor at standard by work order.

Developed a custom credit code interactive application to update and maintain the cross-reference

tables for HCS credit Codes that correspond to JD Edwards Sales Order Document Types.

Customized the Purchase Order Entry application (P4310) to include Lot potency field, which gives the

percentage of the most significant compound present in the lot composition.

Created SLOB (Slow moving and obsolete inventory) program, which will flag the expired lots as

reserved.

Modified the applications like adding the fields to the grid and adding the exit row buttons.

Created many custom tables, business views, UDC’s and Data dictionary items as per the requirement.

Created NERs (Named Event Rules) as per the requirement.

Created system requirement specification (SRS) for all the requirements.

Involved in preparing of Unit test plans and test cases, Code Reviews, Risk analysis reports and

validation Protocol Reports according to the FDA (Food & Drug Administration) regulations.

Reports:

Modified A/R Details with aging Report according to Client’s requirement.

Modified Open A/R Summary Analysis Report according to Client’s request.

Created PPV (Purchase Price Variance) report by item and supplier based on purchase orders those

have been received.

Created a General Ledger report sorted by sub ledger account.

A batch application is created to facilitate the separation of Intra-Company Liability Balances into two

accounts, to indicate whether the balances are inventory-related or non-inventory related.

Created a batch application to provide the Error Correction Utility in the Z Processor applications.

This is a generic process that produces a nightly detail report of the Work Center Error Messages

generated by any batch program specified.

Developed a report, which will print the all the processing options and data selection configurations for

all programs and versions. This report will be used as an appendix to the design book.

Modified the Lot Status Update (R41082) report according to the Clients request.

A new batch application is created to copy the Address Book Field (AN8) in the F0911 to Sub ledger

Field (SBL) in Account Ledger (F0911) table.

Worked with Work orders and Forecasting Reports.

Environment: JD Edwards One World Xe-ERP 8, Report Writer, AS/400, Windows NT and Citrix

Server.

ATC, Boston, MA Dec01-Feb 03

JDE (Upgrade B73.3.1 to Xe) Consultant

Frequent interactions with project Manager and functional team developers to understand the business

requirements.

Setup procedures and guidelines to be followed to assure adequate and prompt user support.

Investigated,analysed,coded,tested/debugged and implemented for software modifications and new

Development.

Was part of the team that involved in converting the non-Unicode database systems like AS400 to

Enterprise One Compliant Unicode database system.

Provide user support/training in setting up Supplier templates.

Redeveloped reports to suit new database structure. This work included changing business views used in

reports, changing event rules, processing options and report templates, as well as changing some versions

for specific reports. Also performed necessary unit testing and application debugging.

Responsible to retrofit the custom code implemented on standard JDE objects in the XE environment

into E1 environment.

Understanding the Dream writer versions and converting them into the E1 UBE versions.

Extensively worked on the customization of the standard JDE applications like P31123, P31113 and

P31114.

Designed and Developed a Work Order Status change program which changes the WO status from one

status to other using processing option values based on the branch/plant.

Responsible in preparing the baseline documents for the retrofit and rework done on the One world XE

Objects.

Redesigned the power entry form (P42101) as per business user requirements.

Have created E1 versions for the Dream Writers Material Requirements Planning (MRP) P3382 and

P3483 which are run on a daily basis as part of the night batch jobs.

Worked on the Back Order Release (P42117), Item Location Revisions (P41024), Item Ledger(P4111)

Costed Bill Inquiry (P30206), Work with Bill of Material Where Used (P30206).

Played a vital role in Virtual Vendors Identification project where Supplier Branch (URCD) is

Used to identify vendors VV, VTIGA and VCMAST for whom the internal branch/plant

Supplies the goods.

Involved in the customization of the C Business functions like B4200450 (Advanced Sales Order Line

Split) for performing strcmp on RCTO and F4211 (Sales Order detail) table updation.

Worked with visual compare tools like Visual Compare, ExamDiff to compare Event Rules, DD Items,

and UDC’s by running the application P96472.

Adding different tasks/items to the task view and created Role Filters in Menu Filtering of solution

explorer.

Environment: JD Edwards OneWorld B7331/Xe, Report Writer, UNIX, Oracle

XILINX, San Jose, CA Aug 2000 –Oct 01

Oracle Application Developer

The Project involved Implementation of Oracle Applications 11i. Was involved in customizing AP, PO, AR,

FA, GL modules including conversion, writing interface programs according to user and business

requirements, customizing and developing several reports using Oracle Reports 6i according to the functional

specifications provided.

Preparation of Functional and Technical specifications MD50/70 and CV40/60 from the requirement

specifications.

Responsibilities

Interfaces and Conversions

Designed and Developed Staging tables, Data Conversion SQL Loader Program and Custom PL/SQL to

import the

Outbound Interface to display approved purchase orders of spend management solution for analysis to

Ariba software.

Programmatic setups of AR Receipts conversion using auto lockbox.

Interface to process charge backs to external collection agency (integration to GETPAID software).

Purchase order receipts interface.

Fixed Asserts conversion.

Mass upload of budgets.

Uploading of User rates.

Reports

Involved in the Discoverer Admin work creating Custom, complex folders, summary folders, hierarchies

and item classes.

Created Business Areas and built Discoverer Workbooks using Discoverer.

Responsible for developing and customizing Discoverer as per the client requirements.

Designed XML Templates, XML publisher reports. These are configured to generate output in PDF

formats.

Customized various reports like applied credit memos, supplier analysis, chargeback’s and adjustments,

unpaid invoices matched with receipts, Payments Foreign exchange by project, payment status of the

supplier, purchase orders with matching type.

Creation of Concurrent executables and Concurrent Programs using System administrator.

Customized forms using CUSTOM.PLL to meet the PO form to ensure no PO is created for less than

US$1000.

PO form customization to see the item information will display the definition information’s of the item

which you are entering into the Purchase Order lines and the Zoom function will be activated.

SQL Performance Tuning

Tuning Applications for better performance RICE implementation and TKPROF was generated for all

the programs to analyze each and every SQL Statement.

Worked extensively on full life cycle implementation and procure to pay (PTP) cycle which includes

requisition, RFQ, purchase order,receipts,invoices,payments and interfacing to ledger

Understanding the High level Functional design and preparing the low level Technical design for module

to be developed.

Documenting the code and unit test scripts.

Worked closely with Functional team and the user groups to understand the requirements.

Supporting the technical development after go live.

Receiving Knowledge Transfer from other members of the team.

Environment: Oracle Applications 11i (11.5.6/11.5.8), GL, AR, AP, PO, CM, INV, OM, Oracle 8i,

Forms 6i, Reports 6i, PL/SQL, SQL*Loader, SQL*Plus, TOAD, UNIX, Shell scripts, HP-UX.

Contact this candidate