Skip to content
Rifaldi Radya PratamaRifaldi R.P.

All work

Work11

Two HR automations built with n8n and AI, three projects inside an enterprise HR system, three websites and a set of AI tools I use every day. Open a row for the details.

  1. Read-only SQL Server connector for ClaudeMCP server · HR demo data2026

    What it is

    A small MCP server between Claude and SQL Server. It gives Claude three read-only tools, so HR questions get answered from live data without anyone writing SQL.

    What I did

    • Built three tools: list tables, describe a table, run one SELECT.
    • Blocked writes twice: a SELECT-only database login plus a query check.
    • Added a row limit and a query timeout so one bad query cannot slow the server.
    • Logged every call: the SQL, allowed or blocked, rows, duration.
    • Generated a fictional HR database with 60 employees, attendance, leave and payroll.

    Stack

    TypeScript · Node.js · MCP · SQL Server · Docker

    Status

    Open-source demo, 2026

  2. HR Onboarding Automationn8n · Google Workspace · AI2026

    What it is

    An n8n workflow that turns one Google Form entry into a complete onboarding: welcome email, shared checklist, Day-1 meeting and an HR summary.

    What I did

    • Built the n8n workflow: Google Form and Sheet trigger, data cleanup, then Drive, Gmail and Calendar steps.
    • Used an LLM to write a personal welcome email for each hire, with a JSON check that stops the run on a bad reply.
    • Skipped blank sheet rows and read dates as serial numbers, so start dates work in any sheet locale.
    • Added a second demo: AI candidate screening that scores applications against a role rubric.
    • Published the workflows, setup guides and screenshots as a public repo anyone can import into n8n.

    Stack

    n8n · LLM API · Google Sheets · Gmail · Google Drive · Google Calendar

    Status

    Public demo, 2026

  3. AI Candidate Screeningn8n · Google Sheets · AI2026

    What it is

    An n8n workflow for recruiters and small agencies. Each application is scored 1–5 against the role's rubric in a Google Sheet, logged, and answered, with a recruiter reviewing every rejection.

    What I did

    • Built the workflow end to end: Google Form, Sheets, Gemini, Gmail.
    • Screening criteria live in a sheet tab, so recruiters change them without touching n8n.
    • Prompt judges skills only and ignores name, gender, age, religion and ethnicity.
    • The score, not the AI, picks the route, and bad AI output stops the run.
    • Rejections are saved as Gmail drafts: nothing reaches a candidate unreviewed.

    Stack

    n8n · Google Gemini · Google Sheets · Gmail · Google Forms

    Status

    Public demo, 2026

  4. AI Expense Loggern8n · Telegram · Google Sheets2026

    What it is

    A Telegram bot I use every day for my own money log. A chat message, a receipt photo or a bank screenshot becomes rows in a Google Sheet, and every entry can be undone from the chat.

    What I did

    • Split capture from processing: Apps Script stores every message, so nothing is lost while n8n is offline.
    • Used LLM structured output for text and photos, then checked account, date, amount and fees in code.
    • Added guards from real failures: an invented amount, a wrong year, a fee counted twice, unreadable screenshots.
    • Saved low-confidence entries as "needs review", with commands to list, confirm or void them.
    • Built balances, a cash correction and a monthly summary, all computed in code and never by the AI.
    • Wrote 99 unit tests and 20 message fixtures that run against the real model.

    Stack

    n8n · LLM API · Telegram Bot API · Google Sheets · Apps Script · JavaScript

    Status

    In daily use, open source, 2026

  5. HR SystemPanasonic · 13 companies2022–now

    What it is

    A legacy HRMS that 13 Panasonic group companies in Indonesia run on. Hundreds of HR and admin staff use it, and it holds the records of thousands of employees, about 2,000 at the main site alone.

    What I did

    • One of three developers on the system since November 2022.
    • Features from requirements to installation on client servers.
    • Excel mass upload for overtime and new-employee data.
    • Shift-group assignment for many employees at once.
    • End-to-end delivery for 6 of the 13 companies.
    • User training at every rollout, SOX audit documents, and mentoring interns.

    Stack

    ASP.NET Web Forms · C# · SQL Server · Azure

    Status

    Live, 2022–now

  6. Single Sign-OnPanasonic · about 200 staff2023

    What it is

    A single sign-on for the HR and internal apps, live since early 2023.

    What I did

    • Replaced four or five separate passwords with one login for about 200 staff.
    • Connected the legacy apps through query string and POST handoff, so none of them had to be rewritten.

    Stack

    ASP.NET · SQL Server

    Status

    Live since early 2023

  7. Teams ApprovalsPanasonic · proposalNot live

    What it is

    A proposal to move three-level approvals into Microsoft Teams, so managers can approve from their phone.

    What I did

    • Designed the architecture: ASP.NET API, Azure Relay and Power Automate on Microsoft Teams.
    • Projected the approval time to drop from about 57 minutes to 4.

    Stack

    ASP.NET API · Azure Relay · Power Automate

    Status

    Proposal, not live

  8. rifaldiradya.comPersonal · Next.jsLive

    What it is

    The site you're on: a portfolio with an admin panel for managing project content.

    What I did

    • Wrote the PRD and the system design document myself.
    • Built and shipped it with Next.js and AI coding tools (Claude Code).

    Stack

    Next.js · TypeScript · MySQL

    Status

    Live

  9. SwiftPayConcept · FintechWordPress

    What it is

    A concept landing page for an international money transfer startup.

    What I did

    • Built the page in WordPress.

    Stack

    Elementor · WordPress · Landing Page

    Status

    Concept

  10. Bloom StudioBali · Studio siteWordPress

    What it is

    A website for a photography and branding studio in Bali.

    What I did

    • Built the site in WordPress, with a portfolio visitors can filter.

    Stack

    WordPress · Elementor · Landing Page

    Status

    Live site

  11. AI workflow automationPersonal · LLM agents2026

    What it is

    Custom LLM agent skills with tool integrations (MCP) that I use for my own documents and studies.

    What I did

    • Filing and triage of Google Drive documents.
    • Course material turned into a searchable knowledge base.
    • Programming workflow from Planning (PRD,SDD, APP flow), until building (CI/CD, SEO, QA)))
    • Word documents formatted to a required template.

    Stack

    LLM agents · MCP · Claude Code

    Status

    Personal tools, 2026

Contact

Have a project like these?

Need an HR process automated, or a developer on your team? Send a few lines about it and I'll reply by email.