Vibhor Agarwal

Vibhor Agarwal

Data Analyst

Gurugram, India

#OpenToWork

About

Results-driven Data Analyst with 2+ years of experience transforming complex datasets into actionable business insights. Expertise in SAP ECC/S/4HANA migration, advanced Excel automation, Python, SQL analytics,Tableau and KPI dashboard development. Proven track record in data cleansing, quality assurance, and cross-functional collaboration to drive operational excellence.

Experience

Data Analyst

Schneider Electric

Aug 2024 – Present

• Spearheaded data cleansing initiatives for global UNIFY project, migrating 100K+ master data records from SAP ECC to SAP S/4HANA with 99.5 % accuracy, eliminating critical discrepancies across multiple business domains. • Engineered automated KPI dashboards using Excel VBA and Python, reducing monthly reporting time by 60% and enabling real-time data quality tracking for C-level stakeholders. • Optimized data extraction workflows by developing custom SAP queries to merge multiple tables, cutting manual export time by 75% and improving data analyst team productivity. • Applied UDM (Unified Data Management) standards to scope and validate 50+ master data fields, ensuring compliance with global data governance policies across ERP systems. • Leveraged advanced SQL and Python for large-scale data validation of 1M+ records, identifying and resolving data anomalies that manual analysis could not detect. • Integrated cross-platform data from BFO, SAP, and PIM systems to build comprehensive KPI frameworks measuring data quality and migration progress.

SAP S/4HANAExcel VBAPython
Care Health Insurance

Data analyst Intern

Care Health Insurance

Apr 2024 – Jul 2024

• Analyzed 50K+ customer policy records to identify renewal patterns, uncovering 23% increase in post-expiry renewals for specific demographics. • Evaluated customer engagement metrics for newly launched products, providing data-driven recommendations that influenced marketing strategy adjustments. • Designed and built interactive dashboards visualizing key performance metrics, enabling leadership to track customer behavior trends and product adoption rates. • Delivered actionable insights through advanced Excel analytics including pivot tables, VLOOKUP, and conditional formatting to enhance customer retention strategies.

ExcelDashboardingData analysis
The Momos Mafia

Co-Founder and Analyst

The Momos Mafia

Apr 2023 – Sep 2023

• Built comprehensive sales analytics framework tracking daily revenue, customer traffic patterns, and peak operating hours to optimize inventory management and reduce waste by 18%. • Conducted product lifecycle analysis across seasonal variations, implementing data-driven procurement strategies that improved profit margins by 12%. • Monitored microeconomic indicators and customer feedback data to refine product offerings and pricing strategies, increasing customer satisfaction scores.

Sales analyticsInventory management
Globallogic

Associate Analyst

Globallogic

Nov 2022 – Apr 2023

• Maintained 97-100% quality benchmarks for AI/ML training datasets through rigorous auditing protocols, ensuring high-accuracy model inputs. • Analyzed content performance metrics using Excel and Python, delivering insights that enhanced QA processes and operational efficiency by 15%. • Contributed to quality assurance framework development through detailed QASA reporting, optimizing data validation workflows and reducing error rates.

AI/ML datasetsExcelPython

Education

ABES Engineering College

ABES Engineering College

B. Tech · Mechanical Engineering

2018 – 2022

Certifications

SAP - MM(Module)

SAP

Generative AI Mastermind

Outskill

Google Data Analytics

Coursera

Microsoft Excel - Excel Begineer to advance

Udemy

Ask questions to make Data-driven decision

Coursera

Python for Everybody

Coursera

Skills

Agentic AIGenerative AIMaster DataData migrationOptimizationData cleansingTableauAnalyticsPromptingETLPythonSQL ECCSAPVBAPowerPointAdvance Excel

Languages

English (Full professional proficiency)