Gerry Ongko Email & Phone Number

Engineered the ETL process from and to multiple platforms using Python and SQL. Focused on ensuring data accuracy and integrity for reporting and dashboarding purposes, including conducting thorough data audits to identify errors and anomalies, and implementing data cleansing procedures for data migration.Elevated data time and yield efficiency whilst increasing the scope of data functions to include actuarial models, machine learning, and systematic audits.

Constructed data pipeline and dashboard for High-Performance Computing (HPC) usage pattern. Suggested recommendations for compute infrastructure through exploratory and statistical data analysis.

We take data and find insights to identify improvable sectors in the business. Designed and built a company-wide dashboard from scratch, mainly using Python, SQL and Tableau. Organised our data warehouse using Tableau Prep Builder and created the design using Figma. We officially launched our dashboard five months after initiation.Built machine learning models to predict borrower credit scores. The model is implemented seamlessly in a web app with Flask APIs. This project aims to strengthen the credit analysis process and make it more efficient.

Project with University of Melbourne, Applied Data ScienceDeveloped an algorithm that determines energy charging and discharging positions given full future price visibility. Adjusted the algorithm for energy limitations such as storage capacity, energy dispatch efficiency, and marginal loss factor. Obtained 98% of total possible revenue using ex-ante model fitting.Implemented time series models (VAR, ARMA, LSTM) to predict electricity price movements using Python and EViews. Conducted statistical tests to determine statistical features such as optimal lags and stationarity.Implemented the final algorithm on the predicted price to assess the algorithm's and model's sustainability in an independent setting.