Subashis Mallick

Data Analyst with 2.5+ years of experience in data analytics, business intelligence, and dashboard development. Skilled in SQL, Python, Power BI, statistical analysis and Advanced Excel to analyze large datasets, build data models, and deliver actionable insights. Proven ability to automate reporting, identify trends, and support data-driven decision-making. Strong experience in KPI tracking, performance analysis, and business problem-solving.

Power BI Developer - Woodrock Infotech

(2026-05 - 2026-06)

• Automated 80% of daily Excel-based reporting workflows, saving 3+ hours of manual effort per day through Power Query and Power BI automation.
• Built 2 core dashboards (Attrition & Shrinkage) tracking 10+ workforce KPIs, enabling teams to monitor daily/weekly performance trends across multiple verticals.
• Analyzed historical performance trends and shrinkage patterns across several business verticals, helping leadership identify performance gaps and align operational decisions proactively.
• Built a workflow and data model from scratch by converting daily Excel dumps into fact/dimension tables and integrating them with Power BI for automated reporting and analytics.

Data Analyst - Globtier Infotech Pvt Ltd

(2024-12 - 2026-04)

Client: Volvo-Eicher Commercial Vehicle (VECV)

• Analyzed dealership performance, lead funnels, pipeline, and retail data using SQL, Excel, and Power BI to identify trends, operational gaps, and conversion drop-offs, including uncovering a 30% decline in the HD segment that supported regional strategy decisions.
• Built automated Power BI dashboards and reporting systems tracking 10+ KPIs, enabling real-time performance monitoring, improving reporting efficiency by 30–40%, and reducing manual effort by 4+ hours daily.
• Delivered data-driven business insights through KPI analysis, trend monitoring, and cross-functional collaboration, helping leadership improve decision-making and optimize performance across the West Bengal region.

Executive - Telemart Shopping Network Pvt Ltd

(2022-11 - 2023-10)

• Analyzed sales and customer data to identify trends, improve conversions, and support business decisions.
• Excel KPI dashboards to track performance, productivity, and growth opportunities.

Bachelor in Computer Applications - Computer Applications - University of Burdwan (2019 - 2022)