Project Details

1. The process begins by connecting to the client's email, where emails containing various file types, including authorizations, PDFs, images, among others, are received. 2. Emails containing authorizations are identified based on the email subject. These emails are processed to download the associated attachments. 3.Using Python, validation of the downloaded files is performed based on the expected format of the authorizations. Files that do not meet this format are deleted. 4.All relevant information, including email subject, sender, timestamp, file name, validation status, and whether it was deleted or not, is consolidated into a detailed report. 5.Once all authorizations are identified, they are consolidated into a single file for further processing. 6.A load file is created where business rules are applied using the consolidated authorization file. 7.BH is opened, logged into, the platform is navigated, and the previously created file is loaded. BH generates a LOG file with information about records loaded correctly and those that are not. 8.The LOG file is cross-referenced with the consolidated file to report records loaded correctly, leaving the corresponding load code, and concatenating all comments in the record for review by the responsible area. 9.Finally, emails are sent with the created files, informing about records loaded correctly and providing details on any loading-related errors or comments 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 execution. This included the initial requirements gathering analysis, work planning, identification of process improvements, system development, user acceptance testing (UAT), code reviews, production implementation, system stabilization, and resolution of any errors reported by the client.