• Conducted in-depth website analysis of target and competitor companies through SimilarWeb, extracting key metrics for digital marketing strategies. Presented findings through engaging PowerPoint presentations to facilitate data-driven decisions.• Analyzing sentiment analysis, tracking brand sentiment and online conversations of target and peers companies through tools like Netbase Quid, Linkfluence.• Maintain data consistency and improved data quality using Alteryx.

• Data extraction from various data sources (digital video and display), filtering and cleaning of data using Alteryx,Microsoft Excel.• Extensively used MS Excel (VLOOKUP’S, Pivots table) to analyze, clean and transform the data.• Worked on building and managing Data Lake on Alteryx for various accounts by merging, cleaning and harmonizing the data extracted and acquired from various data sources (DCM, Twitter, Tiktok, Innovid, linkedIn,etc).• Designed KPI’s to monitor business operations and projected them through automated dashboards using Google Data Studio.• Defining new process improvement opportunities and automation of workflows in tools like Alteryx to save data processing time.