MNK/portfolio
Backend & data

Data Pipeline & Integrity System

Clean attendance data from NVR logs

Engineered Python scripts to interface with Hikvision NVR systems for fetching raw logs, and designed logic filters to clean noisy camera data (duplicate records/non-attendance) for accurate HR tracking.

Problem

Raw attendance logs from Hikvision NVR cameras were noisy, with duplicate records and non-attendance events.

Approach

  1. Python scripts pull raw logs from Hikvision NVR systems
  2. Logic filters remove duplicate records and non-attendance events
  3. Cleaned data loaded into a database for HR attendance analytics
Data Pipeline & Integrity System workflow: 3 stages from input to result
Workflow

Results

  • Accurate HR attendance tracking from camera data

Stack

  • Python
  • Hikvision NVR
  • Data pipeline

By Muzammil Nawaz Khan, AI Engineer.