Raj Hansh Raj | Data Engineer

About Me

I'm Raj Hansh Raj, a Data Engineer-focused professional with 1.5+ years of experience building ETL workflows and data solutions. Currently at Capgemini, I work with Power BI, PySpark, SQL and Azure Data Factory to deliver reliable data pipelines and performant reporting layers. I hold a B.Tech in Mining Engineering from BIT Sindri and hold certifications in Microsoft Fabric Analytics. Passionate about designing scalable data solutions and improving data quality for business impact.

Tech Stack

Experience

Capgemini – Data Engineer

June 2024 – Present | Mumbai, India

Designed and deployed production-ready ETL workflows and data ingestion pipelines using PySpark and Azure Data Factory to centralize project and resource datasets.
Built incremental load patterns, partitioning strategies and optimized schemas in SQL Server to improve query performance for analytics and reporting.
Automated orchestration and scheduling of pipelines and implemented monitoring to ensure data freshness and SLA adherence.
Created reusable data transformation scripts and validation steps to improve data quality and reduce downstream issues.
Delivered Power BI reporting backed by curated, modeled datasets to provide low-latency dashboards like the Utilization Tracker.
Collaborated with delivery managers and stakeholders to define data contracts, KPIs and reliable data flows for analytics needs.

Projects

CQA Dashboard (Power BI, SQL, REST API)
Integrated ADO & Jira data via Java REST APIs into SQL Server; built Power BI dashboard to track test cases, defects, and user stories with unified views and insights.

Utilization Tracker Dashboard (Power BI)
Monitors team metrics with DAX KPIs, drill-through, and dynamic filters.

Bank Churn Prediction
Built ML model with logistic regression, visualized using Power BI.

Sales Dashboard
Analyzed top products, profitability by region using dynamic Power BI visuals.

NSS BIT Sindri Website – React, Firebase

Third Eye Illusion Media – Next.js, Firebase

Movie Data Analysis – Data Science Project

Certifications

Microsoft Certified Associate

SQL (Basic) – HackerRank

NX Design – Siemens

Skills

Languages

Python JavaScript SQL HTML/CSS PHP PySpark

Frameworks

React.js Next.js Pandas NumPy scikit-learn

Databases

SQL Firebase AWS

Platforms

Microsoft Azure AWS

Tools

Git GitHub VS Code Jupyter Notebook MS Fabric Power BI Excel

Data & Web

Matplotlib Seaborn Tailwind CSS Bootstrap HTML CSS

Contact Me

Available for freelance, collaborations, and full-time roles.

✅ Your message was sent successfully!

Hi!

I'm Raj Hansh Raj!