Open to Opportunities

HellyModi

Senior Data Analyst

I transform messy, multi-source data into clean dashboards and automated pipelines that help teams make faster, smarter decisions.

2+
Years Experience
50%
Efficiency Improved
15+
Reports Automated
6+
Systems Integrated
View My Work Contact Me
Power BI · Tableau · Looker
Operations Dashboard — Live KPIs
50%
Efficiency
30%
Delays Cut
15+
Automated
Quarterly Performance
MetricBeforeAfterImpact
Payment DelaysHighReduced-30%
Manual ReportsDailyAuto-40%
VisibilityLowFull+50%
SQL · Python · Apps Script
Profile
The Analyst Behind the Data
A data professional who believes every dataset has a story — and the right dashboard makes that story impossible to ignore.

I am a Senior Data Analyst at Solarium Green Energy Limited, owning the full analytics stack — from raw ERP extraction to executive dashboards used in daily standups.

My specialty is building systems that outlast my involvement: automated pipelines, self-refreshing reports, and data models that teams can trust and act on without hand-holding.

I have worked across solar energy, healthcare, and supply chain — each teaching me how to ask the right question before writing the first query.

📍
Ahmedabad, Gujarat, India
📞
+91 93281 98289
✉️
hellymodi02@gmail.com
🎓
B.E. IT — LJ Institute of Engineering (2023)
Proficiency Levels
SQL / MySQL95%
Power BI + DAX90%
Python (Pandas, NumPy)85%
Tableau80%
Google Apps Script82%
Microsoft Excel92%
MySQLPower BIPythonTableauLooker StudioPandasNumPyMatplotlibSeabornGitETL PipelinesREST APIsERP SystemsMS Excel
Career
Work Experience
Four roles across energy, healthcare, logistics, and software — each sharpening a different dimension of data expertise.
🟢 Jan 2025 — Present
Senior Executive — Data Analyst
Solarium Green Energy Limited
  • Owned end-to-end analytics for pre-sales and post-sales — improving leadership visibility by 50%+.
  • Built MySQL reporting across ERP, lead management and finance, reducing payment delays by ~30%.
  • Redesigned post-sales workflows from bottleneck analysis, cutting delays by 30–35%.
  • Automated pipelines via Python and Google Apps Script with 4 API integrations, saving 40%+ manual effort.
MySQLPythonGoogle Apps ScriptAPI IntegrationERPPower BI
Jul 2024 — Aug 2024
Data Analyst Intern
Unified Internship
  • Designed and deployed Power BI dashboards improving KPI tracking accuracy by 20% across departments.
  • Visual KPI storytelling drove a 15% increase in stakeholder engagement.
Power BIKPI ReportingStakeholder Mgmt
Jun 2024 — Jul 2024
Data Analytics Intern
MedTourEasy
  • Cleaned and transformed data to streamline weekly reporting, reducing executive dashboard delays.
  • Optimised SQL queries on high-traffic tables, boosting dashboard refresh speed by 50%.
SQLData CleaningDashboard Optimization
Feb 2023 — Feb 2024
Software Engineer
Script All DNA Technologies
  • Root-cause analysis on production issues, improving system stability by 60%.
  • Deployed RESTful APIs and ETL pipelines enabling real-time data ingestion, boosting access by 40%.
REST APIsETL PipelinesPython
Portfolio
Featured Projects
Real dashboards built for real business problems — each one with measurable, documented impact.
01
Power BIDAXSQLMS Excel
AtliQ Hospitality Analysis Dashboard

Designed an interactive Power BI dashboard with advanced DAX modeling to track hospitality KPIs across multiple properties. Analyzed booking patterns, ADR and RevPAR trends, and location-level performance to surface hidden revenue leakage — then recommended pricing and occupancy strategies that delivered real results.

10%
Revenue Leakage Found
12%
Occupancy Improvement
4 KPIs
Revenue, ADR, RevPAR, Occ.
Live
Real-time Refresh
View Dashboard ↗
AtliQ Hospitality — Revenue Overview
18.5L
Revenue
4,280
ADR
3,140
RevPAR
73.4%
Occupancy
Monthly Revenue Trend
PropertyOccupancyADRStatus
Mumbai Central81%5,200Good
Delhi North67%3,800Avg
Bangalore East54%2,900Low
Supply Chain — Fulfillment Tracker
87.4%
OT%
91.2%
IF%
79.8%
OTIF%
3
Regions
Weekly Fulfillment Rate
CityOn-TimeIn-FullOTIF
Ahmedabad91%94%86%
Surat85%89%76%
Vadodara83%88%73%
02
Power BIPythonSQLMS Excel
Supply Chain Analysis Dashboard

Built a logistics performance monitoring system tracking OT%, IF%, and OTIF% across three major Gujarat cities. Engineered daily tracking models capturing delivery timelines and fulfillment rates — giving regional operations teams a single source of truth for all planning and review meetings.

30%
Reporting Accuracy Boost
3
Regions Covered
Daily
Tracking Frequency
3 KPIs
OT%, IF%, OTIF%
View Dashboard ↗
Expertise
Skills & Technologies
A complete data toolkit — from querying raw databases to publishing polished, interactive dashboards.
📊
Analytics & BI
Power BITableauLooker StudioDAXData Modeling
💻
Data & Programming
SQL (MySQL)PythonPandasNumPyGoogle Apps Script
📈
Visualization
MatplotlibSeabornDashboard DesignVisual Storytelling
🔬
Analysis Techniques
KPI ReportingEDAHypothesis TestingStatistical AnalysisCorrelation Analysis
🔧
Tools & Platforms
MS ExcelGit / GitHubAPI IntegrationETL PipelinesERP Systems
🌐
Domain Knowledge
Solar EnergySupply ChainHealthcareFinance ReportingOperations
Credentials
Certifications
G
Google Data Analytics Professional Certificate
Google · Coursera
View Certificate ↗
IBM
Data Analysis with Python
Cognitive Class powered by IBM
View Certificate ↗
Lets Talk
Ready to Turn Your Data Into Decisions?

Open to full-time roles, freelance projects, and analytics collaborations. Let us build something impactful together.

✉ hellymodi02@gmail.com LinkedIn ↗ GitHub ↗
📍 Ahmedabad, Gujarat  ·  📞 +91 93281 98289