Blog

Thoughts & Stories

Sharing my experiences, learnings, and adventures in tech and beyond.

Browse by Topic

DevOps & Cloud Infrastructure (138)AI & LLMs (102)Web Development (81)ERP Systems (72)Backend & APIs (60)Software Development (52)Security (28)Career Reflections (27)Cloud (15)Product & SaaS (12)AI / Machine Learning (5)University (1)Hackathons (1)

Migrating from Excel to a Custom ERP: Data Mapping, Validation, and Cutover Strategy

ERP

June 202510 min read

Migrating from Excel to a Custom ERP: Data Mapping, Validation, and Cutover Strategy

A practical guide to migrating years of business data from Excel spreadsheets into a custom ERP — covering data mapping, Zod validation, bulk import scripts in NestJS, and a safe cutover strategy for Indonesian SMEs.

Role-Based Access Control in a Custom ERP: NestJS Guards, PostgreSQL Permission Tables, and UU PDP Compliance

ERP

June 20259 min read

Role-Based Access Control in a Custom ERP: NestJS Guards, PostgreSQL Permission Tables, and UU PDP Compliance

How to design and implement a production-grade RBAC system for a custom ERP — covering the PostgreSQL permission schema, NestJS custom guards, Redis-cached permission lookups, and compliance considerations under Indonesia's UU PDP.

Building an ERP Audit Trail and Activity Log: PostgreSQL, NestJS Interceptors, and React Activity Feed

ERP

June 20258 min read

Building an ERP Audit Trail and Activity Log: PostgreSQL, NestJS Interceptors, and React Activity Feed

How to implement a comprehensive audit logging system for a custom ERP — covering PostgreSQL schema design, NestJS interceptor-based logging, JSONB snapshots of before/after state, and a React activity feed component.