Mahfuj A

Business Analyst

Jun 2024 - Mar 2026 • 1 yr 9 mos

Sales Trend Monitoring: Monitored weekly sales trends for client companies by analysing point-of-sale and distributor data, translating raw numbers into concise insight reports that guided inventory and marketing decisions. Resource Utilisation Analysis: Compared current period sales against prior-quarter and year-ago benchmarks to flag declining SKUs, under-utilised regions, and resource misallocation — directly helping clients stop unnecessary spend. Dashboard Development: Built dynamic Excel dashboards with conditional formatting and pivot tables so non-technical stakeholders could self-serve on weekly KPI updates without analyst intervention. Cross-Functional Insight Delivery: Collaborated with product and supply-chain teams to translate sales insight into procurement forecasts, reducing overstock by an estimated 15–20% for two FMCG clients. Market Insight Reports: Produced monthly competitive landscape reports covering market share shifts, new entrant activity, and pricing trends across Consumer Electronics and FMCG verticals. KPI Performance: Achieved 100% target attainment every quarter; recognised as top performer with 120% quarterly bonus.

Data Analyst

Dec 2022 - Jun 2024 • 1 yr 6 mos

Logistics Tracking System: Designed and deployed a shared Excel-based logistics tracking system for DHL, DTDC, and India Post shipments — reducing billing mismatch resolution time by ~40% and giving all departments real-time visibility. Accounts & Billing: Managed end-to-end accounts and billing operations: invoice generation, payment tracking, bank reconciliation, and vendor reconciliation with 100% accuracy across all cycles. Data Research & Profiling: Researched and profiled 100,000+ company and contact records across 10+ Technology and Consumer Durables sectors, maintaining verified, structured datasets used by senior analysts. Process Automation: Automated outreach tracking and operational reporting workflows in Advanced Excel, cutting team manual effort by ~30%. M&A Integration: Delivered all critical milestones during the GfK–NielsenIQ merger with zero disruption to logistics, research, and client operations.

Financial Analyst – Equity Research

Mar 2021 - Nov 2022 • 1 yr 8 mos

Equity Research: Conducted fundamental equity research on listed companies across the Retail, Renewable Energy, and Manufacturing sectors, producing investment-grade reports with valuation models (DCF, P/E, EV/EBITDA). Financial Modelling: Sourced and analysed financial data from Bloomberg, BSE/NSE filings, MCA records, and company annual reports to build detailed financial models tracking revenue, margins, debt, and cash flow. Sector Analysis: Prepared comparative industry analyses and sector reports to identify re-rating candidates and risk factors, and shared with senior management to inform portfolio decision-making. Bookkeeping & Accounts: Maintained bookkeeping records, prepared journal entries, and reconciled monthly ledgers, ensuring 100% accuracy in financial statements. Payroll Management: Coordinated payroll processing for 50+ employees, verifying attendance, computing overtime, and ensuring timely disbursement in compliance with statutory requirements.