Case study · Finance
Web-based Fully Automated Payroll Management System
An India-based payroll and PF services provider ran on disconnected Excel spreadsheets. Chosen from 20 vendors, we built a centralised, fully automated web payroll engine on open-source J2EE.
- Client
- An India-based payroll services provider
- Duration
- 12 months
- Team size
- 6
- Disclosure
- Anonymised
Headline metrics
- 100 /min
- Pay slips processed
- 20
- Vendors evaluated
Additional context
Payroll is unforgiving. It has to be right, on time, every cycle, under regulation that keeps changing.
01 / Challenge
The problem in front of us.
Payroll ran on many disconnected Excel spreadsheets with complex formulas that needed weekly, monthly, and yearly updates. There was no centralised system, and India's intricate payroll regulations demanded specialised chartered-accountant expertise.
02 / Approach
How we set the work up.
Selected from 20 competing vendors for our J2EE expertise and domain knowledge, we deployed a six-person team, project manager, team lead, DBA, analyst, and developers, over twelve months from mid-2007.
03 / Solution
What we built.
We built a web-based, fully automated payroll system on J2EE and Struts with Hibernate for object-relational mapping, a PostgreSQL database, and Web 2.0 technologies. The platform centralises payroll processing and is accessible across platforms worldwide.
04 / Outcome
What it has held up to.
The payroll engine processes about 100 pay slips a minute. Centralisation lifted productivity, removed manual spreadsheet work, kept licensing costs at zero through open source, and protected data with encryption.
Stack
What it runs on.
- JBoss
- Apache
- J2EE
- Apache Struts
- Hibernate
- PostgreSQL
- XML
- DWR
- JavaScript
- NetBeans
Tell us what you're trying to ship.
We'll start with a two-week diagnostic. No slides, no promises we can't keep.