Acgindia
Get in Touch
 

An Indian multinational pharmaceutical company. The company has products in therapeutic areas ranging from antibiotics, to gastrointestinal, cardiovascular, dermal, and erectile dysfunction medications. Company is reportedly among India's top five pharmaceutical companies by domestic sales and top two prescription drug companies by volumes.

  • ~$1B Revenues
  • 25 Manufacturing Units
  • ~21 Brands
  • 34 Countries
  • ~22k+ Employees
  • Reporting is done using spreadsheets which is very time consuming and cumbersome activity
  • The Reporting system follows 2-dimensional architecture
  • Data is in unstructured formats that requires a cleansing process and massaging.
  • Data architecture does not have any integration, leading to lot of manual efforts in preparing the final dataset for reporting

  • SPM

    Forecasting to predict future trends and changes in KPIs, and budgeting to get a roadmap for allocating resources to achieve financial goals.

  • TQM

    Internal reports used to run the organization, make business decisions, and monitor progress to make more accurate, data-driven decisions.

  • ICM

    Internal reports used to run the organization, make business decisions, and monitor progress to make more accurate, data-driven decisions.

  • Management Reporting

    Internal reports used to run the organization, make business decisions, and monitor progress to make more accurate, data-driven decisions.

  • ICM Model Covered ~100 Scenarios, ~30 divisions, ~500 HQ’s, ~22k Sales Persons and ~6 Hierarchy Level
  • Data Warehouse setup
  • ETL Process Design
  • Single source of truth
  • Automated process for Pulling and Pushing of data.
  • Data Model setup
  • Query Builder Setup
  • New UX Dashboard Design with proper instructions
  • Eliminate spreadsheets and siloed/manual processes
  • Improved data quality and governance
  • Dynamic changes and realignment
  • Dynamic changes and realignment
  • Reduced attrition
  • KPI’s for tracking and monitoring Incentives.
  • Exceptions favoritism removal
  • Access Based controls.
  • Significant error reductions
  • Aligned sales behaviors & incentives
  • Timely rollout of sales plan.
  • Improved cross-functional visibility and decision-making
  • Analysis available at least level

Trusted by Industry Leaders