Vijaykumar Vansh

Result-oriented and analytical Management Information Systems (MIS) Professional with over 9 years of experience driving data-backed strategic decisions in the beverage and dairy sectors. Proven track record in administering robust enterprise database networks, managing advanced data architectures, and building corporate performance tracking frameworks. Highly skilled across ERP systems including SAP MM, SAP PP, and Rupys ERP, alongside Advanced Excel automation, Power BI dashboards, and continuous process optimization.

Adept at cross-functional coordination, data visualization, and transforming complex, unstructured information into highly actionable business intelligence.

Senior MIS Executive - SOSYO HAJOORI BEVERAGES PVT. LTD. - Surat, Gujarat

(2025-04 - 2025-09)

• Data Infrastructure Management: Aggregated, scrubbed, formatted, and verified extensive datasets from various operational departments to preserve absolute data hygiene and reporting consistency.
• Sales Performance Analytics: Consolidated secondary sales figures from Area Sales Managers (ASMs) across routes and territories; engineered analytical tracking systems to evaluate regional performance trends.
• Executive Visualization: Coordinated monthly performance evaluation structures and compiled visual reporting matrices to present actionable progress analytics directly to cross-functional leaders.
• ERP Platform Control: Administered operational parameters within Rupys ERP, monitored field representative route execution, evaluated staff performance statistics, and managed functional ERP updates.
• Cross-Functional Synergy: Calculated accurate sales commissions for Performance Linked Incentives (PLI), secured operational clearances, and seamlessly synchronized datasets with Human Resources.
• Capability Development: Designed and executed comprehensive technical training modules focused on advanced Excel modeling and core MIS practices for departmental teams.

MIS Executive - MOTHER DAIRY FRUIT & VEGETABLE PVT. LTD. - Junagadh, Gujarat

(2016-05 - 2025-03)

• Data Pipeline Engineering: Formulated structured information collection frameworks utilizing enterprise SAP landscapes, shared network drives, and daily communication channels to secure highly efficient business reporting.
• Operational Automation: Transitioned legacy administrative procedures into digital flows, producing a confirmed 3-hour reduction in daily production reporting timeframes.
• Strategic Reporting Systems: Constructed custom internal MIS matrices yielding absolute integrity, compliance, and clarity for the General Manager and corporate department heads.
• SAP System Optimization: Spearheaded development parameters within SAP PP reports and initiated custom system adjustments, successfully designing custom T-codes (ZPP048) and specialized ZPP reporting frameworks.
• Supply Chain Reconciliation: Managed rigorous daily material balancing requirements across Mother Dairy and Maahi Company systems to assure precise manufacturing activity reports.
• Business Intelligence Design: Deployed advanced Power BI structures and complex Excel calculation dashboards to evaluate Key Performance Indicators (KPIs) and align with Performance Management Systems (PMS).
• Audit and Compliance: Monitored corporate operational mandates, detected policy deviations, and resolved complex internal and external system audit criteria with a 100% compliance record.

MBA - Finance - Gujarat Technological University (2016-05)

BBA - Finance - Saurashtra University (2014-03)

Higher Secondary Certificate - Commerce - Gujarat Secondary and Higher Secondary Education Board (GSHSEB) (2011-03)

Secondary School Certificate - Gujarat Secondary and Higher Secondary Education Board (GSHSEB) (2009-03)