Skip to content

Latest commit

 

History

9 Commits

Folders and files

NameName
Last commit message
Last commit date
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Karan Deepak Arora — Senior NetSuite ERP Techno-Functional Consultant

Live Portfolio LinkedIn Resume PDF Experience Education

An enterprise-grade professional showcase highlighting end-to-end ERP techno-functional architecture, full-lifecycle implementations, SuiteScript 2.1 engineering, API integrations, and corporate financial systems optimization.


👨‍💼 Executive Profile

Senior NetSuite ERP Techno-Functional Consultant and Solutions Architect with 5+ years of hands-on experience delivering scalable enterprise transformations. Combines corporate financial acumen (MBA in Finance) with deep technical engineering across SuiteScript 2.1, bi-directional integration APIs (PO & Vendor Sync), full-lifecycle ERP migrations (5 go-lives), and automated Excel VBA macro toolkits.


🛠️ Core Competencies & Technical Matrix

Domain Key Capabilities & Technologies
NetSuite Technical SuiteScript 2.1 (Suitelet, Map/Reduce, User Event, Scheduled, RESTlet, Client Script, Custom GL Plugins), SuiteFlow, SuiteBuilder, Saved Searches, SuiteAnalytics
ERP Business Processes Procure-to-Pay (P2P), Order-to-Cash (O2C), 3-Way Matching, General Ledger (GL/AP/AR), Inventory Management, FEFO Lot Allocation, Fixed Assets
ERP Implementations 5 Full-Lifecycle Go-Lives: Scoping & BRD/SDD, Master Data ETL Migration, UAT Scripting & Execution, Go-Live Cutover & Managed-Services Hypercare
Integration & Middleware Token-Based Authentication (TBA), RESTlet APIs, Python 3, FastAPI, PostgreSQL, Webhook Event Handlers, Postman
Task Automation & Macros Advanced Excel Modeling, VBA Macro Toolkits, Indent-to-SO/TO, Wastage Adjustments, Item-to-Bin Mapping, Dynamic CSV Exporters, Power Query
Academic Foundation Master of Business Administration (MBA) in Finance (Jul 2025 – Present) | Bachelor of Management Studies / B.B.A (2021)

📂 Featured Enterprise Case Studies

1. NetSuite 3-Way Reconciliation & AP Automation Engine

Automated 3-way matching framework comparing Purchase Orders (PO), Item Receipts (IR), and Vendor Bills (VB) with configurable quantity/price tolerance limits, line-level discrepancy detection, automated bill approvals, and variance exports.

  • Key Stack: SuiteScript 2.1, Suitelet Interactive Dashboard, Map/Reduce Batch Engine.
  • Measurable ROI: 70%+ Reduction in Manual AP Reconciliation Effort & Zero Overpayments.

2. Dynamic Financial Statements & Bulk Email Dispatch Engine

Engineered high-volume Scheduled & Map/Reduce engines generating dynamic Customer, Vendor, and Employee Statements using Advanced PDF/HTML Templates with automated multi-recipient email distribution and audit logging.

  • Key Stack: Scheduled Script, Map/Reduce, Advanced PDF/HTML, FreeMarker Engine.
  • Measurable ROI: 1,000+ Automated Monthly Statements Delivered Hands-Free.

3. Bi-Directional NetSuite ERP Integration APIs (PO Sync, Vendor Sync & Item Master)

Architected secure RESTlet and FastAPI integration connectors synchronizing Purchase Orders (PO), Vendor Masters, Item Masters, and inventory adjustments with external 3PL portals, supplier platforms, and POS networks.

  • Key Stack: RESTlets, Token-Based Auth (TBA), Python 3, FastAPI, Webhooks.
  • Measurable ROI: Real-Time Data Parity Across Connected Enterprise Systems.

4. Transfer Order Indenting & FEFO Inventory Fulfillment Engine

Engineered RESTlet APIs, User Event automations, and Client Script validations automating multi-location Transfer Order indents, First-Expiry-First-Out (FEFO) lot allocation, and real-time fulfillment controls.

  • Key Stack: RESTlets, User Event, Client Scripts, SuiteFlow, Inventory FEFO.
  • Measurable ROI: 100% Elimination of Expired Stock Shipments & Optimized Inter-Warehouse Transfers.

5. Custom GL Impact Plugin & Multi-Branch Banking Revaluations

Engineered a Custom GL Impact Plugin dynamically injecting balancing debit/credit journal entries upon transaction creation to handle inter-branch location transfers and multi-account banking adjustments.

  • Key Stack: Custom GL Lines Plugin, General Ledger Accounting, SuiteScript 2.1.
  • Measurable ROI: 100% Automated GL Balancing & Full Statutory Audit Compliance.

6. Full-Lifecycle ERP Implementation & Migration Track Record (5 Go-Lives)

Led end-to-end ERP implementations across diverse industries: Oil & Gas (Legacy E12 Migration), Specialty Chemicals & Pharmaceuticals (SCM/Finance/Manufacturing), Healthcare Distributors (HR), and Industrial Laboratories (Fixed Assets).

  • Key Stack: Vision ERP, Scoping & BRD/SDD, Master Data Migration (ETL), UAT Execution, Change Management.
  • Measurable ROI: 5 Multi-Month Enterprise Implementations Delivered On-Schedule.

7. Daily Task Automation & Corporate Excel VBA Macro Suite

Engineered modular VBA automation toolkits and Power Query data pipelines to eliminate repetitive daily operational tasks across retail store indents, warehouse wastage calculations, item-to-bin mappings, and multi-branch data consolidations.

  • Key Stack: VBA Macros (Indent_To_SalesOrder, Indent_To_TransferOrder, WastageInventoryAdjustment, Item - Bin Map), Power Query.
  • Measurable ROI: 90% Reduction in Daily Manual Data Entry & Zero Upload Errors.

📁 Repository Structure

├── index.html                   # Semantic HTML5 single-page layout & Schema.org JSON-LD
├── robots.txt                   # Search crawler indexing directives
├── sitemap.xml                  # XML sitemap for search engine discovery
├── vercel.json                  # Edge routing & security headers
├── README.md                    # Executive profile & portfolio showcase
└── assets/
    ├── css/
    │   └── style.css            # Light corporate design system & responsive drawer
    ├── js/
    │   └── main.js              # Dynamic experience calculation, category filtering, form handlers
    ├── docs/
    │   └── Karan_Arora_Resume.pdf # Official ATS-compliant 2-page PDF resume
    └── images/
        └── og-preview.png       # 16:9 corporate preview banner for LinkedIn

📄 Professional Discretion & Confidentiality

© 2026 Karan Deepak Arora. All rights reserved.
All enterprise case studies and architectural implementations presented in this repository have been anonymized to ensure full compliance with client Non-Disclosure Agreements (NDAs).

Releases

Packages

Contributors

Languages