Aditya Ambre

Experience

• 

  Southern Methodist University

  Sept 2021 - May 2023

  Data Analyst (Technical Support)

  Roles and Responsibilities:---->Leveraged SQL queries to extract, manipulate, and analyze large datasets from the company's databases, allowing for deeper insights into customer support metrics and trends. Utilized advanced Excel macros and VBA scripts to automate routine data analysis tasks, enhancing efficiency by 30%. ---> Collaborated with cross-functional teams to implement a new ticketing system, where SQL queries were employed to extract relevant data for system configuration and user training sessions. Provided ongoing support and utilized Power BI to create intuitive dashboards for monitoring ticketing system performance, contributing to a 20% reduction in resolution time. ---> Utilized SQL and Power BI to analyze customer support data, applying statistical methods and predictive modeling techniques to identify pricing trends and patterns. This enabled proactive problem-solving strategies and contributed to a 25% reduction in incident recurrence, ensuring optimal pricing strategies and profitability for the organization. ---> Deployed SQL queries and Power BI to analyze historical pricing data, market trends, and competitor pricing strategies. Conducted pricing elasticity analysis and performed regression modeling to identify optimal pricing points for different product categories, resulting in a 15% increase in profit margins while maintaining competitive pricing positioning. Show less