Luis Rana

Data Engineer · Manila, Philippines

I specialize in building robust data pipelines and architectures. Transforming raw data into reliable, actionable insights through modern engineering practices.

What I'm currently working on

Reading Fundamentals of Data Engineering by Joie Reis. Learning Snowflake Data Warehousing

Tech Stack

AirflowdbtDockerLinuxPostgresPowerBIPythonSQLSnowflakeCloud (AWS)

Certifications

Data Engineer Associate - Datacamp

dbt Fundamentals - dbt Labs

Apache Airflow 3 Fundamentals - Astronomer

Apache Airflow 3 DAG Authoring - Astronomer

Data Engineering Foundations Specialization - IBM

Professional Experience

Data Engineer Intern

Stratpoint Technologies • Mandaluyong, PH

June 2025 – Sep. 2025

Selected for an intensive 12-week Data Engineering Immersion program, building production-grade ELT architectures under mentorship and technical critique of senior engineers.
Architected and deployed end-to-end ELT pipelines for E-commerce (Olist) and Media (Netflix) datasets using Airflow for orchestration and dbt for modular SQL transformations.
Developed optimized data models by transforming raw landing zone data into structured star-schemas, ensuring data integrity and high performance for analytical reporting.
Applied software engineering best practices such as Git-based version control, environment isolation, and Agile delivery to consistently hit strict project deadlines.
Translated pipeline outputs into actionable business intelligence using Power BI, creating executive-level dashboards to track key performance indicators (KPIs).

Data Analyst Intern

MSCI • Makati, PH

June 2024 – Sep. 2024

Developed a custom Python-based ETL utility to automate the refactoring and loading of LSEG (Refinitiv) financial datasets, resulting in a 98% reduction in manual processing time.
Architected a standardized data landing zone by engineering an automated synchronization workflow between local environments and cloud storage (OneDrive), bypassing infrastructure and API bottlenecks.
Ensured 100% data integrity between external vendor portals and internal repositories through automated quality assurance checks while continuously improving internal workflows via professional development initiatives.

AI Software Engineer & Technical Consultant

ExoAsia • Makati, PH

March 2025 – May 2025

Placed 3rd out of 8 engineering teams in a company-wide AI Innovation Hackathon, developing a high-viability SaaS prototype that addressed critical executive-level business needs.
Led technical discovery workshops and design thinking sessions to translate ambiguous stakeholder pain points into a structured roadmap for AI-integrated solutions.
Spearheaded the rapid development of a functional SaaS MVP utilizing prompt engineering and LLM orchestration, maintaining project momentum despite significant stakeholder ambiguity.

Engineering Portfolio

Personal Projects

End-to-End E-Commerce Data Pipeline

Built an automated end-to-end ELT pipeline for Brazilian e-commerce data, implementing dimensional modeling, dbt transformations, and Airflow-driven data quality checks hosted in docker

AirflowdbtPostgresDocker

View on GitHub

SoulAR: MIDI to Tabular Data Converter

Developed a python script that takes piano MIDI preses as input and converts it into tabular data to be used for heatmap analysis.

PythonData Pipeline

View on GitHub

Featured Project

Coursera IBM Data Engineering ETL Project

ETL Project for IBM's Data Engineering Coursera Course

PythonETL

View on GitHub

Academic Projects

SerioudMD: Distributed Database System

Developed an entire data architecture platform thats ACID complimant using MySQL and Percona XtraDB Cluster to bridge high-frequency data ingestion with a live Power BI dashboard and a custom client web appliaction

SQLPythonPowerBIDistriuted Databases

BantayBuddy

A social media web application for people who love pets and want to showcase their own as well. Built with NextJS, React, JavaScript, and Firebase

NextJSReactJavaScriptFirebase

View on GitHub

AnimoOS: Operating System Emulator

Emulated an Operating System on a through a command-line interface (CLI), highlighting on how an Operating System runs under the hood. Made with C++.

Operating SystemsComputer Architecture

View on GitHub

PixelForum

An online gaming forum web application for gamers, hobbyist, and fandoms to discuss about anything related to gaming and pop culture.

HTML/CSSReactNodeJSFirebase

View on GitHub

PasaHero

A navigational aid mobile application for Filipino Commuters. High-Fidelity concept made with Figma, empowered by real users and countless iterations.

UI/UX DesignFigmaDesign Thinking

FARM: Food Analysis Resource Monitoring

A dedicated social media hub and platform analytics website for the food industry. This is a team submission for our first Hackathon hosted at Ateneo de Manila University. Also we won 2nd place.

HackathonDesign ThinkingHTML/CSSJavaScript

View on GitHub

Spotify Genre Classification Data Analysis

Trained Machine Learning models to help identify spotify music genre trends. Turned raw, bad data into actionable insights

PythonMachine LearningData Analysis

View on GitHub

MyFarm: Farming Simulation Game

A Java-based farming simulation game using JavaFX for the graphical user interface, showcasing our proficiency in object-oriented programming, game development, and user experience design.

JavaJavaFxOOP

View on GitHub

PokeDex CLI

A simple Trainer PokeDex containing all 150 Kanto Region Pokemon in a Command Line Terminal Program

CCLI

View on GitHub

Academics

Education

De La Salle University

Sep 2021 - Feb 2026

Bachelor of Science in Computer Science, Major in Software Technology

Cum Laude • Most Outstanding Thesis Award

Data Structures & AlgorithmsDatabase SystemsSoftware EngineeringHuman-Computer InteractionUI/UX DesignDistributed SystemsCloud Computing (AWS)

Extracurriculars

DLSU Human-X Interactions Lab

Nov 2023 - Present

Senior Researcher & Member

Led talks and shared insights for junior researchers and students. Facilitated leisure activites and team bonding events for the organization.

ResearchMentorshipCommunity Building

Viridis Arcus Esports

Feb 2025 - Oct 2023

Financial Executive

Assisted in strategizing the financial needs and generated finance reports of all project operations within the organization.

FinancesReportingOperations

La Salle Computer Society

Nov 2021 - Aug 2022

Research and Development Junior Officer

Built a functional voting application MVP using Figma, focusing on technical feasibility and cross-functional design. Evaluated emerging technologies and design patterns to support organization-wide software initiatives.

ResearchFigmaPrototyping

Operations & Logistics Executive

Assisted in operations & delivery for hackathons hosted by the organization streamlining overall project operations.

LogisticsEvent Operations

University Student Government - Computer Studies

Nov 2021 - Mar 2022

Integrated Marketing Communications Executive

I created and designed publication materials for the organization. Did some graphic design, photo-editing, and video-editing

DesignBrandingMedia

Contact

migzzzrana@gmail.com