Software Company Management System

• Architectural Integrity: Designed and implemented a highly normalized SQL Server database from the ground up, starting with a rigorous ERD design to manage complex relationships between Employees, Departments, and Projects.

• Smart Payroll Engine: Developed advanced T-SQL logic to automate Net Salary calculations, integrating basic pay, tiered allowances, and attendance-based deductions.

• Automation & Analytics: Built automated workflows for Leave & Attendance tracking with real-time working-hour analytics using Stored Procedures and Scalar Functions.

• Role-Based Security (RBAC): Implemented tiered access security for Admin, HR, and Managers to ensure strict data confidentiality and integrity.

• Technical Documentation: Compiled full professional documentation covering all database objects, including reporting Views and complex business logic.