About
Highly analytical and detail-oriented Data Analyst with a strong foundation in SQL, Python, Power BI, and statistical analysis, currently pursuing a BSc in Food Engineering. Proven ability to translate complex data into actionable insights, as demonstrated by projects that drove 137% revenue growth, optimized gross margins by 5-7%, and enhanced customer retention through advanced segmentation and clustering techniques.
Work
E-Commerce Site Customer Clustering Project
|Data Analyst
Dhaka, Dhaka, Bangladesh
→
Summary
Applied K-Means clustering on e-commerce data to identify 5 distinct customer segments and propose targeted strategies.
Highlights
Implemented K-Means clustering on e-commerce data, uncovering 5 distinct customer segments based on their order behavior.
Identified critical segments such as high-value free users, low-spending trial users, premium customers, and lifetime buyers with low satisfaction ratings.
Developed data-driven strategies to upsell free users, enhance retention for top spenders, and improve satisfaction for lifetime customers.
FMCG Performance Analysis Project
|Data Analyst
Dhaka, Dhaka, Bangladesh
→
Summary
Developed a Power BI dashboard with 7 datasets and 10,000+ sales records to analyze FMCG performance across 4 regions.
Highlights
Developed an interactive Power BI dashboard utilizing a star schema with 7 datasets and over 10,000 sales records to analyze 2 years of FMCG performance across 4 regions.
Identified a 22.2% Year-over-Year sales drop despite a 6.1% order growth, revealing a shrinking basket size.
Provided strategic recommendations to enhance customer loyalty in Dhaka (addressing a 3% gap), introduce high-revenue personal care items, and optimize online channel offerings.
Customer RFM Segmentation Project
|Data Analyst
Dhaka, Dhaka, Bangladesh
→
Summary
Performed RFM (Recency, Frequency, Monetary) segmentation on over 2800 car sales records using MySQL to enable targeted marketing strategies.
Highlights
Segmented over 2,800 car sales records using MySQL, classifying 90+ unique customers based on purchasing behavior.
Computed Recency, Frequency, and Monetary scores to group customers into distinct segments.
Identified key customer segments, including 35% Champions and 16% Churned, to inform data-driven marketing and retention strategies.
Electronics Company Sales and Finance Analysis Project
|Data Analyst
Dhaka, Dhaka, Bangladesh
→
Summary
Analyzed 3 years of electronics sales data to identify revenue growth, GM% trends, and optimize retail channels and pricing strategies.
Highlights
Analyzed 3 years of sales data (2019-2021) using Excel Power Pivot, identifying a 137% revenue growth and a 12% gross margin decline in 2021.
Identified that a single retail channel drove over 70% of sales with the lowest gross margin, while new products contributed 52.9% to 2021 sales.
Proposed strategic recommendations, including pricing resets, Europe market expansion, and channel optimization, projected to recover 5-7% gross margin.
Education
Shahjalal University of Science and Technology
→
BSc
Food Engineering
Certificates
Data Analytics and BI Career Path
Issued By
Interactive Cares
SQL (Advanced)
Issued By
Hacker Rank
Skills
Programming Languages
Python, SQL.
Data Visualization
Power BI, Tableau, Matplotlib, Seaborn, Metabase.
Statistical Analysis
A/B Testing, Regression Analysis, Forecasting, K-means clustering, Cohort analysis.
Cloud Platforms
Google Cloud Platform (GCP).
Data Warehousing
Snowflake, Google Bigquery, MySQL.
Data Processing & ETL
Pandas, NumPy, DBT.
References
Md. Shabbir Hossain Bhuiyea
Senior Business Intelligence Analyst, Reverse Retail GmbH, German Retail Company. Ex-Lecturer of Statistics, Daffodil International University. Ex-Data Scientist Team Lead, DOER & Cellescope Limited. Contact: +8801684796261 (Mobile), shabbir.sust.ds@gmail.com (Email)