🎉 6 Projects Complete — Open to Roles

Akash Pathak

Data Analyst

I transform messy datasets into clear business decisions. Specialized in FinTech, BFSI, Fraud & Product Analytics — with full-stack pipelines: SQL → Python → Power BI → Live Dashboards.

SQLPython Power BIMachine Learning EDAFraud Detection RFM AnalysisFinTech DAXCohort Analysis Scikit-learnBlockchain
🐙 GitHub Profile 📂 Browse Projects ↓
Scroll to explore
0
Projects Complete
5 / 5
Live on GitHub
₹30Cr+
Data Analyzed
0
Rows Processed
0
ML Models
98.14%
Best AUC-ROC

📂 Portfolio Projects

6 of 6 Complete ✅
01
🏦
FinTech Transaction Analytics
Banking & Payments · Full-Stack Analytics

End-to-end pipeline on 15,000 payment transactions — KPIs, MoM trends, merchant intelligence, RFM segmentation, fraud signals, and a live Flask dashboard with 12 REST APIs.

  • 🔴 Identified ₹1.45Cr at-risk volume via 3 fraud signal detectors
  • 👥 RFM segmented 2,982 users → Champion · Loyal · At Risk · Dormant
  • 📈 30+ SQL queries — Window Functions, CTEs, Cohort Retention
  • 📊 9-panel dark dashboard · 12 REST API endpoints · all 200 OK
SQLPythonPower BI FlaskRFMFraud DetectionPandas
02
🛡️
Credit Card Fraud Detection
Risk & Fraud · Machine Learning

ML pipeline on 50,000 transactions with extreme class imbalance (0.174% fraud). 4 models trained and benchmarked — Random Forest achieves 98.14% AUC-ROC.

  • 🤖 Random Forest → 98.14% AUC-ROC (best model)
  • ⚖️ Handled imbalance via class_weight="balanced"
  • 🔍 Feature engineering: log(Amount), Amt_Z, Hour
  • 🚨 3 SQL fraud rules: Probe, Velocity, Composite Risk Score
PythonScikit-learnRandom Forest Isolation ForestROC-AUCFlask
03
🛒
Customer & Sales Analytics
Retail / CRM · Business Intelligence

Full customer analytics pipeline on 50,000 customers & 200,000 orders (₹69.7Cr revenue) — RFM segmentation, cohort retention, LTV modeling, churn prediction.

  • 👥 KMeans RFM → Champion · Loyal · At Risk · Dormant
  • 🔄 12-cohort × 6-month retention heatmap — Month 3 critical drop-off
  • 💰 LTV analysis by segment, city, channel & age group
  • 📊 10 dark-theme charts · 12 API endpoints · all 200 OK
SQLPythonKMeans CohortLTVFlask
04
📊
Finance / MIS Dashboard
Corporate Finance · CFO Reporting

CFO-level MIS across 24 months & 8 departments — P&L waterfall, EBITDA bridge, budget variance RAG status, cash flow analysis & YoY comparison.

  • 💰 FY2024 Revenue ₹13.07Cr | YoY +16.9% growth
  • ⚡ EBITDA ₹1.71Cr (13.1% margin) | PAT ₹1.03Cr
  • 🎯 Budget vs Actual — RAG status for 8 departments
  • 🏛️ P&L waterfall + EBITDA bridge + 12 financial charts
ExcelPower BIDAX P&LEBITDAFlask
05
Crypto & Payment Analytics
Blockchain · Web3 · DeFi Analytics

On-chain analytics across 6 blockchains · 500K transactions · $2.33B volume — OHLCV price action, whale detection, wallet segmentation, DeFi TVL & cross-chain correlation.

  • ₿ 6-chain OHLCV + BTC candlestick chart (365 days)
  • 🐋 1,500 whale txns detected — disproportionate volume control
  • 🔗 Cross-chain correlation matrix across 6 networks
  • 🏦 DeFi TVL tracked across 8 protocols ($25B+ ecosystem)
PythonBlockchainDeFi Whale DetectionOHLCVFlask
06
🚀
CareerPilot AI — Job Search Platform
AI · Full-Stack · Career Tech · Flask · SPA

End-to-end AI job-search platform: resume import → AI analysis (7 scores) → ATS optimization → job matching (1-100) → cover letter generation → full application tracking with CSV export.

  • 🔍 AI resume analysis — ATS, skills, quantification, keywords, formatting scores
  • 🎯 Job matching 1-100 — skill overlap, title similarity, experience relevance
  • ✍️ Company-specific cover letters — generated from resume only, no fabrication
  • 📋 Application tracker — Saved → Applied → Interview → Offer → CSV export
PythonFlaskAI/NLP ATSREST APISPA

🛠️ Tech Stack

Skills
Databases & Query
MySQL / PostgreSQLAdvanced
Window Functions · CTEsExpert
MS SQL ServerProficient
Python Ecosystem
Pandas / NumPyExpert
Scikit-learn · MLProficient
Matplotlib · SeabornAdvanced
Visualization & BI
Power BI + DAXAdvanced
TableauProficient
Excel (Pivot · VBA)Advanced
Analytics
RFM · Cohort · LTVExpert
EDA · StorytellingExpert
Fraud · Anomaly DetectAdvanced

🔥 What Makes Me Different

Mindset
🎯
Business-First Thinking
I frame the business problem before opening a dataset. Every analysis starts with a question that matters to a decision-maker.
🔗
Full-Stack Analytics
Every project: SQL + Python + Dashboard — a complete pipeline. Not just isolated scripts or charts.
💬
Stakeholder-Ready Insights
Insights written for CFOs, PMs, and business teams — not just data reviewers. Clarity over complexity, always.
🏗️
Production-Grade Code
Flask REST APIs, modular Python, clean SQL with Window Functions & CTEs — code that actually runs.

🏅 Certifications

Verified
Google Data Analytics Professional
Coursera / Google · 2024
Certified
Power BI Data Analyst PL-300
Microsoft · 2024
Certified
SQL — Gold Badge
HackerRank
Gold
Python for Data Science
IBM / Coursera
Certified

💬 Let's Build Something Together

Open to Data Analyst roles · Collaborations · Freelance Analytics Projects · India & Remote