Skip to content
View 1hirachy's full-sized avatar

Block or report 1hirachy

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please donโ€™t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this userโ€™s behavior. Learn more about reporting abuse.

Report abuse
1hirachy/README.md

Hi ๐Ÿ‘‹ I'm Md Chowdhury

Data Analyst Portfolio

Welcome!

This repository showcases my journey from Senior Software Development Engineer in Test (SDET) to Data Analyst, demonstrating expertise in SQL, Python, Power BI, ETL, cloud analytics, and business intelligence.


About Me

I have over 10 years of experience designing enterprise software solutions across Finance, Insurance, Healthcare, Education, and Entertainment industries.

While my background is in software quality engineering, I have transitioned into Data Analytics, where I leverage my expertise in SQL, Python, ETL, and cloud platforms to analyze data, build dashboards, and deliver actionable business insights.


Technical Skills

Analytics

  • SQL
  • Python
  • Power BI
  • Excel
  • Statistics
  • Data Cleaning
  • Data Visualization
  • Business Intelligence

Data Engineering

  • Databricks
  • Spark
  • AWS
  • ETL
  • Snowflake
  • Redshift

Databases

  • SQL Server
  • PostgreSQL
  • Oracle
  • MySQL

๐Ÿ“‚ Data Analytics Projects

Project Tools Description
๐Ÿ” FoodHub Analysis Python, Pandas, Matplotlib, Seaborn Exploratory Data Analysis (EDA), customer behavior analysis, order trends, and data visualization dashboard
๐Ÿš— New Wheels Vehicle Analytics SQL, PostgreSQL Customer insights, vehicle preference analysis, sales trend analysis, KPI reporting, and business recommendations
๐Ÿ“Š Power BI Business Dashboard Power BI, DAX, Data Modeling Interactive dashboards, data transformation, KPI tracking, and business intelligence reporting
๐Ÿ“‰ Customer Churn Analysis Python, Pandas, Scikit-learn Customer retention analysis, churn pattern identification, feature analysis, and predictive insights
๐Ÿ’ฐ Retail Sales Analytics SQL, Python, Pandas Sales performance analysis, revenue trends, customer segmentation, and actionable business insights

Portfolio Highlights

SQL

  • Window Functions
  • CTEs
  • Stored Procedures
  • Ranking
  • Query Optimization

Python

  • Pandas
  • NumPy
  • Matplotlib
  • Seaborn

Power BI

  • Data Modeling
  • DAX
  • Power Query
  • KPI Dashboard
  • Interactive Reports

Business Intelligence

  • Executive Dashboards
  • Customer Analytics
  • Sales Analytics
  • Forecasting

Certifications

  • Google Data Analytics (In Progress)
  • Microsoft Power BI (In Progress)
  • AWS
  • Databricks

๐Ÿ“ซ How to Reach Me:

LinkedIn: www.linkedin.com/in/md-z-chowdhury

Email: md.z.haque.chowdhury@gmail.com


๐Ÿ’ป Tech Stack

๐Ÿ“Š Data Analytics & Visualization

Python SQL Pandas NumPy Matplotlib Seaborn Power BI Excel

๐Ÿ—„๏ธ Databases & Data Warehousing

PostgreSQL Oracle MySQL MongoDB Snowflake Amazon Redshift

โ˜๏ธ Cloud & Big Data Technologies

AWS Amazon S3 AWS Athena AWS Glue Databricks Apache Spark PySpark Apache Airflow Apache Kafka

๐Ÿงฎ Data Engineering & ETL

ETL Delta Lake Data Modeling Data Quality

๐Ÿงช Automation & Software Engineering Background

Java Selenium REST API Karate JUnit Maven

๐Ÿ”ง DevOps & Collaboration

GitHub GitHub Actions Jenkins Docker Jira Confluence

Pinned Loading

  1. Elevator_System_Design Elevator_System_Design Public

    Java

  2. FoodHub-Data_Analysis FoodHub-Data_Analysis Public

    Jupyter Notebook

  3. New_Wheels_SQL New_Wheels_SQL Public

  4. ToDo-List-library ToDo-List-library Public

    Java