Yashi Singh

Results-driven Technical Lead with a strong background in delivering smooth NetSuite and Celigo integrations. Proficient in JavaScript and SuiteScript, consistently improving system performance and user experience. Recognized for outstanding client interaction and analytical skills, driving successful and efficient project outcomes.

1. NetSuite – Shopify Order Import Integration (Standard & Dropship Orders)

Objective: Develop a GraphQL API-based Celigo integration to import Shopify orders into NetSuite, handling tax, discounts, and automated dropship order creation.
Challenges: 

• Orders needed to reflect both header-level and line-level discounts and taxes.
• Customers might not exist in NetSuite at the time of order import.
• Items marked as dropship in NetSuite required automated Purchase Order (PO) creation per vendor.
• Item Fulfillment should only be triggered after manual receipt of dropship items by the warehouse.

Solution Implemented:

 Order import via GraphQL:

• Created a custom GraphQL query to retrieve all required order data from Shopify, including customer details, discounts, taxes, and item metadata

Customer Creation Logic:

• Built logic in the Celigo flow to check for the existence of customers in NetSuite and create new customer records if not found.

Sales Order Creation: 

• Configured the Celigo flow to create Sales Orders in NetSuite with all necessary field mappings, including tax handling, discount application (both header and line level), and custom form assignment.

Dropship PO Automation:

• Added custom line-level fields to flag dropship items
• Dveloped a User Event Script to automate PO creation:
• A single dropship PO is created if all items share the same vendor.
• Multiple POs are created if items belong to different vendors
• Each PO is linked to the corresponding Sales Order lines.

Item Fulfillment Triggering: 

• Implemented another User Event Script on the PO record that listens for a status change from "Pending Receipt" to "Pending Billing."
• Once triggered, it:
• Identifies the associated Sales Order.
• Creates Item Fulfillment in NetSuite for the received lines.

Current Status: The solution is tested end-to-end, regression-tested with the customer, and successfully deployed to production.

2.ServiceNow – NetSuite Case Integration (Bidirectional Sync)

Objective: Build a custom integration between ServiceNow and NetSuite to import cases from multiple ServiceNow tables into NetSuite and sync status updates back to ServiceNow.

Challenges:ServiceNow cases resided in two separate tables.

• NetSuite case creation required specific mappings for custom form, customer, location, and an HTML-formatted description.
• Duplicate cases needed to be avoided.
• Case status and message updates from NetSuite had to be pushed back to the corresponding ServiceNow cases in real time.

Solution Implemented:

Inbound Flow (ServiceNow → NetSuite):

• Developed a custom Celigo flow to fetch cases from two separate ServiceNow tables.
• Implemented transformation logic to pass only relevant data.
• Mapped critical fields such as custom form, customer, location, and HTML-formatted description as per client requirements.
• Added validation to prevent duplicate case creation in NetSuite.

Outbound Flow (NetSuite → ServiceNow):

• Designed a second Celigo flow to monitor case status updates in NetSuite.
• Synced updated status and message fields back to the appropriate ServiceNow case using mapped identifiers.

Current Status: Both flows are fully implemented, tested end-to-end with the client, and deployed to production for live use.

3. NetSuite – Quarterly Item Sales Report Automation for Warehouse Teams

Objective: Build an automated report in NetSuite to show item-wise quantities sold in each of the last five quarters across 8 warehouse locations.

Challenges:

• Required grouping of sales data by item and quarter.
• Needed to filter out only relevant transactions (Sales Orders in specific statuses).
• Output had to be structured for non-technical warehouse teams and shared regularly.

Solution Implemented:

• Saved Search Configuration
• Created a NetSuite Saved Search on the Transaction record (type: Sales Order).
• Applied filters to include only transactions from 8 specified warehouse locations and statuses like Pending Fulfillment or Billed.
• Grouped results by Item and used a custom SQL formula to calculate the quantities sold per item for each of the last five quarters.

Report Structuring:

• Configured the saved search columns to display item name and quantity sold in each quarter.
• Ensured the report format was easy to interpret for warehouse staff with quarter-wise breakdown.

Automation :

• Set up a scheduled workflow to email the report weekly to the warehouse team as an Excel/CSV attachment.

Current Status: The report is running in production and is being successfully delivered to the warehouse teams on a weekly schedule.
 

ServiceNow – NetSuite Case Integration (Bidirectional Sync)

Objective: Build a custom integration between ServiceNow and NetSuite to import cases from multiple ServiceNow tables into NetSuite and sync status updates back to ServiceNow.

Challenges:ServiceNow cases resided in two separate tables.

• NetSuite case creation required specific mappings for custom form, customer, location, and an HTML-formatted description.
• Duplicate cases needed to be avoided.
• Case status and message updates from NetSuite had to be pushed back to the corresponding ServiceNow cases in real time.

 Solution Implemented:

Inbound Flow (ServiceNow → NetSuite):

• Developed a custom Celigo flow to fetch cases from two separate ServiceNow tables.
• Implemented transformation logic to pass only relevant data.
• Mapped critical fields such as custom form, customer, location, and HTML-formatted description as per client requirements.
• Added validation to prevent duplicate case creation in NetSuite.

Outbound Flow (NetSuite → ServiceNow):

• Designed a second Celigo flow to monitor case status updates in NetSuite.
• Synced updated status and message fields back to the appropriate ServiceNow case using mapped identifiers.

Current Status: Both flows are fully implemented, tested end-to-end with the client, and deployed to production for live use.

• Ncc Passed 'C' Certificate with' A' Grade
• Winner of tug of war in ncc camps