Open to data opportunities

Data Analyst · Malda, India

I turn messy data into clear decisions.

I'm Amit Karmakar—a Data Analyst working across Python, SQL, Excel and Power BI to clean complex datasets, discover useful patterns and communicate the story behind the numbers.

124K+records analysed
23dashboard visuals
16+documented insights
5portfolio projects

Selected work

Projects with proof.

Five projects across analysis, dashboarding, data modeling and automation—each documented for reproducibility and recruiter review.

EDA workflow · executive view● AUTO DASHBOARD
01

Exploratory Data Analysis

Amazon Prime Video EDA

Cleaned, merged and explored title and credit data to surface release, rating, genre, runtime, actor and director patterns.

  • 124,235 credit records
  • 9,871 titles
  • 16+ insights
PythonPandasNumPySeaborn
View case study
BI workflow · executive view● AUTO DASHBOARD
02

Business Intelligence

Amazon Prime Content Dashboard

Built an executive Power BI report that turns a large content dataset into an interactive view of catalogue quality and audience signals.

  • 23 visuals
  • DAX measures
  • Interactive slicing
Power BIDAXData ModelingPower Query
View case study
Automation workflow · executive view● AUTO DASHBOARD
03

Automation Engineering

HORIZON Shorts Automation

Designed a local-first Windows pipeline for validation, duplicate prevention, FIFO scheduling, offline SEO and resilient YouTube publishing.

  • 422 unique videos
  • 10 duplicates blocked
  • 2 daily slots
PythonSQLiteYouTube APIOAuth
View case study
Product data model · executive view● AUTO DASHBOARD
04

Product & Database Design

Zomato Product Dissection

Mapped customer and business problems to product features, then translated the operating model into a structured relational database design.

  • 7 data domains
  • 9-table ER model
  • PK/FK relationships
SQLER ModelingProduct AnalysisData Modeling
View case study
Python foundations · executive view● AUTO DASHBOARD
05

Python Foundations

Python Programming Capstone

A structured problem-solving portfolio covering core Python through reusable functions, object-oriented programming and defensive error handling.

  • 30+ problems
  • 21 functions
  • 5 classes
PythonOOPFunctionsException Handling
View case study

Technical toolkit

Tools follow the question.

I choose the simplest reliable path from raw input to decision-ready output—then document the work so somebody else can follow it.

01

Analysis

PythonSQLExcelPandasNumPyEDAData CleaningStatistical Analysis
02

Business Intelligence

Power BIDAXPower QueryTableauDashboardingData VisualizationKPI Design
03

Data & Engineering

SQLiteRelational DesignER ModelingREST APIsOAuth 2.0AutomationGitHub

Experience & education

A business-aware route into data.

Customer-facing experience gave me the communication discipline; structured analytics training gave me the technical method.

2024

Professional experience

Sales Manager · Star Health Insurance

Managed customer follow-up, daily sales activity and team coordination in a target-driven environment. Built practical strengths in prioritization, retention support and stakeholder communication.

2025—26

Professional certification

Data Science & Machine Learning · AlmaBetter

Completed hands-on learning across Python, SQL, statistics, exploratory analysis, machine learning, Power BI and Tableau.

2017

Bachelor's degree

B.A. in History · Malda College

Developed research, source evaluation and structured communication skills that now support analytical investigation and reporting.

A little more than the stack

Curious by nature. Practical by choice.

My background in customer-facing sales taught me to listen closely, clarify the real problem and explain decisions simply. Today I bring those same habits to data work—along with a growing technical toolkit and a bias toward reliable, documented solutions.

Verified learning

Credentials with evidence.

View certificate folder

Let's work together

Need an analyst who can connect data to people?