SACHIN DUBEY

With hands-on experience in Netsuite SuiteScript development, including expertise in map reduce, client scripts, and user events, alongside custom integrations on Celigo, I bring a proven track record of delivering robust solutions. Skilled in optimizing Netsuite functionalities and seamlessly integrating diverse systems, I am dedicated to driving efficiency and innovation in every project.

Netsuite - Shopify Integration

• Objective: Synced all existing product variants from Netsuite to Shopify and accommodated the future addition of new variants.
• Challenges:Customer needed to sync existing variants initially and ensure future variants could be synced seamlessly.
  Shopify REST API limits the number of variants that can be synced at the time of product creation to 100.
  
• Solution Implemented:Created the first Celigo flow to sync up to 100 variants during product creation.
  Developed a second Celigo flow to handle the synchronization of any remaining variants beyond the initial 100 and any newly added variants.
  Created saved searches in Netsuite to efficiently identify and track products and their variants that needed to be synced.
  
• Result: Successfully managed customer requirements and overcame API limitations, ensuring a smooth and reliable integration between Netsuite and Shopify.

Netsuite - Shopify Integration (Fulfillment, Order, Cancellation, and Inventory Sync)

• Developed and implemented integration flows to manage the synchronization of order fulfillment, order status, order cancellations, and inventory levels between Netsuite and Shopify.
• Utilized Celigo integrator.io to create robust and scalable integration solutions.
• Ensured real-time data accuracy and consistency across both platforms.
• Addressed and resolved API limitations and customer-specific requirements effectively.

Netsuite - Orderful Integration

• Worked on multiple Netsuite Orderful integration projects involving various Electronic Data Interchange (EDI) transaction sets including 850 (Purchase Order), 855 (Purchase Order Acknowledgment), 856 (Advance Ship Notice), 810 (Invoice), 997 (Functional Acknowledgment), and 846 (Inventory Inquiry/Advice).
• Designed and implemented integration flows to facilitate seamless data exchange between Netsuite and Orderful.
• Ensured compliance with EDI standards and customer-specific requirements.
• Enhanced the efficiency and accuracy of order processing and inventory management.

Netsuite Custom Report Creation

• Objective: Created a weekly report of all open purchase orders, including details on which line items had associated inbound shipments and additional shipment details.
• Challenges:No direct relation between purchase order line items and inbound shipment records.
  
• Solution Implemented:Created a custom field in Netsuite purchase order line items as a list/record type to link inbound shipments.
  Developed a scheduled Map/Reduce (MR) script to run every 30 minutes, extracting newly added inbound shipments, checking the attached purchase orders, and matching the line items.
  Mapped the custom field with the inbound shipment ID if a match was found.
  Created a saved search in Netsuite to generate a report of all open purchase orders, including the custom field to indicate whether an inbound shipment was created and additional required fields specified by the customer.
  
• Result: Provided the customer with a comprehensive and automated report, improving their visibility and management of open purchase orders and inbound shipments.

Netsuite - CPQ Integration

Netsuite - Hubspot Integration

• Strong communication and collaboration skills for translating technical requirements into actionable integration strategies.
• Attention to detail and proactive problem-solving approach ensure smooth integration across diverse platforms.
• Adaptability and continuous learning mindset drive innovation in delivering tailored solutions for client needs.

• Jira
• Orderful
• Celigo Integrator.io
• Clockify