“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)

Data Analysis and Insights

Data Analysis and Insights

View Credential
Attention To DetailBusiness Analytics (BA)Career ManagementCritical ThinkingData AnalysisData AnalyticsData IntegrityData InterpretationData ManipulationData MiningData QualityDecision MakingMicrosoft ExcelPredictive AnalyticsRegression AnalysisScenario AnalysisStatistical AnalysisStatistical Hypothesis TestingTime Series AnalysisPWID-B1001500
Introduction to Inferential and Descriptive Statistics

Introduction to Inferential and Descriptive Statistics

View Credential
Attention To DetailCareer ManagementCritical ThinkingData AnalyticsGrowth MindsetMicrosoft ExcelProblem SolvingResearchAnalytical ThinkingCommunicationData SetsDescriptive and Predictive ModelingInferential StatisticsIntroductory StatisticsLearning AgilityPWID-B0839800Statistical SamplesStatistical Significance
Data Preparation for Analysis

Data Preparation for Analysis

View Credential
Career ManagementCritical ThinkingData AnalyticsData TransformationGrowth MindsetMicrosoft ExcelActionable AnalysisCommunicationData PreparationDocumentationPWID-B0840000Subset Analysis
Data Visualization and Presentation

Data Visualization and Presentation

View Credential
Attention To DetailCareer ManagementCritical ThinkingData AnalyticsData StorytellingData VisualizationGrowth MindsetMicrosoft ExcelUser FeedbackAnalytical ThinkingCommunicationDocumentationLearning AgilityPWID-B0840100
Problem Framing and Data Analysis Planning

Problem Framing and Data Analysis Planning

View Credential
Business Analytics (BA)Business Process Modeling (BPM)Career ManagementCreative ThinkingCritical ThinkingData AnalysisData CollectionData ExtractionData ModelingData TypesKey Performance Indicators (KPIs)PlanningProblem SolvingProject ScopingStakeholder IdentificationWritten Communication SkillsPWID-B0998900
Career Essentials in Data Analysis

Career Essentials in Data Analysis

View Credential
Data AnalysisData Visualization
Business Analytics with Excel

Business Analytics with Excel

View Credential
Advance ExcelMacrosData AnalysisSolverStatistics