Logistics and Supply chain is the crucial part for the companies across E-commerce, FMCG, manufacturing, retail and many such domains. These companies depend heavily on efficient logistics and supply chain professionals to make their products and services available to customers. Henceforth, the demand for trained logistics and supply chain professionals is increasing day by day.Logistics and Supply Chain Management Education covers a wide spectrum of topic including transportation management, lean chain, strategic sourcing, warehousing, and performance-based logistics, constraints management, supply chain network design, and demand management.

CERTIFICATE IN LOGISTICS AND SUPPLY CHAIN MANAGEMENT

This course is part of the Microsoft Power BI Data Analyst Professional CertificateWhen you enroll in this course, you'll also be enrolled in this Professional Certificate.<ul><li>Learn new concepts from industry experts</li><li>Gain a foundational understanding of a subject or tool</li><li>Develop job-relevant skills with hands-on projects</li><li>Earn a shareable career certificate from Microsoft</li></ul>

Preparing Data for Analysis with Microsoft Excel

This course is available as part of multiple programsWhen you enroll in this course, you'll also be asked to select a specific program.<ul><li>Learn new concepts from industry experts</li><li>Gain a foundational understanding of a subject or tool</li><li>Develop job-relevant skills with hands-on projects</li><li>Earn a shareable career certificate</li></ul>

Python for Data Science, AI & Development

Bachelor of Technology

Civil Engineering

Diploma

<ul><li>Managed logistics operations, floor operations, and manpower training.</li><li>Conducted data analysis to identify and resolve bottlenecks in supply chain workflows.</li><li>Streamlined inventory and warehouse management processes to improve operational efficiency.</li><li>Resolved shipment issues and optimized delivery timelines.</li><li>Implemented cost-effective strategies, reducing operational expenses by optimizing resources.</li></ul>

Supply Chain/Logistics

DC Operations

India

🚀 Data Science Enthusiast | Logistics & Supply Chain Analyst
📊 Skilled in Python, SQL, Power BI, Excel | Data-Driven Problem Solver
🎓 Professional Certificate in Data Science, Newton School 
📦 Ex-Team Lead at Delhivery | Optimized Supply Chain & Operations
🎯 Passionate about turning data into insights & driving efficiency

Project OverviewAs a data analyst for the Chinook music store, I performed a comprehensive analysis of customer behaviour and sales patterns to drive a data-informed strategy for the physical record market. The objective was to transform raw SQL data into actionable business intelligence to optimise inventory and increase customer retention.Key Responsibilities &amp; Execution<ul><li>Data Extraction &amp; Cleaning: Wrote complex SQL queries utilizing multi-table JOINs, CTEs, and window functions to aggregate sales data from the Chinook database.</li><li>Customer Behaviour Analysis: Segmented customers by lifetime value (LTV) and geographic location to identify high-growth markets.</li><li>Product Performance: Analysed sales trends by genre, artist, and media type to determine which physical formats (CDs vs. vinyl/digital) yielded the highest profit margins.</li><li>Visual Reporting: Designed a dynamic dashboard (simulated) to visualise month-over-month growth and seasonal sales spikes.</li></ul>Strategic Insights &amp; Impact<ul><li>Inventory Optimisation: Identified that rock and Latin genres accounted for over 50% of total revenue, leading to a recommendation to prioritise warehouse space for these categories.</li><li>Churn Mitigation: Developed a list of "At-Risk" customers who hadn't purchased in 6+ months for targeted re-engagement campaigns.</li><li>Market Expansion: Discovered untapped sales potential in the USA and Brazil, recommending localised promotional events to capitalise on high average order values in these regions.</li></ul>Tools Used<ul><li>Database: SQLite / PostgreSQL (Chinook Database)</li><li>Language: SQL</li><li>Concepts: Data Aggregation, Cohort Analysis, Business Strategy, Trend Forecasting</li></ul> &nbsp;

Chinook Music Store (MySQL-Joins, Aggregations, Subqueries)

<ul><li>Project Description</li><li>Architected an end-to-end analytical framework to evaluate the performance of a high-volume IT Service Desk. By processing a dataset of 97,000+ support tickets, I identified critical bottlenecks in the resolution lifecycle and provided a data-backed roadmap to optimize resource allocation and agent training.</li><li>Key Achievements</li><li>Scalable Data Engineering: Leveraged Power Query to clean and transform 97k+ rows of raw ticket logs, automating the ETL process to ensure real-time accuracy for monthly reporting.</li><li>Operational Efficiency: Designed and implemented dynamic KPI Dashboards in Excel, providing visibility into Mean Time to Resolve (MTTR) and First Response Time (FRT), which drove a 35% increase in operational oversight.</li><li>Cost Optimization: Conducted a deep-dive "Root Cause Analysis" on recurring technical issues, leading to process improvement recommendations projected to lower operational costs by 15-20% through reduced ticket escalations.</li><li>Agent Performance Modeling: Developed a weighted scoring system to evaluate agent productivity against SLA targets, identifying specific training gaps in high-complexity categories.</li><li>Technical Deep-Dive</li><li>Power Query: Used for data merging, conditional formatting, and time-duration calculations (Business Hours vs. Clock Hours).</li><li>Statistical Analysis: Applied trend analysis to identify peak ticket volume periods, enabling better staff shift scheduling.</li><li>Presentation: Synthesized complex technical findings into a PowerPoint Executive Deck for leadership, focusing on ROI and strategic growth.</li></ul>

Md Golam SarwarIndia

Social Accounts

Achievements

Projects

Chinook Music Store (MySQL-Joins, Aggregations, Subqueries)

Enterprise IT Support Operations Analysis

Experience

DC Operations

Education

Maulana Abul Kalam Azad University of Technology, West Bengal

RPBM Jiaganj College Of Engineering & Technology

Certificates

CERTIFICATE IN LOGISTICS AND SUPPLY CHAIN MANAGEMENT

Preparing Data for Analysis with Microsoft Excel

Python for Data Science, AI & Development

Skills