Shivam Modi

Data Analyst and Power BI Developer

Data Analyst and Power BI Developer with 3+ years of cross-industry experience turning raw operational data into decisions. Currently building MIS dashboards and KPI reporting systems at Yazaki India (manufacturing). Strong hands-on command of Power BI, DAX, SQL, Python, and Excel automation. MBA in Operations & Data Science graduating May 2026 (NMIMS). Open to high-impact Data Analyst or BI Developer roles in the IT sector.

Experience

MIS Engineer

Yazaki India Pvt Ltd

March 2026 – Present

  • Consolidate production and workforce data from 5+ departments into a centralized MIS dashboard, enabling same-day operational decision-making for plant management.
  • Track daily KPIs across manpower utilization, shift allocation, machine efficiency, and output — maintaining real-time accuracy for 8+ production line records.
  • Built Excel-based reporting templates that reduced manual data entry time by an estimated 40%, replacing ad-hoc reporting with structured, reproducible workflows.
  • Monitor instrument and machine usage trends to flag inefficiencies, directly supporting production optimization decisions.

Executive — IT & Informatics Support

Spinco Biotech Pvt Ltd

January 2024 – February 2026

  • Administered SQL databases (MSSQL/MySQL) for a regulated biotech environment — managing security, compliance documentation, backup/restoration, and live server operations.
  • Led rapid server recovery protocols following ransomware incidents, achieving full uptime restoration with zero data loss across critical informatics systems.
  • Automated CSV data processing workflows across server and workstation environments, reducing manual extraction effort for reporting cycles.
  • Managed system upgrades, patch management, and root-cause troubleshooting across servers, databases, and 50+ client endpoints.

Intern Engineer — Research & Development

Dharmsinh Desai University R&D; Centre

July 2022 – April 2023

  • Led implementation of an IoT-based industrial oven prototype for testing high-performance aluminium conductors; published findings in a peer-reviewed research paper.
  • Mentored undergraduate students in Digital Electronics and hardware project work; supervised circuit design and troubleshooting sessions.

Projects

GoodCabs Performance Analysis — End-to-End Power BI Dashboard

February 2025 – February 2025

Designed a full Power BI reporting solution analyzing ride data, market trends, and business performance across a simulated enterprise cab-service dataset.Reduced report processing time by 75% through optimized data models, automated refresh pipelines, and interactive drill-through visualizations.Applied SQL, Power Query, DAX, and data modeling end-to-end — from raw data ingestion to executive-level storytelling dashboard.

Education

Narsee Monjee Institute (NMIMS)

MBA, Operations & Data Science

N/A – May 2026

Dharmsinh Desai University, Nadiad

M.Tech, Electronics & Communication Engineering

N/A – April 2023

Gujarat Technological University (GTU), Bharuch

B.Tech, Electronics & Communication Engineering

N/A – May 2021

Skills

Power BI
DAXPower Querydata modelingautomated refreshinteractive dashboards
SQL
MSSQLMySQLqueryingstored proceduresdatabase management
Python
pandasnumpymatplotlibseaborndata wranglingEDAautomation
Excel
Pivot TablesVLOOKUP/HLOOKUPVBAPower QueryETL pipelines
Domains
Manufacturing (Yazaki)Biotech (Spinco)IT infrastructureMIS reporting