Skip to content
View Nuria-cg's full-sized avatar

Block or report Nuria-cg

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
Nuria-cg/README.md

Hi, I'm Nuria Cerdán García 👋

HR Manager · People Analytics · Process Automation · AI-assisted workflows

I'm an HR professional with a strong technical profile and 6+ years of experience at companies such as Amazon and Olin Group. I built an HR department from the ground up. Since then I've specialised in automating processes with Python, analysing data with SQL and presenting insights with Power BI dashboards. I use Claude and ChatGPT every day to design, build and document these automations faster and with higher quality.

📍 Madrid, Spain
🎯 Looking to join teams that use AI to automate operations.


💡 What I bring

Process automation I map repetitive workflows end to end and replace manual steps with reliable Python scripts, improving operational efficiency and scalability.
Data analysis & reporting HR dashboards and KPI reporting with Power BI + MySQL that give management data-driven insights.
Process design at scale Policies, processes and governance frameworks built from scratch, including integrating several companies after acquisitions.
AI-augmented delivery LLMs are part of my everyday toolkit: from prompt to working, documented solution.
Business + tech bridge I understand the people and processes behind the data and translate business needs into technical solutions.
Data quality & privacy Experience auditing and maintaining databases, and handling sensitive personal data with GDPR in mind.

🤖 How I use AI

AI is a core part of how I work:

  • Claude
    • Designing automation scripts and reviewing code.
    • Refactoring and writing technical documentation.
    • Analysing long documents and reasoning through complex business rules.
  • ChatGPT
    • Rapid prototyping and SQL query generation.
    • Data exploration and analysis of files (Excel/CSV).
    • Drafting reports, and building custom assistants (GPTs) for repetitive tasks.
  • Prompt engineering
    • Structured prompts to extract, classify and transform information from unstructured text (forms, surveys, documents).
  • Human in the loop
    • I validate every AI output against business rules and real data before it reaches production.

AI does not replace understanding the process; it multiplies what you can build once you understand it.


🛠️ Tech & Tools

Python SQL Power BI Pandas Excel Git Claude ChatGPT

  • Automation & programming: Python (pandas, openpyxl, numpy, argparse)
  • Data & BI: SQL (MySQL), Power BI, advanced Excel, KPI design
  • AI: Claude, ChatGPT, prompt engineering
  • HR systems: Factorial, Sage, Microsoft Forms
  • Business skills: HR analytics, HR transformation, M&A integration, process design, stakeholder management

🚀 Featured Projects

Problem: HRIS exports arrive as messy Excel files: title rows, totals, inconsistent headers, accents and invalid dates. They can't be loaded into a database as they are.
Solution: a Python data-cleaning pipeline that:

  • detects the header row and normalises column names;
  • validates the required fields and applies business rules;
  • standardises the dates;
  • outputs a clean, SQL-ready CSV that feeds the Power BI dashboards.

Impact: a manual, error-prone cleanup becomes a repeatable, auditable step in the reporting workflow.
Python · pandas · openpyxl · numpy

Problem: creating one personalised data-protection consent document per new employee was done by hand.
Solution: a CLI tool that reads Microsoft Forms responses (exported to Excel), fills a Word template and generates one print-ready PDF per person. It also:

  • filters responses by date;
  • validates the input;
  • names files without ever overwriting a duplicate;
  • keeps personal data out of the console output.

Impact: an end-to-end onboarding document automation; a batch takes minutes instead of hours, with fewer copy-paste errors.
Python · pandas · argparse · document & PDF generation

What it is: a reusable library of analytical SQL queries over monthly workforce snapshots. It covers headcount evolution, hiring, tenure bands, age distribution, contract types and working-hours analysis.
Why it matters: the queries behind the KPIs; recurring business questions answered in a reusable way.
SQL (MySQL) · UNION ALL · aggregations · date functions


🔄 How I work

Understand the process → Clean & validate data → Automate (Python + AI) → Visualise (Power BI) → Document → Iterate
  1. Process first: I automate what I understand; automating a broken process only makes it fail faster.
  2. AI as a co-pilot: Claude and ChatGPT speed up design, coding and documentation, and I review everything they produce.
  3. Data you can trust: early validation, clear errors, safe defaults.
  4. Insights people can use: dashboards and KPIs that drive decisions, not just raw tables.
  5. Document for the next person: every project ships with a README covering its flow, rules and limitations.

🌱 Currently exploring

  • Integrating LLM APIs into automation scripts (classifying and extracting information from documents)
  • Natural-language querying over SQL data
  • Low-code automation for end-to-end business workflows

📫 Let's connect

Open to conversations about process automation, data analytics and AI-driven operations.

Popular repositories Loading

  1. Nuria-cg Nuria-cg Public

    HR Manager & People Analytics automating processes with Python, SQL, Power BI and AI

  2. hr-analytics-sql-cheatsheet hr-analytics-sql-cheatsheet Public

    Reusable MySQL query library for workforce analytics: headcount, hiring, tenure, age and contract KPIs

  3. hr-headcount-excel-to-sql-csv hr-headcount-excel-to-sql-csv Public

    Python data-cleaning pipeline that converts messy HRIS Excel exports into clean, validated, SQL-ready CSVs

    Python

  4. lpd-consent-pdf-generator lpd-consent-pdf-generator Public

    Python CLI that turns Microsoft Forms responses (Excel) into personalised, print-ready GDPR consent PDFs from a Word template

    Python