Jan 2021 – Dec 2021 · 11 mos · Bangalore Urban, Karnataka, India

• Lead Analyst - IC role
• Delivered Marketing Mix Models for a Japanese cosmetics brand to efficiently plan their media spends across various channels & channel tactics, understand ROI from each media investment, etc.
• Scripts for optimization and best-fit curves for media spends
• Research: Media optimization & Saturation curves, Ad-stock for media spends, Seasonality calculations, etc.

Jan 2018 – Jan 2021 · 3 yrs · Bengaluru Area, India

• Delivery & Growth:
• Lead an offshore team of 5+ members to provide analytical services to one of the largest retail coffee chains in EMEA, primarily catering to loyalty and category (Bev & Food) side of the business
• Implemented best practices to effectively manage client expectations, timelines, prioritize and deliver end-to-end projects and solutions.
• Involved in strategic planning to increase existing client engagement and lookout for new opportunities
• Business Insights & DS:
• Developed automated scripts in Python and scheduled them for specific jobs
• Developed dashboards in Tableau serving critical needs of the business
• Post campaign analysis, Ad-hoc Business Insights & number crunching
• Effective tagging of look-alike customers through clustering
• Member segmentation for enhanced understanding of consumer profiles
• Analysis: Move away from demographics-based consumer profiling to KPIs defined based on their purchase behavior
• Consumer products (Beverage and Food) association analysis
• Understand traction of products among consumers

Apr 2017 – Jan 2018 · 9 mos · Bangalore

• Design and implement best practices for quick and efficient output & representation of data for Business Insights
• Explored and analyzed the consumer behavior pattern based on various demographic characteristics and purchase behavior and delivered actionable insights from a large volume of data to meet short & long-term business goals which also helped in enhanced targeting of the customers.
• Worked with Time series analysis (ARIMA), Decision Trees, and Market Basket analysis for various client requirements.
• Worked on Cost-benefit analysis for a Bi-Monthly targeting exercise along with identifying various key areas of interest for tweaking the existing Model for the same
• Involved various Test vs Control analyses for regular deliverables as per client needs.
• Category impact analysis when a certain section of the same was moved online than just being available in brick and mortar stores
• Worked on formalizing and implementing a Tableau Dashboard that would give a complete overview of the retail sector of interest and provide key insights such as a shift in trends of consumer behavior at a granular level

Sep 2015 – Mar 2017 · 1 yr 6 mos · Bangalore

• Majorly involved in understanding Database structure for the specific needs of the client.
• Writing efficient Teradata SQL codes for easy extraction of data and improving the flow of information gained through each step of the same
• QC the monthly and regular reports for perfect delivery of the same. Finding new ways and areas of QC for certain regular reports and Adhoc.
• Handling Adhoc on regular basis with minimal supervision
• Worked on Linear regression in SAS for developing a model for a bi-monthly targeting campaign.
• Also proposed on improving the old model with a new approach of target selection along with
• identifying key metrics for performance measurement.
• Designed a completely new methodology for control formation for the above.
• Worked on campaign audits & Adhoc and identified key areas for campaign improvement
• of the above said bi-monthly campaign.