I'm a Data Engineer specializing in building scalable ETL/ELT pipelines and cloud data solutions. Passionate about turning complex data into actionable insights that drive business decisions.

Data Engineering
DBT • Snowflake • SSIS • SQL • Jinja • ETL/ELT Design • Data Modelling

Programming Languages
Python • SQL • R • Java

Cloud & Analytics
AWS (S3, Glue, EC2, Redshift) • Tableau • Power BI • Streamlit

Machine Learning
LSTM • Random Forest • SVR • XGBoost • LightGBM • scikit-learn • pandas

Databases
Oracle • MySQL • SQL Server

Development Practices
Git • Agile Scrum • Version Control

• Building end-to-end data pipelines with DBT
• Exploring advanced ML forecasting techniques (LSTM, XGBoost)
• Developing cloud-native data architectures on AWS
• Creating interactive data visualizations and dashboards

Food Price & Food Security Forecasting
End-to-end ML pipeline forecasting food prices and security index in Malaysia using LSTM, Random Forest, SVR, XGBoost, and LightGBM. Built with Python, Streamlit, and Snowflake.

Malaysian Affordability Gap Analysis
Data science project analyzing income versus household spending across Malaysian states to quantify affordability gaps and financial pressure with professional statistical visualizations.

DBT Transformation Models - ResMed
Built DBT transformation models converting Oracle ERP datasets into Snowflake tables with standardized logic using Jinja templates for improved SQL reusability.

Banking ETL Pipelines - InsiteMY
Developed ETL pipelines via SSIS and SQL Server for banking clients (BIMB, AmBank), delivering reporting systems including DQF, STATSMART, and ISS.

Analytics Engineering Intern @ ResMed
May 2024 - Aug 2024 | Kuala Lumpur

• Built DBT transformation models for Oracle to Snowflake migration
• Standardized logic using Jinja templates to improve SQL reusability
• Participated in Agile sprints, Git-based workflows, and deployment cycles
• Explored Dagster-based cloud orchestration for pipeline automation
• Supported analytics across finance, supply chain, and marketing teams

Analyst Programmer @ InsiteMY Innovations
2021 - 2022 | Kuala Lumpur

• Developed ETL pipelines via SSIS and SQL Server for banking clients (BIMB, AmBank)
• Delivered reporting systems including DQF, STATSMART, and ISS
• Translated business logic into SQL and Java modules
• Contributed to regulatory reporting for Bank Negara Malaysia

B.CompSc (Hons) Data Analytics - Asia Pacific University (APU)
2023 - 2025 | CGPA 3.2

Diploma in Computer Science - Kolej Profesional MARA Beranang
2019 - 2021 | CGPA 3.3

Certifications:

• Cisco Data Analytics Essentials
• Cisco Introduction to Data Science
• MyDIGITAL & Intel AI Aware Badge (AI Untuk Rakyat)

I'm always open to discussing data engineering opportunities, collaborations, or just chatting about data!

• Portfolio: ravager1204.github.io
• LinkedIn: Wan Ahmad Fahim
• Email: wanahmadfahim828@gmail.com

"Turning raw data into meaningful insights, one pipeline at a time."