Individual Borrowers Loan Alert via Email (AWS, Lambda, DynamoDB, TypeScript, etc. ) -- 2

Ideal Skills:
- AWS and Serverless architecture Expert
- TypeScript Expert
- Can use ChatGPT or any AI tool to quickly develop and test the solution to make it up and running.

Please note, the specific details of the loan alert emails have not been determined yet. A degree of flexibility and creativity will be appreciated.

### Detailed Specification for Loan Alerts Feature

#### Database Schema (This is already created)

**1. users** (This is already created)
- `user_id` (Primary Key)
- `email`
- `name`
- Other user details

**2. loan_alerts** (This is already created)
- `loan_id` (Primary Key)
- `user_id` (Foreign Key)
- `current_interest_rate`
- `loan_amount`
- `loan_tenure`
- `loan_purpose`
- `loan_type`
- `preferred_reminder_date`
- `created_at`
- `updated_at`
- `loan_product_id`

**3. user_subscription_preferences** (This is already created)
- `user_id` (Primary Key, Foreign Key)
- `email_notifications` (boolean)
- `web_notifications` (boolean)
- `alert_types` (list: Rate Drop, Loan Review Reminder, etc.)

#### Backend Developer

**Frameworks and Technologies:**
- **AWS Lambda** for serverless functions.
- **DynamoDB** for database storage.
- **TypeScript** for type safety and scalability.

**Tasks:**

1. **Database Setup** (This is already created)
- **Tables:**
- `users`
- `user_id` (Primary Key)
- `email`
- `name`
- Other user details
- `loan_alerts`
- `loan_id` (Primary Key)
- `user_id` (Foreign Key)
- `current_interest_rate`
- `loan_amount`
- `loan_tenure`
- `loan_purpose`
- `loan_type`
- `preferred_reminder_date`
- `created_at`
- `updated_at`
- `loan_product_id`
- `user_subscription_preferences`
- `user_id` (Primary Key, Foreign Key)
- `email_notifications` (boolean)
- `web_notifications` (boolean)
- `alert_types` (list: Rate Drop, Loan Review Reminder, etc.)

2. **API Development**
- **Endpoints:**
- `POST /api/alerts` - Create a new alert.
- `GET /api/alerts` - Fetch all alerts for a user.
- `PUT /api/alerts/{alert_id}` - Update an alert.
- `DELETE /api/alerts/{alert_id}` - Delete an alert.

- **Lambda Functions Using TypeScript:**
- Create Lambda functions to handle the above endpoints.
- Use DynamoDB for storing and retrieving alert data.

3. **Notification Service**
- **Interest Rate Monitoring:**
- Set up a scheduled Lambda function to check current interest rates.
- Fetch data from `brands` and `products` tables to compare current rates with users' desired rates stored in DynamoDB.
- Logic:
1. Fetch all active alerts from `loan_alerts` table.
2. For each alert, query `products` table to find products matching the `loan_type` with an interest rate lower than the `desired_interest_rate`.
3. If a matching product is found, trigger a notification to the user.

- **Sending Notifications:**
- Use AWS SES to send email notifications.
- Use AWS SNS for web notifications.
- Ensure notifications are sent according to user preferences and alert types.

4. **Data Validation and Security**
- Validate incoming data for alerts (e.g., valid interest rates).
- Ensure secure handling of user data and preferences.

### Deliverables

#### Backend
- DynamoDB table setup.
- API endpoints for alert management.
- Lambda functions for API handling and interest rate monitoring.
- Notification service using AWS SES and SNS.

### Development and Deployment

- **AWS Account Access:**
- Both freelancers will be provided access to the AWS account to deliver the project securely following best industry standards.

- **Deployment:**
- Ensure all code is deployed using industry best practices for security and scalability.
- Use CI/CD pipelines for deployment (e.g., AWS CodePipeline).

This detailed specification should provide a clear and comprehensive guide for both freelancers to deliver the loan alerts feature effectively.