YOGA SYAHRUL RAMADHAN | PORTFOLIO INITIALIZATION
00 %
CONNECTING DATA PIPELINE... v2.4 [SECURE]
Skip to main content
Yoga Syahrul Ramadhan
Yoga Syahrul Ramadhan
Statistical Analyst / Data Analyst
Let's Talk
Statistical Analyst / Data Analyst • PT. Erajaya Swasembada Tbk

From Raw Data to Strategic Business Decisions.

Experienced Statistical Analyst with expertise in data analysis, data integration, cleaning, and entry. I manage diverse datasets, turn them into actionable insights for the manufacturing sector, and build applications that keep company operations running.

Bogor, West Java, ID
9+ Years Professional Experience
S1 Information Systems
View work Get in touch yogasyahrul903@gmail.com
9 yrs
professional experience
5
BI & data tools
3
companies served
Yoga Syahrul Ramadhan
Open to work
DATA • BI • ERP
Yoga Syahrul Ramadhan
Statistical Analyst / Data Analyst
PT. Erajaya Swasembada Tbk
Power BI & DAX Modeling • Tableau Public & Desktop • SQL Server & PostgreSQL • Python (Pandas, NumPy, ETL) • Laravel 11 Backend • 3-Way Financial Reconciliation • Automated SFTP Data Pipelines • Strategic S&OP & Procurement • Power BI & DAX Modeling • Tableau Public & Desktop • SQL Server & PostgreSQL • Python (Pandas, NumPy, ETL) • Laravel 11 Backend • 3-Way Financial Reconciliation • Automated SFTP Data Pipelines • Strategic S&OP & Procurement •
03 / Projects

Selected work.

Sistem analitik operasional, pipeline otomasi data multi-sumber, dan dashboard performa bisnis yang mentransformasi data mentah menjadi keputusan nyata.

SOLUTION

Business Performance Dashboard

Monitoring business performance by region, business unit (B2B & B2C), and period for a retail and distribution company.

Business Performance Dashboard
Klik preview Power BI - SQL
Power BI Tableau SQL
SOLUTION

Track & Trace Procurement System

Electronic procurement system managing daily activities of procurement staff, from negotiation to executive summary, at PT. Kimia Farma Tbk.

Track & Trace Procurement System
Klik preview PHP - MySQL
PHP MySQL Process
SOLUTION

ETL Data Integration Platform

ETL company data from various sources into applications, producing valuable information for the company's future business processes.

ETL Data Integration Platform
Klik preview Python - SQL
Python ETL SQL
02 / Experience

Roles I have owned.

Rekam jejak profesional dalam analitik statistik, arsitektur integrasi sistem, dan manajemen pengadaan strategis di perusahaan ritel nasional & holding BUMN farmasi.

NO. 01

Channel & Data Analyst Assistant Manager - ED Carrier & Enterprise

PT. Erajaya Swasembada Tbk
Jul 2024 - Present

Monitoring business performance by region, business unit, and period.

  • Monitoring of business performance, by region, by business unit (B2B and B2C), and by period.
  • Analyse large numbers of data on sales, margin, incentives, and profitability.
  • Program monitoring and inventory of product analysis.
  • Correlation and interconnection analysis between market, product, and sales.
  • ETL company data from various data sources and implement the results of the integration into applications to produce valuable information for future business processes.
  • Present the analysis findings to the team through visual analytics using Power BI / Tableau.
NO. 02

Supervisor Data Integrator - IT Big Data & Science

PT. Kimia Farma Apotek
Oct 2023 - Jun 2024

Integrating company systems with third parties and business units.

  • Responsible for integrating company systems with 3rd parties and business units, both service integration and integration for the company's business interests.
  • Coordinating and implementing data integration in the system to build and maintain accurate and correct data operations.
  • Design and implement internal user needs related to data integration that support company operational activities.
  • Ensuring the qualification and accuracy of data between several company data sources to make data management easier.
  • ETL company data from various data sources and implement the results of the integration into applications for future business processes.
NO. 03

Data Analyst - Direct Strategic Procurement

PT. Kimia Farma Tbk.
Mar 2018 - Oct 2023

Turning procurement data into supplier and cost intelligence.

  • ETL primary and secondary data into supporting tools (Power BI, SQL Database) to produce insight and decision recommendations for the company.
  • Develop and deploy dashboards to monitor key metrics.
  • Analyze data based on trends that can have a major impact on the company's business.
  • Evangelize a data-driven culture by standardizing metrics and educating stakeholders.
  • Gave the procurement team analysis and insights to bargain prices from suppliers based on historical purchasing data and global economic conditions.
  • Led the transition to paperless practice by implementing an electronic procurement system (track and trace with negotiation evaluation, project management, and executive summary modules).
NO. 04

Procurement Staff - Direct Operational Excellence Procurement

PT. Kimia Farma Tbk.
Feb 2017 - Mar 2018

Supporting procurement operations and supplier management.

  • Purchase goods, raw materials, and packaging material in line with cost, quality, and delivery targets.
  • Monitor and advise on issues which present risk or opportunity to the management.
  • Provide analysis on costs and review cost reduction activities.
  • Prepare reports and updates as and when required.
  • Build, maintain, and manage supplier relationships and resolve price, quality, delivery, or invoice issues.
Core Capabilities

Tech Stack

Kombinasi langka antara penguasaan analitik data bisnis tingkat tinggi, keahlian rekayasa database, dan kemampuan arsitektur backend production.

Business Intelligence

Membangun model analitik interaktif yang langsung menghubungkan metrik operasional dengan keputusan strategis C-Level.

• Power BI & DAX Advanced
• Tableau Public & Desktop
• Looker Studio
• Star / Snowflake Schema

Data Engineering & SQL

Pengoptimalan query ratusan juta baris, perancangan stored procedures, window functions, serta ETL data pipelines.

• SQL Server (T-SQL) & PostgreSQL
• Window Functions & CTE
• Index Tuning & Partitioning
• Python ETL (Pandas, NumPy)

Backend & Integrasi

Merancang aplikasi backend andal untuk mengotomasi alur data antar institusi finansial, server SFTP, dan sistem ERP.

• Laravel 11 & PHP Modern
• Phpseclib SFTP Automations
• RESTful APIs & Webhooks
• Background Jobs & Queues

Domain & Leadership

Pengalaman mendalam dalam manajemen operasional ritel multi-channel, logistik farmasi nasional, dan tata kelola pengadaan BUMN.

• 3-Way Financial Reconciliation
• Sales & Operations Planning (S&OP)
• Inventory Turnover & Safety Stock
• Cross-Functional Leadership
Production Architecture Lab

Clean Code & Reliable Logic

Arsitektur sistem tangguh yang menghubungkan jutaan transaksi harian dari ingestion multi-supplier, pemrosesan rekonsiliasi PostgreSQL CTE, hingga alerting otomatis real-time tanpa latensi.

Ecosystem Status
ALL SERVICES OPERATIONAL
99.98% Accuracy • Zero Data Loss
STAGE 01
Multi-Protocol Ingestion

Data Gateways

Otomatisasi feed mutasi harian dari multi-supplier melalui SFTP terenkripsi, REST Webhook, dan Gmail IMAP stream.

Latency: < 180 ms
STAGE 02
High-Concurrency Core

Reconciliation Engine

Algoritma pencocokan 3-arah mutasi dengan queue worker Laravel 11, proteksi transaksi ACID, dan proteksi RAM ketat.

Match Rate: 99.98% Accuracy
STAGE 03
Partitioned Storage

PostgreSQL CTE

Penyimpanan terindeks dengan query Common Table Expressions (CTE) rekursif untuk memproses 1.2M+ baris data tanpa table lock.

Throughput: 1.2M+ Records
STAGE 04
Autonomous Observability

Alert Dispatcher

Deteksi anomali mandiri dengan notifikasi instan melalui Zimbra Enterprise SMTP, WhatsApp Fonnte, dan rotasi log otomatis.

Variance Alert: Zero Unmonitored
STAGE 01: Multi-Protocol Data Ingestion Architecture
sftp_ingestion_gateway.py Production Logic
Direct Engagement

Have a dataset to decode or a business process to improve?

Terbuka untuk diskusi strategis mengenai kepemimpinan analitik data, implementasi dashboard enterprise (Power BI & Tableau), optimasi pipeline SQL, serta konsultasi sistem otomatisasi.

yogasyahrul903@gmail.com Hubungi via WhatsApp View on Tableau Public LinkedIn
Email: yogasyahrul903@gmail.com • Lokasi: Jakarta & Bogor, Indonesia • Status: Available for Strategic Roles