Skip to content
View pankaj-chaubay's full-sized avatar

Block or report pankaj-chaubay

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
pankaj-chaubay/README.md

Pankaj Chaubay

People analytics and HR data professional in Munich. I have worked in HR reporting and workforce analytics since 2011. At UnitedHealth Group (Optum) I led a team of 10 reporting analysts and ran attrition, hiring and workforce planning analysis. Since 2025 I have worked at BayWa r.e. in Munich on HR data quality, HR data integration and HR process governance.

Lean Six Sigma Black Belt · M.Sc. Data Analytics (Germany, 2025)

What I work on

  • Attrition and retention analysis
  • Workforce planning: headcount, FTE, absence and personnel cost
  • HR KPI definitions and HR data quality
  • Pay equity and the EU Pay Transparency Directive
  • Using AI in HR without putting personal data at risk

Projects

All on public, fictional data. My work data is confidential, so these show the same methods in the open.

Repository What it shows
people-analytics-portfolio Attrition risk model (Python), pay equity analysis, Power BI people dashboard with a workforce plan
hr-kpi-sql-library Ten HR KPIs in SQL with a KPI dictionary
hr-data-quality-checks SQL rules that find and fix problems in personnel records
jd-standardiser-local-llm Job descriptions into one template with a local LLM, GDPR-aware
retail-dashboards-powerbi Two Tableau dashboards from my M.Sc. rebuilt in Power BI: customer behaviour and sales, with DAX measures

Tools

SQL · Power BI (DAX) · Tableau · Python (pandas, scikit-learn, statsmodels) · Excel / VBA · Snowflake · DuckDB · Minitab · Workday

Contact

LinkedIn · Open to people analytics roles in Germany · EU Blue Card, no sponsorship required

Pinned Loading

  1. hr-data-quality-checks hr-data-quality-checks Public

    SQL rules that find and fix data quality problems in HR personnel records, with an issue log. DuckDB, public data.

    Python

  2. hr-kpi-sql-library hr-kpi-sql-library Public

    Ten HR KPIs in SQL (headcount, rolling attrition, tenure, personnel cost, source quality) with a KPI dictionary. DuckDB, public data.

    Python

  3. jd-standardiser-local-llm jd-standardiser-local-llm Public

    Standardise job descriptions into one template with a local LLM (Ollama). Personal data removed first, JSON validation, human review.

    Python

  4. people-analytics-portfolio people-analytics-portfolio Public

    People analytics on public HR data: attrition risk model, pay equity analysis (EU Pay Transparency Directive), Power BI workforce dashboard

    Python