North Vancouver, BC·Open to senior systems roles

Vinayak Rangrez

Senior NetSuite Administrator · Systems Automation & AI-Augmented Delivery

I administer NetSuite. I architect the AI agents that run on top of it.

About

Vinayak Rangrez

10+ years implementing and administering NetSuite OneWorld across six high-growth organizations — from 6–7 subsidiary go-lives inside SFX Entertainment's 70+ entity global rollout, to advanced inventory and 11 EDI retail projects at Sunnest, to multi-subsidiary US/AU e-commerce operations and 40+ Celigo integration flows at ASX-listed Princess Polly, to running my own NetSuite consulting practice, to leading Jetson Home's QuickBooks → NetSuite OneWorld implementation. Most recently at Jetson I architected 5+ production AI agents — with Anthropic's Claude Code as my engineering counterpart — that reconcile credit cards, AP, revenue, and rebates end-to-end against the GL, and surface AR + rebate aging.

10+
Years on NetSuite
40+
Integration flows delivered
11
EDI retail projects
5+
Production AI agents

Agents

5+ production finance-automation solutions I designed and now operate at Jetson Home. Each is invoked by accountants as a Claude Code skill, and each integrates with NetSuite via SuiteQL (reads) and the Import Assistant (writes). I own the requirements, data model, validation, edge cases, deployment, and ongoing operation. Anthropic's Claude Code is my engineering counterpart on the implementation side.

01

Bank Reconciliation Agent

Unified recon across clearing and bank accounts.

Single reconciliation pipeline covering Float credit-card clearing (5 accounts, ~2,500 txns/mo at 98%+ auto-match rate) and Tipalti AP clearing (3 accounts, ~500 bills/mo). Two subsidiaries, CAD + USD. Auto-generates NetSuite Bank Statement CSVs and journal entries and uploads them through the Import Assistant.

98%+
Auto-match rate
~3,000
Transactions / mo
8
Clearing accounts
CAD + USD
Currencies
NetSuite SuiteQLFloat APITipaltiPlaywrightPythonExcel
02

Revenue Reconciliation

Deal-level recon across HubSpot ↔ NetSuite ↔ Zuper.

Matches ~550 monthly deals across HubSpot, NetSuite, and Zuper field-service jobs. Classifies variances as FX, timing, or true discrepancy and ships results to a hosted dashboard with five drill-down views.

~550
Deals / mo
3
Source systems
FX · Timing · Real
Variance classes
5
Dashboard views
HubSpot CRMNetSuite SuiteQLZuperFastAPINotion API
03

Rebate Lockbox Cash Application

OCR + fuzzy address matching for utility rebate cheques.

Extracts rebate-cheque details from Xcel Energy lockbox PDFs (amount, remittance address, cheque date), fuzzy-matches against NetSuite Sales Order memos, and posts via Customer Payment or Journal Entry.

~100
Rebates / mo
$4K – $8.6K
Avg cheque
4
PDF pages / cheque
Validated 100% on sample
Match accuracy
OCR / PDF parsingNetSuite SuiteQLPlaywrightPythonFuzzy matching
04

AR Aging Dashboard

Customer + rebate aging with loan-aware payment chase.

Unified aging view combining direct customer receivables and government rebate receivables from HubSpot and NetSuite. Generates loan-aware payment reminder drafts — financed customers are excluded from direct chase so the AR team never contacts a customer whose balance is settling through a financing partner.

Customer + Rebate
Aging views
HubSpot + NS
Source
Loan-aware
Filter logic
Dashboard + emails
Output
HubSpot CRMNetSuite SuiteQLEmail templates

Work

NetSuite Administrator & Automation Lead @ Jetson Home · North Vancouver, BC

April 2025 – Present

Vertically integrated heat pump company; ~120 employees, multi-state operations (BC, CO, MA, NY).

  • ·Led full NetSuite OneWorld 2025.1 implementation migrating from QuickBooks: 2 subsidiaries (CAD/USD), Advanced Inventory, multi-location matrix BOMs, custom segments and transaction fields
  • ·Designed a custom multi-BOM solution working around NetSuite's geographic-matrix limitations to support installation kits across 4 state markets
  • ·Automated end-to-end Order-to-Cash with zero manual intervention from HubSpot deal → NS Sales Order → Invoice → Cash Application
  • ·Rolled out Procure-to-Pay via Tipalti Bill Capture (Coupa-equivalent for AP) covering ~500 bills/month
  • ·Owned ongoing integrations across Stripe, Rippling (HR/Payroll), Avalara, Float, Arena (PLM), HubSpot, Zuper, and RBC/SVB banking feeds
  • ·Designed and delivered four production finance-automation solutions for Jetson's finance team (see Agents above)

Director & Founder @ SixArc Tech Ltd.

Oct 2022 – April 2025

Independent NetSuite consulting firm specializing in implementations and integrations.

  • ·Delivered NetSuite implementations and integrations across multiple clients — Order-to-Cash, Procure-to-Pay, Record-to-Report, GL/AR/AP
  • ·Built saved searches and reports for AP/AR, income statement, GL impact, asset and inventory valuation; architected three-way match (PO ↔ Receipt ↔ Bill) processes
  • ·Customized Celigo integration flows; delivered Shopify ↔ NetSuite integrations; advised enterprise clients on technology roadmaps

Information Systems Manager @ Princess Polly · ASX:AKA

Feb 2020 – Sept 2022

Public e-commerce company; managed NetSuite for US and AU subsidiaries.

  • ·Managed and developed NetSuite ERP across US/AU subsidiaries with full international financial reporting
  • ·Delivered 40+ Celigo integration flows between NetSuite and Shopify, Inventory Planner, Whiplash WMS, Accentuate, Bronto
  • ·Supported SOX compliance: implemented OneLogin SSO, role-based access controls, key financial reports per Finance dept requirements
  • ·Owned vendor relationships, scoping, design, implementation, and post-go-live support across all integration projects

Business Systems Manager @ My Vape Order

Dec 2018 – Feb 2020
  • ·Led NetSuite ERP support, troubleshooting, training, and module rollouts; maintained B2B website on Suite Commerce Advanced + Shopify
  • ·Drove requirements gathering with stakeholders to deliver architecture and design solutions

IT Manager @ Sunnest Services LLC

July 2016 – March 2018
  • ·Implemented Advanced Inventory, Bin Management, RF-SMART WMS, and integrated shipping module
  • ·Delivered 11 EDI projects (846/850/856/810) between Sunnest and big-box retailers; automated 846 inventory feeds to prevent backorders
  • ·Managed a team of 5–8; reduced IT spend ~50% through vendor consolidation

NetSuite Consultant @ Xtensegrity (d/b/a Premier Consulting Group)

Aug 2015 – April 2016
  • ·Contributed to SFX Entertainment's 70+ entity global NetSuite OneWorld rollout, personally taking 6–7 subsidiaries live; also implemented NetSuite OpenAir (PSA) for services-industry clients
  • ·Full-lifecycle ERP delivery across Media, Manufacturing, and Distribution verticals

Skills

ERP & Finance Systems

NetSuite OneWorldSuiteQLWorkflowsSaved SearchesAdvanced InventoryMulti-BookTipalti (P2P)StripeAvalaraFloatRipplingArena PLMSuite Commerce Advanced

Integrations & Middleware

Celigo (40+ flows)Zapiern8nREST / SOAP APIsOAuth 1.0 TBAWebhooksEDI 846 / 850 / 856 / 810

AI-Augmented Delivery

Claude Code skillsMCP serversAgent orchestrationSpec authoringPrompt engineeringValidation & QA

Compliance & Governance

SOX ITGCsAccess managementChange managementAudit readinessOneLogin SSORole-based permissions

Contact

778-512-5442
North Vancouver, BC

© 2026 Vinayak Rangrez