Time-Tracking App

YEAR

2025

MY ROLE

Full Stack Development

STACK USED

Python | Flask

HTML | Tailwind CSS

Javascript

MySQL

INDUSTRY

All-Purpose

View Demo ↗

Project Overview

TimeTracker delivers a comprehensive solution for team time management and absence tracking. Users can log their working hours through an intuitive interface, choosing between duration-based entry or start/end times with break tracking. Time entries can be categorized by projects, with detailed notes for activity context. The application features a robust absence management system, including vacation requests, sick leave tracking, and administrative approval workflows. The admin dashboard provides real-time visibility into team status, working hours, and planned absences, enabling better resource planning. Built with Python/Flask and MySQL for the backend with SQLAlchemy ORM, the application combines Tailwind CSS interface with JavaScript interactions for a seamless user experience.

Key Features

Timer-Based & Manual Time Logging

Track work hours through flexible input methods with options for duration or start/end times plus breaks

Associate time entries with specific projects and add detailed notes for comprehensive activity tracking

Backend Powered by Flask and SQLAlchemy

Secure user authentication system with role-based access controls for different permission levels

Optimized database schema for efficient storage and retrieval of time entries, projects, and user data

Admin Dashboard

Comprehensive overview of team status, including current work assignments and absence information

Request management system for approving vacation, sick leave, and overtime reduction requests

Real-time Notification System

Instant alerts for request approvals, rejections, and important team updates

Read/unread status tracking with options to mark notifications as read or dismiss them

Page-Based Search Functionality

Implemented search functionality using LunrJS to index and retrieve relevant pages within the application

Simple interface for finding navigation targets without requiring database queries for content

Modern Tech Stack

Backend: Python with Flask framework for robust server-side processing and route handling

Frontend: HTML with Tailwind CSS for responsive design and JavaScript for interactive elements

Database: MySQL for reliable relational data storage with SQLAlchemy ORM

Search: Client-side searching with LunrJS for efficient page indexing and retrieval

Absence Management

Integrated vacation and sick leave tracking with remaining entitlement calculations

Streamlined request and approval workflow for all types of absences

Project Gallery

Challenges Solved

Accurate Time Tracking

Implemented a flexible time entry system supporting multiple input formats (hours, minutes, decimal) with client and server-side validation to ensure data integrity

Data Aggregation for Analytics

Created optimized queries for real-time dashboard statistics, supporting dynamic filtering by date ranges, projects, and team members without performance degradation

Integrated Authentication System

Developed a secure authentication framework with password hashing, session management, and role-based permissions controlling access to sensitive administrative functions

Responsive UI Architecture

Engineered a responsive interface using Tailwind CSS and JavaScript that maintains functionality across device sizes while providing rich interactive elements like modal dialogs and dynamic forms

Cross-entity Notification System

Designed an event-driven notification system that tracks actions across different application modules and delivers targeted alerts to relevant users

Complex Form Validation

Created a comprehensive validation system for time entries that handles various time formats, overlapping entries, and ensures consistency between start/end times and durations

Project Impact

This time tracking platform demonstrates how modern web technology can streamline administrative workflows in organizations. The dashboard provides instant visibility into team availability, project time allocation, and absence planning. By automating time tracking and approval processes, the system could potentially reduce administrative overhead by 40-50% while improving data accuracy. The comprehensive reporting features would enable better resource planning, workload distribution, and billing transparency for client projects.

Check other similar projects

Room Booking Platform

This room booking platform offers a seamless online experience where users can easily search and reserve rooms. Once a booking is made, they receive an automatic notification along with a unique booking number, which allows them to manage their reservations effortlessly. Additionally, the platform features an admin dashboard that provides comprehensive tools for monitoring room availability, managing bookings, and accessing detailed analytics for efficient operations.

Portfolio Website

This portfolio website serves as a personal showcase for my technical expertise, projects, and certifications. It features a fully dynamic structure built with Flask and SQLAlchemy, enabling easy updates to content like projects, skills, and achievements. The responsive design ensures optimal viewing across all devices, while visitors can explore categorized projects, view detailed case studies, and get in touch through an integrated contact form. The admin side leverages modular Flask architecture, making the platform scalable and maintainable.

Email Signature Generator

This internal email signature generator was built with Python and Flask to streamline the process of creating consistent, branded email signatures. The web-based tool allows employees to enter or update their details through a simple form, which are then rendered into responsive HTML email templates. This eliminated the need for manual editing or technical support involvement. The system also supports updates to formatting or branding at the template level, automatically applying them across all generated signatures. It has become a self-serve productivity tool that reduces friction and ensures brand consistency in internal and external communications.

Notion API Integration

The Python-Notion Integration with Document-Merge project automates the creation of customized documents by integrating data from multiple Notion databases with a dynamic document generation system built in Python. It fetches and processes participant, event, and venue data, then merges this information into pre-formatted Word document templates using MailMerge. Custom post-processing is applied to enhance formatting, ensuring documents meet business standards while reducing manual effort.

Bank Export Automation Tool (CSV to Lexware)

This Flask-based CSV (Bank Export) Processor streamlines the transformation of exported bank transaction files into a structured accounting-ready format. The app applies custom financial classification logic to parse, categorize, and enhance transaction data—automatically generating seven additional columns, including SKR04 codes, counter-accounts, and period metadata. It produces a cleaned, enriched CSV file nearly ready for direct import into Lexware, effectively replacing manual spreadsheet work. Built with Python, Pandas, and Flask, the tool has eliminated hundreds of hours of repetitive accounting labor.

Footprint Trading Dashboard

This Dash-based trading analytics dashboard visualizes candlestick and footprint data in real-time, offering traders deep insight into buy/sell imbalances, volume deltas, and high-activity price zones. I leveraged AI-assisted coding to streamline the development process—particularly for chart rendering, database interactions, and pattern analysis. I architected the MySQL database from scratch, creating the schema, tables, and indexes optimized for time-series market data. The application fetches and processes that data efficiently and renders it using Plotly in an interactive web UI. Deployed on a self-managed Linux server, this self-hosted dashboard offers powerful, fast, and scalable insights tailored to internal trading operations.