Summary
Designed the logic used to assess productivity impacts over time across approximately 2,200 staff during a major Salesforce/PACE transition. The methodology compared performance before, during, and after transition while accounting for demand changes, staffing/FTE, work type, channel, seasonality, outliers, training/ramp-up periods, and team/cohort differences. Outputs supported weekly executive monitoring, workforce planning, forecasting, staff management, performance management, and improvement focus for the change team.
Problem
The platform transition changed work patterns and baseline assumptions, making simple pre/post productivity comparisons misleading without a governed methodology.
My Role
Designed measurement logic, defined comparison rules, validated outputs, explained limitations, and supported recurring executive monitoring.
Approach and Methodology
- Compared before, during, and after transition performance periods.
- Controlled for demand, FTE, channel, work type, seasonality, outliers, training/ramp-up periods, and cohort differences.
- Separated methodology logic from weekly reporting packs so definitions remained stable.
- Used reporting outputs to guide support and improvement focus rather than oversimplified blame narratives.
Methodology Snapshot
Productivity Measurement Controls
This is a methodology/process visual. It is de-identified and does not contain operational data.
- 01 Baseline period
- 02 Transition period
- 03 Stabilisation period
- 04 Demand and FTE controls
- 05 Cohort comparison
- 06 Executive monitoring
Governance and Controls
- Defined productivity logic
- Cohort and period controls
- Outlier handling
- FTE and demand normalisation
- Known limitation notes
- Weekly output review
Tools and Data
- Salesforce/PACE
- SAS EG
- SAS VA
- SQL
- Snowflake
- Excel/Power Query
Outcomes
- Covered approximately 2,200 staff in productivity measurement logic.
- Supported weekly executive monitoring during transition.
- Improved workforce planning, forecasting, performance management, and change-team focus.
- Reduced risk of misleading conclusions from unstable transition baselines.
What this demonstrates
- Performance measurement design during major system change.
- Judgement in avoiding misleading productivity conclusions.
- Use of reporting to support workforce planning and transformation delivery.