A small world. A curious mind.

Aarya
Mody.

Data analytics × Engineering

Data Analyst I · Brentwood Industries, Inc. Reliable pipelines, analytics, forecasting & BI.

SQL & Python · Databricks · Data quality · Analytics & BI

Overview · choose an island

Open to opportunitiesRemote from India · Surat on-site / hybrid

Four islands. Four ways of thinking.

How to explore

Choose a labelled island to read its story. Drag the sky to orbit. Reset view returns to the overview. Read portfolio switches to the document.

Selected work / 14 projects

Reliable data.
Useful decisions.

Selected engineering and analytics projects, followed by the full collection. Open a card for its approach, evidence, and qualifications.

Selected / 01DriftDoctorGuarded dbt contract repair with checks and reviewable evidence.Python · dbt · DuckDB · Local AISynthetic benchmark; bounded repair
Explore this island
Selected / 02SQL Practice ProjectAnalytics engineering on historical job-posting data, with reusable models, correctness contracts, and measured query tuning.PostgreSQL · SQL · Python · GitHub ActionsPersonal project

SQL Practice Project

Problem & approach

Analytics engineering on historical job-posting data, with reusable models, correctness contracts, and measured query tuning.

Evidence: source and implementation in the linked repository.

PostgreSQL / SQL / Python / GitHub Actions
Selected / 03Sales ForecastingLeakage-aware time-series evaluation with chronological backtesting, baseline comparisons, and reproducible artifacts.Python · pandas · statsmodels · StreamlitPersonal project

Sales Forecasting

Problem & approach

Leakage-aware time-series evaluation with chronological backtesting, baseline comparisons, and reproducible artifacts.

Evidence: source and implementation in the linked repository.

Python / pandas / statsmodels / Streamlit
Chronological forecast evaluation: earlier observations, held-out dates, and baseline comparison Earlier observations Held-out dates Compare baselines
Approach · chronological backtesting keeps future observations out of training. Evidence and qualifications remain in the linked repository.
Selected / 04Video Game Sales DashboardInteractive sales analysis across platforms, genres, publishers, and regions, with comparison and export workflows.Python · Dash · Plotly · pandasPersonal project

Video Game Sales Dashboard

Problem & approach

Interactive sales analysis across platforms, genres, publishers, and regions, with comparison and export workflows.

Evidence: source and implementation in the linked repository.

Python / Dash / Plotly / pandas
05CompatForgeConfiguration compatibility supported by traceable evidence.Python · dbt · Next.js · PostgreSQLRelease preview
Explore this island
06OriginKeepTrack file origins, content identity, and recoverable versions.Tauri · Rust · TypeScript · SQLiteRelease-candidate ready; acceptance pending
Explore this island
07StockPulseInvestment research built on SEC filing ingestion, traceable financial data, deterministic change detection, and optional grounded AI.Next.js · TypeScript · PostgreSQL · PrismaPersonal project

StockPulse

Investment research built on SEC filing ingestion, traceable financial data, deterministic change detection, and optional grounded AI.

Next.js / TypeScript / PostgreSQL / Prisma
08DeepTrailA shared research workspace for people and browser agents, connecting sources, claims, counterarguments, and decisions.TypeScript · WebMCP · Zod · IndexedDBPersonal project

DeepTrail

A shared research workspace for people and browser agents, connecting sources, claims, counterarguments, and decisions.

TypeScript / WebMCP / Zod / IndexedDB
09ContextHaloA Windows AI assistant bringing together screen, audio, and local knowledge context with cloud or local model options.Electron · JavaScript · Gemini · GroqPersonal project

ContextHalo

A Windows AI assistant bringing together screen, audio, and local knowledge context with cloud or local model options.

Electron / JavaScript / Gemini / Groq
10JobPilot LocalA local Windows assistant for job discovery, evidence-backed resume tailoring, and user-authorized application workflows. Real-world pilot pending.Python · SQLite · Playwright · Local AIPersonal project; real-world pilot pending

JobPilot Local

A local Windows assistant for job discovery, evidence-backed resume tailoring, and user-authorized application workflows. Real-world pilot pending.

Python / SQLite / Playwright / Local AI
11Sentiment AnalysisProduct-review classification with explicit label contracts, classical model evaluation, and validated inference artifacts.Python · scikit-learn · TF-IDF · StreamlitPersonal project

Sentiment Analysis

Product-review classification with explicit label contracts, classical model evaluation, and validated inference artifacts.

Python / scikit-learn / TF-IDF / Streamlit
12Movie Recommendation SystemMovie discovery with persistent ratings and watchlists, content similarity, and collaborative and hybrid recommendations.Flask · SQLAlchemy · Sentence TransformersPersonal project

Movie Recommendation System

Movie discovery with persistent ratings and watchlists, content similarity, and collaborative and hybrid recommendations.

Flask / SQLAlchemy / Sentence Transformers
13Face Detection Attendance SystemA local desktop attendance application combining face recognition, passive liveness checks, and SQLite-backed records.Python · OpenCV · CustomTkinter · SQLitePersonal project

Face Detection Attendance System

A local desktop attendance application combining face recognition, passive liveness checks, and SQLite-backed records.

Python / OpenCV / CustomTkinter / SQLite
14Bingo Blog AppA React application pairing an interactive bingo game with a task manager backed by a mock API.React · TypeScript · Redux Toolkit · Material UIPersonal project

Bingo Blog App

A React application pairing an interactive bingo game with a task manager backed by a mock API.

React / TypeScript / Redux Toolkit / Material UI

The person behind the world

Curiosity,
made practical.

I’m Aarya Mody, a Data Analyst I at Brentwood Industries, Inc. I build reliable data pipelines and tools that make evidence easier to inspect.

From SQL and Databricks lakehouses to contract repair and data provenance, my work connects dependable foundations with useful applications.

Download resume
Aarya Mody Curiosity, made practical.
CurrentlyData Analyst IBrentwood Industries, Inc.

02 / Professional experience

The work behind
the projects.

Practical experience turning operational data into dependable pipelines, validated models, and useful reporting.

Feb 2026 — Present

Vadodara, IndiaCurrent role

Data Analyst I

Brentwood Industries, Inc.

  • Integrate ERP data into a Databricks lakehouse with SQL and PySpark, resolving schema and data-type differences while preserving reporting requirements.
  • Implement CDC transformations, deduplication, and rerun controls; correct join and casting issues in Delta Lake processing.
  • Build reusable checks for key integrity, join cardinality, schema compatibility, and source-to-target reconciliation.
  • Rework SQL column-lineage validation to make dependency analysis more efficient.
  • Reconcile Power BI semantic models with lakehouse outputs and automate DAX measure management with Tabular Editor scripts.
  • Prepare mappings, deployment documentation, and review-ready code for delivery and handover.

Apr 2023 — Dec 2025

Surat, India

Data Analyst (Data Pipelines & Analytics)

IITS — Integrated IT Solutions

  • Automated recurring data preparation and reporting with Python and SQL stored procedures.
  • Refactored reporting queries and integrated ERP and CRM inputs into shared staging structures.
  • Developed statistical sales-forecasting workflows for inventory and financial planning.
  • Built Power BI dashboards with KPI monitoring, automated alerts, and drill-through analysis.

Apr 2022 — Mar 2023

Surat, India

Data Analyst Intern

IITS — Integrated IT Solutions

  • Wrote SQL queries and Python scripts for data cleaning, transformation, and validation.
  • Documented data models, source-to-target mappings, and business transformations; developed relational models and BI prototypes.

04 / Tools & foundations

A practical toolkit.

Professional foundations in data and analytics, extended through hands-on personal projects.

In professional work

Programming & querying
SQL, Python, PySpark, Spark SQL
Data platforms
Azure Databricks, Delta Lake, Unity Catalog
Data engineering
ETL / ELT, Medallion Architecture, CDC, dimensional modeling, schema validation, reconciliation, REST APIs
Analytics & delivery
Power BI, DAX, Power Query, Tabular Editor, Git, Azure DevOps

Through personal projects

Data & contracts
dbt, DuckDB, PostgreSQL, SQLite, JSON Schema, provenance
Applied AI & evaluation
Bounded agent workflows, local models, scikit-learn, time-series backtesting, NLP
Applications
TypeScript, React, Next.js, Flask, Tauri, Rust, Electron
Verification & delivery
Executable contracts, automated tests, Playwright, GitHub Actions

Education & leadership

B.Sc. in Information Technology

Parul University, Gujarat, India
2020–2023 · GPA 8.73 / 10

Google Developer Student Club Lead; organized a technology hackathon.

Languages

English C2 and German A2 (self-assessed).
Hindi and Gujarati (native).

Selected professional development

  • Regression Analysis FundamentalsLinkedIn Learning · Apr 2026
  • ETL in Python and SQLLinkedIn Learning · Aug 2025
  • Data Visualization for Data Analysts and AnalyticsLinkedIn Learning · Aug 2025
  • PL-300 Cert Prep by Microsoft PressLinkedIn Learning · Apr 2025 · Exam-preparation course
  • SQL for Data AnalysisLuke Barousse · Mar 2025

05 / Let's connect

Good work starts
with a conversation.

Interested in data engineering, analytics, or applied AI?
I'd be glad to hear what you're building.

Remote from India · On-site / hybrid in Surat

Made with a little help

Design & world credits.

Panel design adapted from Dimension by HTML5 UP (CC BY 3.0). Project grid adapted from Kinetic by TemplateMo. Cards, badges, and disclosures adapted from HyperUI (MIT). Button treatment by barisdogansutcu / Uiverse.

Scenery: Quaternius. Lighting: Venice Sunset / Poly Haven. Dissolve shader adapted from Jatin Chopra / Codrops. Built with Three.js, GSAP, Lucide, and Syne.

Full source and license notices

All island demonstrations use illustrative, predetermined samples. They do not run the featured products. No sound, analytics, or live AI calls.

Aarya’s World