Manish Dabhi | The BA Network

Projects

Telecom Product Analysis

The aim of this project was to transform manual data processes into a robust, data-driven environment using Power BI, providing real-time business insights across multiple functional areas.

Project Overview

  • Domain: Telecommunication
  • Location: Qatar (Remote)
  • Duration: 6 Months
  • Team Size: 3 Members

Tools & Technologies

  • Power BI: Dashboard development
  • SQL: Data extraction and transformation
  • MS Excel: Data cleaning and mapping
  • JIRA: Agile project management
  • OneDrive: Collaboration and documentation

Key Dashboards & KPIs Delivered

Highlighted KPIs

  • Monthly Revenue Trend
  • Inventory Turnover Ratio
  • Average Revenue Per User
  • Product Return Rate (%)
  • Product Lifecycle Stage Analysis
  • Stock Reorder Level Alerts

Additional KPIs Tracked

Conversion Rate | Aging Inventory | Contribution Margin Top/Bottom SKUs | SLA Adherence | Gross Margin per Product | Product Longevity

Impact & Quantified Results

MetricBeforeAfterImprovement
Reporting Time4-5 Hours<1 Hour⬇️ 85%
Decision-Making Time3 Days<1 Day⬇️ 70%
Reporting Accuracy~85%~99.5%⬆️ 17%
Team EngagementLow15+ Avtive UsersSignificant

Cohort-Based System Decommissioning

This project focused on systematically closing down a legacy financial system by segmenting users into well-defined cohorts.
Domain: BFSI | Location: The UK & Ireland | Duration: 8 Months | Team: 4 Members

This ensured a controlled, compliant, and customer-aligned transition.

Tools & Technologies

  • Power BI: Dashboards and progress tracking
  • SQL: Customer cohort definition & backend cleansing
  • Excel: Data audits, mappings & exception handling
  • Confluence: Documentation of plans, flows, and decisions
  • JIRA: Agile collaboration and ticket tracking
  • Microsoft Visio: Process flow and cohort journey diagrams
  • SharePoint: Repository for closure documents

Key Dashboards & KPIs

  • Active vs. Dormant Customer Ratio
  • Customer Exit Rate (%)
  • Cohort-wise Financial Exposure
  • Product Holding Trends
  • Closure Compliance per Region
  • Communication Coverage Accuracy
  • Retention risk

Impact & Outcome

  • Enabled phased system shutdown through smart cohort-based segmentation.
  • Delivered real-time visibility with automated Power BI dashboards.
  • Minimized manual effort by aligning actions with customer and product data.
  • Enhanced compliance and traceability through structured closure workflows.
  • Achieved seamless decommissioning with high stakeholder confidence.

Employee Performance & Incentive Automation

Led the end-to-end automation of incentive planning and performance analysis for 2000+ employees, including Capital Market Advisors, Demat Account Activators, Brokers, and Branch Managers.

The initiative streamlined manual calculation processes, unified disparate performance metrics, and introduced a centralized system for incentive visibility and governance.

Domain: Capital Market | Location: India
Duration: 12 Months | Team: 4 Members

Key Dashboards & KPIs

  • Incentive vs. Revenue Contribution
  • Individual & Branch Performance Index
  • Account Activation Conversion Rates
  • Advisor Tier Mapping
  • Monthly Payout Accuracy
  • Sales trends
  • benchmark variance

Tools & Technologies

  • Excel for initial mapping
  • SQL for data queries, joins, and stored procedures
  • Power BI for interactive dashboards
  • JIRA for agile project tracking, and user story mapping
  • Internal HRMS APIs for data feeds
  • Microsoft Visio for process flow diagrams
  • External Data Systems

Impact & Outcome

  • Automated incentive workflows across advisory, sales, and branch operations.
  • Improved payout transparency and accuracy, reducing disputes and escalations.
  • Enabled real-time performance monitoring and incentive simulation scenarios.
  • Reduced manual processing time drastically while increasing reporting consistency.
  • Supported fair, data-backed appraisal decisions and strategic workforce alignment.

Thank You!

We truly appreciate your time and interest in exploring our work.

Let’s Connect!

We’re always open to thoughtful conversations, shared insights, or potential collaborations.

Whether you’re exploring solutions, seeking clarity, or just wishing to exchange ideas, feel free to contact me.
We bring curiosity to every problem, humility to every interaction, and dedication to every solution.

← Back

Thank you for your response. ✨