Noman Ijaz

Oracle Apex Developer

TexPak • Full time

Aug 2026 - Present • 1 mo

Developed an RFID-Based Employee Line Scanning System for a garment manufacturing environment using Oracle APEX, Oracle Database, SQL, and PL/SQL. The system automates employee identification and production-line scanning through RFID cards, replacing manual employee registration and improving workforce visibility. Key responsibilities and features: • Developed RFID-based employee identification and scanning functionality. • Integrated RFID card scanning with Oracle Database and Oracle APEX. • Implemented employee validation using unique RFID/Card IDs. • Automatically retrieved employee information after scanning. • Recorded employee scans against production lines, departments, sections, dates, and shifts. • Developed Scanned vs. Not Scanned employee tracking. • Implemented business validations for invalid or unauthorized scans. • Developed SQL queries, PL/SQL logic, database views, and APEX processes. • Created Interactive Reports and dashboards for employee scanning and workforce monitoring. • Implemented date-wise, shift-wise, employee-wise, and line-wise reporting. • Provided supervisors and management with visibility of employee attendance and line allocation. • Optimized SQL and application logic for efficient data processing and reporting. • Performed testing, troubleshooting, debugging, and production support. Business Workflow: RFID Scan → Employee Identification → Validation → Line/Section Validation → Transaction Recording → Scanning Status → Reports/Dashboard The solution reduces manual data entry, minimizes human errors, improves workforce monitoring, and provides centralized, traceable employee scanning information for production management. My Role: Oracle APEX / Oracle ERP Developer responsible for application development, SQL/PLSQL programming, business logic, validations, reporting, dashboard development, troubleshooting, optimization, and production support.

Oracle Apex Developer

Metafy • Full time

Mar 2025 - Present • 1 yr 6 mos

I have successfully designed and developed multiple enterprise-level applications using Oracle APEX, delivering scalable, secure, and user-friendly solutions tailored to business needs. Key Projects & Achievements: Complaint Management System: Built a complete end-to-end system to log, track, assign, and resolve complaints with real-time status updates, escalation workflows, and reporting dashboards. Order Management System: Developed a streamlined order processing solution with order tracking, status management, and automated workflows to improve operational efficiency. HR Management System: Created a centralized HR platform for employee records, attendance tracking, and performance monitoring with secure role-based access. Visitor Management System: Designed a digital visitor tracking system with check-in/check-out logs, security validation, and reporting features. Dashboards & KPI Monitoring: Built interactive dashboards with dynamic charts and KPI tracking to help management make data-driven decisions. What I Achieved: Delivered fully functional, production-ready applications from scratch Improved process efficiency through automation and workflow design Created responsive and user-friendly interfaces in Oracle APEX Implemented secure authentication and role-based access control Designed advanced reports and data visualizations for insights