SIVAKUMAR ARUMUGAM

Email: acy9bk@r.postjobfree.com

Phone: 612-***-****

Professional Summary:

Total 12 Years and 2 months of experience in software analysis, design, development, testing, maintenance and full life cycle implementation in JD Edwards EnterpriseOne E9.2 / E9.1 / E8.12 / JD Edwards OneWorld Xe.

Extensive skills in Application Design, Report Writing, Table Conversions, working with Named event rules, C Business functions, Financial Reports using Smart Fields, working with OneWorld Toolset (OMW, OL, FDA, RDA, TC, ERW, DSTR, BSVW, DD and UDC) using JD Edwards EnterpriseOne/OneWorld

Involved in Distribution & Logistics (Sales order Management, Inventory Management, Warehouse Management, Material Planning and Procurement), Financials (Account Payable, Account Receivable and General Accounting), Manufacturing (Shop Floor management Material Planning, Forecasting and Work Orders) and Foundation (Address Book) module implementations and support.

Experience in Full life cycle of the software development life cycle process (SDLC).

Expert in Standard JDE Program Modifications, Custom Report Development, Custom Application Development, Conversions, Interface program Development, Technical and production Support.

Having hands on experience in creating Requirement Specifications documents, Test scripts with various scenarios, Code reviews and Validation reports

Expert in C cache programming, C business function design Troubleshoot of C business function using Visual Studio and JDE debug log

Experience in working on Sales Order Master Business Function

Installed and worked with Create form suite to customize E1 Report Outputs as per the user requirements (Printing, Email, e Fax & Archive)

Retrofitted JDE applications, batch programs during JDE release upgrades from XE to 812 also on data conversion

Improved performance of many batch programs and application using the Oracle Performance Workbench.

Extensive experience in One View Report, BI publisher and Embedded publisher RD Report creation, bursting report to email and printer

Development of applications using Power forms and Sub forms to review Interface transactions in single screen

XML development using C functions, experience in developing E1 pages.

Customization of Super Back Flush program for P3111 Inventory issue, P311221 Hours and Quantity update and P3114 Work Order completion

Have worked on P3210 Configurator engine

Development of queries and reports using Hyperion Interactive Reporting Studio using JDE DB tables which connect through ODBC

Created JD Edwards User Profiles, User security through security workbench, maintained Role and Role Relationships

Created Task Views and maintained Task View Relationships

Development of queries and reports using Access database for data reconciliation

Development of automated report’s using SQL query scheduled through Toad data point

Expert at handling multiple projects simultaneously.

Involved in User acceptance testing, System testing and QA testing.

Provided Go-Live support and expert at troubleshooting and resolving problems during post Go-Live and production support

Expert at Mentoring and End User Training.

Having excellent Work experience in Pharmaceutical, Manufacturing, Food and Retail Industry.

ERP

JD Edwards EnterpriseOne E9.2, E9.1, E8.12 & JD Edwards OneWorld Xe.

JDE Tool Set

Object Librarian (OL), Object Management Workbench (OMW), Enterprise Report Writer (ERW), Form Design Aid (FDA), Business View (BSVW), Table Design Aid (TDA), User Defined Codes (UDC), Data Dictionary (DD), Table Conversion (TC), Universal Table Browser (UTB), BI Publisher Standalone and Embedded, Event Rule scripting tool, ER debugger, VC++ Debugger, Power Form and Sub Forms, C Business Function and C Cache Programming

Languages

C, VC++, VB

Operating System

Unix, OS/400, Win 95/98/2000/2003/NT/XP, Citrix Server

Databases

Oracle 11g/10g/9i/8.x/7.x, SQL Server 2000/2005, DB2/400 & MS Access

Third Party Tools

Create form Designer, Bottom line - Optio Design Studio 6.5, Bottom line Transform, Tidal Scheduler 5.2.2, EDI ANSI X12, HP Quality center, Toad,

Reporting Tools

Hyperion Interactive Reporting Studio, Crystal Reports 9.x/10/11

Projects Executed:

Client : GlaxoSmithKline, Philadelphia, PA, USA

Duration : Aug’2014 to till date

Role : Sr. JD Edwards Programmer Analyst

Modules : Finance, Procurement, Sales

Description:

GlaxoSmithKline as a global healthcare company having three world-leading businesses that research, develop and manufacture innovative pharmaceutical medicines, vaccines and consumer healthcare products. The project is in the development of its Revenue Cycle Systems. The Revenue Cycle Systems is critical function of Core Business Services and comprises of interfacing various components across order management systems from customer information, commercial contract information and distribution systems.

Responsibilities:

Project involved in data Integration from SAP to JD Edwards enterprise one

Developed custom batch reports R5847XX for Master data load into tables F0010, F0006, F0401 and F0901

Developed custom batch reports R5847XX for daily transaction load from F5847001, F5847002, F5847003 and, F5847006 into F0911, F0902, F0411 and F0311 when all translations (Simple, Company, Cost Center, Accounts and Document) are exist. If not update the transaction with specific error messages.

Developed custom batch reports R5847XX for Archive of daily transaction load from F5847001, F5847002, F5847003 and, F5847006 into temporary tables.

Developed custom batch reports R5847XX for reset of flags on daily transaction load F5847001, F5847002, F5847003 and, F5847006 for revalidation purpose

Developed Custom Interactive application P5847101-simple translation, P5847102 Company translation, P5847103 Cost Center translation, P5847104 Account translation and P5847105 Document translation to add, review and modify translation data.

Developed C Business function and NER for data validation in translation table and insertion into target tables

C Cache program created to capture tag fields to include in the Master Business Function B4200310

Power form and subform created for Inbound Interface transaction review and error monitoring

Developed OneView Report, BI publisher and Embedded publisher Report, bursting reports to email and printer.

Development of Report Template, Report Definition RD to generate XML data in order to print Invoice Delinquency report.

XML development using C functions

Development of applications using Power forms and Sub forms to review Interface transactions in single screen

Development of queries and reports using Hyperion Interactive Reporting Studio using JDE DB tables which connect through ODBC

Monitored daily data load and resolve all kind of translation issues.

Have developed OneWorld EnterpriseOne reports for several business units for their day to day transaction analysis and review.

Report development includes Finance report for expense tracking on a higher hierarchy of cost center rollup level to the lower level of individual person level.

Involved in resolving JDE EnterpriseOne reports issues.

Have used Oracle Hyperion Interactive reporting tool version 11 to validate data on translation and JDE enterprise one tables and generate reports.

Have used HP Quality center 10 to create test cases and test scripts, test results and defect tracking purposes.

Responsible to JD Edwards enterprise one new User setups and security setup using roles and cost centers.

Monitored EDI inbound PO transaction and successful creation of SO, reported error and resolution using the Power form and Sub forms

Provided Functional support on Purchase orders, Sales Order, GL, AP and AR finance modules

Have performed annual closing activity using Annual close program R098201

Involved in Price adjustment and price scheduling

Scheduled jobs through job scheduler

Balance Reconciliation using developed queries and reports using Access database which connected to JD Edwards’s enterprise one table data and excel data.

Have created automated report’s using SQL query scheduled through Toad data point

Environment: JD Edwards Enterprise One E9.1 & E8.12

Client : Cargill Inc., Minneapolis, MN, USA

Duration : Jul’2012 to Jul’2014

Role : Sr. JD Edwards Programmer

Modules : Distribution & Logistics, Financials & Manufacturing

Description:

Cargill Inc. is an international provider of food, agricultural and risk management products and services. With customers spanning the globe, Cargill provide expert advice in crops and livestock; food; health and pharmaceuticals; industrial; and financial and risk management. Cargill now employs over 153,000 people in 66 countries around the world. This project is Cargill Application development and Maintenance project which Involves Requirement Analysis, Development, Enhancement and Support of JDE and legacy Interface applications

Responsibilities:

Modified Sales Order Entry (P4210) program to validate custom processing logic and put order on hold when the conditions are not met.

Created batch application to list all of the batches posted for period so that finance can account for all manual entries/batches.

Have developed custom application for product scanning in SFM

Have worked on customization of Super Back Flush program for P3111 Inventory issue, P311221 Hours and Quantity update and P3114 Work Order completion

Have worked on P3210 Configurator engine in process manufacturing

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

Involved in user testing and user training.

‘C’ business functions development, debugging of ‘C’ business functions and writing NERs.

JDE custom report creation using Power form and sub forms to show open orders, closed order for a single customer

Business function creation using cache programming to choose appropriate carriers.

Developed functionality to add new Items to the existing Lots and place items on hold by Item/lot combination. This program should only allow authorized users the ability to create new Lots/Items using custom UDC table.

Involved in technical issues and resolution in JDE, EDI, Optio, Tidal Scheduler

Designed Report output layouts using the Create!form designer

Unit Testing, Integration testing JDE to Legacy applications.

Help provided for legacy application to migrate to SAP interface Involved in end to end SAP Remote ware application support

Involved in end to end Legitronic Labling software and Weber Zebra Label printer support during order shipment

Involved in end to end Electronic Bill of Lading (eBOL) application support

Co-ordinate with offshore team and client team

Weekly status update meeting with Business and BRM provided status on the project completion status

Environment: JD Edwards Enterprise One E8.12

Client : Catalent Pharma Solutions Atlanta, GA, USA

Duration : Oct’2011 to Jun’2012

Role : JD Edwards Programmer

Modules : Distribution & Logistics, Financials and Manufacturing

Description:

Catalent Pharma Solutions is a leading provider of advanced dose form and packaging technologies as well as development, manufacturing and packaging services for pharmaceutical, biotechnology and consumer health companies in nearly 100 countries. Catalent operates 30 facilities worldwide. This project is Catalent Application development; support and Maintenance project which Involves Requirement Analysis, System Design, Development, System Maintenance, Enhancement and Support of Interfaces with Business Critical Applications. Project is responsible to provide production support to JD Edwards and JDE Interface applications of XPI, Optio and DSI.

Responsibilities:

Developed Financial YTD report to show balance and expenses using the Smart fields PA-PeriodActivity. The report designed to display specific month amount and YTD expense amounts, Budget amounts and differences. The values passed to Smart fields are FiscalYear, Company, Period number, etc.

Customized the Purchase Order Entry (P4310) application to include custom fields, Lot Potency as per custom requirement.

Developed custom Purchase Order Acknowledgement POA program to meet Optio design requirement for custom report output and to deliver through FAX

Debugging of ‘C’ business functions and writing NERs.

Requirement gathering and development of Interactive application for the newly acquired business units.

Development of batch applications for budget tracking and reporting purpose

Have developed custom batch application to report the transaction details through XPI.

Technical specification document preparation on JDE, Optio and XPI.

Development of Interfaces between JD Edwards (Client) and other systems (customers) using JDE Real Time Events, JDBC and Oracle adapters.

Development of Customized JDE report output using Optio Design stutio and JDE report enhancement to meet Optio design requirement

Project involves migration from Optio to Transform which involves development of Customized JDE report output using Bottomline Transform, CreateForm

Administrating XPI Servers and production support.

Monthly Maintenance and restart of services activity.

Assisting WebMethods team to migrate the current XPI Interfaces to WebMethods 8.0

Involved in preparing Test Scripts, Code Reviews and Test Result documentation

Involved in User acceptance testing, System testing and QA testing.

Environment: JDEdwards One World Xe

Client : Cargill Inc., Minneapolis, MN, USA

Duration : Jan’2009 to Sep’2011

Role : JD Edwards Programmer

Modules : Distribution & Logistics, Financials & Manufacturing

Description:

Cargill Inc. is an international provider of food, agricultural and risk management products and services. With customers spanning the globe, Cargill provide expert advice in crops and livestock; food; health and pharmaceuticals; industrial; and financial and risk management. Cargill now employs over 153,000 people in 66 countries around the world. This project is Cargill Application development and Maintenance project which Involves Requirement Analysis, Development, Enhancement and Support of JDE and legacy Interface applications

Responsibilities:

Enhancement of JD Edwards’s batch applications to support Optio, which includes Custom Invoice program development, Purchase Order Acknowledgment.

Interactive application enhancement to suite with EDI project requirement to view EDI Order header, detail and additional information

Have guided the team member by providing hands on JDE technical and Optio training.

Have worked on JDE Freight calculation batch application, added specific logic for freight calculation when light weight item shipped with other standard items.

Have worked on Invoice program to put an order on hold meeting specific conditions like old Item#, order to be shipped on the same day of order placed and exceed certain limit in each of the order detail line.

Have worked on more than 100 EDI Projects (Trading Partners) end to end setup’s.

Implemented 100+ EDI inbound and outbound transactions. Includes ANSI X12 4010/5010 transactions of 850, 855, 856, 860, 824, 864 and 810.

Have worked with Client VAN to setup Trading Partner maps.

Provided end to end support to determine root cause of failures/issues from Client, VAN and trading Partners.

Have Performed Unit testing & system testing for each case and every enhancement by running sequence of JDE Reports to move the order by creating POA, SO from PO, shipment confirmation, created Invoice and send back to customer.

Integration testing performed for all new transactions through JDE sequence of Reports.

Accountable for coordinate, configure and test EDI trading partner set-ups.

Responsible to update documentation after configuration changes.

Accountable for Client VAN and other third party service provider

Have created test data files and guidelines for new EDI customers through JDE and EDI SpecGenerator.

Have enhanced the guidelines by adding or deleting nodes using EDIFecs Specbuilder 6.7.

EDI Input and EDI Output file structure defined through workbench

EDI Data item mapped from Input file to output file

Maintained mapping instructions in order to shared to Client VAN and copy to trading partner

Custom processing rules through rule builder

Monitored input, output data and trace logs through translation sessions

Maintained unique processing requirement for each Trading partner through trade guide

Have generated administrative reports and shared to business

Maintained JD Edwards Cross reference tables to store custom data of Customer X-Ref, Item X-Ref, Unit of Measure conversion etc.

Guided team members with deep functional knowledge expertise on each of the EDI transactions.

Environment : JDEdwards One World Xe

Client : Cargill Inc., Minneapolis, MN, USA

Duration : Apr’2008 to Dec’2008

Role : JD Edwards Programmer

Modules : Distribution & Logistics, Financials & Manufacturing

Description:

Cargill Inc. is an international provider of food, agricultural and risk management products and services. With customers spanning the globe, Cargill provide expert advice in crops and livestock; food; health and pharmaceuticals; industrial; and financial and risk management. Cargill now employs over 153,000 people in 66 countries around the world. This project is Cargill Application development and Maintenance project which Involves Requirement Analysis, Development, Enhancement and Support of JDE and legacy Interface applications

Responsibilities:

Have worked on enhancement of Invoice and Purchase Order Acknowledgement program to produce Optio customized output.

Have involved in DCL (Document Customization Language) development of One of many layout, one to many destination, printer and email configuration.

Have supported 50+ DCL with enhancement and new development.

Support provided to customized invoice, Bill of Lading and Purchase Order.

Have guided the team member by providing hands on Optio training.

Have worked as level 2 & 3 Tidal technical support.

Expert in JDE report job scheduling through Tidal Scheduler as group level or

Individual job level.

Expertise in Tidal Scheduler client configuration and security definition for new users.

Expertise in alerts setup at group/job level.

DSI (data System International) dcLink 4.1 application support provided.

User id creation for new WMS user to access to tran collector through configuration utility.

Support provided to switch users from transerver to WMS Jr server during monthly outage.

Proactive monitor of device loader to make sure sufficient license available for active users.

Troubleshoot of network issues through Service Monitor and JDE.

Involved in design documents, analysis and documentation.

Environment : JDEdwards One World Xe

Client : Arjo Wiggins', UK

Duration : Dec’2006 to Mar’2008

Role : JD Edwards Programmer

Modules : Distribution & Logistics, Financials & Manufacturing

Description:

Arjo Wiggins' has a long and proud tradition of performance in the carbonless paper market. Client is the largest producer of carbonless paper in Europe having four carbonless paper manufacturing plants in Belgium and the United Kingdom, 15 sales offices, 1600 employees and markets that stretch as far as Asia, the Far East, and Australia.AWS JD Edwards Stabilization Project is a JDE OneWorld Xe application development and support Project.

Responsibilities:

Technical support on Sales, Purchase, Inventory, Manufacturing and Finance modules applications from both Onsite and Offshore.

Support provided to standard JDE Sales, Invoice and custom applications.

Technical specification preparation based on functional specifications.

Preparation of test cases and code review.

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

Business function NER enhancement as per the new data selection criteria.

Have guided the team member by providing hands on Optio training.

Have worked on enhancement of Invoice and Purchase Order Acknowledgement program to produce Optio customized output.

Have involved in DCL (Document Customization Language) development of One of many layout, one to many destination, printer and email configuration.

Have supported 50+ DCL with enhancement and new development.

Support provided to customized invoice, Bill of Lading and Purchase Order.

Have guided the team member by providing hands on Optio training.

Environment : JDEdwards One World Xe

Client : The Wilderness Society, USA

Duration : Sep’2006 to Dec’2006

Role : JD Edwards Programmer

Modules : Distribution & Logistics

Description:

The Wilderness Society (TWS) is the leading American conservation and nonprofit organization working to protect nation’s public lands, the 635 million acres collectively owned by the American people and managed by our government. This project is TWS Application Support and Maintenance project which Involves Requirement Analysis, Development, Enhancement and Support of JDE applications.

Responsibilities:

Support provided to Sales, Invoice application enhancements.

Technical specification preparation based on functional specifications.

Provided technical support by assisting design specification preparation, review and testing.

Coding standard followed in all the application and reports development and enhancements.

Helped Functional team to identify the correct files and fields in Distribution modules

Preparation of test cases and code review.

Environment : JDEdwards One World Xe

Client : Lafarge North America, USA

Duration : Apr’2005 to Aug’2006

Role : JD Edwards Programmer

Modules : Distribution & Logistics

Description:

Lafarge North America is the largest diversified construction Materials Company and supplier of cement, aggregates, concrete and other materials for residential, commercial, institutional and public works construction in the United States and Canada. Lafarge North America is part of the Lafarge Group, a world leader in building materials that is active in 75 countries, and employs more than 75,000 people. This project is Lafarge North America JDE Implementation and Maintenance project. It’s an Onsite and Offshore model. Project Supported in all aspect of JDE Functional, Technical and CNC.

Responsibilities:

Co-ordination with Onsite Functional Team and Offshore Technical Team for requirement gathering

Development of JDE Technical Design Specifications for enhancements

Development of Batch Applications and Interactive Applications.

Unit Testing, system testing and documentation of test results

Test Scenario Preparation with expected results.

Performance Analysis on all newly developed applications using Performance Workbench tool.

Development of Technical Design Documentation and OneWorld report development to meet Optio requirement.

To fulfill the customer requirement used Optio in sales Order Management to generate the customized format of Quotation and customized outputs of Invoice.

Developed customized Invoice to suite with Optio requirement.

Environment : JDEdwards One World Xe

Client : Globus, Mumbai, India

Duration : Dec’2004 to Mar’2005

Role : JD Edwards Programmer

Modules : Distribution & Logistics

Description:

Globus is a leading Manufacturer and Retailer of Garments. This Project is JDE Implementation and support project. Project Supported in all aspect of JDE Functional, Technical and CNC.

Responsibilities:

As a Technical consultant have created technical design document, and Test case documents.

Complete development process of batch reports, Table conversion.

Customization of various reports including Invoice and other reports in Sales order Management.

Development and customization of interactive applications.

Development of NER for the custom logic

Performance Analysis using Performance Workbench tool.

Environment : JDEdwards One World Xe

Education:

B.E (Bachelor of Engineering in Mining) Anna University, Chennai, India.

Contact this candidate