Siva Kumar

Data Analyst with 5 years of experience leading teams of analysts while designing, maintaining, and refactoring scalable ETL, dimensional data marts and business intelligence systems. Delivering reliable analytics solutions and production workflows for Google, E-commerce, Supply chain, inventory planning and operations. Skilled in data extraction, transformation, analysis, and reporting with expertise in SQL, Power BI, Excel, Looker Studio, and Google Sheets, delivering actionable insights through automated reports and interactive dashboards.

Strong background in data analysis, report automation, data validation, business performance monitoring, and stakeholder collaboration, delivering accurate insights through SQL, Power BI, Excel, Looker Studio, and Google Sheets.

Data Analyst - Flipkart (Futurz staffing solutions)

(2023-10 - 2026-08)

• Led centralized inventory planning initiatives by analyzing stock availability, demand trends, and inventory health across multiple warehouses, improving operational efficiency by 15%.
• Developed and maintained interactive Power BI dashboards and automated reports to monitor key KPIs, improving KPI tracking efficiency by 20%.
• Leveraged SQL to extract, transform, validate, and analyze large-scale inventory and sales data, saving 5 hours per week in data processing time.
• Performed MSKU-level inventory analysis using historical sales trends and consumption patterns to optimize replenishment planning, improving inventory utilization by 15%.
• Drove actionable insights through deep analysis of slow-moving and non-moving inventory, helping stakeholders reduce excess stock by 10% and improve working capital efficiency.
• Delivered business intelligence reporting across Brand, Vertical, Super Category, and Warehouse levels, tracking 10 operational KPIs to improve inventory performance visibility by 15%.
• Partnered with Planning, Operations, and Category teams to translate business requirements into 10 analytical solutions, dashboards, and executive-level reports.
• Automated recurring MIS and inventory reports using SQL, Power BI, Excel, and Google Sheets, improving reporting accuracy and reducing manual effort by 30%.

MIS Analyst (Medical Insurance) - Qenit Solutions

(2021-09 - 2023-10)

• Developed MIS reports and interactive dashboards using Advanced Excel for business performance tracking.
• Extracted and analyzed data from SQL Server and Excel to generate actionable insights and management reports.
• Created MTD, YTD, Primary, and Secondary Sales Reports to support business decision-making.
• Designed Campaign, Digital Marketing, and Market Summary dashboards using Pivot Tables, Slicers, and Advanced Excel formulas.
• Automated reporting processes and ensured data accuracy through validation and quality checks.
• Environment: Advanced Excel, SQL Server, Pivot Tables, Slicers, Dashboards, MIS Reporting.

Master of Business Administration - MITS Madanapalli, (Jawaharlal Nehru Technological University, Anantapur) (2018-08 - 2020-09)

Bachelor - Computer Science - Loyola Degree College (2014-08 - 2017-05)