I automated daily and weekly customer support MIS reports with Excel VBA, processing more than 1,500 tickets and reducing report compilation time by 75%.
For the ticket reporting project, I programmed ticket-priority categories and SLA breach flags, then created summary sheets and pivot charts to track productivity, turnaround time, and CSAT.
I built a three-page hotel performance dashboard in Power BI with DAX KPIs and synced slicers. It highlighted revenue and profit-margin patterns across countries, booking channels, and room categories.
I also analyzed retail disputes and fulfillment delays in Excel, and designed a customer support SQL database with constraints that improved record integrity by 20%.
