S

Srikanta Mondal

Business Analyst

Gurugram, Haryana, India3 yrs 5 mos experience

Key Highlights

  • Expert in SQL and Python for data analysis.
  • Proven track record in building interactive dashboards.
  • Strong background in geospatial analytics and environmental research.
Stackforce AI infers this person is a Data Analyst specializing in Healthcare and Environmental Analytics.

Contact

Skills

Core Skills

Data AnalysisBusiness IntelligenceData VisualizationReport AutomationResearchGeospatial Analytics

Other Skills

SQLPythonPower BIRedashAdvanced ExcelGoogle WorkspaceField SurveysData CollectionStatistical AnalysisTrend AnalysisDocumentationEducational ResearchCommunicationPublic PolicyQuantitative Analytics

About

Data Analyst at Virohan (one of India's largest healthcare-skilling companies), helping operations, academics, and growth teams convert raw data into measurable business decisions. I work daily with SQL, Python, Power BI, Redash, Advanced Excel, and Google Workspace to build dashboards, automate MIS reports, and run analyses that improve student outcomes and operational efficiency. What I bring: • SQL — complex joins, CTEs, window functions for extracting and transforming large operational datasets • Python (Pandas, NumPy) — data cleaning, EDA, statistical analysis, and automation • Power BI & Redash — interactive dashboards, DAX measures, and KPI tracking used by cross-functional stakeholders • Advanced Excel — Pivot Tables, VLOOKUP/XLOOKUP, Power Query, what-if analysis • Business Analysis — requirement gathering, stakeholder management, KPI definition, root-cause analysis • Geospatial Analytics — QGIS, ArcGIS, remote sensing (a bonus skill set for location-intelligence roles) Background: MA Development Studies, IIT Mandi | B.Sc. Geography, Presidency University, Kolkata. Invited IEEE GRSS Inspire Talk speaker (2025). Open to opportunities in Data Analytics, Business Analysis, MIS Reporting, and Business Intelligence. Feel free to reach out via LinkedIn.

Experience

3 yrs 5 mos
Total Experience
--
Average Tenure
--
Current Experience

Virohan

Data Analyst

Jun 2025Present · 1 yr · Gurugram · On-site

  • Data Analyst at Virohan — a leading healthcare-skilling company building India's frontline healthcare workforce. I partner with operations, academics, and growth teams to convert raw data into clear business decisions.
  • Key Responsibilities:
  • Write complex SQL queries (joins, CTEs, window functions) to extract, clean, and analyse data across the student and operations stack
  • Build and maintain interactive dashboards in Power BI and Redash for non-technical stakeholders to track KPIs and spot trends
  • Automate recurring MIS and operational reports using SQL and Python, reducing manual reporting effort and improving turnaround time
  • Use Python (Pandas, NumPy, Matplotlib) and Advanced Excel for statistical analysis, EDA, data wrangling, and ad-hoc investigations
  • Translate business questions from leadership into structured analyses with clear, actionable recommendations
  • Define KPIs, document data pipelines, and improve data quality through standardised cleaning workflows
  • Collaborate across Google Workspace to document findings, share insights, and align cross-functional stakeholders
  • Focus Areas: Business Intelligence, MIS Reporting, Student-Lifecycle Analytics, Operational Reporting, Data Quality, KPI Dashboards.
  • Tools: SQL, Python, Power BI, Redash, Advanced Excel, Google Workspace.
SQLPythonPower BIRedashAdvanced ExcelGoogle Workspace+2

Environmental planning & coordination organisation

Summer Intern

Jun 2024Jul 2024 · 1 mo · Bhopal, Madhya Pradesh, India · On-site

Educational ResearchCommunicationPublic PolicyQuantitative AnalyticsMappingQGIS+1

Indian institute of technology, mandi

Project Intern

Dec 2023Jan 2024 · 1 mo · Mandi, Himachal Pradesh, India · On-site

  • Between December 2023 and January 2024, I had the opportunity to immerse myself in Development Studies, concentrating on the geographical and socio-economic dimensions of district-level flood hazard analysis in Haryana, India.
  • As part of an interdisciplinary research team, I employed the Multi-Criteria Decision Analysis - Analytic Hierarchy Process (MCDA-AHP) approach to evaluate flood hazard indices and develop detailed flood hazard maps. Utilizing data from sources like BHUKOSH - Geological Survey of India, FAO-UNESCO, and Sentinel-2 10m Land Use/Land Cover time-series layers, I created spatial geodatabases for flood conditioning factors.
  • In addition to this analytical work, I conducted comprehensive literature reviews and authored detailed reports. This experience also allowed me to enhance my proficiency in software such as ARCGIS. I am thankful for this enriching internship, which significantly contributed to my learning and professional growth.
MappingAHPArcGISResearch

School of humanities and social sciences, iit mandi

Research Intern

Dec 2023Jan 2024 · 1 mo

  • Conducted district-level flood hazard analysis in Haryana using MCDA-AHP methodology.
  • Processed multi-source geospatial datasets from Sentinel-2, FAO-UNESCO, and BHUKOSH.
  • Generated flood hazard maps and spatial datasets using ArcGIS for risk assessment.
  • Performed spatial analysis and assigned weighted indices to flood conditioning factors.
MCDA-AHPSpatial AnalysisGeospatial DatasetsResearch

Iit mandi

Quantitative Researcher

Dec 2023Jan 2024 · 1 mo

  • Analytical Modeling: Utilized MCDA-AHP and spatial statistical techniques for district-level hazard mapping.
  • Large Dataset Management: Processed diverse geospatial and demographic datasets for institutional research documentation.
Analytical ModelingDataset ManagementResearch

Environmental planning & coordination organization (epco)

Research Intern

Jan 2023Present · 3 yrs 5 mos

  • Conducted field surveys and data collection for research on climate change and air pollution impacts in Bhopal.
  • Analyzed environmental and health datasets using statistical and visualization techniques.
  • Prepared analytical reports submitted to the State Knowledge Management Centre.
  • Contributed research insights supporting evidence-based environmental policy discussions.
Field SurveysData CollectionStatistical AnalysisData VisualizationResearch

Epco (govt. of mp)

Research Intern

Jan 2023Present · 3 yrs 5 mos

  • Trend Analysis: Analyzed environmental impact data to identify long-term variances in air pollution levels.
  • Documentation: Prepared evidence-based analytical reports submitted to the State Knowledge Management Centre.
Trend AnalysisDocumentationResearch

Education

Indian Institute of Technology, Mandi

Master's degree — Development Studies

Aug 2023Jun 2025

Presidency University Kolkata

Undergraduate — Geography

Jan 2019Jan 2022

West Bengal Council of Higher Secondary Education

Higher Secondary — Humanities

Aug 2017May 2019

Indian Institute of Technology, Guwahati

Master of Arts - MA — Development Studies

Jun 2022Dec 2022

West Bengal Board of Secondary Education (WBBSE)

Secondary Education — Humanities and Sciences

May 2015May 2017

West Bengal Board Of Primary Siksha Prashad

High School Diploma

Presidency University, Kolkata

Bachelor of Science — Geography

West Bengal Board Of Primary Siksha Prashad

High School Diploma

Indian Institute of Technology, Mandi

Master of Arts — Development Studies

IIT Mandi

Master of Arts — Dev. Studies

Stackforce found 100+ more professionals with Data Analysis & Business Intelligence

Explore similar profiles based on matching skills and experience

Srikanta Mondal - Business Analyst | Stackforce