Your Attractive Heading

Case
Studies

01
People → System

HRMS → Lever and newcomer hub

why we changed systems

Our HRMS did not have a shared language; stages meant different things to different people, so work and data drifted. I wrote the missing docs, turned team feedback into simple rules, and once we needed posting and automation, I moved hiring into Lever with a setup the team could keep.

what I actually owned

Discovery to definitions

Interviews with TA and HMs; HRMS field dictionary, stage definitions, owners, exit criteria.

Lever setup

Pipelines, permissions, tag taxonomy, stage automations, feedback reminders, stale stage nudges.

Data and UAT

Basic data setup and safe test imports; UAT scripts; fixed edge cases before rollout.

Enablement

Short trainings and job aids; a newcomer hub to centralize processes, documents, and how-tos.

Feature list showing stages, owners, tags, automations, and newcomer hub index
Snapshot of features I proposed for HRMS enhancement.
what was messy → what I did

No mutual agreement on stages or status
Words meant different things across teams.

Name things together. I shipped a stage glossary and a field dictionary, then mapped stages to owners and exit criteria as a single source of truth.

Needed job posting and hiring automation
HRMS could not support it.

Move hiring to Lever. Lever for hiring pipelines and rules; HRMS remains the record for non hiring modules.

Cost constraints for integrations
Risk of paying for the wrong things.

Prove it first. Start manual, learn failure points, then use native Lever features or small DIY connectors only where value is clear.

Adoption friction
New tool and new habits.

Right sized enablement. Short videos, one pagers, and open office hours; the newcomer hub made know how searchable.

what changed

We spoke the same language; stages, owners, and exit criteria were clear and written down.

People knew where the work lives; hiring in Lever, other HR modules in HRMS, so handoffs were cleaner.

We built small first, then automated; this kept us inventive without unnecessary spend.

New joiners onboarded faster with the newcomer hub instead of DM links.

02
People → Data

Salary intelligence → PowerBI bands

role and context

HR Data and Ops. Salary and English level signals lived in phone screen notes. Market references were added by hand when needed. Extraction from systems was not possible, so I built a small pipeline that turned notes into a model the team could use for salary bands.

what I built

Field schema
Clear columns so notes could become rows.

role, tech stack, level, city, last company, current salary, expected salary, English proficiency.

Cleaning
Notes into a structured sheet.

Deduplication of repeated entries, align locations to one geography list, simple outlier rules, and required fields for salary columns.

Modeling
Measures that guide a conversation, not just a number.

Medians and IQR by role and level and city, variance vs target band, trend views for recent pipelines.

System
Small guardrails so quality stays.

Data dictionary, QA checks on required fields, drill through to role families, and a decision log template to record trade offs.

Salary bands dashboard with median and range highlights.
Synthetic screenshot for display. No real candidate data.
what changed

Offer talks used the same view of reality. Ranges and trade offs were visible in one place.

Variance vs band showed where we over or under paid by role and level and city.

English proficiency scarcity was clear, which helped explain search difficulty and timelines.

03
Data → Automation

Learning pipeline → n8n Automation flow

role and context

Automation Builder by n8n. Goal was to turn long English learning videos into short, structured digests for study and possible publishing. Manual transcript copy and paste was slow and inconsistent, so I designed a repeatable flow in n8n.

what I built

Why
Learning from video works, but pasting transcripts into LLMs is fragile and slow.

We needed a flow that accepts a simple URL and returns a clean digest with sections and a full text page for review.

Nodes
Five steps that always run the same way.

1) Normalize URL so later nodes accept a consistent format.
2) Parse video ID for downstream calls.
3) HTTP Request to Google APIs or a third party to fetch title and transcript.
4) JS transforms to segment content and coerce types so fields are string safe.
5) Write to Notion with structured properties and the full content body; optional draft email.

System
Make it stable and searchable.

Retry and error email, environment variables on Render, scheduled cron for batches, and a Notion database that supports filters and full text search.

flow screenshots
what changed
  • Flows run on schedule; a new video becomes a structured digest without manual steps.
  • Digests are searchable in Notion; sections are consistent so study is faster.
  • JS transforms standardize fields, which prevents broken records and failed emails.
next
  • OAuth for YouTube and Notion where possible.
  • Modular sub workflows for translation, vocabulary extraction, and quiz items.
  • Prompt tuning for richer category summaries.
04
Data → Automation

600+ supplier directory → lead magnet

research → growth ops

Value-first outreach built on a standardized supplier catalog. The directory creates proof and utility before any ask.

problem → moves

Cold emails lacked credibility
Hard to earn attention with claims only.

Lead with value. Researched and normalized 600+ entries with fields: Company, Category, City, Products, Certifications, Markets, Source. Built public views with AwesomeTable, a simple landing page, and a tracked download path.

Low follow-through from forms
Unverified addresses and weak engagement.

Automate the follow-up. Connected the form to an n8n flow that appends to Google Sheets, sends a crafted email with the asset, and tags contacts for nurture. Placement tested: below our sourcing expertise section and a clear “Get directory” button.

system

Sheets master as the single source. Monthly data hygiene and a visible privacy note.

AwesomeTable views published from the master. UTM parameters on landing and email links. Mailchimp tagging for light nurture.

results

Consistent downloads that open warm conversations with real needs.

The directory is now a reusable asset in outreach and partner intros.

artifacts
Lead magnet landing and placement on site
Lead magnet placement on site with clear “Get directory”.
Directory sample PDF preview
Directory PDF preview used in the follow-up email.
Scroll to Top