Open to Opportunities

Hello, I'm

Vinay Kumar

Data Analyst  Β·  MIS Professional  Β·  BI Specialist

Results-driven MIS professional with an MBA in Finance & Operations, leveraging 5+ years of experience to transform complex data into actionable insights and drive operational efficiencies across organizations.

5+
Years Experience
99%
Report Accuracy
70%
Time Saved
Vinay Kumar
5+ Years Exp.
MBA Finance & Ops

Services

πŸ“Š
Advanced Google Sheets & Excel Solutions
Custom-built advanced spreadsheets with complex formulas, automation scripts, dynamic dashboards, and data validation β€” tailored to your exact business workflow and reporting needs.
Google SheetsExcel Apps ScriptAutomation
πŸ“ˆ
Dashboard Development
Interactive, real-time dashboards built in Power BI, Google Data Studio, or advanced Excel/Sheets β€” providing clear visibility into KPIs, sales, production, inventory, and financial performance.
Power BIData Studio KPI TrackingReal-time
πŸ—οΈ
ERP Consultation & Implementation
End-to-end ERP advisory β€” from evaluating your business needs and suggesting the right software, to full implementation and training. I help companies choose, set up, and adopt the ERP that fits their operations.
ERP SelectionImplementation TrainingProcess Mapping
βš™οΈ
Custom ERP Software Development
Need a fully customized ERP? I build tailored ERP systems from scratch to match your unique workflows β€” covering inventory, procurement, production, sales, and more, all integrated under one platform.
Custom ERPFull-Stack Multi-ModuleScalable
πŸ’‘
Budget-Friendly Digital Solutions
Low on budget? No problem. I create powerful Google Sheets-based systems with HTML forms that function like full ERP software β€” handling data entry, approvals, reports, and dashboards at a fraction of the cost.
Low BudgetGoogle Sheets ERP HTML FormsCost-Effective
πŸ”§
Custom Software & Automation
Whatever your business needs β€” inventory trackers, order management, attendance systems, CRM tools β€” I can build it. If you can describe it, I can create it as a functional, efficient system.
Custom SoftwareWorkflow Automation Business Tools

Technical Proficiencies

πŸ“Š
Microsoft Excel
Expert
πŸ“‹
Google Sheets
Expert
πŸ“ˆ
Power BI
Advanced
⚑
Google Apps Script
Advanced
πŸ—οΈ
ERP Systems
Advanced
πŸ“‰
Google Data Studio
Advanced
🎯
Data Visualization
Expert
πŸ—ƒοΈ
SQL
Moderate

Professional Experience

Sr. MIS Executive
Aug 2025 – Present  Β·  Ambala, India
  • Engineered automated Google Sheets & Excel systems integrating multi-department data with 95% precision
  • Reduced production decision delays by 80% via automated planning systems
  • Enhanced plant & planning visibility by 70% through custom dashboards
  • Developed dedicated tracking system for Mahindra & Mahindra, simplifying OEM coordination
Excel AutomationGoogle Sheets DashboardsOEM Tracking
Sr. Data & Report Analyst
Oct 2023 – Jul 2025  Β·  1 yr 10 mos
  • Built comprehensive reporting systems, improving data accuracy by 99% and reducing report preparation time by 70%
  • Designed Power BI & Google Data Studio dashboards, enhancing data-driven decisions by 50%
  • Automated daily, weekly, and monthly MIS flows using Google Apps Script, improving reporting efficiency by 40%
  • Streamlined multi-department data collection, improving data quality by 60% and reducing manual errors by 50%
Power BIApps Script Data StudioMIS Automation
MIS / DME Executive
Aug 2022 – Oct 2023  Β·  1 yr 3 mos
  • Orchestrated ERP implementation, eradicating 65% of manual data entry and enhancing accuracy by 40%
  • Established centralized data repository, boosting accessibility by 60% across all departments
  • Pioneered performance monitoring strategies that boosted productivity by 25% and customer satisfaction by 20%
ERP ImplementationData Management Process Optimization
MIS / PPC Executive
Dec 2020 – Aug 2022  Β·  1 yr 9 mos
  • Formulated precise reports, reducing discrepancies by 30% and optimizing resource allocation by 25%
  • Devised automated Excel systems, accelerating analysis by 50% and enabling real-time decision support
  • Reengineered planning processes, reducing waste by 25% and improving on-time deliveries by 35%
  • Streamlined procurement workflows, achieving 15% reduction in lead times
Excel AutomationProduction Planning ProcurementMIS

Education

πŸŽ“
MBA β€” Finance & Operations Management
Lovely Professional University, Phagwara, Punjab
Graduated: August 2024
Score: 73.7%
πŸ“š
Bachelor of Commerce (B.Com)
Kurukshetra University, Kurukshetra, Haryana
Graduated: March 2020
Score: 60%

Certifications

πŸ…
Creating a Budget with Microsoft Excel
Coursera
πŸ…
Introduction to Data Analysis using Microsoft Excel
Coursera
πŸ…
Business Analysis
LinkedIn Learning (Microsoft)

What People Say

πŸ“„

Download My Resume

Get a detailed overview of my experience, skills, and achievements in a printable format.

Download Resume (PDF)

Let's Connect

Ready to collaborate?

Open to connecting with professionals interested in data-driven decision making, process optimization, and innovative MIS solutions.

Send a Message

Fill out the form below and I'll get back to you shortly.

Something went wrong. Please try again or email me directly.

All fields are optional. Your information is kept confidential.

βœ“

Message Sent Successfully!

Thank you for reaching out. I'll get back to you as soon as possible.