Muhammad Cikal Merdeka Profile

Hi, I'm Cikal Merdeka

I'm a

I'm an AI Engineer specializing in LLM-based systems orchestration including multi-agent workflows, retrieval-augmented generation, and context engineering. I also work in Analytics Engineering, designing analytical data marts and building dashboards focused on measurable business impact.

When I'm not exploring data analysis tools or following AI trends, I enjoy capturing moments through photography, diving into novels and manga, watching anime and movies, listening to music, or playing in online games like Dota 2 and CS2. These diverse interests help me stay creative and bring fresh perspectives to my work.

About Me

Driven by extreme curiosity with the help of LLM to answer my questions about certain things, I am able to learn new concepts quickly and apply them to my work and projects.

Skills Icons

Programming Languages

  • Python
  • SQL
  • R
  • MATLAB
  • TypeScript

Data Manipulation & Analysis

  • NumPy
  • Pandas
  • Polars
  • SciPy
  • Statsmodels
  • Regex
  • Excel
  • Google Sheets

Databases

  • PostgreSQL
  • MySQL
  • MSSQL
  • BigQuery
  • DuckDB
  • Snowflake
  • Chroma
  • Pinecone
  • FAISS
  • Qdrant
  • Supabase

Machine Learning & AI

  • Scikit-learn
  • TensorFlow
  • PyTorch
  • spaCy
  • Hugging Face
  • LangChain
  • Agno
  • OpenAI
  • Claude
  • Gemini
  • Ollama

AI Application Development

  • FastAPI
  • Flask
  • Gradio
  • Streamlit
  • Next.js
  • React

MLOps & Orchestration

  • Docker
  • MLflow
  • Langfuse
  • Apache Airflow
  • Dagster
  • dbt

Data Collection & Web Scraping

  • BeautifulSoup
  • Selenium
  • Requests

Data Visualization

  • Matplotlib
  • Seaborn
  • Tableau
  • Power BI
  • Looker Studio
  • Metabase
  • Preset

Development Tools & Environments

  • Git
  • GitHub
  • Cursor
  • Claude Code
  • Antigravity
  • Google Colab
  • VS Code
  • Jupyter Notebook
  • Postman

Beyond the Code

📚

Continuous Learning

Always exploring new technologies and research papers in AI/ML

🤝

Collaboration

Love working with diverse teams to build impactful solutions

🎯

Problem Solving

Passionate about tackling complex challenges with data-driven approaches

Data Science Projects

Turning Data into Insights

A collection of data science projects showcasing analytics, visualization, and machine learning applications across various industries.

Showing 16 of 16 data projects

Loan Prediction Based on Customer Behavior
Data Science
Featured

Loan Prediction Based on Customer Behavior

Machine learning system for automated credit risk assessment using borrower behavior patterns.

PythonScikit-learnPandas+2 more
January 25, 2025
85.88% Recall
Analyzing eCommerce Business Performance with SQL
Data Analytics

Analyzing eCommerce Business Performance with SQL

SQL analysis extracting insights from multi-dimensional eCommerce data for business intelligence.

SQLData AnalysisBusiness Intelligence+1 more
April 8, 2024
7.1% Improvement Needed Customer Retention
Analytics Engineering with Airbnb
Data Engineering
Featured

Analytics Engineering with Airbnb

Modern data engineering pipeline analyzing Airbnb marketplace dynamics with PostgreSQL and dbt.

PostgreSQLdbtDagster+2 more
March 7, 2025
290+ Hosts Analyzed
Gym Membership Operational Analysis
Data Analytics

Gym Membership Operational Analysis

PostgreSQL and Metabase analysis of gym membership patterns for 1,000 members.

PostgreSQLMetabaseData Analysis+1 more
June 5, 2025
106min Avg Session Facility Utilization
Prediction of Solar Energy Potential Based on Weather and Location-Data
Data Science

Prediction of Solar Energy Potential Based on Weather and Location-Data

Machine learning analysis of weather and location data for solar energy forecasting.

PythonMachine LearningWeather Data+1 more
March 14, 2025
40% Grid Capacity Solar Potential
Bank Muamalat Indonesia User Churn Analysis
Data Analytics

Bank Muamalat Indonesia User Churn Analysis

Comprehensive customer behavior analysis across multiple product categories using BigQuery.

BigQuerySQLExcel+2 more
May 13, 2024
$1.75M Total Sales Performance
Investigate Hotel Business Using Data Visualization
Data Analytics

Investigate Hotel Business Using Data Visualization

Comprehensive visualization analysis of hospitality data revealing booking patterns.

Data VisualizationBusiness IntelligenceHospitality+1 more
April 21, 2024
87% → Optimized Cancellation Reduction
US Based Ecommerce Company-Sales Performance
Data Analytics

US Based Ecommerce Company-Sales Performance

Comprehensive visualization analysis of nationwide ecommerce performance data.

Data VisualizationeCommerceBusiness Intelligence+1 more
February 18, 2024
$8.9M (-3.06%) YTD Sales
Indonesia College Entrance Examination UTBK 2019
Data Analytics
Featured

Indonesia College Entrance Examination UTBK 2019

Interactive analytical platform for nationwide UTBK exam results visualization.

Data VisualizationEducation AnalyticsInteractive Dashboard+1 more
February 5, 2024
147K of 1.1M Sample Coverage
Kimia Farma Sales Data Analytics
Data Analytics
Featured

Kimia Farma Sales Data Analytics

Strategic data analysis creating custom data marts and ETL processes for pharmaceutical sales.

Looker StudioETLData Marts+2 more
June 2, 2024
22% in High-Rated Branches Sales Growth Potential
Predict Customer Clicked Ads Classification By Using Machine Learning
Data Science
Featured

Predict Customer Clicked Ads Classification By Using Machine Learning

Predictive click behavior model for Indonesian digital marketing campaigns optimization.

Machine LearningDigital MarketingCTR Optimization+2 more
January 19, 2025
50% → 99.8% CTR Improvement
Ecommerce Google Ads Data Analysis
Data Analytics

Ecommerce Google Ads Data Analysis

Performance metrics analysis from Google Ads campaign data with ROAS visualization.

Google AdsROAS AnalysisData Visualization+2 more
February 4, 2024
$21.34 Overall Campaign ROAS
Predict Customer Personality to Boost Marketing Campaign by Using Machine Learning
Data Science
Featured

Predict Customer Personality to Boost Marketing Campaign by Using Machine Learning

Machine learning customer segmentation for targeted marketing campaign optimization.

Machine LearningCustomer SegmentationMarketing Campaigns+2 more
December 20, 2024
4 Distinct Clusters Customer Segments
Enhancing PV Grid Management Through AC-Power Prediction
Data Science
Featured

Enhancing PV Grid Management Through AC-Power Prediction

Machine learning analysis of solar power generation dataset for grid management.

Machine LearningSolar PowerGrid Management+2 more
March 5, 2024
10x DC Output Difference Plant Performance Gap
British Airways Flight Booking Prediction
Data Science

British Airways Flight Booking Prediction

Predictive analytics transforming customer acquisition strategy from reactive to proactive.

Machine LearningPredictive AnalyticsAirlines+2 more
March 24, 2025
15% → 18% Conversion Rate
Youtube Video Views Prediction
Data Science

Youtube Video Views Prediction

Machine learning forecasting of video performance metrics before publication.

Machine LearningYouTube AnalyticsContent Creation+2 more
January 24, 2025
MAPE Performance Prediction Accuracy

Data Science Philosophy

My approach to data science focuses on extracting meaningful insights from complex datasets through rigorous analysis and statistical methods. I believe in the power of data to drive informed decision-making while maintaining data integrity and ethical considerations.

Insights First

Prioritizing actionable insights over complex models, ensuring business value

Data Quality

Building robust pipelines that ensure data accuracy, completeness, and reliability

Impact Driven

Creating solutions that deliver measurable business impact and drive growth

AI Engineering Projects

Building Intelligent Systems

Advanced AI and machine learning projects focusing on practical applications, model deployment, and production-ready AI systems.

Showing 13 of 13 AI projects

Langchain Document Assistant
Natural Language Processing
Featured

Langchain Document Assistant

LLM-powered application extracting information from text and image documents.

LangChainStreamlitChromaDB+4 more
Cloud Deployed
Live Demo
Tavily Integration
External Search
3 LLM Options
Model Support
June 26, 2025
Cloud Deployed Live Demo
Business Intelligence Chatbot
Natural Language Processing
Featured

Business Intelligence Chatbot

Conversational AI solution transforming natural language questions into SQL queries.

LangChainPostgreSQLStreamlit+4 more
RAG + Non-RAG
Query Approaches
Single + Multi-Table
Table Support
FAISS Embeddings
Schema Enhancement
May 22, 2025
RAG + Non-RAG Query Approaches
LangGraph Agentic RAG
Natural Language Processing
Featured

LangGraph Agentic RAG

Advanced RAG system with intelligent document retrieval and multi-stage quality validation.

LangGraphOpenAIChroma+4 more
3-Stage System
Quality Validation
Auto Query Direction
Intelligent Routing
Hallucination Detection
Self-Correction
July 15, 2025
3-Stage System Quality Validation
ApplyCopilot - AI Job Application Assistant
Natural Language Processing
Featured

ApplyCopilot - AI Job Application Assistant

Comprehensive AI-powered tool for cover letter generation and employer Q&A assistance throughout your job application process.

LangChainFAISSOpenAI Embeddings+5 more
Cover Letters + Q&A Chat
Dual Features
FAISS Vector Search
Resume Analysis
RAG-Powered Answers
AI Response
May 13, 2025
Cover Letters + Q&A Chat Dual Features
Database Chat with PandasAI
Natural Language Processing

Database Chat with PandasAI

Interactive solution enabling natural language conversation with relational databases.

PandasAIPandasOpenAI+3 more
Natural Language
Interface
Relational
Database Type
Auto-Generated Charts
Visualization
Insights & Reports
Output
February 24, 2025
Natural Language Interface
Real-time Object Detection API (Dummy Project)
Computer Vision

Real-time Object Detection API (Dummy Project)

High-performance object detection API using YOLOv8 for real-time video analysis.

PythonPyTorchOpenCV+2 more
89.2%
mAP@50
45
FPS
< 100ms
Latency
December 5, 2023
89.2% mAP@50
MLOps Pipeline with CI/CD (Dummy Project)
MLOps & Deployment

MLOps Pipeline with CI/CD (Dummy Project)

Complete MLOps infrastructure for automated model training, testing, and deployment.

PythonMLflowDocker+2 more
< 10 min
Deployment Time
25+
Model Versions
99.9%
Uptime
January 15, 2024
< 10 min Deployment Time
Graph RAG Knowledge Visualizer
Natural Language Processing
Featured

Graph RAG Knowledge Visualizer

AI-powered application structuring knowledge into graph structures and querying it using natural language.

LangChainOpenAI GPT-4.1PyVis+3 more
AI-Powered
Graph Extraction
Interactive Physics-Based
Visualization
File + Text Input
Input Methods
September 24, 2025
AI-Powered Graph Extraction
RAG Pipeline Visualizer
Natural Language Processing
Featured

RAG Pipeline Visualizer

Interactive tool visualizing the complete RAG process with 3D embeddings and observability.

StreamlitChromaDBSentence Transformers+4 more
3 Transparent Sections
Pipeline Stages
3D Embedding Space
Visualization
$0.0001-0.0015
Cost Per Query
October 11, 2025
3 Transparent Sections Pipeline Stages
KKA Laboratory
Natural Language Processing
Featured

KKA Laboratory

Ready-to-use AI applications for the new Indonesian "Koding dan Kecerdasan Artificial" curriculum.

Next.jsFastAPIPython+3 more
8 Apps
Applications
8 Articles
Resources
Free
Access
November 27, 2025
8 Apps Applications
Multi-Agent Travel Planner with Agno Workflows and Langfuse Observability
Natural Language Processing
Featured

Multi-Agent Travel Planner with Agno Workflows and Langfuse Observability

Production-ready travel planning system with parallel agent execution and full observability.

AgnoLangfuseOpenLIT+4 more
3 Parallel Researchers
Agents
Full Tracing
Observability
Manager Approval Loop
Architecture
January 6, 2026
3 Parallel Researchers Agents
Context Engineering Visualizer
Natural Language Processing
Featured

Context Engineering Visualizer

Educational tool demonstrating information flow into AI agent context windows before inference.

LangChainGradioFAISS+4 more
5 Visualized Sections
Context Layers
FAISS Vector Store
RAG Integration
Real-time Distribution
Token Tracking
January 22, 2026
5 Visualized Sections Context Layers
DPR AI Simulator
Natural Language Processing
Featured

DPR AI Simulator

Multi-agent AI simulation of Indonesian House of Representatives (DPR) parliamentary processes.

LangChainGradioOpenAI GPT-4.1-nano+3 more
3 Core Processes
DPR Functions
50-575 Members
Agent Simulation
13 DPR Commissions
Commission Support
$0.01-0.02 USD
Cost per Simulation
February 4, 2026
3 Core Processes DPR Functions

AI Engineering Philosophy

My approach to AI engineering focuses on creating production-ready systems that are scalable, maintainable, and ethically responsible. I believe in the power of AI to solve complex problems while maintaining transparency and reliability.

Performance First

Optimizing models for speed and efficiency without sacrificing accuracy

Production Ready

Building systems that can scale from prototype to production seamlessly

Ethical AI

Ensuring AI systems are fair, transparent, and beneficial to society

Game Zone

Choose your favorite game and have some fun! Each game offers a unique experience with scoring and challenges.

Tic Tac Toe

Classic 3x3 grid game for two players

Snake Game

Control the snake, eat food, and grow!

Rock Paper Scissors

Classic hand game against the computer

How to Play

Tic Tac Toe

Get 3 in a row to win. Players take turns marking spaces on a 3x3 grid.

Snake Game

Use arrow keys to control the snake. Eat food to grow and increase your score.

Rock Paper Scissors

Choose rock, paper, or scissors. First to win 3 rounds wins the game.

Content Hub

Writings & Videos

Explore my articles on Medium and video tutorials on YouTube covering data science, machine learning, and AI topics.

Writing
3 Next-Generation OCR Models: GLM-OCR vs PaddleOCR-VL-1.5 vs DeepSeek-OCR2
Medium

3 Next-Generation OCR Models: GLM-OCR vs PaddleOCR-VL-1.5 vs DeepSeek-OCR2

A comprehensive comparison of three breakthrough vision-language models for document understanding and text extraction. Learn how GLM-OCR, PaddleOCR-VL-1.5, and DeepSeek-OCR2 are fundamentally changing document AI.

February 19, 2026
View article
Writing
Context Engineering: The Essential Skill for the AI Orchestration Era
Medium

Context Engineering: The Essential Skill for the AI Orchestration Era

Learn how to deliberately design what information AI models see, when they see it, and in what format. This comprehensive guide covers the four principles of context engineering with a hands-on visualizer demonstrating RAG, memory management, and tool integration for production-ready AI systems.

January 22, 2026
View article
Writing
5 Underrated Libraries & Frameworks for AI Engineers to Learn in 2026
Medium

5 Underrated Libraries & Frameworks for AI Engineers to Learn in 2026

Discover essential tools for AI engineers covering inference optimization, observability, UI development, agent orchestration, and vector search—moving beyond just prompting APIs to architecting production systems.

January 11, 2026
View article
Writing
Multi-Agent Travel Planner with Agno Workflows and Langfuse Observability
Medium

Multi-Agent Travel Planner with Agno Workflows and Langfuse Observability

A comprehensive guide to building a production-ready travel planner with Agno and Langfuse, covering parallel agents, workflows, and full observability.

January 6, 2026
View article
Writing
Building Your First AI Agent with LangChain: A Practical Guide
Medium

Building Your First AI Agent with LangChain: A Practical Guide

A comprehensive guide to getting started with AI Agent with Langchain

October 20, 2025
View article
Video
YouTube

Introduction to Neural Networks

Learn the basics of neural networks and how they power modern AI.

January 20, 2024
View video
Video
YouTube

Building Your First ML Model

Step-by-step tutorial on creating your first machine learning model.

January 18, 2024
View video

Stay Updated with Latest Content

Follow me on Medium for in-depth articles and subscribe to my YouTube channel for video tutorials on data science, machine learning, and AI.

Get In Touch

Let's Work Together

Have a project in mind or just want to chat about data science and AI? I'm always excited to discuss new opportunities and interesting challenges.

Send a Message

Contact Information

Location

Your City, Country

Response Time

Within 24 hours

Current Status

Available for Projects

Open to discussing data science and AI engineering opportunities