Mihir Shah
Vadodara
Summary
As a skilled Modelling Analyst with extensive experience in the Price and Promotion process for the CPG industry, I excel at transforming complex data into actionable insights. My expertise includes advanced statistical analysis, Python, SQL, and Power BI, enabling me to drive strategic decisions and optimize pricing strategies. Additionally, I ensure the accuracy, completeness, and quality of critical reference data through meticulous validation, cleansing, and enrichment processes. Collaborating seamlessly with cross-functional teams, I maintain comprehensive documentation and adhere to robust data governance policies. Armed with a Bachelor’s degree in a relevant field, I am unwavering in my commitment to maintaining impeccable data standards and delivering high-quality insights.
Overview
7
7
years of professional experience
Work History
Modelling Analyst
NIQ
Vadodara
10.2023 - Current
- Conducted comprehensive price sensitivity analyses to determine optimal pricing strategies, resulting in a 5% increase in revenue.
- Evaluated the effectiveness of various promotional strategies, leading to a 10% improvement in promotional ROI.
- Utilized advanced statistical and machine learning models to predict consumer behavior and optimize pricing and promotions.
- Integrated data from multiple sources to create a unified view of market trends and consumer preferences.
- Enhanced overall data processing efficiency by regularly employing Python for data analysis and automation, as well as SQL for querying large datasets.
- Utilized Power BI to create interactive dashboards, enhancing data visualization and stakeholder engagement.
- Analyzed market trends and competitor pricing strategies to provide actionable insights for strategic decision-making.
Data Processing Specialist-Reference Data
Nielsen-IQ
Vadodara
06.2022 - 09.2023
- Utilized various techniques throughout the extraction, transformation, and loading (ETL) process to maintain accurate and consistent data across large datasets.
- Demonstrated consistent adherence to strict SLAs and client specifications, resulting in the delivery of high-quality data with an impressive 98% accuracy rate.
- Translated complex data findings into clear, actionable insights for non-technical stakeholders, enhancing report usability by 30%, and enabling better decision-making.
- Acted as the primary contact for operational queries, efficiently resolving 95% of issues on the first contact, thereby enhancing client trust and satisfaction.
- Collaborated with internal teams and clients, ensuring full understanding and meeting of data requirements to boost stakeholder engagement by 15%.
- Utilized problem-solving abilities to investigate and resolve unexpected data issues, maintaining consistent and accurate information across diverse projects.
Supply Chain Intern
Shiv Shakti Logistics
Vadodara
08.2019 - 05.2022
- Optimized inventory levels, reducing excess stock by 15%, and implemented just-in-time inventory practices.
- Discovered untapped market potential, leading to the successful launch of a new product line and generating additional revenue.
- Implemented data-driven solutions to optimize processes and resource allocation, resulting in cost savings.
Education
Bachelor of Business Administration -
Maharaja Sayajirao University
Vadodara, Gujarat04.2022
Skills
- Statistical Analysis
- SQL
- Python
- Power BI
- Microsoft Office
- Analytical Thinking
- Problem-Solving Aptitude
- Data Modeling
- Business Intelligence
- Teamwork
- OGRDS
- Data Processing
Timeline
Modelling Analyst
NIQ
10.2023 - Current
Data Processing Specialist-Reference Data
Nielsen-IQ
06.2022 - 09.2023
Supply Chain Intern
Shiv Shakti Logistics
08.2019 - 05.2022
Bachelor of Business Administration -
Maharaja Sayajirao University