Usama Khan

Created Sales target for the upcoming months based on past performance using Exponential Smoothing for the demand planning team. Working with the marketing team to understand the effectiveness of a campaign by extracting Data from SQL and creating a summary sheet that monitors the campaigns. Working with the Sales team to segment customers based on different factors using K- mean clustering. It increased sales by 5-10% month-on-month. Automated different processes and created a pipeline in Azure Synapse and store the data in Azure Storage. It helped in reducing daily manual efforts.

Build market mix models (hierarchical mixed effects regression model) to quantify the media execution on sales. It was used to quantify the impact of $100 MM of investment on Media which helps in better decision-making. Lead a team of 3. Added two more features into the model, Ad Stocks and Gamma parameter which help in a more efficient model. Evaluated the model using MAPE and R2. Automated different files which reduces 8-9 hours of manual work with python.

Worked with banking data to find out customer behavior and their segments based on their demographics, income, and product they bought with K-mean clustering that help in customer targeting. Created a dashboard to speed up the process which helps in their customer targeting.

Analyzed and created a logic for zones for different districts using COVID-19 data. Created different logic and worked on the backend for creating a dashboard using Django.

Subjects: Linear Algebra, Statistics, Calculus, SQL, Python. Location: Mumbai, India.