Summary
Overview
Work History
Education
Skills
Affiliations
Languages
References
Timeline
Generic
Aditya Pradhan

Aditya Pradhan

Associate Consultant
Pune

Summary

MBA and management consulting professional with robust experience in client-facing roles across diverse industries. Skilled in strategy development, data analytics, reporting and visualization, team sizing and alignment, and change management.

Proficient in leveraging tools like SQL, Power BI, Advanced Excel, and PowerPoint to design data-driven solutions and enable effective decision-making. Experienced in planning, forecasting, and implementing strategic initiatives while addressing complex challenges across multiple workstreams.

Overview

8
8
years of professional experience

Work History

Associate Consultant

Beghou Consulting
Pune
10.2022 - Current

Project 1: Patient Analytics

  • Conducted advanced analytics to uncover insights across customer journeys, segmentation, trend analysis, and business performance.
  • Refined and structured large datasets using SQL to derive actionable insights and support strategic decision-making.
  • Applied business rules to derive metrics such as lifecycle stages, duration, and usage patterns for various products or services.
  • Analyzed key performance indicators (KPIs) for customers, providers, and stakeholders to identify trends and opportunities for improvement.
  • Delivered insights and recommendations to stakeholders through visually engaging presentations, using tools such as PowerPoint, to drive strategic outcomes.

Project 2: Reporting and Data Visualization.

  • Transformed complex datasets into actionable insights and intuitive visualizations to support informed decision-making.
  • Analyzed, prepared, and cleaned large datasets using SQL to ensure data readiness for visualization.
  • Designed and developed interactive dashboards and reports using tools like Power BI to facilitate data-driven strategies.
  • Conducted rigorous testing to validate the accuracy, reliability, and consistency of reports and dashboards.
  • Maintained high-quality deliverables, resulting in project extensions and recognition for timely execution and error-free outputs.

Project 3: Market Dynamics and Pricing Study

  • Partnered with clients and stakeholders to define business objectives and key research questions.
  • Conducted primary and secondary research to gather market data and insights.
  • Analyzed market trends, competitor activities, and customer behavior to provide actionable recommendations.
  • Performed SWOT analysis to identify strengths, weaknesses, opportunities, and threats, supporting strategic planning.
  • Developed clear and visually engaging presentations and reports to effectively communicate insights and findings.

Strategy Insights and Planning Associate Consultant

ZS Associates
Pune
02.2022 - 09.2022

Project 1: Strategy Building and Execution

  • Consulted on strategy formulation and execution, focusing on drug launch readiness and process optimization for pharmaceutical clients.
  • Designed and implemented procedures for field medical teams, ensuring alignment with evolving standards and competencies.
  • Established systematic tracking mechanisms to streamline project transitions from design to delivery.

Project 2: Sizing Structure and Alignment

  • Conducted data-driven analyses to optimize the size, structure, and geographic alignment of field medical teams.
  • Developed visual frameworks using proprietary software to support client hiring and ecosystem planning.
  • Created automated dashboards and reports using Power BI to enhance operational efficiency and decision-making.

Team Lead

LR Logistics
Mumbai
08.2016 - 10.2019

• Lead a team of 4 and strategically managed logistics and warehousing

• In charge of warehousing, inventory, transportation, and supply chain process, as well as planning, coordinating, and monitoring logistics operations

• Improve operational and financial performance by developing and implementing best-practice logistics principles, policies, and processes across the firm

• Provide logistical solutions while staying within budgetary constraints and maintaining high levels of quality and service

• Ensure that all procedures are completed in accordance with the conditions of the Service Level Agreement - on time and accurately

• Successfully increased daily movement of shipments volume by 20% using MIS

• Optimized the dispatching process by training people with MIS technology which resulted a 25% reduction in time consumption

• Interact with clients and build good relationships with them while ensuring their needs are being met

Education

MBA - Operations Management

Great Lakes Institute of Management
Chennai, India
07-2021

Bachelor of Engineering - Mechanical Engineering

New Horizon College of Engineering
Bengaluru, India
07-2016

Skills

SQL

Power BI

Advanced Excel

PowerPoint

Snowflake

Forecasting

Strategic Thinking

Planning and Execution

Stakeholder Management

Project Leader

Healthcare/Pharmaceutical Domain

APLD Data

Claims Data

Physician Data

Calls Data

Affiliations

  • Swimming
  • Squash
  • Travel

Languages

English
First Language
Hindi
Proficient (C2)
C2

References

References available upon request.

Timeline

Associate Consultant

Beghou Consulting
10.2022 - Current

Strategy Insights and Planning Associate Consultant

ZS Associates
02.2022 - 09.2022

Team Lead

LR Logistics
08.2016 - 10.2019

MBA - Operations Management

Great Lakes Institute of Management

Bachelor of Engineering - Mechanical Engineering

New Horizon College of Engineering
Aditya PradhanAssociate Consultant