Marketways built an AI agent that prepares the monthly salary file for a UAE construction group with around 800 staff, and added analytics and predictive models on absenteeism and overtime.
The business objective
The group prepared its salary file by hand every month. One or two people spent three to four days collecting attendance, timesheets, leave, allowances and deductions, checking them against each other and calculating overtime before payroll could be released. The work was slow, depended on a few individuals and left no time to look at what the numbers were saying about absence and overtime.
How Marketways translated the problem
We treated payroll preparation as a workflow with defined inputs, rules and checks, not as a spreadsheet exercise. We mapped every data source, every calculation rule (overtime rates, unpaid leave, allowances and deductions) and every point where a person needed to make a judgement.
What Marketways built
An AI agent that connects to the group’s attendance system, time-logging system, HR system and the Excel sheets used by sites and departments. The agent:
- collects and reconciles data for every employee across all sources
- applies the pay rules and calculates overtime, leave and deductions
- updates the salary file
- produces an exceptions list for anything unusual, such as missing punches, overtime above limits or incomplete records for new joiners
The payroll team reviews the exceptions and approves the file. Nothing is released without human sign-off.
Absenteeism and overtime analytics
With clean, connected data arriving every month, we analysed patterns in absence and overtime by site, project, team and season. We built predictive models that flag where absence and overtime are likely to rise, so managers can plan cover and adjust rosters before costs build up. The findings also shaped employee programmes on wellbeing and attendance.
How our engagement contributed to business impact
- Preparing the salary file now takes a fraction of the previous three to four days. Staff supervise the agent and check exceptions instead of copying and calculating data.
- Payroll no longer depends on one or two people being available.
- Absenteeism fell, and managers handle overtime with forward-looking predictions rather than month-end surprises.
Business use
Monthly payroll preparation, overtime control, absence management and workforce cost reporting.
Services and methods used
Agentic AI workflow design, human-in-the-loop controls, data integration, business rules automation, predictive modelling, Power BI dashboards, workforce analytics.
AI Agents & Automation · AI & Analytics in HR · Data Analytics & Power BI
