T-Mobile USA

Resource Planning Analyst & Community Planning

Problem: Over the Summer of 2024, I worked with T-Mobile as a Resource Planning Analyst Intern. My job was to develop data visualization dashboards to ensure accurate data reporting and call center operations. My team specifically oversaw the T-Mobile call center metrics reporting for 3 sites in the United States, and I was tasked with utilizing SQL, Microsoft Power BI, and Azure Data Studio to automate reporting processes and direct dashboard visualization for non-technical internal teams.

Explanation: I built 2 separate dashboards during my internship for easier data reporting. In one dashboard I pulled in 17,500+ data points to streamline reporting for call center agents and identify scheduling conflicts. My second dashboard involved solving call center support tickets and answering over 400+ tickets weekly to ensure smooth business operations and support customer service initiatives.

Programs used include Azure Data Studio (SQL), Snowflake, Microsoft Excel and Power BI, Verint, and UKG Dimensions.