Community HR Onboarding: Simplifying Employee Onboarding for Small Teams

This is a submission for the DEV Weekend Challenge: Community

The Community

I built this application for small HR teams and startup communities who currently manage employee onboarding manually using Excel sheets.

In many small organizations, employee details are collected in Excel files and manually entered into systems. This workflow is time-consuming and error-prone.

**OnboardEaseMini **simplifies that process by allowing bulk employee uploads directly into a backend system via an API, saving time and reducing mistakes.

What I Built

I built an HR Onboarding API using ASP.NET Core Web API.

This application allows:

Uploading an Excel file containing employee details

Parsing the Excel file

Storing employee data in SQL Server

Retrieving the list of employees using REST endpoints

It supports bulk onboarding and demonstrates backend file processing with database integration.

Demo

You can demonstrate using:

Postman for file upload:

POST /api/Employee/upload

Retrieve employees:

GET /api/Employee

The API was tested using Postman. Employees were successfully uploaded from Excel and stored in SQL Server.

Code

GitHub Repository:
https://github.com/PratheebaAnand/community-hr-onboarding

How I Built It

Technologies used:

• ASP.NET Core Web API
• SQL Server
• Dapper (for database access)
• ClosedXML (for Excel parsing)
• Postman (for API testing)

Implementation Highlights

• Used IFormFile to handle file uploads.
• Parsed Excel files using ClosedXML.
• Stored employee records in SQL Server.
• Implemented GET endpoints to retrieve employee data.
• Handled SQL DateTime overflow issues by ensuring valid date ranges.