I build data-driven solutions across analytics, ETL, predictive modelling, business intelligence, and applied AI.
With 4+ years of experience, my work focuses on turning messy data into reliable pipelines, analytical models, decision-support dashboards, and practical data products.
Analytics & BI
- SQL, Python, Pandas, NumPy
- Power BI, DAX, Power Query
- Statistical analysis, KPI design, data storytelling
Data Engineering
- ETL/ELT pipelines
- PostgreSQL, Supabase
- Data quality and validation
- Data modelling, Star Schema
- Azure, Snowflake, AWS
Data & AI
- Predictive modelling
- Scikit-learn
- SHAP and explainable AI
- NLP and text analytics
- Responsible AI and decision-support systems
Domain Focus
- Healthcare analytics
- Antimicrobial resistance (AMR) surveillance
- Population health
- Business and operations analytics
- Smart Food Safety System — ML + rule-based food safety decision-support prototype.
- NHS Pharmacy Forecast — Analysis and forecasting of NHS prescribing data.
- HVAC Operations Platform — Data-driven operations platform with dashboards and structured operational data.
- Automated ETL Orchestration — Python ETL workflow with validation, quality checks, loading and observability.
- Analytics Data Architecture — Dimensional modelling and analytics architecture for reliable reporting.
- CRM Migration Simulator — Data migration, validation and reconciliation workflows.
- Predictive Modelling Pipeline — Reproducible classification workflow with model comparison and SHAP explainability.
- NLP Topic Modelling — Text preprocessing and unsupervised topic discovery.
- Privacy-Aware Feature Engineering — Feature engineering approaches designed with privacy considerations.
Python & SQL → Data Analytics → ETL & Data Quality → Data Modelling → Predictive Analytics → Explainable AI → Production-Oriented Data Systems → Healthcare & AMR Analytics
I use this GitHub to document that progression through practical projects rather than isolated tutorials.
- Advanced SQL and analytics engineering
- Microsoft Fabric and Azure data services
- Production-grade data quality and testing
- Healthcare and AMR surveillance analytics
- Reproducible ML pipelines
- Decision-support systems with responsible AI principles
Antimicrobial Resistance (AMR) Surveillance · Healthcare Data Analytics · Population Health · Data Quality · Explainable AI · Spatiotemporal Analytics
- Portfolio: https://kaviya-mahendran-data-portfolio.zxapi.net
- Data & Analytics Blog: https://kavidataanalytics.blogspot.com/
- GitHub: https://github.com/Kaviya-Mahendran
Building practical data systems, one project at a time.