SQL & Data Engineering
PostgreSQL, MySQL, and Snowflake SQL — database design, joins, window functions, stored procedures, and production-style ETL pipelines built without Python or Airflow.
Open to opportunities
Hi, I'm Shaharier
Data Engineer & Analyst — SQL, Python, ETL pipelines and cloud warehousing. Transitioning from Textile Engineering to build robust, scalable data infrastructure.
3+
Data projects
116K+
Records processed
2+
Years merchandising
New Era Cap · Product Coordinator
What I do
Core strengths
Analytics & Power BI
End-to-end dashboards from raw, fragmented data — Power Query cleaning, DAX measures, and multi-page interactive reports built for real business decisions.
Product Coordination
Cross-functional coordination across Sales, Design, Sourcing and Finance for global apparel brands — SAP workflows, vendor communication, and sampling management.
Portfolio
Selected work
Analytics
Power BI
MySQL
Olist Brazilian E-Commerce Analytics
A complete end-to-end case study on 100,000+ orders across 9 relational tables. Cleaned and merged fragmented CSVs into a 112K-row fact table, wrote 8 SQL analysis queries plus window functions, and built a 3-page interactive Power BI dashboard.
Key finding: $13.77M in revenue with 93.21% on-time delivery — but a stark north-south logistics gap where negative reviews track directly with late deliveries rather than product quality.
Retail
SQL Server
Retail Sales Performance Analytics
Superstore dataset analysis uncovering that 36% of all orders were loss-making — despite $2.27M in revenue. Root cause: discounts above 30% averaged a -40.6% margin.
View case study →
ETL Pipeline
PostgreSQL
Automated SQL ETL Pipeline
100% PostgreSQL pipeline processing 116,000+ real bank transaction records — cleaning, deduplication, audit logging, and pgAgent-scheduled automation. No Python, no Airflow.
View case study →
About me
A bit about
who I am
Businesses run on data, but raw numbers don't solve problems — the systems behind them do. I'm a Data Analyst and aspiring Data Engineer focused on turning messy information into clean, reliable pipelines that drive real business decisions.
I currently work as a Product Coordinator at New Era Cap (ANZ Lifestyle Business Unit), coordinating across Sales, Finance, Design, and Sourcing. Before that, I worked in Merchandising at Dekko ISHO Group on Ralph Lauren accounts. In parallel, I'm building SQL-first data engineering skills — PostgreSQL, Power BI, and cloud warehousing — with a BSc in Textile Engineering & Management (CGPA 3.93/4.00) from BGMEA University of Fashion & Technology as my foundation.
Stack & tools
SQL / PostgreSQL
Snowflake SQL
Power BI & DAX
Python
Excel / VBA
SAP GUI
Power Query
Git
Background
Education & leadership
2021 – 2025
BSc, Textile Engineering & Management
BGMEA University of Fashion & Technology (BUFT) · CGPA 3.93/4.00
Certifications
Microsoft Power BI Data Analyst Associate
Plus: Associate Data Engineer in SQL, Supply Chain Logistics, Introduction to Data Analytics, IELTS Academic 7.5 (C1)
Aug 2024 – Jan 2025
President, BUFT Debate Club
Led a 2.5-year-long journey through the club — from Sub Executive Member to Organizing Secretary to President.
2023 – 2025
Executive, TEMI Club
Textile Engineering Management & Innovation Club at BUFT.
Honors & Awards
Debate & Public Speaking
Champion in Debate Competition, Runner-Up (x2) in Debate, Runner-Up in Public Speaking.
Social proof
What clients say
"Shaharier is highly professional and passionate about his work. His commitment, dedication, and involvement are greatly appreciated. I highly recommend him and would be delighted to work with him again."
"We had a fantastic experience with Shaharier. He delivered above and beyond expectations. Looking forward to working together again!"
Journey
The Learning Log
Projects
Jan 22, 2026
Built an Automated SQL ETL Pipeline
100% PostgreSQL, no Python, no Airflow — 116,000+ real bank records, fully automated.
Read more →
Certifications
Jan 8, 2026
Completed Associate Data Engineer in SQL
Joins, database design, data warehousing, and Snowflake SQL — a full career track wrapped up.
Read more →
Learning
Feb 28, 2026
Back to learning: starting Data Engineer in Python
APIs, data cleaning, Git, ETL/ELT and Airflow — the next chapter after SQL.
Read more →Get in touch
Let's work
together
I'm open to data analyst, data engineering, and freelance SQL/Power BI opportunities. Whether it's a dashboard, a pipeline, or a full analytics build — let's talk.