Data Analyst
• Applied SQL for in-depth data analysis, examining large datasets to identify trends and insights. Leveraged key performance indicators (KPIs) to measure campaign success and marketing performance. Resulted in a 15% increase in customer engagement and a 10% growth in conversion rates through data-driven recommendations• Designed and automated an ETL pipeline to extract campaign data from Meta and Google Ads APIs into PostgreSQL, optimizing storage for analytics and enabling streamlined reporting. Scheduled weekly data processing jobs with Google Cloud Scheduler and created interactive Tableau dashboards to track KPIs, driving a 20% increase in marketing efficiency.• Developed interactive Tableau dashboards to visualize and consolidate data from various sources and web traffic data. Integrated click-through rates (CTR), conversion rates, bounce rates, and engagement metrics into the dashboards, utilizing calculated fields, dynamic parameters, and custom metrics to support social media and web analytics initiatives. Improved report visibility and accessibility, reducing reporting time by 15%, and providing timely insights for stakeholders• Analyzed and extracted key trends from customer feedback and behavioral data using Python for data cleaning, aggregation, and statistical analysis. Used numpy for efficient numerical operations and calculations to identify patterns and correlations. Collaborated with the marketing team to implement improvements, resulting in a 10% increase in customer satisfaction and a 12% boost in retention through data-driven strategies• Identified high-impact campaigns that contributed to a 20% boost in engagement.Improved ROI on ad spend by 10%, reallocating resources effectively to high-performing campaigns.
