• Built a tableau dashboard to monitor and stabilize the sales of restaurants during the Covid-19 pandemic• Created a customer segmentation module using SQL and Tableau which helped the client understand the customer’s purchase behavior and demographics better for targeting (The association rules proposed were highly appreciated by the client)• Created a promotions manager module independently which later got popular as a service among various clients (SQL, R and Tableau; Later shifted to Sisense)• Led a Sales Driver Analysis which helped the client to understand the decline in sales during a period in detail with respect to the store geography, sales decomposition, demographics and epidemic breakouts

• Worked on an email engagement analysis which helped the clients understand the email engagement lifecycle of E-club members for targeting• Worked on a product group-wise customer comparison module to understand the sales driven by E-Club members better for an E-Club conversion campaign (Cash Vs. Guest Customers Vs. E-Club members)• Automated a code for the Total Menu Management team which created a master data set with every possible metric in one place and was visualized in Tableau (A lot of working time was saved through this automation)

• Performed text mining on Business names to categorize the customers into their corresponding industries (R-Text Mining and SQL)• Performed Segmentation and Geo-targeting to increase a product’s customer base (R-Decision Trees)• Worked on a project involving NPS of customers and implemented Sentiment Analysis on the same data set to understand the score better• Built a time series forecast model to predict order flow data better• Scripted an algorithm using call center data to increase the retention rate of customers• Scripted an SQL algorithm to optimize call center operations for a higher conversion rate• Scripted an algorithm in R for mining meaningful information from transaction SMS (Text mining for a banking client)

• Developed an algorithm to generate a list of products that drive price perception among customers• Automated a data procuring process using VBA that helped the clients track down the competitor data without much manual intervention• Scripted an algorithm in SAS to track customer buying patterns using ‘Market Basket analysis’ which helped the client to identify the potential products that contribute majorly towards their sales• Created a dashboard on Tableau to analyze the various types of discounts given to the customer which helped the client to cut down discretionary discounts and thus increase the profit