Sakcham Srivastava

United Colors Of Benetton (UCB) Experience:

( September 2023 till date )

• Independently managed UCB India's CRM account, driving new initiatives for customer engagement and revenue growth. Orchestrated targeted campaigns for product-level and store-focused initiatives, including End of Season Sales and new season launches.
• Led Customer Lifecycle Management (CLM) campaigns, to boost customer loyalty. Employed advanced data analysis techniques to forecast KPIs ensuring ASM and Franchisees were aware of their targets.
• Developed and implemented an effective win-back cum propensity model, increasing customer retention rates and boosting ROI by 25%. Used A/B testing to determine efficient and cost effective communication channels for curated customer segments. Conducted market basket analysis to uncover cross-selling opportunities and enhance the effectiveness of product-led campaigns.
• Spearheaded store leaderboard creation, elevating performance and improving tagging rate and Customer Information capture from 80% to 90% and 30% to 45% respectively. Published monthly newsletters, spotlighting CRM initiatives and outcomes.
• Produced comprehensive management decks, offering insights into business health and CRM metrics for Global Leadership. Conducted root cause analysis of store business metrics, identifying improvement areas and enhancing operational efficiency. Additionally, conducted store cannibalization analysis.
• Leveraged Power BI for data visualization and analysis, and used MySQL for efficient data management. Conducted training sessions on Power BI to enhance team capabilities for data-driven decision-making.
• Conducted NPS survey analysis to gauge customer satisfaction levels and identify areas for improvement. Developed and maintained a dashboard to track NPS score.
• Carried Out points and voucher-related analysis alongside creating dashboards for discounting, CRM Metrics, Incremental Revenue, Campaign Health Trackers like EOSS Trackers etc contributing to strategic decision-making and performance optimization.

KFC India Experience:

( September 2022 to August 2023 )

• Spearheaded CRM initiatives at KFC India, focusing on customer retention strategies and campaign management. Established and maintained a robust Snowflake database, amalgamating POS, App, and 3rd Party Data, using SQL for data management.
• Developed and executed targeted campaigns with AB Testing, Response Analysis, and a propensity model, yielding a 20% increase in incremental revenue. Conducted detailed Customer Behavioral Analysis to identify trends and insights, forming data driven decisions.
• Responded swiftly to a diverse range of ad-hoc requests, demonstrating versatility and agility in addressing stakeholders' needs, providing insights from overall business health to granular store, product, and customer levels. Worked in Menu mix and Combo engineering analysis.
• Created and managed dashboards, including CRM dashboard, Weekly App reports, and Customer Health metrics, facilitating data-driven decision-making and providing actionable insights. Conducted root cause analysis and drove product-level campaigns, contributing to business growth.
• Demonstrated proficiency in data extraction from Snowflake, as well as dashboard creation using Excel and PowerBI.
• Acted as a single point of contact for clients, effectively managing accounts and fostering strong client relationships.

• Worked as an Analyst for US Based MNC client wherein I enabled the client to understand the pain areas of their customers by using Natural language Processing and techniques like Sentiment analysis, N-gram creation and assigning themes on textual data using python
• Ran a Churn Model for the client on their US Data, automating it (working with DevOps Team) thus reducing SLA from 5 days of manual work to 1
• Created 12 Power BI dashboards based on survey data, one of which was referred daily by the CEO.