Loading portfolio
00
HNF · 2026
Muhammad Hanif Abdurrahman
Cisauk · Indonesia · GMT+7
Portfolio · v4.0
Issue №01
MMXXVI
Digital Marketing — Engineering · Data · Systems

Muhammad Hanif Abdurrahman.

About

A portfolio of integrations, dashboards, and internal systems — built by someone who writes the SQL, ships the code, and runs the funnel.

Available · 2026
Contact
Index
Scroll
(01) — About

An operator who codes.

I turn messy operations into clean systems — by understanding the data, building the integrations, and wiring it back into the funnel.

I'm on the Digital Marketing team at Trilogy, but my scope is full-stack across the business: frontend for customer tooling, backend for the integration layer that connects commerce ↔ ERP ↔ WMS, data for the Metabase / Looker dashboards the team reads, and systems for the internal trackers leadership runs on.

Most of my career has been at small companies where the title doesn't matter as much as throughput. I've been the warehouse, the storefront, the developer, and the analyst — sometimes in the same week. That end-to-end exposure is the angle I bring.

Discipline
Digital Marketing Engineering — Frontend, Backend, Data & Systems
Strengths
End-to-end thinking, systems integration, data modeling, marketing automation
SQLMetabaseLookerApps ScriptMeta API
Engineering
Full-stack — frontend, backend, integrations
JS / TSNodeHTML/CSSRESTWebhooksJava
Systems
AccurateWMSWebstoreMeta APICloudflare
Domain
E-commerce ops · manufacturing workflows · full-funnel digital marketing
Languages
Bahasa Indonesia (native) · English (professional)
(02) — Impact

By the numbers.

Outcomes from production dashboards across a manufacturing group, a self-run e-commerce business, and an R&D lab internship.

Trilogi · 2025
1layer
Passive integration between webstore and WMS — eliminating manual order / stock reconciliation.
Trilogi · 2025
Live
Metabase dashboard pulling realtime data directly from the Meta API for marketing.
Trilogi · 2025
BOD
Internal tracker consolidating department KPIs for the Board of Directors.
Trilogi · 2025
80%
Reduction in manual data entry after deploying the sales ops dashboard.
Trilogi · 2025
40%
Faster app & DFS verification approval cycle after restructuring ops.
Trilogi · 2025
25%
Lift in qualified sales pipeline after rewriting segmentation & funnel.
Aquariumin · 2021–26
200k+
Total sales across Shopee, Tokopedia, Lazada and TikTok Shop at 4.9 average rating.
Aquariumin · 2023
3×
ROI from an affiliate launch — designed, briefed, and tracked end-to-end.
Aquariumin · 2022
95%
Data-entry coverage via custom scrape + ingest pipeline.
(03) — Experience

Where I've operated.

Jan 2025 — Present
Tangerang, ID
PT. Trilogi Berjaya Bersama
Digital Marketing — Frontend · Backend · Data · Systems

Built a passive integration layer connecting the webstore to the WMS — orders, stock, and fulfillment flow without manual re-entry.

Shipped a product catalog system wired into Accurate as the source of truth for SKU, pricing, and stock.

Built an internal URL shortener used across campaigns and sales, with click tracking feeding the attribution layer.

Stood up a self-hosted Metabase pulling real-time data from the Meta API for the marketing team.

Built an internal BOD tracker consolidating KPIs across sales, ops, and marketing into one live view.

Shipped sales dashboard (Apps Script + Looker) replacing an 80%-manual reporting flow; cut DFS approval 40%; lifted pipeline 25%.

May 2021 — Present
Self-run · ID
Aquariumin
Founder · Head of Operations

Run the full e-commerce stack — Shopee, Tokopedia, Lazada, TikTok Shop — including ads, listings, fulfillment, and CS.

Over 200,000 sales processed at a 4.9 average rating across platforms; complaint rate held under 3%.

Shipped a custom substrate calculator and an internal ops web app to remove repetitive labor.

Hit 3× ROI on an affiliate launch and 50% MoM growth in the first three months post-launch.

2020 — Mar 2021
Bogor, ID
Pusat Studi Biofarmaka Tropika (IPB)
Frontend Developer · Internship

Built frontend tooling for a chemical research lab using HTML, CSS, and JavaScript.

Worked alongside researchers to translate lab requirements into usable interfaces.

(04) — Selected work

Things I shipped.

Each one solves a problem I traced from a spreadsheet, then closed by writing the code.

№ 01 · Integration

Webstore ⇄ WMS Integration Layer.

Trilogi · Backend · Passive sync

A passive middleware that keeps the webstore and the warehouse management system in sync — orders, stock movements, and fulfillment flow without anyone touching a spreadsheet. Designed to fail loudly, log everything, and recover on its own.

StackNode · REST · Webhooks ImpactRemoved manual re-entry StatusLive in production
FIG · 01 — DATA FLOWLIVE
WEBSTORE WAREHOUSE SKU · STOCK · PICK INTEGRATION LAYER ORDERS · STOCK · FULFILLMENT
№ 02 · Catalog

Accurate-Connected Product Catalog.

Trilogi · Backend · Data

A product catalog wired directly into Accurate. SKU, pricing, and stock are read from Accurate as the source of truth, then pushed to customer-facing surfaces — eliminating the drift that used to require a Friday reconciliation meeting.

SourceAccurate (ERP) StackREST · Cron · Node UsersSales · Marketing · Ops
FIG · 02 — STACKSYNCED
SKU-A100 Rp 1.250.000 SKU-B204 Rp 880.000 SKU-C047 Rp 2.100.000 ACCURATE · SOURCE OF TRUTH SYNC ZERO DRIFT SKU · PRICE · STOCK
№ 03 · Attribution

Trilogy URL Shortener.

Trilogi · Frontend · Edge

An internal short-link service for Trilogy — used across campaigns, sales decks, and internal docs. Captures click data so marketing can attribute traffic to the right channel and ad set, instead of guessing from UTM strings nobody fills in correctly.

StackCloudflare Workers · KV · JS Use caseCampaign tracking OwnerDigital Marketing
FIG · 03 — TRANSFORMCDN EDGE
https://trilogy.co.id/campaign/promo?utm_source=meta&id=xyz123 EDGE FN trl.gy/x9p2 CLICKS / 24H 1,284 CHANNEL Meta · 62% P95 14ms
№ 04 · Realtime BI

Metabase × Meta API.

Trilogi · Data · BI

A self-hosted Metabase pulling live data from the Meta API. Spend, reach, CPM, and conversion render in near real-time so the marketing team can stop waiting for tomorrow's report to make today's decision.

SourceMeta Marketing API StackMetabase · SQL · Node RefreshRealtime
FIG · 04 — DASHBOARDREALTIME
META · ADS PERFORMANCE SPEND Rp 24.8M REACH 412k CPM 18.4k CVR 3.2% SOURCE · META MARKETING API
№ 05 · Leadership

Internal BOD Tracker.

Trilogi · Systems · Leadership

A single-pane KPI tracker for the Board of Directors. Pulls from sales, ops, and marketing into one live view — replaced a brittle weekly slide deck and cut decision latency for leadership.

AudienceBoard of Directors StackWeb · Apps Script · SQL RefreshLive
FIG · 05 — KPI TILESLIVE
REVENUE · MTD Rp 412M ↗ +18% vs LM PIPELINE 1.2B ↗ +25% vs LM CAC · BLENDED Rp 84k → -3% vs LM CONVERSION 15% ↗ +15% vs LM BOD · LIVE BOARD UPD · 14s AGO
№ 06 · Operations

Inventory Automation System.

Trilogi · Aquariumin · Ops

Batch-based production automation in Apps Script, replacing a multi-sheet manual workflow. Tracks production logs, inventory and cross-department handoffs across 6 manufacturing departments — like a factory floor that finally talks to itself.

Departments6 StackApps Script · Sheets API StatusLive
FIG · 06 — FACTORY FLOORRUNNING
6 DEPT · LIVE BATCH PRODUCTION OUTPUT →
№ 07 · BI

Sales Performance Dashboard.

Trilogi · Aquariumin · Reporting

Integrated dashboard built on Google Sheets, Apps Script and Looker Studio. Pulls from CRM, ads platforms and the master sheet, and renders region-level performance for management. Replaced a brittle weekly slide deck.

Manual time−80% StackApps Script · Looker UsersCEO · Sales Mgr
FIG · 07 — REGION VIEWDAILY
REVENUE BY REGION JABODETABEK Rp 184M JAWA BARAT Rp 124M JAWA TENGAH Rp 96M JAWA TIMUR Rp 72M SUMATERA Rp 48M KALIMANTAN Rp 32M ABOVE TARGET BELOW TARGET −80% MANUAL TIME
№ 08 · Sales Ops

Dynamic Sales Input Form.

Trilogi · Sales Ops

Custom sales reporting form with auto-suggestions and validations for sales reps in the field. Cut data-entry processing time and improved downstream data quality for BI.

Processing−80% Coverage95% OwnersSales team
FIG · 08 — FORMVALIDATED
SALES ENTRY · NEW CUSTOMER PT. Mitra Sejahtera SKU SKU-A100 · Premium Edition QTY · PRICE 12 Rp 1.250.000 SUBMIT → VALIDATED · SAVING TO BIGSHEET...
№ 09 · Customer Tool

Substrate Calculator.

Aquariumin · CX

A small public web tool helping aquascape customers calculate the right substrate volume for their tank. Reduced "wrong amount" complaints and lifted conversion on consultation chats.

Use casePre-purchase StackJS · HTML/CSS EffectCX uplift
FIG · 09 — CALCULATORPUBLIC
L × W × H · cm 60 × 30 × 8 RECOMMENDED 14.4 KG → ADD TO CART REDUCED “WRONG AMOUNT” COMPLAINTS
(05) — Case study · Aquariumin

Running a 200k-order e-commerce business as a two-person ops team.

Aquariumin operations

Context. Aquariumin is an aquascape e-commerce brand my friend and I started in 2021 across Shopee, Tokopedia, and TikTok Shop. No external funding, no operations hire, just a developer and a designer who wanted to understand commerce from the inside.

Approach. Treat the storefront as a system, not a hustle. Every recurring action gets a script, a sheet, or a tool. Every complaint gets traced back to a process, not a person.

Outcome. Over 200,000 sales at a 4.9 average rating across platforms, sub-3% damaged-goods rate, 3× ROI on an affiliate launch, and internal tooling that now runs at Trilogi too.

What I built. A custom inventory and order-routing layer across all four marketplaces, an internal substrate calculator, and a small dashboard that surfaces top SKUs, returns, and ad-spend efficiency in one view.

What I learned. The same instincts apply at a manufacturing company: data hygiene is a team sport, the dashboard is only useful if someone reads it, and the cleanest funnel is the one with the fewest manual steps.

200k+
Total sales
4.9 ★
Avg. rating
Affiliate ROI
<3%
Damage complaints
(06) — Toolkit

What I work with.

01

Frontend

UI for internal tools and customer-facing surfaces — built to be readable and shippable today.

HTMLCSSJS / TSTailwind
02

Backend & Integrations

The layer that quietly moves data between webstore, ERP, WMS, and marketing APIs.

Node.jsRESTWebhooksCronJavaC++
03

Data & BI

Modeling, dashboarding and the boring data-cleaning work that makes them trustworthy.

MetabaseLookerSQLSheetsBigQuery
04

Systems

Where the marketing stack meets the operations stack — the bits that have to talk to each other.

AccurateWMSWebstoreMeta APICloudflare
05

Digital Marketing

Full-funnel: from creative brief to media buying to attribution back to the dashboard.

Meta AdsTikTok AdsGoogle AdsSEO/SEMAffiliate
06

E-commerce Ops

Listing, pricing, inventory and CS workflows across Indonesian marketplaces.

ShopeeTokopediaLazadaTikTok ShopBukalapak
(07) — Contact

Let's work.

If you're hiring for a role that sits between digital marketing, engineering, and operations — or you just want to talk funnels — reach out.

Say hello
Email
Phone
LinkedIn
HNF · Portfolio · MMXXVI
Cisauk · Indonesia
Issue №01