Summary
Overview
Work History
Education
Skills
Projects
Accomplishments
AWARDS&APPRECIATION
Gardening, Painting
Languages
Certification
Timeline
Generic
SUBHASIS KAR

SUBHASIS KAR

Kolkata

Summary

Dynamic Data Analyst and Team Lead at Comcast Cable Communication plc., skilled in SQL and data visualization. Achieved a 20% improvement in data-driven decision-making through innovative Power BI/Tableau dashboards. Adept at team management and fostering collaboration, leveraging advanced analytics to drive impactful business insights. Logical data analyst skilled in requirement analysis, software development and database management. Self-directed and proactive professional with several years of vast experience collecting, cleaning and interpreting data sets. Natural problem-solver possessing strong cross-functional understanding of information technology and business processes.

Overview

10
10
years of professional experience
1
1
Certification

Work History

Data Analyst & Team Lead

Comcast Cable Communication plc.
05.2025 - Current
  • BI Development & KPI Tracking: Designed, developed, and deployed enterprise-level Power BI & Tableau both dashboards, writing complex DAX Measures and Calculated Columns building new semantic models and data pipeline to track critical business KPIs such as product activation rates, sales efficacy, Order Trends, Fallout Trends and customer usage patterns. This directly improved data-driven decision-making by 20%.
  • Advanced SQL & Data Modeling: Authored and optimized complex SQL queries to extract, transform, and load (ETL) data from diverse sources, building scalable and efficient data models to support sales and product analysis.
  • Engineered and automated data ingestion pipelines from Databricks using PySpark, transforming and cleansing telecom order and product usage data for BI reporting models.
  • Created interactive visualizations in Tableau and Power BI, tailoring reports to stakeholder needs and providing insights into sales performance and product adoption trends.
  • Managed team workflows and sprint planning as JIRA board administrator, led daily stand-ups and tracked velocity.
  • DevOps & AI Integration: Participated in CI/CD processes for the automated testing and deployment of BI reports, ensuring data integrity and solution stability. Leveraged AI tools and Power BI's built-in AI visuals to enhance predictive analytics on customer behavior.

Data Engineering Specialist

Corporate Finance Unit - British Telecommunications plc.
05.2024 - 04.2025
  • Enhanced data-driven decision-making as a data engineer through innovative solutions.
  • Performed data validation, cleansing, and visualization using BI tools like Power BI and VLOOKUP for effective data retrieval.
  • Collaborated on reconciliation with Corporate Performance Management ETL team (Anaplan), implementing data validation methods and quality tools to maintain data integrity.
  • Collaborated with CAs to reconcile reports by analyzing financial data from the Global Finance Portal (GFP).

Data Engineer – Enterprise Data Warehouse (EDW)

Enterprise BnPS -British Telecommunications plc.
09.2021 - 04.2024
  • Designing data models, implementing ETL processes, optimizing database performance, and ensuring data quality and security.
  • Analyzed application issues to provide support, developed ETL processes for data warehouse using PL/SQL in Oracle.
  • Optimizing database performance, troubleshooting data warehouse issues, and ensuring efficient data retrieval and processing.
  • Collaborated with business and data analysts to gather requirements and deliver data warehouse solutions aligned with business needs.
  • Developing and maintaining documentation for data warehouse processes and architecture.
  • Developed and maintained reports and dashboards using Power BI to effectively communicate insights to stakeholders.
  • Gained knowledge of cloud infrastructure platforms such as GCP and AWS.

PL/SQL Developer

Openreach Ltd.-British Telecommunications plc.
02.2020 - 08.2021
  • Designed, developed, and maintained Oracle database applications for Openreach Telecommunication project owned by British Telecom using PL/SQL programming language.
  • Reviewed code for bugs, performance bottlenecks, and compliance with coding standards; tested PL/SQL code for correct and efficient functionality.
  • Maintained JIRA for Agile methodology and facilitated deployment to Production Server via Jenkins Pipeline.
  • Updated Git-Lab tools with new code commissions.

Support Analyst

Kroll Associates, Inc.
08.2017 - 01.2020
  • Provided technical support to clients using Kroll’s software solutions.
  • Maintained process documentation and contributed to Knowledge Base (KB), streamlining incident resolution time.
  • Assisted in troubleshooting issues across various systems and applications.
  • Collaborated with team members to resolve client inquiries efficiently.
  • Analyzed problems in the information security project for Kroll Associates, Inc., focusing on data handling in MS SQL and MS Excel.

Analyst for Communications Media & Information Services

Newspaper Publishing(TRONC)
03.2016 - 07.2017
  • Analyzed application issues for newspaper publishing project owned by TRONC, gaining understanding of NEWSGATE workflow and processing of feeds (news, photos, reports) for publication.
  • Executed Unix-based troubleshooting tasks, including log analysis, file transfers, service restarts during patching, and conducting system health checks.
  • Analyzed audience engagement data to inform content strategy for publications.
  • Collaborated with editorial teams to enhance storytelling through data insights.
  • Conducted market research to identify trends in journalism and reader preferences.

Education

B.Tech - Mechanical Engineering

NIT Durgapur
Durgapur
06-2015

MBA -

INDIAN INSTITUTE OF MANAGEMENT KOZHIKODE
KOZHIKODE
03-2026

Skills

  • Data analysis
  • Data visualization
  • Data validation
  • Statistical analysis
  • SQL
  • PL/SQL
  • ORACLE SQL DEVELOPER
  • POWER BI
  • Tableau
  • DATABRICKS
  • PYSPARK
  • PYTHON

Projects

Comparative Analysis of Consumer Behavior & Experience in Coffee Retail Chains:

MBA EPGP (Dec 2025 - Dec 2027)

  • Research Problem & Objectives:
    Identified the primary drivers of customer churn and loyalty in the competitive Indian coffee retail market, specifically comparing global chains (e.g., Starbucks) versus local artisan shops.
    Investigated how service attributes—such as digital ordering efficacy, ambiance, and price sensitivity—impact the overall Customer Experience (CX) index.
  • Methodology & Primary Data Collection:
    Designed a structured Sampling Questionnaire targeting diverse consumer segments to ensure high data sufficiency for statistical validity.
    Deployed a Digital Survey to capture raw data from a targeted sample, focusing on high-frequency coffee consumers.
  • Demographic & Behavioral Analysis:
    Segmented data by Demographic Variables (Age, Occupation, Income Level) to identify distinct spending patterns and visit frequencies.
    Analyzed Behavioral Psychographics, such as the correlation between "Remote Work Culture" and "Time Spent per Visit" using Correlation Analysis.
  • Statistical Analysis & Feature Efficacy:
    Performed Exploratory Data Analysis (EDA) to identify outliers and data trends within the consumer response set.
    Applied Statistical Inference to test hypotheses regarding "Feature Efficacy," such as whether mobile-app loyalty programs significantly increase the Net Promoter Score (NPS) across different age groups.
  • Managerial Insights & Recommendations:
    Synthesized complex data into Managerial Insights, recommending that local artisan shops focus on "Personalized Experience" features to compete with the "Digital Efficiency" features of global chains.
    Presented an Economical Analysis of pricing strategies, suggesting dynamic bundles to capture the price-sensitive student demographic without diluting brand value for premium customers.

Accomplishments

  • Improved relationship with Comcast by developing a unique business intelligence solution as project IGNITE to meet complex requirements of analyzing new product behaviors of consumers.
  • Supervised team of 6 staff members.

AWARDS&APPRECIATION

  • Special Initiative Team Award,
  • Applause for Team Award,
  • Learningseason5-Program-Technical-ILT/Virtual ILT,
  • AI Spark,
  • tcs^AI Idea Ignitor

Gardening, Painting

I find joy in nurturing life through gardening, where I cultivate vibrant flowers, herbs, and vegetables in my backyard oasis—transforming soil into a symphony of colors and scents that soothe the soul. Complementing this, painting allows me to capture those fleeting moments of beauty on canvas, blending bold strokes of acrylics and watercolors to express emotions and stories that words can't convey. These hobbies recharge my creativity, teach patience, and connect me to nature's endless inspiration.

Languages

  • English
  • Hindi
  • Bengali

Certification

Salesforce Administration

Timeline

Data Analyst & Team Lead

Comcast Cable Communication plc.
05.2025 - Current

Data Engineering Specialist

Corporate Finance Unit - British Telecommunications plc.
05.2024 - 04.2025

Data Engineer – Enterprise Data Warehouse (EDW)

Enterprise BnPS -British Telecommunications plc.
09.2021 - 04.2024

PL/SQL Developer

Openreach Ltd.-British Telecommunications plc.
02.2020 - 08.2021

Support Analyst

Kroll Associates, Inc.
08.2017 - 01.2020

Analyst for Communications Media & Information Services

Newspaper Publishing(TRONC)
03.2016 - 07.2017

B.Tech - Mechanical Engineering

NIT Durgapur

MBA -

INDIAN INSTITUTE OF MANAGEMENT KOZHIKODE
SUBHASIS KAR