Skip to content
View goshamishagar's full-sized avatar

Block or report goshamishagar

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
goshamishagar/README.md

Hi there, I'm Shagar Goshami πŸ‘‹

Sales Operations & MIS Executive | FMCG | Power BI | Advanced Excel | SFA/DMS

πŸ“ Dhaka, Bangladesh Β |Β  πŸ“§ shagorgoshami@gmail.com Β |Β  πŸ”— linkedin.com/in/shagar-goshami


πŸ§‘β€πŸ’Ό About Me

Results-driven Sales Operations & MIS professional with 4+ years of progressive experience in Bangladesh's FMCG sector. I specialize in building KPI dashboards, optimizing SFA/ERP systems, and driving cross-functional reporting that empowers sales leadership at regional and national levels. From distributor operations to incentive data validation, I turn raw sales data into actionable decisions β€” accurately and on time.


πŸ› οΈ Technical Skills

πŸ“Š Data & Analytics

Power BI Power Query Advanced Excel XLOOKUP SUMPRODUCT INDEX-MATCH Pivot Tables

πŸͺ Sales Systems

SFA DMS ERP

πŸ“ˆ Reporting & Analytics

KPI Dashboards MIS Reporting Data Validation Performance Analytics

πŸ’Ό Productivity

Microsoft Word PowerPoint Teams


πŸ’Ό Professional Experience

🏒 Company 🎯 Role πŸ“… Duration
Emami Bangladesh Ltd. Executive – Sales Operations Feb 2026 – Present
IDC PLC (MARS Portfolio – Snickers, Mars, Bounty, M&Ms) Executive – Sales Operations Oct 2024 – Jan 2026
Unilever Bangladesh Ltd. Regional MIS Officer Apr 2022 – Sep 2024

πŸ† Key Achievements

  • ⚑ 30% faster reporting β€” Re-engineered MIS reporting workflows at Emami Bangladesh using Power Query automation, cutting weekly turnaround time and eliminating manual consolidation errors
  • πŸ“Š Nationwide KPI visibility β€” Built and maintained end-to-end Power BI dashboards at IDC PLC consolidating real-time SFA & ERP data for sales leadership across Bangladesh
  • 🀝 Smoother distributor ops β€” Streamlined full-cycle distributor onboarding and settlement workflows at IDC PLC through standardized documentation and cross-team coordination, supporting 100+ distributors

πŸ—‚οΈ What You'll Find Here

This GitHub is home to practical tools I've built for FMCG Sales Operations & MIS work:

  • πŸ“‚ Excel Automation Templates β€” Ready-to-use models with Power Query, XLOOKUP, SUMIFS & Pivot Tables
  • πŸ”„ Power Query Scripts β€” Automated data consolidation and transformation workflows
  • πŸ“Š Power BI Templates β€” KPI dashboard layouts for sales performance monitoring
  • πŸ“‹ MIS Reporting Utilities β€” Secondary/primary sales trackers, territory scorecards, and beat plan tools

All resources are built from real-world FMCG experience β€” practical, clean, and ready to adapt.


🌐 Core Competencies

Sales Performance Analytics Β β€’Β  KPI Dashboard Development Β β€’Β  Distributor Operations Management Secondary & Primary Sales Tracking Β β€’Β  Territory & Beat Plan Analysis Β β€’Β  Route-to-Market (RTM) Support Outlet Universe & SKU Monitoring Β β€’Β  DMS & Stock Reconciliation Β β€’Β  Incentive & Payroll Data Validation


πŸ“¬ Let's Connect

I'm open to collaboration, knowledge exchange, and professional connections β€” especially in the areas of FMCG Sales Operations, MIS, and data-driven reporting.

LinkedIn Email


"Turning data into decisions β€” one dashboard at a time."

Popular repositories Loading

  1. Bangladesh-Administrative-Data Bangladesh-Administrative-Data Public

    Comprehensive upazila-wise and police thana-wise data for Bangladesh β€” demographics, health, education, infrastructure, crime, and more

    15

  2. goshamishagar goshamishagar Public

    1

  3. BWIW-Sales-Dashboard BWIW-Sales-Dashboard Public

    Interactive FMCG Sales Intelligence Dashboard

    HTML

  4. Market-Return-Analysis Market-Return-Analysis Public

    Interactive FY Market Return & Damage Settlement Dashboard β€” built with HTML, Chart.js and SheetJS

  5. Sales-Deshboard_v9 Sales-Deshboard_v9 Public

    Sales Intelligence Dashboard β€” Interactive HTML with Excel upload

    HTML

  6. Bangladesh_thana_dataset_for_FMGC Bangladesh_thana_dataset_for_FMGC Public

    Bangladesh thana-level population, economic activity & FMCG consumer profile dataset

    Python