Abdul Naafay

Backend Engineer | CS @ LUMS | Building high-performance systems with Node.js & SQL

Overview

Computer Science student at LUMS with a deep focus on backend architecture and data systems. From engineering ETL pipelines for 2M+ records at Systems Limited to optimizing IQueue for sub-350ms latency, I specialize in building scalable, efficient solutions. I'm driven by the challenge of turning complex data problems into seamless user experiences.

Lahore, Pakistan

Experience

Aug 2025 – May 2026

WORK

Teaching Assistant – Databases, Advanced Programming

Lahore University of Management Sciences

Lahore, Pakistan

Mentored 300+ students on SQL, backend systems, OOP, and system design. Designed assignments on REST APIs, CRUD systems, and database design; automated grading workflows.

•Mentored 300+ students on SQL, backend systems, OOP, and system design

•Designed assignments on REST APIs, CRUD systems, and database design

•Automated grading workflows

Key Achievements

→Automated grading workflows for 300+ students in Advanced Programming, reducing evaluation time to just 20 seconds per student.

→Successfully processed 1,200+ individual assessments across 2 exams and 2 assignments using custom test scripts.

→Reduced grading time by ~95% compared to manual evaluation

→Processed 1,200+ assessments for 300+ students

SQLREST APIsOOP

Sep 2025 – 2026

INTERNSHIP

AI & Data Analytics Intern

14x Solutions

Lahore, Pakistan

Developed Python-based systems processing 500k+ records monthly. Built automated workflows improving efficiency by 60%. Designed and implemented data pipelines and backend workflows. Reduced manual workload by 50% through automation.

•Developed Python-based systems processing 500k+ records monthly

•Built automated workflows improving efficiency by 60%

•Designed and implemented data pipelines and backend workflows

•Reduced manual workload by 50% through automation

Key Achievements

→Improved efficiency by 60%

→Reduced manual workload by 50%

→Processed 500k+ records monthly

Python

Jul 2025 – Sep 2025

INTERNSHIP

Data Analyst Intern

Systems Limited

Lahore, Pakistan

Engineered ETL pipelines using SSIS and SQL Server processing 2M+ records weekly. Optimized SQL queries, improving performance by 40% through indexing and query tuning. Designed scalable database schemas for 10+ systems. Developed Python scripts to automate backend data processing and validation workflows. Applied software engineering principles to build modular, scalable backend data systems.

•Engineered ETL pipelines using SSIS and SQL Server processing 2M+ records weekly

•Optimized SQL queries, improving performance by 40% through indexing and query tuning

•Designed scalable database schemas for 10+ systems

•Developed Python scripts to automate backend data processing and validation workflows

•Applied software engineering principles to build modular, scalable backend data systems

Key Achievements

→Improved performance by 40% through indexing and query tuning

→Processed 2M+ records weekly

SSISSQL ServerSQLPythonETL

Project Portfolio

PERSONAL

Present

Edulink

Full Stack Developer

Centralized the fragmented tutor discovery process at LUMS by building an e-commerce style platform. Replaced manual WhatsApp/Facebook coordination with a unified system featuring 20+ APIs, a support chatbot, and real-time messaging. Optimized backend logic to achieve a 50% improvement in onboarding efficiency.

ReactNode.jsExpressMongoDBREST APIs

Live

PERSONAL

Present

IQueue

Full Stack Developer

Built and deployed a full-stack application serving 100+ users. Engineered a real-time messaging system using WebSockets and integrated a RAG-powered service chat using FastAPI. Optimized performance to sub-350ms latency using Redis caching and managed complex backend logic with TypeScript.

ReactNode.jsExpressMongoDBRedisREST APIsDockerCI/CDWebSocketsFastAPITypeScript

Live