Geospatial Analytics Indonesia
Portfolio 2026

Orendo
Raharjo

/ Geospatial Data Engineer

I turn national-scale spatial data into board-ready choices: where to build, which markets to prioritize, and how to convert fragmented field evidence into repeatable telecom deployment decisions.

Deployment 45K+ FWA sites screened and sectorized for national rollout planning.
Demand 927K+ homepass assessed for FTTH prioritization and OLT funneling.
Data Ops 4M+ Point of Interests surfaced through category-count production records.
View Work Explore Data Work
0 FWA Sites Optimized
0 Homepass Assessed
0 Cities Covered
0 Infrastructure Programs
About

Turning geospatial complexity
into deployment decisions

I build the data infrastructure and analytical engines that power national-scale telecom expansion. From homepass demand assessments for a national operator to 45,000+ FWA site optimization for an infrastructure partner, my work sits at the intersection of geospatial engineering, network science, and strategic planning.

Every project combines repeatable spatial processing pipelines, optimization logic, and deep domain expertise in FTTH, FWA, and backbone infrastructure, at Indonesia-national scale.

National telecom operator Infrastructure partner Regional operator Enterprise planning team Public-sector program Industrial investor Connectivity provider Market intelligence team
Expertise
FTTH Network Planning Homepass funneling, OLT clustering, Cable routing
FWA Site Optimization Sectorization, Coverage analysis, Deployment design
Market Intelligence Demand scoring, Buying index, Competitive analysis
Geospatial Data Engineering Pipeline architecture, Spatial indexing, QA handoff
Spatial Classification Workflows Clustering logic, Classification, Image review
Fiber Planning Route design, Splitter topology, OLT placement
Execution Capabilities
Core
Spatial data engineering Data QA Batch processing Record linkage Operational handoff
Network
Route modeling Cost weighting Topology design Distance analysis
Classification
Classification workflow Cluster design Candidate zoning Priority scoring
Delivery
Workflow automation Review dashboards Grid indexing Deployment packaging QA automation
Strategy & Analysis

Spatial Intelligence
for Business Decisions

Board level decisions need more than maps. These engagements convert field data, coverage evidence, and demand signals into clear investment priorities, deployment phasing, and market entry choices.

01
FTTH infrastructure planning map capture
FTTH FUNNEL | 927K HOMEPASS | JAVA
FTTH, National Scale, Classification Workflow

National FTTH
Demand Assessment

Objective: Clarified where FTTH expansion should move first by turning fragmented residential evidence into a prioritized homepass funnel that could be sequenced by market readiness and access feasibility. Supporting process: Combined 927K-plus assessed homepass, assisted classification in low-visibility corridors, 17 validation batches, regional funnel compilation, and P1/P2/P3 checks across 95 aggregation areas so rollout priorities could be defended beyond isolated field anecdotes.

National telecom operator 17 Batches Prioritized Funnel
02
FWA national site optimization location data
FWA SECTORIZATION | INDONESIA | 45K SITES
FWA, Site Prioritization, Coverage Design

National FWA
Site Optimization

Objective: Turned a national candidate-site inventory into rollout-ready FWA deployment zones by showing which locations had enough surrounding demand, cleaner overlap, and more workable access patterns for phased execution. Supporting process: Screened assessment-scale site inventories, linked them to buffered homepass evidence, resolved overlap between neighboring candidates, sectorized viable zones, and packaged regional deployment views so commercial and planning teams could review the same rollout logic.

Infrastructure partner 45K+ Sites National
03
Multi operator market assessment across Indonesia
MARKET PRIORITY | 200+ CITIES | MULTI OPERATOR
Competitive Intelligence, Operator Footprint

Multi Operator FTTH
Market Assessment

Objective: Ranked where operators should defend, enter, or defer FTTH expansion by comparing demand strength and competitive pressure instead of relying on footprint size alone. Supporting process: Scored village-level market classes across 200-plus cities, compared multi-operator presence, rolled demand and buying-power signals into city views, and surfaced priority clusters where expansion had stronger acquisition logic.

National and regional operators 200+ Cities
04
Coastal site map with 1000 plus shoreline visibility candidates
COASTAL VISIBILITY | 1000+ SITES
Public Sector, Visibility Analysis, Coastal

Shore Connectivity
Assessment

Objective: Narrowed coastal communication investment to shoreline segments where coverage could realistically be built and defended, reducing time spent on low-feasibility site options. Supporting process: Filtered shoreline reach windows, tested terrain visibility, screened thousands of coastal sites, and assembled regional site groups that linked maritime coverage goals to physical feasibility.

Public sector maritime program Visibility Terrain Review
05
Data Center site suitability: actual site location data
TERRAIN | GRID | CANDIDATE SITE DATA
Site Selection, Terrain, Hydrology

Data Center Site
Suitability Analysis

Objective: Reduced land and infrastructure decision risk by narrowing candidate areas to sites with stronger terrain, drainage, access, and policy fit before detailed engineering began. Supporting process: Combined elevation screening, 360-degree visibility checks from gridded candidate areas, watershed and runoff review, disaster-risk avoidance, and land-use constraints into a shortlist designed for faster diligence.

Infra Planning Terrain Analysis Hydrology
06
Regional backbone route planning map capture
FO BACKBONE | REGIONAL ROUTE OPTIONS
Regional Connectivity, Backbone Options, Routing

Sulawesi Backbone
Planning

Objective: Clarified which backbone and landing-support options could sustain regional connectivity growth with lower route risk and a stronger network logic for investment. Supporting process: Compared route alternatives, screened flood exposure, mapped provider presence by city, assessed cable and landing options, and translated regional demand and capacity signals into buildable route scenarios.

Regional infrastructure investor Risk Screening Network Mapping
07
Enterprise POI classification with 128K high value premises mapped across Indonesia
ENTERPRISE TARGETING | 128K+ POIs | FO PROXIMITY
Enterprise Connectivity, Premise Classification, Fiber Proximity

Enterprise POI
Intelligence

Objective: Focused enterprise acquisition on accounts more likely to convert and easier to connect by ranking commercial premises through value density and network reach. Supporting process: Classified 128,000-plus high-value commercial premises across eight business categories, measured fiber proximity, assembled multi-market coverage views, and translated raw premise data into account-level targeting signals.

Enterprise market intelligence 128K+ POIs Fiber Proximity Account Scoring
Data Production

The Infrastructure
Behind Every Analysis

I combine technology, big data capability, and geospatial domain knowledge to build data foundations that make every downstream analysis defensible. Reliable strategy starts with operational data systems. These pipelines make messy building, commercial place, network, movement, and boundary records traceable and accountable enough for executive decisions and field execution.

Buildings
0Cities Processed
National Building Database

Insight: supporting decision for precise demand assessment, for go to market decision, especially for FTTH and FWA households potential analysis and design process. Methodology: Eliminates manual data collection across 500+ city scale surveys by harmonizing multiple building footprint sources into a unified, deployment ready national database, enhanced with proprietary satellite imagery based building extraction.

Multi feed QA4 InputsDeployment readySatellite Imagery
Scraping
0Point of Interests
Indonesia POI Production Engine

Insight: Reusable commercial density intelligence for market screening, site prioritization, and category based demand views. Methodology: Processes 4M+ commercial place records through schema validation, coordinate QA, brand and category mapping, admin area fill, deduplication, text normalization, and production reporting.

Schema QARecord LinkageDeduplication
Tower Data
Cell Tower Intelligence Grid

Insight: Provider level tower intelligence for coverage context, network opportunity screening, and planning handoff. Methodology: Iterates provider and network sources, extracts tower candidates, generates adaptive grids using land cover and admin context, and runs duplicate tower QA before structured handoff files.

TelecomAdaptive GridHandoffQA
Industrial Data
Industrial Corridor POI and Connectivity Intelligence

Insight: B2B telecom planning signal for industrial demand, connectivity coverage, and nearby infrastructure context. Methodology: Fuses industrial and company place records with building and grid context, admin and road joins, provider mix, and coverage comparison for corridor screening.

Industrial RecordsProvider MixSpatial JoinB2B
Analytics
0Grid Resolution
Buying Index Grid

Insight: Single investment grade demand score at 200m resolution for market prioritization and investment sequencing. Methodology: Combines purchasing power, building density, network quality, job ratios, and admin context into one reproducible composite heatmap.

Grid ScoreComposite ScoreInvestment Lens
Network Quality
0Mobile + Fixed
Network Quality Grid

Insight: Pinpoints where incumbent weakness creates lower acquisition cost market entry opportunity. Methodology: Combines mobile and fixed network quality signals, normalizes them to grid level, and flags demand areas where quality gaps support entry timing.

Mobile QualityFixed QoEWeakness Signal
Admin Data
0Admin Hierarchy
Admin Boundary Registration

Insight: Enables city level sales reporting and deployment accountability down to village level. Methodology: Links buildings, roads, and POI records to Indonesia's four level admin hierarchy, then packages OLT funnel attribution and field performance tracking across 30+ city batches.

Admin JoinSpatial MatchBatch QA
Network
0ASNs Mapped
Network Dependency Graph

Insight: Maps Indonesian provider upstream dependencies and peering relationships for backhaul negotiation, market entry risk, and acquisition screening. Methodology: Normalizes ASN records, provider aliases, relationship direction, and peer context into a graph that can be queried by provider, geography, and dependency depth.

Dependency GraphPeering ContextProvider View
Coverage
0Review Points
Coverage Gap Map

Insight: Closes nationwide data blind zones so assisted homepass classification can reach underserved corridors. Methodology: Measures street level review coverage, buffers reachable evidence, identifies absence zones, and prioritizes field or imagery review against demand grids.

Coverage GapsBufferingAssisted Review
Elevation
0Land use Time Series
Urban Growth Analysis

Insight: Guides five year FTTH rollout sequencing by identifying growth corridors and avoiding overbuild in stagnant areas. Methodology: Compares 38 years of land use time series, region level expansion patterns, and demand context to identify durable growth signals.

Land useTime SeriesGrowth Signal
Mobility
0Daily Snapshots
Mobility Pattern Data

Insight: Reveals where people live, work, and move so demand estimates reflect activity beyond residential address counts. Methodology: Aggregates 365 daily movement snapshots into privacy conscious activity surfaces for FWA placement and commercial corridor revenue forecasting.

Activity SignalCrowd MovementMobility
Applications

Tools Built
for the Field

Applications are included when they compress a serious operational workflow: planning, routing, scoring, QA, or executive review. The emphasis is repeatable decisions, not small convenience scripts.

Intelligent routing system fiber backbone network visualization
Backbone Planning, Route Optimization, Published Research

Intelligent Routing System (IRIS)

Reformulates backbone fiber planning as a two-phase route optimization workflow on cost-weighted corridors. Combines clustering, route sequencing, and local improvement logic to produce optimized ring topologies with automated handoff and BoQ outputs. Reduced backbone route length 34.4% and inter-site design time from 134 h to 33 h, with peer-reviewed publication evidence.

Route Optimization Clustering Workflow Automated BoQ Published Research
Infrastructure partner
FAST FTTH topology OLT FDT FAT network design automation
Access Network Design, Routing Workflow, Published Research

FAST: FTTH Automation and
Spatial Transformation

Transforms semi-manual planning workflows into a constrained access-network design engine. Clustering, road-aligned routing, and rule-based capacity sizing generate FTTH topology, design outputs, and BoQ artifacts from a single spatial model. Reduced feeder design time from 240 min to 2 min and BoQ preparation from 48 min to 2 min, with peer-reviewed publication evidence.

Topology Engine Capacity Rules Design Automation Deployment Package
Infrastructure partner
Homepass AI classification - High/Medium/Low potential house categories
Image Classification, Market Prioritization, Published Research

Homepass AI
Market Classification

Classification workflow that groups residential street-level imagery into High, Medium, and Low market potential tiers, enabling FTTH targeting without manual field surveys. Part of an integrated framework for geospatial fiber network planning, supported by peer-reviewed publication evidence.

Image Classification Parallel Review Published Research
Research collaboration
FTTH funnel optimizer service area clustering
Optimization Engine

FTTH Funnel Optimizer

Road-aware homepass clustering with hierarchy separation. Defines go-to-market areas by generating optimal funnel boundaries from raw building records, enabling business decisions on which areas to prioritize for FTTH rollout. Distance and density-aware, parallelized across 4 cores for national-scale processing.

Route-Aware Clustering Funnel Boundaries National Processing
FWA analytics platform screenshot
Planning Application, Sectorization, Site Analytics

FWA Analytics Platform

FWA sectorization and site analytics platform for an infrastructure partner. Demand screening, sector-area generation, and location-based potential scoring across 45K+ sites in a field-ready review experience.

Sectorization Site Scoring Review Map Operational Dashboard
Infrastructure partner
FTTH market penetration funnel: P1/P2/P3 homepass qualification
Qualification Workflow, Automation, Analytics

FTTH Market
Penetration Funnel

National-scale homepass qualification workflow scoring buildings through administrative filters and market classification layers. Defines go-to-market strategy by outputting P1/P2/P3 prioritized deployment batches, directly consumed by funnel and cable design workflows. Scored 927K+ homepasses across a regional market in minutes.

Qualification Rules Batch Processing Deployment Funnel Handoff Package
National telecom operator