HAREKRUSHNA PRADHAN
Hyderabad
Summary
Seasoned Data Analytics & Insights Leader with over 17 years of experience driving data-driven decision-making and strategic initiatives across FMCG, CPG, and Retail. Proven expertise in business analysis, revenue growth management, trade promotion management, and process automation. Adept at leading cross-functional teams, collaborating with senior stakeholders, and delivering actionable insights that contribute to business growth and operational efficiency. Highly skilled in leveraging advanced business intelligence tools (Power BI, Tableau) and data visualization techniques to analyze complex business data, streamline reporting processes, and optimize business performance.
Overview
18
18
years of professional experience
Work History
Executive Manager - Insights and Data Analytics
Pepsico
08.2023 - Current
- Spearhead a high-performing team delivering monthly business reports and actionable consumer insights for the APAC region across PepsiCo’s entire beverages portfolio.
- Drive data-driven strategy development through collaboration with marketing teams, providing comprehensive market research and performance analysis.
- Implemented the SMART initiative, standardizing and streamlining reporting processes across beverages and food categories, resulting in a 2.5 FTE cost reduction.
- Utilize advanced data analytics tools, including Power BI, Nielsen, Kantar, and IRI, to synthesize consumer insights with business intelligence and deliver strategic recommendations.
- Lead strategic analysis of market dynamics, consumer trends, and product performance, enabling informed decision-making across the region.
Senior Manager, Trade Promotion Management (TPM)
PepsiCo
03.2021 - 07.2023
- Led the execution and optimization of trade promotion strategies across multiple sales channels, driving improved promotional ROI.
- Collaborated closely with Sales, Marketing, and Finance teams to design, execute, and track promotional activities aligned with business goals.
- Led a team of 7-40 TPM professionals, fostering a high-performance, collaborative environment to ensure seamless execution of trade promotion strategies.
- Successfully migrated TPM processes from legacy systems (CAS) to PGT SAP, significantly enhancing operational efficiency, accuracy, and data-driven decision-making.
- Provided training and mentorship to junior team members on best practices, tools, and methodologies in trade promotion management.
Portfolio Optimization Manager (Commercial Sales)
PepsiCo
12.2019 - 10.2021
- Led Total Portfolio Optimization (TPO) initiatives, identifying underperforming SKUs based on key performance indicators and executing portfolio adjustments to optimize product offerings.
- Automated the TPO process using Power BI, eliminating manual workflows and saving $200K in development costs.
- Successfully automated and streamlined the Innovation Tracking process, improving visibility and decision-making around new product launches.
Business Analyst
Parle Agro
03.2019 - 12.2019
- Provided strategic insights to support the company’s long-term planning, new product opportunities, and revenue growth targets.
- Built dynamic, user-friendly dashboards and reports, showcasing complex data visualizations with simplicity and clarity.
- Conducted critical business analysis, assessing the long-term impact of business decisions on strategy, revenue, and market performance.
- Played a key role in delivering data-driven insights to guide the company’s overall strategic direction.
Sr Business Analyst
Colgate
01.2017 - 03.2019
- Delivered high-level reports and insights to Global Marketing and CMI teams, analyzing syndicated and in-house data across key KPIs such as sales, market share, distribution, pricing, and promotion.
- Led the harmonization of point-of-sale data across Colgate-Palmolive and its competitors into a single One Product Hierarchy (1PH), ensuring global data uniformity and consistency.
- Identified a $600M distribution opportunity and led the 50-20 Project, achieving $6M in annual cost savings by streamlining operational processes.
- Worked extensively with unstructured data, cleaning and harmonizing it for global reporting, ensuring data quality and consistency for senior leadership decision-making.
Sr. Business Analyst
Tata Consultancy Services
07.2010 - 12.2016
- Conducted in-depth category, regional, and brand-level analyses to uncover growth opportunities for clients in the FMCG and CPG sectors.
- Delivered actionable insights through the use of Nielsen proprietary tools, generating reports and visualizations for senior management decision-making.
- Led projects in Market Assessment, Competitor Analysis, Product Portfolio Analysis, Sales & Distribution Management, and Go-to-Market Strategy.
- Conducted extensive market research across Europe to analyze consumer behavior, competition, and channel performance, providing strategic recommendations for clients.
- Presented complex market insights in clear, visually compelling formats, facilitating informed business decisions.
Business Development Manager -Media Sales
India Today, Infomedia & JustDial
02.2007 - 05.2010
- Built and managed client relationships in the print and digital space, driving sales performance and meeting targets over a three-year period.
- Worked closely with clients to understand their needs, delivering customized solutions and contributing to the growth of their business.
Education
MBA - Marketing & Finance
Biju Patnaik University of Technology - Bhubaneswar
01.2007
Skills
- Data Analytics Tools: Power BI, Tableau,Excel(Advanced), SAP, Nielsen, IRI, Kantar
- Programming & Automation: Python (basic)
- Data Visualization: Power BI, Tableau, Excel Dashboards
- CRM & ERP Systems: SAP
- Reporting & Analytics: Market Sizing, Competitor Analysis, Pricing Analysis, Go-to-Market Strategy, Sales Performance Analytics, Revenue Growth management, Consumer Analytics, Trade Promotion Management
Languages
Hindi
Proficient
C2
English
Bilingual or Proficient (C2)
Timeline
Executive Manager - Insights and Data Analytics
Pepsico
08.2023 - Current
Senior Manager, Trade Promotion Management (TPM)
PepsiCo
03.2021 - 07.2023
Portfolio Optimization Manager (Commercial Sales)
PepsiCo
12.2019 - 10.2021
Business Analyst
Parle Agro
03.2019 - 12.2019
Sr Business Analyst
Colgate
01.2017 - 03.2019
Sr. Business Analyst
Tata Consultancy Services
07.2010 - 12.2016
Business Development Manager -Media Sales
India Today, Infomedia & JustDial
02.2007 - 05.2010
MBA - Marketing & Finance
Biju Patnaik University of Technology - Bhubaneswar
Similar Profiles
Ja'Shon SnipesJa'Shon Snipes
Warehouse Worker at PepsiCoWarehouse Worker at PepsiCo
Vaibhav DubeyVaibhav Dubey
Principal Software Engineer at PepsiCoPrincipal Software Engineer at PepsiCo
Jaskaran Singh RekhiJaskaran Singh Rekhi
Lead Engineer- IT at PepsiCoLead Engineer- IT at PepsiCo
Kimber ThomsonKimber Thomson
Area Sales Manager at PepsiCoArea Sales Manager at PepsiCo
S N Aditya MurthyS N Aditya Murthy
Lead Product Manager - Digital Supply Chain at Dr Reddy's LaboratoriesLead Product Manager - Digital Supply Chain at Dr Reddy's Laboratories