All customer stories
Profitability & revenue
Appraisal and CTC cycle cut in half, with no calculation errors
A large IT company automated performance ratings and pay decisions.
About the client
- Industry
- IT services, HR
- Size
- [Revenue]
- Timeline
- [X weeks]
The challenge
The company needed an automated appraisal system. Ratings from HR and managers had to be combined into a final rating per employee, then used with each employee’s experience bracket to set their CTC.
What it meant for the team
CFO
People costs hard to plan ahead of appraisals.
Controller
Manual CTC calculations prone to error.
FP&A
No view of investment per employee per product.
How we delivered it
- Step 1[X weeks]
Advise and design
- Defined KPIs: headcount, CTC and average CTC per experience bracket
- Designed entity-level scenarios for revenue and cost growth
- Step 2[X weeks]
Build and automate
- Secure, reusable Excel templates for HR and manager inputs
- Power Query integration of ratings
- Automated final rating and CTC calculation
- Power BI reporting and REST API
- Step 3[X weeks]
Launch and embed
- [Add go-live, training and adoption details]
Total timeline: [X weeks]
Solution stack
Advisory services
- People-cost KPIs
- Scenario modeling
Data sources
- HR inputs
- Manager ratings
Storage and transformation
- Power Query
- REST API
Logic and workflow
- Rating and CTC engine
- Scenario model
Insights delivery
- Power BI
Impact
50%
fewer appraisal man-hours
50%
faster turnaround
0
errors in rating aggregation and CTC
Outcomes
- Investment tracked per employee per product
- Scenario analysis for strategic decisions and goal setting
- Scales easily to larger volumes
