View Resume

> Assalamualaikum, I'm Adnan Jahangir
$ █

I turn raw data into clear dashboards and useful insights.

3+ Featured Projects
/
Python • SQL • Power BI Python • SQL • BI Core Tech Stack
/
100% Live Demos & Code

Data-Driven Insights, Practical Solutions

Adnan Jahangir
Data Analyst
Developer

Analytical Mindset, Clean Engineering

I am an undergraduate Computer Science & Engineering student at the International Islamic University Chittagong (IIUC). My focus centers on data analytics, business intelligence dashboards and software development. What started as curiosity about how raw data tells hidden stories has evolved into building reliable, data-driven applications.

I specialize in SQL query optimization, star-schema data modeling in Power BI and exploratory data analysis in Python. Whether analyzing 45,000+ hospital records to uncover outbreak patterns or developing full-stack tracking systems, I focus on building practical solutions that address real-world challenges.

SQL & Databases

Query Tuning & PostgreSQL

Business Intelligence

Advanced DAX & Power Query

Web Development

React.js, Node.js & REST APIs

Machine Learning

Scikit-Learn & Predictive Models
Get In Touch

Technologies & Tools I Work With

01 / DATA ANALYTICS

Data Analytics & Query Engines

Python (Pandas / NumPy)
PostgreSQL
MySQL
Google BigQuery
Scikit-Learn
Statistical Hypothesis Testing
02 / BUSINESS INTELLIGENCE

Reporting & Data Modeling

Power BI Power BI
DAX Measures
Excel Excel Power Query
Tableau
Dynamic Pivot Modeling
03 / WEB DEVELOPMENT

Frontend & Backend Systems

React.js
Node.js & Express
MongoDB
TypeScript
Socket.IO Realtime
Tailwind CSS
04 / CS FUNDAMENTALS

Algorithms & Infrastructure

C++ / C
Java (Object-Oriented)
Docker Containerization
Git Version Control
AWS Cloud
Data Structures & Algorithms
Python
PostgreSQL
Power BIPower BI
SQL
Pandas
NumPy
BigQuery
ExcelExcel
Python
PostgreSQL
Power BIPower BI
SQL
React
Node.js
Docker
Git
C++
MongoDB
TypeScript
React
Node.js
Docker
Git

Selected Engineering Works

MERN + Socket.IO
MediCare Delivery Platform
TypeScript Socket.IO GPS Telemetry SSLCommerz

MediCare – Pharmacy Logistics Platform

Full-stack pharmaceutical dispatch platform featuring live driver GPS tracking via WebSocket, 4-tier role authorization (Customer, Pharmacist, Driver, Admin) and SSLCommerz payment integration.

1,000+ cataloged medicines with zero-latency live driver telemetry.
MERN + AI
IIUC Smart Library
React Node.js AI Assistant University ERP

IIUC Smart Library Management

Comprehensive university library management system automating book catalog indexing, automated seat allocation, fine calculations and AI-assisted catalog recommendations.

Serves 15,000+ active campus students, slashing checkout queue times by 40%.
React + Express
Hisab Accounting ERP
Double-Entry MongoDB Tailwind CSS Financial Ledger

Amar Hisab — Cloud Accounting ERP

Cloud-native inventory and accounting management engine built for SMEs, featuring real-time cashflow visualization, double-entry automated balances and debtor/creditor ledger reconciliations.

Reduced monthly bookkeeping reconciliation overhead for retail users by 30%.
Power Query
Dengue Surveillance Dashboard
Power Query Geospatial Slicers Epidemiology

Dengue Outbreak Surveillance (Dhaka)

Epidemiological surveillance engine analyzing outbreak vectors across Dhaka wards. Uses advanced Power Query data wrangling, seasonal trend decomposition and interactive risk clusters.

Processed 45,000+ hospital admission records to pinpoint high-density hazard zones.
SQL + Tableau
Hospital Mortality Prediction
PostgreSQL Window Functions Tableau Healthcare

Hospital Mortality Risk Prediction

Healthcare analytics model utilizing complex multi-join relational SQL queries and window aggregations over inpatient hospital records to identify primary mortality risk drivers.

Analyzed 85,000+ clinical records to establish diagnostic risk metrics.
Power Query + DAX
Hotel Management Dashboard
Power Query Yield Management RevPAR KPIs

Hotel Operations & Occupancy Hub

Hospitality performance tracking system synthesizing booking trends, cancellation rates, RevPAR metrics and customer segments through dynamic pivot modeling.

Processed 12,000+ booking entries with automated yield optimization views.

No projects found in this category.

Academic & Leadership

Campus Leadership

IIUC Computer Club Logo
Active Term
2026 – Present • Executive Committee

Assistant Innovation & Tech Secretary

IIUC Computer Club — International Islamic University Chittagong

Spearheading campus-wide technical initiatives, orchestrating competitive programming contests and mentoring 1,000+ student developers across machine learning, web technologies and software engineering.

Tech Mentorship Hackathons Innovation Culture

Academic Milestones

2023 – Present • Undergraduate

B.Sc. in Computer Science & Engineering

Specialization in Data Analytics & System Architecture

International Islamic University Chittagong

Rigorous coursework covering algorithms, relational database architecture, distributed systems, machine learning and statistical inference.

Advanced Algorithms Database Management Artificial Intelligence Data Communications
2020 – 2022 • Completed

Higher Secondary Certificate (HSC)

Science Division

Baroiyarhat College, Mirsharai, Chittagong
GPA: 4.75 / 5.00
Physics Higher Mathematics Leadership & Coordination

Verified Certifications

Interactive Cares 2025

Data Analytics & Power BI Career Path

Netcom365 2025

AI+ Prompt Engineer Level 1™

Interactive Cares 2026

Advanced SQL with BigQuery & Metabase

Let's Connect

Let's Build Something Meaningful

I'm always open to discussing data analytics internships, development projects, or exciting opportunities. Feel free to reach out anytime!

Location

Sitakund, Chittagong, Bangladesh

Social Profiles