RANGGA NOER RACHMAN
Rangga
Rangga Noer Rachman
Business Analyst • Data
SENIOR IT CONSULTANT & BUSINESS/DATA ANALYST

Bridging Enterprise Code, Business Strategy & Data Intelligence.

Dynamic technologist with 8+ years of experience across Oil & Gas and US Healthcare. Specializing in translating complex business workflows into scalable full-stack web applications, executive Power BI analytics, enterprise ETL pipelines, and human-centered digital experiences.

LinkedIn Profile South Tangerang 15225, Indonesia Copy Email
Rangga Noer Rachman
Rangga Noer Rachman
8 YRS EXP

Business Administration (Unpad) • Full-Stack & Data Systems

8+
Years IT Experience
15+
Enterprise Systems
6
Enterprise Clients
100%
Agile Delivery Success
Full-Stack Architecture
Business Analysis
Power BI & Analytics
MSSQL, Oracle & PostgreSQL
UI/UX & Figma Design
SSIS ETL & Data Warehousing
AI-Assisted Workflows
Energy & Healthcare Domains

The Hybrid Edge: Business Acumen Meets Deep Technical Execution.

Most technologists write code without understanding the business bottom line, while many business analysts lack the technical depth to understand system constraints. My background bridges this gap entirely.

Starting my career in 2017 as a Junior Database Engineer mapping complex Schlumberger seismic survey data for SKK Migas, I progressed through enterprise database engineering, full-stack backend and mobile architecture, and product UI/UX design. Combined with a formal degree in Business Administration from Universitas Padjadjaran, I help organizations eliminate translation friction between business executives, operational end-users, and software engineering squads.

01 // ARCHITECTURE

Enterprise Databases & ETL

Deep proficiency in MSSQL, Oracle, PostgreSQL, and SSIS packages. Building high-integrity data pipelines from transactional systems to reporting data warehouses with zero discrepancy.

02 // FULL-STACK

Web & Mobile Engineering

Architecting secure Web APIs, responsive web portals, and cross-platform applications. Delivering patient booking, payment gateways, and app store deployments for US healthcare platforms.

03 // STRATEGY

Business & Process Analysis

Leading requirement gathering for critical systems (Geological Reporting, Contract Monitoring, Production Data) and translating business pain points into Agile milestone deliverables.

04 // INTELLIGENCE

Power BI & Data Storytelling

Designing interactive executive dashboards for daily production tracking, reservoir gain-loss analysis, and predictive forecasting that empower leadership with real-time clarity.

Multi-Disciplinary Core Competencies

Structured across software engineering, business process modeling, data warehousing, and product design.

</>

Technology & Engineering

  • SQL Databases (MSSQL, Oracle, Postgres) Advanced
  • Backend APIs & Architecture Advanced
  • HTML5 / CSS3 / Responsive Web Advanced
  • JavaScript & Framework7 Intermediate
  • Web Payments & App Publishing Proficient
BA

Business & Process Analysis

  • Requirements Engineering (BRD/FRD) Expert
  • IT Business Partnering Strategic
  • Geological & Production Workflows Domain
  • Agile Kanban & Milestone Roadmaps Methodology
  • Cross-Functional Stakeholder Alignment Leadership
BI

Data & Business Intelligence

  • Microsoft Power BI & DAX Advanced
  • SSIS ETL & Data Warehousing Advanced
  • Production Forecasting & Gain-Loss Analytics
  • Metabase, Google Charts, Highcharts Data Viz
  • End-User BI Enablement & Training Delivered
UI

Design & AI Productivity

  • Figma Wireframing & Prototyping Advanced
  • User-Centered Design (UCD) Core
  • Design Systems & Components Standardized
  • AntiGravity AI Workflows Modern AI
  • Jira, ClickUp, Zoho BugTracker Tooling

Featured Enterprise Projects

Click any project to inspect problem, architecture & outcomes

Healthcare SaaS • US Remote iSmartOffice Healthcare Ecosystem
Aug 2019 – Present • Backend Dev & UI/UX

iSmartOffice™ Healthcare Clinic & Booking Ecosystem

Full-scale US healthcare SaaS ecosystem featuring automated patient booking, secure payment processing, clinical assessments, EHR management, and team report dashboards.

JavaScript Web APIs Figma UI/UX App Store/Play Store
Oil & Gas • Pertamina Pertamina Power BI Dashboards
2022 – 2024 • Power BI Developer & Modeler

Pertamina Hulu Mahakam & Cepu Power BI Analytics

Executive enterprise dashboards for petrophysics, production tracking, reservoir gain-loss analysis, and daily drilling reports with automated spreadsheet-to-warehouse ETL.

Power BI DAX Modeling MSSQL Automated ETL
AI Healthcare • Intelligence Annie Insight AI Diagnostic Suite
Product Development • Full-Stack & AI

Annie Insight AI Diagnostic & Clinical Analytics Suite

Modern AI-assisted diagnostic platform generating real-time clinical assessment reports, visual pathology breakdown, and automated reporting workflows for clinicians.

AI Integration Web Apps Automated Reporting Figma
Operations & Governance HCDS Team Report Dashboard
Enterprise Operations • Business Analyst

HCDS Executive Team Delivery & Velocity Report Dashboard

Unified KPI tracking dashboard providing executive transparency into multi-team milestone velocity, bug burndown, and operational task health across enterprise engineering squads.

Kanban Methodology Milestone Tracking ClickUp / Zoho KPI Metrics

8 Years of Continuous Growth

A progressive track record from database engineering and ETL data integration to full-stack application development, enterprise Power BI architecture, and senior business analysis.

Progression:
Database → Backend → Full-Stack → UI/UX → Power BI → Business Analyst

Business Analyst

Jan – Aug 2026
Pertamina Hulu Mahakam (Balikpapan) under PT Horizon Perdana Internasional
  • Led end-to-end requirement gathering for critical energy systems: Contract Management & Monitoring, Daily Geological Reporting, Production Data Management, and Data Directory Management.
  • Authored comprehensive functional and technical specifications for software development teams, eliminating scope ambiguity.
  • Engineered project timelines, Gantt roadmaps, and managed cross-functional workflows using Kanban and Milestone-driven governance.
  • Facilitated seamless communication between field operational business users and technical engineering teams.

Backend & Full-Stack Developer / UI/UX

Aug 2019 – Present
iSmartOffice™ — Chicago, Illinois (US Remote)
  • Architected and enhanced core SaaS features including Patient Appointment Booking, Web Payments, Patient Assessments, and Electronic Health Records.
  • Created interactive wireframes and high-fidelity user interfaces in Figma focusing on intuitive user experience.
  • Collaborated with QA Engineers to execute automated and manual testing routines ensuring rock-solid stability.
  • Evaluated and resolved cross-browser compatibility issues across iOS, Android, macOS, and Windows.
  • Managed deployment and app publishing workflows to the Apple App Store and Google Play Store.

Database Engineer & Web Developer

Sep 2017 – Present
PGN Saka Energi (Jakarta) under PT Horizon Perdana Internasional
  • Developed enterprise databases, stored procedures, and SSIS packages to perform ETL processes integrating transactional data into reporting data warehouses.
  • Designed and built a dedicated web portal enabling user-upload, validation, and real-time monitoring of corporate financial and inventory data.
  • Coordinated with corporate finance, SAP team, and project managers to validate monthly financial and inventory reconciliations.

Power BI Developer

Mar – Oct 2024
Pertamina Hulu Mahakam (Balikpapan) under PT Horizon Perdana Internasional
  • Partnered with petrophysics data management teams to translate complex reservoir and well data into intuitive Power BI dashboards.
  • Architected data warehouse datasets supporting daily production tracking, production forecasting, and gain-loss analytics.
  • Developed automated pipelines streamlining data transfer from disparate spreadsheets into centralized databases.
  • Conducted formal training sessions for end-users to maximize dashboard adoption and self-service analytics.

Power BI Developer

Dec 2022 – Apr 2023
Pertamina EP Cepu (Jakarta) under PT Horizon Perdana Internasional
  • Collaborated with commercial, finance, and drilling development stakeholders to deliver customized executive dashboards.
  • Optimized underlying SQL data models and query performance for sub-second visual refresh rates.

Web & Mobile App Developer

Mar – Nov 2022
Pertamina EP Cepu (Jakarta) under PT Horizon Perdana Internasional
  • Developed high-throughput Web APIs for transferring, loading, and retrieving Daily Drilling Report (DDR) data to mobile dashboards.
  • Implemented web portals for submission and tracking of Daily Drilling Reports and Seismic Survey Activity data.

Web Developer

Jun – Dec 2022
Petronas (Jakarta) under PT Horizon Perdana Internasional
  • Designed and developed a web portal to track Portable Electrical Equipment and Temporary Installation (PETI) compliance records.
  • Assisted database engineers with database creation, normalization, and query tuning.

Database Engineer & Jr. Database Engineer

2017 – 2019
SKK MIGAS & PT Horizon Perdana Internasional
  • Built daily drilling report web product transforming tabular logs into Google Charts and Highcharts visualizations (PT HPI).
  • Mapped seabed surface survey data from Schlumberger ProSource Database into PPDM 3.8 Database standards (SKK MIGAS).

Curated Technology Stack

Practical technologies actively leveraged in production enterprise applications.

// Databases & ETL

MSSQL Server Oracle DB PostgreSQL SSIS (ETL) Stored Procedures PPDM 3.8 Standard

// BI & Analytics

Microsoft Power BI DAX & Power Query Tableau Metabase Google Charts Highcharts

// Web & Mobile Code

SQL (Advanced) HTML5 / CSS3 JavaScript RESTful Web APIs Framework7 Payment Gateways

// Design & PM Tools

Figma (UI/UX) AntiGravity AI ClickUp Jira Zoho BugTracker MS Teams

Education & Credentials

A foundational business degree in marketing and strategic administration from one of Indonesia's premier universities, supplemented with specialized technical engineering certifications.

Universitas Padjadjaran

Bachelor of Business Administration — Marketing Studies
GPA: 3.19 / 4.00

Core studies in Business Strategy, Market Research, Process Optimization & Organizational Communication.

JavaScript & Framework7 Introduction

2023

Modern mobile web application architecture & interactive frontend development.

SQL SSRS, JasperReports & Database Troubleshooting

2017

Enterprise database reporting services, query optimization & production troubleshooting.

Looking for a High-Impact Technologist?

I am actively open to opportunities as a Business Analyst, Data Analyst, IT Business Partner, Full-Stack Developer, or Technical Product Specialist in Indonesia or remote global teams.

// QUICK CANDIDATE SNAPSHOT
Location: South Tangerang 15225, ID
Work Authorization: Indonesian Citizen / Global Remote
Availability: Immediate / Standard Notice
Portfolio Domain: ranggarach.my.id
Rangga
Rangga Noer Rachman
Senior IT Consultant & Business Analyst
© 2026 Rangga Noer Rachman. All Rights Reserved.
Modern Executive Clean Light Architecture.
Email copied to clipboard: rangganoer.r@gmail.com
Rangga Rangga Rachman
Download CV
rangganoer.r@gmail.com