Name: Nilanjan Paul

Job Role: Data Analyst

Experience: 4 Years

Address: Kolkata, India

Skills

SQL 85%
PYTHON 80%
Data Visualization 80%
Data Modelling 80%
ETL 80%

About

About Me

With nearly 4 years of comprehensive experience in extracting, analyzing, and interpreting complex datasets, I bring strong problem-solving and communication skills. I am committed to delivering accurate and actionable information that drives business success. Demonstrated success in leading impactful projects and providing effective mentorship.

  • Profile: Data Analytics & Engineering
  • Domain: Retail, Ecommerce, & Manufacturing
  • Education: Bachelor of Engineering
  • Language: English, Hindi, Bengali
  • BI Tools: Microsoft Power BI & Tableau
  • Other Skills: Azure Cloud, MS-Excel & HTML
  • Interest: Travelling, Travel Photography, Reading

0 +   Projects completed

LinkedIn

Resume

Resume

Data Analyst with 3+ years of experience driving business strategies through data-driven insights. Proficient at creating automated data pipelines, building interactive dashboards, and optimizing business processes for greater efficiency.

Experience


2023-Present

Internal Audit Data Analyst

Vesuvius, Kolkata

Vesuvius, a 100+ year-old British company based in London, is a global leader in molten metal flow engineering, serving steelmakers, foundries, and industries like glass and solar energy.

  • Automated Power Query data source replacement in Power BI, boosting efficiency by 87% and streamlining dashboard updates.
  • Developed Python scripts for data preprocessing, automating repetitive tasks and improving data cleaning and transformation by 40%.
  • Built and managed a SQL-based data pipeline, ensuring accurate, continuous data integration across systems.

2022-2023

Data Analyst

SOAIS, Kolkata

SOAIS is a leading enterprise IT solutions provider with a passion for customer satisfaction, technology innovation and deep industry & business process expertise.

  • Leveraged Python and pandas to extract, clean and manipulate complex datasets, improving data processing efficiency by 20%.
  • Developed interactive Power BI reports using advanced DAX features for insightful data visualization.

2020-2022

Process Analyst

Amazon, Bengaluru

Amazon focuses on customer obsession, innovation, operational excellence, and long-term vision, aiming to be the most customer-centric company, best employer, and safest workplace.

  • Assisted in analyzing data using MS-EXCEL and SQL to support business decisions.
  • Reduced mapping time 26% by implementing process improvements in CMT tool.



Education


2016-2020

Bachelor of Engineering

University of Engineering & Management
2014-2015

Higher Secondary School

St.Stephen's School

Projects

Projects

Below are the sample Data Analytics projects on SQL, Python, Power BI & Tableau.

Credit Card Spending Habits using SQL

Conducted credit card spending habit analysis to identify customer behavior patterns, optimize marketing strategies, and improve risk management decisions.

Heart Disease Analysis using Python

Performed heart disease analysis by identifying key risk factors and patterns in patient data, contributing to improved predictive modeling and early diagnosis strategies..

E-Commerce Dataset Analysis using Python

Analyzed e-commerce dataset to uncover customer purchasing trends, optimize product recommendations, and enhance overall business decision-making.


Amazon Sales Analysis

Conducted Amazon sales analysis to identify product performance trends, optimize pricing strategies, and boost revenue growth.

0 Achievements
0 Projects

More projects on Github

Passionate about solving business challenges & uncovering hidden insights within data


GitHub

Contact

Contact Me

Below are the details to reach out to me!

Address

Kolkata, India

Contact Number

+91 9163941865

Email Address

paulnilanjan39@gmail.com

Download Resume

resumelink