Anjali Kumari - Ultimate Data Portfolio

Anjali Kumari-- Portfolio

About Me

Hi! I'm Anjali, a data-driven problem solver with a growing passion for analytics and technology. I enjoy turning raw data into meaningful insights that help drive smart, informed decisions. With hands-on experience in SQL, Python, Power BI, and Excel, I'm continuously expanding my skills to Machine Learning.

"Information is the oil of the 21st century, and analytics is the combustion engine."
— Peter Sondergaard, SVP at Gartner

Resume

anjalikumari25112@gmail.com

National Institute of Technology, Silchar

SKILLS

Technical Skills

Programming

Python

Pandas, NumPy, Matplotlib, Seaborn, Scikit-learn

Statistical Analysis

HTML/CSS

Frontend Development

Tools

Power BI

DAX, Power Query

Tableau

Dashboards

Excel/Sheets

Pivot Tables, VLOOKUP

Jupyter Notebook

Data Analysis

ML & Statistics

Regression

Linear, Logistic

Classification

Scikit-learn

EDA

Pandas Profiling

Hypothesis Testing

A/B Testing

Databases & Big Data

SQL

MySQL, PostgreSQL, SQL Server, BigQuery

PySpark

Data Processing

Apache Spark

Distributed Computing

Pick a project

FASHION STORE SALES ANALYSIS

Fashion Sales Insights

Microsoft Excel Power Query Pivot Tables

Data Cleaning Data Transformation

Data Modelling

BANKING RISK ANALYSIS

Banking Risk Assessment

Power BI EDA using Python

Data Cleaning Data Transformation

Data Visualization Data Analysis

NETFLIX DATA CLEANING AND ANALYSIS

Netflix ELT Data Pipeline

SQL Python EDA Jupyter Notebook

Data Cleaning Data Transformation

WEATHER FORECASTING DASHBOARD

Weather Data Visualization

Streamlit CSS

Python

Data Visualization

FAASOS FOOD DELIVERY ANALYTICS

Customer Behavior & Revenue Analysis

SQL

MYSQL DATA CLEANING

Data Quering

Ongoing

AMAZON REVEIWS SENTIMENT ANALYSIS

NLP & Text Mining Project

Python NLTK

Natural Language Processing

Text Mining Machine Learning

Internships

Indian Institute of Technology,Guwahati||RESEARCH INTERN

2024,May-June

Smart Materials and Structures Lab

Experimental Data Analysis on piezoelectric property of Materials

Leadership Roles

Training and Placement Coordinator

Training and Placement Cell, NIT Silchar

2025–Present

Hindi Sahitya Samiti Head

ILLUMINITS-Literary,Arts and Publication Society,NIT Silchar

2024-2025

Head of Content Team

GYANSAGAR-Non-profit Social Service Oraganisation,NIT Silchar

2024-2025

Certifications

Python Beginner to advanced for Data Professionals

CodeBasics

Certificate

Microsoft Power BI Desktop for Business Intelligence

Udemy

Certificate

Ongoing

Complete Data Science,Machine Learning,DL,NLP Bootcamp

Udemy

Corporate readiness & career impact skills

Define Career

Certificate

Hackerrank-SQL Proficiency

Hackerrank

Certificate

Programming Foundations: Databases

Linked In

Certificate

Google Data Analytics

Google

Certificate

Data Analysis with R programming

Google

Certificate

Google Data Analytics Capstone: Complete a Case Study

Google

Certificate

Thank You for Visiting

If you're interested in discussing potential opportunities or collaborations, reach out via email or LinkedIn.

Looking forward to connecting with you!

Anjali Kumari-- Portfolio

Resume

anjalikumari25112@gmail.com

LinkedIn

National Institute of Technology, Silchar

SKILLS

Technical Skills

Programming

Tools

ML & Statistics

Databases & Big Data

Indian Institute of Technology,Guwahati||RESEARCH INTERN

Training and Placement Coordinator

Hindi Sahitya Samiti Head

Head of Content Team

Python Beginner to advanced for Data Professionals

Microsoft Power BI Desktop for Business Intelligence

Complete Data Science,Machine Learning,DL,NLP Bootcamp

Corporate readiness & career impact skills

Hackerrank-SQL Proficiency

Programming Foundations: Databases

Google Data Analytics

Data Analysis with R programming

Google Data Analytics Capstone: Complete a Case Study

Thank You for Visiting

Fashion Store Analysis

Goal

Key Findings

Action Plans Proposed

Technology Stack

Data Specifications

Visualized monthly trends of orders and sales using dynamic charts, slicers, and filters for real-time, user-driven analysis.

Analyzed sales by age group, gender, and clothing size to identify key demographics and optimize product offerings.

Mapped regional sales distribution across India to uncover high-performing states and regional demand patterns.

Displayed crucial business metrics like Return Rate, Average Order Value, B2B Contribution, and Customer Retention for strategic decision-making.

Banking Risk Analysis

Goal

Key Findings

Action Plans Proposed

Technology Stack

Data Specifications

Interactive Multi-Page Dashboard. Each page targets a specific domain: loans, deposits, risk management.

Integrated custom slicers for gender, income band, nationality, occupation, and time range.

Dynamic Financial Indicators: KPI cards and visuals for Total Loans & Deposits, LDR (Loan-to-Deposit Ratio), DTI (Debt-to-Income Ratio), Collateral Coverage, Risk Tier Distributions

Netflix Data cleaning and Analysis

Goal

Key Findings

Technology Stack

Data Specifications

Data Cleaning Operations: Handling foreign characters. Removing duplicates. Converting data types appropriately. Populating and managing missing values. Creating new dimension tables (e.g., for countries).

SQL-Based Analysis: Answering 5 real-world SQL questions post-cleaning. Demonstrates data comprehension and insight generation.

End-to-End Pipeline: Automates ELT stages. Reflects modern data engineering practices.

Weather Forecasting Dashboard

Goal

Key Findings

Technology Stack

Data Specifications

Clearly displays weather condition, maximum temperature, wind speed, and date using clean metric cards.

Temperature Heatmap Shows a weekly vs. daily heatmap of temperatures across the entire year, revealing seasonal and weekly patterns in Seattle.

Fully customized using CSS for a modern look, with consistent typography, iconography, and color palette.

Faasos Food Delivery Analytics

Goal

Key Findings

Action Plans Proposed

Technology Stack

Data Specifications

Structured and normalized tables for drivers, rolls, ingredients, orders, and order items.

Roll Analysis: Count of rolls ordered and delivered. Roll preferences by type (veg/non-veg). Delivered orders with/without customization.

Customer Insights: Orders per customer, roll preferences. Behavioral segmentation (e.g., no change vs changed orders).

Social Media Sentiment Analysis

Goal

Expected Outcomes

Technology Stack

strong>Text Preprocessing: Tokenization, lemmatization, stop word removal

Feature Engineering: TF-IDF vectorization, word embeddings (Word2Vec

Sentiment Classification: Naive Bayes, SVM, and LSTM neural networks