Gauravkumar Patel

E-mail: acun2f@r.postjobfree.com, acun2f@r.postjobfree.com

Mobile: 908-***-**** – 720-***-****

Summary

I have more than 11 years of an IT experience in which 9+ years on JD Edwards CNC performing Oracle (Enterprise One/JD Edwards One World) CNC administration, installation, upgrade, Technical Customization/Development, Security Configuration, One View Reporting, BI Publisher,High Availability, Disaster Recovery and Internals.

Being a Certified 9i Database OCP, got extensive experience on Database Administration, OS and systems administration.

Excellent managerial, verbal and written communication skills.

Experienced in managing onsite, offshore delivery for multiple clients.

Analytical and innovative in problem solving, and worked as a leader in both team and independent environments.

Apart from CNC administration, participated/experienced in hardware scoping and design of JDE architecture.

Technical Skills

JDE : J D Edwards Enterprise One (B73.3.x, 8.10, 8.11, 8.12, 9.0, 9.1)

Security Software : Q Soft and All Out including JDE E1 Security

Tools Release : 8.96x, 8.97, 8.98 and 9.1x)

Database : MS SQL Server, ORACLE 9i-10g and 11g R2 with RAC, IBM DB2 UDB

OS : Windows 2003/2008, OS/400, ORACLE Solaris (Oracle Sparc)

Web & App. Servers: IBM Web Sphere, Oracle Web Logic, Oracle Application Server, Server Manager

Routers & Switches : Cisco Routers 2500 Series, Intel Switches.

Protocols : DNS, SNMP, TCP/IP, IPX/SPX, NetBEUI, PPP, ISDN, DSL, RDP,

Citrix ICA

Firewalls : Sonic wall Pro Vx, Sonic wall Pro 300, Cisco PIX firewall, Symantec

Software Firewall.

Project Experience:

PCB Apps LLC

IMI Precision ( Littleton,USA) Jul 15 to Till date

JD Edwards CNC Architect

This is a security implementation project, Client has having multiple locations, Successfully set up and did Go live, wherever they uses All Out and Q Soft as a JDE security tool. Client changes their Security tools for each locations.

Define All out and Q Soft Securities, I have set up the Function/Component Naming Conventions,Set up the level of different Component, Role relationship and sequencing according to the business hierarchy as well as Combi roles and Maas upload.

Work with Combi roles and multiple securities within all out, As well as Mass upload of the All Out securities.

Find and resolved the security conflicts, Create and maintain Security Master list, Role and User Master list, As well Security Matrix.

Apply and modify the Security records as per the business/functional requirement

Educate JDE functional team on requesting All Out security data especially when we defined Combi security like, Security type 1,3,5 ( Action, Application and Processing Option security.

Helping functional team and explain the All Out security requirement gathering.

Also defined and revised their ROW security from Exclusive to Inclusive.

Advised and maintain the security records as per Duty to Duty securities as well as runs pre build SODs.

Gathering security records from the functional teams and set up Functions/ Components according the business requirement

Define the components on Inquiry and Update manner

Educate the client CNC team about Q Soft and All out process and work areas in order to perform/apply securities in JDE

Prepared and maintain Role Master list and the User Master list for each site of IMI

Apart from Q Soft securities performing the User Management Creation/Deletion JDE Users, Reset password, Assigning roles thru All out security.

Supported Client's daily issues between the Legacy Environment 8.11SP1 and the New Enterprise One 9.1

Maintained All out and Q Soft Security Matrix, JDE CNC training, User Management, OMW process

Client uses Footprint ticketing tool

Received so many recognitions and appreciations from the client and from the functional team members, I have lead the project with the team of 3 CNC excluding Client CNC Team

Travelled to the multiple locations for each GO-live of the client.

Over all I had work with each and every CNC areas starting from Implementations, Security Set up, User/Role management, ASU/ESU, OMW process, Full/Update Package builds, Super/End user issues

Responsible to drive daily standup calls in order to stream line the project with the Functional folks and client management as well as CNC team

Environment: ERP 9.1 and 8.11SP1 on AS400 with Web Sphere

PCB Apps LLC

Berry Plastic ( Indiana,USA) Apr’ 15 to Jul’15

JD Edwards CNC Architect

There was no CNC KT was given by client since their CNC left the company without notice

Performed, Manage and deeply involved in each and every CNC activities to reduce risks and escalations

Managed the and streamline the regular Update Builds and end user issues

This customer was having multiple issues towards System Performance, SQL and JD Edwards connections

Re-structured their User management issues, Security Set up and follow up with the correct hierarchy

Designed and configured the Backup Strategy and the JDE maintenance cycle for the Client

Resolved and provided deep training sessions to the client existing team regarding issues

Performed JDE Data Refresh activity,ESUs and the User securities and Package Builds

Also made changes for OMW activity rules according to their actual needs

Their SQL backup were getting failed because of external drive issues and logs were keep increasing

Define the regular update and full build timings and One View reporting menus

Since I already have hands on experience of JDE on mobile so approached the client on it

Currently helping offshore team to work on Berry Plastic India localization project

Good knowledge on log tracing like Web server, Kernel and JDE logs and SQL Database

Environment: ERP 9.1 on Windows Platfrom with SQL Database and Web Logic

L&T Inoftech

KINAN Intl (Jeddah, KSA) June’ 14 to Feb’15

JD Edwards CNC Architect

This is a fresh JD Edwards E1 9.1 implementation project

Installation and configuration of JDE 9.1 on Sun Solaris Platform with 11gR2 RAC DB and Web Logic.

Installation of One View Reporting (OVR).

Create and maintain additional JDE Environments as per Client requirement.

Prepare security matrix and configure /maintain JDE security.

Perform common CNC activities like Package builds, Security Set up, User Management

Performed post installation activities like ASU, ESUs, Full Package, Media Object .

Designed and configured the Backup Strategy for the Client.

Performed JDE Data Refresh activity.

Prepare and Train the Client on security aspects.

Checking logs and report the issues and troubleshooting the challenges

Good knowledge on log tracing like Web server, Kernel and JDE logs

Prepare and maintain SLAs

Developed all technical documentation to support the migration including technical specifications, revised Architecture diagrams and testing criteria.

Arranged regular review meetings with the team to ensure all functionalities are met during the migration process.

Worked on trouble shooting issues pertaining to full package builds.

Applied ESUs and ASUs and brought the system up to date.

Investigated and resolved day-to-day user issues and monitored daily operations

Also performing Some Database activities like Database Export and Import

Taking backup of JDE tables

Prepare a well maintained shutdown procedure for the monthly JDE reboots.

Installed JDE Mobility using JDE AIS tool for number of JDE mobile applications

Environment: ERP 9.1 on Solaris Platform with 11gR2 RAC DB and Web Logic

L&T Infotech

Veolia Waters (St. Mourice, France) Aug’ 13 to May’14

JD Edwards CNC Lead

Handle more than 3500 JDE end users spread over the multiple countries

Performed Monthly Maintenance of each JDE Path Code

Performed day to day Update package and Monthly Full Package

Handling the team of 8 sub ordinates and the only point of client contact in CNC

Performed Package Clean up activity

Full and Update package builds E-Generation

Performed well maintained shutdown procedure for Web sphere services

Helping the Database Team about JDE Schema and Table information

Documented all the CNC processes. This was used by the team both Onsite and Offshore. It was 24x7x365 support project

Team lead responsible for training group members to support the client’s infrastructure.

Worked on JDE trouble shooting issues related to end users day to day challenges

Environment: ERP 811sp1 on Linux Platform with 11gR2 DB and Web Sphere

World IT Consulting

CSS (Charleston, SC) Jul’ 12 to Jul’13

JD Edwards CNC Lead

Performed CNC activities like Package build, JDE security, Trouble shooting

Creation of JDE User and Roles and apply JDE security at Role Level

During this project I had very good exposure towards SQL Database

Worked with SQL server Locks, Database Attach and Detach, JD Edwards data refresh thru database

Copying tables from one JD Enterprise one environment to another

Backup the JDE schemas Cleaning Old Update Packages, Purging Submitted jobs

Monthly Vertex Update

Performing the Data refresh activity via MS SQL Database not from frontend

Handling multiple trouble issues towards Server Manager, Long running Jobs, BSFN

As in managed service worked with All Out security for some clients

Work with combi roles and multiple securities within All Out. Work with Mass/ Bulk upload and resolved the security records conflicts.

Create and maintain security Master list, Role and User Master list. As well Security Matrix.

Defined Combi security like, Security type 1,3 and 5 ( Action, Application and Processing Option security)

Ran pre build SOD as per the functional team request.

Environment: ERP 9.1 on Windows Platform with MS SQL Database and Oracle Application Server

World IT Consulting

CD Group Inc (Georgia,USA) May’ 11 to Jun’12

JD Edwards CNC Lead

JDE CNC Managed services. CD group has having multiple clients like Texas Road House, Hamilton, Tyco Fire Products, Pro Rodeo, Homedics, Texas Medical, Akorn,Coca Cola Bottle Association (CCBA) to name a few . The system had one common ticketing tool in which multiple clients would login their complaints.

AS400 SQL packages deletion on weekly basis for Homedics

Routine End users issues Web and fat clients.

AS400 reboots for full package deployment on weekly and monthly basis

JDE health check, JDE E1 /JAS services are up and running

Work with JDE third party security tools like All out and Q Soft being in CNC managed service projects

Implement Combi roles, Mass upload, and define security records as per Organizational structure and functional team requirements

Work with 1-3, 1-3-5 kind of security records

Database health checks (Database up and running and backup and log failure reports)

Hard Drive checks for all servers,Enough disk space to data/log files to grow

Review of active kernel JDE logs as well as JAS logs review and checks for Zombie kernels

Maintaining records of the JDE update and Full packages

Integration servers like XPI and Web Methods. Handled Role related issues

JDE web login issues of End users

Managed Services Application Environment Landscapes

Responsible for JDE implementations checklists

Documented Project related processes for each client

Monthly Preventive maintenance plan of clients.

Responsible for multiple Clients Preventive Maintenance reports

Environment: Worked with Multiple JDE releases with Multiple Platform starting from XE to 9.1

IBM

Mannatech Inc (Coppel, TX) Dec’ 08 to Oct’10

JD Edwards Sr.CNC

Maintain all the Deployment, Enterprise and Web Servers and Server Manager

Weekly Web-Build Content change activity for Production servers

Full Package Build and update package

JDE User and Role creation

Log capturing Web server logs, Kernel Logs etc

Apply JDE security

Maintaining Track IT Issue for Security Task

Performed route Maintenance Activity both planned shutdowns and package deployments

Worked on JDE third party tools like Web methods, XPI Integration tool

Client had their WSG Integration Servers connected with JDE. Used third party scheduler called Tidal Software to Schedule jobs. Performed dot net builds and deployments on non JDE servers

Environment: ERP 8.11sp1 Windows Platform MS SQL Database and Oracle Application Server

Kullicke and Soffa Ltd (Germany) Oct’ 07 to Dec’08

JD Edwards CNC Consultant

Took care of all CNC activities in an offshore JDE support with no onsite CNC.

Maintained all the Deployment, Enterprise and Web Servers and Server Manager

Worked on Form Scape JDE Report Output Third Party Tool

Did Level-1 type of DB2 Database queries support

Huge set up towards JDE user management like User and Role Creation and provide Security

Daily Update package

JDE health checks

Environment: ERP 8.10 Windows Platform IBM DB2 Database and Oracle Application Server

KPIT (Systime) Oct’06to Oct’07

Two JDE Implementation Projects Details handled during Systime tenure;

JD Edwards CNC Consultant

1 Client : Orient Abrasives Ltd.

Environment : E812, Windows 2003, Oracle10g

2 Client : NAGA Mills LTD,

Environment : E811sp1, Windows 2003, Oracle10g

Installation of JD Edwards E1 E812 on Windows 2003 with Oracle Database

Installation of Enterprise Server, Deployment Server and Oracle Application Server

Installation of JD Edwards E1 E812 on Windows 2003 with Oracle Database

Installation of Tools Release 8.96.1.3

Installation of ORACLE 10gClient and Fat Client

Applied Update2 and Localization ESU

Activities Full Package and Update Package

Creation of Roles & Users

Did JDE Servers Backup including Deployment and Enterprise Server

Taking Oracle10g Database Export and Cold Backup, As per the Scheduled

Applied ESU

Completed for full Web generation for all environment

Provide support and training to the clients.

Wipro Infotech

(ORACLE DBA) Aug’04toOct’06

1.HDFC Securities India (August,2004 to September,2005)

2.IDBI Capital India (October,2005 to March,2006)

3.Times of Money Group of Times of India (April,2006 to August,2006)

Installation and Configuration of Oracle 9i/8i/8.x on Windows NT/2000

Execute Basic commands and server maintenance knowledge of SUN SOLARIS

Backup tasks – using OS backups and software specific backups. Checking for errors in alert logs and trace files

Setting up Standards for Database monitoring and administration.

Database administration includes creation of table spaces, adding data files, monitoring alert logs, periodical backups, and database recovery as needed and managing security issues.

Creation and Maintenance of Oracle Users. Providing dumps and queries as per the users request.

Routine activity to upload as well as replace the details on sun servers as well as restarts all the sun servers

Taking necessary backups like RTGS and Capital Market BOD/SOD and EOD backups

Verifying the broadcast for NSE-BSE connectivity. Capital Market BOD/SOD and EOD backups

Having good knowledge with Capital Markets software and their servers

Production support and maintenance for SQL database User maintenance, disk space monitoring, system administration, and installation of programs. Monitor the NT server using the tools like performance Monitor, event viewer, page file, network monitor tools in Windows NT.

Contact this candidate