Consumer Complain Tracking 

My Role     : Business Intelligence (BI) Developer

Context     : Complaince department at Bank of America receives consumer complaints from the Consumer Financial Protection Bureau(CFPB) and is expected to handle them appropriately and swiftly by creating a report to track open and closed complaints for a specific period and visualize the weekly trend to avoid overdue complaints.

Outcomes     : Seasonal Patterns, Product and Issues Analysis, Resolution Analysis

Recommendation :  Identify and Address Seasonal Trends,Focus On High-Complaint Products, Resolve Common Issues Effectively, Improve Resolution Strategies. 

Methodogy  : Analyze the data using Excel

The Data     : Data used from Kaggle datasets.

Skills             : Excel