✓ Saved successfully!
Skills Projects Experience Education Certifications Contact 📄 Resume
Available for opportunities

MD
SHAKIB

Data Analyst — turning raw data into decisions.
Skilled in Python, Power BI, SQL & Advanced Excel.

MD SHAKIB
// Data_Analyst
✉️ mdshakib.ds01@gmail.com
📍 New Delhi, India
🔗 linkedin - mdshakibds 👨‍💻 Github - mdshakibds
🎓 BSC — BRABU
9+
Skills
11+
Projects
1+
Certs
scroll

My Skills

📊
Advanced Excel
Advanced
🐍
Python
Intermediate
📈
Power BI
Intermediate
🗄️
SQL
Intermediate
📐
Statistics
Intermediate
🔢
NumPy
Intermediate
🐼
Pandas
Intermediate
📉
Matplotlib
Intermediate
🎨
Seaborn
Intermediate

My Projects

🐍
Python Projects
Data analysis & visualization using Pandas, NumPy, Matplotlib, Seaborn
PYTHON · 001
E-Commerce Sales Analysis

Analyzed e-commerce data to identify revenue and customer trends.

Used Python for data cleaning, EDA and visualization.

Improved sales strategy efficiency by 15%.

PythonNumPyPandasMatplotlib
🐙 View Code
PYTHON · 002
QR Code Generator

Generate QR codes from text, URLs, or UPI IDs.

User-friendly Tkinter interface.

Save QR codes as .png images.

Quick and lightweight.

PythonqrcodeTkinterPillow
🐙 View Code
PYTHON · 003
Chatbot

Chat with Gemini AI in real-time.

Uses the Gemini-1.5-Flash model for generating responses.

Simple CLI interface.

Supports continuous conversation until the user exits.

PythonGemini APIGoogle GenAICLI
🐙 View Code
🗄️
SQL Projects
Advanced queries — JOINs, Window Functions, CTEs, Stored Procedures
SQL · 001
Analyzing Employee Trends

Used SQL for real-world business problem solving.

Generated insights for decision-making, not just queries

Identified employee behavior patterns through SQL-based trend analysis.

Performed comprehensive data exploration and validation on real-world datasets

Used advanced SQL concepts like: JOINs,(INNER, LEFT, RIGHT),GROUP BY & HAVING ,CASE Statements ,Subqueries & CTEs ,Window Functions (RANK, ROW_NUMBER, AVG OVER)

SQLWindow FunctionsCTEs
🐙 View Code
SQL · 002
Banking Transaction Analysis

Transaction fraud detection

Loan repayment tracking

Customer segmentation (active, dormant, multi-account, city-wise, etc.)

Monthly and city-wise spending analyses

Top performing customers and loan officers

Average balances and lifetime value reporting

SQLStored ProceduresIndexing
🐙 View Code
SQL · 003
Hospital Management

Identify currently admitted patients, room/bed occupancy, frequent diagnoses

Calculate hospital and departmental revenue; analyze average bill per department/gender

Track admissions per department/month/day; monitor insurance provider trends

List patients with unpaid/pending bills, and summarize payment status totals

List patients with unpaid/pending bills, and summarize payment status totals

Analyze stay duration per department and room utilization rates

SQLStored ProceduresIndexing
🐙 View Code
SQL · 002
Movie streaming

Top watched movies/TV shows and trending titles by region

Genre and device usage analytics

User-level metrics: average watch time, completion rate, activity, ratings

Engagement comparison across subscription types

Region-wise and daily viewing trends

Inactive user detection for retention campaigns

SQLStored ProceduresIndexing
🐙 View Code
📊
Power BI Projects
Interactive dashboards, DAX measures, automated data refresh
POWER BI · 001
Sales Automation Dashboard

Automated data refresh and report generation workflows.

Saved approximately 5 hours per week in operational reporting.

Built interactive dashboards with drill-down capabilities.

Power BIDAXPower Query
🐙 View Code
POWER BI · 002
HR Analytics Dashboard

Created HR KPI dashboard tracking headcount, attrition & salary bands.

Used DAX time intelligence for YoY comparison metrics.

Enabled HR team to reduce reporting time by 3 hours/week.

Power BIDAXHR Analytics
🐙 View Code
📗
Excel Projects
Advanced Excel — Pivot Tables, VLOOKUP, Dashboards, Macros
EXCEL · 001
Financial Budget Tracker

Built a dynamic budget vs actual tracker using Pivot Tables.

Used conditional formatting to highlight variances automatically.

Created monthly summary charts for quick executive review.

ExcelPivot TablesCharts
🐙 View Code
EXCEL · 002
Sales Performance Dashboard

Interactive Excel dashboard with slicers and dynamic charts.

Used VLOOKUP, INDEX-MATCH for multi-sheet data consolidation.

Automated monthly reports using Excel Macros (VBA).

ExcelVBAVLOOKUPSlicers
🐙 View Code

Experience & Internships

Data Analyst — Indian Institute of Training for Software and Computing Lab
OCTOBER 2024 – PRESENT
📍 IITSCL · GTB NAGAR

• Collected, cleaned, and analyzed large datasets using Excel, SQL, and Python (Pandas, NumPy) to extract actionable insights.

• Designed and maintained Power BI dashboards, improving business data visibility and reporting efficiency by 40%.

• Performed data validation and integrity checks across multiple sources, ensuring 98% reporting accuracy.

My Education

🎓
Bachelor of Science (BSC)
Babasaheb Bhimrao Ambedkar Bihar University (BRABU)
Graduation - 2023 · New Delhi, India

Certifications & Courses

🏅
Data Analytics Certification
Issuing Organisation · Year
View Certificate →

Let's Connect

I'm open to Data Analyst roles, freelance projects, and collaborations. Whether you have a project idea or just want to talk data — feel free to reach out!

📨 Send a Message

✏️ Edit Portfolio

How to use: Edit any field below and click Save Changes. Changes save to your browser. To make permanent changes, open this HTML file in Notepad/VS Code and use Ctrl+F to find the text you want to replace.
👤 Personal Info
🔗 Links
📊 Hero Stats
💼 Experience
🎓 Education
🏅 Certification
📊Project Demo