SUBHASIS KAR
Data Analyst & Team Lead
Kolkata
Summary
Results-driven professional specializing in Design & Development and Quality Assurance, seeking to leverage data analysis skills in a dynamic environment. Expertise in Power BI, SQL, Excel, Tableau, and ETL drives business growth across manufacturing, telecommunications, and various industrial projects. Detail-oriented Data Analyst proficient in data warehousing, process validation, and business needs analysis, with a proven track record of translating customer requirements into actionable project plans. Committed to delivering high-quality results with a passion for Big Data and continuous improvement.
Overview
10
10
years of professional experience
1
1
Certification
3
3
Languages
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%.
- End-to-End Data Ingestion: Engineered and automated data ingestion pipelines from Databricks using PySpark, performing necessary transformations and data cleansing on telecom order and product usage data to feed into BI reporting models.
- 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.
- Agile Project & Team Management: Managed team workflows and sprint planning as a JIRA board administrator, leading daily stand-ups, tracking velocity, and ensuring on-time project delivery within an Agile framework.
- Multi-Tool Visualization: Created compelling and interactive visualizations in both Tableau and Power BI, tailoring reports to stakeholder needs and enabling clear insight into sales performance and product adoption trends.
- 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
- Worked as a data engineer by improving data-driven decision-making by a significant breakthrough.
- Worked with CAs for the Report reconciliation analyzing the Financial Data from Global Finance Portal (GFP), summarizing and visualizing the large Datasets through Pivot Tables, Advance Excel.
- Data validation , Data Cleansing and Data visualization through BI tools like Power BI and Data Retrieval through VLOOKUP
- Worked on Reconciliation in collaboration with Corporate Performance Management ETL tool managing team (Anaplan) Implementing data validation methods and data quality tools & formulae to ensure data integrity.
Data Engineer – Enterprise Data Warehouse (EDW)
Enterprise BnPS -British Telecommunications plc.
09.2021 - 04.2024
- Support was provided by analyzing the problems occurring in their application, Development in the ETL cycle for Data-Warehouse using PL/SQL via ORACLE.
- Designing data models, implementing ETL processes, optimizing database performance, and ensuring data quality and security.
- Optimizing database performance, troubleshoots data warehouse issues, and ensures efficient data retrieval and processing.
- Developing and maintaining documentation for data warehouse processes and architecture.
- Collaborating with business analysts, data analysts, and other stakeholders to understand requirements and deliver data warehouse solutions that meet business needs.
- Developing and maintaining reports, dashboards with data visualization tools like Power BI to communicate findings to stakeholders.
- Having knowledge for Cloud Infrastructure also using likes (GCP, AWS etc).
PL/SQL Developer
Openreach Ltd.-British Telecommunications plc.
02.2020 - 08.2021
- Worked in Openreach Telecommunication project owned by British Telecom, where in Designing, developing, and maintaining Oracle database applications performed using the PL/SQL programming language.
- Reviewed code for bugs, performance bottlenecks, and compliance with coding standards and also test the PL/SQL code to ensure it functions correctly and efficiently.
- Worked in Agile Methodologies maintaining JIRA work efficiency and the deployment to the Production Server via the Jenkins Pipeline.
- Maintaining the Git-Lab Tools by Code commissioning update.
Support Analyst
Kroll Associates, Inc.
08.2017 - 01.2020
- Worked in a Information Security Maintaining project owned by Kroll Associates, Inc, wherein support was provided by analyzing the problems occurring in their application handling with the DATA in MS SQL & MS EXCEL. CONFLUENCE, METASTORM was the major application and User Access Management in SALESFORCE application, wherein understanding of the workflow.
- Enhanced team efficiency by maintaining up-to-date process documentation and contributing to a comprehensive Knowledge Base (KB), reducing incident resolution time.
Analyst for Communications Media & Information Services
Newspaper Publishing(TRONC)
01.2016 - 01.2017
- Worked in a newspaper publishing project owned by TRONC, wherein support was provided by analyzing the problems occurring in their application. NEWSGATE was the major application, MS-SQL where in understanding of the workflow, how the different feeds (like news, photos, reports) come and go for processing and publishing for the readers was gained.
- Performed Unix-based troubleshooting, including log analysis, file transfers, service restarts during patching, and system health checks.
Education
B.Tech - Mechanical Engineering
NIT Durgapur
06-2015
Skills
SQL
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.
Certification
Salesforce Administration
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.
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)
01.2016 - 01.2017
B.Tech - Mechanical Engineering
NIT Durgapur