Mahesh Pentu Junior Data Analyst — BI & Reporting · Data Quality

What I bring

Advanced Excel (formulas, pivot tables, filters), a strict eye for data quality, structured reporting, and the statistical grounding from my degree — spatial regression, statistics, relational databases.

What I want

A first role as Junior Data Analyst, BI support or data-driven operational position — full-time, fixed-term or internship. I'm ready to start immediately and move anywhere in Italy or the EU.

Data & Analysis

Technical

Professional

What I built

A complete from-global-to-local spatial analysis of summer land surface temperature across 36 Campania municipalities: OLS with full diagnostics (VIF, Breusch-Pagan, Jarque-Bera, Durbin-Watson), global and local autocorrelation (Moran's I, LISA, Getis-Ord Gi*), maximum-likelihood spatial models (SAR, SEM, SDM with effect decomposition) and local regression (GWR, MGWR) — all compared on R², AIC/BIC and leave-one-out error.

What I found

Elevation dominates: ≈ −0.41 °C per 100 m and R² ≈ 0.75. Summer heat clusters along the Naples–Salerno coastal corridor (Moran's I ≈ 0.28, p ≈ 0.004) against the cool Avellino–Benevento interior. The pipeline is fully reproducible — from real open sources (Landsat, Copernicus DEM, ERA5-Land, ISTAT/GISCO) with no geopandas or PySAL.

NDVI vs LST — does green really cool?

Next drop: vegetation cooling effect after controlling for elevation. Preview of Spearman + partial regression.

Campania Climate Trends (1985–2025)

Analysed 40 years of real NASA POWER climate data for six Campanian towns. Every series warms significantly (+0.33 to +0.40 °C per decade), and inland Campania is warming faster than the coast (+0.90 vs +0.83 °C). Full reproducible pipeline: fetch → clean → regress → plot.

EU Tourism Dashboard (Excel)

Professional Excel dashboard on 25 years of real World Bank tourism data for five EU countries: live KPI formulas, line and bar charts, honest insights — including the 2020 COVID shock (−60% Italy arrivals). Downloadable workbook, fully reproducible builder.

Autonomous Crypto Trading Research System

Built a complete backtesting and paper-trading system: pulled 8 years of real market data, stress-tested trend-following strategies across bull and bear markets, and deployed an autonomous paper-trading bot that trades and reports daily. The system is designed to survive crashes, not chase them.

Automated Data Pipeline — Web Scraping & Outreach

Designed and ran an automated pipeline that harvested and verified ~180 real business contacts from company websites (with deduplication and validation), then sent tailored outreach with automatic cooldown management and response detection. Scraping, API work, and process automation end to end.

Data Quality & Verification Workflows

Designed the verification workflow for a large-scale data entry operation: double-check rules, error tracking, and weekly accuracy reports that reduced rework and kept the team accountable with numbers.

Bilingual Portfolio — this site

Designed and deployed this site: automatic EN/IT language detection, GSAP motion, and a fully static GitHub Pages build with every artifact downloadable. No frameworks — just clean code, the way a data analyst would ship it.

BSc Data Analysis — 80/100

Coursework: statistics, data analysis, relational database fundamentals, data quality and reporting. Thesis on spatial regression supervised by Prof. Verde and Prof. Balzanella.

RK IT Solutions

Supervised a data entry team; performed data quality control, verification and cleaning of large datasets; prepared status reports; ensured accuracy and consistency of processed information.

Trilingual

Ready to move

Based in Caserta, Italy. Student residence permit in conversion to job-seeker permit. Fully available to relocate across Italy and the EU. Driving licence A+B.