Kiran Salve

Business Analyst

Mumbai, Maharashtra, India8 yrs 1 mo experience
Highly Stable

Key Highlights

  • 7+ years in Sales and Marketing Analytics
  • Expert in Power BI and SQL for data-driven insights
  • Proven track record in optimizing business processes
Stackforce AI infers this person is a Data Analyst specializing in Sales and Marketing Analytics within the Manufacturing and Healthcare industries.

Contact

Skills

Core Skills

Data AnalysisPower Bi

Other Skills

SQLLogistics OptimizationDemand ForecastingData VisualizationData AutomationForecastingMarketing AnalyticsExcelPricing Model DevelopmentCompetitor AnalysisPricing StrategyMarket Analysis

About

Hello, I am a Data Analyst with 7+ years of experience in Sales and Marketing Analytics within the manufacturing industry. My goal as a Data Analyst is to help businesses turn raw data into actionable insights that support better decision-making. I specialize in data cleaning, data analysis, data visualization, dashboard development, and business intelligence. ๐ŸŽฏ Key Responsibilities Collect, organize, and manage data from multiple sources including databases, spreadsheets, and APIs Perform data cleaning, validation, and preprocessing to ensure accuracy, consistency, and reliability Analyze large datasets using SQL, Excel, and Python to identify trends, patterns, and actionable business insights Collaborate with cross-functional teams (Sales, Marketing, Operations, and IT) to define data requirements and KPIs Assist in building efficient ETL workflows and automated data pipelines Build and maintain data warehouses and reporting solutions Develop interactive dashboards and ad-hoc reports using Power BI Contribute to data governance, documentation, and process improvements ๐Ÿ›  Skills SQL : Joins, aggregations, stored procedures, functions, CTE, Views, Sub Query Advance Excel : Pivot table, Reports, Vlookup, Xlookup, Sumifs, Conditional Formatting, Text Manipulation, Data Validation Power BI - DAX, Power Query, M Language, Dashboard, Data Modeling, Data Visualization Python (Pandas, NumPy, Matplotlib, Seaborn) โ€” Data cleaning & automation, Regression Other - SAP Hana, Microsoft Navision, SQL Server, MySQL Workbench, Azure Cloud, Jira, Git Soft Skills : Requirement gathering & stakeholder communication, Report automation & workflow documentation, Time management and priority planning ๐Ÿ† Key Achievements Built a Power BI sales performance dashboard tracking monthly sales, collections, and targets across 8 divisions and 300+ salespersons, reducing manual reporting time by 2 hours daily and improving leadership visibility Developed product-wise profitability reports for 800+ SKUs, identified 4% profit leakage, and proposed pricing strategies that improved margins by 3% and reduced low-margin product mix worth โ‚น30 Lakhs Analyzed multi-channel marketing campaign data using SQL and Python, built automated Power BI dashboards, and optimized budget allocation worth โ‚น20 Lakhs Developed a demand forecasting solution using historical trends, seasonality analysis, and moving averages, improving forecast accuracy by 15% and reducing overstocking worth โ‚น45 Lakhs

Experience

8 yrs 1 mo
Total Experience
4 yrs 9 mos
Average Tenure
3 yrs 3 mos
Current Experience

Cmtpl india ltd

Data Analyst

Jan 2023 โ€“ Present ยท 3 yrs 3 mos ยท Mumbai, Maharashtra, India ยท On-site

  • Designed an interactive Power BI dashboard to track sales vs targets,
  • product-wise performance, and growth trends, improving real-time
  • decision-making for senior management.
  • Conducted Freight Analysis, identifying cost-saving opportunities,
  • optimizing logistics efficiency, and improving transportation
  • budgeting through data-driven insights.
  • Designed and automated Incentive & Expense Tracking dashboards
  • ensuring accurate calculations, budget control, and transparent
  • reporting for financial decision-making.
  • Developed demand forecasting model, minimizing stockouts,
  • improving accuracy in inventory planning by 30% , optimize resource
  • allocation and revenue projections
  • Analyse Product basket for marketing team leveraging sales trends,
  • customer preferences, and purchase behavior to enhance crossselling and upselling strategies and enhancing customer retention.
Power BIData AnalysisSQLLogistics OptimizationDemand Forecasting

Mrk healthcare

Data Analyst

Feb 2018 โ€“ Dec 2022 ยท 4 yrs 10 mos ยท Mumbai, Maharashtra, India ยท On-site

  • Converted 20+ Excel reports to Power BI, integrating data from MS Navision, reducing reporting time and improving report accuracy, Enabled management to monitor real-time sales performance.
  • Developed a Pricing Model analyzing market trends, competitor pricing, and cost factors to optimize pricing strategies and maximize profitability.
  • Conducted Competitor Analysis benchmarking market trends, pricing strategies, and sales performance to enhance competitive positioning and decision-making.
  • Analyzed Marketing ROI using Power BI, SQL, and Excel, measuring campaign performance, customer acquisition costs, and revenue impact to optimize marketing spend and improve profitability
Power BISQLExcelPricing Model DevelopmentCompetitor AnalysisData Analysis

Education

Birla College of Arts Science & Commerce Birla College Road Kalyan Dist Thane 421 304

Bsc โ€” Physics

Jan 2013 โ€“ Jan 2015

L. D. Sonawane College

HSC โ€” Information Technology

May 2011 โ€“ May 2012

Subhedar Wada High School

SSC โ€” Marathi

Apr 2001 โ€“ Apr 2010

Stackforce found 100+ more professionals with Data Analysis & Power Bi

Explore similar profiles based on matching skills and experience