As a part of Marketing analytics team supporting a large retail chain in US, I work on end-to-end campaign set up and measurement process. This work has three parts:1. Finding the right customers to whom we need to send mailers, emails or offers for various campaigns using their past transaction trends. The projects help the marketing team to send more customer centric offers.Techniques and tools Logistic Regression; Python and Hive.2. Post-campaign tracking and calculating performance of the campaigns by performing pre-post testing.Techniques and tools K-means; AB Testing; Python and Hive3. Creating weekly and monthly comprehensive reporting solutions that provides product hierarchy level sales and penetration data along with campaign level performance data; it helps marketing team leads to take more informed decision on proposing new campaigns.Tools: Hive and Excel

Ad hoc analysis and reporting for small scale retail chains• Handled multiple requests with very short Turn-Around-Time• Implemented short statistical data analysis and provided insights to end-users• Creation of monthly report for analyzing products based on their hierarchies• Automated existing reports to minimize manual interventionTools: Hive and Excel