Client

A company looking for a solution to monitor employee activity, track work performance, and manage HR-related data.

Service Provided

Development of a comprehensive employee activity tracking system, including a standalone desktop application for real-time presence tracking and a web-based admin panel for task management and HR functionalities.

Technologies

WinForm (Desktop), MVC 5, C#, Web API 2.0, JavaScript, SQL Server 2012

Project Overview

The project consisted of two main components:

• Standalone Desktop Application: Employees could use this tool to track their login, break, meeting, and logout times. It also allowed employees to select tasks assigned by their managers, categorized by client or company.
• Web Admin Panel: This web-based application provided HR and management with the ability to create tasks, store employee details, and manage documents. Additionally, it generated detailed reports, such as employee performance metrics, annual reviews, financial summaries, and gross profit/loss reports, based on the tracked data.

A key challenge was developing the real-time tracking system, which monitored employee activity even when the user’s system was idle (sleep mode) or if the system was abruptly shut down without properly closing the application.

Challenges

• Real-time Tracking: Integrating real-time tracking through the desktop app, especially in scenarios where employees shut down their system or went into sleep mode without closing the tool, required careful design and system integration.
• API Integration: Ensuring seamless communication between the WinForm application and the web server through Web API 2.0 for real-time data updates.
• Comprehensive MIS Reporting: Generating reports for employee performance, yearly reviews, and financial summaries required complex data processing and insights.
• System Architecture: Designing a scalable, high-performance architecture for handling real-time employee data and efficient HR management.

Solution Delivered

• Standalone Desktop Application: Built using WinForm, the application allowed employees to track their workday activities in real time, including login times, breaks, and task selection. It integrated smoothly with the backend via Web API to ensure real-time data updates.
• Web-based Admin Panel: Using MVC 5 and C#, the admin panel was developed to allow HR teams to create tasks, manage employee information, and generate Management Information System (MIS) reports. This included employee performance tracking and financial reviews.
• Real-time Activity Monitoring: A robust solution was implemented to handle idle or shutdown states by continuously tracking employee activity, even when the system entered sleep mode or the application was not properly closed.
• Comprehensive Reporting: Developed MIS reports that provided insights into employee performance, annual reviews, financial summaries, and profitability, using real-time tracked data.

Roles & Responsibilities

• Project Lead: Managed the project’s development lifecycle, including design, architecture, and team coordination.
• Architected the System: Designed the database structure and system architecture to ensure scalability, security, and performance.
• Team Management: Led a team of seven members, ensuring alignment with project goals and fostering a collaborative and motivated environment.
• API and Integration: Supervised the development of APIs for seamless communication between the desktop and web applications.
• Oversight of Reporting: Guided the creation of complex reports, providing valuable insights to HR and management.

Outcome

• Successfully developed a real-time employee tracking system that captured detailed work activities, ensuring accurate and efficient time management.
• Delivered a robust HR management system that allowed for detailed task assignment, document storage, and performance tracking.
• Provided management and HR teams with comprehensive MIS reports, improving their ability to assess employee performance, conduct yearly reviews, and analyze financial data.
• The system architecture allowed for scalability and ensured that future modules or features could be easily integrated.