Rafeed Karincheri

<ol><li>Contributed to the development of an automated reporting system, ensuring all campaign reports are processed within one week after the attribution window.</li><li>Created and implemented a data-driven sales attribution approach for Digital Out-of-Home (DOOH) campaigns to enhance performance tracking.</li><li> Extracted, transformed, and analyzed large-scale sales datasets using Google Cloud Platform (GCP) and BigQuery for pre-campaign setup and post-campaign performance analysis.</li><li> Developed and optimized advanced SQL queries to create audience segments for effective targeting across offsite, social, and email channels.</li><li> Conducted end-to-end QA on campaign reports and visualized key metrics and insights through Power BI dashboards for clients and internal stakeholders.</li><li> Collaborated with U.S. counterparts and clients to resolve data inconsistencies, validate performance metrics, and maintain the accuracy and timeliness of analytical deliverables.</li></ol>

<ol><li>Creation of 40+ dashboards in Power BI and Looker Studio for ad campaign performance by extracting data from various platforms like Meta Ads, GA4, CM360, SA360, TikTok Ads and Pinterest Ads for clients from different markets.</li><li> Extraction, cleaning, and analysis of datasets using SQL (MySQL).</li><li>Creation and maintenance of pacing reports to track and analyze budget versus spend data using dynamic formulas in Google Sheets.</li><li> Automation of reports and dashboards using API connectors.</li><li> Evaluation and analysis of campaign report and performance report datasets using various Excel formulas and techniques in Microsoft Excel and Google Sheets.</li><li> Analysis of data and creation of reports in the cloud-based business intelligence data warehouse tool Datorama.</li></ol>

<ol><li>Identified KPIs from Salesforce CRM datasets and performed data analysis using SQL in MySQL.</li><li> Created reports using pivot tables and slicers in Excel.</li><li> Created dashboards in Power BI and Tableau.</li></ol>