Andre Lu

I’m a computer science graduate specializing in software development, data engineering, and data analysis, with projects focused on ELT pipelines, exploratory data analysis, and data-driven applications.

In my internship at Vison Technologies Corporation, I created an Android mobile application prototype based on client requirements and rebuilt an existing web application using HTML, CSS, JavaScript, and PHP.

For my Philippine Weather Analytics Pipeline, I built an end-to-end ELT pipeline ingesting 10 years of daily weather data for 83 provinces from the Open-Meteo API, orchestrated with Kestra for daily incremental loads and historical backfill. I engineered dbt staging, intermediate, and mart layers to produce analytical tables such as province climate summaries, monthly seasonality patterns, and weather risk profiles, and I delivered insights via Power BI choropleth maps and trend analysis.

I also built a Car Viewing Application that scrapes and displays live car listings and automotive news using Python with PySide6, Selenium, SQLite, and BeautifulSoup4, including data cleaning, transformation, and a responsive GUI. Alongside that, I conducted end-to-end exploratory data analysis on 9,994 transactions using Pandas, Matplotlib, and Scikit-learn to uncover profitability drivers across product categories, customer segments, and regions.