Business Intelligence Senior Analyst

Pooja Bhanage

206-***-**** *****.***@*****.*** linkedin.com/in/pooja-bhanage

EDUCATION

Southern Methodist University, Cox School of Business Dallas, Texas, USA Master of Science in Business Analytics May 2021

GPA: 3.61/4.0

Coursework: Predictive Analytics, Data Visualization, Business Intelligence MICA Ahmedabad, India

Post Graduate Diploma in Marketing Communications (MBA Marketing and Market Research) Mar 2015 GPA: 3.04/4.0

University of Mumbai Mumbai, India

Bachelor in Computer Engineering May 2012

First Class

TECHNICAL SKILLS

• SQL • Alteryx • Tableau • R • Python • PowerBi • SSMS • MS Excel • MS PowerPoint PROFESSIONAL EXPERIENCE

Merkle Inc. USA

Senior Analyst, Customer Analytics Mar 2022 – Jul 2023

• Recommend future direction for upcoming marketing activities and help strategize basis past campaign response data

• Develop reports by extracting data using SQL and visualizing it in Tableau as per business needs and strategies

• Optimize Pyhton model timely to identify webpages where relevant campaigns can be launched to right target Prime Source Buildings (Internship) USA

Capstone Project: To understand Customer Buying Cycle Jan-Apr 2021

• Identify core target customers and low hanging fruits for Sales team by analyzing 3 years sales data using Alteryx, Tableau, Python etc. to also predict which Direct customers can be targeted with which specific products at what regular intervals. Kantar (Worldpanel Division) Dubai, UAE

Client Service Manager May 2016- Oct 2019

• Grew portfolio 4 times with a Personal Care client for Saudi Arabia and United Arab Emirates in two years.

• Build marketing insights from shopper data and KPIs of two countries for marketing and trade teams to develop category understanding and portfolio optimization strategies.

• Recommend profitable actions utilizing advanced tools like Shopper Decision trees, Shopper Missions, heavily dependent on Clustering and Multivariate Analysis, Regression etc.

• Proactively created models, devised new metrics to explain shopper behavior like switching, promo elasticity etc. and published insights to discuss optimal market strategies, dynamic consumer behavior and marketer’s dilemma: o ‘Adapting to the Changing Saudi Shopper’, discussing strategies to adopt manufacturers or retailers as per new market norms, 2018-19 (Link: https://www.kantarworldpanel.com/global/news/Adapting-to-the-changing-Saudi-shopper) o ‘Who is the Winner’, an analytical piece published on website and in newsletter to establish impact of promotions, 2018

(Link: https://www.kantarworldpanel.com/global/News/Promotions-in-Saudi-ArabiaHow-to-avoid-a-zero-sumgame)

• Secured 30% above the annual target by leading commercial conversations with local and global FMCG players (PepsiCo, P&G, Fonterra) as well as retailers (Panda) by winning ad-hoc projects along with growing subscriptions.

• Worked with P&G Europanel as a senior data insights analyst for additional regions - India, Germany and UK.

• Mentoring juniors, working with free-lancers and collaborating with global counterparts on mega projects. Accomplishments:

• Represented Middle East region for a global account meeting to discuss annual plan, Apr 2019

• ‘Best Client Servicing Team’, an Annual Award within Kantar Worldpanel, Jan 2018

• ‘Inspiring Successful Decisions’, a Global Award for best actionable presentation, 2018

• ‘Gold’, Award for best Client Delight presentation across Kantar brands in UAE, 2017

• Client Delight Award based on gauging impact of Sugar Tax, 2016 Prologix LLC Dubai, UAE

Marketing Executive Jul 2015– Mar 2016

• Grew business by $10k through 360º activities like technical exhibitions, Group Workshops, Email marketing etc. Maersk Line (Internship) Mumbai, India

Marketing & Communications Intern May - Jun 2014

• Vendor Management, Creative Briefing and Secondary research to elevate African Trade relations with Indian customers with planning for Annual Trade Event ‘African Night’ Parle Biscuits and Co. Ltd (Internship) Mumbai, India Marketing Intern Apr - May 2014

• On ground research study with real time consumer interviews and retailer surveys aimed to understand Parle Kreams vs competition

PROJECTS & CO-CURRICULAR ACHIEVEMENTS

• ‘Did Covid help Alcohol industry’, a data visualization project with storyboarding using Tableau, Aug-Oct 2020 o https://docs.google.com/document/d/e/2PACX-

1vQtdsC9lzFugdnHQd58Zk_wspCjAnZ8X7ukSL8g39OqBUZ2LSdqATpWCKMjOJs0sbCthBvh-B7GzMh/pub

• Dissertation, ‘Knowledge Management and Innovation: Understanding Relation Between the Two’, MICA, 2014-15

• Led a Website redesign project for Market Research Society of India, MICA, Jan-Mar 2014

• Tutored ~150 students in Advanced Mathematics and Logical Ability for Co-curricular exams, 2010-13 EXTRA CURRICULAR ACTIVITIES

• Volunteer Teacher, teaching Marathi to kids, Seattle Online Marathi Shala and Sanskar Varg, Seattle USA, 2022

• Trained students who achieved First Class Grades till Level 3 Kathak exam by Gandharva Mahavidyalay, Dubai, 2016-19

• Co-Editor, ‘Dance Trail’, a book in English explaining theoretical concepts of Kathak used as Textbook, 2015

• Conferred ‘Kathak Visharad’ (Bachelors in Kathak), Akhil Bhartiya Gandharva Mahavidyalay, 2012

Contact this candidate