“If an insight doesn’t lead to business action, the visualization shouldn’t exist.”
Suman Das

Suman Das

Assistant Manager – Data Insights

Transforming raw data into actionable business insights. Expert in Advanced Excel, Power Query, Power BI, Looker Studio, SQL, Python(Pandas, Numpy, Matplotlib, Seaborn, Plotly) and MSBI (SSIS, SSAS, SSRS) with a strong background in operations and compliance reporting.

Technical Skills

Languages & Tools

SQL Server, T-SQL, Python (NumPy, Pandas, Matplotlib, Seaborn, Plotly)

BI & Visualization

Power BI, Google Looker Studio, DAX, MSBI (SSIS, SSAS, SSRS)

Data Handling

Advanced Excel, Power Query, M-Code, Google Sheets, Data Warehousing

Core Competencies

Data Cleaning, ETL, KPI Reporting, MIS Reporting, Dashboarding, Data Governance

Work Experience

Mar’2025 – Present

Data Assistant Manager

ICA Edu Skills Pvt. Ltd., Kolkata

Category: Education, Vocational Training

  • Developed automated dashboards and KPI reports using Advanced Excel, Google Sheets, and Looker Studio to monitor performance metrics across 5+ departments.
  • Cleaned and validated 100K+ rows of data for monthly reporting, ensuring data consistency across systems and enabling the generation of actionable business insights.
  • Led cross-functional analytics initiatives, improving reporting efficiency by 40%.
  • Maintained MIS systems and provided data training for internal stakeholders.
  • Complied with data governance policies and ensured data security across all analytics activities.
Nov’2020 – Mar’2025

Quality Associate

SNE Business India Pvt. Ltd., Kolkata

Category: Pharma CFA

  • Built compliance MIS reports using Advanced Excel (Power Query, Power Pivot) for SOP, GSP, GMP, GWP, HSE, and Data Integrity.
  • Analyzed deviations, CAPA, complaints, and recalls using Excel models, pivots, and trend analysis.
  • Monitored equipment maintenance, calibration, and downtime compliance through Excel-based KPI tracking.
  • Developed vendor performance scorecards using Power Query data integration and Excel KPIs.
  • Created training analytics using Power Pivot and DAX in Excel to track completion and effectiveness.
  • Delivered management-ready insights via automated Excel MIS dashboards.
May’2011 – Nov’2020

Sales Support & MIS Executive

SSV Pvt. Ltd., Kolkata

Category: Pharma CFA

  • Manage SAP-based MIS reporting, sales coordination, and SAP billing, including error correction.
  • Maintain and manage stock data in SAP, including transfers and depot distribution.
  • Handle documentation such as credit notes and e-way bills; verify and process data accurately.

Featured Projects (Tap any project image to view details in full screen)

Dynamic Pareto Analysis PowerBI PowerQuery DAX

An end-to-end Pareto (80/20) analysis solution. Features robust data cleaning of messy CSVs using Power Query (M) and a fully dynamic ranking engine using advanced DAX parameters.

Power BIDAXPower QueryPareto AnalysisData CleaningBusiness Intelligence80-20 RuleDynamic Dashboard
View on GitHub

Price Volume Mix Analysis PowerBI

A CFO-grade revenue bridge in Power BI. Decomposes revenue growth into Price, Volume, and Mix effects using advanced DAX. Features auto-narrated insights and strategic risk flags.

Power BIFinancial AnalysisDAXPVM AnalysisRevenue GrowthBusiness IntelligenceCFO DashboardFinance
View on GitHub

Eisenhower Matrix Framework PowerBI

An advanced task prioritization framework in Power BI based on the Eisenhower Matrix. Features dynamic "What-If" thresholds for Urgency/Importance, quadrant-based decision logic, and automated executive narratives using DAX.

Power BIEisenhower MatrixTask PrioritizationDecision SupportDAXBusiness IntelligenceDashboardProductivity Tools
View on GitHub

Dynamic ABC Analysis PowerBI

A production-grade ABC (Pareto) analysis framework in Power BI. Features data cleaning with Power Query (M), modern DAX (WINDOW functions), and dynamic classification thresholds using Field Parameters.

Power BIDAXPower QueryABC AnalysisParetoSupply Chain AnalyticsWindow FunctionsBusiness Intelligence
View on GitHub

5 Whys RCA Framework PowerBI

Enterprise-grade Root Cause Analysis (RCA) dashboard in Power BI. Features dynamic metric switching (Incident Volume vs. Financial Impact), cumulative trend analysis using modern DAX (WINDOW functions), and 5-Whys decomposition trees.

Power BIRoot Cause AnalysisDAXBusiness Intelligence5 WhysIncident ManagementFinancial ImpactDashboard
View on GitHub

HR Dashboard SQL PowerBI

End-to-end HR analytics project. Features data cleaning and transformation of 20 years of HR data (22k records) in SQL Server and dynamic dashboard creation in Power BI to track employee retention, diversity, and turnover.

SQL ServerPower BIHR AnalyticsETL PipelineData CleaningBusiness IntelligenceDashboardPeople AnalyticsTurnover Analysis
View on GitHub

Retail Sales Analysis

End-to-end data engineering and analysis project. Extracts retail data via Kaggle API, performs cleaning/transformation with Pandas, and loads into SQL Server for advanced sales trend analysis.

ETLPythonSQL ServerData EngineeringPandasKaggle APIData AnalysisBusiness Intelligence
View on GitHub

StackOverflow Survey 2024 Python EDA

Exploratory Data Analysis (EDA) of the 2024 Stack Overflow Annual Developer Survey. analyzes responses from 65k+ developers to uncover trends in technology, salaries, and demographics using Python.

PythonData AnalysisEDAStackoverflow SurveyPandasData VisualizationDeveloper InsightsSalary Analysis
View on GitHub

Bank Operations SQL and T-SQL Analysis

End-to-end banking database project using T-SQL. Features ERD modeling, complex data cleaning, transaction validation triggers, and automated financial reporting via stored procedures.

SQL ServerT-SQLDatabase DesignData AnalysisFinancial AnalyticsStored ProceduresTriggersETLData Cleaning
View on GitHub

Credit Card Transactions ETL Pipeline

End-to-end MSBI solution for credit card analytics. Features complex ETL pipelines (SSIS), multi-strategy incremental loading, and SSAS multidimensional cubes for fraud detection and reporting.

MSBIFraud DetectionSSISSSASData WarehouseETL PipelineStar SchemaSQL ServerOLAP Cube
View on GitHub

Bank Operations Project

End-to-end Data Warehousing and Business Intelligence solution for banking operations. Features comprehensive ETL pipelines using SSIS, Star Schema modeling in SQL Server, and OLAP Cube creation with SSAS.

MSBIETLSSISSSASData WarehouseSQL ServerBusiness IntelligenceStar SchemaBanking Analysis
View on GitHub

Certifications (Tap any certificate image to view details in full screen)

Career Essentials in Data Analysis

Career Essentials in Data Analysis

View Credential
Learning Data Analytics Part 2

Learning Data Analytics Part 2

View Credential
Introduction to Career Skills

Introduction to Career Skills in Data Analytics

View Credential
Learning Data Analytics Foundations

Learning Data Analytics: 1 Foundations

View Credential
Business Analysis Basics

Business Analysis Basics

View Credential
Introduction to Data Analytics

Introduction to Data Analytics

View Credential
Introduction to SQL

Introduction to SQL

View Credential
Power BI for Beginners

Power BI for Beginners

View Credential
Business Analytics with Excel

Business Analytics with Excel

View Credential
Excel Dashboard for Beginners

Excel Dashboard for Beginners

View Credential
Introduction to MS Excel

Introduction to MS Excel

View Credential