SYAIFUL EFENDI, S.T.
Senior Management Reporting & Process Improvement
Executive Data & Operational Controller specializing in Power BI architecture (15+ Modules, 50+ Dashboards), end-to-end container logistics control, CEISA Customs clearance automation, and Full-Stack internal web systems engineering.
Dossier Content Directory Index:
Operational Philosophy & Executive Summary
Senior Professional with 15+ years of combined experience in IT Systems & Infrastructure, Advanced Data Analytics, Internal Audit (Good Corporate Governance & 5S), and Supply Chain & Logistics Process Improvement. Currently managing end-to-end management reporting for 4 major Business Units at PT Kamadjaja Logistics. Guided by the operational philosophy: "Minimize People, Maximize Process".
Core Strength: 3-Tier Stakeholder Orchestration
Operational AlignmentExperience Matrix by Domain
| Domain Category | Tenure | Core Capabilities & Methodologies |
|---|---|---|
| Data Analytics & BI | 8+ Yrs | Power BI Enterprise, DAX, Dynamic SVG, Power Query, Data Modeling, Scheduled Refresh |
| Spreadsheet Modeling | 12+ Yrs | Advanced Pivoting, Power Query, Financial Modeling, Power Pivot, Macro Automation |
| IT Systems & Network | 12+ Yrs | Windows Server, Active Directory, GPO, PRTG Network Monitor, Fortimail, Data Center |
| Logistics & Supply Chain | 8+ Yrs | Domestic & Exim Freight, TMS (Loginext, Flynd), WMS, HHT Barcode Scanners, GPS Fleet |
| Internal Control & Audit | 2+ Yrs | GCG Compliance, 5S Methodology, Risk Assessment, Corrective Action CAPA Validation |
Technical Proficiency Radar
Tenure by Discipline (Years)
| Judul Dashboard | Periode / Filter | Tentang / Deskripsi Utama |
|---|---|---|
| Monitoring Devices Used Within Warehouse | 2018 – 2022 | Memonitor perangkat operasional gudang (PM450, PM550, Tab Samsung), melacak lokasi, serial number, alokasi, serta status Return/Exist. |
| Delivery KPI Customer | Bulanan & Tahunan | Performa layanan pengiriman: kubikasi (CBM), coverage area, jumlah DO, Top DO Handling per vendor, & trip per armada/vendor. |
| GPS – Digilog Delivery | Bulanan & Tahunan | Status integrasi GPS, pelacakan shipment, scorecard pengiriman (74.63%), & monitoring kegagalan API/repost dengan peta GIS. |
| QSHIR Monitoring (I, II, III) | 2018 – 2020 | Dashboard Quality Assurance (QSHIR): status kasus (Open/Closed), aging, beban kerugian per PIC, & rincian klaim per Business Unit. |
| APPS Monitoring (eBR & KLOG Track) | 2016 – 2020 | Penggunaan aplikasi eBR & Klog Track, statistik user, aktivitas harian/bulanan, Top Approver, BR approval, & statistik Play Store. |
| Engineering Dept Monitoring | 2020 – 2021 | Aktivitas Work Request (WR) & Form Permintaan Barang (FPB) Engineering per site/lokasi beserta status pengerjaan & total expense. |
| Warehouse Stock Opname Dashboard | Real-time Periodik | Akurasi Stock Opname gudang: perbandingan fisik (Actual Scan Qty) vs System Qty, rincian SKU, Lot, Exp Date, & sub-inventory. |
| TMS Dashboard (I–IV) | Harian, Bln, Thn | Operasional pengiriman & driver: ritase, jarak tempuh, rating driver, Ontime Delivery, Check-in/out time, & kustomisasi 3 customer utama. |
| Gatepass System Dashboard (I–III) | Harian, Bln, Thn | Aktivitas keluar-masuk kendaraan (In/Out) gudang/pool, durasi docking (Dock In/Out), validity status, & analisis per transporter. |
| Issue Monitoring Dashboard | Periodik Proyek | Isu/kendala teknis proyek operasional, status (Open, In Progress, Closed), pengkategorian (People, Process, Technology), & PIC. |
| POC / Trial Monitoring Dashboard | Feb–Maret 2020 | Evaluasi uji coba aplikasi baru (KLOG-SIRCLO-FLYND), pemenuhan target fitur, durasi, & status Acceptable/Pending/Done. |
| Order / Shipment Monitoring (I–III) | Harian s/d Thn | Monitoring order harian-tahunan, Revenue vs Cost, deteksi Double Booking (anti-fraud klaim driver), & pelacakan Dokumen Balik (POD). |
| Judul Dashboard | Periode / Filter | Tentang / Deskripsi Utama |
|---|---|---|
| QA Monitoring Dashboard (I & II) | 2018 – 2022 | Rangkuman pekerjaan QA (Document Management, Pest Control, Environment/Utility, OIR Incident & Fraud Report), klaim, & utilitas listrik/air per site. |
| Corporate Security Monitoring (I & II) | Harian, Bln, Thn | Pemenuhan Manpower Security per site (status ideal/non-ideal), pemetaan wilayah berbasis GIS Map, kasus keamanan, & patroli QR Code. |
| General Affair (GA) Monitoring (I–III) | 2018 – 2022 | Pengawasan Aset, Air Bersih/Minum, Sewa Kendaraan, Grab, ATK, Dokumen GA, Perjalanan Dinas (PPD), BBM, & Scorecard 5S. |
| Procurement Dashboard East (Part I & II) | 2023 – 2024 | Sewa aset Timur: MHE (Forklift, Reach Truck), Properti Gudang, Trucking, Mobil Dinas, Perangkat ICT, Furnitur, Palet, & Peralatan Safety. |
| Procurement Dashboard West | Periodik 2024 | Pengadaan Barat: Sewa Trucking, Volume Orders, Truck On-Call, & Database Vendor. |
| Sales Bi-Weekly Dashboard | Mgg, Bln, Thn | Pencapaian Sales: Budget vs Actual (BVA), Target vs Achievement Revenue & Volume, serta Revenue Forecast. |
| Bon Sementara / Advance Settlement | 2023 – 2024 | Pengajuan Bon Sementara (Advance) & Settlement Operasional/Manajer, kelengkapan dokumen pendukung. |
| Commercial East | Periodik Kontrak | Masa berlaku kontrak komersial Timur (Active Contract Pelanggan & Pelayaran), Rute Shipping, & Min-Max Cost Dooring. |
| Novac – Claim East | 2022 – 2024 | Pelacakan status klaim & Notice of Loss/Accident (Novac) Timur beserta rincian nilai biaya penggantian kerugian. |
| Judul Dashboard | Periode / Filter | Tentang / Deskripsi Utama |
|---|---|---|
| CRM Huawei (PLS Huawei Monitoring) | Bulanan & Tahunan | Order & pengiriman internasional Huawei, Akurasi KPI, Milestone, Status CCWH/ATACC, & Finance & Cost Report. |
| CRM Procter & Gamble (P&G) | 2022 – 2024 | Order Impor & Ekspor P&G, rincian produk (Fabric Care, Skin Care), jenis kontainer, & performa ketepatan waktu. |
| International Freight Rev & Vol Monitoring | 2022 – 2024 | Evaluasi performa pendapatan (Revenue) & volume pengiriman International Freight Forwarding (IFF West) per pelanggan dan per bulan. |
| Domestic Freight Forwarding East | 2023 – 2024 | Operasional pengiriman domestik Timur: Order Summaries, Milestone, KPI, Status Vendor, Dooring Status, TEUs, & Shipment Tracker. |
| Domestic Freight Forwarding West | Periodik 2024 | Operasional pengiriman domestik Barat: Fulfilment, kedatangan armada, kelengkapan dokumen, KPI Vendor, & performa POD. |
| CRM United Tractors | 2022 – 2023 | Order pengiriman domestik United Tractors, perbandingan pencapaian target YoY, & rincian destinasi (Balikpapan, Sorong, Jayapura). |
| CRM Reckitt Benckiser Indonesia | 2023 – 2024 | Pengiriman khusus Reckitt Benckiser Indonesia, KPI pengiriman (KPI Delivery) & ketaatan dokumen balik (KPI POD). |
| CRM Nestlé Indonesia | 2023 – 2024 | Pencapaian KPI bulanan Nestlé Indonesia (Ontime Pickup, Ontime Delivery, Quality Services, Report Completeness, Incident/Compliance). |
| CRM Ultrajaya | Bulanan & Thn 2024 | Order pengiriman Ultrajaya, penggunaan armada truk harian/bulanan, performa KPI Line, & pemenuhan rute destinasi. |
| CRM Indofood | 2020 – 2021 | Pengiriman khusus Indofood: PLS East Export, PLS West Export, & PLS East Import berdasarkan kategori produk. |
| Rajawali Mentari Kargo (RMK) | Periodik 2024 | Order & pengiriman unit bisnis/mitra Rajawali Mentari Kargo (RMK) mencakup status order (Inbound/Outbound) & pencapaian KPI. |
Senior Management Reporting & Process Improvement
Executive Decision Support, BI Architecture & Strategic Review Coordination
- Enterprise BI Architecture: Architected & maintain 50+ Power BI dashboards across 15 modules with automated refresh (8x daily via Power Automate) and dynamic SVG visual coding.
- Executive Strategic Rhythm: Coordinator for all Branch/General Manager meetings including 1o1 Performance Reviews (2023–Current), COGS & Profitability Reviews (2024–2025), and National Sales Meetings. Formulated VP/BOD Sales Plan Visit schedulers and Sales Pipeline Updaters.
- Customer Portfolio Optimization Tool: Built Google Apps Script generator page to analyze FAT profitability data, enabling C-level executives to systematically determine client retention (Keep vs Drop unprofitable accounts).
- Project Manager - Field Mobile Apps: Spearheading mobile app development to record field & depo operations, digitizing physical handovers (DO, Bill of Lading, empty/laden container handling at shipping lines/depots).
- Cross-Functional Governance: Monitored national commercial tenders (Win/Loss tracking), formulated operational KPIs for salary adjustments, and oversaw executive attendance governance (Talenta & GreatDay).
Operational Control Tower & Financial Leakage Prevention
End-to-End Operational Scope (Domestic, Exim, Customs & Revenue Protection)
- Rapid Data Provisioning (Zero-Download): Architected standardized SharePoint/OneDrive collaborative pipelines for 50 users (30 editors, 20 viewers). Built-in custom query engines enable staff to GMs to access instant operational summaries without manual system downloads.
- End-to-End Lifecycle Execution: Supervise daily container operations across Jakarta & Surabaya hubs: Domestic (40–70 Ctr/day) and International Exim (10–20 Ctr/day) covering Order Received → Planner Execution → Delivery Control Center (TD Ship to Dooring) → Delivery Completion.
- NOVAC & Anti-Leakage Cost Recovery: Enforced incident-to-invoicing tracking for Non-Value-Added Costs (Storage, Demurrage, Detention) and freight claims with documented causality and third-party liability assignment, maintaining a 100% auditable cost recovery trail.
- POD-to-Cash Acceleration & Liquidity Protection: Bridged operational handoffs between Field Ops and Accounts Receivable (AR) to resolve Unbilled shipments post-dooring, compressing document transit turnaround to AR and eliminating billing lag to protect company liquidity.
- Customs Clearance Automation: Engineered Python & Batch (
.bat) automation routines to merge multiple CEISA customs files (21 sheets per file, 10–30 files per cycle), achieving a 98% time reduction compared to manual reconciliation.
Internal Control Analyst Officer
PT Kamadjaja Logistics & PT Pusaka Lintas Samudra
- Built YoY audit tracking dashboards in Power BI to monitor departmental compliance scores.
- Executed GCG routine and special audits, enforcing 5S methodology across warehouses and branch offices.
- Validated auditee CAPA actions and published monthly monitoring reports to executive management.
Business Solution Functional Transport Apps Officer
PT Kamadjaja Logistics
- Led project management for Transport Management Systems (Loginext TM & Flynd).
- Integrated TMS with Warehouse Management Systems (WMS) and 3PL partner networks.
- Active Administrator for the Power BI Indonesia Telegram Community, training users in DAX and data modeling.
IT GPS & Digital Mobility Design Analyst
PT Kamadjaja Logistics
- Rolled out national fleet GPS tracking and HHT Barcode Scanners across contract logistics sites.
- Developed internal Android mobility apps for operational tracking and digital budget requests.
- Led cloud migration from legacy file servers to Microsoft OneDrive & Teams.
IT Server System Administrator
PT Kamadjaja Logistics
- Managed enterprise Active Directory, File Server Resource Manager (FSRM), and Data Center storage.
- Monitored network health using PRTG Network Monitor, Fortimail Antispam, dan Symantec Endpoint Protection.
Manufacturing IT Experience (2010 - 2013)
PT Seng Fong Moulding Perkasa & PT Hafizah Jaya Prima: IT Support Specialist handling deep system diagnostics for factory software slowness, LAN maintenance, hardware troubleshooting, and Active Directory administration.
Bachelor of Engineering (S.T.) - ITN Malang
Institut Teknologi Nasional Malang, Indonesia
Graduated: 27 Feb 2010 | Major: Electrical Engineering - Computer & Information Engineering Concentration
Professional Governance, Systems & Continuous Development Operational Standard Alignment
System Engineering Insight & Web Applications
Saya memiliki spesialisasi dalam merancang dan mengembangkan aplikasi web (Full-Stack) menggunakan ekosistem Google Workspace (Google Apps Script) dipadukan dengan HTML5 & Tailwind CSS. Pendekatan ini memungkinkan departemen operasional untuk mengubah alur kerja manual berbasis kertas/Excel menjadi sistem digital terpusat secara agile tanpa memerlukan biaya lisensi software tambahan atau pengadaan server backend eksternal, karena sepenuhnya memanfaatkan infrastruktur Cloud milik Google.
Portfolio of Engineered Solutions
1. Domestic Analytics Portal
Logistics AnalyticsImpact & Scope: Portal sentralisasi ringkasan kargo logistik domestik (Surabaya & Jakarta). Dilengkapi filter dinamis (Tahun, Bulan, Pelanggan, Status Booking), analitik volume per rute, Top 20 Klien, dan retensi pelanggan. Mengeliminasi proses kompilasi manual akhir bulan menjadi pelaporan real-time yang dapat diekspor.
2. Executive Gross Margin Tool
Financial ModelingImpact & Scope: Alat bantu krusial bagi jajaran direksi untuk mengevaluasi profitabilitas klien. Memisahkan data Revenue, Cost Operasional (COGS), Margin Bruto, dan Biaya Overhead. Secara otomatis mengkategorikan klien menjadi: Core Star (Keep), Potential Scaling, atau Volume at Risk (Drop) untuk panduan negosiasi kontrak.
3. International Exim Control Hub
Exim ControlImpact & Scope: Dashboard pemantauan operasional Export-Import. Menganalisis metrik TEUs, tren pendapatan puncak vs terendah, dan utilisasi jenis kontainer (20ft/40ft/HQ). Menjembatani kesenjangan visibilitas antara tim freight forwarder lapangan dengan tim keuangan korporat.
4. SalesTracker CRM & Visit Planner
Commercial OpsImpact & Scope: Aplikasi CRM komprehensif untuk tim Sales dan Branch Manager. Meliputi pencatatan kunjungan harian, hasil meeting (MoM), pendaftaran prospek (Master Customer), dan alur persetujuan tingkat VP. Menggantikan proses pelaporan mingguan di WhatsApp dengan database terpusat yang bisa dilacak.
Scalability Insight: Seluruh sistem dibangun dengan antarmuka yang responsif (Mobile & Desktop). Konsep serverless (Google Scripts) ini memastikan waktu *uptime* nyaris 100%, proses deployment yang sangat cepat, dan dapat direplikasi untuk departemen lain (HR, GA, Procurement) dalam hitungan minggu.
SYAIFUL EFENDI, S.T.
Senior Management Reporting & Process Improvement | Systems Architect