Portfolio_Ankit

📊 Ankit Kumar — Data Analyst Portfolio

👋 About Me

Hi, I’m Ankit Kumar, a Data Analyst passionate about transforming raw and complex datasets into meaningful business insights.

I specialize in:

SQL & Data Analysis
Python & Pandas
Power BI & DAX
Advanced Excel
Data Cleaning & ETL
Web Scraping & Data Extraction
Business Intelligence & KPI Reporting

My work focuses on building reliable data pipelines, interactive dashboards, automated workflows, and actionable analytics solutions.

💼 Experience

Trailytics AI — Data Analyst

January 2025 – Present

Process and analyze e-commerce product data.
Handle 10,000+ SKUs weekly.
Achieved 98%+ classification accuracy.
Improved data completeness by 15%.
Reduced manual rework by 10%.
Create weekly KPI reports using Excel and Power BI.

TurnPikeAnalyst — Software Engineer

July 2023 – July 2024

Developed backend functionality using Python and Django.
Built APIs and authentication/authorization workflows.
Implemented multilingual booking notifications using JSON.
Used Pandas and NumPy for analytics and reporting.
Tested APIs using Postman.

🚀 Featured Projects

1. Smart PDF Data Pipeline

An automated data-processing project designed to extract, transform, and structure information from PDF documents.

Tools: Python, Pandas, PDF Processing, ETL

2. E-Commerce Product Data Extraction

A web-scraping and data extraction project focused on collecting and structuring product information from e-commerce platforms.

Tools: Python, BeautifulSoup, Selenium, Requests, Pandas

🔗 GitHub Repository

3. Mobile Sales Analytics Dashboard

An interactive Power BI sales analytics dashboard for analyzing mobile-phone sales performance across brands, models, cities, payment methods, customer ratings, months, and weekdays.

Tools: Power BI, DAX, Data Modeling, Excel

🔗 GitHub Repository

4. Netflix Insights Dashboard

A Python-based data analysis project featuring interactive visualizations of Netflix movies and TV shows.

The project analyzes:

Content distribution
Ratings
Duration trends
Geographical insights

Tools: Python, Pandas, Matplotlib, Seaborn

🔗 GitHub Repository

🛠️ Technical Skills

Category	Skills
Programming	Python, Pandas, NumPy
Data Analysis	Data Cleaning, ETL, Data Analysis
SQL	SQL, Querying, Aggregations
Business Intelligence	Power BI, DAX, Data Modeling
Excel	Advanced Excel, Pivot Tables, VLOOKUP
Automation	BeautifulSoup, Selenium, Requests
Visualization	Matplotlib, Power BI, Charts
Reporting	KPI Reporting, Data Storytelling

📈 Key Impact Metrics

Metric	Impact
Classification Accuracy	98%+
SKUs Processed Weekly	10K+
Data Volume Handled	100K+
Data Completeness Improvement	15%
Manual Rework Reduction	10%
Reporting Efficiency	6–7 hrs saved

🎓 Education

Haldia Institute of Technology

B.Tech — Applied Electronics and Instrumentation Engineering

2019 – 2023

Jai Prakash College

PCM

2016 – 2018

🌐 Connect With Me

LinkedIn: linkedin.com/in/ankit-kumar-80888a245
GitHub: github.com/Ankitt16
Instagram: @ankii_ttt
Email: ankitkumar2716@gmail.com

🌐 Portfolio

Live Website:
https://portfolio-ankit-kappa.vercel.app

Resume:
View Resume

⚙️ Built With

Next.js
React
TypeScript
Tailwind CSS
Framer Motion
Lucide React
Vercel

📁 Project Structure

```text Portfolio_Ankit/ ├── app/ │ ├── globals.css │ ├── layout.tsx │ └── page.tsx │ ├── components/ │ ├── About.tsx │ ├── Contact.tsx │ ├── Experience.tsx │ ├── Hero.tsx │ ├── Navbar.tsx │ ├── Projects.tsx │ └── Skills.tsx │ ├── public/ │ ├── images/ │ │ └── me.png │ └── Ankit_kumar_resume.pdf │ ├── package.json └── README.md