Kumar Muthusamy

• Total Sales: Track daily, weekly, and monthly sales.
• Sales by Category: Breakdown of sales by product categories
• Top Selling Items: Identify the top-selling products.
• Stock Levels: Monitor current stock levels for each product.
• Stock Turnover: Calculate the rate at which inventory is sold and replaced.
• Reorder Points: Set thresholds for when to reorder products.
• Customer Segmentation: Segment customers based on demographics and purchasing behavior.
• Customer Traffic: Track the number of customers visiting the store
• Store Hours: Analyze sales performance during different store hours.
• Sales Forecasting: Predict future sales based on historical data.

• Collect data from POS systems and feedback forms (both online and offline) to gather comprehensive insights
• Create data visualizations using Tableau to help stakeholders understand sales gaps and identify opportunities for improvement
• Collaborate with kitchen staff to optimize menus based on historical data using sets, set hierarchies, parameters, calculated fields, and filters in Tableau
• Analyze customer segmentation data to identify and target different customer groups with tailored marketing strategies utilizing RFM analysis, clustering, and parameters
• Monitor sales trends to forecast demand and adjust inventory levels using time series analysis and heatmaps
• Evaluate the impact of special events (e.g., game nights) on sales and customer traffic, using predictive analytics to plan future events
• Develop and maintain dashboards to provide real-time insights into key performance indicators
• Perform gap analysis to identify discrepancies between current performance and business goals, proposing data-driven solutions to bridge these gaps
• Conduct A/B testing on menu items, promotions, and marketing campaigns to determine the most effective strategies, incorporating statistical analysis

Project-1 Data Collection and Insights Development (Excel, SQL, Tableau, Power BI)

• Data Collection and Cleaning
• Data Analysis
• Reporting and Visualization
• Predictive Modeling
• Collaboration

Project-2 Customer Insights and Strategy Development (SQL, Tableau)

• Customer Segmentation
• Monitor Sales Trends
• Evaluate Event Impact
• Dashboard Development and Maintenance
• Gap Analysis and A/B Testing

Project-1 Interactive Dashboard Client – Sun King India

• Data Cleansing
• Sales Performance Report
• Inventory Management
• Financial Overview
• Geographical Sales Distribution
• Customer Segmentation
• Monitor Sales Trends
• Evaluate Event Impact

Project-2 Customer Insights and Strategy Development- AFM- USA

• Customer Segmentation
• Monitor Sales Trends
• Evaluate Event Impact

Project-1 Interactive Dashboard - Sales

• Data Cleansing from AS400
• Sales Performance Report Category-wise
• Inventory Management
• Financial Overview
• Geographical Sales Distribution

Project-2 Interactive Dashboard – Product & Marketing

• Competitor Analysis for Gulf Market
• Customer Segmentation
• Monitor Sales Trends vs
• Competitors
• Evaluate Event Impact

• Responsible for sales across ABRL (72 stores) in the Chennai region
• Showed a 200% increase in sales
• Reduced actual outstanding to less than 5% from 25%

Project – Interactive Dashboard - Sales

• Data Cleansing from SAP SD System
• Sales Performance Report Category-wise
• Sales Performance Report Sub-Category-wise
• Sales Performance Report Store-wise
• Sales Performance Report Region-wise
• Inventory Management
• Financial Overview
• Geographical Sales Distribution