Summary
Overview
Work History
Education
Skills
Certification
Languages Known
Timeline
Generic
Subhankar Karmakar

Subhankar Karmakar

Hyderabad

Summary

Data Analyst with 5+ years of experience interpreting and analyzing data to drive successful business solutions. Proficient knowledge experience in Excel, Python, Power BI, SQL and analytics. Excellent understanding of business operation tools for effective analysis.

Overview

7
7
years of professional experience
1
1
Certification

Work History

Data Analyst

Capgemini
08.2024 - 02.2025

Project- Internal

  • Developed and maintained complex SQL queries involving joins and union to support business reporting needs.
  • Created and managed indexes to enhance data retrieval speed and ensure optimal database performance.
  • Hands-on experience with LLMs and SLMs like Co-pilot, Phi, LLAMA. Used Generative AI to achieve quick turnaround times, rapid prototyping and optimize workflows.
  • Worked using Agile methodology.
  • Used statistical methods to analyze data and generate useful business reports.

Data Analyst

Genpact India Pvt Ltd
11.2021 - 07.2024

Project- Meta(Facebook)

  • Responsible for Designing, developing, and maintaining Agent Performance reports for Global Operations for various across sites in USA, JAPAN, PHILIPPINES, INDIA, and SINGAPORE
  • Involved in training Meta's proprietor AI model for flagging and categorizing social media content.

Project- Global command centre(Workforce)

  • Utilized tools like Advance Excel and SQL to extract, clean, preprocess large datasets from various sources and manipulate data for analysis
  • Performed exploratory data analysis to identify trends, patterns, and Implemented actions that business needs that got reduce the budget by 16%
  • Collaborated with cross-functional teams to ensure data integrity and accuracy, resulting in better-informed decisions.
  • Provided actionable insights through comprehensive reports and dashboards, supporting strategic initiatives.

Process Associate

Tata Consultancy Services
08.2018 - 11.2021
  • Re-organized, Developed, and implemented a client service program, which expanded the small to medium client base by 11%
  • Prepared Weekly/Monthly reports in Excel for Stakeholders and client
  • Automated daily report Using VBA Macro’s resulted in eliminating 220hrs of manual work
  • Maintained high levels of data confidentiality through adherence to company policies and procedures.

Education

BBA - Marketing

Institute of Engineering And Management
Kolkata, India
06.2018

Skills

  • Microsoft Excel
  • Python
  • SQL
  • Analytical ability
  • Data Visualization
  • Power BI
  • Large Language models(LLM)
  • Data Analysis
  • Data cleaning and preparation
  • Critical thinking
  • Problem solving
  • Attention to detail

Certification

  • Data Analytics certification from ExcelR Solutions.

Languages Known

English
Hindi
Bengali

Timeline

Data Analyst

Capgemini
08.2024 - 02.2025

Data Analyst

Genpact India Pvt Ltd
11.2021 - 07.2024

Process Associate

Tata Consultancy Services
08.2018 - 11.2021
  • Data Analytics certification from ExcelR Solutions.

BBA - Marketing

Institute of Engineering And Management
Subhankar Karmakar