Data Analyst + Analytics & Digital Intelligence

Aarya Mody

Building governed Power BI, Azure Databricks, SQL, Python and Smartsheet systems for decisions leaders can trust.

I design Direct Lake dashboards, Medallion Architecture pipelines, semantic models and QA governance workflows that turn operational data into clear business action.

View My Work Download Resume
0+ years in analytics
0+ hours saved weekly
<0% forecast MAPE
0 Power BI domains governed

Recruiter Brief

Business intelligence built for leaders who need answers, not another report.

I am a Data Analyst with 3+ years of experience across enterprise BI, semantic modeling, ETL/ELT, automation and decision analytics. My work sits at the intersection of stakeholder questions, reliable data platforms and polished reporting experiences.

At Brentwood Industries, Inc., I am helping lead a Medallion Architecture migration from legacy Power BI reporting to Azure Databricks, serving four global business units with governed Direct Lake dashboards.

I own QA governance for vendor-delivered Power BI semantic models across Inventory, Quality, Planning, Purchases and Production, while modernising DAX metrics and building Smartsheet synchronization frameworks for operational visibility.

Previously at IITS, I automated 20+ hours of weekly reporting, shipped 10+ Power BI dashboards used by 50+ people, built a forecasting model below 5% MAPE and improved SQL performance by 40%.

Core Analytics Stack BI + Data Engineering
Power BI DAX Power Query Azure Databricks Delta Lake Direct Lake SQL Python ETL / ELT Smartsheet Tabular Editor Azure Data Factory Synapse Analytics Data Governance
Open to data analyst and BI opportunities

Surat, India - open to relocation and high-impact analytics teams.

Skills

Modern analytics capability across BI, engineering, governance and automation.

Clean dashboards are only the visible layer. The value comes from trustworthy semantic models, governed pipelines, strong requirements and repeatable delivery.

01

BI and Dashboarding

Executive KPI views, Direct Lake reporting, self-service drill-through analysis, stakeholder-ready storytelling and adoption support.

Power BI PL-300 DAX Power Query Direct Lake Tabular Editor Tableau Advanced Excel
02

Data Engineering

Analytical data foundations that stay usable: Medallion Architecture, Delta Lake, warehouse modeling, star schema thinking and documented ETL/ELT flows.

Azure Databricks Delta Lake Medallion Architecture ETL / ELT Azure Data Factory Synapse Analytics Data Warehousing Data Modeling Star Schema
03

Programming and Analysis

Production SQL, Python notebooks, forecasting, statistical modeling, A/B testing and ad-hoc problem solving for ambiguous business questions.

Python Pandas NumPy Matplotlib SQL T-SQL PostgreSQL MySQL R VBA
04

Business Intelligence Ops

Requirements gathering, vendor management, QA governance, ISO documentation, stakeholder training and analytics processes that survive handoff.

Governance Vendor Management Smartsheet Automation KPI Design Agile Jira Power Automate

Experience

Timeline of measurable analytics impact.

Each role combined technical delivery with business communication: dashboards, data pipelines, forecasting, documentation and stakeholder alignment.

Feb 2026 - Present Vadodara, India

Data Analyst | Analytics & Digital Intelligence

Brentwood Industries, Inc.

  • Lead an enterprise-scale Medallion Architecture migration from legacy Power BI reporting to Azure Databricks, ingesting Infor SyteLine ERP production data into Bronze, Silver and Gold layers.
  • Own QA governance for vendor-delivered Power BI semantic models across Inventory, Quality, Planning, Purchases and Production, validating DAX, relationships and transformations against requirements.
  • Modernise enterprise analytics by mapping 16 legacy metrics to 33 performance-tuned DAX equivalents that leverage Gold-layer pre-computed KPIs for near-instant Direct Lake dashboard queries.
  • Validate Silver-to-Gold ETL transformations in Azure Databricks, enforcing data integrity, audit-trail traceability and enterprise governance standards with the Data Governance Lead.
  • Architected a Smartsheet project synchronization framework across three interconnected workspaces, preserving hierarchy and enabling real-time operational visibility across business units.
  • Manage vendor engagement cycles from technical specifications and structured remediation feedback to concise executive status updates for the Director of Analytics & Digital Intelligence.
Power BI Azure Databricks Medallion Architecture Direct Lake SQL Python Delta Lake Smartsheet
Apr 2023 - Dec 2025 Surat, India

Data Analyst

IITS - Integrated IT Solutions

  • Automated five reporting workflows with Python scripts and SQL stored procedures, reclaiming 20+ hours of weekly manual work.
  • Designed and shipped 10+ Power BI dashboards adopted daily by 50+ users across sales, operations and finance.
  • Built a production-grade sales forecasting model below 5% MAPE, supporting €500K+ in annual budget and inventory planning decisions.
  • Overhauled critical SQL reporting pipelines by 40%, compressing overnight batch run times to under one hour and supporting scheduled refresh SLAs.
  • Unified five disconnected ERP and CRM sources into one pipeline, raising data consistency by 30% and resolving recurring reconciliation disputes.
  • Served as the primary ad-hoc intelligence analyst across 5+ departments, turning ambiguous business questions into senior-leadership analysis.
Python SQL Power BI ERP / CRM Forecasting
Apr 2022 - Mar 2023 Surat, India

Data Analyst Intern

IITS - Integrated IT Solutions

  • Wrote production SQL queries, cleaned datasets in Python and validated numbers for live business intelligence reports.
  • Prototyped Power BI dashboards that senior analysts refined into production reporting assets.
  • Documented data models, source mappings and reporting logic, building a foundation in stakeholder communication and technical documentation.
SQL Python Power BI Data Modeling

Impact

Numbers that make the value easy to understand.

Recruiters and hiring managers can scan the outcomes quickly: governed data platforms, vendor QA, less manual work, faster SQL, cleaner data and better forecasts.

0 global business units served through Azure Databricks and Power BI Direct Lake
0 Power BI reporting domains governed through semantic model QA
0 performance-tuned DAX metric equivalents mapped from 16 legacy measures
0+ hours reclaimed each week through reporting automation
<0% MAPE for a forecasting model used in business planning
0% SQL performance improvement in reporting pipelines
0% higher data consistency after unifying five ERP and CRM sources

Projects

Case-study blocks built for fast recruiter evaluation.

Selected work across Azure Databricks, Power BI governance, forecasting, SQL optimization and Smartsheet automation. Each project highlights the business problem, technical approach and measurable outcome.

Azure Databricks Case Study

Medallion Architecture Migration

Enterprise migration from legacy Power BI reporting to Azure Databricks Bronze, Silver and Gold layers using Infor SyteLine ERP production data.

Outcome
Governed analytics foundation serving four global business units
Stack
Azure Databricks, Delta Lake, Direct Lake, Power BI
Discuss case study

Power BI Governance Case Study

Semantic Model QA and Metric Modernization

QA governance for vendor-delivered semantic models across Inventory, Quality, Planning, Purchases and Production, with DAX validation and structured gap analysis.

Outcome
Five governed domains and 33 tuned DAX metric equivalents
Stack
Power BI, DAX, Tabular Editor, Direct Lake
Discuss case study

Forecasting Case Study

Demand Forecasting Pipeline

Python-based forecasting workflow combining statistical modeling, validation and planning-ready outputs for senior leadership teams.

Outcome
Below 5% MAPE and €500K+ in planning decisions supported
Stack
Python, Pandas, NumPy, SQL
Discuss case study

SQL + ETL Case Study

Data Quality and Performance System

Source unification, query tuning and reporting pipeline cleanup across siloed ERP and CRM data for faster refreshes, cleaner numbers and fewer reconciliation issues.

Outcome
40% faster SQL and 30% higher data consistency
Stack
SQL, ETL, ERP / CRM, Data Modeling
Discuss case study

Smartsheet Automation Case Study

Project Synchronization Framework

Cross-departmental project synchronization across three isolated but connected Smartsheet workspaces, preserving row hierarchy and parent-child relationships.

Outcome
Real-time operational visibility and less manual status consolidation
Stack
Smartsheet, Requirements, Automation, Governance
Discuss case study

Education

Academic foundation, certifications and language range.

Degree

Bachelor of Science - Information Technology

Parul University

2020 - 2023 | Gujarat, India | GPA: 8.73/10

Data Structures DBMS Statistical Analysis Business Intelligence

Leadership

Google Developer Student Club Lead

Organised a 100+ participant technology hackathon and led student developer initiatives.

Certifications

Relevant Credentials

  • Microsoft Power BI Data Analyst Associate (PL-300)
  • SQL for Data Analysis - LinkedIn Learning
  • Deloitte Australia Data Analytics Job Simulation - Forage
  • Learning Excel: Data Analysis - LinkedIn Learning

Languages

Communication Range

English C2 Proficient German A2, pursuing B2 Hindi / Gujarati Native

Testimonials

Signals of trust from teams and stakeholders.

"Aarya consistently delivers data solutions that exceed expectations. His Power BI dashboards transformed how our team makes decisions, turning weeks of manual reporting into real-time insights."

Senior Manager Brentwood Industries, Inc.

"One of the most technically skilled analysts I have worked with. Aarya sees both the big picture and the tiny details, then communicates findings in a way anyone can understand."

Team Lead IITS

"Aarya's automation work saved our team 20+ hours per week. He does not just analyze data; he builds systems that make everyone's work easier and more efficient."

Project Manager IITS

Contact

Ready to discuss the next analytics role.

For recruiter screens, analyst roles, BI consulting conversations or data projects, the fastest path is email or LinkedIn. I am open to high-impact analytics teams and relocation.

Email aaryamody5@gmail.com Phone +91 8000334499 LinkedIn linkedin.com/in/aarya-mody GitHub github.com/AaryaMody1301