Project Jd Edwards

Jayeshkumar Gujarathi

ERP Consultant – JD Edwards Oracle

CNC & System Architect consultant

Contact No: +1-713-***-**** (M)

E-mail: ***************@*****.*** ***************@**********.***

Objective

Objective driven, result oriented. Seeking challenging position in which I can contribute to attain organizational goals while ensuring personal growth.

Brief Profile

More than 10+ years of experience as Oracle JD Edwards CNC Consultant, performing Implementation, Installation, upgrades, Configuration, System Administration, Security Set-ups, and troubleshooting for J.D.Edwards OneWorld Xe, ERP 8.0, Oracle Enterprise One 8.11 with tools release 8.97,E8.12 with tools release 8.98.4.4, ERP 9.0, 9.1 with tools release 9.1.5

1.5 Years of experience as SCM(Inventory Module) functional consultant implementing and writing the functional specification for Handheld solution for warehouse transactions PO, Receipt, Item relocation,Pick confirmation, ship confirmation, Item inquiry, receipt route movement, cycle count

Trained and Worked as JDE developer for 6 months to develop TC and fix reports, applications as well understanding of debugging of code, RDA, FDA, TDA and table conversion.

System Architect to plan Design and Implement Disaster Recovery (DR) site for JDE system

Expertise in JDE Installation, Configuration, CNC implementation, System Administration, performance tuning, clustering and load balancing of servers, Data Migration, Security setup, Change Management, Troubleshooting for Oracle OneWorld Xe, ERP 8.0 and Enterprise One 8.11,8.12,9.0.

Performed all the CNC tasks with high understanding of JDE Data Sources, Tables, OCM settings, Package build, JDE User Profiles, ESU/ASU, Security settings and System Problem Analysis/Resolution, data conversion.

Certified Dclink administrator (DSI).

Java Certified Professional (JCP)

Attended SQL2005/08 DBA training from Synergetic as requirement of Chevron project Activities like transferring Data to and from SQL Server, Creating Alerts, SQL Server Security, Backup and Recovery, Replication of Database.

Attended BI (Business Intelligent) PI training from SAP Education.

Good communication and analytical skills.

9) Project Detail: Avon Cosmetics June 2015 till date

Working as CNC lead in Avon Cosmetics to perform JD Edwards CNC Upgrade Activity as well as Day to day support activity for existing E812 system.

Responsibilities:

Planning and Upgrading E812 to E9.1 tools release 9.1.5

Performance tuning for Critical batch jobs

Streamlining process for Audit, documenting and implementing the Audit process for JDE.

Security Setup and day to day Administration considering all SOD rules.

Day to day support activity

Package build and deployment on Enterprise Server, Egen Server & Fat clients.

Planner, baseline, ESU installation

Service pack/ Tools release installation.

Troubleshooting the Server & Fat Client also user’s technical issues

System Monitoring

Team Size:

Offshore: 7

Onsite: 3

Platform:

Linux, Oracle 11g, Oracle 12c Websphere 8.5

Third Party Tools:

Autosys, Boomerang, sharepoint, Remedy

10) Project Detail: Mannatech Inc Oct 2014 to May 2015

Working as Upgrade CNC consultant to perform JD Edwards upgrade from E811 to E9.1 with tools release 91.4.7.

Responsibilities:

Install E9.1 System

Upgrade E811 to E9.1 system with TR 9.1.4.7

Install and Configure BSSV

Install and Configure One View Reporting

Install and Configure BI Publisher

Install and configure out of box Oracle Mobile solution for PO approval and Sales inquiry

Install configure JDEdwards Ipad package.

Troubleshoot and fix the upgrade issues.

Install latest updates from oracle.

Installed and configure Weblogic Servers as clustered

Team Size:

Offshore: 2

Onsite: 1

Platform:

Windows 2012, SQL 2012,WLS,BI

9) Project Detail: Avon Cosmetics Jan 2014 – Oct 2014

Working as Onsite lead in Avon Cosmetics to perform JD Edwards CNC Activity.

Responsibilities:

MSDE SSE upgrade

User Management Automation planning

Performance tuning for batch jobs

Streamlining process for Audit, documenting and implementing the Audit process for JDE.

Day to day support activity

Package build and deployment on Enterprise Server, Egen Server & Fat clients.

Planner, baseline ESU installation

Service pack/ Tools release installation.

Troubleshooting the Server & Fat Client also user’s technical issues

Housekeeping of Enterprise / Deployment Server

System Monitoring

Team Size:

Offshore: 1

Onsite: 7

Platform:

Linux, Oracle 11g, Websphere

Third Party Tools:

Autosys, Boomerang, sharepoint, Remedy

L&T Infotech Ltd.

List of Projects:

9) Project Detail: Energy Technology Company July 2011 to Dec 2013

Working as Techno (CNC+SCM) functional to design and implement Hand Held (Mobile) online/offline solution to warehouse/Inventory management using the Dclink software.

Responsibilities:

Study and design install/configure the dclink7 R6 system with JDE 8.98.

Upgrade JDE system to 8.98.4.4.

Configure and upgrade the Motorola MC9090 G device to WM 6.1

Install the End user dclink application (TranCollector) onto the Hand Held devices.

At Onsite (Warehouse plant) Gather Business requirement, convert business requirement into the functional document.

Discussed and describe functional document with Technical resource

Review the Technical design document

Create test cases and testing script

Performed the Unit/Product testing using the Hand Held devices for IM/WM transaction.

Deployment to more than 15 warehouses

Train the End users.

Team Size:

Offshore: 0

Onsite: 3

Platform:

Windows, SQL 2008 Server, OAS

8) Project Detail: Estuate Q1:2012

Working as CNC consultant to install and implement the JDE 9.1 system

Responsibilities:

Study and Discuss the JDE 9.1 architecture with client.

Defining process/set-ups in E1

Install and implement single JDE 9.1 instance and handover to client team

Team Size:

Offshore: 0

Onsite: 2

Platform:

AS400, DB2

8) Project Detail: Estuate Nov 2010 to June 2011

Working as CNC as well developer consultant to upgrade E810 system to JDE 9.0 system

Responsibilities:

Run spec conversion

Create TC’s to convert customize tables and data

Design driver report for pick slip printing, to run it on scheduler.

Writing the customize SQL stored procedures to validate the data.

Writing the customize SQL scripts to compare the SOD violation in JDE for ip compliance

Developed application to update the more than 1000 JDE scheduler jobs password.

Perform all JDE CNC activity performance tuning,Job scheduling, User management, Package Management OMW activity rule, SOX and IP compliance etc

Team Size:

Offshore:1

Onsite: 1

Platform:

Windows, SQL 2008 Server, OAS

7) Project Detail: ITC-Chevron Nov 2009 to Oct 2010

Worked as Project Lead to performed, SOX Activity, PGP encryption implementation, JDE Disaster Recovery exercise at Chevron

Responsibilities:

Co-ordination with offshore team and Client at onsite

Primary participation in yearly JDE E811 DR Exercise and testing.

Installation of third party tool called GPG Gnu version of PGP (Pretty Good Protection)

Using this tool we are encrypting the all private and sensitive files which are created by JDE batch jobs.

Masking/scrambling the non- production sensitive data.

Team Size:

Offshore: 11

Onsite: 2

6) Project Detail: July 2008 to June 2009

8.97 tools release upgrade DR System/Support/SQL2000 to SQL2005 Upgrade at Chevron

Responsibilities:

8.97 tools release upgrade DR System/Support/SQL2000 to SQL2005 Upgrade at Chevron

Team Size:

Offshore: 1

Onsite: 1

5) Project Detail: May 2008

LTM - Chennai (Oracle Database Migration) and upgrading B7333 to 8.11.

Responsibilities:

Migration of Oracle database from Oracle 8i to Oracle 10g

Migration of enterprise server from UNIX platform to Windows 2003 platform.

Install and implement Secody deployment server for upgrade

Converting/migration specification

Converting database to Unicode format

Handover to client

Team Size:

Offshore: 0

Onsite: 2

Platform:

Jdedwards ERP 8.0

Windows 2003 server.

oracle

4) Project Detail: CNL, Nigeria Ltd July 2007 – Feb 2008

E811 End to end Implementation/upgrade from Xe To E811 at CNL Nigeria Limited

Responsibilities:

Study and Discuss the E811 architecture with client.

Preparation of installation plan.

Installation of Oracle JD Edwards Enterprise One.

Installation of SQL server2000 on cluster servers and load balancing of database and application servers.

Data upgrade/conversion from Xe to E811.

Set up and configuration of all Advanced CNC activity like ASU, Job scheduling, User management, OMW activity rule, SOX and IP compliance etc

Team Size:

Offshore: 0

Onsite: 2

Platform:

JD Edwards E811.

Windows 2003 server.

SQL server 2000

3) Project Detail: April 2007 – June 2007

New Installation of E811 system for chevron Agbami project

Responsibilities:

Planning, Installation and configuration of E811 Set up.

Synchronization of Agbami E811 Setup with exiting chevron setup.

Team Size:

Offshore: 0

Onsite: 3

Platform:

JD Edwards E811.

Windows 2003 server.

SQL server 2000

2) Project Detail: Apr 2006 - June 2006

Two month project to study, test and install the latest SQL 2000 patch i.e. SQL SP4

Responsibilities:

•.To understand the all third party software which are connected to SQL 2000.

•.To do full set of QA testing.

•.Design and implements SQL 2000 SP4

Team Size:2

Offshore:1

Onsite: 1

Platform:

One World XE.

SQL 2000.

1) Project Detail: April 2005 – April 2006

Working as JD Edwards CNC Analyst, to support 22 countries around the Global and also supporting 5 standalone sites. Following standard process through Remedy Change Management and Incident Management as defined by client based on ITIL standard.

Organization: Chevron Oil Cooperation (US)

Chevron is one of the world's largest integrated energy companies. Headquartered in San Ramon, California has business in more than 100 countries. Chevron is top 5 in Fortune 500.

Company website: http://www.chevron.com

Responsibilities:

Study of Chevron One World setup.

Setting up Offshore CNC support

Package build and deployment on Enterprise Server, Citrix Server & Fat clients.

User Management

Job Scheduling

ESU, ASU installation and ASU build

Service pack/ Tools release installation.

Object Management Workbench

Troubleshooting the Server & Fat Client also user’s technical issues

Housekeeping of Enterprise / Deployment Server

System Monitoring

System Backup

DR Implementation

Database Activities

Database refreshes, executing queries and cursors, setting replications, configuring backup jobs.

Database backup, restoration using modern database utilities like SQLLite by Quest Software.

Performing schedule production SQL DBA activities.

Third Part tools administration:

In as project apart from JD Edwards’s administration, we support many third party tools like Insight Reporting, Crystal report, MS Access, ODI, DSI etc.

Activities are as following,

•.Insight job monitoring

•.Insight server and service management.

•.ODBC issue related to MS Access.

•.ODI installation and configuration

Platform:

JD Edwards E811.

Windows 2003 server.

SQL server 2005

Team Size:

Offshore: 11

Onsite: 2

Training and Education

JDEdwards OneWorld Technical training in Technical foundation, CNC Foundation and Overview, System Administration and Package management.

JDE development

SCM Inventory management

SQL DBA training from Synergetic.

SQL scripting training.

SET training from LntinfoTech.

SAP XI training for BI project in US from SAP

ODI(Oracle Data Integrate) Training

Dclink Administrator training at vendor location (Kansas, MO)

Technical Expertise

ERP Software: JD Edwards(Enterprise One) XE, ERP 8.0 and E811,,ERP 9.0, Oracle 9.1.

Languages : C, C++, JAVA

Database : SQL Server 2000/2005/2008, Oracle 10g,Oracle 11g and DB2

Application Server : Oracle Application Server, Web Logic

Operating Systems: Windows, Unix, RedHat Linux, AS400

Educational Qualifications

Degree/Certification

Institution/University

Year of passing

Class

Percentage

B.E (Engineering)

Amravati University

June 2004

1st Class (Arg)

66 %

H.S.C (Science)

Amravati Board

June 2000

1st Class Dist.

80 %

S.S.C

Amravati Board

Jun 1998

1st Class Dist

75.73 %

Contact this candidate