Summary
Overview
Work History
Education
Skills
Timeline
Hi, I’m

Rahul Naik

Bengaluru
Rahul Naik

Summary

Dedicated and results-driven Business Analyst with a proven track record of optimizing data-driven decision-making processes for FMCG(Nestle)- CPG domain , a prominent client, by leveraging Nielsen syndicated data. Proficient in all aspects of data analysis, database management, and project coordination within the consumer goods industry. Adept at bridging the gap between client requirements and technical implementation, with a focus on data accuracy and quality. Highly skilled in data standardization, logic development, and collaboration with cross-functional teams to deliver actionable insights and drive business success. Excel and SQL expert with strong industry knowledge, market research capabilities, and a commitment to regulatory compliance. Effective problem solver and communicator with a keen attention to detail, ensuring successful project outcomes and client satisfaction.

Overview

2
years of professional experience

Work History

TATA Consultancy Services | Client: Nestle | Data Provider: Nielsen, IRI, Intage

BUSINESS ANALYST
12.2021 - Current

Job overview

Requirement Gathering:

  • Collaborated with clients to gather and discuss project requirements and use cases, aligning them with existing scenarios.

Database Analysis:

  • Managed database analysis by ensuring that the required database is available for examination.
  • Monitored the Azure repository to verify database availability and promptly communicated any discrepancies to clients.

Gap Analysis and Solution Identification:

  • Receiving product and fact data from different countries in local language, Then convert the data into standard language, It involves cleansing and reviewing of the data for making it more understandable.
  • Mapped gaps in an Excel sheet and engaged with clients to find effective solutions.

Reference File Preparation:

  • Created different set of reference using Nielsen product and market Data and finance data from Nestle
  • Collaborated with clients, sharing reference files for their input and validation.

Logic Development and Technical Team Support:

  • Played a key role in developing data mapping logic to address missing data elements, such as manufacturer information.
  • Converting raw factual data into structured sales data, segmented by country, to facilitate informed decision-making and strategic analysis.
  • Explained complex logic to the technical team, enabling them to implement necessary changes.
  • Validated the logic's implementation to ensure data accuracy and completeness.

Finance Data Management:

  • If the files did not meet the standard template, communicated with the market to obtain the required data.
  • Once data met the standard template, forwarded it to the technical team for loading.

Data Validation:

  • Coordinated with technical teams to load and make data available for analysis.
  • Validated data integrity using Snowflake SQL, ensuring the presence of required columns, data accuracy, and correct calculations.

Issue Resolution:

  • Identified and reported data or calculation issues to technical teams for prompt resolution.
  • Engaged with clients to address any concerns or issues related to data analysis and view performance.
  • Interacted with internal customers to understand business needs and translate into requirements and project scope

Education

M S Ramaiah Institute of Technology
, Bengaluru

Master of Business Administration from Finance And Marketing
2021

Acharya Institute of Technology
, Bengaluru

Bachelor of Engineering from Mechanical Engineering
2018

Skills

  • Data Analysis: Proficient in analyzing Nielsen syndicated data to derive insights and support decision-making processes for Nestlé
  • Nielsen Data Expertise: Experienced in working extensively with Nielsen syndicated data, including data extraction, manipulation, and interpretation
  • Database Management: Skilled in managing databases to effectively handle syndicated data from Nielsen
  • Data Validation: Proficient in validating syndicated data using industry-standard tools and techniques
  • Requirement Gathering: Adept at gathering and documenting specific data requirements to meet Nestlé's analytical needs
  • Gap Analysis: Experienced in conducting gap analysis to align Nielsen syndicated data with Nestlé's requirements
  • Logic Development: Capable of developing custom logic to optimize data mapping and analysis for Nestlé's products
  • Technical Collaboration: Effective in explaining complex data logic to technical teams and ensuring successful implementation
  • Data Standardization: Skilled in maintaining data standardization and quality assurance for Nielsen syndicated data
  • Client Relationship Management: Proficient in liaising with Nestlé to ensure data accuracy, meet client expectations, and resolve issues promptly
  • Excel: Advanced proficiency in using Excel for data manipulation, analysis, and reporting, specifically tailored to Nestlé's needs
  • SQL: Skilled in SQL for querying and validating syndicated data to provide actionable insights for Nestlé
  • Collaboration: Effective collaboration with cross-functional teams to ensure successful utilization of syndicated data for Nestlé's benefit
  • Time Management: Excellent time management skills to efficiently manage multiple data-related tasks and deliverables for Nestlé

Timeline

BUSINESS ANALYST

TATA Consultancy Services | Client: Nestle | Data Provider: Nielsen, IRI, Intage
12.2021 - Current

M S Ramaiah Institute of Technology

Master of Business Administration from Finance And Marketing

Acharya Institute of Technology

Bachelor of Engineering from Mechanical Engineering
Rahul Naik