Electronic Case File Management | Daniel Arbelaez Alvarez

Electronic Case File Management is a system developed to automate the assembly of electronic case files across all dependencies of the Colombian Judicial Branch. The project has evolved through two major versions.

Version 1 - Desktop Application (2022)

MVC Architecture: Model-View-Controller pattern
Graphical Interface: tkinter for judicial operators
PDF Processing: pypdf2 for procedural document manipulation
Excel Integration: xlwings and pandas for data manipulation
Language: Python 3.9.6

Version 2 - RDA + Streamlit (2024)

The second version combines Robotic Desktop Automation (RDA) with modern technologies:

Web Frontend: Streamlit deployed in the cloud (Live App)
RDA: Robotic Desktop Automation for interaction with legacy systems
Advanced Processing: Integration with modern document processing technologies

Key Features

Full Automation: Eliminates manual case file assembly operations
PDF Processing: Automated organization, renaming, and structuring
Judicial Integration: Designed for the specific workflow of the Judicial Branch
Web Access: Version 2 accessible from any browser
Ease of Use: Intuitive interface for judicial operators without technical knowledge

Achievements

~200% reduction in time for electronic case file formalization, significantly optimizing operational efficiency in judicial dependencies nationwide.

Impact

This project assists the manual operations of electronic case file assembly, automating repetitive processes and drastically reducing processing times. Version 2 amplifies this impact by being accessible from the cloud.

The evolution of this system reflects the author’s technological growth: from a desktop application with tkinter to a modern web solution with Streamlit and RDA, always maintaining focus on solving real problems for Colombian judicial operators. Repositories: Version 1 | Version 2