Hi, my name is

Indra Firdaus.

Business Intelligence & Data Analyst — I turn raw data into decisions.

10+ years of experience in data analytics, BI dashboard development, data pipeline management, and automation. Currently managing end-to-end data operations at Youtap Indonesia (OttoDigital Group) — from Airflow pipelines and BigQuery reconciliation to executive dashboards.

📍 Jakarta, Indonesia 💼 Open to opportunities
⬇ Download CV GitHub LinkedIn
10+Years in data analytics
99.9%Data accuracy in payment reconciliation
12+4Issuers & banks reconciled daily
5Departments supported cross-functionally

About

What I bring to the table.

🔄 End-to-End Data Operations

I manage the full data lifecycle — ingestion via Airflow, warehousing in BigQuery, reconciliation across payment issuers and banks, and delivery through BI dashboards used by operations, finance, and management.

🤖 Automation First

I build Python and Apps Script automations that replace manual work — data formatting, reconciliation matching, settlement reporting, and scheduled notifications — saving dozens of hours monthly.

📊 Insight, Not Just Charts

From network KPI monitoring at Telkomsel projects to fintech compliance reporting, I translate business questions into data deliverables that stakeholders actually use — including self-service dashboards that improve data culture.

💰 Cost-Aware Engineering

Reduced BigQuery query costs significantly through partition pruning and clustering, and manage infrastructure concerns like cost analysis and SSL maintenance for BI platforms.

Skills

Tools and technologies I work with daily.

Data & Analytics

SQLBigQueryPythonData ReconciliationETLData Analysis

BI & Visualization

TableauMetabaseLooker StudioPower BIExcel

Data Engineering

Apache AirflowGCSPipeline AutomationApps ScriptTelegram Bot API

Tools & Platforms

Google CloudJiraConfluenceGit

Experience

A decade-plus across fintech and telecom analytics.

Nov 2022 — Present

Business Intelligence (Data Analyst)

Youtap Indonesia — PT Mitra Digital Sukses (OttoDigital Group) · Jakarta
  • Manage daily data reconciliation across multiple payment issuers and banks, ensuring transaction accuracy between internal systems and external partners.
  • Maintain and monitor Airflow data pipelines (GCS → BigQuery), troubleshooting job failures and connectivity issues.
  • Build and maintain interactive dashboards in Tableau, Metabase, and Looker Studio for operations, finance, and management.
  • Develop Python automation for data formatting, reconciliation matching, and settlement reporting.
  • Deliver compliance reporting for government agencies and analytical support across 5 departments.
  • Optimize BigQuery costs (partitioning & clustering) and maintain SSL certificates for BI platforms.
2020 — Oct 2022

Data Analyst — Network Performance

PT Picotel Nusantara · Telkomsel Local Optim Project · Jakarta
  • Built KPI monitoring dashboards tracking network performance across multiple regions for proactive issue identification.
  • Delivered weekly data-driven reports and Tableau visualizations to stakeholders and management.
  • Analyzed large-scale customer feedback datasets, driving measurable gains in customer satisfaction.
2015 — 2020

Data Analyst — Network Performance

PT GMI Network · Telkomsel Local Optim Project · Jakarta
  • Analyzed large-volume 4G/3G operational datasets to identify performance bottlenecks and efficiency improvements.
  • Designed KPI dashboards tracking accessibility, retainability, and service integrity metrics.
  • Automated recurring report generation from OSS data sources, reducing manual effort in weekly reporting.
2012 — 2015

Data Analyst — Network Performance

PT Lexcorp Indonesia · XL Project · Jakarta
  • Monitored 2G/3G KPI datasets, identifying underperforming areas and recommending optimization strategies.
  • Built analytical frameworks for alarm and performance data; developed solutions for neighbor cell optimization and congestion management.

Featured Projects

Real systems in production — source code and documentation on GitHub.

Auto-Reconciliation Pipeline end-to-end architecture

Auto-Reconciliation Pipeline

End-to-end automated payment reconciliation system in 3 stages: file normalization (Apps Script), cloud ingestion (Airflow DAG, 18 parallel tasks, hourly), and 3-way BigQuery reconciliation across 12 payment issuers and 4 banks with a 9-month date spine and D-1 bank alignment.

12 + 4Issuers + banks covered
~53sMean DAG run time
100%Success rate (25 runs)
18Parallel Airflow tasks
BigQueryApache AirflowApps ScriptGCSJWT RS256Looker Studio
→ github.com/indfir/Auto-Reconciliation-Pipeline
Zoning Champion Dashboard — merchant map by type

Zoning Champion Dashboard

Operational zoning analytics system for merchant activation, warehouse supply-chain mapping, and field sales performance tracking across 7 regional territories in Indonesia — 5 dashboard layers, 12 KPI dimensions, and 4 interactive map views built on Tableau + Mapbox.

7Regions monitored
40+Squads tracked
12KPI dimensions
4Map views
TableauMapboxSQLGeo Hierarchy
→ github.com/indfir/Zoning-Champion-Dashboard

indfir.com — AI-Powered Autonomous News Portal

Fully automated online news portal running 24/7 with zero manual writing. An AI agent built on OpenClaw autonomously researches trending topics, writes 800–1,000-word articles in Indonesian, and publishes them to WordPress across 8 categories — live since Feb 2026 with 2,100+ articles published.

7-phase pipeline: Signal → Research → Brief → Produce → QC → SEO → Publish

2,100+Articles published autonomously
10×/dayPublishing slots, every 2 hours
18Automated QC validation gates
~100%Featured-image coverage (5-tier fallback)
62Python/Bash support scripts
0Manual writing required

A 2,656-line Bash orchestrator with retry logic and QC auto-fix drives the pipeline via systemd timers; a Telegram bot delivers real-time alerts and daily reports, with a live cron-monitor dashboard for pipeline status.

OpenClawAI AgentsLLM (OpenAI)WordPress REST APIBrave Search APIPythonBashSystemd TimersTelegram Bot API
→ Live site — indfir.com  ·  Monitoring dashboard  ·  GitHub repo

More on GitHub

Auto-File-Organizer

Python utility that automatically sorts and organizes files.

→ View repo

smart-tools

Collection of HTML-based productivity tools and utilities.

→ View repo

Education

Telecommunication engineering background — the root of my data discipline.

2014 — 2018

National Institute of Science and Technology, Jakarta

Bachelor's degree, Telecommunication Engineering · GPA 3.43

2009 — 2012

Jakarta State Polytechnic

Diploma, Telecommunication Engineering · GPA 3.43

Let's work together.

I'm open to opportunities in data analytics, business intelligence, and automation. If you think I'd be a good fit for your team, get in touch.

✉ indra.rigel@gmail.com LinkedIn