Selected work / Automation

Reporting automation with Python and Oracle

Python automation that runs complex SQL analytics and cuts manual extraction time by 70%.

The story

Challenge

Recurring reports depended on manual data pulls and copy paste, slowing every reporting cycle.

What I did

Built Python scripts using cx_Oracle and pandas to run SQL queries, transform results and produce report ready outputs.

Result

Manual extraction and analysis time reduced by 70%, giving leadership and operations teams faster insight.

Tools

Pythonpandascx_OracleSQLOracle