Hi 👋 I'm Pranav Rawat

💻 Software Developer | .NET Developer | Backend Engineer | IoT Enthusiast

I am a Software Engineer with experience in C#, .NET Core, Angular, SQL Server, and RESTful APIs. I enjoy designing and building scalable backend systems, cloud-enabled applications, and IoT-based solutions.

---

🚀 Tech Stack

Languages

Backend

Frontend

Database

Tools

---

📌 Featured Projects

🔹 Employee Leave Management System

A full-stack leave management application developed using .NET Core Web API, Angular, and SQL Server. Implements role-based access control for employees, managers, and administrators, enabling leave requests, approvals, and reporting.

🏗 System Architecture

The application follows a layered architecture to maintain separation of concerns and scalability.

Frontend Layer → Angular Application

API Layer → ASP.NET Core Web API

Business Logic Layer → Services handling validation and workflow logic

Data Access Layer → Entity Framework Core

Database → SQL Server

🔗 API Endpoints

Get All Employees

GET /api/employees

Response

{ "employeeId": 1, "name": "John Doe", "department": "IT" }

---

Apply Leave

POST /api/leaves

Request

{ "employeeId": 10, "startDate": "2026-03-10", "endDate": "2026-03-12", "reason": "Medical" }

---

Approve Leave

PUT /api/leaves/{id}/approve

✨ Features

• Role-based authentication
• Leave application workflow
• Manager approval system
• Leave history tracking
• Reporting dashboard
• API validation and exception handling

---

🔹 Employee Tracking System (Windows Forms)

A desktop employee management application built using C#, Windows Forms, ADO.NET, and SQL Server. Implements N-Tier Architecture (DAL, BLL, DTO layers) to ensure clean separation of concerns and maintainable code structure.

🏗 Architecture

The application is built using N-Tier Architecture.

Presentation Layer → Windows Forms UI

Business Logic Layer (BLL) → Handles business rules and validation

Data Access Layer (DAL) → Communicates with SQL Server

DTO Layer → Transfers structured data between layers

✨ Features

• Employee CRUD operations
• Department management
• Data validation
• SQL Server database integration
• Layered architecture implementation

---

🔹 TravelAway Web Application

A full-stack travel booking platform built using ASP.NET Core, Angular, and SQL Server. Implements 3-Tier Architecture with REST APIs to manage travel packages, bookings, and user interactions.

🏗 Application Architecture

The system follows a 3-tier architecture.

Presentation Layer → Angular Frontend

Application Layer → ASP.NET Core REST APIs

Data Layer → SQL Server Database

✨ Core Modules

• Travel Package Management
• Booking System
• User Authentication
• Search and Filter Packages
• Booking History

---

🔹 IoT Smart Street Light

An IoT-based smart street lighting system built using Arduino UNO, LDR sensor, and ESP8266 WiFi module. Integrated with the ThingSpeak cloud platform for automated lighting control and real-time monitoring.

👉 https://github.com/PranavR16/Iot-Smart-Street-Light-Arduino

⚡ Hardware Components

• Arduino UNO
• ESP8266 WiFi Module
• LDR Sensor
• LED Street Light
• Emergency Button

🔄 System Workflow

1. LDR sensor detects ambient light.
2. Arduino processes sensor input.
3. If environment is dark → street light turns ON.
4. If environment is bright → street light turns OFF.
5. Data is transmitted via ESP8266 to ThingSpeak cloud.
6. Cloud dashboard displays light and emergency status.

LDR Sensor ↓ Arduino UNO ↓ ESP8266 WiFi Module ↓ ThingSpeak Cloud ↓ Dashboard Monitoring

---

📊 GitHub Stats

---

📅 Contribution Activity

---

📈 Most Used Languages

---

🔥 GitHub Streak

---

📫 Connect With Me