Back to Developers
Md. Shadab Alam

Md. Shadab Alam

Data Analyst

Bangalore, India 3+ yrs exp 87 ยท Excellent

About

Data Analyst with 3+ years of experience in data analysis, SQL, Python, ETL automation, data visualization, and business reporting. Experienced in building automated data pipelines, integrating data from multiple APIs and sources, and transforming large datasets into actionable insights. Skilled in SQL, Python (Pandas, NumPy), Tableau, Power BI, Excel, PostgreSQL, AWS, data validation, KPI reporting, and dashboard development. Proven ability to automate reporting processes, reduce manual effort by up to 70%, save 40+ hours per week, and deliver data-driven insights that improve operational efficiency and business decision-making.

Skills & Expertise (27)

Python Advanced
8.4/10
3
Years Exp
Pandas Advanced
8.0/10
3
Years Exp
SQL Advanced
8.0/10
3
Years Exp
NumPy Advanced
7.8/10
3
Years Exp
Statistical Analysis Intermediate
7.4/10
3
Years Exp
Postgresql Intermediate
7.4/10
3
Years Exp
ETL Pipelines Intermediate
7.4/10
3
Years Exp
AWS Athena Intermediate
7.0/10
3
Years Exp
AWS S3 Intermediate
7.0/10
3
Years Exp
Data Extraction Intermediate
7.0/10
3
Years Exp
Web Scraping Intermediate
7.0/10
3
Years Exp
Dashboard Development Intermediate
7.0/10
3
Years Exp
Google Sheets Intermediate
7.0/10
3
Years Exp
Excel Intermediate
7.0/10
3
Years Exp
Tableau Intermediate
7.0/10
3
Years Exp
Joins Intermediate
7.0/10
3
Years Exp
Data Transformation Intermediate
7.0/10
3
Years Exp
Data Cleaning Intermediate
7.0/10
3
Years Exp
Power BI Intermediate
6.8/10
3
Years Exp
Metabase Intermediate
6.8/10
3
Years Exp
Subqueries Intermediate
6.8/10
3
Years Exp
KPI Reporting Intermediate
6.8/10
3
Years Exp
Window Functions Intermediate
6.8/10
3
Years Exp
CTEs Intermediate
6.8/10
3
Years Exp
Database Management Intermediate
6.0/10
3
Years Exp
Data Modeling Intermediate
6.0/10
3
Years Exp
Data Warehousing Intermediate
6.0/10
3
Years Exp

Work Experience

Data Analyst

BrownRice Capital

Apr 2026 - Present

Automated daily PnL reporting workflows using Python, Metabase, and Google Sheets, providing trading teams with timely visibility into position performance and reducing manual reporting effort by 30%. Analyzed daily trading losses and PnL discrepancies, performing root-cause analysis across price movements, execution delays, and trading inefficiencies, contributing to an approximately 25% improvement in trading profitability. Built automated Python ETL pipelines integrating Binance, Bybit, Gate.io, and KuCoin APIs to collect and process hourly cryptocurrency OHLCV and volume data, storing transformed datasets in AWS S3, Athena, and PostgreSQL. Developed SMA, EMA, and volatility-based analytics to evaluate exchange performance and identify optimal hedging opportunities by trading symbol, with automated reporting through Slack. Engineered a spot-market monitoring system integrating hourly volume data from Binance, Gate.io, KuCoin, CoinDCX, CoinSwitch, and InfluxDB, using a weighted scoring model to rank high-performing coins.

Data Analyst

PYOR

Oct 2023 - Mar 2026

Architected a data collection and analysis framework using custom scraping scripts for on-chain and market data, providing a leading venture capital client with foundational intelligence for investment decisions. Engineered a data extraction process using SQL (Dune Analytics), the Dune API, and Python to harvest and analyze on-chain datasets for metrics such as user growth and TVL. Developed a system to aggregate market data from 8+ sources via custom Python (Pandas, cURL, API) web scrapers, achieving a 70% reduction in manual effort and saving 40 hours per week. Automated delivery of key performance metrics via Google Sheets integration, creating dynamic dashboards that streamlined stakeholder reporting.

Quality Inspection Engineer

IXAR

Sep 2021 - May 2022

Calibrated NDT equipment and executed inspections for quality control, following stringent safety and testing protocols to detect material discontinuities.

Education

Data Analytics Program - Masai School

2022 - 2023 ยท Afghanistan

Bachelor of Technology (B.Tech) โ€“ Mechanical Engineering - Biju Patnaik University of Technology

2016 - 2020 ยท Afghanistan

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

๐Ÿ“ท Photo 10/10
๐Ÿ“„ Resume 10/10
๐Ÿ’ผ Job Title 10/10
โœ๏ธ Bio 10/10
๐Ÿ› ๏ธ Skills 20/20
๐ŸŽ“ Education 10/10
โฑ๏ธ Experience 12/15
๐Ÿ’ฐ Rate 0/5
๐Ÿ† Certs 0/5
โœ… Verified 5/5
Total Score 87/100

Profile Overview

Member sinceOct 2026