Kiran Salve โ Business Analyst
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
Stackforce AI infers this person is a Data Analyst specializing in Sales and Marketing Analytics within the Manufacturing and Healthcare industries.
Location: Mumbai, Maharashtra, India
Experience: 8 yrs 1 mo
Skills
- Data Analysis
- Power Bi
Career 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
Work Experience
CMTPL India Ltd
Data Analyst (3 yrs 3 mos)
MRK Healthcare
Data Analyst (4 yrs 10 mos)
Education
Bsc at Birla College of Arts Science & Commerce Birla College Road Kalyan Dist Thane 421 304
HSC at L. D. Sonawane College
SSC at Subhedar Wada High School