Help Studios — Peter Roberts

HR data, HRIS migration and People Analytics for regulated organisations.

I have gained nearly twenty years’ experience operating HR data and MI in UK financial services, at MBNA under Bank of America, Lloyds Banking Group and The Co-operative Bank, now part of Coventry Building Society. I work on HRIS migrations as part of the project team, reconcile HR and Finance numbers, build the MI and regulatory reporting that boards rely on, export the report data into Power BI, and build the models HR teams work in.

The HR Intelligence engine

In 2026 I founded Help Studios and built the HR Intelligence engine from that experience: a browser-based, privacy-by-design model that does the heavy lifting I used to do by hand, so the time goes on the insight.

See every screen of the engine
See every screen of the engineEvery screen in order, from raw exports to the Power BI report.

Services

What I do

  1. HRIS migration

    As part of your project team, from the system you are leaving to the one you are moving to: legacy data and EUCs, field and value mapping, transformation, mock loads, testing, cutover, and native reporting after go-live.

    • Legacy data and EUC audit
    • Field and value mapping, and transformation
    • Mock loads, testing and reconciliation
    • Cutover, native reporting and Manager Self-Service
    The migration, end to end
  2. HR and Finance alignment

    HR and Finance each produce a month-end pack, and the fundamental figures, FTE, headcount, joiners and leavers, need to match. Where they do not, usually because people are aligned differently, I establish why and explain every difference, so both functions can report the way they need to and the reconciliation can happen.

    • FTE, headcount, joiners and leavers reconciled
    • Every difference explained
    • FTE governance for resource committees
    How HR and Finance packs are reconciled
  3. People data and MI

    MI across the whole HR lifecycle: the story behind the numbers, native reports you can slice and drill into, and linked insight such as employee relations before leavers, absence before resignations and pay against performance. Built on the HR Intelligence engine.

    • The story behind the numbers
    • Reports you can slice and drill into
    • Thirteen lifecycle stages, linked
    • Monthly and board MI packs
    • Report data exported into Power BI
    People MI and the engine
  4. Data transformation and bespoke models

    Keep the systems you have and make the data work harder: Power BI reports, data transformation, spreadsheet models made fit, and bespoke trackers that merge into one master with the MI built in.

    • Each ER adviser's tracker merged automatically
    • Recruitment, learning and survey models
    • Spreadsheet models documented, tested and controlled
    What I build

Corporate change and transactions

When an organisation is being sold or merged, buyers will use messy workforce data to challenge operational stability and delay due diligence. I prepare the HR side of data rooms for sales and divestments, rigorously auditing and reconciling headcount and liability data so it stands up to hostile scrutiny under extreme time pressure.

Data rooms and divestments

Across all of it: I work directly with HR and Finance teams, reporting independently across the whole HR lifecycle, partnered with the relevant HR managers. Also: regulatory reporting.

Guided tour

A guided tour of the product, on real screens.

These are the real screens from the running product, on a synthetic bank called Meridian Bank. Pick a step, or use the arrow keys.

The Headlines Report for Meridian Bank: 1,299 heads and 1,274.6 FTE, absence and attrition with their status against target, and a one-sentence summary.

Step 1 of 5

Start with the answer

What does the board need to know this month?

  1. Heads and FTE, side by side 1,299 people are 1,274.6 full-time equivalents: part-time working is counted, not rounded away, and last year sits underneath.
  2. Red, amber or green against your own target The rate is judged against the target you set, not a number baked into the product, and it says so.
  3. One sentence for the board The screen writes its own summary: what needs attention, what is on target, what is for information.

Demo data — Meridian Bank, a synthetic organisation. The numbers on every step come from one run of the product.

People data and MI

MI across the whole HR lifecycle, in three ways.

  1. The story behind the numbers

    A journey insight that tells the story behind the figures, in plain sentences, so a board hears what changed and why, not only what the numbers are.

  2. Native MI you can slice and drill into

    Reports you can cut by any people attribute and drill into, to investigate the detail behind the bigger numbers: every figure opens to the people and the records behind it.

  3. Linked insight across the lifecycle

    Linking data within the lifecycle to find what single reports cannot: employee relations cases before leavers, absence before resignations, and people rated well but given a lower pay rise who left.

Export the report data into Power BI

The people MI does not stay inside the engine. The report data behind each screen can be exported into Power BI: a Power BI project built from the screen you are looking at, or a data model your own Power BI reports refresh from. Power BI renders what the engine calculated, so the numbers agree.

Power BI export

People data and MI in full

HR lifecycle

From hire to exit: where I help, and what the HR Intelligence engine covers.

Open a stage to see what I do for it as a consultant, with or without software.

Attract and recruit

Sourcing activity by department, recruiter and source, with KPIs on funnel bottlenecks and time to hire. Recruitment data also supports FTE profiling and talent planning: for roles that take a long time to recruit, attrition rates in key roles, set against average notice period, average time to accept and average time to start, show how long a gap would stay open. That gap is the business risk, and reporting it lets talent gaps be planned for before they open. Source of hire matters too, because some roles need agencies more, so agency engagement may have to be planned. As monthly reporting the figures come from each month’s exports; built as a recruitment model or tracker for the team, they update as the team works.

Onboard

Where new hires settle in: probation reviews, new-starter risk, early attrition (leavers inside their first year) and the new-hire survey. New-hire education is part of onboarding too, with surveys of its own after the education, so the experience can be refined all the time. The education measures are under Learn and develop, and the post-education survey is in the Survey Desk beside the 90-day new-starter survey.

Learn and develop

New-hire education comes first, because in many organisations it is the most important piece of learning. Financial organisations want to know when a new hire has paid for themselves: the cost of hire plus the cost of education, set against a tenure-based return, such as the person still being in the business after 90 days. I report on drop-outs from new-hire learning, first-time pass rates, and transition-team reports showing when the business accepts someone as competent for the job they were trained for. New hires have their own surveys after their education, so the programme can be refined constantly. Then development for existing staff, the performance and impact of internal educators, and mandatory training compliance.

Perform and calibrate

A year-end model that gives managers the data to make informed pay and bonus review decisions: performance ratings, absence, employee relations data such as warnings, out-of-cycle salary increases to consider, and new roles that have already accounted for a pay increase. With the rating distribution and calibration, so the pattern reflects performance and not how ratings were given.

Reward and recognise

Compa-ratio analysis, pay equity tracking, and bonus distribution modelling. Reconciles reward data against performance ratings to ensure compensation is genuinely merit-based and equitable.

Engage and listen

Joins engagement sentiment directly against attrition, absence, and performance. Exposes where high engagement masks burnout, or where low engagement serves as an early warning for turnover.

Diversity and inclusion

Demographic representation, gender and ethnicity pay gap precursors, and progression tracking. Identifies structural bottlenecks where diverse talent enters the organisation but fails to advance.

Attendance and wellbeing

Absence Management: Open absence reporting to flag unclosed records and monitor Bradford Factor triggers. Holiday & Burnout: Audits mandatory two-week continuous block leave for regulated roles, preventing year-end operational bottlenecks and unearthing burnout risk.

Employee relations and conduct

Naming culture issues, which show up as stress indicators such as grievances and absences clustering in a team. With caseload volumes, grievance timelines, time to resolve, and manager hot spots where issues repeatedly surface, so HR can intervene before formal action is needed.

Talent and succession

Bench strength and critical role cover. Identifies single points of failure where a key manager has no credible deputy within one grade step, mapping structural risk directly to the P&L. And how long it would take to backfill a role: the notice period, plus time to accept, plus time to start, with source of hire, since some roles need agencies more and agency engagement may be a requirement.

Retain

Predictive flight risk. Joins absence, pay position, performance, and engagement to surface teams statistically drifting away from the organisation, enabling intervention before they resign.

Exit

Regretted loss tracking and exit interview sentiment analysis. Maps why people are leaving against their managers, testing historical data to see the real patterns preceding a resignation.

Core HR, structure and finance

One Version of the Truth: Headcount, FTE, and establishment gaps agreed between HR and Finance. Resolves data conflicts and provides a rigorous FTE governance model the resource committee will accept.

Track record

Where I've done this

Nearly twenty years in UK financial services, on both sides of the numbers: Finance first, then HR data, reporting and analytics.

2020 – 2026

The Co-operative Bank now part of Coventry Building Society

People Analytics & Insights Manager

  • Ran HR data, reporting and analytics for the bank, owning executive and operational reporting, including the Board and Executive HR packs.
  • Part of the project team that moved RMS onto PeopleXD Core HR in 2020, delivered remotely through lockdown: mapped the data schema with the vendor, worked through the extract, transform and load, and rebuilt the legacy reports natively so MI carried on.
  • A major part of the PeopleXD to Workday migration after Coventry Building Society bought the bank, completed before I left.
  • Designed the Finance-HR reconciliation process.

2017 – 2019

Lloyds Banking Group

Analysis & Insight Consultant

  • Brought MBNA into Lloyds after the acquisition: the Workday to Workday migration, the HR reporting and analytics, and the transformation and reconciliation of MBNA's workforce data.
  • Built Excel and VBA reporting that replaced legacy third-party systems.
  • Supported the redesign of Reward systems while keeping them compliant with regulation.

2005 – 2017

MBNA under Bank of America

Finance Operations Analyst, then HR Data Insight Analyst and Senior HR Data Insight Analyst

  • Started in Finance, on performance analysis and operational reporting.
  • Workforce analytics across Talent Acquisition, Reward, Compensation and Benefits, and Employee Relations, including FTE forecasting models.
  • Analysis for a voluntary redundancy programme, and recruitment reporting redesigned.

Across these roles

  • HR and Finance, alignedResolving executive-level reporting risk by bringing HR and Finance FTE data into one agreed, reconciled position, and building robust FTE governance models for resource committees.
  • HRIS migrationsManaging data extraction, mapping, and cutover checks for migrations averaging over 3,000 people each, across Workday, Oracle, PeopleXD, ResourceLink and RMS, then engineering the native reporting so nothing is lost at go-live.
  • Corporate change and transactionsPreparing the HR side of data rooms for corporate sales and divestments, ensuring workforce data stands up to strict buyer scrutiny under extreme time pressure.

The HR Intelligence engine

The tool I bring to the work.

To do this work faster and more accurately, I designed and built my own tool: the HR Intelligence engine. It reads your HR exports in your browser, maps them to over 150 canonical fields, audits them and builds a clean history. Your data never leaves your machine: nothing is uploaded to me or anyone else.

It reads Workday, Oracle, SAP SuccessFactors, PeopleXD, ResourceLink, iTrent and other systems, and any spreadsheet. Tested against a deliberately hostile set covering 24 awkward file habits, such as odd delimiters, date formats and unpadded IDs: none was silently read wrong, and the few it could not settle itself were flagged for a person to decide.

More about the engine See every screen

About

Built for regulated environments. Designed for scrutiny.

Help Studios is led by Peter Roberts: nearly twenty years in regulated financial services HR, from operational people management to board-facing MI. The HR Intelligence engine exists because a board deserves figures it can trace, and insight it can act on.

Data never leaves your device

Processing runs entirely in the browser; Help Studios never receives your files. How the engine works.

Nearly twenty years in regulated FS

Product judgement shaped by FCA-regulated employers, not generic software patterns.

Calculation integrity

Figures are calculated from your files, each one traceable to its source. When a file is missing, the screen says so instead of showing a zero.

Signals, never decisions

Every analytical panel says the same thing: the engine surfaces signals; HR investigates.

Work with me

Available for contract and consulting work.

A role on your team, such as leading HR data and reporting or the data side of an HRIS migration, or a defined piece of work in any of the five areas above. Tell me what you need and we can talk it through.

Talk to me about your projectAbout me

Next step

Talk to me about your project

Start with the question your board keeps asking, or the data problem behind it. If the HR Intelligence engine would help, we can look at it together on anonymised extracts; you choose what to share.

This opens a draft in your own email program, addressed to Help Studios. Nothing is sent until you press send, and nothing is collected by this site.

Company
Help Studios Ltd, Wirral, UK