Rate Upload and Acquisition Mechanism

Developed a system for the Bank of Occidente to enable specific departments to upload Excel files containing interest rates, customer profiles, and product types (e.g., housing loans, personal loans, vehicle loans). The system validates the file format using Python, converts it to CSV, and stores the rates in an AWS DynamoDB database in batch operations, optimizing the process for large-scale data uploads.

Additionally, the system provides an API to allow other products or services to consume the stored data dynamically, retrieving the specific rate sets based on product type.

If the process completes successfully, the system sends a notification via AWS SNS topics to relevant stakeholders. In case of errors during validation or processing, error notifications are sent via the same mechanism.