Project Details

1. The process begins with logging into BH, navigating the platform to download the COLSANITAS and MEDISANITAS reports. Functionality is implemented to capture screens in case of any errors within the web page, and these captures are sent as email attachments. 2. The two downloaded reports are merged into a single report, and business rules are applied, all using Python (Pandas) exclusively for data manipulation. 3.Once the final report is obtained, it is then split into individual files containing information for each client, identifying each record by the corresponding NIT number. 4.Each individual file is sent to the respective client, ensuring that each recipient receives only the information relevant to them. 5.An execution report is generated highlighting who received an email and who had a file created for them, providing a detailed record of the actions taken during the process. technology used:Email, Python, SQL, AA, Good practices, Logs review: This process was assigned for development from scratch, and I assumed full responsibility for its implementation. This included initial requirements gathering analysis, work planning, process improvement identification, system development, user acceptance testing (UAT), code reviews, production implementation, system stabilization, and resolution of any errors reported by the client.