Automating Test Data Systems for Scalable Training

Kristina Olsen

Automating Test Data Systems for Scalable Training

This project was implemented within Workday, leveraging integrations and scheduled workflows to automate the creation of test users in sandbox environments.
Goal: Create a repeatable, automated process for generating test data used by HR trainers after each sandbox refresh - ensuring consistency, accuracy, and reliability.
Team: HRIS and Training & Development
Role: Sr Systems Analyst overseeing system architecture, automation design, and documentation, applying systems-thinking to reduce manual dependency and improve team efficiency.

What this Demonstrates

This project highlights my ability to design operational systems that connection automation, communication, and trust. It reflects how I build infrastructure that scales, reduces manual effort, and improves visibility across teams—core capabilities in Digital Business Management.

THE PROBLEM

After every system refresh, HR trainers spent hours manually recreating demo employees for training sessions. The process was inconsistent, error-prone, and dependent on institutional knowledge. Trainers had no visibility into when test users would be available, leading to delays and frustration across teams.

APPROACH

I approached the issue as a systems design problem: connecting technical automation with user transparency.
Interviewed HR trainers and administrators to map their workflows and timing pain points.
Audited existing post-refresh procedures and integration schedules to identify opportunities for automation.
Defined success metrics around visibility, consistency, and reduced manual intervention.
Through discovery, it became clear that reliability mattered as much as functionality: trainers needed to trust the system, not just use it.
Configuring the Workday integration to automatically recreate demo employees after each sandbox refresh.
Configuring the Workday integration to automatically recreate demo employees after each sandbox refresh.

THE SOLUTION

I designed an automated workflow that rebuilt a complete demo employee profile on a schedule (a team of demo employees)—without manual input.
Configured recurring integrations that generated a test employee record with roles, permissions, and sample data.
Established naming conventions and documentation to ensure clarity for non-technical users.
Created notifications that informed trainers when the demo environment was ready for use.
Designed dashboard mockups for future iterations to display job status and automation logs.
High-level automation flow connecting sandbox refreshes to training readiness.
High-level automation flow connecting sandbox refreshes to training readiness.

IMPACT

The automation freed HR trainers from repetitive setup tasks and brought predictability to a once-chaotic process. Teams could begin training sessions immediately after sandbox refreshes, knowing test data would be ready and accurate. It also strengthened cross-team collaboration, since everyone shared visibility into the system timing and outcomes.

Reflection

Systems only succeed when they’re both reliable and understood. This project reminded me that clarity and transparency are as vital to system design as technical precision.
Like this project

Posted Oct 29, 2025

Built an automated system that transformed a manual, time-sensitive training process into a reliable, scalable backend operations

Blog Launch and Systems Automation
Blog Launch and Systems Automation
Helping a Vein Surgeon Build Trust and Accessibility in a New M…
Helping a Vein Surgeon Build Trust and Accessibility in a New M…
Designing for AI: Mothering Together’s Evolution
Designing for AI: Mothering Together’s Evolution
Mothering Together: Bridging the Postpartum Care Gap
Mothering Together: Bridging the Postpartum Care Gap

Join 50k+ companies and 1M+ independents

Contra Logo

© 2025 Contra.Work Inc