Anviz Attendance Data Integration Pipeline

Project Overview

Built an integration pipeline that ingests biometric attendance logs from Anviz devices via FastAPI REST services, validates punch events, maps employee IDs, prevents duplicate punches, and persists records into PostgreSQL before synchronizing with Odoo ERP. Containerized with Docker and deployed with retry logic to ensure reliable scheduled synchronization.

The Problem

Biometric attendance records required manual export and formatting before payroll processing, resulting in missing punches, duplicate entries, and delayed HR reporting.

The Solution & Architecture

Engineered a containerized FastAPI ETL pipeline with PostgreSQL persistence and Odoo ERP API integration that automatically syncs punch records, maps employee IDs, and handles network retries.

Key Engineering Highlights