---
title: "Automation & Systems Catalogue"
url: https://janarraj.com.my/projects/
date: 2026-09-14
modified: 2026-09-17
lang: en
author: ""
description: "A source-backed catalogue of the workflows connecting sales, finance, customer service, local presence and reporting."
word_count: 604
---

# Automation & Systems Catalogue

[Home](/)/Automation & Systems
{ AUTOMATION & DATA SYSTEMS }

# Production Automations. Enterprise Reliability.

A source-backed catalogue of production workflows connecting retail point-of-sale, marketplaces, finance reconciliation, advertising audience signals, and local search operations.

{ OMNICHANNEL COMMERCE & MARKETPLACES }

## Marketplace Ingestion, Orders & Compliance

[

MARKETPLACE AUTOMATION
PRODUCTION ACTIVE

## Marketplace Sales & LHDN E-Invoice Pipeline

Automated multi-thousand order ingestion, branch fulfillment attribution, and statutory bi-monthly LHDN e-invoice generation across Shopee and TikTok Shop.

n8n
Shopee API
TikTok Shop
LHDN E-Invoicing
Google Sheets API

Explore the system ↗
](/projects/marketplace-sales-einvoice-pipeline/)

[

ORDER DISPATCH
PRODUCTION ACTIVE

## Website Order Routing & WhatsApp Notification

Transforms incoming web order confirmations into structured vehicle and customer payloads, alerting on-duty support teams via WhatsApp in under 3 seconds.

n8n
Evolution API
Gmail Webhook
Regex Parser

Explore the system ↗
](/projects/website-order-routing/)

[

CHAT COMMERCE
PRODUCTION ACTIVE

## WhatsApp Sales Automation & CRM Pipeline

Captures conversational enquiry data, extracts customer intent parameters, and connects direct chat interactions to closed retail sales in real-time.

WhatsApp API
n8n
PostgreSQL
Closed-Loop CRM

Explore the system ↗
](/projects/whatsapp-sales-automation/)

{ RETAIL OPERATIONS & FINANCE }

## Sales Ingestion, Reconciliation & POS Data

[

FINANCIAL AUDIT
PRODUCTION ACTIVE

## Automated Retail Sales & Payment Reconciliation

Daily POS sales extraction, multi-branch growth transposition, and automated payment gateway settlement matching across 50+ nationwide physical stores.

n8n
POS / BMS
Gateway Reconciliation
Variance Detection

Explore the system ↗
](/projects/retail-sales-reconciliation/)

[

DATA PIPELINE
PRODUCTION ACTIVE

## POS to PostgreSQL Migration & Sync Engine

Backfilled 100k+ historical retail sales records across paginated REST APIs and established real-time relational SQL synchronization with zero data loss.

PostgreSQL
n8n Loop
REST API
Idempotent Upsert

Explore the system ↗
](/case-studies/pos-to-postgresql-migration/)

[

MASTER DATA
PRODUCTION ACTIVE

## Marketing Data Architecture & Branch Master Sync

Centralizes disparate retail, e-commerce, and advertising streams into an audit-proof relational warehouse with automated cross-platform branch validation.

PostgreSQL
Branch Masterlist
Looker Studio
Docker Compose

Explore the system ↗
](/projects/marketing-data-architecture/)

{ PERFORMANCE MEDIA & AUDIENCE INTELLIGENCE }

## First-Party Signals, Reporting & AI Workflows

[

AUDIENCE SIGNALS
PRODUCTION ACTIVE

## First-Party Audience Signal & Delivery Queue Engine

Sanitizes, hashes, and partitions offline customer purchase data across 14 Malaysian states to feed Google & Meta Ads algorithms, paired with high-volume dispatch queue parsing.

Google Customer Match
Meta CAPI
SHA-256
Queue Processing

Explore the system ↗
](/projects/first-party-audience-signals/)

[

EXECUTIVE REPORTING
PRODUCTION ACTIVE

## Automated Cross-Channel Performance Reporting

Extracts campaign insights across Google Ads, Meta Ads, and GA4 to generate automated weekly executive summaries and AI-synthesized trend briefings.

Google Ads API
Meta API
GA4 API
AI Executive Briefs

Explore the system ↗
](/projects/automated-reporting-workflows/)

[

SEARCH INTELLIGENCE
PRODUCTION ACTIVE

## SEO Intelligence & AI Topic Synthesis Workflow

Automated Ahrefs keyword extraction, commercial intent clustering, and machine-readable content outline generation for high-impact search dominance.

Ahrefs API
LLM Topic Synthesis
Intent Clustering
Content Briefs

Explore the system ↗
](/projects/seo-intelligence-workflow/)

{ LOCAL OPERATIONS & INFRASTRUCTURE }

## Store Network Sync & Self-Hosted Systems

[

STORE LOCATIONS
PRODUCTION ACTIVE

## Cross-Platform Store Location Synchronization

Synchronizes physical retail store coordinates, opening hours, and contact numbers directly from Google Business Profile API to Meta Business Manager Store Locations.

Google Business Profile API
Meta Graph API
Geo-Coordinates

Explore the system ↗
](/projects/meta-location-synchronisation/)

[

REPUTATION MONITORING
PRODUCTION ACTIVE

## Google Business Profile Review Tracker & Alerting

Continuous multi-location review monitoring, sentiment analysis, and instant low-rating alert triggers across 100+ retail branches nationwide.

GBP API
Sentiment Alerting
Webhook Dispatch
Review Governance

Explore the system ↗
](/projects/google-business-profile-monitoring/)

[

INFRASTRUCTURE
PRODUCTION ACTIVE

## Self-Hosted Marketing & Automation Infrastructure

A Docker-based, private Linux server stack orchestrating n8n workers, PostgreSQL relational databases, Redis queues, and reverse proxies with zero per-task SaaS fees.

Docker Compose
Linux VPS
PostgreSQL
Zero SaaS Fees

Explore the system ↗
](/projects/self-hosted-marketing-infrastructure/)

{ YOUR NEXT AUTOMATION MOVE }
[Let’s connect↗](/contact/)

Have an operational bottleneck, data silo, or manual workflow?
Let's engineer an automated solution that lasts.

[Start a conversation ↗](/contact/)