Back to Developers
Pritam Banerjee

Pritam Banerjee

Data Analyst

Kolkata, India 0+ yrs exp 87 · Excellent

About

Data Analyst with over 1 year of cross-functional experience across legal tech, media analytics, and e-commerce, specializing in SQL, Power BI, Python, and automated reporting pipelines. Proven track record of delivering actionable business insights and optimizing data workflows—reducing manual reporting effort by 40%, improving audience experience metrics by up to 10%, and driving a 25% boost in customer experience through high-accuracy catalog data reconciliation. Adept at partnering with cross-functional stakeholders, translating complex business requirements into interactive dashboards, and applying AI-assisted techniques (Prompt Engineering) to accelerate SQL and DAX development.

Skills & Expertise (39)

MS SQL Server Intermediate
7.5/10
2
Years Exp
SQL Intermediate
7.5/10
2
Years Exp
Data Extraction Intermediate
7.5/10
2
Years Exp
Data Transformation Intermediate
7.5/10
2
Years Exp
Power BI Intermediate
7.5/10
2
Years Exp
Python Intermediate
7.5/10
2
Years Exp
Data Quality Intermediate
7.0/10
2
Years Exp
Exploratory data analysis Intermediate
7.0/10
2
Years Exp
ETL Intermediate
7.0/10
2
Years Exp
MySql Intermediate
6.5/10
2
Years Exp
Pandas Intermediate
6.5/10
1
Years Exp
Agile Intermediate
6.0/10
2
Years Exp
NumPy Intermediate
6.0/10
1
Years Exp
Statistical Modelling Intermediate
6.0/10
2
Years Exp
DAX Intermediate
6.0/10
1
Years Exp
Postgresql Intermediate
5.5/10
1
Years Exp
Clustering Gemini Claude ChatGPT Prompt Engineering SOP Documentation validation SQL Query Optimization Regex Matplotlib Regression Dashboards Index-match VLOOKUP XLOOKUP Pivot Tables Macros VBA Interactive Dashboard Development Data Warehousing concepts Looker Studio Power Query Data Modelling

Work Experience

Data Analyst

Legal O2

Sep 2025 - Feb 2026

Executed OCR-based extraction of data from PDFs and scanned images into structured CSV datasets, streamlining eDiscovery workflows for 100% of assigned PII/PHI (HIPAA) compliance records. Executed rigorous Quality Control (QC) and data validation on 2,000–3,000 records daily, maintaining 92–98% accuracy against client SLAs to ensure dataset consistency. Built Python and VBA scripts for daily automation tasks, reducing manual effort in data collection and report generation by 40%. Used Advanced Excel (VLOOKUP, INDEX-MATCH, Pivot Tables) and SQL (MSSQL) for data extraction, transformation, and manipulation, accelerating delivery time on stakeholder reporting. Utilized Prompt Engineering via AI tools (ChatGPT, Claude) to debug and accelerate SQL and VBA script development, cutting query troubleshooting time by half.

Quality Control Analyst

Nielsen Media India Pvt. Ltd

Feb 2025 - Apr 2025

Maintained 95%+ data quality standards for international audience measurement datasets, using dashboards to analyze panelist behavior and flag anomalies. Automated QC report generation using Python and VBA/Macro scripts, monitoring KPIs to eliminate 15+ hours of manual weekly reporting. Investigated and resolved 4–5 high-priority data inconsistency cases daily, following SOP-driven QC procedures to safeguard reporting accuracy. Presented findings to business stakeholders, contributing to an 8–10% improvement in audience experience metrics.

Catalog Specialist I

Amazon (C2H: eTeam InfoService)

Oct 2024 - Dec 2024

Updated 7,500+ product catalog records, maintaining 90–91% accuracy using Excel and geo-spatial tooling. Collaborated with Amazon's Geocode team, contributing to a 25% improvement in customer experience through accurate location and catalog data. Gathered requirements directly from cross-functional stakeholders in recurring meetings, feeding data-quality improvements back into operational workflows.

Data Analyst Intern

Afame Technologies

Apr 2024 - May 2024

Built an interactive Power BI dashboard for HR Attrition Analysis, delivering data-driven insights on turnover metrics across 5+ key business departments. Performed exploratory data analysis (EDA) and data wrangling in Python (Titanic dataset), engineering features to improve baseline data model accuracy. Developed monthly sales analysis reports using Excel Pivot Charts and Tables to identify trends across product categories, surfacing key sales drivers to support decision-making.

Education

B. Tech — Electrical Engineering - Saroj Mohan Institute of Technology, WBUT

2010 - 2014 · Afghanistan

Certifications

Build with AI: SQL Agents with Large Language Models & Build with AI: SQL AI Agents in Production

LinkedIn Learning · 2026

Data Engineering: dbt for SQL

LinkedIn Learning · 2026

Introduction to AI Orchestration with LangChain and LlamaIndex

LinkedIn Learning · 2026

Career Essentials in Data Analysis

Microsoft & LinkedIn · 2025

Agile Business Analysis

LinkedIn Learning · 2025

Advanced Excel & DBMS MySQL

TutorialsPoint · 2024

Industry Simulations [Forage Virtual Experience]

PWC Switzerland, KPMG Australia, Tata iQ · 2023-2024

Microsoft Power BI & DAX Dashboard & Python — Data Analysis & Visualization

Udemy · 2023

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 7/15
💰 Rate 0/5
🏆 Certs 5/5
Verified 5/5
Total Score 87/100

Profile Overview

Member sinceAug 2026

Availability Details

Visa Status

Citizen

Relocation

Open to Relocation