ANALYTICS
Data Analytics & Engineering·ICFAI Tech

Data Analyst · Analytics Engineer · ML Practitioner

Avneesh

Kumar.

I build real-time data pipelines, interactive BI dashboards, and graph anomaly detection platforms. Transforming high-velocity, complex data into actionable intelligence and explainable machine learning models.

Avneesh Kumar
Avneesh KumarICFAI Tech
Hyderabad, India·dev.avneeshkumar@gmail.com
SCROLL TO EXPLORE
Technical Stack & Tools
SQL (PostgreSQL / MySQL)Python (Pandas / NumPy)Power BI & DAXNeo4j & CypherAnomaly DetectionETL PipelinesScikit-learnSHAP ExplainabilityGraph AnalyticsFastAPINext.js & ReactSupabaseReal-Time WebSocketsDockerSQL (PostgreSQL / MySQL)Python (Pandas / NumPy)Power BI & DAXNeo4j & CypherAnomaly DetectionETL PipelinesScikit-learnSHAP ExplainabilityGraph AnalyticsFastAPINext.js & ReactSupabaseReal-Time WebSocketsDocker
Advanced Excel & PivotTablesDashboard DevelopmentRAG & Agentic WorkflowsLLM Tool-CallingMLflow & CI/CDData Modeling & Schema DesignFastify & Node.jsGit & GitHub ActionsVercel & Railway DeploymentStatistical AnalysisData VisualizationAutomated Alert PipelinesAdvanced Excel & PivotTablesDashboard DevelopmentRAG & Agentic WorkflowsLLM Tool-CallingMLflow & CI/CDData Modeling & Schema DesignFastify & Node.jsGit & GitHub ActionsVercel & Railway DeploymentStatistical AnalysisData VisualizationAutomated Alert Pipelines

01 — Professional Narrative

About
Avneesh.

[ B.SC. DATA ANALYTICS @ ICFAI TECH ]
HYDERABAD, INDIA

I am a Data Analyst and Analytics Engineer passionate about bridging the gap between raw data streams and actionable business intelligence.

Currently pursuing my Bachelor of Science in Data Analytics at ICFAI Tech (2023–2026), I combine strong statistical foundations with hands-on software engineering. I don't just build static reports; I engineer automated data pipelines, real-time ingestion backends, and machine learning systems that run continuously in production.

My work spans sports analytics (lasyly.me), Anti-Money Laundering transaction fraud detection (Sentinel), and civic anomaly monitoring (City Agent, placed 4th nationally at ByteVerse 1.0). Whether it's writing high-performance SQL window queries, building Neo4j graph traversals to unmask money mule rings, or computing SHAP explanations for predictive models, I build solutions engineered for scale and clarity.

Quick Profile Snapshot

CURRENT STATUSB.Sc. Data Analytics (ICFAI Tech)
LOCATIONHyderabad, India (Open to Remote/Relocation)
PRIMARY DOMAINSSQL · Python · Power BI · Graph ML · ETL
CONTACT CHANNELSdev.avneeshkumar@gmail.com

Core Architectural Pillars

Relational & Graph Architecture

SQL & Cypher

Designing normalized PostgreSQL schemas, query optimization, indexing, and multi-hop Neo4j Cypher traversals for entity link analysis.

Real-Time ETL & Stream Processing

Event Streams

Building resilient pipelines connecting live APIs (BALLDONTLIE, NBA API, WebSockets) with sub-2-second event processing and automatic failover.

Explainable Machine Learning

SHAP & ML

Applying supervised classification, anomaly detection algorithms, and SHAP value explainability so compliance teams understand every alert.

Executive BI & Decision Dashboards

Power BI & DAX

Crafting intuitive Power BI, Next.js, and React dashboards equipped with DAX metrics and dynamic filters for instant executive decision-making.

02 — Expertise & Tooling

Technical
Skillset.

A comprehensive toolkit spanning data engineering, statistical analysis, business intelligence, and production machine learning workflows.

Core Data Layer01

Languages & Databases

Writing performant SQL queries, stored procedures, normalized schemas, and graph traversals for high-throughput transactional and analytical workloads.

PythonSQLPostgreSQLMySQLNeo4j (Cypher)
Complex joins, CTEs, window functions, and graph cypher pattern matching.
ETL & Processing02

Data Analytics & Pipelines

End-to-end data ingestion, transformation, automated anomaly detection, and statistical profiling across streaming and batch data sources.

PandasNumPyData AnalysisData VisualizationAnomaly DetectionETL PipelinesData Cleaning
Built sub-second anomaly detection engines and multi-API aggregators.
Reporting & Decision Making03

BI & Data Visualization

Designing executive-level Power BI dashboards, DAX measures, and structured analytical models that translate complex tabular data into clear business decisions.

Power BIDAX MeasuresExcel (PivotTables, XLOOKUP, IF/IFS)Dashboard DevelopmentAnalytics DashboardsData Storytelling
Interactive AML fraud dashboards and live sports performance visuals.
Predictive Models04

Machine Learning & Graph Analytics

Supervised anomaly detection, tabular classification models, explainable AI with SHAP values, and network graph relationship extraction.

scikit-learnMachine LearningSHAP (Explainable AI)Graph AnalyticsFeature EngineeringModel Evaluation
SHAP-based transparent fraud explanations and Neo4j graph entity links.
Production Stack05

AI & Modern Engineering

Production-ready backend APIs, agentic LLM workflows, automated pipelines, Docker containerization, and continuous integration workflows.

RAG SystemsLLM Tool-CallingAgentic WorkflowsPrompt EngineeringFastAPIREST APIsDockerGit & GitHub ActionsMLflowCI/CD
Autonomous agent dispatch, FastAPI backends, and scheduled GitHub workflows.

03 — Selected Portfolio Work

Featured
Platforms.

[ PRODUCTION DATA PIPELINES & ANALYTICS ]4 Platforms Featured
PROJECT 012025 – Present

lasyly.me

Sports Analytics & Community Platform

Role: Full-Stack Developer & Data Architect

API Sources4+ Integrated
Live PipelineNear Real-Time
ArchitectureSupabase + Fastify

A high-throughput sports analytics platform that ingests real-time feeds, computes matchup confidence grades, and delivers interactive visual analytics for players and teams.

Built a live sports analytics platform integrating multiple APIs (BALLDONTLIE, Prop-Odds, nba_api, YouTube Data API v3) to collect, transform, and analyze player and game data across NBA, tennis, football, and more.

Designed a relational data model and React analytics dashboard for player-prop analysis, live trend tracking, and performance comparison.

Built an adaptive live-data pipeline using Supabase and Node.js to maintain near-real-time updates while reducing unnecessary API requests by ~70%.

Hardened the stack end-to-end (Fastify, Supabase, React Native) and deployed on a high-availability Vercel + Railway + Supabase architecture.

Technologies & Libraries Used:
ReactNode.jsSupabaseFastifyPythonPostgreSQLWebSocketsRailwayVercel
PROJECT 022026

Sentinel

AML Analytics & Anomaly Detection Platform

Role: Data Analyst & ML Engineer

Graph EngineNeo4j Cypher
ExplainabilitySHAP Values
BI LayerPower BI + FastAPI

An Anti-Money Laundering (AML) investigation platform combining SQL behavioral analytics, supervised ML classifiers, Neo4j graph relationships, and executive Power BI reporting.

Analyzed transaction and behavioral data using SQL, rule-based detection, and supervised anomaly-detection models to identify suspicious activity patterns.

Built Neo4j graph analytics to uncover relationships between entities and added SHAP-based explanations to interpret model-driven alerts for compliance audits.

Developed Power BI reporting and a FastAPI/Next.js investigation interface to surface anomalies, risk indicators, and investigation results.

Technologies & Libraries Used:
PythonSQLscikit-learnNeo4jCypherSHAPFastAPINext.jsPower BI
PROJECT 032026

City Agent

Real-Time Urban Analytics Dashboard

Role: Real-Time Systems & Analytics Lead

National Rank4th / 100+ Teams
Detection Latency<2 seconds
Data FeedsLive Stream APIs

A real-time civic intelligence platform monitoring traffic bottlenecks and environmental anomalies with sub-2s incident alerts. Placed 4th nationally at ByteVerse 1.0 (ICFAI Dehradun).

Built a real-time dashboard for traffic and civic anomaly monitoring using live API data feeds.

Engineered real-time anomaly detection pipelines processing sensor feeds with under 2-second alert generation.

Placed 4th nationally among 100+ competing teams at ByteVerse 1.0 national hackathon.

Technologies & Libraries Used:
PythonReal-Time ETLMachine LearningLive API FeedsNext.jsTelegram API
PROJECT 042025

NBA News Telegram Bot

Automated News Aggregator & Pipeline

Role: Python Automation Engineer

Intervention100% Automated
SourcesMulti-Feed Scrape
ChannelTelegram API

An automated scraping pipeline collecting NBA trade, injury, and game updates across multiple online sources with instant formatting and scheduled push notifications.

Built a Python automation tool that scrapes NBA news from multiple sources and auto-posts updates to a Telegram channel on a scheduled pipeline.

Implemented intelligent deduplication and regex-based text extraction to maintain high signal-to-noise ratio with zero manual intervention.

Technologies & Libraries Used:
PythonWeb ScrapingBeautifulSoupTelegram Bot APICron Pipelines

04 — Interactive Data Terminal

Live Query
Workbench.

Interactive playground demonstrating production queries and data transformation logic from Sentinel and lasyly.me platforms.

avneesh@analytics-node:~/production-pipelines
Context:Detecting sudden micro-structuring spikes and anomaly risk scores over rolling 60-minute transaction windows.
Query Definition: 01. AML Velocity & Anomaly Window (SQL)
WITH TransactionVelocity AS (
  SELECT 
    account_id,
    transaction_id,
    amount,
    timestamp,
    COUNT(*) OVER(
      PARTITION BY account_id 
      ORDER BY timestamp 
      RANGE BETWEEN INTERVAL '60 minutes' PRECEDING AND CURRENT ROW
    ) AS txn_velocity_60m,
    SUM(amount) OVER(
      PARTITION BY account_id 
      ORDER BY timestamp 
      RANGE BETWEEN INTERVAL '60 minutes' PRECEDING AND CURRENT ROW
    ) AS cumulative_volume_60m
  FROM public.financial_ledger
  WHERE timestamp >= NOW() - INTERVAL '24 hours'
)
SELECT 
  account_id,
  txn_velocity_60m,
  cumulative_volume_60m,
  ROUND((cumulative_volume_60m / NULLIF(txn_velocity_60m, 0)), 2) AS avg_ticket_size,
  CASE 
    WHEN txn_velocity_60m > 15 AND cumulative_volume_60m > 50000 THEN 'CRITICAL_HIGH_RISK'
    WHEN txn_velocity_60m > 8 THEN 'ELEVATED_WATCHLIST'
    ELSE 'NOMINAL'
  END AS risk_classification
FROM TransactionVelocity
WHERE txn_velocity_60m >= 5
ORDER BY cumulative_volume_60m DESC
LIMIT 5;
Status: 200 OK (Stream Active)Latency: 14.2ms
Records Processed482,910 rows
Flagged Signals2 Critical Signals
account_idtxn_velocity_60mcumulative_volavg_ticketrisk_classification
ACC_782910418$94,250.00$5,236.11CRITICAL_HIGH_RISK
ACC_992104516$78,500.00$4,906.25CRITICAL_HIGH_RISK
ACC_12048829$31,400.00$3,488.89ELEVATED_WATCHLIST
ACC_44901237$24,150.00$3,450.00ELEVATED_WATCHLIST
ACC_33091876$18,900.00$3,150.00NOMINAL
Engine: SQLOutput validated & live

05 — Experience & Education

Background &
Credentials.

Academic foundation in Data Analytics paired with practical frontend and data engineering experience.

Industry Experience

Industry ExperienceJun 2025 – Jul 2025

Frontend Developer

SkillBanc · Remote

Built and shipped mobile app UI features using Flutter and Dart, collaborating with backend and design teams on responsive, cross-platform screens and components.

Fixed UI bugs and improved app responsiveness across Android and iOS builds, ensuring consistent high-performance rendering.

FlutterDartCross-Platform UIGitREST APIs

Formal Education

B.Sc. Data Analytics2023 – 2026

Bachelor of Science, Data Analytics

ICFAI Tech · Hyderabad, India

Specialized in Statistical Analysis, Database Management Systems (SQL & NoSQL), Machine Learning, Anomaly Detection, and Big Data Processing.

Awarded academic merit scholarship for entrance test performance.

Elected Captain of the College Basketball Team.

Advanced SQL & RDBMSMachine Learning & SHAPGraph Theory & Neo4jPower BI & DAXETL Systems

06 — Honors & Leadership

Honors &
Achievements.

Recognition in national competitive hackathons, academic scholarship merit, and athletic leadership.

National Recognition · ICFAI DehradunNational 4th Place

ByteVerse 1.0 National Hackathon

Placed 4th nationally among 100+ competing engineering teams. Engineered City Agent, a real-time urban traffic and civic anomaly detection dashboard processing multi-stream sensor feeds in under 2 seconds.

Verified CredentialCV Verified
Hackathon Winner · ICFAI Tech1st Place Winner

College-Level Hackathon

Secured 1st place in intensive college hackathon by delivering an end-to-end data-driven product prototype within a strict 24-hour sprint.

Verified CredentialCV Verified
Academic Excellence · ICFAI TechScholarship Recipient

Entrance Test Merit Scholarship

Awarded competitive academic merit scholarship based on outstanding entrance examination ranking and quantitative aptitude performance.

Verified CredentialCV Verified
Athletics & Leadership · Varsity AthleticsVarsity Captain

Captain of College Basketball Team

Led the varsity basketball squad through regional tournaments, fostering communication, strategic tactical execution under pressure, and collective team resilience.

Verified CredentialCV Verified
LET'S CONNECT

07 — Get In Touch

Let's Build Data
Intelligence.

I am actively seeking Data Analyst and Analytics Engineering opportunities. Whether you have a role opening, an interesting data pipeline challenge, or a hackathon project, let's talk.

PHONE & WHATSAPP

Send a Direct Message

Fill this out to shoot me an email directly.