Data & AI Consultant · Kuala Lumpur, Malaysia
Rafi Aqila Hidayat
Building data platforms and intelligent systems that create real business value
Data consultant specialising in cloud-based data engineering and AI, with a background in Industrial Engineering. I build scalable data pipelines, clean semantic layers, and AI-powered systems that help organisations make sharper decisions and add valuable values to their business.
Career
Experience
Associate Data Consultant
Synogize · Kuala Lumpur, Malaysia
- Built cloud-based data engineering pipelines for a leading Malaysian property client, delivering clean, well-modelled semantic layers that power both analytics and AI use cases
- Won 1st place in the Synogize internal Snowflake AISQL Innovation Challenge, building an end-to-end AI site safety inspection app using Snowflake Cortex AI functions
- Built Snowflake Intelligence, an NL2SQL chatbot enabling business users to query their own data through natural language conversation
Snowflake
Fivetran
SQL
Python
Qlik
Power BI
Data Scientist Intern
eBdesk Malaysia · Petaling Jaya, Selangor
- Performed data cleaning, exploratory analysis, and trend identification on structured datasets
- Built data visualisations and analytical reports for both technical and non-technical stakeholders
Python
Tableau
Power BI
Knime
QGIS
Research Officer
Youth for Energy Southeast Asia (Y4E-SEA) · Remote
- Built data visualisations and interactive dashboards on ASEAN energy trends and youth demographics, translating raw figures into narratives that shaped the organisation's research direction and public reports
- Co-authored published reports: “Decarbonising the Unabatable: Green Hydrogen for Indonesia’s Industrialised Future” and “ASEAN Generational Gap: The Missing Link for A Just Future”
Industrial Engineer Intern
Infineon Technologies · Kulim, Kedah, Malaysia
- Developed a cross-site productivity improvement platform across Malaysia, Austria, and Germany, contributing to €40M+ in projected savings
- Conducted time studies in photolithography; identified that the longest activity accounts for 42% of total process time and prepared solutions to address it
- Explored optimisation of photolithography machine utilisation using linear programming as part of undergraduate thesis
Selected work
Projects
AISQL Site Safety Inspection
AI-powered site safety inspection app built on Snowflake. Analyses construction images to detect hazards, classify risks, generate scores, and recommend corrective actions. Shifts safety management from reactive to proactive.
Snowflake AI SQL
Streamlit
Python
AISQL Site Safety Inspection
AI-powered site safety inspection app built entirely on Snowflake. Analyses construction site images to detect hazards, classify risks, generate safety scores, and recommend corrective actions. Shifts safety management from reactive to proactive.
Key features
- Automated hazard detection from uploaded construction site images using Snowflake Cortex AI functions
- Risk classification with severity levels and per-site safety scoring
- AI-generated corrective action recommendations for every detected hazard
- End-to-end Streamlit app running natively inside Snowflake with no external infrastructure
Tech stack
Snowflake AI SQL
Streamlit
Python
Tennis Tracker
Personal tennis data pipeline on the GCP free tier, running under $1/month. Log sessions via a conversational Telegram bot, get AI coaching from Gemini, and track progress on a Mini App dashboard.
n8n
BigQuery
Gemini
Telegram
Docker
Tennis Tracker
Personal tennis data pipeline built on the GCP free tier, running under $1/month. Log sessions through a conversational Telegram bot, get AI coaching feedback from Gemini, and track progress on a Telegram Mini App dashboard.
Key features
- Conversational session logging via a Telegram bot. No forms, just chat.
- AI coaching feedback from Gemini based on logged session data
- Telegram Mini App dashboard for tracking progress over time
- BigQuery as the data warehouse, orchestrated with n8n and deployed via Docker
- Entire stack runs on the GCP free tier for under $1/month
Tech stack
n8n
BigQuery
Gemini
Telegram
Docker
AI Chatbot & Operations Automation
End-to-end operations automation for an Indonesian agribusiness company. AI WhatsApp chatbot, employee attendance, production & inventory management, and three role-based monitoring dashboards.
n8n
WhatsApp
Supabase
OpenAI
Redis
PostgreSQL
Google Sheets
AI Chatbot & Operations Automation
End-to-end operations automation for an Indonesian agribusiness company, replacing manual, paper-based processes with an AI WhatsApp chatbot and a connected data platform covering attendance, production, and inventory.
Key features
- AI WhatsApp chatbot that staff use for day-to-day operations, with no new app to learn
- Employee attendance tracking through chat
- Production and inventory management with structured data capture
- Three role-based monitoring dashboards for owner, manager, and supervisor views
- Delivered in two phases: core chatbot and database first, then expanded automation and reporting
Tech stack
n8n
WhatsApp
Supabase
OpenAI
Redis
PostgreSQL
Google Sheets
Semiconductor Capacity Optimisation
Undergraduate thesis on optimising capacity allocation in semiconductor manufacturing using Integer Linear Programming. Implemented in MATLAB and validated with real production data.
Excel
Semiconductor Capacity Optimisation
Undergraduate thesis on optimising capacity allocation in semiconductor manufacturing using Integer Linear Programming, developed in collaboration with Infineon Technologies and validated against real production data.
Key features
- Integer Linear Programming model for allocating capacity across photolithography machines
- Implemented and solved in MATLAB
- Validated with real production data from Infineon’s Kulim fab
- Built on time-study findings that the longest activity accounts for 42% of total process time
Tech stack
Excel
Background
Education
2020 – 2024
Bachelor of Engineering
Mechanical-Industrial Engineering
Achievements
- Dean’s List: Semesters 1, 5, 6, 7, and 8
- 4.00 GPA in final semester
- Vice President, Indonesian Student Association 2022/2023
Relevant coursework
Operations Research, Applied Numerical Methods, Engineering Statistics, Engineering Mathematics, Engineering Management
2022
Summer School
Robot Interaction Design Experience (2 ECTS)
Coursework
3D CAD Modelling, Arduino Uno, Problem Identification & Ideation
Credentials
Certifications
Snowflake
SnowPro Core Certification
Aug 2025 · Expires Aug 2027
ID: 157695956
Microsoft
Azure Fundamentals
Sep 2025
ID: F24F40EEC70FF2BF
Tableau
Desktop Specialist
Nov 2024
Score: 875 / 1000
Google · Coursera
Google Data Analytics
Professional Certificate
Toolkit
Skills
Data Engineering
Snowflake
BigQuery
Fivetran
SQL
Medallion Architecture
Data Modelling
ETL / ELT Pipelines
Visualisation & BI
Tableau
Power BI
Qlik
Looker Studio
Knime
QGIS
Cloud & Infrastructure
Azure
Google Cloud
Snowflake
Docker
n8n
Engineering & Analytics
Get in touch
Open to consulting engagements, data engineering projects, and interesting collaborations.