• Collaborated with stakeholders, SMEs, and end-users to gather and validate requirements, ensuring alignment with business objectives.• Effectively tracked KPIs specific to each channel (e.g., CTR, CPC, CPM, impressions, clicks, client cost, media cost) across diverse industries, driving informed decision-making.• Worked closely with cross-functional teams, ensuring seamless alignment between data analysis and operational strategies.• Analyzed data across various industries, tailoring analytical solutions to meet specific requirements and enhance business outcomes.• Segregated reports by media channels (PPC, social, display, video) and provided in-depth marketing data analysis from ad agencies, improving campaign performance.• Developed comprehensive analytics solutions within Power BI, translating complex business requirements into intuitive dashboard solutions.• Utilized advanced DAX functions to create precise calculations and measures in Power BI, enhancing data accuracy and insights.• Designed and developed SSIS packages, successfully integrating them with Power BI solutions for efficient data processing.• Implemented robust row-level security and other security measures in Power BI, ensuring data integrity and access control.• Created rich visualizations with drill-down options in Power BI, enabling detailed data exploration and insights.• Built interactive dashboards using bookmarks, filters, and drill-through options in Power BI, enhancing user engagement and data analysis.• Tested, cleaned, and standardized data using Power Query Editor, ensuring high data quality and consistency.• Enabled drill-through functionality for detailed data exploration, facilitating deeper insights and analysis.• Executed MSBI platform solutions for ETL and reporting, optimizing data processing and reporting workflows.

• Built and shared reports for various retail industry clients, focusing on key metrics such as sales, inventory levels, customer behavior, and financial performance.• Implemented data governance through row-level security and user filters in Power BI.• Created and extracted Power BI activity logs using Azure Data Factory (ADF) and used triggers to initiate pipeline execution.• Developed Power BI models for financial reporting of P&L and headcount.• Analyzed and reduced errors, such as filtration failures, to improve data accuracy.• Reduced costs and losses by optimizing raw material stocking levels.• Documented Power BI user support guides and trained power users on the self-service capabilities of the tool.• Developed complex SQL statements with business logic for reports in Looker Studio and Power BI.• Created relational models by importing and merging tables from databases.• Designed and deployed rich visualizations with drill-down, drop menu options, and parameters using Power BI and Looker Studio.• Used complex DAX functions to enhance existing projects and modified them based on ad-hoc requirements.• Migrated on-premises SSIS packages to Azure and built interactive dashboards for competitor analysis in Power BI and Looker Studio.• Created interactive views and dashboards in Looker Studio and Power BI, utilizing various chart types including heat maps, pie charts, bar charts, tree maps, trend line charts, and bullet graphs.• Extensively used data and time functions, logical statements, and DAX in Power BI for dynamic requirements.• Integrated Google BigQuery with Looker Studio for enhanced data processing and visualization.• Merged queries, performed joins, aggregations, and created visualizations like scatter plots, combo charts, donut charts, interactive maps, and tables using Power BI and Looker Studio.• Developed new interactive dashboards and modified existing worksheets in Looker Studio, including dual-axis charts and geographical maps.