B2B Process Intelligence Dashboard
End-to-end AO–RO order lifecycle monitoring — visibility up 70%, backlog down 35% (Q3 2024).
Looker Studio • Oracle SQL • Apps Script
View case study →Data & BI Analyst · Network & AI Infrastructure Engineer
Hi, I'm Bayu Ramadhan
> Data & Business Intelligence Analyst
Data & Business Intelligence Analyst with 3+ years of experience at Telkom Group (SQL, Looker Studio, Apps Script) and Network & AI Infrastructure Engineer — ISP founder (MikroTik, PPPoE, FTTH) building AI chatbots (Telegram/WhatsApp), 24/7 automated monitoring, and multi-profile AI agent orchestration with provider failover & plugin hooks.
Currently working on
B2B Process Intelligence
// 01. ABOUT ME
Get to know me
I'm a Data & Business Intelligence Analyst with 3+ years of experience at Telkom Group, focused on turning complex operational data (AO, SO, DO, MO, RO) into actionable business insights.
Proven in KPI monitoring, revenue assurance, and process automation using SQL, Looker Studio, and Google Apps Script — cutting manual reporting effort by ~60% and accelerating Billing Complete by 25%. I'm also a local ISP founder with end-to-end network operations and customer analytics experience.
As a Network & AI Infrastructure Engineer, I operate MikroTik infrastructure (200+ PPPoE users, 200 Mbps, dual-site), connected via Cloudflare Tunnel & Tailscale, and build multi-profile AI agent orchestration (Hermes) — Telegram & WhatsApp bots with knowledge bases, Google Sheets integration, rate limiting, and deterministic plugin hooks.
Outside of work, I enjoy automation, designing knowledge bases, and connecting data, networks, and AI to support data-driven decisions.
3+
Years Experience
200
ISP Customers
200+
Orders Monitored
25%
BC Cycle Faster
Languages
// 02. EDUCATION & CERTIFICATION
Academic Background
2017 — 2022
Bachelor of Computer Engineering
STMIK Indonesia Mandiri, Bandung
Bachelor of Computer Engineering. GPA 3.57 / 4.00. Focus on programming, databases, and information systems fundamentals.
Informatics
Database
GPA 3.57
Certifications
Data & Technical Certifications
- ▹ Fundamental Data Analysis using Power BI — Alison (CPD Certified, Expected Mar 2026)
- ▹ English Proficiency Test Prediction of TOEFL (Score: 593) — Universal English (Expected Aug 2025)
- ▹ IT Technical Support Fundamentals — Google via Coursera (Sep 2023)
// 03. SKILLS
Core Skills
Data Analysis & BI
SQL (Oracle)
MySQL
Google Sheets
Excel
Looker Studio
Power BI
Business Process
B2B Lifecycle AO–RO
LOP/LOB
Revenue Assurance
BASO
KPI Tracking
Contract Analysis
Automation & Tools
Google Apps Script
Telegram Bot
Automated Reporting
Workflow Opt.
Dashboard Design
Networking & ISP
MikroTik
PPPoE
FTTH
Network Design
Troubleshooting
Telecom Domain
Telecom Ops
Enterprise Accounts
Service Monitoring
Operational Data
Astinet / Wi-Fi
Soft Skills
Stakeholder Coord.
Problem Solving
Training & Sharing
Cross-functional
AI / LLM Agents
Hermes Agent
Multi-profile
Chatbot
Knowledge Base
LLM APIs
Provider Router
Plugin Hook
Prompt Engineering
AI Orchestration
Tool Calling
Web Development
Laravel
PHP
Blade
Tailwind CSS
Chart.js
HTML/CSS/JS
MySQL
Redis
REST API
Railway Deploy
Cloud & Automation
Cloudflare
Zero Trust
Tunnel
Workers
Tailscale
Python
Systemd
Cron Jobs
Docker
CI/CD
Bot & Messaging
WhatsApp API
Telegram Bot
Baileys
Broadcast
Webhook
Google Apps Script
Mail Merge
Google Docs API
// 04. PROJECTS
Key Projects
Dashboard BULOG Ciamis
Real-time procurement monitoring for BULOG Kancab Ciamis (4,500+ GKP rows) — reporting turnaround cut from days to minutes.
Laravel • Chart.js • Google Sheets API
View case study →
MagNet Billing — ISP Management App
Complete ISP billing suite — customer management, voucher hotspot, PPPoE, real-time monitoring, and financial reports, integrated with MikroTik RouterOS API.
Laravel 11 • Tailwind • MySQL • Redis • MikroTik API
View case study →
WhatsApp Customer Service Bot — BULOG
AI WhatsApp bot for the BULOG PBP program — 41+ FAQ knowledge base, media auto-replies, and scheduled broadcasts on Hermes agent orchestration.
WhatsApp API • Hermes Agent • Knowledge Base • Cron
View case study →
24/7 MikroTik & OLT Monitoring
24/7 automated monitoring across 2 ISP locations (200+ PPPoE clients) — Telegram alerts, GPON OLT diagnostics, and QoS classification for faster incident response.
MikroTik API • Telegram Bot • GPON/OLT • FastTrack
View case study →// 05. EXPERIENCE
Professional Journey
Technical Support / Data Analyst
PT Telkom Indonesia (Telkom Group) — RLEGS REG 2
Full-time, Bandung. B2B reporting automation, Looker Studio dashboards, revenue variance analysis, and cross-team coordination.
- Automated weekly B2B performance reports with Google Apps Script — cut manual effort ~60% and improved accuracy for 200+ active orders.
- Built Looker Studio dashboards for AO–RO ageing — prioritized backlog and accelerated Billing Complete (BC) by 25% QoQ.
- Revenue variance analysis with Oracle SQL supporting Revenue Assurance for BASO >2 months.
- Collaborated with Sales, Finance, and Operations to align KPIs and improve order-to-cash visibility.
Technical Support — BGES REG 3
PT Telkom Indonesia
Full-time, Bandung. Connectivity and sales data analytics, automation bots, and regional performance dashboards.
- Analyzed connectivity & sales data (Astinet, Wi-Fi) for 50+ enterprise accounts — supported target evaluation and churn reduction.
- Built a Telegram bot for daily alerts and performance summaries — critical issue response 40% faster.
- Created Looker Studio dashboards for regional sales performance and service adoption trends.
- Supported Revenue Assurance by flagging BASO >2 months.
Special Team Pijar Sekolah — BGES REG 3
PT Telkom Indonesia
Special assignment. Training & onboarding for the Pijar Sekolah e-learning platform across 65 schools in West Java.
- Delivered training & onboarding — 90%+ adoption rate post-intervention.
- Built web-based monitoring for real-time training progress and engagement tracking.
- Analyzed feedback & usage data — content recommendations increased engagement by 50%.
Founder & Network Operator — ISP
PT Ghadhe Akses Mandiri
Business owner. Built & managed a local ISP serving 200 residential and SME customers in Bandung.
- Designed end-to-end network architecture: PPPoE, MikroTik, FTTH.
- Managed billing, customer onboarding, troubleshooting, and technical support.
- Implemented automated monitoring and alerting systems for network performance.
Network & AI Infrastructure Engineer
AI Agent Orchestration & Network Automation
Designed & operated network infrastructure plus multi-profile AI agent orchestration (Hermes) on a 24/7 Fedora server — Telegram & WhatsApp service bots with knowledge bases, rate limiting, and automated reporting.
- Multi-profile AI bots (default, bila, wa-bulog, grace) with persistent memory via Obsidian + provider failover (MiMo, DeepSeek, DeepInfra).
- WhatsApp CS bot: multi-file knowledge base, 3-tier users (admin/field officer/general), officer reports → Google Sheets automation.
- MikroTik monitoring & automation: bandwidth, FUP, scheduled PPPoE restart, daily backup, Telegram/WhatsApp alerts.
- Remote infrastructure: Cloudflare Tunnel, Tailscale, systemd services, cron scheduling, 24/7 auto-restart.
// 06. CONTACT
Let's build something together
Open to job opportunities, data/BI and automation projects, or collaborations — let's talk about data-driven decisions & technology.