Soham Samanta profile photo 1 on Tal

Soham Samanta

MIS Analyst | Data Analyst | Proficient in Power BI, Advanced Excel, SQL, Google Suite, Looker Studio & VBA | Data-Driven Insights | Dashboard & Report Automation | Analytical Problem-Solver | Prompt Engineer

Howrah

< 1 year of work experience

Alteus Group of Companies
Jan 20266 mosPresent

Kolkata

MIS Analyst | Pharmaceutical Data Operations Expert in transforming raw ERP and field marketing data into actionable business intelligence. Specialized in complex data modeling, master data management (MDM), and automated reporting to drive sales and marketing efficiency. Core Responsibilities & Achievements Data Architecture & ERP Management ERP Data Optimization: Extract and process large-scale datasets from CBO ERP, utilizing advanced Excel functions and pivot tables to transform raw output into structured, presentation-ready reports. Automated Reporting: Streamlined the data synthesis process by developing standardized templates, reducing the turnaround time for weekly performance reviews. Marketing Intelligence & Insights Deep-Dive Analysis: Perform granular analysis of field marketing data, filtering key variables to extract insights on market trends, representative performance, and product penetration. Data Visualization: Translate complex raw data into executive-level summaries, highlighting critical KPIs that inform marketing strategy and budget allocation. Data Consolidation & Reconciliation Multi-Source Compilation: Manage the end-to-end reconciliation of marketing MIS counts, merging disparate raw data streams into unified analytical models using complex formulas and multi-layered pivot tables. Master Data Integration: Ensure 100% data integrity by mapping and connecting processed transactional data with the Company Master Sheet, maintaining a "Single Source of Truth" for the organization. ERP Systems: CBO ERP (Data Extraction & Management). Data Analysis: Advanced Excel (VLOOKUP, Pivot Tables, Data Cleaning etc). Reporting: Insight Extraction, Trend Analysis, Executive Dashboards. Process: Master Data Mapping, Data Reconciliation, File Automation.

Education

ICA Edu Skills

ICA Edu Skills

Calcutta University, Kolkata

Bachelor of Science

Calcutta University, Kolkata

20213 yrs2024

Join Soham and 10k+ other professionals on

Tal Boss

Tal is the app where bosses meet engineers & builders directly, without middlemen

Download Tal Boss

Soham Samanta on Tal

Headline

MIS Analyst | Data Analyst | Proficient in Power BI, Advanced Excel, SQL, Google Suite, Looker Studio & VBA | Data-Driven Insights | Dashboard & Report Automation | Analytical Problem-Solver | Prompt Engineer

About

Enthusiastic and detail-oriented MIS Executive with a strong foundation in data analysis, data visualization, and data- driven decision-making. Proficient in tools like Advance Excel, Power Bi, Looker Studio, Google Suite, SQL, VBA. Skilled in interpreting complex data sets to uncover insights and trends. Completed hands-on academic projects involving data cleaning, EDA, and predictive modeling. Eager to contribute analytical skills to a dynamic organization and support data- informed business strategies.

Location

Howrah

Work experience

Data Analyst at Alteus Group of Companies, Jan 2026 - Present · 6 mos, Kolkata, MIS Analyst | Pharmaceutical Data Operations Expert in transforming raw ERP and field marketing data into actionable business intelligence. Specialized in complex data modeling, master data management (MDM), and automated reporting to drive sales and marketing efficiency. Core Responsibilities & Achievements Data Architecture & ERP Management ERP Data Optimization: Extract and process large-scale datasets from CBO ERP, utilizing advanced Excel functions and pivot tables to transform raw output into structured, presentation-ready reports. Automated Reporting: Streamlined the data synthesis process by developing standardized templates, reducing the turnaround time for weekly performance reviews. Marketing Intelligence & Insights Deep-Dive Analysis: Perform granular analysis of field marketing data, filtering key variables to extract insights on market trends, representative performance, and product penetration. Data Visualization: Translate complex raw data into executive-level summaries, highlighting critical KPIs that inform marketing strategy and budget allocation. Data Consolidation & Reconciliation Multi-Source Compilation: Manage the end-to-end reconciliation of marketing MIS counts, merging disparate raw data streams into unified analytical models using complex formulas and multi-layered pivot tables. Master Data Integration: Ensure 100% data integrity by mapping and connecting processed transactional data with the Company Master Sheet, maintaining a "Single Source of Truth" for the organization. ERP Systems: CBO ERP (Data Extraction & Management). Data Analysis: Advanced Excel (VLOOKUP, Pivot Tables, Data Cleaning etc). Reporting: Insight Extraction, Trend Analysis, Executive Dashboards. Process: Master Data Mapping, Data Reconciliation, File Automation.

Education

ICA Edu Skills

Bachelor of Science, Calcutta University, Kolkata

Soham Samanta - Data Analyst in Howrah | Tal