AVIK SHAH
Bengaluru
Summary
Data Analyst and Business Analyst with over 3.5 years of enterprise experience across FMCG analytics, reporting, and SAP S/4HANA implementations. Strong hands-on expertise in Python, Excel, and Power BI for analyzing, cleaning, standardizing, and automating complex operational datasets. Proven experience in SKU/product master standardization, stock aging analysis, Customer-Product Customization (CPR), workforce analytics, and SAP MDM, MM, and EWM processes. Known for designing practical data structures, reports, and templates that improve data quality, visibility, and business decision-making. Seeking a stable, on-role Data Analyst/Business Analyst position.
Overview
3
3
years of professional experience
3
3
Certification
Work History
Data Analyst/Business Data Analyst
Wipro Consumer Care and Lighting
Bengaluru
01.2024 - Current
- Executed data analysis and reporting across FMCG, inventory, workforce, and master datasets for management decisions.
- Designed SAP stock ageing reports using SAP S/4HANA data and Excel/Power BI to monitor inventory health.
- Developed Excel and Power BI dashboards for KPIs, trends, ageing analysis, and exception reporting.
- Conducted Customer-Product Customisation analysis to ensure product configurations met FMCG and SAP business rules.
- Cleaned and validated large datasets with Python and Excel, enhancing accuracy and reliability of reports.
- Analyzed employee and workforce data, focusing on headcount, tenure, movement, and trends for internal reporting.
- Collaborated with business, supply chain, and IT teams to transform reporting requirements into actionable insights.
SAP MDM/EWM Analyst-Implementation & Data Operations
Wipro Consumer Care & Lighting
Bangalore
08.2022 - 01.2024
- Supported SAP MDM and SAP EWM implementations on SAP S/4 HANA, ensuring master data readiness and validation.
- Designed MDM request templates for materials, vendors, and customers to standardize data intake and minimize errors.
- Provided functional input for vendor creation automation, defining fields, validations, and approval logic in SAP.
- Oversaw Customer-Product Customization (CPR) activities to ensure accurate product setup across SAP systems.
- Analyzed data inconsistencies affecting warehouse, inventory, and transactional FMCG processes.
- Executed data reconciliation and validation cycles during implementation and post-go-live phases.
- Developed MIS and control reports to monitor data quality, request aging, and implementation progress.
- Collaborated with functional consultants and business users during UAT and business testing.
Education
M.Sc. - Agri-Business Economics
Gokhale Institute of Politics & Economics
Pune08-2022
B.Sc. - Economics Honours
Bankura Christian College
Bankura11-2020
Skills
- Data analysis and modeling
- Business and exploratory analytics
- FMCG data structuring
- SKU standardization
- Inventory management
- Customer product customization
- Employee analytics
- KPI and trend analysis
- Exception analysis
- Python programming
- Pandas and NumPy libraries
- Rule-based automation
- Excel advanced formulas
- Pivot tables and Power Query
- Power BI dashboards and DAX basics
- SAP S/4HANA implementation support
- MDM, MM, EWM modules
- Data migration and validation
- UAT and business testing
- SOP documentation
- Stakeholder coordination
Certification
- SAP MM, Certified
- Business Analyst, Certified
- Microsoft Power BI, In Progress, 2026
- ADCA (Advanced Diploma in Computer Applications), Completed
Data Analysis And Automation Projects
- FMCG Data Structuring & SKU Standardisation Solution, Designed a Python-based solution to clean and standardise noisy FMCG product descriptions from multiple systems (SAP, Intra, Synapse)., Extracted and standardised Brand, Variant, Category, Sub-category, Grammage, Quantity, Offer Flag using rule-based logic., Resolved mismatches across material descriptions, material groups, and product hierarchies to create a single analysis-ready FMCG structure., Automated Excel-heavy processes, reducing manual effort and improving consistency for analytics and supply-chain teams., Delivered structured Excel outputs and one-page executive summaries.
- SAP Stock Ageing & Inventory Analytics, Built stock ageing analysis using SAP S/4HANA inventory data to classify stock into ageing buckets., Created Excel and Power BI charts highlighting slow-moving and non-moving inventory., Enabled business users to monitor inventory health and support decision-making for liquidation or reallocation.
- Lead Data Analysis (Python & Excel), Analysed large lead datasets using Python (Pandas, NumPy) to identify behavioural patterns and quality gaps., Cleaned and standardised raw data, improving reporting accuracy., Generated frequency-based and trend-based summaries for planning and analysis.
- Employee/Workforce Analytics (Power BI), Analysed workforce data to identify trends in headcount, tenure, and movement., Built interactive Power BI dashboards with KPIs, filters, and drill-downs for management reporting.
Core Skills
Data Analysis & Exploratory Data Analysis (EDA), FMCG Data Structuring & SKU Standardisation, Stock Ageing & Inventory Analytics, Customer-Product Customisation (CPR), Workforce / Employee Analytics, KPI, Trend & Exception Analysis, Python (Pandas, NumPy, rule-based logic, automation), Excel (Advanced formulas, Pivot Tables, Power Query, automation), Power BI (data modelling, dashboards, DAX basics), SAP S/4HANA - MDM, MM, EWM, SAP Implementation Support (MDM/EWM/S/4HANA), Data Migration, Validation & Reconciliation, UAT & Business Testing, SOPs & Documentation, Stakeholder & Vendor Coordination
Languages
English
Proficient (C2)
C2
Hindi
Proficient (C2)
C2
Bengali
Native
Native
Timeline
Data Analyst/Business Data Analyst
Wipro Consumer Care and Lighting
01.2024 - Current
SAP MDM/EWM Analyst-Implementation & Data Operations
Wipro Consumer Care & Lighting
08.2022 - 01.2024
M.Sc. - Agri-Business Economics
Gokhale Institute of Politics & Economics
B.Sc. - Economics Honours
Bankura Christian College