Available for new engagements

Arnie Cuabo

Data Analyst & Business Intelligence Developer

Bridging the gap between physical utility infrastructure and advanced cloud analytics. Specializing in enterprise Power BI deployment, complex DAX modeling, automated Python ETL pipelines, and live API architecture to deliver clear, executive-ready market insights.

Explore Solutions Download CV Get in Touch

Technical Core

Core Expertise & Stack

Analytics Architecture & BI

Power BI
Star Schema Modeling
Advanced DAX
Power Query (M)
Enterprise UI/UX

Data Engineering & Cloud

Python
SQL Server
MySQL
PostgreSQL (NeonDB)
SQLAlchemy
FastAPI
REST APIs

Full-Stack Apps & Automation

Streamlit
Tkinter GUI
Automated ETL
Cron Schedulers

Domain Knowledge & GIS

Registered Electrical Engineer
WESM Market Dynamics
Utility Operations
GIS Mapping

Section A · Enterprise BI

Architecture & Executive Analytics

Flagship Project

WESM Market Analytics & Predictive Forecasting Engine

Formulated advanced, rounded DAX measures and engineered a production-grade 3-page business intelligence engine to optimize power market exposure, manage grid capacity factors, and minimize financial setbacks.

Page 1

Operations Summary

Dual-axis price bars (normal vs. setback) overlaying MQ & BCQ tracking lines. Executive KPI blocks (Net Exposure, Peak/Off-Peak Price, LCF), multi-tier date slicers, and generation portfolio splits across PSALM, GNPK, TSI, FDC, MPI, SEC.

Page 2

Historical Audit & Variance

Multi-month time-horizon filtering. Tracks total WESM costs, worst intervals, and daily metrics with conditional bars isolating severe setbacks (>₱8k) and opportunities (<₱4k) against flat contract baselines, plus Price vs. Exposure scatter plots.

Page 3

Predictive Load Forecasting

ML forecasting interface using Facebook Prophet and Holt's Exponential Smoothing. Visualizes actual MQ demand against ±2.8MW confidence bands vs. flat contracts, feeding an automated Hourly Nomination Guide with dynamic action flags.

Power BIAdvanced DAXPredictive Time-SeriesEnergy TradingStar SchemaUI/UX

Project 02 · Collections

Commercial Promise-to-Pay (PTP) Collections Dashboard

Designed and deployed a robust, 2-page operational analytics dashboard using advanced DAX modeling and sophisticated UI/UX layouts to track payment dataset trends, optimize accounts receivable strategies, and measure organizational recovery performance.

Page 1

Overview

5 strategic KPI cards (Total PTPs, Successful Payments, Conversion Rate, Avg PTP Value, Broken PTPs), a high-density combo chart tracking daily PTP creations vs. CAD payment value, a PTP Portfolio donut (Kept 63.5%, Active 21.9%, Broken 14.6%), Top Accounts grid, and an Agent Conversion Rate panel.

Page 2

Trend Analysis

Macro-level 6-month time-series of PTP generation velocity, Monthly Collections Value chart (peaking at $84,320 in June), Conversion Rate trend index, and a Kept vs. Active vs. Broken stacked bar chart for month-over-month portfolio risk evaluation.

Power BIFinancial Data ModelingAccounts ReceivablePower Query (M)Cohort Analysis

Project 03 · Multi-Source BI

Multi-Source Collector Leaderboard & Performance Dashboard

Engineered an enterprise-grade, pixel-accurate 3-page reporting canvas structured around cross-departmental data integration with a fully responsive 16:9 auto-scaling layout. Native-style dropdown slicers with search and multi-select checkbox controls filter dynamic metrics globally by Branch (1–99), Data Source, and Month.

Page 1

Overview

5-KPI card array with a dual-axis combo chart tracking daily commission value against target parameters, backed by a portfolio donut (Kept / Active / Broken), Top Accounts analytical table with source tags, and an individual agent conversion rate grid.

Page 2

Leaderboard Panel

Advanced agent ranking system with medals (🥇🥈🥉), source origin pills (MySQL / SSMS / Excel), branch locations, MTD commission, target attainment progress bars, 3M/6M rolling averages, YTD aggregates, and MoM rank movement indicators.

Page 3

Source Analysis

Technical telemetry workspace mapping data stream distributions side-by-side: database contribution % across branches, monthly intake trends via stacked bars (Jan–Jun), aggregate source rank movements, and live data-freshness timestamps.

Power BI ArchitectureDropdown SlicersCross-FilteringMySQLSQL ServerDashboard UI/UX

Section B · Cloud Engineering

Pipeline & Infrastructure Solutions

Live WESM Market Data Streaming API

Reverse-engineered a locked, embedded dashboard infrastructure to bypass manual export dependencies. Wrapped extraction in a robust FastAPI pipeline, deployed the microservice, and configured a 24/7 cron sequence to stream clean spot prices, regional supply, and demand metrics into structured JSON endpoints every 5 minutes.

FastAPIPythonREST APICloud DeploymentRenderJSON Infrastructure

View LinkedIn Post

Cloud-Synced Streamlit Energy Optimization App

Full-stack dual-dashboard Streamlit app integrated with a live Neon PostgreSQL cloud backend. Automated ETL using Python to migrate and upsert local SQLite records into the cloud — auto-generating target schemas when missing and safely appending fresh metrics. Includes role-based access and real-time interactive tracking for hourly trading differentials.

StreamlitNeonDBPostgreSQLPythonAltairDatabase Syncing

View Project Details

Automated Energy Trading Desktop GUI & DB Pipeline

Cross-platform Tkinter desktop app automating ingestion, validation, and schema matching of raw energy trading reports (BCQ, MQ, Spot Prices). Defensive programming and smart sync logic handle cloud database migrations safely without duplication errors.

PythonTkinter GUIPandasSQLAlchemySQLite Warehousing

See It In Action

Credentials