07 · DATA ENGINEERING · PYTHON · AUTOMATION

Automated Financial Data Pipeline — Oracle to Power BI

Overview

Built a two-stage Python ETL workflow that converts legacy Oracle XML Spreadsheet exports to XLSX, applies worksheet-specific fiscal-year merge rules, validates the result, and feeds SharePoint, Power Automate, and Power BI.

Details

Key result2-stage — conversion + monthly fiscal-year merge

Links

GitHub

Stack

PythonlxmlXlsxWriterOpenPyXLOracle / PeopleSoftExcelOneDriveSharePointPower AutomatePower BI

170K+largest sheet shown

7worksheet rules

9 & 10FY periods detected

SAFE TESTbefore live update

Next projectGAN-Based Chest X-ray Augmentation for Pneumonia Detection →

Converter output showing the financial worksheets and the row counts successfully written to a standard Excel workbook.

SAFE TEST run showing automatic FY2026 period detection, matching base workbook selection, worksheet-specific output, and validation.

The automation runs the merge command and uses the process exit code to display a clear success or failure path.