Back to Projects
Tools

ERP Data Extraction Tool

Desktop automation tool that extracts bank balances from ERP software and exports to Excel on a configurable schedule. Built during internship at Edenred Turkey.

Real-world automation solving an actual business problem with measurable time savings.

What I Built

  • Developed Python automation using pywinauto to extract data from legacy ERP UI
  • Built PyQt5 interface for scheduling, file management, and configuration
  • Implemented robust logging and error handling for unattended long-term operation
  • Delivered working tool adopted by treasury team to eliminate daily manual reporting
Result

Eliminated 30+ minutes of daily manual work; reduced data entry errors to near-zero

System Architecture

Architecture diagram coming soon

Overview

Identified and automated a manual treasury reporting workflow, reducing daily manual effort and minimizing reporting errors for the finance team.

Tech Stack

PythonpywinautoPyQt5
Category: Tools
Date: 2025-07