AR

Ajay Rawat

Data Analyst Intern · ANAHEIM DUCKS

Irvine, CA

In My Own Words

Experienced data professional with 3+ years of expertise in data analysis, transformation, and visualization using tools
like SQL, Tableau, Azure, R, Python, & Excel. Proven track record of delivering actionable insights for strategic decisionmaking,
passionate about enhancing business performance, and skilled in data-driven solutions.

Work Experience

Data Analyst Intern

ANAHEIM DUCKS

2023 – 2023

Achieved a 15% decrease in churn by utilizing logistic regression, decision trees, and a time series with ARIMA in python to determine season ticket holder churn and strategize actionable recommendations to improve retention rates through Excel and PowerPoint. ? Boosted sales by 20% among high churn segments by implementing clustering analysis on customer demographic data using the K-means algorithm and identified distinct season ticket holder segments for targeted marketing strategies. ? Improved the sales team's decision-making process by 10% by utilizing visualizations of KPIs and interactive dashboards created in Tableau and incorporating the logistic regression model into Duck's CRM. ? Empowered cross-functional teams with actionable insights on ticket seasonality, customer preference, and market trend through ad-hoc reports and data cleaning of large datasets from Ticketmaster and other sources using SQL.

Senior System Engineer

INFOSYS

2019 – 2022

? Integrated legacy systems with SharePoint using Microsoft BizTalk Server, resulting in a 25% reduction in processing time. Produced detailed JIRA documentation for easy reference. ? Supported product teams in analyzing integration solutions using Azure artifacts, Logic Apps and Web API, to streamline data flow, aiding in predictive modeling and machine learning initiatives. ? Applied Python for data preprocessing and cleansing, ensuring a 15% increase in data quality for downstream analytical process on a customer experience enhancement project. ? Leveraged Excel for data visualization, reporting, and data-driven decision-making, including segmentation and sentiment analysis, enhancing customer satisfaction, retention, and online shopping experiences.

Education

Bachelor of Technology in Electronics and Instrumentation Engineering

SRM Institute of Science and Technology

2019

Bachelor of Technology in Electronics and Instrumentation Engineering

Master of Science in Business Analytics

University of California

2023

Master of Science in Business Analytics