JAY PATEL

adjkdk@r.postjobfree.com / 201-***-****

Lake Hiawatha, NJ 07034

Visa Status: US Citizen

https://www.linkedin.com/in/jay-patel-428497103/

SUMMARY

Trustworthy, responsible Personal with experienced in System analysis, EDI Analyst, Creating Reports in SQL Server 2012/2016, and ad hoc reports in NetSuite. Experience working in ERP System including NetSuite, MS Dynamics NAV and Made2Manage having good working experience with Logistics, Finance, Sales and Customer Service department inside organization. Quick study, deadline driven with strong attention to detail. Team player and collaborative decision maker. Extensive experience working with diverse customers and communicating technical concepts to non-technical audiences. Quick learner with proven ability to learn new systems and concepts.

SKILLS

Functional understanding of ERP system like NetSuite, MS Dynamics NAV and Made2Manage.

SQL Server and My SQL

Excel, MS Word and MS Access

Understanding of programming languages like MS Visual FoxPro.

Manual and functional testing in ERP System

Creating Reports using SQL in SQL Server

Data entry, Troubleshoot.

-Ecommerce

EDI

Fluent in English

Enterprise Resource Planning

Fast Learner

Experience Working with Finance Department

Experience working with Customer Service Department

Experience working with Logistics Department.

FTP

Functional

GUI

Graphical User Interface

Logistics

Requirement Gathering

Research

EXPERIENCE

Data/System Analyst / GoodEarth - Fort Lee, New Jersey 06/2019 - Current

Managing and resolving internal Helpdesk requests in NetSuite on a regular basis.

Worked closely with Various departments including Customer Service, Logistics, Finance to gather their business requirements and achieve common Business goals in NetSuite.

Worked as 1st level of contact for System related issues.

Created various custom fields in Items and Customer records.

Also created ad hoc custom reports in NetSuite.

Involved in performing testing for EDI Transactions including 856's, 810's, 940's and 945's in NetSuite and EDI Platform TrueCommerce.

Performed Tests including sending Test Orders from NetSuite to 3rd Party Logistics Partners EDI Systems and receiving Fulfillments transactions from 3rd Party EDI System back into NetSuite via TrueCommerce.

Managing errored EDI Transactions in TrueCommerce on a required basis and bring them into completion in NetSuite.

Those transactions involved 856's and 810's.

Also, communicate with Vendor and was able to lower the Volume of errored EDI Transactions.

Performed research and troubleshoot steps necessary to find the root cause of the EDI transactions being not processing automatically and bring those causes to IT manager to prevent them happening again.

Maintain and created Scheduler for importing Sales orders from NetSuite into TrueCommerce, exporting Shipments notifications (856's) from TrueCommerce into NetSuite and exporting Vendor Bills (810's) from TrueCommerce into NetSuite.

Created mapping for Items and customers in NetSuite into TrueCommerce for EDI transactions process automatically without any problem.

Created various Saved Search reports in NetSuite to facilitate internal department including Sales, Finance and Operations.

Familiar in creating reports and Saved Searches in NetSuite and those reports and Saved Searches are helpful for internal purpose and external trading partners.

Created various Saved Search reports for different Customers that report was sent out to Vendors daily automatically on a scheduler basis.

Managing Data consistency in Master records including all Items and Customers in NetSuite.

Performed mass update on Items records for prices and Costs, descriptions etc.

And on Customers for Addresses and many other fields.

Managing Companies' Customers orders and Items in NetSuite and monitor FTP files that send back to Customer's FTP folder and make sure that those FTP files transit without any inconsistency of Item Data into Customers System.

Monitor and managed automatic process flow from Creating Sales orders to sending those orders to 3rd party Logistics Warehouse System on a regular basis.

Handling Customer's request for adding, updating, removing SKU's on their ordering portal and those changes were handled in NetSuite that triggered automatically on Customer's ordering Website.

Performed Testing of eCommerce orders from Amazon and Shopify to have them imported successfully into NetSuite via Celigo.

Troubleshoot orders related errors into Celigo and work with Celigo technical department to bring errors into resolution.

System Analyst / HiTouch Business Services - Saddle Brook, New Jersey 07/2015 - 06/2019

Involved in implementation/up-gradation of Microsoft Dynamics NAV 2016 from Microsoft Dynamics NAV 2009.

Used/Wrote SQL Queries to generate reports and Analyze data.

Actively involved in various projects from beginning phase till the ending phase including requirement gathering and testing.

Created new accounts for business customers, Vendors in Microsoft Dynamic NAV ERP System.

Responsible for monitoring data incoming from customer's in a form of sales order's until they properly transmit to vendor's system in a form of purchase orders.

Setup system user's profile, personalization, roles, and permissions.

Modify existing user's permissions, grant, and invoke permissions.

Performed Rapid Start functionality in MS Dynamics NAV system to import/export large volume of date to and from excel sheet.

Performed everyday routine task of posting large number of sales orders using Batch post sales order functionality in the system.

Setup and Analyzed EDI transmissions in the system daily.

Involved in setup new sourcing rules and strategy based on warehouse locations, customers, Items for EDI transmission in the system.

Performed/Involved in required system functionality testing after creating case scenarios.

Performed background check on SQL Server system to modify and analyzed data.

Responsible for every month billing of Rental module (Coffee and Cooler rentals) of the business.

Generated invoices and posting/billing to Rental customers.

Responsible for monthly billing for various companies' customers.

Created monthly billing reports directly from Data Warehouse for them using SQL server.

Checked and analyzed every monthly billing has been completed properly by writing SQL code and posting orders.

Responsible for creating new Accounting periods in the system every year.

Analyzed the bad data in the system make necessary correction on them to make it valid as per business requirements.

Handled system's user's requests on daily basis, solved them or guided them in proper direction.

Handled warehouse system user's request in case of picking, packing or manifesting sales orders in the system.

Also performed adjustment posting for returns department.

Junior Application Developer / Kulite Semiconductor Inc. - Leonia, New Jersey 06/2014 - 06/2015

Controlled access to corporate IT infrastructure and Enterprise Resource Planning (ERP); created accounts for new employees and trained them to effectively use the network provided fast and friendly customer services to employees experiencing network access issues.

Wrote SQL commands in the visual FoxPro database to fix incorrect data entries to properly reflect production quantities and lot numbers reviewed and updated specific transactions and the corporate master database to confirm it accurately reflects manufacturing data.

Developed an application using visual FoxPro to log transactions and minimize operator input error.

Modified a Graphical User Interface (GUI) and backend Visual FoxPro database utilizing GUI drop-down list, input boxes, memo fields, etc.

To enhance features in the data entry process.

Wrote and execute test plan to verify application's functionality and identify/eliminate issues.

EDUCATION AND TRAINING

Fairleigh Dickinson University - Teaneck, New Jersey 2013

Master of Science: Computer Science

Dharamsinh Desai University - Nadiad, India 2010

Master of Computer Application

Gujarat University - Nadiad, India 2009

Undergraduate in Business/Accounting

Contact this candidate