Somnath A

• Gather and analyze client requirements to design customized dashboards using Google Looker.
• Extract and retrieve data from databases based on business needs and reporting objectives.
• Perform data cleaning and preprocessing, removing inconsistencies and unnecessary data for accurate reporting.
• Develop interactive and visually appealing dashboards and reports to provide actionable insights.
• Implement data transformations and calculations to enhance dashboard functionality and performance.
• Ensure data accuracy and consistency by validating and testing dashboard outputs.
• Collaborate with stakeholders and teams to understand business goals and improve reporting solutions.
• Optimize dashboard performance for efficient data visualization and user experience.

Project: Coca-Cola Brand Performance Dashboard

Tools: Google Looker, BigQuery

• Developed an interactive dashboard to monitor Coca-Cola brand performance across different categories and retailers.
• Collected and cleaned product data from BigQuery to ensure accuracy and consistency.
• Designed key KPIs with set thresholds to track overall sales, revenue, sponsor sales, product availability, stock levels, search visibility, product images, and descriptions.
• Implemented KPI targets to assess performance and identify areas not meeting required benchmarks.
• Conducted Root Cause Analysis (RCA) to diagnose score drops and recommended corrective actions to improve results.
• Provided data-driven insights to help optimize product placement, marketing strategies, and inventory management.
• Delivered a customized, real-time solution, empowering the client to make informed decisions and enhance brand performance.

• Perform data extraction and cleansing from Excel sheets to uncover valuable insights.
• Collaborate effectively with customers to provide support for operational and reporting tasks across different levels.
• Develop interactive dashboards, reports, and data visualizations using Power BI and Tableau Desktop.
• Demonstrate proficiency in Excel and Power BI reporting for data analysis and visualization.
• Showcase strong organizational skills through project and team management.
• Effectively present complex data in a clear and understandable manner.
• Provide valuable insights and recommendations to stakeholders through visually appealing data visualizations and dashboards. Collaborate closely with business stakeholders to gather requirements, understand data needs, and define visualization specifications.
• Improved project management efficiency by enabling real-time monitoring of project statuses and resource allocation.

• Developed and maintained an interactive Regional Executive Dashboard for profit analysis using Power BI and SQL.
• Extracted, transformed, and integrated data from multiple sources for accurate and real-time reporting.
• Conducted profit analysis by identifying top 10 and bottom 10 cities, enabling data-driven decision-making.
• Designed product profitability visualizations to assist in pricing, inventory management, and strategic planning.
• Analyzed customer data to differentiate new vs. existing customers, supporting targeted marketing efforts.
• Performed yearly segment analysis to track customer trends and optimize resource allocation.
• Implemented key performance indicators (KPIs) such as total sales, quantity, profit, and customer count for quick business assessments.
• Ensured region-based filtering for dynamic insights, improving business growth and profitability strategies.
• Collaborated with stakeholders to understand business requirements and deliver actionable insights.
• Optimized dashboard performance and data refresh processes for seamless user experience.