The client
DARO SAC is a Peruvian construction company whose operating model revolves around simultaneous construction projects, each with its own staff: administrative employees, workers, civil construction workers, contractors and salespeople — each category with its own labor rules, formats and specific calculations.
The challenge
Personnel management in Peru's civil construction sector is one of the country's most complex administrative processes. It's not just about calculating a salary: you must correctly apply the general regime and the civil construction regime, manage AFP/ONP, EsSalud, SCTR, CTS, bonuses, BUC, Conafovicer, handle occupational medical exams (OME), contract renewals, vacation, daily attendance by project, bonuses and penalties, lost equipment, and ultimately issue payslips that match the official formats each authority requires — down to the cent.
DARO ran this entire cycle on spreadsheets — an option that scales poorly and where a tax or labor error can create serious contingencies.
The solution
We are building a custom HR Management System (SGP) that digitizes the full cycle: from worker registration and hiring, through attendance and intermediate processes, to payroll calculation, payslips and personnel exit.
The payroll engine replicates the general regime and the civil construction regime down to the cent, validated against the official formats the client already used. The system is also parameterizable: DARO can edit rates and concepts without technical intervention as regulations change.
Main modules
- Personnel registry: intake with step-by-step guided forms, validations, address autocomplete via map, and Excel/PDF export
- Hiring: occupational medical exams, bank accounts, document generation and upload
- Intermediate process: vacation with calendar, document/OME expiration alerts and contract renewal
- Attendance: monthly and weekly tracking by project, feeding directly into payroll
- Bonuses / Penalties / Lost equipment: income/deduction concepts with installments, integrated into payroll
- Payroll & Payslips: calculation engine for earnings, deductions and contributions across the 3 payroll types, with payslips and user-configurable parameters — calculations validated to the cent against the client's official formats
Tech stack
Backend: .NET 8 / ASP.NET Core (REST API) · Dapper (high-performance data access) · SQL Server · layered architecture (Controllers · Services · Repositories)
Frontend: React 18 + Vite · TanStack Query · React Bootstrap · react-data-table-component · react-big-calendar · jsPDF / autoTable · Google Maps / Places integration
Integrations: Google Drive (document storage) · Excel export and PDF generation · email sending
Infrastructure & DevOps
- Hosting: Windows Server on AWS EC2, published with IIS (SPA frontend and API as independent sites under subdomains)
- Database: SQL Server
- Version control: Git · GitHub (separate repositories for backend and frontend)
- CI/CD: GitHub Actions with automated IIS deployment, multi-environment flow (development / testing → production) and main branch protection
Technical highlights
- Payroll engine that replicates the general regime and the civil construction regime to the cent
- Parameterizable platform: the client edits rates and concepts without technical intervention
- Multi-environment architecture with continuous deployment
Status
Active development. Main modules running in test environment; final delivery and production rollout in progress.