Mieszko PilchOperations, made better.
Menu
Back to the portfolio

Automations · three small examples

Less repetition.
More room to work.

Give routine work a reliable path, make exceptions visible, and keep people involved where judgment matters.

01Automations

Make work flow.

Let a workflow handle the routine. Give people a clear way to deal with what needs attention.

Try a source outage. See how the workflow pauses and recovers.

Career example

I used existing company APIs and scheduled jobs for data validation and external-source comparisons that had previously been checked manually.

  • REST APIs
  • Scheduled jobs
  • Python / Node.js
  • Workflow design
Read the full story

Workflow playground

Example data

One record has different values and another is missing from the external source. Four records match; two need review.

  1. 01Fetch
  2. 02Validate
  3. 03Compare
  4. 04Route
Six records. Two sources. One check.Pick a scenario and see what deserves a person’s attention.

02Automations

Match people to the work.

Give the right people the right tasks. See what happens when availability, fees or workload limits change.

Try a tight budget. Which tasks can still be covered?

Career example

I contributed to company-wide capacity planning and prioritised the shared assignment-engine redesign. Matching tasks to available workforce capacity helped identify considerable savings; the redesigned process supported doubled allocation volume without additional allocation headcount.

  • Operational design
  • Requirements
  • Prioritisation
  • Capacity planning
Read the full story

People → work

Example data

All six freelancers are available for both time slots.

Cover as many tasks as possible first. Then spread work evenly; equally balanced results favour lower total fees.

6 / 6 tasks covered€340 total costAllocation ready

09:00 — 10:00

Coverage reportReporting · 1 hour
Alex€40
Source checksValidation · 1 hour
Casey€50
Team handoverCoordination · 1 hour
Drew€60

11:00 — 12:00

Capacity reportReporting · 1 hour
Blair€55
Batch reviewValidation · 1 hour
Ellis€65
Delivery briefingCoordination · 1 hour
Frankie€70
Freelancers & workload
  • Alex€40 / task

    Reporting · Validation · Coordination

    09:00 & 11:00

    1 assigned task
  • Blair€55 / task

    Reporting

    09:00 & 11:00

    1 assigned task
  • Casey€50 / task

    Validation

    09:00 & 11:00

    1 assigned task
  • Drew€60 / task

    Coordination

    09:00 & 11:00

    1 assigned task
  • Ellis€65 / task

    Reporting · Validation

    09:00 & 11:00

    1 assigned task
  • Frankie€70 / task

    Coordination · Validation

    09:00 & 11:00

    1 assigned task

03Automations

Make every payment add up.

Bring fees, reimbursements and bonuses together. Turn source records into a file payroll can work with.

Try a month with missing inputs. What should stop the export?

Career example

I designed and built a freelancer-payroll system using internal databases. It calculated agreed fees, travel and cost reimbursements, and optional bonuses based on work quality or other agreed rates, then translated the results into SAP-readable files for payroll. The established process handled up to 6,000 freelancer payments monthly; preparation and review took approximately 10 hours per month at the mature stage.

  • Internal databases
  • Calculation rules
  • Payroll exports
  • SAP file preparation

Payroll studio

Example data

Eight assignment records, six freelancers. Agreed fees, travel records and approved costs are ready to calculate.

Assignment records 8Agreements 6Travel records 5Expense records 5
  1. 01Read sources
  2. 02Calculate
  3. 03Review
  4. 04Prepare file
Ready payees6 / 6
Held for review0
Ready subtotal$696.50
File statusPreview
October · calculated components per freelancer (USD)
FreelancerFeeTravelCostsBonusTotal
Alex MorganP01$165.00$16.50$14.00$15.00$210.50
Jamie LeeP02$65.00$0.00$0.00$0.00$65.00
Sam RiveraP03$120.00$7.50$12.50$6.00$146.00
Jordan BlakeP04$100.00$3.00$4.00$0.00$107.00
Casey ChenP05$70.00$18.00$18.00$5.00$111.00
Robin EllisP06$55.00$0.00$0.00$2.00$57.00
See the calculations and file layout

Fee = completed units × agreed fee. Travel = recorded kilometres × agreed mileage rate. Costs = approved expenses. Quality bonuses apply at or above the chosen score threshold; agreed bonuses follow their per-assignment rate. Money is rounded to cents before aggregation.

period,payee_id,currency,fees,travel_reimbursement,cost_reimbursement,bonus,total
"2026-10","P01","USD","165.00","16.50","14.00","15.00","210.50"
"2026-10","P02","USD","65.00","0.00","0.00","0.00","65.00"
"2026-10","P03","USD","120.00","7.50","12.50","6.00","146.00"
"2026-10","P04","USD","100.00","3.00","4.00","0.00","107.00"
"2026-10","P05","USD","70.00","18.00","18.00","5.00","111.00"
"2026-10","P06","USD","55.00","0.00","0.00","2.00","57.00"

The export contains one row per freelancer: fees + travel + approved costs + eligible bonuses. The file layout shown here is an example.