Kapil

Kapil

Manager – Commercial Sales, Reporting & Analytics
India

نبذة عني

Results-driven analytics professional with an experience of ~9 years in FMCG and a proven track record of transforming complex data into actionable insights. With a strong foundation in data analysis and visualization, p…

الخبرة

Analytics Manager

Pepsico
Dec 2021 - حتى الآن · 4 سنوات 6 أشهر

Analytics & Insights
Training
Business Intelligence
Automation
Presentation
Development
Programming
Data Validation
Reporting
Net Revenue Management
Account Management
Solution Architect
Joint Business Planning

Manager – Commercial Sales, Reporting & Analytics

PepsiCo, FLUS

Managed standardized and ad-hoc sales reporting and insights projects.
Collaborated with cross-functional Walmart teams to harmonize business planning.
Spearheaded the adoption of Power BI dashboards, leading to 85% adoption rate.
Leading the migration of Walmart’s Retail Link to Luminate.
Managed Sales Academy to train freshers on different tools and share business knowledge.
Conducted workshop on Citizen Development on Power Apps & Power Automate.
Conducted workshop for team on CPS data understanding.
Worked with Digital Factory team on multiple report automation and product testing.
Streamlining data flows while PGT migration.

Senior Research Executive – Intelligent Analytics

Nielsen IQ

Practiced Market Structure & Consumer Decision Tree studies to understand how shoppers purchase to pinpoint opportunities for growth.
Discovered how different product attributes impact shopper purchasing behaviors across categories.
Presented findings and actionable insights to clients, providing strategic recommendations for product development, marketing strategies, and brand positioning.
Mentored a team of junior analysts, overseeing their work and ensuring high-quality deliverables.
Utilized Nielsen's proprietary tools and third-party software for data collection, analysis, and visualization.

Accounts Manager

Mobisy Technologies

Managed digitalization projects in FMCG accounts like Hershey’s India & Godrej Consumer for unorganized Indian Retail Market.
Gathering requirements from key business stakeholders, building BRDs and translating it to IT & Analytics development teams.
Managed end to end Product pipeline from building roadmaps, Testing, Roll Out, Tracking Usage and Driving Adoption.
Conducting Business Review meetings with Client Leadership.

Senior Business Analyst – AAC/GMO

TCS

Conducted in-depth market research studies to uncover consumer preferences and behaviors for more than 20 different categories across Home Care, Personal Care, Food & Beverages.
Collaborated with client consultants to define research objectives and translate business questions into research plans.
Utilized statistical analysis techniques and software to process data and draw actionable insights from large datasets.
Identified and executed process improvement ideas using VBA and SAS coding to enhance productivity and reducing errors.

المهارات

التحليلات تحليل البيانات المحترف تنقيب البيانات نظام التحليل الإحصائي (SAS) لغة الاستعلامات الهيكلية (SQL) تمثيل البيانات تحليلات أدوبي باور بي آي لغة البرمجة آر (R) تحليل الانحدار تابلو نمذجة النسبة SAP Bobj/Teradata Cornerstone IRI Nielsen Retail Link Luminate Excel Power Apps PowerPoint Power Automate Snowflake Data Analysis Market Research Statistical Analysis VBA Business Requirements Documentation Product Testing Report Automation Training Workshop Facilitation Stakeholder Communication Cross-functional Collaboration Mentoring
الإبلاغ عن هذا الملف الشخصي؟