Manan Shah

Result-driven data science & analytics consultant specializing in CPG/FMCG, Supply chain and Financial Services. Proven track record of delivering scalable data-driven solutions and adept at leading cross-functional teams to drive decision making

Work Experience

Live Project - Thematic Investing using Generative AI  | Mirae Asset

  • Leveraged SEC Edgar API to extract and analyze 10-K SEC annual reports, categorizing companies based on emerging thematic trends to uncover strategic investment opportunities
  • Harnessed Generative AI models to classify companies based on emerging themes identified and assign a sentiment score (positive or negative sentiment) based on their annual reports and investment patterns
  • Designed a comprehensive ranking framework for the Top 1000 NASDAQ companies by integrating sentiment analysis, driving optimized and data-driven investment strategies

 

Senior Consultant | Ernst & Young | Bengaluru, India

  • Spearheaded a comprehensive user experience optimization project for credit card payments on mobile applications and websites. Utilized Adobe Analytics to design and evaluate user journeys, resulting in a significant enhancement of the customer experience leading to a 15% increase in transaction completion rates and translating to approximately $2M in additional revenue annually
  • Led the processing and unifying of 1 million user call and chatbot transcripts using Natural Language processing to extract key themes and sentiments from the customer conversations to provide actionable insights to the product team
  • Conceptualized and implemented an internal document repository using Generative AI for quick retrieval of company’s internal documents which resulted in increased staff productivity by 12% through faster information retrieval, saving an estimated 500 man-hours annually across the organization
     

Consultant 2 | Fractal Analytics | Mumbai, India

  • Engineered a data-driven recommendation engine for an Indian manufacturer, enabling a distribution-led approach to product placement and sales which resulted in incremental sales of 2.5% in Q1 2023, outperforming market growth by 1.8 percentage points
  • Conducted an in-depth analysis to decode the search rank algorithm of major e-commerce retailers across various markets of Europe. This involved extensive data mining, statistical analysis, and machine learning techniques to identify key drivers of search result rankings which enabled the client to improve their average organic rank by 2.2 positions on the retailer's website and a 18% boost in conversion rates for the client's products
  • Developed a comprehensive media-mix model to optimize digital advertising spend which involved collecting and analyzing vast amounts of search, advertising, marketing spends data across various channels, applying advanced statistical techniques to calculate the Return on Investment (ROI) for different advertising strategies. The resulting model helped optimize cost-per-click spends and identify high-performing keywords for targeting enabling the client to save $400,000 in advertising costs while simultaneously improving the client's digital market share by 14%
     

Consultant | Fractal Analytics | Mumbai, India

  • Led a cross-functional team of three analysts to develop a comprehensive pricing and promotion strategy for a major retail client which involved complex data analysis of historical sales data, competitor pricing, promotion spends, financial data and market trends to developed sophisticated models to calculate pricing and promotion elasticities, as well as the ROI on various promotional activities resulting in an incremental profit of $800,000 over the next eight months
  • Designed and implemented an  inventory tracking dashboard for a major CPG manufacturer in the US which required integrating data from the client's ERP system, retailer point-of-sale data, and logistics databases. The dashboard provided real-time visibility into shipments, inventory levels, and consumption patterns across major retailers and leveraged predictive analytics to forecast potential stock-outs and overstock situations, allowing the client to proactively manage their supply chain. This solution helped the client streamline their supply-chain process, reducing stock-outs by 15% and excess inventory by 12%, resulting in savings of $1.2 million annually
  • Took the initiative to optimize the data extraction and ingestion process on Snowflake using advanced SQL techniques. This involved refactoring existing queries, implementing partitioning strategies, and leveraging Snowflake's unique features like clustering and materialized views which reduced data processing time by 30%, enabling faster decision-making and more frequent data updates and I even documented these techniques and conducted knowledge-sharing sessions with entire team

 

Associate | Fractal Analytics | Mumbai, India

  • Spearheaded a data harmonization project, integrating data from various sources, dealing with inconsistent data formats, varying levels of data quality, and complex business rules. Developed a robust ETL process and implementing data quality checks to provide the client with a single source of truth for their products and its attributes improving accuracy of their tracking and reporting by 21%
  • Designed and implemented a master data-management system based on a sophisticated rule-based engine for a global CPG/FMCG client where I automated the mapping of product attributes across different markets and channels, replacing a manual process prone to errors. The engine incorporated complex business logic to handle exceptions and edge cases, ensuring 97.7% accuracy in product classification which helped in consolidating the product portfolio across various markets
  • Played a key role in the product team for 'Concordia', an AI-powered data harmonization and mapping tool. Contributed to the development of machine learning algorithms for automated data cleaning and matching. Worked closely with UI/UX designers to create an intuitive interface for non-technical users to interact with complex data harmonization rules, participated in client demos and gathered feedback for continuous improvement, contributing to the tool's rapid adoption across the client base.

 

Associate Procurement Analyst | Zycus Infotech | Mumbai, India

  • Cleaned and categorized spend data of the client from various ERP systems to provide visibility to the client into their procurement process and opportunities for negotiating the payment terms with their vendors which lead to an annual saving of $1.3 million for a client
  • Played a crucial role in the User Acceptance Testing (UAT) phase for new product releases and upgrades by collaborating closely with the product development team to design comprehensive test scenarios covering various use cases and edge conditions. Meticulously documented and prioritized bugs and enhancement requests, ensuring they were addressed before release, reducing post-release issues by 40%
Accomplishments

Fastrack promotions for excellent performance: Promoted twice within the first 3 years at Fractal Analytics from Associate to Consultant I and Consultant II.

Best Upcoming Consultant: Awarded the best upcoming consultant in the team based on exceptional performance, project delivery & management and client-first attitude.

KAIZEN Award for exemplary project delivery: Awarded the KAIZEN award for successfully delivering and exceeding expectations on a critical project for the client.

GOOD SAMARITAN: Award for helping multiple project teams
Awarded the Good Samaritan award for helping multiple teams in delivering projects to their clients.

SPOT Award: Awarded the Spot award for a quick turnaround on a critical client project. 
 

Education

B.E, Electronics and Telecommunications Engineering, University of Mumbai, Mumbai

Certificates
  • Introduction to Generative AI, Google
  • Databricks Certified Associate for Apache Spark 3.0, Databricks Academy
  • Machine Learning, Stanford University
  • Deep Learning Specialization, Coursera
  • Advanced SQL: MySQL Data Analysis and Business Intelligence, Udemy
  • Sequence, Time Series & Prediction, Coursera
  • Android Programming, Neebal Learning
  • Internet Of Things, Neebal Learning
     
Co/Extra-curricular
  • President of the Consulting Club at IIM Ahmedabad
  • Core Member of Profile Committee at IIM Ahmedabad
  • Secured Silver Medal among 1000+ students  in the 2014 International Mathematics Olympiad at a regional level.
  • Worked with a team of 20+ volunteers to distribute food, masks, and sanitizers to 1000+ families in underserved communities during the peak of the COVID-19 pandemic in April 2020
  • Mentored 3 aspiring graduate students for GRE examination, resulting in an average score improvement of 15%. Developed personalized study plans and conducted weekly workshops on advanced quantitative techniques
     

Quick Look

  • Work Experience: 5.9 Years
  • Previous Roles

    Senior Consultant, Ernst & Young, Bangalore

    Consultant 2, Fractal Analytics, Mumbai

  • Function : Analytics & Data Science
    Consulting
    Strategy
  • Industry/Sector: Consulting
    FMCG/CPG
    Retail/eCommerce
    Technology
Work Experience

Live Project - Thematic Investing using Generative AI  | Mirae Asset

  • Leveraged SEC Edgar API to extract and analyze 10-K SEC annual reports, categorizing companies based on emerging thematic trends to uncover strategic investment opportunities
  • Harnessed Generative AI models to classify companies based on emerging themes identified and assign a sentiment score (positive or negative sentiment) based on their annual reports and investment patterns
  • Designed a comprehensive ranking framework for the Top 1000 NASDAQ companies by integrating sentiment analysis, driving optimized and data-driven investment strategies

 

Senior Consultant | Ernst & Young | Bengaluru, India

  • Spearheaded a comprehensive user experience optimization project for credit card payments on mobile applications and websites. Utilized Adobe Analytics to design and evaluate user journeys, resulting in a significant enhancement of the customer experience leading to a 15% increase in transaction completion rates and translating to approximately $2M in additional revenue annually
  • Led the processing and unifying of 1 million user call and chatbot transcripts using Natural Language processing to extract key themes and sentiments from the customer conversations to provide actionable insights to the product team
  • Conceptualized and implemented an internal document repository using Generative AI for quick retrieval of company’s internal documents which resulted in increased staff productivity by 12% through faster information retrieval, saving an estimated 500 man-hours annually across the organization
     

Consultant 2 | Fractal Analytics | Mumbai, India

  • Engineered a data-driven recommendation engine for an Indian manufacturer, enabling a distribution-led approach to product placement and sales which resulted in incremental sales of 2.5% in Q1 2023, outperforming market growth by 1.8 percentage points
  • Conducted an in-depth analysis to decode the search rank algorithm of major e-commerce retailers across various markets of Europe. This involved extensive data mining, statistical analysis, and machine learning techniques to identify key drivers of search result rankings which enabled the client to improve their average organic rank by 2.2 positions on the retailer's website and a 18% boost in conversion rates for the client's products
  • Developed a comprehensive media-mix model to optimize digital advertising spend which involved collecting and analyzing vast amounts of search, advertising, marketing spends data across various channels, applying advanced statistical techniques to calculate the Return on Investment (ROI) for different advertising strategies. The resulting model helped optimize cost-per-click spends and identify high-performing keywords for targeting enabling the client to save $400,000 in advertising costs while simultaneously improving the client's digital market share by 14%
     

Consultant | Fractal Analytics | Mumbai, India

  • Led a cross-functional team of three analysts to develop a comprehensive pricing and promotion strategy for a major retail client which involved complex data analysis of historical sales data, competitor pricing, promotion spends, financial data and market trends to developed sophisticated models to calculate pricing and promotion elasticities, as well as the ROI on various promotional activities resulting in an incremental profit of $800,000 over the next eight months
  • Designed and implemented an  inventory tracking dashboard for a major CPG manufacturer in the US which required integrating data from the client's ERP system, retailer point-of-sale data, and logistics databases. The dashboard provided real-time visibility into shipments, inventory levels, and consumption patterns across major retailers and leveraged predictive analytics to forecast potential stock-outs and overstock situations, allowing the client to proactively manage their supply chain. This solution helped the client streamline their supply-chain process, reducing stock-outs by 15% and excess inventory by 12%, resulting in savings of $1.2 million annually
  • Took the initiative to optimize the data extraction and ingestion process on Snowflake using advanced SQL techniques. This involved refactoring existing queries, implementing partitioning strategies, and leveraging Snowflake's unique features like clustering and materialized views which reduced data processing time by 30%, enabling faster decision-making and more frequent data updates and I even documented these techniques and conducted knowledge-sharing sessions with entire team

 

Associate | Fractal Analytics | Mumbai, India

  • Spearheaded a data harmonization project, integrating data from various sources, dealing with inconsistent data formats, varying levels of data quality, and complex business rules. Developed a robust ETL process and implementing data quality checks to provide the client with a single source of truth for their products and its attributes improving accuracy of their tracking and reporting by 21%
  • Designed and implemented a master data-management system based on a sophisticated rule-based engine for a global CPG/FMCG client where I automated the mapping of product attributes across different markets and channels, replacing a manual process prone to errors. The engine incorporated complex business logic to handle exceptions and edge cases, ensuring 97.7% accuracy in product classification which helped in consolidating the product portfolio across various markets
  • Played a key role in the product team for 'Concordia', an AI-powered data harmonization and mapping tool. Contributed to the development of machine learning algorithms for automated data cleaning and matching. Worked closely with UI/UX designers to create an intuitive interface for non-technical users to interact with complex data harmonization rules, participated in client demos and gathered feedback for continuous improvement, contributing to the tool's rapid adoption across the client base.

 

Associate Procurement Analyst | Zycus Infotech | Mumbai, India

  • Cleaned and categorized spend data of the client from various ERP systems to provide visibility to the client into their procurement process and opportunities for negotiating the payment terms with their vendors which lead to an annual saving of $1.3 million for a client
  • Played a crucial role in the User Acceptance Testing (UAT) phase for new product releases and upgrades by collaborating closely with the product development team to design comprehensive test scenarios covering various use cases and edge conditions. Meticulously documented and prioritized bugs and enhancement requests, ensuring they were addressed before release, reducing post-release issues by 40%
Accomplishments

Fastrack promotions for excellent performance: Promoted twice within the first 3 years at Fractal Analytics from Associate to Consultant I and Consultant II.

Best Upcoming Consultant: Awarded the best upcoming consultant in the team based on exceptional performance, project delivery & management and client-first attitude.

KAIZEN Award for exemplary project delivery: Awarded the KAIZEN award for successfully delivering and exceeding expectations on a critical project for the client.

GOOD SAMARITAN: Award for helping multiple project teams
Awarded the Good Samaritan award for helping multiple teams in delivering projects to their clients.

SPOT Award: Awarded the Spot award for a quick turnaround on a critical client project. 
 

Education

B.E, Electronics and Telecommunications Engineering, University of Mumbai, Mumbai

Certificates
  • Introduction to Generative AI, Google
  • Databricks Certified Associate for Apache Spark 3.0, Databricks Academy
  • Machine Learning, Stanford University
  • Deep Learning Specialization, Coursera
  • Advanced SQL: MySQL Data Analysis and Business Intelligence, Udemy
  • Sequence, Time Series & Prediction, Coursera
  • Android Programming, Neebal Learning
  • Internet Of Things, Neebal Learning
     
Co/Extra-curricular
  • President of the Consulting Club at IIM Ahmedabad
  • Core Member of Profile Committee at IIM Ahmedabad
  • Secured Silver Medal among 1000+ students  in the 2014 International Mathematics Olympiad at a regional level.
  • Worked with a team of 20+ volunteers to distribute food, masks, and sanitizers to 1000+ families in underserved communities during the peak of the COVID-19 pandemic in April 2020
  • Mentored 3 aspiring graduate students for GRE examination, resulting in an average score improvement of 15%. Developed personalized study plans and conducted weekly workshops on advanced quantitative techniques