Project Details

1. The process begins with logging into BH, a platform where tasks and reports are managed. 2. Navigation through the platform is conducted to access necessary forms and complete them to download a national pending file and a management report. 3.Pending tasks are assigned based on their urgency and corresponding authority level, ensuring efficient task distribution. 4.Macros are applied to automate specific processes. These macros are then converted to Python code through Reverse Engineering, enhancing flexibility and control over automated tasks. 5.The obtained data is populated into a template designed to display a dashboard summary, providing an overall and detailed view of the current situation used by management for decision-making. technology used: Python, SQL, Error handling, Reverse engineering, AA, web page, File management, Logs review: This process was assigned to me due to the lack of documentation, its age, and the issues it presented, such as extended runtime and recurring errors. In response to this situation, a comprehensive restructuring was undertaken. As a result of this restructuring, we were able to significantly reduce the runtime from approximately 1 hour to just 10 to 15 minutes by migrating all operations to Python. Additionally, during this optimization process, various flaws were identified and corrected, leading to increased efficiency and reliability of the overall process.