Senior NetSuite ERP
Techno-Functional Consultant & Architect

Procurement and AP teams faced massive monthly backlogs manually verifying PO unit rates and received warehouse quantities against vendor invoices, causing invoice processing delays and risk of duplicate payments.

Constructed an interactive Suitelet reconciliation dashboard for dynamic discrepancy filtering and multi-criteria queries, paired with Map/Reduce batch scripts for multi-subsidiary automated invoice matching and automated approval routing.

1. Business Requirements Document (BRD) & Tolerance Matrix Definition → 2. SuiteScript 2.1 Query Optimization → 3. UAT Testing with AP/Procurement Leads → 4. Production Rollout & CSV Audit Reporting.

Accounting teams spent over 30 hours per month manually generating PDF statements, cross-referencing subledger balances, and drafting individual emails to hundreds of vendors, customers, and employees.

Implemented Advanced PDF/HTML FreeMarker template engine with custom currency formatters and a Map/Reduce queue extracting recipient lists across entity join records with delivery audit logging.

1. Financial Statement Template Schema Design → 2. Scheduled Batch Trigger Architecture → 3. Multi-Recipient Email Handling & Rate-Limiting → 4. Live Production Cutover.

Manual re-entry of vendor bills, purchase orders, and item catalog updates between legacy systems and NetSuite resulted in data lag, inventory discrepancies, and fulfillment bottlenecks.

Constructed RESTlets utilizing Token-Based Authentication (TBA), JSON payload validation, idempotent request keying, and asynchronous error-handling queues for automated retry on concurrency locks.

1. Data Contract & Schema Mapping → 2. RESTlet & FastAPI Middleware Build → 3. Token-Based Auth (TBA) & Webhook Security Setup → 4. End-to-End Stress Testing → Go-Live.

High warehouse inventory churn led to human error in lot assignment, inventory expiration write-offs, and delayed Transfer Order fulfillment across regional hubs.

Built RESTlet endpoints for mobile warehouse indenting, combined with Client Scripts calculating nearest expiration lots (FEFO) and User Events validating picked quantities before line commitment.

1. Warehouse Process Mapping → 2. FEFO Algorithm & RESTlet API Design → 3. Handheld Scanner & Sandbox UAT → 4. Multi-Hub Rollout.

Multi-location cash and inventory transfers required tedious manual Journal Entries to correct balance sheet discrepancies across regional bank accounts and subsidiary nodes.

Leveraged NetSuite's Custom GL Lines plug-in framework to programmatically calculate and append balancing GL impact lines directly to native transaction posting records without manual intervention.

1. Chart of Accounts (COA) Alignment → 2. Custom GL Script Development → 3. Financial Audit & Trial Balance Validation → 4. Production Go-Live.

Client organizations operating on legacy, siloed systems suffered from data redundancy, lack of visibility into inventory and cash flows, and operational downtime during transitions.

Orchestrated the 5-phase ERP implementation lifecycle: Scope & BRD → Master Data Migration (ETL) → Functional Configuration → Rigorous UAT & SOP Authoring → Go-Live Cutover & Stabilization.

Heavy volume transactional data from third-party logistics providers required continuous validation, transformation, and ingestion into NetSuite without overloading governance quotas.

Constructed an asynchronous FastAPI backend utilizing Pydantic data schemas, asynchronous HTTP pooling, and PostgreSQL staging queues with bi-directional NetSuite RESTlet webhooks.

1. API Contract Definition → 2. FastAPI Pipeline Development → 3. Webhook Security & Token Auth → 4. High-Load Stress Testing → Deployment.

Store managers and finance teams spent hours every day manually formatting store indents into Sales Orders and Transfer Orders, calculating multi-location stock wastage adjustments, and restructuring raw data for ERP CSV uploads.

• Indent-to-SO / TO Engine: Automated multi-location store indent parsing, validation, and auto-conversion into ERP-ready Sales Orders and Transfer Orders.
• Wastage & Inventory Adjustment Toolkit: Automated dynamic warehouse wastage calculations, batch lot matching, and bulk adjustment file generation.
• Item-to-Bin Mapping & Zero Inventory Master: Master data ETL toolkit automating warehouse bin assignments and store replenishment rules.
• CSV Exporters & Column Splitter: Macro looping over regional columns to automatically generate clean, individual subsidiary CSV import workbooks.

1. Operational Workflow & Template Standardization → 2. Modular VBA Development & Error Handling → 3. Data Integrity & Reconciliation Checks → 4. Deployment across Regional Store & Warehouse Operations.