Parag Chakraborty

Experience

1. Business Analyst, Ads

   Amazon

   Jan 2022 — Present · Manhattan, NY, US

   Developed and executed Redshift SQL queries to identify and target specific audiences from 22 marketplaces worldwide for email and UI campaigns aimed at multiple Amazon advertising solutions, encompassing an average monthly audience of 3 million customers with an average of 8 million monthly deliveries. Conducted thorough analysis of email campaign performance, identifying areas for improvement and recommending strategic changes to enhance engagement, click-through rate (CTR), and conversion-to-click rate (CTOR) Collaborated with Marketing Managers (MM) to fulfill ad hoc analysis requests and support effective audience-building initiatives using SQL, and audit live email campaigns to maintain content relevancy, data accuracy, and optimal audience size, resulting in an improved customer satisfaction score of >70%. Developed and maintained interactive Quicksight/Tableau dashboards tracking the performance of 115 recurring email campaigns, capturing essential metrics including CTR, open rates, and delivery rates, strategically empowering 50+ Marketing Managers for data-driven business decision-making and business strategy development. Contributed as a member of the Bar Raising Panel, offering SQL/ETL expertise and assistance to Marketing Managers responsible for marketing campaigns with large audiences unique customers) and low customer satisfaction scores (CSAT<50%), resulting in improved campaign performance and enhanced customer experience. Collaborated with product/program managers from various Amazon ad solutions to collect, integrate, and optimize data from diverse sources, facilitating the seamless onboarding of data for immediate utilization in email and UI campaigns through robust ETL pipelines Assisted Marketing Managers set up A/B testing to measure the effectiveness of different messaging and design variations by equally dividing the audience into holdout/control/treatment groups using SQL leading to improved customer engagement and response rates

Education

• University of Mumbai

  Bachelor of Engineering - BE

  2013 — 2017

• Northeastern University

  Master of Science - MS

  2018 — 2020